Server-Side Analytics Monthly Aggregates Datasets

Through Data Sharing, JWP shares server-side analytics to help broadcasters create informed monetization and engagement strategies by providing data on how viewers consume content.

The datasets for server-side analytics monthly aggregates contain play sessions, which are rows of data containing attributes that pertain to a specific user watching a specific video fetched from the JWP content delivery network (CDN).

This reference explains all the server-side analytics monthly aggregates metrics and dimensions.

Dimensions

Primary Dimensions

The following dimensions are sourced directly from the CDN logs and define aggregated play sessions. The fields correspond to the GROUP BY query clause that populates the table. These dimensions do not include other fields from the CDN logs.

Name	Column Name	Description
UTC Month	utc_month string	First calendar day of the aggregation period, in UTC date format (`YYYY-MM-DD`)
Site ID	site_id string	Unique key that accessed the CDN through the JWP API
CDN	cdn string	Content Delivery Network provider identifier such as CloudFront, Fastly, or Akamai
Media ID	media_id string	Unique identifier of the media that was fetched If the media ID is not included in the CDN logs, this value will be null.
Media Extension	media_extension string	Value of the filename extension that indicates media segment format, such as `.ts`, `.dash`, or `.m4s`

Secondary Dimensions

The following dimensions are sourced from the CDN logs or enriched from other sources but do not define a unique play session. Dimensions from the CDN logs are assumed to be constant across the entire session.

Media

Name	Column Name	Description
Streaming Type	streaming_type string	Type of stream of the aggregation JWP determines the streaming type using the media CDN. Possible values: `LIVE` `VOD`

Location

Name	Column Name	Description
Continent Code	continent_code string	Two-character code of the continent from which viewers accessed a media item Possible values: `AS`: Asia `AN`: Antarctica `AF`: Africa `EU`: Europe `SA`: South America `OC`: Oceania `NA`: North America
Country Code	country_code string	Two-letter country code from which viewers accessed a media item The value is the ISO 3166-1 alpha-2 country code.

Device

Name	Column Name	Description
Access	access string	Type of platform or method through which users interact with the content Possible values: `App` `Cast` `Web` `Unknown`
Browser	browser string	Browser used to fetch the content from JWP servers Example values: `Safari` `Chrome` `Firefox` `Edge` `Roku` `AppleCoreMedia` `Silk` JWP determines the browser based on the user agent.
Device Type	device_type string	Type of hardware used to retrieve the content from JWP servers Possible values: `TV` `Desktop` `Phone` `Tablet` `Console` `Ebook Reader` `Car Entertainment System` `Other` `Unknown` JWP determines the device type based on the user agent.
Operating System	operating_system string	Operating system of the device used to fetch content from JWP servers Possible values : `iOS` `iPadOS` `Windows` `RokuOS` `Tizen` `Android` `FireOS` JWP determines the operating system based on the user agent.

Metrics

The following server-side monthly aggregated metrics are available through Data Sharing.

Name	Column Name	Description
Sessions	sessions string	Total count of play sessions, where each session is a row of server-side analytics data representing a user viewing a specific video delivered via the JWP CDN
Bytes Streamed	bytes_streamed integer	Total bytes delivered of VOD and Live content
Minutes Delivered	minutes_delivered float	Total minutes of video content successfully streamed by the JWP server to the viewers' video players JWP determines minutes delivered by counting video segments retrieved.
Unique Minutes Delivered	unique_minutes_delivered float	Minutes of video content streamed where replaying segments of the video does not lead to an accumulation of extra minutes JWP calculates unique minutes delivered based on the number of unique segments retrieved.
Ad Impressions	ad_impressions integer	Number of server-side ad insertion (SSAI) impressions
VOD 25%+ Completes	vod_25_pct_plus_completes number	Number of times viewers watched at least to the 25% mark of a video on-demand media item This metric is only available for media items over 30 seconds.
VOD 50%+ Completes	vod_50_pct_plus_completes number	Number of times viewers watched at least to the 50% mark of a video on-demand media item This metric is only available for media items over 30 seconds.
VOD 75%+ Completes	vod_75_pct_plus_completes number	Number of times viewers watched at least to the 75% mark of video on-demand media item This metric is only available for media items over 30 seconds.
VOD Completes	vod_completes number	Number of times viewers watched to the end of a video on-demand media item

FAQs

Dimensions

What is the AppleCoreMedia browser?

The AppleCoreMedia browser is the player used in apps within the Apple ecosystem.

Browser	Device Type	OS	Description
AppleCoreMedia	TV	tvOS	App on an Apple TV
AppleCoreMedia	Phone	iOS	App on an iPhone
AppleCoreMedia	Tablet	iPadOS	App on an iPad

Metrics

What are minutes delivered?

Minutes delivered refers to the total video content retrieved on a viewer's device from the JWP servers. It is a measure of the video segments streamed and downloaded by the player.

Key points:

Minutes delivered is near-100% accurate in calculating total streamed minutes for a piece of content over a period.
This metric can exceed content duration if viewers rewind or rewatch portions of a video.
This metric may not perfectly reflect watch time due to buffering, connectivity issues, or background and shared playback.
For long-form content, minutes delievered provides a good approximation of total engagement.

What are unique minutes delivered?

Unique minutes delivered refers to unique minutes streamed within a play session.

A rewind does not result in higher unique minutes delivered. This metric cannot exceed the duration of the video nor the length of the play session. Unique minutes delivered helps track the percentage of viewers who watch to a certain point of the video.

Why are minutes delivered helpful to broadcasters?

Minutes delivered provides an accurate measure of the total viewing time across all viewers for a given piece of content. It allows broadcasters to track engagement metrics like video completion rates (percentage of viewers watching 25%, 50%, 75%, or the entire video). While not a perfect proxy for watch time, minutes delivered serves a good approximation, particularly for long-form content.

How does JWP determine minutes delivered?

When a video is played, the video player retrieves it in small segments from JWP servers. Each retrieval of a segment is recorded, with the segment length contributing to the total minutes delivered count. This allows JWP to accurately track the total minutes of video streamed and downloaded across all viewers, which approximates the total watch-time.