For information about overriding our macros, see here
unify_fields_query
โ
Detailsโ
Used to populate the snowplow_unified_events_this_run
table; groups together fields that come from multiple entities or SDEs depending on whether the platform is mobile or web. Should be overwritten if there is other grouping or complex SQL you wish to run on the events this run
table.
filter_bots
โ
Argumentsโ
table_alias
: The table alias to prefix a the column name with, if any. Defaultnone
Detailsโ
Defines the filter to remove bot events from events processed by the package. Of the form and <condition>
. Used throughout the package to filter out bots from all models.
channel_group_query
โ
Detailsโ
Defines the channel a user arrived at using various fields, populates the default_channel_group
field in the views
and sessions
tables. Must be a valid sql select
object e.g. a complete case when
statement. Used as part of the platform_independent_fields
macro.
engaged_session
โ
Detailsโ
Defines if a session was engaged or not, populates the is_engaged
field. Must return true
or false
and be a valid sql select
object e.g. a complete case when
statement. Used in sessions_this_run
table. Default at least 2 views, or at engaged time of at least 2 heartbeats, or had a conversion event.
content_group_query
โ
Detailsโ
Defines the content groups by classifying the page urls for views. Must be a valid sql select
object e.g. a complete case when
statement. Used in views_this_run
table.