Youtube Predefined Reports
  • 9 Minutes to read
  • Dark
    Light
  • PDF

Youtube Predefined Reports

  • Dark
    Light
  • PDF

Article summary

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.

FieldData TypeDimension/Metric
id system schemaStringDimension
brandingSettings_channel_countryStringDimension
brandingSettings_channel_profileColorStringDimension
brandingSettings_channel_showBrowseViewBooleanDimension
brandingSettings_channel_showRelatedChannelsBooleanDimension
brandingSettings_channel_titleStringDimension
brandingSettings_channel_trackingAnalyticsAccountIdStringDimension
brandingSettings_image_bannerExternalUrlStringDimension
contentDetails_relatedPlaylists_favoritesStringDimension
contentDetails_relatedPlaylists_likesStringDimension
contentDetails_relatedPlaylists_uploadsStringDimension
etagStringDimension
brandingSettings_channel_defaultTabStringDimension
kindStringDimension
snippet_countryStringDimension
snippet_descriptionStringDimension
snippet_localized_descriptionStringDimension
snippet_localized_titleStringDimension
snippet_publishedAtStringDimension
snippet_thumbnails_default_heightIntegerDimension
snippet_thumbnails_default_urlStringDimension
snippet_thumbnails_default_widthIntegerDimension
snippet_thumbnails_high_heightIntegerDimension
snippet_thumbnails_high_urlStringDimension
snippet_thumbnails_high_widthIntegerDimension
snippet_thumbnails_medium_heightIntegerDimension
snippet_thumbnails_medium_urlStringDimension
snippet_thumbnails_medium_widthIntegerDimension
snippet_titleStringDimension
statistics_hiddenSubscriberCountBooleanDimension
statistics_subscriberCountStringDimension
statistics_videoCountStringDimension
statistics_viewCountStringDimension
status_isLinkedBooleanDimension
status_longUploadsStatusStringDimension
status_privacyStatusStringDimension
topicDetails_topicCategoriesStringDimension
topicDetails_topicIdsStringDimension

Dimensions Videos

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

FieldData TypeDimension/Metric
id system schemaStringDimension
contentDetails_captionStringDimension
contentDetails_definitionStringDimension
contentDetails_dimensionStringDimension
contentDetails_durationStringDimension
contentDetails_hasCustomThumbnailBooleanDimension
contentDetails_licensedContentBooleanDimension
contentDetails_projectionStringDimension
contentDetails_regionRestriction_blockedStringDimension
etagStringDimension
fileDetails_audioStreams_bitrateBpsStringDimension
fileDetails_audioStreams_channelCountIntegerDimension
fileDetails_audioStreams_codecStringDimension
fileDetails_bitrateBpsStringDimension
fileDetails_containerStringDimension
fileDetails_durationMsStringDimension
fileDetails_fileNameStringDimension
fileDetails_fileSizeStringDimension
fileDetails_fileTypeStringDimension
fileDetails_videoStreams_aspectRatioFloatDimension
fileDetails_videoStreams_bitrateBpsStringDimension
fileDetails_videoStreams_codecStringDimension
fileDetails_videoStreams_frameRateFpsIntegerDimension
fileDetails_videoStreams_heightPixelsIntegerDimension
fileDetails_videoStreams_widthPixelsIntegerDimension
contentDetails_contentRating_ytRatingStringDimension
id_kindStringDimension
id_videoIdStringDimension
kindStringDimension
player_embedHtmlStringDimension
processingDetails_editorSuggestionsAvailabilityStringDimension
processingDetails_fileDetailsAvailabilityStringDimension
processingDetails_processingIssuesAvailabilityStringDimension
processingDetails_processingStatusStringDimension
processingDetails_tagSuggestionsAvailabilityStringDimension
processingDetails_thumbnailsAvailabilityStringDimension
snippet_categoryIdStringDimension
snippet_channelIdStringDimension
snippet_channelTitleStringDimension
snippet_descriptionStringDimension
snippet_liveBroadcastContentStringDimension
snippet_localized_descriptionStringDimension
snippet_localized_titleStringDimension
snippet_publishedAtStringDimension
snippet_tagsStringDimension
snippet_thumbnails_default_heightIntegerDimension
snippet_thumbnails_default_urlStringDimension
snippet_thumbnails_default_widthIntegerDimension
snippet_thumbnails_high_heightIntegerDimension
snippet_thumbnails_high_urlStringDimension
snippet_thumbnails_high_widthIntegerDimension
snippet_thumbnails_maxres_heightIntegerDimension
snippet_thumbnails_maxres_urlStringDimension
snippet_thumbnails_maxres_widthIntegerDimension
snippet_thumbnails_medium_heightIntegerDimension
snippet_thumbnails_medium_urlStringDimension
snippet_thumbnails_medium_widthIntegerDimension
snippet_thumbnails_standard_heightIntegerDimension
snippet_thumbnails_standard_urlStringDimension
snippet_thumbnails_standard_widthIntegerDimension
snippet_titleStringDimension
statistics_commentCountStringDimension
statistics_dislikeCountStringDimension
statistics_favoriteCountStringDimension
statistics_likeCountStringDimension
statistics_viewCountStringDimension
status_embeddableBooleanDimension
status_licenseStringDimension
status_madeForKidsBooleanDimension
status_privacyStatusStringDimension
status_publicStatsViewableBooleanDimension
status_selfDeclaredMadeForKidsBooleanDimension
status_uploadStatusStringDimension
topicDetails_topicCategoriesStringDimension

Static Operating System

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

FieldData TypeDimension/Metric
key system schemaStringDimension
typeStringDimension
valueStringDimension

Static Sharing Service

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

FieldData TypeDimension/Metric
key system schemaStringDimension
typeStringDimension
valueStringDimension

Static Traffic Source Type

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

FieldData TypeDimension/Metric
key system schemaStringDimension
typeStringDimension
valueStringDimension

Static Card Type

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

FieldData TypeDimension/Metric
key system schemaStringDimension
typeStringDimension
valueStringDimension

Static Device Type

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

FieldData TypeDimension/Metric
key system schemaStringDimension
typeStringDimension
valueStringDimension

Static Annotation Type

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

FieldData TypeDimension/Metric
key system schemaStringDimension
typeStringDimension
valueStringDimension

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.

FieldData TypeDimension/Metric
channel_id system schemaStringDimension
video_id system schemaStringDimension
subscribed_status system schemaStringDimension
province_code system schemaStringDimension
live_or_on_demand system schemaStringDimension
date system schemaIntegerDimension
country_code system schemaStringDimension
annotation_click_through_rateIntegerMetric
average_view_duration_secondsFloatMetric
card_click_rateIntegerMetric
card_clicksIntegerMetric
card_impressionsIntegerMetric
card_teaser_click_rateIntegerMetric
card_teaser_clicksIntegerMetric
card_teaser_impressionsIntegerMetric
average_view_duration_percentageFloatMetric
annotation_impressionsIntegerMetric
annotation_closesIntegerMetric
annotation_close_rateIntegerMetric
annotation_closable_impressionsIntegerMetric
red_viewsIntegerMetric
red_watch_time_minutesFloatMetric
annotation_clicksIntegerMetric
annotation_clickable_impressionsIntegerMetric
viewsIntegerMetric
watch_time_minutesFloatMetric

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.

FieldData TypeDimension/Metric
subscribed_status system schemaStringDimension
video_id system schemaStringDimension
channel_id system schemaStringDimension
country_code system schemaStringDimension
date system schemaIntegerDimension
device_type system schemaIntegerDimension
live_or_on_demand system schemaStringDimension
operating_system system schemaIntegerDimension
average_view_duration_percentageFloatMetric
red_watch_time_minutesFloatMetric
red_viewsIntegerMetric
average_view_duration_secondsFloatMetric
viewsIntegerMetric
watch_time_minutesFloatMetric

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.

FieldData TypeDimension/Metric
subscribed_status system schemaStringDimension
video_id system schemaStringDimension
channel_id system schemaStringDimension
country_code system schemaStringDimension
date system schemaIntegerDimension
live_or_on_demand system schemaStringDimension
traffic_source_type system schemaIntegerDimension
traffic_source_detail system schemaStringDimension
average_view_duration_percentageFloatMetric
red_watch_time_minutesFloatMetric
red_viewsIntegerMetric
average_view_duration_secondsFloatMetric
viewsIntegerMetric
watch_time_minutesFloatMetric

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.

FieldData TypeDimension/Metric
age_group system schemaStringDimension
channel_id system schemaStringDimension
country_code system schemaStringDimension
date system schemaIntegerDimension
gender system schemaStringDimension
live_or_on_demand system schemaStringDimension
subscribed_status system schemaStringDimension
video_id system schemaStringDimension
views_percentageFloatMetric

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.

FieldData TypeDimension/Metric
channel_id system schemaStringDimension
video_id system schemaStringDimension
subscribed_status system schemaStringDimension
live_or_on_demand system schemaStringDimension
date system schemaIntegerDimension
country_code system schemaStringDimension
annotation_click_through_rateIntegerMetric
average_view_duration_percentageFloatMetric
average_view_duration_secondsFloatMetric
card_click_rateIntegerMetric
card_clicksIntegerMetric
card_impressionsIntegerMetric
card_teaser_click_rateIntegerMetric
card_teaser_clicksIntegerMetric
card_teaser_impressionsIntegerMetric
annotation_impressionsIntegerMetric
commentsIntegerMetric
annotation_closesIntegerMetric
annotation_close_rateIntegerMetric
dislikesIntegerMetric
likesIntegerMetric
annotation_closable_impressionsIntegerMetric
red_viewsIntegerMetric
red_watch_time_minutesFloatMetric
sharesIntegerMetric
annotation_clicksIntegerMetric
subscribers_gainedIntegerMetric
subscribers_lostIntegerMetric
annotation_clickable_impressionsIntegerMetric
videos_added_to_playlistsIntegerMetric
videos_removed_from_playlistsIntegerMetric
viewsIntegerMetric
watch_time_minutesFloatMetric

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.

FieldData TypeDimension/Metric
subscribed_status system schemaStringDimension
video_id system schemaStringDimension
channel_id system schemaStringDimension
country_code system schemaStringDimension
date system schemaIntegerDimension
live_or_on_demand system schemaStringDimension
subtitle_language system schemaStringDimension
average_view_duration_percentageFloatMetric
red_watch_time_minutesFloatMetric
red_viewsIntegerMetric
average_view_duration_secondsFloatMetric
viewsIntegerMetric
watch_time_minutesFloatMetric

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.

FieldData TypeDimension/Metric
channel_id system schemaStringDimension
country_code system schemaStringDimension
date system schemaIntegerDimension
live_or_on_demand system schemaStringDimension
sharing_service system schemaIntegerDimension
subscribed_status system schemaStringDimension
video_id system schemaStringDimension
sharesIntegerMetric

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.

FieldData TypeDimension/Metric
subscribed_status system schemaStringDimension
video_id system schemaStringDimension
channel_id system schemaStringDimension
country_code system schemaStringDimension
date system schemaIntegerDimension
device_type system schemaIntegerDimension
live_or_on_demand system schemaStringDimension
operating_system system schemaIntegerDimension
playback_location_type system schemaIntegerDimension
traffic_source_type system schemaIntegerDimension
average_view_duration_percentageFloatMetric
red_watch_time_minutesFloatMetric
red_viewsIntegerMetric
average_view_duration_secondsFloatMetric
viewsIntegerMetric
watch_time_minutesFloatMetric

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.

FieldData TypeDimension/Metric
subscribed_status system schemaStringDimension
channel_id system schemaStringDimension
country_code system schemaStringDimension
date system schemaIntegerDimension
device_type system schemaIntegerDimension
live_or_on_demand system schemaStringDimension
operating_system system schemaIntegerDimension
playlist_id system schemaStringDimension
video_id system schemaStringDimension
average_view_duration_secondsIntegerMetric
playlist_startsIntegerMetric
playlist_saves_removedIntegerMetric
playlist_saves_addedIntegerMetric
viewsIntegerMetric
watch_time_minutesIntegerMetric

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.

FieldData TypeDimension/Metric
subscribed_status system schemaStringDimension
channel_id system schemaStringDimension
country_code system schemaStringDimension
date system schemaIntegerDimension
live_or_on_demand system schemaStringDimension
playback_location_detail system schemaStringDimension
playback_location_type system schemaIntegerDimension
playlist_id system schemaStringDimension
video_id system schemaStringDimension
average_view_duration_secondsIntegerMetric
playlist_startsIntegerMetric
playlist_saves_removedIntegerMetric
playlist_saves_addedIntegerMetric
viewsIntegerMetric
watch_time_minutesIntegerMetric

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.

FieldData TypeDimension/Metric
subscribed_status system schemaStringDimension
channel_id system schemaStringDimension
country_code system schemaStringDimension
date system schemaIntegerDimension
live_or_on_demand system schemaStringDimension
playlist_id system schemaStringDimension
video_id system schemaStringDimension
traffic_source_type system schemaIntegerDimension
traffic_source_detail system schemaStringDimension
average_view_duration_secondsIntegerMetric
playlist_startsIntegerMetric
playlist_saves_removedIntegerMetric
playlist_saves_addedIntegerMetric
viewsIntegerMetric
watch_time_minutesIntegerMetric

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.

FieldData TypeDimension/Metric
subscribed_status system schemaStringDimension
channel_id system schemaStringDimension
country_code system schemaStringDimension
date system schemaIntegerDimension
live_or_on_demand system schemaStringDimension
playlist_id system schemaStringDimension
video_id system schemaStringDimension
average_view_duration_secondsIntegerMetric
playlist_startsIntegerMetric
playlist_saves_removedIntegerMetric
playlist_saves_addedIntegerMetric
viewsIntegerMetric
watch_time_minutesIntegerMetric

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.

FieldData TypeDimension/Metric
subscribed_status system schemaStringDimension
video_id system schemaStringDimension
channel_id system schemaStringDimension
country_code system schemaStringDimension
date system schemaIntegerDimension
live_or_on_demand system schemaStringDimension
playback_location_detail system schemaStringDimension
playback_location_type system schemaIntegerDimension
average_view_duration_percentageFloatMetric
red_watch_time_minutesFloatMetric
red_viewsIntegerMetric
average_view_duration_secondsFloatMetric
viewsIntegerMetric
watch_time_minutesFloatMetric

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.

FieldData TypeDimension/Metric
subscribed_status system schemaStringDimension
channel_id system schemaStringDimension
country_code system schemaStringDimension
date system schemaIntegerDimension
device_type system schemaIntegerDimension
live_or_on_demand system schemaStringDimension
operating_system system schemaIntegerDimension
playback_location_type system schemaIntegerDimension
playlist_id system schemaStringDimension
video_id system schemaStringDimension
traffic_source_type system schemaIntegerDimension
average_view_duration_secondsIntegerMetric
playlist_startsIntegerMetric
playlist_saves_removedIntegerMetric
playlist_saves_addedIntegerMetric
viewsIntegerMetric
watch_time_minutesIntegerMetric

Was this article helpful?