Snowplow Media Player dbt package v0.6 released

We are excited to announce the release of v0.6.1 of the snowplow-media-player dbt package!

New media schemas with more accurate metrics and media ad tracking

This release adds support for the new media event and context entity schemas (published under the vendor). The new schemas enable a range of new features.

Media events now report metrics about the playback calculated on the tracker (e.g., time played, average playback rate). This enables the package to report more accurate metrics in the media_plays and media_stats tables than previously possible. The new information is tracked in the media session context entity. Several new interesting metrics have been added such as the duration of unique content watched without counting repeatedly watched content (content_watched_secs) and the total number of seconds that the video was buffering (buffering_time_secs).

The package provides two new tables to report on ads played during media playback. The media_ad_views table shows information about each ad view such as the percentage progress reached, whether the ad was clicked or skipped and more. The media_ads table aggregates the ad views per each ad viewed within a media content and calculates the total metrics for all ad views and for unique users.

New media event schemas have been added including one for the playback quality change event or the media ping event.

Support for mobile app events and new JavaScript tracker plugins

This release brings support for media events tracked using the following new tracking options (in addition to the YouTube and HTML5 Media Tracking plugins for the JavaScript tracker):

Under the hood, the entire the base of the package has been replaced to bring support for mobile events. The dependency on the Snowplow Web dbt package has been removed by adding a self-contained base inside the media package.

Released under the SPAL license

Starting with the 0.6.x version series, the package is being released under the Snowplow Personal & Academic License (SPAL) instead of the Apache 2. To learn, see the announcement, or check out our FAQ.

Blog post, accelerator and documention

To learn more, take a look at the following resources:


This version requires a full refresh run if you have been using any previous versions. You will not be able to upgrade and have the package work without doing a full refresh. Check out the migration guide for more information when you upgrade.