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

Data Sharing Datasets

Read definitions of data sets that are only available in Data Sharing

Suggest Edits

📘

To view performance measurement data available in the API, Custom Reports, and Data Sharing, see Metrics and Dimensions.


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 JWP 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 JWP 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 JWP 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 JWP 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

OTT 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 an implementation based on Apps.

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

Reader Account:
JW_DATA.PUBLIC.BATCH_OTT_PLAY_SESSIONS_<jw_account_id>
Number of data attributes See: Data Sharing metrics and dimensions
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 OTT 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 Continuously appended throughout the day



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 JWP cloud-hosted, JWP self-hosted, or JWP 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: Data Sharing metrics and dimensions
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.



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 JWP 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 JWP 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.

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 JWP. JWP uses the duration between pings to calculate the Time Watched metric.

Updated 8 days ago

What’s Next
© 2007- Longtail Ad Solutions, Inc.