YouTube Content Owner report transformation
When your YouTube Content Owner or system-managed reports are transferred to BigQuery, the reports are transformed into the following BigQuery tables and views.
When you view the tables and views in BigQuery, the value for suffix is the table suffix you configured when you created the transfer.
| YouTube Content Owner report | BigQuery table | BigQuery view |
|---|---|---|
| Video reports | ||
| User activity | p_content_owner_basic_a3_suffix | content_owner_basic_a3_suffix |
| User activity by province | p_content_owner_province_a2_suffix | content_owner_province_a2_suffix |
| Playback locations | p_content_owner_playback_location_a2_suffix | content_owner_playback_location_a2_suffix |
| Traffic sources | p_content_owner_traffic_source_a2_suffix | content_owner_traffic_source_a2_suffix |
| Device type and operating system | p_content_owner_device_os_a2_suffix | content_owner_device_os_a2_suffix |
| Viewer demographics | p_content_owner_demographics_a1_suffix | content_owner_demographics_a1_suffix |
| Content sharing by platform | p_content_owner_sharing_service_a1_suffix | content_owner_sharing_service_a1_suffix |
| Annotations | p_content_owner_annotations_a1_suffix | content_owner_annotations_a1_suffix |
| Cards | p_content_owner_cards_a1_suffix | content_owner_cards_a1_suffix |
| End screens | p_content_owner_end_screens_a1_suffix | content_owner_end_screens_a1_suffix |
| Subtitles | p_content_owner_subtitles_a2_suffix | content_owner_subtitles_a2_suffix |
| Combined | p_content_owner_combined_a2_suffix | content_owner_combined_a2_suffix |
| Playlist reports | ||
| User activity | p_content_owner_playlist_basic_a1_suffix | content_owner_playlist_basic_a1_suffix |
| User activity by province | p_content_owner_playlist_province_a1_suffix | content_owner_playlist_province_a1_suffix |
| Playback locations | p_content_owner_playlist_playback_location_a1_suffix | content_owner_playlist_playback_location_a1 |
| Traffic sources | p_content_owner_playlist_traffic_source_a1 | content_owner_playlist_traffic_source_a1_suffix |
| Device type and operating system | p_content_owner_playlist_device_os_a1_suffix | content_owner_playlist_device_os_a1_suffix |
| Combined | p_content_owner_playlist_combined_a1_suffix | content_owner_playlist_combined_a1_suffix |
| Ad rate reports | ||
| Ad rate reports | p_content_owner_ad_rates_a1_suffix | content_owner_ad_rates_a1_suffix |
| Estimated revenue reports | ||
| Estimated video revenue | p_content_owner_estimated_revenue_a1_suffix | content_owner_estimated_revenue_a1_suffix |
| Estimated asset revenue | p_content_owner_asset_estimated_revenue_a1_suffix | content_owner_asset_estimated_revenue_a1_suffix |
| Asset reports | ||
| User activity | p_content_owner_asset_basic_a2_suffix | content_owner_asset_basic_a2_suffix |
| User activity by province | p_content_owner_asset_province_a2_suffix | content_owner_asset_province_a2_suffix |
| Video playback locations | p_content_owner_asset_playback_location_a2_suffix | content_owner_asset_playback_location_a2_suffix |
| Traffic sources | p_content_owner_asset_traffic_source_a2_suffix | content_owner_asset_traffic_source_a2_suffix |
| Device type and operating system | p_content_owner_asset_device_os_a2_suffix | content_owner_asset_device_os_a2_suffix |
| Viewer demographics | p_content_owner_asset_demographics_a1_suffix | content_owner_asset_demographics_a1_suffix |
| Content sharing by platform | p_content_owner_asset_sharing_service_a1_suffix | content_owner_asset_sharing_service_a1_suffix |
| Annotations | p_content_owner_asset_annotations_a1_suffix | content_owner_asset_annotations_a1_suffix |
| Cards | p_content_owner_asset_cards_a1_suffix | content_owner_asset_cards_a1_suffix |
| End screens | p_content_owner_asset_end_screens_a1_suffix | content_owner_asset_end_screens_a1_suffix |
| Combined | p_content_owner_asset_combined_a2_suffix | content_owner_asset_combined_a2_suffix |
| Youtube System-managed reports | BigQuery table | BigQuery view |
|---|---|---|
| Ads revenue reports | ||
| Monthly global ad revenue summary | p_content_owner_global_ad_revenue_summary_a1_suffix | content_owner_global_ad_revenue_summary_a1_suffix |
| Monthly country ad revenue summary | p_content_owner_country_ad_revenue_summary_a1_suffix | content_owner_country_ad_revenue_summary_a1_suffix |
| Monthly day ad revenue summary | p_content_owner_day_ad_revenue_summary_a1_suffix | content_owner_day_ad_revenue_summary_a1_suffix |
| Weekly global ad revenue summary | p_content_owner_global_ad_revenue_summary_weekly_a1_suffix | content_owner_global_ad_revenue_summary_weekly_a1_suffix |
| Weekly country ad revenue summary | p_content_owner_country_ad_revenue_summary_weekly_a1_suffix | content_owner_country_ad_revenue_summary_weekly_a1_suffix |
| Weekly day ad revenue summary | p_content_owner_day_ad_revenue_summary_weekly_a1_suffix | content_owner_day_ad_revenue_summary_weekly_a1_suffix |
| Aggregate ad revenue per video | p_content_owner_ad_revenue_summary_a1_suffix | content_owner_ad_revenue_summary_a1_suffix |
| Weekly video ad revenue summary | p_content_owner_ad_revenue_summary_weekly_a1_suffix | content_owner_ad_revenue_summary_weekly_a1_suffix |
| Weekly video ad revenue | p_content_owner_ad_revenue_raw_weekly_a1_suffix | content_owner_ad_revenue_raw_weekly_a1_suffix |
| Daily ad revenue per video | p_content_owner_ad_revenue_raw_a1_suffix | content_owner_ad_revenue_raw_a1_suffix |
| Aggregate ad revenue per asset | p_content_owner_asset_ad_revenue_summary_a1_suffix | content_owner_asset_ad_revenue_summary_a1_suffix |
| Daily ad revenue per asset | p_content_owner_asset_ad_revenue_raw_a1_suffix | content_owner_asset_ad_revenue_raw_a1_suffix |
| Monthly claim ad revenue summary | p_content_owner_claim_ad_revenue_summary_a1_suffix | content_owner_claim_ad_revenue_summary_a1_suffix |
| Weekly claim ad revenue summary | p_content_owner_claim_ad_revenue_summary_weekly_a1_suffix | content_owner_claim_ad_revenue_summary_weekly_a1_suffix |
| Monthly claim ad revenue | p_content_owner_claim_ad_revenue_raw_a1_suffix | content_owner_claim_ad_revenue_raw_a1_suffix |
| Weekly claim ad revenue | p_content_owner_claim_ad_revenue_raw_weekly_a1_suffix | content_owner_claim_ad_revenue_raw_weekly_a1_suffix |
| Subscription revenue reports | ||
| Monthly music revenue summary | p_content_owner_country_music_red_revenue_summary_a1_suffix | content_owner_country_music_red_revenue_summary_a1_suffix |
| Monthly non-music summary | p_content_owner_country_non_music_red_revenue_summary_a1_suffix | content_owner_country_non_music_red_revenue_summary_a1_suffix |
| Monthly subscriptions music assets revenue | p_content_owner_music_asset_red_revenue_raw_a1_suffix | content_owner_music_asset_red_revenue_raw_a1_suffix |
| Monthly subscriptions music videos revenue | p_content_owner_music_red_revenue_raw_a1_suffix | content_owner_music_red_revenue_raw_a1_suffix |
| Monthly subscriptions non-music assets revenue | p_content_owner_non_music_asset_red_revenue_raw_a1_suffix | content_owner_non_music_asset_red_revenue_raw_a1_suffix |
| Monthly subscriptions non-music videos revenue | p_content_owner_non_music_red_revenue_raw_a1_suffix | content_owner_non_music_red_revenue_raw_a1_suffix |
| Monthly music label assets revenue | p_music_content_owner_asset_red_revenue_raw_a1_suffix | music_content_owner_asset_red_revenue_raw_a1_suffix |
| Weekly music label assets revenue | p_music_content_owner_asset_red_revenue_raw_weekly_a1_suffix | music_content_owner_asset_red_revenue_raw_weekly_a1_suffix |
| Monthly music label music revenue summary | p_music_content_owner_country_music_red_revenue_summary_a1_suffix | music_content_owner_country_music_red_revenue_summary_a1_suffix |
| Weekly music revenue summary | p_music_content_owner_country_music_red_revenue_summary_weekly_a1_suffix | music_content_owner_country_music_red_revenue_summary_weekly_a1_suffix |
| Monthly music label non-music revenue summary | p_music_content_owner_country_non_music_red_revenue_summary_a1_suffix | music_content_owner_country_non_music_red_revenue_summary_a1_suffix |
| Weekly non-music revenue summary | p_music_content_owner_country_non_music_red_revenue_summary_weekly_a1_suffix | music_content_owner_country_non_music_red_revenue_summary_weekly_a1_suffix |
| Monthly music label video revenue | p_music_content_owner_red_revenue_raw_a1_suffix | music_content_owner_red_revenue_raw_a1_suffix |
| Weekly music label videos revenue | p_music_content_owner_red_revenue_raw_weekly_a1_suffix | music_content_owner_red_revenue_raw_weekly_a1_suffix |
| Monthly music label subscriber revenue summary | p_music_content_owner_subscriber_red_revenue_summary_a1_suffix | music_content_owner_subscriber_red_revenue_summary_a1_suffix |