Add support for new Snowplow media event and entity schemas on Web and mobile #49
Labels
status:needs_triage
Needs maintainer triage.
Comments
matus-tomlein
added a commit
that referenced
this issue
Sep 4, 2023
…d mobile (close #49) Minor changes based on review Use snowplow_utils.get_field macro from the field macro Correct table aliases in macro docs Add comments for event type field Select all properties from atomic table in base events Change in to equals when comparing event type Rename _X_percent_reached columns to percent_reached_X Change var snowplow__events to snowplow__events_table in src_base.yml Avoid having only one argument in coalesce in macros Fix coalesce in a few more macros Disable mobile events and ad quartile events by default Select all columns from atomic table in bigquery, postgres, snowflake Fix subquery for snowflake Add sort, dist and cluster_by config to base_sessions_lifecycle manifest Unify macros to not add aliases Rename session_id to session_identifier Mention that play time counts rewatched content in docs Protect access to properties in optional contexts and improve docs Add check for at least one media player context Disable media_ad_views and media_ads in case media ad context is disabled Add session_identifier to media_ad_views Add a note in column documentation that several properties will be null if the media session entity is not available Handle cases when the table is empty during incremental run in media_stats
matus-tomlein
added a commit
that referenced
this issue
Sep 4, 2023
…d mobile (close #49) Minor changes based on review Use snowplow_utils.get_field macro from the field macro Correct table aliases in macro docs Add comments for event type field Select all properties from atomic table in base events Change in to equals when comparing event type Rename _X_percent_reached columns to percent_reached_X Change var snowplow__events to snowplow__events_table in src_base.yml Avoid having only one argument in coalesce in macros Fix coalesce in a few more macros Disable mobile events and ad quartile events by default Select all columns from atomic table in bigquery, postgres, snowflake Fix subquery for snowflake Add sort, dist and cluster_by config to base_sessions_lifecycle manifest Unify macros to not add aliases Rename session_id to session_identifier Mention that play time counts rewatched content in docs Protect access to properties in optional contexts and improve docs Add check for at least one media player context Disable media_ad_views and media_ads in case media ad context is disabled Add session_identifier to media_ad_views Add a note in column documentation that several properties will be null if the media session entity is not available Handle cases when the table is empty during incremental run in media_stats
matus-tomlein
added a commit
that referenced
this issue
Sep 20, 2023
…d mobile (close #49) Minor changes based on review Use snowplow_utils.get_field macro from the field macro Correct table aliases in macro docs Add comments for event type field Select all properties from atomic table in base events Change in to equals when comparing event type Rename _X_percent_reached columns to percent_reached_X Change var snowplow__events to snowplow__events_table in src_base.yml Avoid having only one argument in coalesce in macros Fix coalesce in a few more macros Disable mobile events and ad quartile events by default Select all columns from atomic table in bigquery, postgres, snowflake Fix subquery for snowflake Add sort, dist and cluster_by config to base_sessions_lifecycle manifest Unify macros to not add aliases Rename session_id to session_identifier Mention that play time counts rewatched content in docs Protect access to properties in optional contexts and improve docs Add check for at least one media player context Disable media_ad_views and media_ads in case media ad context is disabled Add session_identifier to media_ad_views Add a note in column documentation that several properties will be null if the media session entity is not available Handle cases when the table is empty during incremental run in media_stats Use the timestamp of the first ad event regardless of it's type for viewed_at in ad views and add a test for not null
2 tasks
matus-tomlein
added a commit
that referenced
this issue
Sep 20, 2023
…d mobile (close #49) Minor changes based on review Use snowplow_utils.get_field macro from the field macro Correct table aliases in macro docs Add comments for event type field Select all properties from atomic table in base events Change in to equals when comparing event type Rename _X_percent_reached columns to percent_reached_X Change var snowplow__events to snowplow__events_table in src_base.yml Avoid having only one argument in coalesce in macros Fix coalesce in a few more macros Disable mobile events and ad quartile events by default Select all columns from atomic table in bigquery, postgres, snowflake Fix subquery for snowflake Add sort, dist and cluster_by config to base_sessions_lifecycle manifest Unify macros to not add aliases Rename session_id to session_identifier Mention that play time counts rewatched content in docs Protect access to properties in optional contexts and improve docs Add check for at least one media player context Disable media_ad_views and media_ads in case media ad context is disabled Add session_identifier to media_ad_views Add a note in column documentation that several properties will be null if the media session entity is not available Handle cases when the table is empty during incremental run in media_stats Use the timestamp of the first ad event regardless of it's type for viewed_at in ad views and add a test for not null
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Add support for the new media schemas tracked using the Snowplow media plugin on Web or using the media APIs on the iOS and Android trackers.
The text was updated successfully, but these errors were encountered: