YouTube Analytics

Explore the interactive ERD

Table & Field Reference

channel_annotations_a_1_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`annotation_click_through_rate`	Double
`annotation_clickable_impressions`	Int
`annotation_clicks`	Int
`annotation_closable_impressions`	Int
`annotation_close_rate`	Double
`annotation_closes`	Int
`annotation_id`	String
`annotation_impressions`	Int
`annotation_type`	Int
`country_code`	String
`live_or_on_demand`	String
`subscribed_status`	String

channel

Column	Type	Keys
`id`	String	PK
`branding_settings`	String
`content_details_likes`	String
`content_details_uploads`	String
`content_owner_details`	String
`etag`	String
`kind`	String
`localizations`	String
`snippet_country`	String
`snippet_custom_url`	String
`snippet_default_language`	String
`snippet_description`	String
`snippet_localized`	String
`snippet_published_at`	LocalDateTime
`snippet_thumbnails`	String
`snippet_title`	String
`statistics_hidden_subscriber_count`	Boolean
`statistics_subscriber_count`	Long
`statistics_video_count`	Long
`statistics_view_count`	Long
`status`	String
`topic_details`	String

playlist_playback_location_a_1_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`playlist_id`	String	FK
`video_id`	String	FK
`average_view_duration_seconds`	Double
`country_code`	String
`engaged_views`	Int
`live_or_on_demand`	String
`playback_location_detail`	String
`playback_location_type`	Int
`playlist_saves_added`	Int
`playlist_saves_removed`	Int
`playlist_starts`	Int
`subscribed_status`	String
`views`	Int
`watch_time_minutes`	Double

caption

Column	Type	Keys
`languages`	String	PK
`start`	Double	PK
`video_id`	String	PKFK
`duration`	Double
`text`	String

video

Column	Type	Keys
`id`	String	PK
`snippet_channel_id`	String	FK
`content_details_caption`	String
`content_details_definition`	String
`content_details_dimension`	String
`content_details_duration`	String
`content_details_has_custom_thumbnail`	Boolean
`content_details_licensed_content`	Boolean
`content_details_projection`	String
`content_details_region_restriction`	String
`etag`	String
`kind`	String
`player_embed_height`	Long
`player_embed_html`	String
`player_embed_width`	Long
`privacy_status`	String
`snippet_category_id`	String
`snippet_channel_title`	String
`snippet_default_audio_language`	String
`snippet_default_language`	String
`snippet_description`	String
`snippet_live_broadcast_content`	String
`snippet_localized`	String
`snippet_published_at`	LocalDateTime
`snippet_tags`	String
`snippet_thumbnails`	String
`snippet_title`	String
`statistics_comment_count`	String
`statistics_dislike_count`	String
`statistics_favorite_count`	String
`statistics_like_count`	String
`statistics_view_count`	String
`status_embeddable`	Boolean
`status_failure_reason`	String
`status_license`	String
`status_made_for_kids`	Boolean
`status_public_stats_viewable`	Boolean
`status_publish_at`	LocalDateTime
`status_rejection_reason`	String
`status_self_declared_made_for_kids`	Boolean
`upload_status`	String

content_owner_end_screens_a_1_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`claimed_status`	String
`country_code`	String
`end_screen_element_click_rate`	Double
`end_screen_element_clicks`	Int
`end_screen_element_id`	String
`end_screen_element_impressions`	Int
`end_screen_element_type`	Int
`live_or_on_demand`	String
`subscribed_status`	String
`uploader_type`	String

content_owner_playlist_basic_a_1_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`average_view_duration_seconds`	Double
`country_code`	String
`engaged_views`	Int
`live_or_on_demand`	String
`playlist_id`	String
`playlist_saves_added`	Int
`playlist_saves_removed`	Int
`playlist_starts`	Int
`subscribed_status`	String
`views`	Int
`watch_time_minutes`	Double

system_managed_content_owner_non_music_asset_red_revenue_raw

Column	Type	Keys
`adjustment_type`	String	PK
`asset_id`	String	PK
`country`	String	PK
`custom_id`	String	PK
`day`	String	PK
`report_end_time`	Instant	PK
`report_start_time`	Instant	PK
`channel_id`	String	PKFK
`asset_labels`	String
`asset_title`	String
`owned_watchtime`	Double
`partner_revenue`	Double

channel_combined_a_2_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`average_view_duration_percentage`	Double
`average_view_duration_seconds`	Double
`country_code`	String
`device_type`	Int
`engaged_views`	Int
`live_or_on_demand`	String
`operating_system`	Int
`playback_location_type`	Int
`red_views`	Int
`red_watch_time_minutes`	Double
`subscribed_status`	String
`traffic_source_type`	Int
`views`	Int
`watch_time_minutes`	Double

channel_demographics_a_1_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`age_group`	String
`country_code`	String
`gender`	String
`live_or_on_demand`	String
`subscribed_status`	String
`views_percentage`	Double

system_managed_content_owner_ad_revenue_raw

Column	Type	Keys
`adjustment_type`	String	PK
`country_code`	String	PK
`date`	String	PK
`report_end_time`	Instant	PK
`report_start_time`	Instant	PK
`channel_id`	String	PKFK
`video_id`	String	PKFK
`category`	String
`channel_display_name`	String
`content_type`	String
`owned_views`	Long
`partner_revenue`	Double
`partner_revenue_auction`	Double
`partner_revenue_partner_sold_partner_served`	Double
`partner_revenue_partner_sold_youtube_served`	Double
`partner_revenue_reserved`	Double
`policy`	String
`uploader`	String
`video_duration_sec`	Long
`video_title`	String
`youtube_revenue_split`	Double
`youtube_revenue_split_auction`	Double
`youtube_revenue_split_partner_sold_partner_served`	Double
`youtube_revenue_split_partner_sold_youtube_served`	Double
`youtube_revenue_split_reserved`	Double

content_owner_combined_a_2_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`average_view_duration_percentage`	Double
`average_view_duration_seconds`	Double
`claimed_status`	String
`country_code`	String
`device_type`	Int
`engaged_views`	Int
`live_or_on_demand`	String
`operating_system`	Int
`playback_location_type`	Int
`red_views`	Int
`red_watch_time_minutes`	Double
`subscribed_status`	String
`traffic_source_type`	Int
`uploader_type`	String
`views`	Int
`watch_time_minutes`	Double

channel_sharing_service_a_1_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`country_code`	String
`live_or_on_demand`	String
`shares`	Int
`sharing_service`	Int
`subscribed_status`	String

channel_device_os_a_2_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`average_view_duration_percentage`	Double
`average_view_duration_seconds`	Double
`country_code`	String
`device_type`	Int
`engaged_views`	Int
`live_or_on_demand`	String
`operating_system`	Int
`red_views`	Int
`red_watch_time_minutes`	Double
`subscribed_status`	String
`views`	Int
`watch_time_minutes`	Double

system_managed_content_owner_asset_ad_revenue_raw

Column	Type	Keys
`adjustment_type`	String	PK
`asset_id`	String	PK
`country_code`	String	PK
`date`	String	PK
`report_end_time`	Instant	PK
`report_start_time`	Instant	PK
`administer_publish_rights`	Boolean
`album`	String
`artist`	String
`asset_channel_id`	String
`asset_labels`	String
`asset_title`	String
`asset_type`	String
`custom_id`	String
`director`	String
`eidr`	String
`episode_number`	String
`episode_title`	String
`grid`	String
`hfa_song_code`	String
`isrc`	String
`iswc`	String
`label`	String
`owned_views`	Long
`partner_revenue`	Double
`partner_revenue_auction`	Double
`partner_revenue_partner_sold_partner_served`	Double
`partner_revenue_partner_sold_youtube_served`	Double
`partner_revenue_reserved`	Double
`season`	String
`studio`	String
`tms`	String
`upc`	String
`writers`	String
`youtube_revenue_split`	Double
`youtube_revenue_split_auction`	Double
`youtube_revenue_split_partner_sold_partner_served`	Double
`youtube_revenue_split_partner_sold_youtube_served`	Double
`youtube_revenue_split_reserved`	Double

content_owner_sharing_service_a_1_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`claimed_status`	String
`country_code`	String
`live_or_on_demand`	String
`shares`	Int
`sharing_service`	Int
`subscribed_status`	String
`uploader_type`	String

content_owner_demographics_a_1_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`age_group`	String
`claimed_status`	String
`country_code`	String
`gender`	String
`live_or_on_demand`	String
`subscribed_status`	String
`uploader_type`	String
`views_percentage`	Double

content_owner_asset_combined_a_2_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`asset_id`	String
`average_view_duration_percentage`	Double
`average_view_duration_seconds`	Double
`claimed_status`	String
`country_code`	String
`device_type`	Int
`engaged_views`	Int
`live_or_on_demand`	String
`operating_system`	Int
`playback_location_type`	Int
`red_views`	Int
`red_watch_time_minutes`	Double
`subscribed_status`	String
`traffic_source_type`	Int
`uploader_type`	String
`views`	Int
`watch_time_minutes`	Double

content_owner_province_a_2_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`annotation_click_through_rate`	Double
`annotation_clickable_impressions`	Int
`annotation_clicks`	Int
`annotation_closable_impressions`	Int
`annotation_close_rate`	Double
`annotation_closes`	Int
`annotation_impressions`	Int
`average_view_duration_percentage`	Double
`average_view_duration_seconds`	Double
`card_click_rate`	Double
`card_clicks`	Int
`card_impressions`	Int
`card_teaser_click_rate`	Double
`card_teaser_clicks`	Int
`card_teaser_impressions`	Int
`claimed_status`	String
`country_code`	String
`engaged_views`	Int
`live_or_on_demand`	String
`province_code`	String
`red_views`	Int
`red_watch_time_minutes`	Double
`subscribed_status`	String
`uploader_type`	String
`views`	Int
`watch_time_minutes`	Double

channel_end_screens_a_2_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`country_code`	String
`end_screen_element_click_rate`	Double
`end_screen_element_clicks`	Int
`end_screen_element_id`	String
`end_screen_element_impressions`	Int
`end_screen_element_type`	Int
`live_or_on_demand`	String
`subscribed_status`	String

content_owner_traffic_source_a_2_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`average_view_duration_percentage`	Double
`average_view_duration_seconds`	Double
`claimed_status`	String
`country_code`	String
`engaged_views`	Int
`live_or_on_demand`	String
`red_views`	Int
`red_watch_time_minutes`	Double
`subscribed_status`	String
`traffic_source_detail`	String
`traffic_source_type`	Int
`uploader_type`	String
`views`	Int
`watch_time_minutes`	Double

system_managed_content_owner_active_claims

Column	Type	Keys
`asset_id`	String	PK
`asset_policy_id`	String	PK
`claim_id`	String	PK
`claim_policy_id`	String	PK
`custom_id`	String	PK
`reference_id`	String	PK
`reference_video_id`	String	PK
`report_start_time`	Instant	PK
`channel_id`	String	PKFK
`video_id`	String	PKFK
`album`	String
`artist`	String
`asset_labels`	String
`asset_policy_block`	String
`asset_policy_monetize`	String
`asset_policy_track`	String
`asset_title`	String
`channel_display_name`	String
`claim_created_date`	String
`claim_origin`	String
`claim_policy_block`	String
`claim_policy_monetize`	String
`claim_policy_track`	String
`claim_status`	String
`claim_status_detail`	String
`claim_type`	String
`content_type`	String
`director`	String
`engaged_views`	Long
`episode_number`	String
`episode_title`	String
`grid`	String
`hfa_song_code`	String
`is_shorts_eligible`	String
`isrc`	String
`iswc`	String
`longest_match`	Long
`matching_duration`	Long
`record_label`	String
`release_date`	String
`season`	String
`tms`	String
`upc`	String
`uploader`	String
`video_duration_sec`	Int
`video_matching_length`	Long
`video_title`	String
`video_upload_date`	String
`views`	Long
`writers`	String

content_owner_asset_playback_location_a_2_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`asset_id`	String
`average_view_duration_percentage`	Double
`average_view_duration_seconds`	Double
`claimed_status`	String
`country_code`	String
`engaged_views`	Int
`live_or_on_demand`	String
`playback_location_detail`	String
`playback_location_type`	Int
`red_views`	Int
`red_watch_time_minutes`	Double
`subscribed_status`	String
`uploader_type`	String
`views`	Int
`watch_time_minutes`	Double

content_owner_ad_rates_a_1_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`ad_impressions`	Int
`ad_type`	Int
`claimed_status`	String
`country_code`	String
`estimated_cpm`	Double
`estimated_youtube_ad_revenue`	Double
`uploader_type`	String

playlist

Column	Type	Keys
`id`	String	PK
`snippet_channel_id`	String	FK
`content_details_item_count`	Int
`etag`	String
`kind`	String
`localizations`	String
`player_embed_html`	String
`privacy_status`	String
`snippet_channel_title`	String
`snippet_default_language`	String
`snippet_description`	String
`snippet_localized`	String
`snippet_published_at`	LocalDateTime
`snippet_thumbnails`	String
`snippet_title`	String

channel_traffic_source_a_2_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`average_view_duration_percentage`	Double
`average_view_duration_seconds`	Double
`country_code`	String
`engaged_views`	Int
`live_or_on_demand`	String
`red_views`	Int
`red_watch_time_minutes`	Double
`subscribed_status`	String
`traffic_source_detail`	String
`traffic_source_type`	Int
`views`	Int
`watch_time_minutes`	Double

content_owner_playlist_province_a_1_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`average_view_duration_seconds`	Double
`country_code`	String
`engaged_views`	Int
`live_or_on_demand`	String
`playlist_id`	String
`playlist_saves_added`	Int
`playlist_saves_removed`	Int
`playlist_starts`	Int
`province_code`	String
`subscribed_status`	String
`views`	Int
`watch_time_minutes`	Double

content_owner_basic_a_3_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`annotation_click_through_rate`	Double
`annotation_clickable_impressions`	Int
`annotation_clicks`	Int
`annotation_closable_impressions`	Int
`annotation_close_rate`	Double
`annotation_closes`	Int
`annotation_impressions`	Int
`average_view_duration_percentage`	Double
`average_view_duration_seconds`	Double
`card_click_rate`	Double
`card_clicks`	Int
`card_impressions`	Int
`card_teaser_click_rate`	Double
`card_teaser_clicks`	Int
`card_teaser_impressions`	Int
`claimed_status`	String
`comments`	Int
`country_code`	String
`dislikes`	Int
`engaged_views`	Int
`likes`	Int
`live_or_on_demand`	String
`red_views`	Int
`red_watch_time_minutes`	Double
`shares`	Int
`subscribed_status`	String
`subscribers_gained`	Int
`subscribers_lost`	Int
`uploader_type`	String
`videos_added_to_playlists`	Int
`videos_removed_from_playlists`	Int
`views`	Int
`watch_time_minutes`	Double

playlist_combined_a_1_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`playlist_id`	String	FK
`video_id`	String	FK
`average_view_duration_seconds`	Double
`country_code`	String
`device_type`	Int
`engaged_views`	Int
`live_or_on_demand`	String
`operating_system`	Int
`playback_location_type`	Int
`playlist_saves_added`	Int
`playlist_saves_removed`	Int
`playlist_starts`	Int
`subscribed_status`	String
`traffic_source_type`	Int
`views`	Int
`watch_time_minutes`	Double

playlist_traffic_source_a_1_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`playlist_id`	String	FK
`video_id`	String	FK
`average_view_duration_seconds`	Double
`country_code`	String
`engaged_views`	Int
`live_or_on_demand`	String
`playlist_saves_added`	Int
`playlist_saves_removed`	Int
`playlist_starts`	Int
`subscribed_status`	String
`traffic_source_detail`	String
`traffic_source_type`	Int
`views`	Int
`watch_time_minutes`	Double

channel_subtitles_a_2_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`average_view_duration_percentage`	Double
`average_view_duration_seconds`	Double
`country_code`	String
`engaged_views`	Int
`live_or_on_demand`	String
`red_views`	Int
`red_watch_time_minutes`	Double
`subscribed_status`	String
`subtitle_language`	String
`subtitle_language_autotranslated`	String
`views`	Int
`watch_time_minutes`	Double

content_owner_asset_traffic_source_a_2_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`asset_id`	String
`average_view_duration_percentage`	Double
`average_view_duration_seconds`	Double
`claimed_status`	String
`country_code`	String
`engaged_views`	Int
`live_or_on_demand`	String
`red_views`	Int
`red_watch_time_minutes`	Double
`subscribed_status`	String
`traffic_source_detail`	String
`traffic_source_type`	Int
`uploader_type`	String
`views`	Int
`watch_time_minutes`	Double

content_owner_subtitles_a_2_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`average_view_duration_percentage`	Double
`average_view_duration_seconds`	Double
`claimed_status`	String
`country_code`	String
`engaged_views`	Int
`live_or_on_demand`	String
`red_views`	Int
`red_watch_time_minutes`	Double
`subscribed_status`	String
`subtitle_language`	String
`uploader_type`	String
`views`	Int
`watch_time_minutes`	Double

content_owner_asset_demographics_a_1_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`age_group`	String
`asset_id`	String
`claimed_status`	String
`country_code`	String
`gender`	String
`live_or_on_demand`	String
`subscribed_status`	String
`uploader_type`	String
`views_percentage`	Double

playlist_basic_a_1_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`playlist_id`	String	FK
`video_id`	String	FK
`average_view_duration_seconds`	Double
`country_code`	String
`engaged_views`	Int
`live_or_on_demand`	String
`playlist_saves_added`	Int
`playlist_saves_removed`	Int
`playlist_starts`	Int
`subscribed_status`	String
`views`	Int
`watch_time_minutes`	Double

content_owner_asset_sharing_service_a_1_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`asset_id`	String
`claimed_status`	String
`country_code`	String
`live_or_on_demand`	String
`shares`	Int
`sharing_service`	Int
`subscribed_status`	String
`uploader_type`	String

content_owner_asset_end_screens_a_1_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`asset_id`	String
`claimed_status`	String
`country_code`	String
`end_screen_element_click_rate`	Double
`end_screen_element_clicks`	Int
`end_screen_element_id`	String
`end_screen_element_impressions`	Int
`end_screen_element_type`	Int
`live_or_on_demand`	String
`subscribed_status`	String
`uploader_type`	String

comment

Column	Type	Keys
`id`	String	PK
`snippet_channel_id`	String	FK
`video_id`	String	FK
`can_reply`	Boolean
`etag`	String
`is_public`	Boolean
`kind`	String
`snippet_author_channel_id`	String
`snippet_author_channel_url`	String
`snippet_author_display_name`	String
`snippet_author_profile_image_url`	String
`snippet_can_rate`	Boolean
`snippet_like_count`	Int
`snippet_moderation_status`	String
`snippet_parent_id`	String
`snippet_published_at`	LocalDateTime
`snippet_text_display`	String
`snippet_text_original`	String
`snippet_updated_at`	LocalDateTime
`snippet_viewer_rating`	String
`total_reply_count`	Int

content_owner_annotations_a_1_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`annotation_click_through_rate`	Double
`annotation_clickable_impressions`	Int
`annotation_clicks`	Int
`annotation_closable_impressions`	Int
`annotation_close_rate`	Double
`annotation_closes`	Int
`annotation_id`	String
`annotation_impressions`	Int
`annotation_type`	Int
`claimed_status`	String
`country_code`	String
`live_or_on_demand`	String
`subscribed_status`	String
`uploader_type`	String

content_owner_playlist_traffic_source_a_1_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`average_view_duration_seconds`	Double
`country_code`	String
`engaged_views`	Int
`live_or_on_demand`	String
`playlist_id`	String
`playlist_saves_added`	Int
`playlist_saves_removed`	Int
`playlist_starts`	Int
`subscribed_status`	String
`traffic_source_detail`	String
`traffic_source_type`	Int
`views`	Int
`watch_time_minutes`	Double

system_managed_content_owner_music_asset_red_revenue_raw

Column	Type	Keys
`adjustment_type`	String	PK
`asset_id`	String	PK
`country`	String	PK
`custom_id`	String	PK
`date_id`	String	PK
`report_start_time`	Instant	PK
`channel_id`	String	PKFK
`asset_labels`	String
`asset_title`	String
`owned_views`	Long
`partner_revenue`	Double

channel_playback_location_a_2_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`average_view_duration_percentage`	Double
`average_view_duration_seconds`	Double
`country_code`	String
`engaged_views`	Int
`live_or_on_demand`	String
`playback_location_detail`	String
`playback_location_type`	Int
`red_views`	Int
`red_watch_time_minutes`	Double
`subscribed_status`	String
`views`	Int
`watch_time_minutes`	Double

content_owner_playlist_playback_location_a_1_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`average_view_duration_seconds`	Double
`country_code`	String
`engaged_views`	Int
`live_or_on_demand`	String
`playback_location_detail`	String
`playback_location_type`	Int
`playlist_id`	String
`playlist_saves_added`	Int
`playlist_saves_removed`	Int
`playlist_starts`	Int
`subscribed_status`	String
`views`	Int
`watch_time_minutes`	Double

content_owner_cards_a_1_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`card_click_rate`	Double
`card_clicks`	Int
`card_id`	String
`card_impressions`	Int
`card_teaser_click_rate`	Double
`card_teaser_clicks`	Int
`card_teaser_impressions`	Int
`card_type`	Int
`claimed_status`	String
`country_code`	String
`live_or_on_demand`	String
`subscribed_status`	String
`uploader_type`	String

playlist_province_a_1_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`playlist_id`	String	FK
`video_id`	String	FK
`average_view_duration_seconds`	Double
`country_code`	String
`engaged_views`	Int
`live_or_on_demand`	String
`playlist_saves_added`	Int
`playlist_saves_removed`	Int
`playlist_starts`	Int
`province_code`	String
`subscribed_status`	String
`views`	Int
`watch_time_minutes`	Double

content_owner_estimated_revenue_a_1_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`ad_impressions`	Int
`claimed_status`	String
`country_code`	String
`estimated_cpm`	Double
`estimated_monetized_playbacks`	Double
`estimated_partner_ad_auction_revenue`	Double
`estimated_partner_ad_reserved_revenue`	Double
`estimated_partner_ad_revenue`	Double
`estimated_partner_red_revenue`	Double
`estimated_partner_revenue`	Double
`estimated_partner_transaction_revenue`	Double
`estimated_playback_based_cpm`	Double
`estimated_youtube_ad_revenue`	Double
`uploader_type`	String

content_owner_playlist_device_os_a_1_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`average_view_duration_seconds`	Double
`country_code`	String
`device_type`	Int
`engaged_views`	Int
`live_or_on_demand`	String
`operating_system`	Int
`playlist_id`	String
`playlist_saves_added`	Int
`playlist_saves_removed`	Int
`playlist_starts`	Int
`subscribed_status`	String
`views`	Int
`watch_time_minutes`	Double

system_managed_content_owner_video_metadata

Column	Type	Keys
`asset_id`	String	PK
`claim_id`	String	PK
`custom_id`	String	PK
`report_start_time`	Instant	PK
`channel_id`	String	PKFK
`video_id`	String	PKFK
`category`	String
`channel_display_name`	String
`claim_origin`	String
`claimed_by_this_owner`	String
`comments`	Long
`comments_allowed`	String
`content_type`	String
`display_ads_enabled`	String
`effective_policy`	String
`eidr`	String
`embedding_allowed`	String
`engaged_views`	Long
`in_video_ads_enabled`	String
`is_made_for_kids_effective_setting`	String
`is_made_for_kids_modifiable`	String
`is_made_for_kids_user_selection`	String
`isrc`	String
`long_nonskippable_video_ads_enabled`	String
`midrolls_enabled`	String
`nonskippable_video_ads_enabled`	String
`offweb_syndicatable`	String
`other_owners_claiming`	String
`overlay_ads_enabled`	String
`postrolls_enabled`	String
`prerolls_enabled`	String
`ratings_allowed`	String
`skippable_video_ads_enabled`	String
`sponsored_cards_enabled`	String
`third_party_ads_enabled`	String
`third_party_video_id`	String
`time_published`	String
`time_uploaded`	String
`upload_source`	String
`video_length`	String
`video_privacy_status`	String
`video_title`	String
`video_url`	String
`views`	Long

content_owner_asset_device_os_a_2_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`asset_id`	String
`average_view_duration_percentage`	Double
`average_view_duration_seconds`	Double
`claimed_status`	String
`country_code`	String
`device_type`	Int
`engaged_views`	Int
`live_or_on_demand`	String
`operating_system`	Int
`red_views`	Int
`red_watch_time_minutes`	Double
`subscribed_status`	String
`uploader_type`	String
`views`	Int
`watch_time_minutes`	Double

content_owner_playlist_combined_a_1_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`average_view_duration_seconds`	Double
`country_code`	String
`device_type`	Int
`engaged_views`	Int
`live_or_on_demand`	String
`operating_system`	Int
`playback_location_type`	Int
`playlist_id`	String
`playlist_saves_added`	Int
`playlist_saves_removed`	Int
`playlist_starts`	Int
`subscribed_status`	String
`traffic_source_type`	Int
`views`	Int
`watch_time_minutes`	Double

content_owner_playback_location_a_2_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`average_view_duration_percentage`	Double
`average_view_duration_seconds`	Double
`claimed_status`	String
`country_code`	String
`engaged_views`	Int
`live_or_on_demand`	String
`playback_location_detail`	String
`playback_location_type`	Int
`red_views`	Int
`red_watch_time_minutes`	Double
`subscribed_status`	String
`uploader_type`	String
`views`	Int
`watch_time_minutes`	Double

content_owner_device_os_a_2_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`average_view_duration_percentage`	Double
`average_view_duration_seconds`	Double
`claimed_status`	String
`country_code`	String
`device_type`	Int
`engaged_views`	Int
`live_or_on_demand`	String
`operating_system`	Int
`red_views`	Int
`red_watch_time_minutes`	Double
`subscribed_status`	String
`uploader_type`	String
`views`	Int
`watch_time_minutes`	Double

content_owner_asset_estimated_revenue_a_1_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`asset_id`	String
`claimed_status`	String
`country_code`	String
`estimated_partner_ad_auction_revenue`	Double
`estimated_partner_ad_reserved_revenue`	Double
`estimated_partner_ad_revenue`	Double
`estimated_partner_red_revenue`	Double
`estimated_partner_revenue`	Double
`estimated_partner_transaction_revenue`	Double
`uploader_type`	String

channel_basic_a_2_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`annotation_click_through_rate`	Double
`annotation_clickable_impressions`	Int
`annotation_clicks`	Int
`annotation_closable_impressions`	Int
`annotation_close_rate`	Double
`annotation_closes`	Int
`annotation_impressions`	Int
`average_view_duration_percentage`	Double
`average_view_duration_seconds`	Double
`card_click_rate`	Double
`card_clicks`	Int
`card_impressions`	Int
`card_teaser_click_rate`	Double
`card_teaser_clicks`	Int
`card_teaser_impressions`	Int
`comments`	Int
`country_code`	String
`dislikes`	Int
`engaged_views`	Int
`likes`	Int
`live_or_on_demand`	String
`red_views`	Int
`red_watch_time_minutes`	Double
`shares`	Int
`subscribed_status`	String
`subscribers_gained`	Int
`subscribers_lost`	Int
`videos_added_to_playlists`	Int
`videos_removed_from_playlists`	Int
`views`	Int
`watch_time_minutes`	Double

system_managed_content_owner_asset

Column	Type	Keys
`active_reference_id`	String	PK
`asset_id`	String	PK
`constituent_asset_id`	String	PK
`custom_id`	String	PK
`inactive_reference_id`	String	PK
`report_start_time`	Instant	PK
`active_claims`	Int
`approx_daily_engaged_views`	Double
`approx_daily_views`	Double
`asset_labels`	String
`asset_type`	String
`conflicting_country_code`	String
`conflicting_owner`	String
`display_isrc`	String
`episode_title`	String
`is_merged`	Boolean
`match_policy`	String
`metadata_origination`	String
`other_isrc`	String
`ownership`	String
`season`	String
`sr_approx_daily_engaged_views`	Double
`tms`	String
`your_isrc`	String

content_owner_asset_cards_a_1_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`asset_id`	String
`card_click_rate`	Double
`card_clicks`	Int
`card_id`	String
`card_impressions`	Int
`card_teaser_click_rate`	Double
`card_teaser_clicks`	Int
`card_teaser_impressions`	Int
`card_type`	Int
`claimed_status`	String
`country_code`	String
`live_or_on_demand`	String
`subscribed_status`	String
`uploader_type`	String

content_owner_asset_province_a_2_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`annotation_click_through_rate`	Double
`annotation_clickable_impressions`	Int
`annotation_clicks`	Int
`annotation_closable_impressions`	Int
`annotation_close_rate`	Double
`annotation_closes`	Int
`annotation_impressions`	Int
`asset_id`	String
`average_view_duration_percentage`	Double
`average_view_duration_seconds`	Double
`card_click_rate`	Double
`card_clicks`	Int
`card_impressions`	Int
`card_teaser_click_rate`	Double
`card_teaser_clicks`	Int
`card_teaser_impressions`	Int
`claimed_status`	String
`country_code`	String
`engaged_views`	Int
`live_or_on_demand`	String
`province_code`	String
`red_views`	Int
`red_watch_time_minutes`	Double
`subscribed_status`	String
`uploader_type`	String
`views`	Int
`watch_time_minutes`	Double

channel_cards_a_2_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`card_click_rate`	Double
`card_clicks`	Int
`card_id`	String
`card_impressions`	Int
`card_teaser_click_rate`	Double
`card_teaser_clicks`	Int
`card_teaser_impressions`	Int
`card_type`	Int
`country_code`	String
`live_or_on_demand`	String
`subscribed_status`	String

audience_retention

Column	Type	Keys
`date`	LocalDate	PK
`elapsed_video_time_ratio`	String	PK
`video_id`	String	PKFK
`audience_watch_ratio`	Double
`relative_retention_performance`	Double

channel_province_a_2_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`annotation_click_through_rate`	Double
`annotation_clickable_impressions`	Int
`annotation_clicks`	Int
`annotation_closable_impressions`	Int
`annotation_close_rate`	Double
`annotation_closes`	Int
`annotation_impressions`	Int
`average_view_duration_percentage`	Double
`average_view_duration_seconds`	Double
`card_click_rate`	Double
`card_clicks`	Int
`card_impressions`	Int
`card_teaser_click_rate`	Double
`card_teaser_clicks`	Int
`card_teaser_impressions`	Int
`country_code`	String
`engaged_views`	Int
`live_or_on_demand`	String
`province_code`	String
`red_views`	Int
`red_watch_time_minutes`	Double
`subscribed_status`	String
`views`	Int
`watch_time_minutes`	Double

content_owner_asset_annotations_a_1_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`annotation_click_through_rate`	Double
`annotation_clickable_impressions`	Int
`annotation_clicks`	Int
`annotation_closable_impressions`	Int
`annotation_close_rate`	Double
`annotation_closes`	Int
`annotation_impressions`	Int
`annotation_title`	String
`annotation_type`	Int
`asset_id`	String
`claimed_status`	String
`country_code`	String
`live_or_on_demand`	String
`subscribed_status`	String
`uploader_type`	String

content_owner_asset_basic_a_2_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`video_id`	String	FK
`annotation_click_through_rate`	Double
`annotation_clickable_impressions`	Int
`annotation_clicks`	Int
`annotation_closable_impressions`	Int
`annotation_close_rate`	Double
`annotation_closes`	Int
`annotation_impressions`	Int
`asset_id`	String
`average_view_duration_percentage`	Double
`average_view_duration_seconds`	Double
`card_click_rate`	Double
`card_clicks`	Int
`card_impressions`	Int
`card_teaser_click_rate`	Double
`card_teaser_clicks`	Int
`card_teaser_impressions`	Int
`claimed_status`	String
`comments`	Int
`country_code`	String
`dislikes`	Int
`engaged_views`	Int
`likes`	Int
`live_or_on_demand`	String
`red_views`	Int
`red_watch_time_minutes`	Double
`shares`	Int
`subscribed_status`	String
`uploader_type`	String
`videos_added_to_playlists`	Int
`videos_removed_from_playlists`	Int
`views`	Int
`watch_time_minutes`	Double

playlist_device_os_a_1_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`channel_id`	String	FK
`playlist_id`	String	FK
`video_id`	String	FK
`average_view_duration_seconds`	Double
`country_code`	String
`device_type`	Int
`engaged_views`	Int
`live_or_on_demand`	String
`operating_system`	Int
`playlist_saves_added`	Int
`playlist_saves_removed`	Int
`playlist_starts`	Int
`subscribed_status`	String
`views`	Int
`watch_time_minutes`	Double