Media playback events

Snowplow provides a complete solution for tracking events from media (video or audio) playback and for modeling the tracked data.

This page gives an overview of the tracked data (consisting of self-describing events and context entities) and points to resources for setting up tracking using our Web and mobile trackers and modeling using our dbt package.

Events
Context entities
How to track?
Modeled data using the snowplow-media-player dbt package

Older (version 1) media event and context entity schemas

This page describes events and entities in the newer, version 2, schemas for media events and context entities. In case you are using the HTML5 and YouTube plugins for the JavaScript tracker, you may still be using the older schemas. These are still supported and work with our dbt media package. However, they provide less information (e.g, no ad tracking) and less accurate playback metrics (which are estimated based on percentage progress boundaries).

They consist of the following events and context entities:

media-player event schema used for all media events.
media-player context v1 schema.
Depending on the plugin / intention there are player-specific contexts:
- in case of embedded YouTube tracking: Have the YouTube specific context schema enabled.
- in case of HTML5 audio or video tracking: Have the HTML5 media element context schema enabled.
- in case of HTML5 video tracking: Have the HTML5 video element context schema enabled.

Events

Playback events

Buffer end event

Event: buffer_end_event

Media player event fired when the the player finishes buffering content and resumes playback.

Schema URI:iglu:com.snowplowanalytics.snowplow.media/buffer_end_event/jsonschema/1-0-0

Web	Mobile	Tracked automatically
✅	✅	Depends on the tracker used

👀 Example

{}

📃 Schema properties definition

Table
JSON schema

Property	Type	Description	Required?

{
  "$schema": "http://iglucentral.com/schemas/com.snowplowanalytics.self-desc/schema/jsonschema/1-0-0#",
  "description": "Media player event fired when the the player finishes buffering content and resumes playback.",
  "self": {
    "vendor": "com.snowplowanalytics.snowplow.media",
    "name": "buffer_end_event",
    "format": "jsonschema",
    "version": "1-0-0"
  },
  "type": "object",
  "properties": {},
  "additionalProperties": false
}

❓ How to query the event in the warehouse?

Snowflake
BigQuery
Databricks
Redshift & Postgres

select
  unstruct_event_com_snowplowanalytics_snowplow_media_buffer_end_event_1 buffer_end_event_1
from
  atomic.events
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'buffer_end_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_buffer_end_event_1_0_0
from
  PIPELINE_NAME.events events
where
  events.collector_tstamp > timestamp_sub(current_timestamp(), interval 1 hour)
  and events.event = 'unstruct'
  and events.event_name = 'buffer_end_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_buffer_end_event_1
from
  atomic.events events
where
  events.collector_tstamp > timestampadd(HOUR, -1, current_timestamp())
  and events.event = 'unstruct'
  and events.event_name = 'buffer_end_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'
  and unstruct_event_com_snowplowanalytics_snowplow_media_buffer_end_event_1 is not null

select
  "buffer_end_event_1".*
from
  atomic.events events
  join atomic.com_snowplowanalytics_snowplow_media_buffer_end_event_1 "buffer_end_event_1"
    on "buffer_end_event_1".root_id = events.event_id and "buffer_end_event_1".root_tstamp = events.collector_tstamp
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and "buffer_end_event_1".root_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'buffer_end_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

Buffer start event

Event: buffer_start_event

Media player event fired when the player goes into the buffering state and begins to buffer content.

Schema URI:iglu:com.snowplowanalytics.snowplow.media/buffer_start_event/jsonschema/1-0-0

Web	Mobile	Tracked automatically
✅	✅	Depends on the tracker used

👀 Example

{}

📃 Schema properties definition

Table
JSON schema

Property	Type	Description	Required?

{
  "$schema": "http://iglucentral.com/schemas/com.snowplowanalytics.self-desc/schema/jsonschema/1-0-0#",
  "description": "Media player event fired when the player goes into the buffering state and begins to buffer content.",
  "self": {
    "vendor": "com.snowplowanalytics.snowplow.media",
    "name": "buffer_start_event",
    "format": "jsonschema",
    "version": "1-0-0"
  },
  "type": "object",
  "properties": {},
  "additionalProperties": false
}

❓ How to query the event in the warehouse?

Snowflake
BigQuery
Databricks
Redshift & Postgres

select
  unstruct_event_com_snowplowanalytics_snowplow_media_buffer_start_event_1 buffer_start_event_1
from
  atomic.events
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'buffer_start_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_buffer_start_event_1_0_0
from
  PIPELINE_NAME.events events
where
  events.collector_tstamp > timestamp_sub(current_timestamp(), interval 1 hour)
  and events.event = 'unstruct'
  and events.event_name = 'buffer_start_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_buffer_start_event_1
from
  atomic.events events
where
  events.collector_tstamp > timestampadd(HOUR, -1, current_timestamp())
  and events.event = 'unstruct'
  and events.event_name = 'buffer_start_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'
  and unstruct_event_com_snowplowanalytics_snowplow_media_buffer_start_event_1 is not null

select
  "buffer_start_event_1".*
from
  atomic.events events
  join atomic.com_snowplowanalytics_snowplow_media_buffer_start_event_1 "buffer_start_event_1"
    on "buffer_start_event_1".root_id = events.event_id and "buffer_start_event_1".root_tstamp = events.collector_tstamp
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and "buffer_start_event_1".root_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'buffer_start_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

Pause event

Event: pause_event

Media player event sent when the user pauses the playback.

Schema URI:iglu:com.snowplowanalytics.snowplow.media/pause_event/jsonschema/1-0-0

Web	Mobile	Tracked automatically
✅	✅	Depends on the tracker used

👀 Example

{}

📃 Schema properties definition

Table
JSON schema

Property	Type	Description	Required?

{
  "$schema": "http://iglucentral.com/schemas/com.snowplowanalytics.self-desc/schema/jsonschema/1-0-0#",
  "description": "Media player event sent when the user pauses the playback.",
  "self": {
    "vendor": "com.snowplowanalytics.snowplow.media",
    "name": "pause_event",
    "format": "jsonschema",
    "version": "1-0-0"
  },
  "type": "object",
  "properties": {},
  "additionalProperties": false
}

❓ How to query the event in the warehouse?

Snowflake
BigQuery
Databricks
Redshift & Postgres

select
  unstruct_event_com_snowplowanalytics_snowplow_media_pause_event_1 pause_event_1
from
  atomic.events
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'pause_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_pause_event_1_0_0
from
  PIPELINE_NAME.events events
where
  events.collector_tstamp > timestamp_sub(current_timestamp(), interval 1 hour)
  and events.event = 'unstruct'
  and events.event_name = 'pause_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_pause_event_1
from
  atomic.events events
where
  events.collector_tstamp > timestampadd(HOUR, -1, current_timestamp())
  and events.event = 'unstruct'
  and events.event_name = 'pause_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'
  and unstruct_event_com_snowplowanalytics_snowplow_media_pause_event_1 is not null

select
  "pause_event_1".*
from
  atomic.events events
  join atomic.com_snowplowanalytics_snowplow_media_pause_event_1 "pause_event_1"
    on "pause_event_1".root_id = events.event_id and "pause_event_1".root_tstamp = events.collector_tstamp
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and "pause_event_1".root_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'pause_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

Playback end event

Event: end_event

Media player event sent when playback stops when end of the media is reached or because no further data is available.

Schema URI:iglu:com.snowplowanalytics.snowplow.media/end_event/jsonschema/1-0-0

Web	Mobile	Tracked automatically
✅	✅	Depends on the tracker used

👀 Example

{}

📃 Schema properties definition

Table
JSON schema

Property	Type	Description	Required?

{
  "$schema": "http://iglucentral.com/schemas/com.snowplowanalytics.self-desc/schema/jsonschema/1-0-0#",
  "description": "Media player event sent when playback stops when end of the media is reached or because no further data is available.",
  "self": {
    "vendor": "com.snowplowanalytics.snowplow.media",
    "name": "end_event",
    "format": "jsonschema",
    "version": "1-0-0"
  },
  "type": "object",
  "properties": {},
  "additionalProperties": false
}

❓ How to query the event in the warehouse?

Snowflake
BigQuery
Databricks
Redshift & Postgres

select
  unstruct_event_com_snowplowanalytics_snowplow_media_end_event_1 end_event_1
from
  atomic.events
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'end_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_end_event_1_0_0
from
  PIPELINE_NAME.events events
where
  events.collector_tstamp > timestamp_sub(current_timestamp(), interval 1 hour)
  and events.event = 'unstruct'
  and events.event_name = 'end_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_end_event_1
from
  atomic.events events
where
  events.collector_tstamp > timestampadd(HOUR, -1, current_timestamp())
  and events.event = 'unstruct'
  and events.event_name = 'end_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'
  and unstruct_event_com_snowplowanalytics_snowplow_media_end_event_1 is not null

select
  "end_event_1".*
from
  atomic.events events
  join atomic.com_snowplowanalytics_snowplow_media_end_event_1 "end_event_1"
    on "end_event_1".root_id = events.event_id and "end_event_1".root_tstamp = events.collector_tstamp
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and "end_event_1".root_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'end_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

Percent progress event

Event: percent_progress_event

Media player event fired when a percentage boundary set in tracking options is reached

Schema URI:iglu:com.snowplowanalytics.snowplow.media/percent_progress_event/jsonschema/1-0-0

Web	Mobile	Tracked automatically
✅	✅	Depends on the tracker used

👀 Example

{}

📃 Schema properties definition

Table
JSON schema

Property	Type	Description	Required?
`percentProgress`	`["integer","null"]`	The percent of the way through the media	❌

{
  "$schema": "http://iglucentral.com/schemas/com.snowplowanalytics.self-desc/schema/jsonschema/1-0-0#",
  "description": "Media player event fired when a percentage boundary set in tracking options is reached",
  "self": {
    "vendor": "com.snowplowanalytics.snowplow.media",
    "name": "percent_progress_event",
    "format": "jsonschema",
    "version": "1-0-0"
  },
  "type": "object",
  "properties": {
    "percentProgress": {
      "type": [
        "integer",
        "null"
      ],
      "description": "The percent of the way through the media",
      "minimum": 0,
      "maximum": 100
    }
  },
  "additionalProperties": false
}

❓ How to query the event in the warehouse?

Snowflake
BigQuery
Databricks
Redshift & Postgres

select
  unstruct_event_com_snowplowanalytics_snowplow_media_percent_progress_event_1 percent_progress_event_1
from
  atomic.events
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'percent_progress_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_percent_progress_event_1_0_0
from
  PIPELINE_NAME.events events
where
  events.collector_tstamp > timestamp_sub(current_timestamp(), interval 1 hour)
  and events.event = 'unstruct'
  and events.event_name = 'percent_progress_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_percent_progress_event_1
from
  atomic.events events
where
  events.collector_tstamp > timestampadd(HOUR, -1, current_timestamp())
  and events.event = 'unstruct'
  and events.event_name = 'percent_progress_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'
  and unstruct_event_com_snowplowanalytics_snowplow_media_percent_progress_event_1 is not null

select
  "percent_progress_event_1".*
from
  atomic.events events
  join atomic.com_snowplowanalytics_snowplow_media_percent_progress_event_1 "percent_progress_event_1"
    on "percent_progress_event_1".root_id = events.event_id and "percent_progress_event_1".root_tstamp = events.collector_tstamp
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and "percent_progress_event_1".root_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'percent_progress_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

Media ping event

Event: ping_event

Media player event fired periodically during main content playback, regardless of other API events that have been sent.

Schema URI:iglu:com.snowplowanalytics.snowplow.media/ping_event/jsonschema/1-0-0

Web	Mobile	Tracked automatically
✅	✅	Depends on the tracker used

👀 Example

{}

📃 Schema properties definition

Table
JSON schema

Property	Type	Description	Required?

{
  "$schema": "http://iglucentral.com/schemas/com.snowplowanalytics.self-desc/schema/jsonschema/1-0-0#",
  "description": "Media player event fired periodically during main content playback, regardless of other API events that have been sent.",
  "self": {
    "vendor": "com.snowplowanalytics.snowplow.media",
    "name": "ping_event",
    "format": "jsonschema",
    "version": "1-0-0"
  },
  "type": "object",
  "properties": {},
  "additionalProperties": false
}

❓ How to query the event in the warehouse?

Snowflake
BigQuery
Databricks
Redshift & Postgres

select
  unstruct_event_com_snowplowanalytics_snowplow_media_ping_event_1 ping_event_1
from
  atomic.events
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'ping_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_ping_event_1_0_0
from
  PIPELINE_NAME.events events
where
  events.collector_tstamp > timestamp_sub(current_timestamp(), interval 1 hour)
  and events.event = 'unstruct'
  and events.event_name = 'ping_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_ping_event_1
from
  atomic.events events
where
  events.collector_tstamp > timestampadd(HOUR, -1, current_timestamp())
  and events.event = 'unstruct'
  and events.event_name = 'ping_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'
  and unstruct_event_com_snowplowanalytics_snowplow_media_ping_event_1 is not null

select
  "ping_event_1".*
from
  atomic.events events
  join atomic.com_snowplowanalytics_snowplow_media_ping_event_1 "ping_event_1"
    on "ping_event_1".root_id = events.event_id and "ping_event_1".root_tstamp = events.collector_tstamp
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and "ping_event_1".root_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'ping_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

Play event

Event: play_event

Media player event sent when the player changes state to playing from previously being paused.

Schema URI:iglu:com.snowplowanalytics.snowplow.media/play_event/jsonschema/1-0-0

Web	Mobile	Tracked automatically
✅	✅	Depends on the tracker used

👀 Example

{}

📃 Schema properties definition

Table
JSON schema

Property	Type	Description	Required?

{
  "$schema": "http://iglucentral.com/schemas/com.snowplowanalytics.self-desc/schema/jsonschema/1-0-0#",
  "description": "Media player event sent when the player changes state to playing from previously being paused.",
  "self": {
    "vendor": "com.snowplowanalytics.snowplow.media",
    "name": "play_event",
    "format": "jsonschema",
    "version": "1-0-0"
  },
  "type": "object",
  "properties": {},
  "additionalProperties": false
}

❓ How to query the event in the warehouse?

Snowflake
BigQuery
Databricks
Redshift & Postgres

select
  unstruct_event_com_snowplowanalytics_snowplow_media_play_event_1 play_event_1
from
  atomic.events
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'play_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_play_event_1_0_0
from
  PIPELINE_NAME.events events
where
  events.collector_tstamp > timestamp_sub(current_timestamp(), interval 1 hour)
  and events.event = 'unstruct'
  and events.event_name = 'play_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_play_event_1
from
  atomic.events events
where
  events.collector_tstamp > timestampadd(HOUR, -1, current_timestamp())
  and events.event = 'unstruct'
  and events.event_name = 'play_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'
  and unstruct_event_com_snowplowanalytics_snowplow_media_play_event_1 is not null

select
  "play_event_1".*
from
  atomic.events events
  join atomic.com_snowplowanalytics_snowplow_media_play_event_1 "play_event_1"
    on "play_event_1".root_id = events.event_id and "play_event_1".root_tstamp = events.collector_tstamp
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and "play_event_1".root_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'play_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

Seek end event

Event: seek_end_event

Media player event sent when a seek operation completes.

Schema URI:iglu:com.snowplowanalytics.snowplow.media/seek_end_event/jsonschema/1-0-0

Web	Mobile	Tracked automatically
✅	✅	Depends on the tracker used

👀 Example

{}

📃 Schema properties definition

Table
JSON schema

Property	Type	Description	Required?

{
  "$schema": "http://iglucentral.com/schemas/com.snowplowanalytics.self-desc/schema/jsonschema/1-0-0#",
  "description": "Media player event sent when a seek operation completes.",
  "self": {
    "vendor": "com.snowplowanalytics.snowplow.media",
    "name": "seek_end_event",
    "format": "jsonschema",
    "version": "1-0-0"
  },
  "type": "object",
  "properties": {},
  "additionalProperties": false
}

❓ How to query the event in the warehouse?

Snowflake
BigQuery
Databricks
Redshift & Postgres

select
  unstruct_event_com_snowplowanalytics_snowplow_media_seek_end_event_1 seek_end_event_1
from
  atomic.events
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'seek_end_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_seek_end_event_1_0_0
from
  PIPELINE_NAME.events events
where
  events.collector_tstamp > timestamp_sub(current_timestamp(), interval 1 hour)
  and events.event = 'unstruct'
  and events.event_name = 'seek_end_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_seek_end_event_1
from
  atomic.events events
where
  events.collector_tstamp > timestampadd(HOUR, -1, current_timestamp())
  and events.event = 'unstruct'
  and events.event_name = 'seek_end_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'
  and unstruct_event_com_snowplowanalytics_snowplow_media_seek_end_event_1 is not null

select
  "seek_end_event_1".*
from
  atomic.events events
  join atomic.com_snowplowanalytics_snowplow_media_seek_end_event_1 "seek_end_event_1"
    on "seek_end_event_1".root_id = events.event_id and "seek_end_event_1".root_tstamp = events.collector_tstamp
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and "seek_end_event_1".root_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'seek_end_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

Seek start event

Event: seek_start_event

Media player event sent when a seek operation begins.

Schema URI:iglu:com.snowplowanalytics.snowplow.media/seek_start_event/jsonschema/1-0-0

Web	Mobile	Tracked automatically
✅	✅	Depends on the tracker used

👀 Example

{}

📃 Schema properties definition

Table
JSON schema

Property	Type	Description	Required?

{
  "$schema": "http://iglucentral.com/schemas/com.snowplowanalytics.self-desc/schema/jsonschema/1-0-0#",
  "description": "Media player event sent when a seek operation begins.",
  "self": {
    "vendor": "com.snowplowanalytics.snowplow.media",
    "name": "seek_start_event",
    "format": "jsonschema",
    "version": "1-0-0"
  },
  "type": "object",
  "properties": {},
  "additionalProperties": false
}

❓ How to query the event in the warehouse?

Snowflake
BigQuery
Databricks
Redshift & Postgres

select
  unstruct_event_com_snowplowanalytics_snowplow_media_seek_start_event_1 seek_start_event_1
from
  atomic.events
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'seek_start_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_seek_start_event_1_0_0
from
  PIPELINE_NAME.events events
where
  events.collector_tstamp > timestamp_sub(current_timestamp(), interval 1 hour)
  and events.event = 'unstruct'
  and events.event_name = 'seek_start_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_seek_start_event_1
from
  atomic.events events
where
  events.collector_tstamp > timestampadd(HOUR, -1, current_timestamp())
  and events.event = 'unstruct'
  and events.event_name = 'seek_start_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'
  and unstruct_event_com_snowplowanalytics_snowplow_media_seek_start_event_1 is not null

select
  "seek_start_event_1".*
from
  atomic.events events
  join atomic.com_snowplowanalytics_snowplow_media_seek_start_event_1 "seek_start_event_1"
    on "seek_start_event_1".root_id = events.event_id and "seek_start_event_1".root_tstamp = events.collector_tstamp
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and "seek_start_event_1".root_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'seek_start_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

Player events

Error event

Event: error_event

Media player event tracked when the resource could not be loaded due to an error.

Schema URI:iglu:com.snowplowanalytics.snowplow.media/error_event/jsonschema/1-0-0

Web	Mobile	Tracked automatically
✅	✅	Depends on the tracker used

👀 Example

{
  "errorCode": "E522",
  "errorName": "forbidden",
  "errorDescription": "Playback failed"
}

📃 Schema properties definition

Table
JSON schema

Property	Type	Description	Required?
`errorCode`	`["string","null"]`	Error-identifying code for the playback issue. E.g. E522	❌
`errorName`	`["string","null"]`	Name for the type of error that occurred in the playback. E.g. forbidden	❌
`errorDescription`	`["string","null"]`	Longer description for the error that occurred in the playback.	❌

{
  "$schema": "http://iglucentral.com/schemas/com.snowplowanalytics.self-desc/schema/jsonschema/1-0-0#",
  "description": "Media player event tracked when the resource could not be loaded due to an error.",
  "self": {
    "vendor": "com.snowplowanalytics.snowplow.media",
    "name": "error_event",
    "format": "jsonschema",
    "version": "1-0-0"
  },
  "type": "object",
  "properties": {
    "errorCode": {
      "type": [
        "string",
        "null"
      ],
      "description": "Error-identifying code for the playback issue. E.g. E522",
      "maxLength": 256
    },
    "errorName": {
      "type": [
        "string",
        "null"
      ],
      "description": "Name for the type of error that occurred in the playback. E.g. forbidden",
      "maxLength": 256
    },
    "errorDescription": {
      "type": [
        "string",
        "null"
      ],
      "description": "Longer description for the error that occurred in the playback.",
      "maxLength": 4096
    }
  },
  "additionalProperties": false
}

❓ How to query the event in the warehouse?

Snowflake
BigQuery
Databricks
Redshift & Postgres

select
  unstruct_event_com_snowplowanalytics_snowplow_media_error_event_1 error_event_1
from
  atomic.events
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'error_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_error_event_1_0_0
from
  PIPELINE_NAME.events events
where
  events.collector_tstamp > timestamp_sub(current_timestamp(), interval 1 hour)
  and events.event = 'unstruct'
  and events.event_name = 'error_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_error_event_1
from
  atomic.events events
where
  events.collector_tstamp > timestampadd(HOUR, -1, current_timestamp())
  and events.event = 'unstruct'
  and events.event_name = 'error_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'
  and unstruct_event_com_snowplowanalytics_snowplow_media_error_event_1 is not null

select
  "error_event_1".*
from
  atomic.events events
  join atomic.com_snowplowanalytics_snowplow_media_error_event_1 "error_event_1"
    on "error_event_1".root_id = events.event_id and "error_event_1".root_tstamp = events.collector_tstamp
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and "error_event_1".root_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'error_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

Fullscreen change event

Event: fullscreen_change_event

Media player event fired immediately after the browser switches into or out of full-screen mode.

Schema URI:iglu:com.snowplowanalytics.snowplow.media/fullscreen_change_event/jsonschema/1-0-0

Web	Mobile	Tracked automatically
✅	✅	Depends on the tracker used

👀 Example

{
  "fullscreen": true
}

📃 Schema properties definition

Table
JSON schema

Property	Type	Description	Required?
`fullscreen`	`"boolean"`	Whether the video element is fullscreen after the change	✅

{
  "$schema": "http://iglucentral.com/schemas/com.snowplowanalytics.self-desc/schema/jsonschema/1-0-0#",
  "description": "Media player event fired immediately after the browser switches into or out of full-screen mode.",
  "self": {
    "vendor": "com.snowplowanalytics.snowplow.media",
    "name": "fullscreen_change_event",
    "format": "jsonschema",
    "version": "1-0-0"
  },
  "type": "object",
  "properties": {
    "fullscreen": {
      "type": "boolean",
      "description": "Whether the video element is fullscreen after the change"
    }
  },
  "required": [
    "fullscreen"
  ],
  "additionalProperties": false
}

❓ How to query the event in the warehouse?

Snowflake
BigQuery
Databricks
Redshift & Postgres

select
  unstruct_event_com_snowplowanalytics_snowplow_media_fullscreen_change_event_1 fullscreen_change_event_1
from
  atomic.events
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'fullscreen_change_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_fullscreen_change_event_1_0_0
from
  PIPELINE_NAME.events events
where
  events.collector_tstamp > timestamp_sub(current_timestamp(), interval 1 hour)
  and events.event = 'unstruct'
  and events.event_name = 'fullscreen_change_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_fullscreen_change_event_1
from
  atomic.events events
where
  events.collector_tstamp > timestampadd(HOUR, -1, current_timestamp())
  and events.event = 'unstruct'
  and events.event_name = 'fullscreen_change_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'
  and unstruct_event_com_snowplowanalytics_snowplow_media_fullscreen_change_event_1 is not null

select
  "fullscreen_change_event_1".*
from
  atomic.events events
  join atomic.com_snowplowanalytics_snowplow_media_fullscreen_change_event_1 "fullscreen_change_event_1"
    on "fullscreen_change_event_1".root_id = events.event_id and "fullscreen_change_event_1".root_tstamp = events.collector_tstamp
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and "fullscreen_change_event_1".root_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'fullscreen_change_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

Picture-in-picture change event

Event: picture_in_picture_change_event

Media player event fired immediately after the browser switches into or out of picture-in-picture mode.

Schema URI:iglu:com.snowplowanalytics.snowplow.media/picture_in_picture_change_event/jsonschema/1-0-0

Web	Mobile	Tracked automatically
✅	✅	Depends on the tracker used

👀 Example

{
  "pictureInPicture": true
}

📃 Schema properties definition

Table
JSON schema

Property	Type	Description	Required?
`pictureInPicture`	`"boolean"`	Whether the video element is showing picture-in-picture after the change.	✅

{
  "$schema": "http://iglucentral.com/schemas/com.snowplowanalytics.self-desc/schema/jsonschema/1-0-0#",
  "description": "Media player event fired immediately after the browser switches into or out of picture-in-picture mode.",
  "self": {
    "vendor": "com.snowplowanalytics.snowplow.media",
    "name": "picture_in_picture_change_event",
    "format": "jsonschema",
    "version": "1-0-0"
  },
  "type": "object",
  "properties": {
    "pictureInPicture": {
      "type": "boolean",
      "description": "Whether the video element is showing picture-in-picture after the change."
    }
  },
  "required": [
    "pictureInPicture"
  ],
  "additionalProperties": false
}

❓ How to query the event in the warehouse?

Snowflake
BigQuery
Databricks
Redshift & Postgres

select
  unstruct_event_com_snowplowanalytics_snowplow_media_picture_in_picture_change_event_1 picture_in_picture_change_event_1
from
  atomic.events
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'picture_in_picture_change_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_picture_in_picture_change_event_1_0_0
from
  PIPELINE_NAME.events events
where
  events.collector_tstamp > timestamp_sub(current_timestamp(), interval 1 hour)
  and events.event = 'unstruct'
  and events.event_name = 'picture_in_picture_change_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_picture_in_picture_change_event_1
from
  atomic.events events
where
  events.collector_tstamp > timestampadd(HOUR, -1, current_timestamp())
  and events.event = 'unstruct'
  and events.event_name = 'picture_in_picture_change_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'
  and unstruct_event_com_snowplowanalytics_snowplow_media_picture_in_picture_change_event_1 is not null

select
  "picture_in_picture_change_event_1".*
from
  atomic.events events
  join atomic.com_snowplowanalytics_snowplow_media_picture_in_picture_change_event_1 "picture_in_picture_change_event_1"
    on "picture_in_picture_change_event_1".root_id = events.event_id and "picture_in_picture_change_event_1".root_tstamp = events.collector_tstamp
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and "picture_in_picture_change_event_1".root_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'picture_in_picture_change_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

Playback rate change event

Event: playback_rate_change_event

Media player event sent when the playback rate has changed.

Schema URI:iglu:com.snowplowanalytics.snowplow.media/playback_rate_change_event/jsonschema/1-0-0

Web	Mobile	Tracked automatically
✅	✅	Depends on the tracker used

👀 Example

{
  "previousRate": 1,
  "newRate": 1.5
}

📃 Schema properties definition

Table
JSON schema

Property	Type	Description	Required?
`previousRate`	`["number","null"]`	Playback rate before the change (1 is normal)	❌
`newRate`	`"number"`	Playback rate after the change (1 is normal)	✅

{
  "$schema": "http://iglucentral.com/schemas/com.snowplowanalytics.self-desc/schema/jsonschema/1-0-0#",
  "description": "Media player event sent when the playback rate has changed.",
  "self": {
    "vendor": "com.snowplowanalytics.snowplow.media",
    "name": "playback_rate_change_event",
    "format": "jsonschema",
    "version": "1-0-0"
  },
  "type": "object",
  "properties": {
    "previousRate": {
      "type": [
        "number",
        "null"
      ],
      "description": "Playback rate before the change (1 is normal)",
      "minimum": 0,
      "maximum": 16
    },
    "newRate": {
      "type": "number",
      "description": "Playback rate after the change (1 is normal)",
      "minimum": 0,
      "maximum": 16
    }
  },
  "required": [
    "newRate"
  ],
  "additionalProperties": false
}

❓ How to query the event in the warehouse?

Snowflake
BigQuery
Databricks
Redshift & Postgres

select
  unstruct_event_com_snowplowanalytics_snowplow_media_playback_rate_change_event_1 playback_rate_change_event_1
from
  atomic.events
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'playback_rate_change_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_playback_rate_change_event_1_0_0
from
  PIPELINE_NAME.events events
where
  events.collector_tstamp > timestamp_sub(current_timestamp(), interval 1 hour)
  and events.event = 'unstruct'
  and events.event_name = 'playback_rate_change_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_playback_rate_change_event_1
from
  atomic.events events
where
  events.collector_tstamp > timestampadd(HOUR, -1, current_timestamp())
  and events.event = 'unstruct'
  and events.event_name = 'playback_rate_change_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'
  and unstruct_event_com_snowplowanalytics_snowplow_media_playback_rate_change_event_1 is not null

select
  "playback_rate_change_event_1".*
from
  atomic.events events
  join atomic.com_snowplowanalytics_snowplow_media_playback_rate_change_event_1 "playback_rate_change_event_1"
    on "playback_rate_change_event_1".root_id = events.event_id and "playback_rate_change_event_1".root_tstamp = events.collector_tstamp
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and "playback_rate_change_event_1".root_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'playback_rate_change_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

Quality change event

Event: quality_change_event

Media player event tracked when the video playback quality changes automatically.

Schema URI:iglu:com.snowplowanalytics.snowplow.media/quality_change_event/jsonschema/1-0-0

Web	Mobile	Tracked automatically
✅	✅	Depends on the tracker used

👀 Example

{
  "previousQuality": "1080p",
  "newQuality": "720p",
  "bitrate": 1500,
  "framesPerSecond": 30,
  "automatic": true
}

📃 Schema properties definition

Table
JSON schema

Property	Type	Description	Required?
`previousQuality`	`["string","null"]`	Quality level before the change (e.g., 1080p).	❌
`newQuality`	`["string","null"]`	Quality level after the change (e.g., 1080p).	❌
`bitrate`	`["integer","null"]`	The current bitrate in bits per second.	❌
`framesPerSecond`	`["integer","null"]`	The current number of frames per second.	❌
`automatic`	`["boolean","null"]`	Whether the change was automatic or triggered by the user.	❌

{
  "$schema": "http://iglucentral.com/schemas/com.snowplowanalytics.self-desc/schema/jsonschema/1-0-0#",
  "description": "Media player event tracked when the video playback quality changes automatically.",
  "self": {
    "vendor": "com.snowplowanalytics.snowplow.media",
    "name": "quality_change_event",
    "format": "jsonschema",
    "version": "1-0-0"
  },
  "type": "object",
  "properties": {
    "previousQuality": {
      "type": [
        "string",
        "null"
      ],
      "description": "Quality level before the change (e.g., 1080p).",
      "maxLength": 4096
    },
    "newQuality": {
      "type": [
        "string",
        "null"
      ],
      "description": "Quality level after the change (e.g., 1080p).",
      "maxLength": 4096
    },
    "bitrate": {
      "type": [
        "integer",
        "null"
      ],
      "description": "The current bitrate in bits per second.",
      "minimum": 0,
      "maximum": 9007199254740991
    },
    "framesPerSecond": {
      "type": [
        "integer",
        "null"
      ],
      "description": "The current number of frames per second.",
      "minimum": 0,
      "maximum": 65535
    },
    "automatic": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Whether the change was automatic or triggered by the user."
    }
  },
  "additionalProperties": false
}

❓ How to query the event in the warehouse?

Snowflake
BigQuery
Databricks
Redshift & Postgres

select
  unstruct_event_com_snowplowanalytics_snowplow_media_quality_change_event_1 quality_change_event_1
from
  atomic.events
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'quality_change_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_quality_change_event_1_0_0
from
  PIPELINE_NAME.events events
where
  events.collector_tstamp > timestamp_sub(current_timestamp(), interval 1 hour)
  and events.event = 'unstruct'
  and events.event_name = 'quality_change_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_quality_change_event_1
from
  atomic.events events
where
  events.collector_tstamp > timestampadd(HOUR, -1, current_timestamp())
  and events.event = 'unstruct'
  and events.event_name = 'quality_change_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'
  and unstruct_event_com_snowplowanalytics_snowplow_media_quality_change_event_1 is not null

select
  "quality_change_event_1".*
from
  atomic.events events
  join atomic.com_snowplowanalytics_snowplow_media_quality_change_event_1 "quality_change_event_1"
    on "quality_change_event_1".root_id = events.event_id and "quality_change_event_1".root_tstamp = events.collector_tstamp
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and "quality_change_event_1".root_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'quality_change_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

Ready event

Event: ready_event

Media player event fired when the media tracking is successfully attached to the player and can track events.

Schema URI:iglu:com.snowplowanalytics.snowplow.media/ready_event/jsonschema/1-0-0

Web	Mobile	Tracked automatically
✅	✅	Depends on the tracker used

👀 Example

{}

📃 Schema properties definition

Table
JSON schema

Property	Type	Description	Required?

{
  "$schema": "http://iglucentral.com/schemas/com.snowplowanalytics.self-desc/schema/jsonschema/1-0-0#",
  "description": "Media player event fired when the media tracking is successfully attached to the player and can track events.",
  "self": {
    "vendor": "com.snowplowanalytics.snowplow.media",
    "name": "ready_event",
    "format": "jsonschema",
    "version": "1-0-0"
  },
  "type": "object",
  "properties": {},
  "additionalProperties": false
}

❓ How to query the event in the warehouse?

Snowflake
BigQuery
Databricks
Redshift & Postgres

select
  unstruct_event_com_snowplowanalytics_snowplow_media_ready_event_1 ready_event_1
from
  atomic.events
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'ready_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_ready_event_1_0_0
from
  PIPELINE_NAME.events events
where
  events.collector_tstamp > timestamp_sub(current_timestamp(), interval 1 hour)
  and events.event = 'unstruct'
  and events.event_name = 'ready_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_ready_event_1
from
  atomic.events events
where
  events.collector_tstamp > timestampadd(HOUR, -1, current_timestamp())
  and events.event = 'unstruct'
  and events.event_name = 'ready_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'
  and unstruct_event_com_snowplowanalytics_snowplow_media_ready_event_1 is not null

select
  "ready_event_1".*
from
  atomic.events events
  join atomic.com_snowplowanalytics_snowplow_media_ready_event_1 "ready_event_1"
    on "ready_event_1".root_id = events.event_id and "ready_event_1".root_tstamp = events.collector_tstamp
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and "ready_event_1".root_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'ready_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

Volume change event

Event: volume_change_event

Media player event sent when the volume has changed.

Schema URI:iglu:com.snowplowanalytics.snowplow.media/volume_change_event/jsonschema/1-0-0

Web	Mobile	Tracked automatically
✅	✅	Depends on the tracker used

👀 Example

{
  "previousVolume": 30,
  "newVolume": 50
}

📃 Schema properties definition

Table
JSON schema

Property	Type	Description	Required?
`previousVolume`	`["integer","null"]`	Volume percentage before the change.	❌
`newVolume`	`"integer"`	Volume percentage after the change.	✅

{
  "$schema": "http://iglucentral.com/schemas/com.snowplowanalytics.self-desc/schema/jsonschema/1-0-0#",
  "description": "Media player event sent when the volume has changed.",
  "self": {
    "vendor": "com.snowplowanalytics.snowplow.media",
    "name": "volume_change_event",
    "format": "jsonschema",
    "version": "1-0-0"
  },
  "type": "object",
  "properties": {
    "previousVolume": {
      "type": [
        "integer",
        "null"
      ],
      "description": "Volume percentage before the change.",
      "minimum": 0,
      "maximum": 100
    },
    "newVolume": {
      "type": "integer",
      "description": "Volume percentage after the change.",
      "minimum": 0,
      "maximum": 100
    }
  },
  "required": [
    "newVolume"
  ],
  "additionalProperties": false
}

❓ How to query the event in the warehouse?

Snowflake
BigQuery
Databricks
Redshift & Postgres

select
  unstruct_event_com_snowplowanalytics_snowplow_media_volume_change_event_1 volume_change_event_1
from
  atomic.events
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'volume_change_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_volume_change_event_1_0_0
from
  PIPELINE_NAME.events events
where
  events.collector_tstamp > timestamp_sub(current_timestamp(), interval 1 hour)
  and events.event = 'unstruct'
  and events.event_name = 'volume_change_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_volume_change_event_1
from
  atomic.events events
where
  events.collector_tstamp > timestampadd(HOUR, -1, current_timestamp())
  and events.event = 'unstruct'
  and events.event_name = 'volume_change_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'
  and unstruct_event_com_snowplowanalytics_snowplow_media_volume_change_event_1 is not null

select
  "volume_change_event_1".*
from
  atomic.events events
  join atomic.com_snowplowanalytics_snowplow_media_volume_change_event_1 "volume_change_event_1"
    on "volume_change_event_1".root_id = events.event_id and "volume_change_event_1".root_tstamp = events.collector_tstamp
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and "volume_change_event_1".root_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'volume_change_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

Ad events

Ad click event

Event: ad_click_event

Media player event fired when the user clicked on the ad.

Schema URI:iglu:com.snowplowanalytics.snowplow.media/ad_click_event/jsonschema/1-0-0

Web	Mobile	Tracked automatically
✅	✅	Depends on the tracker used

👀 Example

{
  "percentProgress": 50
}

📃 Schema properties definition

Table
JSON schema

Property	Type	Description	Required?
`percentProgress`	`["integer","null"]`	The percent of the way through the ad	❌

{
  "$schema": "http://iglucentral.com/schemas/com.snowplowanalytics.self-desc/schema/jsonschema/1-0-0#",
  "description": "Media player event fired when the user clicked on the ad.",
  "self": {
    "vendor": "com.snowplowanalytics.snowplow.media",
    "name": "ad_click_event",
    "format": "jsonschema",
    "version": "1-0-0"
  },
  "type": "object",
  "properties": {
    "percentProgress": {
      "type": [
        "integer",
        "null"
      ],
      "description": "The percent of the way through the ad",
      "minimum": 0,
      "maximum": 100
    }
  },
  "additionalProperties": false
}

❓ How to query the event in the warehouse?

Snowflake
BigQuery
Databricks
Redshift & Postgres

select
  unstruct_event_com_snowplowanalytics_snowplow_media_ad_click_event_1 ad_click_event_1
from
  atomic.events
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'ad_click_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_ad_click_event_1_0_0
from
  PIPELINE_NAME.events events
where
  events.collector_tstamp > timestamp_sub(current_timestamp(), interval 1 hour)
  and events.event = 'unstruct'
  and events.event_name = 'ad_click_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_ad_click_event_1
from
  atomic.events events
where
  events.collector_tstamp > timestampadd(HOUR, -1, current_timestamp())
  and events.event = 'unstruct'
  and events.event_name = 'ad_click_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'
  and unstruct_event_com_snowplowanalytics_snowplow_media_ad_click_event_1 is not null

select
  "ad_click_event_1".*
from
  atomic.events events
  join atomic.com_snowplowanalytics_snowplow_media_ad_click_event_1 "ad_click_event_1"
    on "ad_click_event_1".root_id = events.event_id and "ad_click_event_1".root_tstamp = events.collector_tstamp
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and "ad_click_event_1".root_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'ad_click_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

Ad break start event

Event: ad_break_start_event

Media player event that signals the start of an ad break.

Schema URI:iglu:com.snowplowanalytics.snowplow.media/ad_break_start_event/jsonschema/1-0-0

Web	Mobile	Tracked automatically
✅	✅	Depends on the tracker used

👀 Example

{}

📃 Schema properties definition

Table
JSON schema

Property	Type	Description	Required?

{
  "$schema": "http://iglucentral.com/schemas/com.snowplowanalytics.self-desc/schema/jsonschema/1-0-0#",
  "description": "Media player event that signals the start of an ad break.",
  "self": {
    "vendor": "com.snowplowanalytics.snowplow.media",
    "name": "ad_break_start_event",
    "format": "jsonschema",
    "version": "1-0-0"
  },
  "type": "object",
  "properties": {},
  "additionalProperties": false
}

❓ How to query the event in the warehouse?

Snowflake
BigQuery
Databricks
Redshift & Postgres

select
  unstruct_event_com_snowplowanalytics_snowplow_media_ad_break_start_event_1 ad_break_start_event_1
from
  atomic.events
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'ad_break_start_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_ad_break_start_event_1_0_0
from
  PIPELINE_NAME.events events
where
  events.collector_tstamp > timestamp_sub(current_timestamp(), interval 1 hour)
  and events.event = 'unstruct'
  and events.event_name = 'ad_break_start_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_ad_break_start_event_1
from
  atomic.events events
where
  events.collector_tstamp > timestampadd(HOUR, -1, current_timestamp())
  and events.event = 'unstruct'
  and events.event_name = 'ad_break_start_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'
  and unstruct_event_com_snowplowanalytics_snowplow_media_ad_break_start_event_1 is not null

select
  "ad_break_start_event_1".*
from
  atomic.events events
  join atomic.com_snowplowanalytics_snowplow_media_ad_break_start_event_1 "ad_break_start_event_1"
    on "ad_break_start_event_1".root_id = events.event_id and "ad_break_start_event_1".root_tstamp = events.collector_tstamp
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and "ad_break_start_event_1".root_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'ad_break_start_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

Ad break end event

Event: ad_break_end_event

Media player event that signals the end of an ad break.

Schema URI:iglu:com.snowplowanalytics.snowplow.media/ad_break_end_event/jsonschema/1-0-0

Web	Mobile	Tracked automatically
✅	✅	Depends on the tracker used

👀 Example

{}

📃 Schema properties definition

Table
JSON schema

Property	Type	Description	Required?

{
  "$schema": "http://iglucentral.com/schemas/com.snowplowanalytics.self-desc/schema/jsonschema/1-0-0#",
  "description": "Media player event that signals the end of an ad break.",
  "self": {
    "vendor": "com.snowplowanalytics.snowplow.media",
    "name": "ad_break_end_event",
    "format": "jsonschema",
    "version": "1-0-0"
  },
  "type": "object",
  "properties": {},
  "additionalProperties": false
}

❓ How to query the event in the warehouse?

Snowflake
BigQuery
Databricks
Redshift & Postgres

select
  unstruct_event_com_snowplowanalytics_snowplow_media_ad_break_end_event_1 ad_break_end_event_1
from
  atomic.events
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'ad_break_end_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_ad_break_end_event_1_0_0
from
  PIPELINE_NAME.events events
where
  events.collector_tstamp > timestamp_sub(current_timestamp(), interval 1 hour)
  and events.event = 'unstruct'
  and events.event_name = 'ad_break_end_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_ad_break_end_event_1
from
  atomic.events events
where
  events.collector_tstamp > timestampadd(HOUR, -1, current_timestamp())
  and events.event = 'unstruct'
  and events.event_name = 'ad_break_end_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'
  and unstruct_event_com_snowplowanalytics_snowplow_media_ad_break_end_event_1 is not null

select
  "ad_break_end_event_1".*
from
  atomic.events events
  join atomic.com_snowplowanalytics_snowplow_media_ad_break_end_event_1 "ad_break_end_event_1"
    on "ad_break_end_event_1".root_id = events.event_id and "ad_break_end_event_1".root_tstamp = events.collector_tstamp
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and "ad_break_end_event_1".root_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'ad_break_end_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

Ad complete event

Event: ad_complete_event

Media player event that signals the ad creative was played to the end at normal speed.

Schema URI:iglu:com.snowplowanalytics.snowplow.media/ad_complete_event/jsonschema/1-0-0

Web	Mobile	Tracked automatically
✅	✅	Depends on the tracker used

👀 Example

{}

📃 Schema properties definition

Table
JSON schema

Property	Type	Description	Required?

{
  "$schema": "http://iglucentral.com/schemas/com.snowplowanalytics.self-desc/schema/jsonschema/1-0-0#",
  "description": "Media player event that signals the ad creative was played to the end at normal speed.",
  "self": {
    "vendor": "com.snowplowanalytics.snowplow.media",
    "name": "ad_complete_event",
    "format": "jsonschema",
    "version": "1-0-0"
  },
  "type": "object",
  "properties": {},
  "additionalProperties": false
}

❓ How to query the event in the warehouse?

Snowflake
BigQuery
Databricks
Redshift & Postgres

select
  unstruct_event_com_snowplowanalytics_snowplow_media_ad_complete_event_1 ad_complete_event_1
from
  atomic.events
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'ad_complete_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_ad_complete_event_1_0_0
from
  PIPELINE_NAME.events events
where
  events.collector_tstamp > timestamp_sub(current_timestamp(), interval 1 hour)
  and events.event = 'unstruct'
  and events.event_name = 'ad_complete_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_ad_complete_event_1
from
  atomic.events events
where
  events.collector_tstamp > timestampadd(HOUR, -1, current_timestamp())
  and events.event = 'unstruct'
  and events.event_name = 'ad_complete_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'
  and unstruct_event_com_snowplowanalytics_snowplow_media_ad_complete_event_1 is not null

select
  "ad_complete_event_1".*
from
  atomic.events events
  join atomic.com_snowplowanalytics_snowplow_media_ad_complete_event_1 "ad_complete_event_1"
    on "ad_complete_event_1".root_id = events.event_id and "ad_complete_event_1".root_tstamp = events.collector_tstamp
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and "ad_complete_event_1".root_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'ad_complete_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

Ad pause event

Event: ad_pause_event

Media player event fired when the user clicked the pause control and stopped the ad creative.

Schema URI:iglu:com.snowplowanalytics.snowplow.media/ad_pause_event/jsonschema/1-0-0

Web	Mobile	Tracked automatically
✅	✅	Depends on the tracker used

👀 Example

{
  "percentProgress": 50
}

📃 Schema properties definition

Table
JSON schema

Property	Type	Description	Required?
`percentProgress`	`["integer","null"]`	The percent of the way through the ad	❌

{
  "$schema": "http://iglucentral.com/schemas/com.snowplowanalytics.self-desc/schema/jsonschema/1-0-0#",
  "description": "Media player event fired when the user clicked the pause control and stopped the ad creative.",
  "self": {
    "vendor": "com.snowplowanalytics.snowplow.media",
    "name": "ad_pause_event",
    "format": "jsonschema",
    "version": "1-0-0"
  },
  "type": "object",
  "properties": {
    "percentProgress": {
      "type": [
        "integer",
        "null"
      ],
      "description": "The percent of the way through the ad",
      "minimum": 0,
      "maximum": 100
    }
  },
  "additionalProperties": false
}

❓ How to query the event in the warehouse?

Snowflake
BigQuery
Databricks
Redshift & Postgres

select
  unstruct_event_com_snowplowanalytics_snowplow_media_ad_pause_event_1 ad_pause_event_1
from
  atomic.events
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'ad_pause_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_ad_pause_event_1_0_0
from
  PIPELINE_NAME.events events
where
  events.collector_tstamp > timestamp_sub(current_timestamp(), interval 1 hour)
  and events.event = 'unstruct'
  and events.event_name = 'ad_pause_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_ad_pause_event_1
from
  atomic.events events
where
  events.collector_tstamp > timestampadd(HOUR, -1, current_timestamp())
  and events.event = 'unstruct'
  and events.event_name = 'ad_pause_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'
  and unstruct_event_com_snowplowanalytics_snowplow_media_ad_pause_event_1 is not null

select
  "ad_pause_event_1".*
from
  atomic.events events
  join atomic.com_snowplowanalytics_snowplow_media_ad_pause_event_1 "ad_pause_event_1"
    on "ad_pause_event_1".root_id = events.event_id and "ad_pause_event_1".root_tstamp = events.collector_tstamp
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and "ad_pause_event_1".root_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'ad_pause_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

Ad quartile event

Event: ad_quartile_event

Media player event fired when a quartile of ad is reached after continuous ad playback at normal speed.

Schema URI:iglu:com.snowplowanalytics.snowplow.media/ad_quartile_event/jsonschema/1-0-0

Web	Mobile	Tracked automatically
✅	✅	Depends on the tracker used

👀 Example

{
  "percentProgress": 50
}

📃 Schema properties definition

Table
JSON schema

Property	Type	Description	Required?
`percentProgress`	`"integer"`	The percent of the way through the ad	✅

{
  "$schema": "http://iglucentral.com/schemas/com.snowplowanalytics.self-desc/schema/jsonschema/1-0-0#",
  "description": "Media player event fired when a quartile of ad is reached after continuous ad playback at normal speed.",
  "self": {
    "vendor": "com.snowplowanalytics.snowplow.media",
    "name": "ad_quartile_event",
    "format": "jsonschema",
    "version": "1-0-0"
  },
  "type": "object",
  "properties": {
    "percentProgress": {
      "type": "integer",
      "description": "The percent of the way through the ad",
      "minimum": 0,
      "maximum": 100
    }
  },
  "additionalProperties": false,
  "required": [
    "percentProgress"
  ]
}

❓ How to query the event in the warehouse?

Snowflake
BigQuery
Databricks
Redshift & Postgres

select
  unstruct_event_com_snowplowanalytics_snowplow_media_ad_quartile_event_1 ad_quartile_event_1
from
  atomic.events
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'ad_quartile_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_ad_quartile_event_1_0_0
from
  PIPELINE_NAME.events events
where
  events.collector_tstamp > timestamp_sub(current_timestamp(), interval 1 hour)
  and events.event = 'unstruct'
  and events.event_name = 'ad_quartile_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_ad_quartile_event_1
from
  atomic.events events
where
  events.collector_tstamp > timestampadd(HOUR, -1, current_timestamp())
  and events.event = 'unstruct'
  and events.event_name = 'ad_quartile_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'
  and unstruct_event_com_snowplowanalytics_snowplow_media_ad_quartile_event_1 is not null

select
  "ad_quartile_event_1".*
from
  atomic.events events
  join atomic.com_snowplowanalytics_snowplow_media_ad_quartile_event_1 "ad_quartile_event_1"
    on "ad_quartile_event_1".root_id = events.event_id and "ad_quartile_event_1".root_tstamp = events.collector_tstamp
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and "ad_quartile_event_1".root_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'ad_quartile_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

Ad resume event

Event: ad_resume_event

Media player event fired when the user resumed playing the ad creative after it had been stopped or paused.

Schema URI:iglu:com.snowplowanalytics.snowplow.media/ad_resume_event/jsonschema/1-0-0

Web	Mobile	Tracked automatically
✅	✅	Depends on the tracker used

👀 Example

{
  "percentProgress": 50
}

📃 Schema properties definition

Table
JSON schema

Property	Type	Description	Required?
`percentProgress`	`["integer","null"]`	The percent of the way through the ad	❌

{
  "$schema": "http://iglucentral.com/schemas/com.snowplowanalytics.self-desc/schema/jsonschema/1-0-0#",
  "description": "Media player event fired when the user resumed playing the ad creative after it had been stopped or paused.",
  "self": {
    "vendor": "com.snowplowanalytics.snowplow.media",
    "name": "ad_resume_event",
    "format": "jsonschema",
    "version": "1-0-0"
  },
  "type": "object",
  "properties": {
    "percentProgress": {
      "type": [
        "integer",
        "null"
      ],
      "description": "The percent of the way through the ad",
      "minimum": 0,
      "maximum": 100
    }
  },
  "additionalProperties": false
}

❓ How to query the event in the warehouse?

Snowflake
BigQuery
Databricks
Redshift & Postgres

select
  unstruct_event_com_snowplowanalytics_snowplow_media_ad_resume_event_1 ad_resume_event_1
from
  atomic.events
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'ad_resume_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_ad_resume_event_1_0_0
from
  PIPELINE_NAME.events events
where
  events.collector_tstamp > timestamp_sub(current_timestamp(), interval 1 hour)
  and events.event = 'unstruct'
  and events.event_name = 'ad_resume_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_ad_resume_event_1
from
  atomic.events events
where
  events.collector_tstamp > timestampadd(HOUR, -1, current_timestamp())
  and events.event = 'unstruct'
  and events.event_name = 'ad_resume_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'
  and unstruct_event_com_snowplowanalytics_snowplow_media_ad_resume_event_1 is not null

select
  "ad_resume_event_1".*
from
  atomic.events events
  join atomic.com_snowplowanalytics_snowplow_media_ad_resume_event_1 "ad_resume_event_1"
    on "ad_resume_event_1".root_id = events.event_id and "ad_resume_event_1".root_tstamp = events.collector_tstamp
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and "ad_resume_event_1".root_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'ad_resume_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

Ad skip event

Event: ad_skip_event

Media player event fired when the user activated a skip control to skip the ad creative.

Schema URI:iglu:com.snowplowanalytics.snowplow.media/ad_skip_event/jsonschema/1-0-0

Web	Mobile	Tracked automatically
✅	✅	Depends on the tracker used

👀 Example

{
  "percentProgress": 50
}

📃 Schema properties definition

Table
JSON schema

Property	Type	Description	Required?
`percentProgress`	`["integer","null"]`	The percent of the way through the ad	❌

{
  "$schema": "http://iglucentral.com/schemas/com.snowplowanalytics.self-desc/schema/jsonschema/1-0-0#",
  "description": "Media player event fired when the user activated a skip control to skip the ad creative.",
  "self": {
    "vendor": "com.snowplowanalytics.snowplow.media",
    "name": "ad_skip_event",
    "format": "jsonschema",
    "version": "1-0-0"
  },
  "type": "object",
  "properties": {
    "percentProgress": {
      "type": [
        "integer",
        "null"
      ],
      "description": "The percent of the way through the ad",
      "minimum": 0,
      "maximum": 100
    }
  },
  "additionalProperties": false
}

❓ How to query the event in the warehouse?

Snowflake
BigQuery
Databricks
Redshift & Postgres

select
  unstruct_event_com_snowplowanalytics_snowplow_media_ad_skip_event_1 ad_skip_event_1
from
  atomic.events
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'ad_skip_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_ad_skip_event_1_0_0
from
  PIPELINE_NAME.events events
where
  events.collector_tstamp > timestamp_sub(current_timestamp(), interval 1 hour)
  and events.event = 'unstruct'
  and events.event_name = 'ad_skip_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_ad_skip_event_1
from
  atomic.events events
where
  events.collector_tstamp > timestampadd(HOUR, -1, current_timestamp())
  and events.event = 'unstruct'
  and events.event_name = 'ad_skip_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'
  and unstruct_event_com_snowplowanalytics_snowplow_media_ad_skip_event_1 is not null

select
  "ad_skip_event_1".*
from
  atomic.events events
  join atomic.com_snowplowanalytics_snowplow_media_ad_skip_event_1 "ad_skip_event_1"
    on "ad_skip_event_1".root_id = events.event_id and "ad_skip_event_1".root_tstamp = events.collector_tstamp
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and "ad_skip_event_1".root_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'ad_skip_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

Ad start event

Event: ad_start_event

Media player event that signals the start of an ad.

Schema URI:iglu:com.snowplowanalytics.snowplow.media/ad_start_event/jsonschema/1-0-0

Web	Mobile	Tracked automatically
✅	✅	Depends on the tracker used

👀 Example

{}

📃 Schema properties definition

Table
JSON schema

Property	Type	Description	Required?

{
  "$schema": "http://iglucentral.com/schemas/com.snowplowanalytics.self-desc/schema/jsonschema/1-0-0#",
  "description": "Media player event that signals the start of an ad.",
  "self": {
    "vendor": "com.snowplowanalytics.snowplow.media",
    "name": "ad_start_event",
    "format": "jsonschema",
    "version": "1-0-0"
  },
  "type": "object",
  "properties": {},
  "additionalProperties": false
}

❓ How to query the event in the warehouse?

Snowflake
BigQuery
Databricks
Redshift & Postgres

select
  unstruct_event_com_snowplowanalytics_snowplow_media_ad_start_event_1 ad_start_event_1
from
  atomic.events
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'ad_start_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_ad_start_event_1_0_0
from
  PIPELINE_NAME.events events
where
  events.collector_tstamp > timestamp_sub(current_timestamp(), interval 1 hour)
  and events.event = 'unstruct'
  and events.event_name = 'ad_start_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

select
  unstruct_event_com_snowplowanalytics_snowplow_media_ad_start_event_1
from
  atomic.events events
where
  events.collector_tstamp > timestampadd(HOUR, -1, current_timestamp())
  and events.event = 'unstruct'
  and events.event_name = 'ad_start_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'
  and unstruct_event_com_snowplowanalytics_snowplow_media_ad_start_event_1 is not null

select
  "ad_start_event_1".*
from
  atomic.events events
  join atomic.com_snowplowanalytics_snowplow_media_ad_start_event_1 "ad_start_event_1"
    on "ad_start_event_1".root_id = events.event_id and "ad_start_event_1".root_tstamp = events.collector_tstamp
where
  events.collector_tstamp > getdate() - interval '1 hour'
  and "ad_start_event_1".root_tstamp > getdate() - interval '1 hour'
  and events.event = 'unstruct'
  and events.event_name = 'ad_start_event'
  and events.event_vendor = 'com.snowplowanalytics.snowplow.media'

Context entities

Media player entity

Context entity: media_player

Schema for a context entity for media events that describes the media player and playback state

Schema URI:iglu:com.snowplowanalytics.snowplow/media_player/jsonschema/2-0-0

Web	Mobile	Tracked automatically
✅	✅	✅

👀 Example

{
  "currentTime": 109,
  "duration": 400,
  "ended": false,
  "fullscreen": false,
  "livestream": false,
  "label": "Big Bucks Bunny",
  "loop": false,
  "mediaType": "video",
  "muted": false,
  "paused": true,
  "pictureInPicture": false,
  "playbackRate": 1.5,
  "playerType": "com.vimeo-vimeo",
  "quality": "1080p",
  "volume": 100
}

📃 Schema properties definition

Table
JSON schema

Property	Type	Description	Required?
`currentTime`	`"number"`	The current playback time position within the media in seconds.	✅
`duration`	`["number","null"]`	A floating-point value indicating the duration of the media in seconds.	❌
`ended`	`"boolean"`	Whether playback of the media has ended.	✅
`fullscreen`	`["boolean","null"]`	Whether the video element is fullscreen.	❌
`livestream`	`["boolean","null"]`	Whether the media is a live stream.	❌
`label`	`["string","null"]`	Human readable name given to tracked media content.	❌
`loop`	`["boolean","null"]`	Whether the video should restart after ending.	❌
`mediaType`	One of: video, audio,	Type of media content.	❌
`muted`	`["boolean","null"]`	Whether the media element is muted.	❌
`paused`	`"boolean"`	Whether the media element is paused	✅
`pictureInPicture`	`["boolean","null"]`	Whether the video element is showing picture-in-picture.	❌
`playbackRate`	`["number","null"]`	Playback rate (1 is normal).	❌
`playerType`	`["string","null"]`	Type of the media player (e.g., com.youtube-youtube, com.vimeo-vimeo, org.whatwg-media_element).	❌
`quality`	`["string","null"]`	Quality level of the playback (e.g., 1080p).	❌
`volume`	`["integer","null"]`	Volume percentage at which the media will be played.	❌

{
  "$schema": "http://iglucentral.com/schemas/com.snowplowanalytics.self-desc/schema/jsonschema/1-0-0#",
  "description": "Schema for a context entity for media events that describes the media player and playback state",
  "self": {
    "vendor": "com.snowplowanalytics.snowplow",
    "name": "media_player",
    "format": "jsonschema",
    "version": "2-0-0"
  },
  "type": "object",
  "properties": {
    "currentTime": {
      "type": "number",
      "description": "The current playback time position within the media in seconds.",
      "minimum": 0,
      "maximum": 2147483647
    },
    "duration": {
      "type": [
        "number",
        "null"
      ],
      "description": "A floating-point value indicating the duration of the media in seconds.",
      "minimum": 0,
      "maximum": 2147483647
    },
    "ended": {
      "type": "boolean",
      "description": "Whether playback of the media has ended."
    },
    "fullscreen": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Whether the video element is fullscreen."
    },
    "livestream": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Whether the media is a live stream."
    },
    "label": {
      "type": [
        "string",
        "null"
      ],
      "description": "Human readable name given to tracked media content.",
      "maxLength": 4096
    },
    "loop": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Whether the video should restart after ending."
    },
    "mediaType": {
      "description": "Type of media content.",
      "enum": [
        "video",
        "audio",
        null
      ],
      "type": [
        "string",
        "null"
      ]
    },
    "muted": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Whether the media element is muted."
    },
    "paused": {
      "type": "boolean",
      "description": "Whether the media element is paused"
    },
    "pictureInPicture": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Whether the video element is showing picture-in-picture."
    },
    "playbackRate": {
      "type": [
        "number",
        "null"
      ],
      "description": "Playback rate (1 is normal).",
      "minimum": 0,
      "maximum": 16
    },
    "playerType": {
      "type": [
        "string",
        "null"
      ],
      "description": "Type of the media player (e.g., com.youtube-youtube, com.vimeo-vimeo, org.whatwg-media_element).",
      "maxLength": 4096
    },
    "quality": {
      "type": [
        "string",
        "null"
      ],
      "description": "Quality level of the playback (e.g., 1080p).",
      "maxLength": 4096
    },
    "volume": {
      "type": [
        "integer",
        "null"
      ],
      "description": "Volume percentage at which the media will be played.",
      "minimum": 0,
      "maximum": 100
    }
  },
  "additionalProperties": false,
  "required": [
    "currentTime",
    "ended",
    "paused"
  ]
}

Media session entity

The media session entity is updated automatically by our trackers. It contains metrics that are calculated based on the tracked media events and the media update calls.

It makes use of the information in the media player entity (see above) and the tracked media event types to update it's state and calculate metrics. The table below shows which media player properties (first column) and media events (second column) are used to calculate the metrics within the media session entity (third column).

Media player entity property	Media events	Affected calculation of metric
`paused`	`play_event`, `pause_event`	`timePlayed`, `timePaused`, `timePlayedMuted`, `contentWatched`
`currentTime`		`timePlayed`, `timePaused`, `timePlayedMuted`, `contentWatched`
`muted`		`timePlayedMuted`
`playbackRate`	`playback_rate_change_event`	`avgPlaybackRate`
	`buffer_start_event`, `buffer_end_event`, `play_event`	`timeBuffering`
	`ad_start_event`	`ads`
	`ad_skip_event`	`adsSkipped`
	`ad_click_event`	`adsClicked`
	`ad_break_start_event`	`adBreaks`
	`ad_start_event`, `ad_quartile_event`, `ad_complete_event`	`timeSpentAds`
	`ad_start_event`, `ad_complete_event`, `ad_skip_event`	`timePlayed`, `timePlayedMuted`*

* Play time stats are not being incremented while ads with type linear (default) are being played. Linear ads take over the video playback. For non-linear and companion ads, play time stats are still being incremented while the ad is playing.

Context entity: session

Schema for a context entity for media player events that tracks a session of a single media player usage

Schema URI:iglu:com.snowplowanalytics.snowplow.media/session/jsonschema/1-0-0

Web	Mobile	Tracked automatically
✅	✅	✅

👀 Example

{
  "mediaSessionId": "2d9bd9ac-abbd-419a-b934-9a2965cba339",
  "startedAt": "2023-11-03T09:55:29.920Z",
  "pingInterval": 15,
  "timePlayed": 143.12,
  "timePlayedMuted": 0,
  "timePaused": 8.12,
  "contentWatched": 120,
  "timeBuffering": 0.988,
  "timeSpentAds": 14.2,
  "ads": 4,
  "adsClicked": 0,
  "adsSkipped": 1,
  "adBreaks": 2,
  "avgPlaybackRate": 1.21
}

📃 Schema properties definition

Table
JSON schema

Property	Type	Description	Required?
`mediaSessionId`	`"string"`	An identifier for the media session that is kept while the media content is played in the media player.	✅
`startedAt`	`["null","string"]`	Local date-time timestamp of when the session started.	❌
`pingInterval`	`["integer","null"]`	Interval (seconds) in which the ping events will be sent. Default (specified in the tracker media docs) is assumed if not specified.	❌
`timePlayed`	`["number","null"]`	Total seconds user spent playing content (excluding linear ads).	❌
`timePlayedMuted`	`["number","null"]`	Total seconds user spent playing content on mute (excluding linear ads).	❌
`timePaused`	`["number","null"]`	Total seconds user spent with paused content (excluding linear ads).	❌
`contentWatched`	`["number","null"]`	Total seconds of the content played. Each part of the content played is counted once (i.e., counts rewinding or rewatching the same content only once). Playback rate does not affect this value.	❌
`timeBuffering`	`["number","null"]`	Total seconds that playback was buffering during the session.	❌
`timeSpentAds`	`["number","null"]`	Total seconds that ads played during the session.	❌
`ads`	`["integer","null"]`	Number of ads played.	❌
`adsClicked`	`["integer","null"]`	Number of ads that the user clicked on.	❌
`adsSkipped`	`["integer","null"]`	Number of ads that the user skipped.	❌
`adBreaks`	`["integer","null"]`	Number of ad breaks played.	❌
`avgPlaybackRate`	`["number","null"]`	Average playback rate (1 is normal speed).	❌

{
  "$schema": "http://iglucentral.com/schemas/com.snowplowanalytics.self-desc/schema/jsonschema/1-0-0#",
  "description": "Schema for a context entity for media player events that tracks a session of a single media player usage",
  "self": {
    "vendor": "com.snowplowanalytics.snowplow.media",
    "name": "session",
    "format": "jsonschema",
    "version": "1-0-0"
  },
  "type": "object",
  "properties": {
    "mediaSessionId": {
      "type": "string",
      "maxLength": 256,
      "description": "An identifier for the media session that is kept while the media content is played in the media player."
    },
    "startedAt": {
      "type": [
        "null",
        "string"
      ],
      "description": "Local date-time timestamp of when the session started.",
      "format": "date-time"
    },
    "pingInterval": {
      "type": [
        "integer",
        "null"
      ],
      "description": "Interval (seconds) in which the ping events will be sent. Default (specified in the tracker media docs) is assumed if not specified.",
      "minimum": 0,
      "maximum": 65535
    },
    "timePlayed": {

Events​

Playback events​

Buffer end event​

Buffer start event​

Pause event​

Playback end event​

Percent progress event​

Media ping event​

Play event​

Seek end event​

Seek start event​

Player events​

Error event​

Fullscreen change event​

Picture-in-picture change event​

Playback rate change event​

Quality change event​

Ready event​

Volume change event​

Ad events​

Ad click event​

Ad break start event​

Ad break end event​

Ad complete event​

Ad pause event​

Ad quartile event​

Ad resume event​

Ad skip event​

Ad start event​

Context entities​

Media player entity​

Media session entity​

Events

Playback events

Buffer end event

Buffer start event

Pause event

Playback end event

Percent progress event

Media ping event

Play event

Seek end event

Seek start event

Player events

Error event

Fullscreen change event

Picture-in-picture change event

Playback rate change event

Quality change event

Ready event

Volume change event

Ad events

Ad click event

Ad break start event

Ad break end event

Ad complete event

Ad pause event

Ad quartile event

Ad resume event

Ad skip event

Ad start event

Context entities

Media player entity

Media session entity