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.