Streaming Monthly Aggregates Datasets

Through Data Sharing, JWX 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 JWX 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.

NameColumn NameDescription
UTC Monthutc_month string First calendar day of the aggregation period, in UTC date format (YYYY-MM-DD)
Site IDsite_id string Unique key that accessed the CDN through the API
CDNcdn string Content Delivery Network provider identifier such as CloudFront, Fastly, or Akamai
Media IDmedia_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 Extensionmedia_extension string Value of the filename extension that indicates media segment format, such as .ts, .dash, or .m4s
Channel IDchannel_id string Unique identifier of the FAST channel (also known as a Pop-up Channel)

This column has a value only for VOD or live media items in a FAST channel. Otherwise, it is NULL.

TIPS:
  • FAST channels are media items. Join on MEDIA to retrieve title and other metadata.
  • Use coalesce(channel_id, media_id) to list FAST channels alongside other media items.

    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

    NameColumn NameDescription
    Streaming Typestreaming_type string

    Type of stream of the aggregation



    The streaming type is identified from the media CDN.



    Possible values:
    • LIVE
    • VOD

    Location

    NameColumn NameDescription
    Continent Codecontinent_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 Codecountry_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

    NameColumn NameDescription
    Accessaccess string

    Type of platform or method through which users interact with the content



    Possible values:
    • App
    • Cast
    • Web
    • Unknown
    Browserbrowser string

    Browser used to fetch the content



    Example values:
    • Safari
    • Chrome
    • Firefox
    • Edge
    • Roku
    • AppleCoreMedia
    • Silk

    The browser is identified based on the user agent string.

    Device Typedevice_type string

    Type of hardware used to retrieve the content



    Possible values:
    • TV
    • Desktop
    • Phone
    • Tablet
    • Console
    • Ebook Reader
    • Car Entertainment System
    • Other
    • Unknown

    The device type is identified based on the user agent string.

    Operating Systemoperating_system string

    Operating system of the device used to fetch content



    Possible values :
    • iOS
    • iPadOS
    • Windows
    • RokuOS
    • Tizen
    • Android
    • FireOS

    The operating system is identified based on the user agent string.



    Metrics

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

    NameColumn NameDescription
    Sessionssessions 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 CDN
    Bytes Streamedbytes_streamed integer Total bytes delivered of VOD and Live content
    Minutes Deliveredminutes_delivered float

    Total minutes of video content successfully streamed by the server to the viewers' video players



    Minutes delivered are determined by counting video segments retrieved.

    Unique Minutes Deliveredunique_minutes_delivered float

    Minutes of video content streamed where replaying segments of the video does not lead to an accumulation of extra minutes



    Unique minutes delivered are calculated based on the number of unique segments retrieved.

    Ad Impressionsad_impressions integer Number of server-side ad insertion (SSAI) impressions
    VOD 25%+ Completesvod_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%+ Completesvod_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%+ Completesvod_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 Completesvod_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.

    BrowserDevice TypeOSDescription
    AppleCoreMediaTVtvOSApp on an Apple TV
    AppleCoreMediaPhoneiOSApp on an iPhone
    AppleCoreMediaTabletiPadOSApp on an iPad

    Metrics

    What are minutes delivered?

    Minutes delivered refers to the total video content retrieved on a viewer's device from the JWX 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.

    What methodology is used to determine minutes delivered?

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


    Did this page help you?
    © 2007- Longtail Ad Solutions, Inc.