# YouTube Analytics schema ERD

Table and field reference for the Fivetran YouTube Analytics connector.

## Table & Field Reference

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

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

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

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

### 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_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 |  |

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

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

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

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

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

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

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

### 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_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_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 |  |

### channel_reach_basic_a_1_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| date | LocalDate | PK |
| channel_id | String | FK |
| video_id | String | FK |
| video_thumbnail_impressions | Int |  |
| video_thumbnail_impressions_ctr | 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 |  |

### 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 | PK, FK |
| asset_labels | String |  |
| asset_title | String |  |
| owned_views | Long |  |
| partner_revenue | 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_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 |  |

### 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_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 |  |

### 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 | PK, FK |
| video_id | String | PK, FK |
| 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 |  |

### 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 | PK, FK |
| video_id | String | PK, FK |
| 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 |  |

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

### 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_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_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 |  |

### channel_reach_combined_a_1_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| date | LocalDate | PK |
| channel_id | String | FK |
| video_id | String | FK |
| device_type | Int |  |
| operating_system | Int |  |
| traffic_source_detail | String |  |
| traffic_source_type | Int |  |
| video_thumbnail_impressions | Int |  |
| video_thumbnail_impressions_ctr | 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_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_reach_combined_a_1_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| date | LocalDate | PK |
| channel_id | String | FK |
| video_id | String | FK |
| device_type | Int |  |
| operating_system | Int |  |
| traffic_source_detail | String |  |
| traffic_source_type | Int |  |
| video_thumbnail_impressions | Int |  |
| video_thumbnail_impressions_ctr | Double |  |

### 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_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_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 |  |

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

### 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_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 |  |

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

### content_owner_reach_basic_a_1_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| date | LocalDate | PK |
| channel_id | String | FK |
| video_id | String | FK |
| video_thumbnail_impressions | Int |  |
| video_thumbnail_impressions_ctr | Double |  |

### 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_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 |  |

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

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

### caption

| Column | Type | Keys |
| --- | --- | --- |
| languages | String | PK |
| start | Double | PK |
| video_id | String | PK, FK |
| duration | Double |  |
| text | String |  |

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

### 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_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 |  |

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

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

### 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_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 |  |

### 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_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 |  |

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

### audience_retention

| Column | Type | Keys |
| --- | --- | --- |
| date | LocalDate | PK |
| elapsed_video_time_ratio | String | PK |
| video_id | String | PK, FK |
| audience_watch_ratio | Double |  |
| relative_retention_performance | 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 |  |

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

### 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 | PK, FK |
| video_id | String | PK, FK |
| 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 |  |

### 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 | PK, FK |
| asset_labels | String |  |
| asset_title | String |  |
| owned_watchtime | Double |  |
| partner_revenue | Double |  |

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

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

## Relationships

- content_owner_asset_estimated_revenue_a_1_report(channel_id) → channel(id)
- content_owner_asset_estimated_revenue_a_1_report(video_id) → video(id)
- content_owner_playlist_device_os_a_1_report(channel_id) → channel(id)
- content_owner_playlist_device_os_a_1_report(video_id) → video(id)
- channel_sharing_service_a_1_report(channel_id) → channel(id)
- channel_sharing_service_a_1_report(video_id) → video(id)
- content_owner_cards_a_1_report(channel_id) → channel(id)
- content_owner_cards_a_1_report(video_id) → video(id)
- video(snippet_channel_id) → channel(id)
- content_owner_demographics_a_1_report(channel_id) → channel(id)
- content_owner_demographics_a_1_report(video_id) → video(id)
- channel_end_screens_a_2_report(channel_id) → channel(id)
- channel_end_screens_a_2_report(video_id) → video(id)
- channel_basic_a_2_report(channel_id) → channel(id)
- channel_basic_a_2_report(video_id) → video(id)
- channel_province_a_2_report(channel_id) → channel(id)
- channel_province_a_2_report(video_id) → video(id)
- content_owner_asset_demographics_a_1_report(channel_id) → channel(id)
- content_owner_asset_demographics_a_1_report(video_id) → video(id)
- channel_combined_a_2_report(channel_id) → channel(id)
- channel_combined_a_2_report(video_id) → video(id)
- playlist_playback_location_a_1_report(channel_id) → channel(id)
- playlist_playback_location_a_1_report(video_id) → video(id)
- playlist_playback_location_a_1_report(playlist_id) → playlist(id)
- content_owner_subtitles_a_2_report(channel_id) → channel(id)
- content_owner_subtitles_a_2_report(video_id) → video(id)
- content_owner_asset_traffic_source_a_2_report(channel_id) → channel(id)
- content_owner_asset_traffic_source_a_2_report(video_id) → video(id)
- content_owner_sharing_service_a_1_report(channel_id) → channel(id)
- content_owner_sharing_service_a_1_report(video_id) → video(id)
- channel_reach_basic_a_1_report(channel_id) → channel(id)
- channel_reach_basic_a_1_report(video_id) → video(id)
- content_owner_asset_combined_a_2_report(channel_id) → channel(id)
- content_owner_asset_combined_a_2_report(video_id) → video(id)
- system_managed_content_owner_music_asset_red_revenue_raw(channel_id) → channel(id)
- content_owner_playback_location_a_2_report(channel_id) → channel(id)
- content_owner_playback_location_a_2_report(video_id) → video(id)
- content_owner_playlist_basic_a_1_report(channel_id) → channel(id)
- content_owner_playlist_basic_a_1_report(video_id) → video(id)
- playlist(snippet_channel_id) → channel(id)
- channel_traffic_source_a_2_report(channel_id) → channel(id)
- channel_traffic_source_a_2_report(video_id) → video(id)
- content_owner_annotations_a_1_report(channel_id) → channel(id)
- content_owner_annotations_a_1_report(video_id) → video(id)
- system_managed_content_owner_active_claims(channel_id) → channel(id)
- system_managed_content_owner_active_claims(video_id) → video(id)
- system_managed_content_owner_ad_revenue_raw(video_id) → video(id)
- system_managed_content_owner_ad_revenue_raw(channel_id) → channel(id)
- playlist_traffic_source_a_1_report(channel_id) → channel(id)
- playlist_traffic_source_a_1_report(video_id) → video(id)
- playlist_traffic_source_a_1_report(playlist_id) → playlist(id)
- content_owner_playlist_combined_a_1_report(channel_id) → channel(id)
- content_owner_playlist_combined_a_1_report(video_id) → video(id)
- content_owner_playlist_playback_location_a_1_report(channel_id) → channel(id)
- content_owner_playlist_playback_location_a_1_report(video_id) → video(id)
- content_owner_device_os_a_2_report(channel_id) → channel(id)
- content_owner_device_os_a_2_report(video_id) → video(id)
- channel_reach_combined_a_1_report(channel_id) → channel(id)
- channel_reach_combined_a_1_report(video_id) → video(id)
- content_owner_estimated_revenue_a_1_report(channel_id) → channel(id)
- content_owner_estimated_revenue_a_1_report(video_id) → video(id)
- content_owner_asset_device_os_a_2_report(channel_id) → channel(id)
- content_owner_asset_device_os_a_2_report(video_id) → video(id)
- content_owner_reach_combined_a_1_report(channel_id) → channel(id)
- content_owner_reach_combined_a_1_report(video_id) → video(id)
- channel_annotations_a_1_report(channel_id) → channel(id)
- channel_annotations_a_1_report(video_id) → video(id)
- channel_playback_location_a_2_report(channel_id) → channel(id)
- channel_playback_location_a_2_report(video_id) → video(id)
- content_owner_asset_province_a_2_report(channel_id) → channel(id)
- content_owner_asset_province_a_2_report(video_id) → video(id)
- content_owner_playlist_province_a_1_report(channel_id) → channel(id)
- content_owner_playlist_province_a_1_report(video_id) → video(id)
- playlist_province_a_1_report(channel_id) → channel(id)
- playlist_province_a_1_report(video_id) → video(id)
- playlist_province_a_1_report(playlist_id) → playlist(id)
- content_owner_combined_a_2_report(channel_id) → channel(id)
- content_owner_combined_a_2_report(video_id) → video(id)
- content_owner_asset_sharing_service_a_1_report(channel_id) → channel(id)
- content_owner_asset_sharing_service_a_1_report(video_id) → video(id)
- content_owner_asset_end_screens_a_1_report(channel_id) → channel(id)
- content_owner_asset_end_screens_a_1_report(video_id) → video(id)
- content_owner_reach_basic_a_1_report(channel_id) → channel(id)
- content_owner_reach_basic_a_1_report(video_id) → video(id)
- content_owner_asset_playback_location_a_2_report(channel_id) → channel(id)
- content_owner_asset_playback_location_a_2_report(video_id) → video(id)
- content_owner_playlist_traffic_source_a_1_report(channel_id) → channel(id)
- content_owner_playlist_traffic_source_a_1_report(video_id) → video(id)
- channel_cards_a_2_report(channel_id) → channel(id)
- channel_cards_a_2_report(video_id) → video(id)
- caption(video_id) → video(id)
- playlist_basic_a_1_report(channel_id) → channel(id)
- playlist_basic_a_1_report(video_id) → video(id)
- playlist_basic_a_1_report(playlist_id) → playlist(id)
- content_owner_traffic_source_a_2_report(channel_id) → channel(id)
- content_owner_traffic_source_a_2_report(video_id) → video(id)
- content_owner_asset_annotations_a_1_report(channel_id) → channel(id)
- content_owner_asset_annotations_a_1_report(video_id) → video(id)
- content_owner_asset_basic_a_2_report(channel_id) → channel(id)
- content_owner_asset_basic_a_2_report(video_id) → video(id)
- playlist_device_os_a_1_report(channel_id) → channel(id)
- playlist_device_os_a_1_report(video_id) → video(id)
- playlist_device_os_a_1_report(playlist_id) → playlist(id)
- channel_demographics_a_1_report(channel_id) → channel(id)
- channel_demographics_a_1_report(video_id) → video(id)
- content_owner_end_screens_a_1_report(channel_id) → channel(id)
- content_owner_end_screens_a_1_report(video_id) → video(id)
- content_owner_ad_rates_a_1_report(channel_id) → channel(id)
- content_owner_ad_rates_a_1_report(video_id) → video(id)
- channel_subtitles_a_2_report(channel_id) → channel(id)
- channel_subtitles_a_2_report(video_id) → video(id)
- content_owner_province_a_2_report(channel_id) → channel(id)
- content_owner_province_a_2_report(video_id) → video(id)
- content_owner_asset_cards_a_1_report(channel_id) → channel(id)
- content_owner_asset_cards_a_1_report(video_id) → video(id)
- audience_retention(video_id) → video(id)
- playlist_combined_a_1_report(channel_id) → channel(id)
- playlist_combined_a_1_report(video_id) → video(id)
- playlist_combined_a_1_report(playlist_id) → playlist(id)
- comment(snippet_channel_id) → channel(id)
- comment(video_id) → video(id)
- system_managed_content_owner_video_metadata(video_id) → video(id)
- system_managed_content_owner_video_metadata(channel_id) → channel(id)
- system_managed_content_owner_non_music_asset_red_revenue_raw(channel_id) → channel(id)
- channel_device_os_a_2_report(channel_id) → channel(id)
- channel_device_os_a_2_report(video_id) → video(id)
- content_owner_basic_a_3_report(channel_id) → channel(id)
- content_owner_basic_a_3_report(video_id) → video(id)