Platform DocsPlayers DocsRelease Notes
Support Guides
System StatusSubmit a CaseDashboard LoginCompany Site

Dataset Reference

Suggest Edits

Dynamic Strategy Rules

This dataset contains daily rollups of the Dynamic Strategy Rules data.

Item Description
Table name Direct Share:
JW_DATA.PUBLIC.PLACEMENTS_DAILY_<jw_account_id>_<snowflake_id>

Reader Account:
JW_DATA.PUBLIC.PLACEMENTS_DAILY_<jw_account_id>
Data attributes See: Strategy Rules Placement Daily Definitions
New row creation A new row is created once a day.
Data refresh rate Once per morning, US - Eastern (UTC -4 / UTC -5)*

* The time zone is affected by whether daylight saving time or standard time is in effect.


Media Metadata

Media Custom Parameters

This dataset contains custom parameters which are rows of data containing all the custom parameters for a given media item.

Item Description
Table name Direct Share:
JW_DATA.PUBLIC.MEDIA_CUSTOM_PARAMETERS_<jw_account_id>_<snowflake_id>

Reader Account:
JW_DATA.PUBLIC.MEDIA_CUSTOM_PARAMETERS_<jw_account_id>
Data attributes See: Media Custom Parameters
New row creation A new row is created each time a custom parameter is added to a media item.
Data refresh rate Once per morning, US - Eastern (UTC -4 / UTC -5)*

* The time zone depends on whether daylight saving time or standard time is in effect.



Media Metadata

This dataset contains media which are rows of data containing all of the media in your JWX account.

Item Description
Table name Direct Share:
JW_DATA.PUBLIC.MEDIA_<jw_account_id>_<snowflake_id>

Reader Account:
JW_DATA.PUBLIC.MEDIA_<jw_account_id>
Data attributes See: Media Metadata
New row creation A new row is created each time a new media is added into the JW Platform.
Data refresh rate Once per morning, US - Eastern (UTC -4 / UTC -5)*

* The time zone depends on whether daylight saving time or standard time is in effect.



Tags

This dataset contains media tags which are rows of data containing all the tags for a given media item.

Item Description
Table name Direct Share:
JW_DATA.PUBLIC.MEDIA_TAGS_<jw_account_id>_<snowflake_id>

Reader Account:
JW_DATA.PUBLIC.MEDIA_TAGS_<jw_account_id>
Data attributes See: Tags
New row creation A new row is created each time a tag is added to a media item.
Data refresh rate Once per morning, US - Eastern (UTC -4 / UTC -5)*

* The time zone depends on whether daylight saving time or standard time is in effect.


Playlist Metadata

Playlist Custom Parameters

This dataset contains custom parameters which are rows of data containing all the custom parameters for a given playlist.

Item Description
Table name Direct Share:
JW_DATA.PUBLIC.PLAYLIST_CUSTOM_PARAMETERS_<jw_account_id>_<snowflake_id>

Reader Account:
JW_DATA.PUBLIC.PLAYLIST_CUSTOM_PARAMETERS_<jw_account_id>
Data attributes See: Playlist Custom Parameters
New row creation A new row is created each time a custom parameter is added to a playlist.
Data refresh rate Once per morning, US - Eastern (UTC -4 / UTC -5)*

* The time zone depends on whether daylight saving time or standard time is in effect.



Playlist Filter Custom Parameters

This dataset filters playlists by custom parameters.

Item Description
Table name Direct Share:
JW_DATA.PUBLIC.PLAYLIST_FILTER_PARAMETERS_<jw_account_id>_<snowflake_id>

Reader Account:
JW_DATA.PUBLIC.PLAYLIST_FILTER_PARAMETERS_<jw_account_id>
Data attributes See: Playlist Filter Custom Parameters
New row creation A new row is created each time a new custom parameters is added to a playlist.
Data refresh rate Once per morning, US - Eastern (UTC -4 / UTC -5)*

* The time zone depends on whether daylight saving time or standard time is in effect.



Playlist Media

This dataset contains media which are rows of data containing all of the media in a playlist.

Item Description
Table name Direct Share:
JW_DATA.PUBLIC.PLAYLIST_MEDIA_<jw_account_id>_<snowflake_id>

Reader Account:
JW_DATA.PUBLIC.PLAYLIST_MEDIA_<jw_account_id>
Data attributes See: Playlist Media
New row creation A new row is created each time a new media is added to a playlist.
Data refresh rate Once per morning, US - Eastern (UTC -4 / UTC -5)*

* The time zone depends on whether daylight saving time or standard time is in effect.



Playlist Metadata

This dataset contains playlist which are rows of data containing all of the playlists in your JWX account.

Item Description
Table name Direct Share:
JW_DATA.PUBLIC.PLAYLISTS_<jw_account_id>_<snowflake_id>

Reader Account:
JW_DATA.PUBLIC.PLAYLISTS_<jw_account_id>
Data attributes See: Playlist Metadata
New row creation A new row is created each time a new playlist is added into the JW Platform.
Data refresh rate Once per morning, US - Eastern (UTC -4 / UTC -5)*

* The time zone depends on whether daylight saving time or standard time is in effect.



Playlist Filter Tags

This dataset contains playlist filter tags which are rows of data containing all the tags for a given playlist.

Item Description
Table name Direct Share:
JW_DATA.PUBLIC.PLAYLIST_FILTER_TAGS_<jw_account_id>_<snowflake_id>

Reader Account:
JW_DATA.PUBLIC.PLAYLIST_FILTER_TAGS_<jw_account_id>
Data attributes See: Playlist Tags
New row creation A new row is created each time a tag is added to a playlist.
Data refresh rate Once per morning, US - Eastern (UTC -4 / UTC -5)*

* The time zone depends on whether daylight saving time or standard time is in effect.


Sessions



Play Sessions

This dataset contains play sessions which are rows of data containing attributes that pertain to a specific user watching a specific video in a JWX cloud-hosted, JWX self-hosted, or JWX SDK player.

Item Description
Table name Direct Share:
JW_DATA.PUBLIC.PLAY_SESSIONS_<jw_account_id>_<snowflake_id>

Reader Account:
JW_DATA.PUBLIC.PLAY_SESSIONS_<jw_account_id>
Number of data attributes See: Playback Data
New play session row creation A new row is created when either of the following occurs:
  • The video player advances to the next video, such as in a playlist.
  • The user leaves the page.
  • The play session crosses over multiple (US - Eastern) dates*.
* In this case, group the queried metrics by Play ID and Media ID. For example, if two rows have the same Play ID, SUM these rows to determine the total time watched for the session.
User session generation Linking all play sessions for a specific user during a visit provides an understanding of the viewer's user session.
Data refresh rate Once per morning, US - Eastern (UTC -4 / UTC -5)*

* The time zone is affected by whether daylight saving time or standard time is in effect.



Play Sessions Monthly Aggregates

This dataset enables you to query more than 90 days of play session data, aggregated at a monthly level.

Item Description
Table name Direct Share:
JW_DATA.PUBLIC.PLAY_SESSIONS_MONTHLY_AGGREGATES_<jw_account_id>_<snowflake_id>

Reader Account:
JW_DATA.PUBLIC.PLAY_SESSIONS_MONTHLY_AGGREGATES_<jw_account_id>
Data attributes See: Play Sessions Monthly Aggregates
New row creation A new row is created for the previous month once a new month begins.

For example, a row for January 2025 (2025-01) is created after February 2025 begins.
Data refresh rate N/A



Server-Side Play Sessions

These datasets 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).

📘

You may key server-side play sessions using either the Viewer ID or User ID identity metrics.


Item Description
Table name Direct Share:
JW_DATA.PUBLIC.CDN_PLAY_METRICS_<jw_account_id>_<snowflake_id>

Reader Account:
JW_DATA.PUBLIC.CDN_PLAY_METRICS_<jw_account_id>
Number of data attributes See: Server-side analytics datasets
New play session row creation A new row is created when either of the following occurs:
  • The player first requests a video from the CDN.
  • The viewer leaves the page.
  • The play session crosses over UTC day boundaries*.
* These sessions do not cross UTC day boundaries and are assumed to roughly represent a single play by a single viewer.
User session generation Linking all play sessions for a specific viewer during a visit provides an understanding of the viewer's session.
Data refresh rate Once per day, 3-5 AM UTC*

* Server-side analytics become available 3-5 hours after the day of the play session ends.



Server-Side Play Sessions Monthly Aggregates

This dataset enables you to query more than 90 days of play session data, aggregated at a monthly level.

Item Description
Table name Direct Share:
JW_DATA.PUBLIC.CDN_PLAY_METRICS_MONTHLY_<jw_account_id>_<snowflake_id>

Reader Account:
JW_DATA.PUBLIC.CDN_PLAY_METRICS_MONTHLY_<jw_account_id>
Data attributes See: Server-Side Analytics Monthly Aggregates
New row creation A new row is created for the previous month once a new month begins.

For example, a row for January 2025 (2025-01) is created after February 2025 begins.
Data refresh rate N/A

FAQs

How are play sessions created?

As a viewer watches a video, the player sends a ping at certain intervals or user actions. This data is combined together into a session to create a play session.

In instances when a viewer has an ad blocker enabled, some ping data may not be captured.

How is Time Watched calculated?

As a viewer watches a video, the player periodically sends a ping to JWX. JWX uses the duration between pings to calculate the Time Watched metric.

Updated about 2 hours ago

© 2007- Longtail Ad Solutions, Inc.