Playback Monthly Aggregates

Play Session Monthly Aggregates

Aggregated play session data at a monthly level

Column Name	Description
SITE_ID string	ID of the media property
MONTHLY_EASTERN_DATE string	Month of the aggregated play session data in `YYYY-MM` (USA - Eastern Time) format
MEDIA_ID string	ID of the media item
COUNTRY_CODE string	Two-letter country code from which a user accessed a media item The value is the ISO 3166-1 alpha-2 country code.
DEVICE_TYPE string	Device on which the user experienced the session, such as Desktop, Phone, Tablet, TV, Other, and Unknown
PLAYLIST_ID string	ID of the playlist
PAGE_DOMAIN string	Domain associated with the page where the player was embedded By excluding www, all subdomains are also included.
PLAY_REASON integer	Indicator of how media playback was initiated Possible Values: `0`: Unknown reason `1`: A user clicked on the video `2`: Autostarted playback, not dependent upon player viewability settings `3`: Auto-repeat based on the configuration of the player `4`: JavaScript call to the player API `5`: Auto-advance on recommendation and search playlists `6`: Auto-advance on dynamic and manual playlists `7`: Autostarted playback when the player was viewable, dependent upon player viewability settings
SDK_PLATFORM integer	SDK platform in which the player was embedded Possible Values: `0`: Web `1`: Android `2`: iOS `3`: Roku `4`: tvOS `5`: Chromecast Receiver `6`: Fire OS
EMBED_SEEN string	Number of times an embed was viewable at least once in the session
EMBEDS integer	Number of times a player has been set up on a page The following behaviors can log an embed: Loading or refreshing a page with an embedded player Resetting an embedded player without refreshing the page
EXPERIENCE_TYPE string	End user experience shown for the session NOTE: Experience type reporting requires Player version 8.48 or later. Sessions from earlier player versions, or sessions where the experience type is unavailable, appear as `null`. Possible values: `audio`: Audio experience `classic`: Default player `vertical`: Vertical video `null`: Experience type was not reported or could not be determined
PLAYS integer	Number of media item starts The player does not have to be visible for this event to fire. This is based on the `firstFrame` player event.
UNIQUE_VIEWERS integer	Approximate number of unique users who have played at least one media item A unique viewer is defined by IP and user agent.
WATCHED_DURATION integer	Total duration watched in seconds
WATCHED_DURATION_AUDIBLE integer	Total duration of content watched with audio unmuted, in seconds
P25_COMPLETES integer	Number of times viewers watched to the 25% mark of a media item This metric is only available for media items over 30 seconds.
P50_COMPLETES integer	Number of times viewers watched to the 50% mark of a media item This metric is only available for media items over 30 seconds.
P75_COMPLETES integer	Number of times viewers watched to the 75% mark of a media item This metric is only available for media items over 30 seconds.
P100_COMPLETES integer	Number of times a viewer watched until the end of a media item
AD_CLICKS integer	Number of clicks on an ad in an embedded player
AD_COMPLETES integer	Number of times a video ad was completed in an embedded player
AD_IMPRESSIONS integer	Number of ad starts across all embedded players
AD_SKIPS integer	Number of times a video ad was skipped in an embedded player
AD_VIEWABLE_IMPRESSIONS integer	Total number of viewable ad impressions in this session, as defined by the IAB (a viewer has watched an ad for 2 consecutive seconds with at least 50% of the pixels in the viewport) The following are required to properly receive metrics: Player version 8.5+ Ad schedule ID