Youtube Predefined Reports

Predefined Reports

The YouTube datasource in Rivery comes with the below predefined reports. Each report will have a short description of the data, a list of customizable fields (if any), and the schema mapping. Due to the standardized nature of these reports, there are a number of locked fields that will only be accessible through the custom reporting functionality.

Source-Level Selections

YouTube does not have any source-level selections available to filter each report in the river.

Dimensions Channels

The Dimensions Channels report creates a table of channels and their attributes within the account.

Field	Data Type	Dimension/Metric
id	String	Dimension
brandingSettings_channel_country	String	Dimension
brandingSettings_channel_profileColor	String	Dimension
brandingSettings_channel_showBrowseView	Boolean	Dimension
brandingSettings_channel_showRelatedChannels	Boolean	Dimension
brandingSettings_channel_title	String	Dimension
brandingSettings_channel_trackingAnalyticsAccountId	String	Dimension
brandingSettings_image_bannerExternalUrl	String	Dimension
contentDetails_relatedPlaylists_favorites	String	Dimension
contentDetails_relatedPlaylists_likes	String	Dimension
contentDetails_relatedPlaylists_uploads	String	Dimension
etag	String	Dimension
brandingSettings_channel_defaultTab	String	Dimension
kind	String	Dimension
snippet_country	String	Dimension
snippet_description	String	Dimension
snippet_localized_description	String	Dimension
snippet_localized_title	String	Dimension
snippet_publishedAt	String	Dimension
snippet_thumbnails_default_height	Integer	Dimension
snippet_thumbnails_default_url	String	Dimension
snippet_thumbnails_default_width	Integer	Dimension
snippet_thumbnails_high_height	Integer	Dimension
snippet_thumbnails_high_url	String	Dimension
snippet_thumbnails_high_width	Integer	Dimension
snippet_thumbnails_medium_height	Integer	Dimension
snippet_thumbnails_medium_url	String	Dimension
snippet_thumbnails_medium_width	Integer	Dimension
snippet_title	String	Dimension
statistics_hiddenSubscriberCount	Boolean	Dimension
statistics_subscriberCount	String	Dimension
statistics_videoCount	String	Dimension
statistics_viewCount	String	Dimension
status_isLinked	Boolean	Dimension
status_longUploadsStatus	String	Dimension
status_privacyStatus	String	Dimension
topicDetails_topicCategories	String	Dimension
topicDetails_topicIds	String	Dimension

Dimensions Videos

The Dimensions Videos report creates a table of videos and their attributes within the account.

Field	Data Type	Dimension/Metric
id	String	Dimension
contentDetails_caption	String	Dimension
contentDetails_definition	String	Dimension
contentDetails_dimension	String	Dimension
contentDetails_duration	String	Dimension
contentDetails_hasCustomThumbnail	Boolean	Dimension
contentDetails_licensedContent	Boolean	Dimension
contentDetails_projection	String	Dimension
contentDetails_regionRestriction_blocked	String	Dimension
etag	String	Dimension
fileDetails_audioStreams_bitrateBps	String	Dimension
fileDetails_audioStreams_channelCount	Integer	Dimension
fileDetails_audioStreams_codec	String	Dimension
fileDetails_bitrateBps	String	Dimension
fileDetails_container	String	Dimension
fileDetails_durationMs	String	Dimension
fileDetails_fileName	String	Dimension
fileDetails_fileSize	String	Dimension
fileDetails_fileType	String	Dimension
fileDetails_videoStreams_aspectRatio	Float	Dimension
fileDetails_videoStreams_bitrateBps	String	Dimension
fileDetails_videoStreams_codec	String	Dimension
fileDetails_videoStreams_frameRateFps	Integer	Dimension
fileDetails_videoStreams_heightPixels	Integer	Dimension
fileDetails_videoStreams_widthPixels	Integer	Dimension
contentDetails_contentRating_ytRating	String	Dimension
id_kind	String	Dimension
id_videoId	String	Dimension
kind	String	Dimension
player_embedHtml	String	Dimension
processingDetails_editorSuggestionsAvailability	String	Dimension
processingDetails_fileDetailsAvailability	String	Dimension
processingDetails_processingIssuesAvailability	String	Dimension
processingDetails_processingStatus	String	Dimension
processingDetails_tagSuggestionsAvailability	String	Dimension
processingDetails_thumbnailsAvailability	String	Dimension
snippet_categoryId	String	Dimension
snippet_channelId	String	Dimension
snippet_channelTitle	String	Dimension
snippet_description	String	Dimension
snippet_liveBroadcastContent	String	Dimension
snippet_localized_description	String	Dimension
snippet_localized_title	String	Dimension
snippet_publishedAt	String	Dimension
snippet_tags	String	Dimension
snippet_thumbnails_default_height	Integer	Dimension
snippet_thumbnails_default_url	String	Dimension
snippet_thumbnails_default_width	Integer	Dimension
snippet_thumbnails_high_height	Integer	Dimension
snippet_thumbnails_high_url	String	Dimension
snippet_thumbnails_high_width	Integer	Dimension
snippet_thumbnails_maxres_height	Integer	Dimension
snippet_thumbnails_maxres_url	String	Dimension
snippet_thumbnails_maxres_width	Integer	Dimension
snippet_thumbnails_medium_height	Integer	Dimension
snippet_thumbnails_medium_url	String	Dimension
snippet_thumbnails_medium_width	Integer	Dimension
snippet_thumbnails_standard_height	Integer	Dimension
snippet_thumbnails_standard_url	String	Dimension
snippet_thumbnails_standard_width	Integer	Dimension
snippet_title	String	Dimension
statistics_commentCount	String	Dimension
statistics_dislikeCount	String	Dimension
statistics_favoriteCount	String	Dimension
statistics_likeCount	String	Dimension
statistics_viewCount	String	Dimension
status_embeddable	Boolean	Dimension
status_license	String	Dimension
status_madeForKids	Boolean	Dimension
status_privacyStatus	String	Dimension
status_publicStatsViewable	Boolean	Dimension
status_selfDeclaredMadeForKids	Boolean	Dimension
status_uploadStatus	String	Dimension
topicDetails_topicCategories	String	Dimension

Static Operating System

The Static Operating System report lists the distinct operating systems from which the viewers are accessing the channel.

Field	Data Type	Dimension/Metric
key	String	Dimension
type	String	Dimension
value	String	Dimension

Static Sharing Service

The Static Sharing Service report lists the distinct social platforms on which the item was shared.

Field	Data Type	Dimension/Metric
key	String	Dimension
type	String	Dimension
value	String	Dimension

Static Traffic Source Type

The Static Traffic Source Type report lists the distinct manner in which viewers reached the channel's video content.

Field	Data Type	Dimension/Metric
key	String	Dimension
type	String	Dimension
value	String	Dimension

Static Card Type

The Static Card Type report lists the distinct card types within the channel's video content.

Field	Data Type	Dimension/Metric
key	String	Dimension
type	String	Dimension
value	String	Dimension

Static Device Type

The Static Device Type report lists the distinct device types from which the viewers are accessing the channel.

Field	Data Type	Dimension/Metric
key	String	Dimension
type	String	Dimension
value	String	Dimension

Static Annotation Type

The Static Annotation Type report lists the distinct annotation types that display during a channel's videos.

Field	Data Type	Dimension/Metric
key	String	Dimension
type	String	Dimension
value	String	Dimension

Analytics Province

The Analytics Province report provides user activity statistics for U.S. states and the District of Columbia. The user can only customize the type of incremental load associated with this report.

Field	Data Type	Dimension/Metric
channel_id	String	Dimension
video_id	String	Dimension
subscribed_status	String	Dimension
province_code	String	Dimension
live_or_on_demand	String	Dimension
date	Integer	Dimension
country_code	String	Dimension
annotation_click_through_rate	Integer	Metric
average_view_duration_seconds	Float	Metric
card_click_rate	Integer	Metric
card_clicks	Integer	Metric
card_impressions	Integer	Metric
card_teaser_click_rate	Integer	Metric
card_teaser_clicks	Integer	Metric
card_teaser_impressions	Integer	Metric
average_view_duration_percentage	Float	Metric
annotation_impressions	Integer	Metric
annotation_closes	Integer	Metric
annotation_close_rate	Integer	Metric
annotation_closable_impressions	Integer	Metric
red_views	Integer	Metric
red_watch_time_minutes	Float	Metric
annotation_clicks	Integer	Metric
annotation_clickable_impressions	Integer	Metric
views	Integer	Metric
watch_time_minutes	Float	Metric

Analytics Device And OS

This report aggregates video viewing statistics based on viewers' operating systems and device types. The user can only customize the type of incremental load associated with this report.

Field	Data Type	Dimension/Metric
subscribed_status	String	Dimension
video_id	String	Dimension
channel_id	String	Dimension
country_code	String	Dimension
date	Integer	Dimension
device_type	Integer	Dimension
live_or_on_demand	String	Dimension
operating_system	Integer	Dimension
average_view_duration_percentage	Float	Metric
red_watch_time_minutes	Float	Metric
red_views	Integer	Metric
average_view_duration_seconds	Float	Metric
views	Integer	Metric
watch_time_minutes	Float	Metric

Analytics Traffic Source

The Analytics Traffic Source report aggregates viewing statistics based on the manner in which viewers reached the channel's video content. The user can only customize the type of incremental load associated with this report.

Field	Data Type	Dimension/Metric
subscribed_status	String	Dimension
video_id	String	Dimension
channel_id	String	Dimension
country_code	String	Dimension
date	Integer	Dimension
live_or_on_demand	String	Dimension
traffic_source_type	Integer	Dimension
traffic_source_detail	String	Dimension
average_view_duration_percentage	Float	Metric
red_watch_time_minutes	Float	Metric
red_views	Integer	Metric
average_view_duration_seconds	Float	Metric
views	Integer	Metric
watch_time_minutes	Float	Metric

Analytics Demographics

The Analytics Demographics report aggregates viewing statistics based on viewers' age group and gender. The user can only customize the type of incremental load associated with this report.

Field	Data Type	Dimension/Metric
age_group	String	Dimension
channel_id	String	Dimension
country_code	String	Dimension
date	Integer	Dimension
gender	String	Dimension
live_or_on_demand	String	Dimension
subscribed_status	String	Dimension
video_id	String	Dimension
views_percentage	Float	Metric

Analytics User Activity

The Analytics User Activity report provides user activity statistics related to a channel and its videos. The user can only customize the type of incremental load associated with this report.

Field	Data Type	Dimension/Metric
channel_id	String	Dimension
video_id	String	Dimension
subscribed_status	String	Dimension
live_or_on_demand	String	Dimension
date	Integer	Dimension
country_code	String	Dimension
annotation_click_through_rate	Integer	Metric
average_view_duration_percentage	Float	Metric
average_view_duration_seconds	Float	Metric
card_click_rate	Integer	Metric
card_clicks	Integer	Metric
card_impressions	Integer	Metric
card_teaser_click_rate	Integer	Metric
card_teaser_clicks	Integer	Metric
card_teaser_impressions	Integer	Metric
annotation_impressions	Integer	Metric
comments	Integer	Metric
annotation_closes	Integer	Metric
annotation_close_rate	Integer	Metric
dislikes	Integer	Metric
likes	Integer	Metric
annotation_closable_impressions	Integer	Metric
red_views	Integer	Metric
red_watch_time_minutes	Float	Metric
shares	Integer	Metric
annotation_clicks	Integer	Metric
subscribers_gained	Integer	Metric
subscribers_lost	Integer	Metric
annotation_clickable_impressions	Integer	Metric
videos_added_to_playlists	Integer	Metric
videos_removed_from_playlists	Integer	Metric
views	Integer	Metric
watch_time_minutes	Float	Metric

Analytics Subtitles

The Analytics Subtitles report provides statistics about the closed caption language that is used for the longest time during video views. The user can only customize the type of incremental load associated with this report.

Field	Data Type	Dimension/Metric
subscribed_status	String	Dimension
video_id	String	Dimension
channel_id	String	Dimension
country_code	String	Dimension
date	Integer	Dimension
live_or_on_demand	String	Dimension
subtitle_language	String	Dimension
average_view_duration_percentage	Float	Metric
red_watch_time_minutes	Float	Metric
red_views	Integer	Metric
average_view_duration_seconds	Float	Metric
views	Integer	Metric
watch_time_minutes	Float	Metric

Analytics Sharing Service

The Analytics Sharing Service report provides statistics showing how frequently the channel's videos were shared on different social platforms. The user can only customize the type of incremental load associated with this report.

Field	Data Type	Dimension/Metric
channel_id	String	Dimension
country_code	String	Dimension
date	Integer	Dimension
live_or_on_demand	String	Dimension
sharing_service	Integer	Dimension
subscribed_status	String	Dimension
video_id	String	Dimension
shares	Integer	Metric

Analytics Combined

The Analytics Combined report provides fine-grained video statistics by combining dimensions used in the playback location, traffic source, and device/OS reports. The user can only customize the type of incremental load associated with this report.

Field	Data Type	Dimension/Metric
subscribed_status	String	Dimension
video_id	String	Dimension
channel_id	String	Dimension
country_code	String	Dimension
date	Integer	Dimension
device_type	Integer	Dimension
live_or_on_demand	String	Dimension
operating_system	Integer	Dimension
playback_location_type	Integer	Dimension
traffic_source_type	Integer	Dimension
average_view_duration_percentage	Float	Metric
red_watch_time_minutes	Float	Metric
red_views	Integer	Metric
average_view_duration_seconds	Float	Metric
views	Integer	Metric
watch_time_minutes	Float	Metric

Analytics Playlist Device And OS

The Analytics Playlist Device And OS report aggregates playlist viewing statistics based on viewers' operating systems and device types. The user can only customize the type of incremental load associated with this report.

Field	Data Type	Dimension/Metric
subscribed_status	String	Dimension
channel_id	String	Dimension
country_code	String	Dimension
date	Integer	Dimension
device_type	Integer	Dimension
live_or_on_demand	String	Dimension
operating_system	Integer	Dimension
playlist_id	String	Dimension
video_id	String	Dimension
average_view_duration_seconds	Integer	Metric
playlist_starts	Integer	Metric
playlist_saves_removed	Integer	Metric
playlist_saves_added	Integer	Metric
views	Integer	Metric
watch_time_minutes	Integer	Metric

Analytics Playlist Playback Locations

The Analytics Playlist Playback Locations report provides statistics related to the type of page or application where playlist playbacks occurred. The user can only customize the type of incremental load associated with this report.

Field	Data Type	Dimension/Metric
subscribed_status	String	Dimension
channel_id	String	Dimension
country_code	String	Dimension
date	Integer	Dimension
live_or_on_demand	String	Dimension
playback_location_detail	String	Dimension
playback_location_type	Integer	Dimension
playlist_id	String	Dimension
video_id	String	Dimension
average_view_duration_seconds	Integer	Metric
playlist_starts	Integer	Metric
playlist_saves_removed	Integer	Metric
playlist_saves_added	Integer	Metric
views	Integer	Metric
watch_time_minutes	Integer	Metric

Analytics Playlist Traffic Sources

The Analytics Playlist Traffic Sources report aggregates viewing statistics based on the manner in which viewers reached a channel's playlist videos. The user can only customize the type of incremental load associated with this report.

Field	Data Type	Dimension/Metric
subscribed_status	String	Dimension
channel_id	String	Dimension
country_code	String	Dimension
date	Integer	Dimension
live_or_on_demand	String	Dimension
playlist_id	String	Dimension
video_id	String	Dimension
traffic_source_type	Integer	Dimension
traffic_source_detail	String	Dimension
average_view_duration_seconds	Integer	Metric
playlist_starts	Integer	Metric
playlist_saves_removed	Integer	Metric
playlist_saves_added	Integer	Metric
views	Integer	Metric
watch_time_minutes	Integer	Metric

Analytics Playlist User Activity

The Analytics Playlist User Activity report provides statistics related to users' interactions with a channel's playlists. The user can only customize the type of incremental load associated with this report.

Field	Data Type	Dimension/Metric
subscribed_status	String	Dimension
channel_id	String	Dimension
country_code	String	Dimension
date	Integer	Dimension
live_or_on_demand	String	Dimension
playlist_id	String	Dimension
video_id	String	Dimension
average_view_duration_seconds	Integer	Metric
playlist_starts	Integer	Metric
playlist_saves_removed	Integer	Metric
playlist_saves_added	Integer	Metric
views	Integer	Metric
watch_time_minutes	Integer	Metric

Analytics Playback Locations

The Analytics Playback Locations report provides user activity statistics related to users' interactions with a channel's playlists for U.S. states and the District of Columbia. The user can only customize the type of incremental load associated with this report.

Field	Data Type	Dimension/Metric
subscribed_status	String	Dimension
video_id	String	Dimension
channel_id	String	Dimension
country_code	String	Dimension
date	Integer	Dimension
live_or_on_demand	String	Dimension
playback_location_detail	String	Dimension
playback_location_type	Integer	Dimension
average_view_duration_percentage	Float	Metric
red_watch_time_minutes	Float	Metric
red_views	Integer	Metric
average_view_duration_seconds	Float	Metric
views	Integer	Metric
watch_time_minutes	Float	Metric

Analytics Playlist Combined

The Analytics Playlist Combined report provides fine-grained playlist statistics by combining dimensions used in the playback location, traffic source, and device/OS reports. The user can only customize the type of incremental load associated with this report.

Field	Data Type	Dimension/Metric
subscribed_status	String	Dimension
channel_id	String	Dimension
country_code	String	Dimension
date	Integer	Dimension
device_type	Integer	Dimension
live_or_on_demand	String	Dimension
operating_system	Integer	Dimension
playback_location_type	Integer	Dimension
playlist_id	String	Dimension
video_id	String	Dimension
traffic_source_type	Integer	Dimension
average_view_duration_seconds	Integer	Metric
playlist_starts	Integer	Metric
playlist_saves_removed	Integer	Metric
playlist_saves_added	Integer	Metric
views	Integer	Metric
watch_time_minutes	Integer	Metric