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 |
| Monthly global ad adjustment revenue summary | p_content_owner_global_ad_adjustment_revenue_summary_a1_suffix | content_owner_global_ad_adjustment_revenue_summary_a1_suffix |
| Monthly asset ad adjustment revenue summary | p_content_owner_asset_ad_adjustment_revenue_summary_a1_suffix | content_owner_asset_ad_adjustment_revenue_summary_a1_suffix |
| Monthly asset ad adjustment revenue | p_content_owner_asset_ad_adjustment_revenue_raw_a1_suffix | content_owner_asset_ad_adjustment_revenue_raw_a1_suffix |
| Monthly video ad adjustment revenue summary | p_content_owner_ad_adjustment_revenue_summary_a1_suffix | content_owner_ad_adjustment_revenue_summary_a1_suffix |
| Monthly video ad adjustment revenue raw | p_content_owner_ad_adjustment_revenue_raw_a1_suffix | content_owner_ad_adjustment_revenue_raw_a1_suffix |
| Monthly claim ad adjustment revenue summary | p_content_owner_claim_ad_adjustment_revenue_summary_a1_suffix | content_owner_claim_ad_adjustment_revenue_summary_a1_suffix |
| Monthly claim ad adjustment revenue | p_content_owner_claim_ad_adjustment_revenue_raw_a1_suffix | content_owner_claim_ad_adjustment_revenue_raw_a1_suffix |
| Monthly country ad adjustment revenue summary | p_content_owner_country_ad_adjustment_revenue_summary_a1_suffix | content_owner_country_ad_adjustment_revenue_summary_a1_suffix |
| Monthly day ad adjustment revenue summary | p_content_owner_day_ad_adjustment_revenue_summary_a1_suffix | content_owner_day_ad_adjustment_revenue_summary_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 music label video revenue | p_music_content_owner_red_revenue_raw_a1_suffix | music_content_owner_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 |
| 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 |
| Monthly music publisher revenue summary | p_publisher_content_owner_music_red_revenue_summary_a1_suffix | publisher_content_owner_music_red_revenue_summary_a1_suffix |
| Monthly music publisher subscription revenue summary | p_publisher_content_owner_subscriber_red_revenue_summary_a1_suffix | publisher_content_owner_subscriber_red_revenue_summary_a1_suffix |
| Monthly music publisher non-music subscription revenue summary | p_publisher_content_owner_non_music_red_revenue_summary_a1_suffix | publisher_content_owner_non_music_red_revenue_summary_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 |
| Monthly subscriptions music video revenue | p_content_owner_music_red_revenue_raw_a1_suffix | content_owner_music_red_revenue_raw_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 |
| 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 |
| Weekly music label videos revenue | p_music_content_owner_red_revenue_raw_weekly_a1_suffix | music_content_owner_red_revenue_raw_weekly_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 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 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 |
| 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 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 |
| 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 asset subscription adjustment revenue raw | p_music_content_owner_asset_red_adjustment_revenue_raw_a1_suffix | music_content_owner_asset_red_adjustment_revenue_raw_a1_suffix |
| Monthly subscriptions adjustment music video raw | p_music_content_owner_red_adjustment_revenue_raw_a1_suffix | music_content_owner_red_adjustment_revenue_raw_a1_suffix |
| Monthly music label country music subscription adjustment revenue summary | p_music_content_owner_country_music_red_adjustment_revenue_summary_a1_suffix | music_content_owner_country_music_red_adjustment_revenue_summary_a1_suffix |
| Monthly music label country non-music subscription adjustment revenue summary | p_music_content_owner_country_non_music_red_adjustment_revenue_summary_a1_suffix | music_content_owner_country_non_music_red_adjustment_revenue_summary_a1_suffix |
| Monthly non-music asset subscription adjustment revenue raw | p_content_owner_non_music_asset_red_adjustment_revenue_raw_a1_suffix | content_owner_non_music_asset_red_adjustment_revenue_raw_a1_suffix |
| Monthly non-music subscription adjustment revenue raw | p_content_owner_non_music_red_adjustment_revenue_raw_a1_suffix | content_owner_non_music_red_adjustment_revenue_raw_a1_suffix |
| Monthly music video subscription adjustment revenue raw | p_content_owner_music_video_red_adjustment_revenue_raw_a1_suffix | content_owner_music_video_red_adjustment_revenue_raw_a1_suffix |
| Monthly music asset subscription adjustment revenue raw | p_content_owner_music_asset_red_adjustment_revenue_raw_a1_suffix | content_owner_music_asset_red_adjustment_revenue_raw_a1_suffix |
| Monthly music publisher asset subscription adjustment revenue raw | p_publisher_content_owner_asset_red_adjustment_revenue_raw_a1_suffix | publisher_content_owner_asset_red_adjustment_revenue_raw_a1_suffix |
| Monthly music publisher country non-music subscription adjustment revenue summary | p_publisher_content_owner_country_non_music_red_adjustment_revenue_summary_a1_suffix | publisher_content_owner_country_non_music_red_adjustment_revenue_summary_a1_suffix |
| Monthly music publisher country music subscription adjustment revenue summary | p_publisher_content_owner_country_music_red_adjustment_revenue_summary_a1_suffix | publisher_content_owner_country_music_red_adjustment_revenue_summary_a1_suffix |
| Shorts revenue reports | ||
| Monthly YouTube Shorts music label content owner revenue summary | p_music_content_owner_shorts_revenue_summary_a1_suffix | music_content_owner_shorts_revenue_summary_a1_suffix |
| Monthly YouTube Shorts music publisher content owner revenue summary | p_publisher_content_owner_shorts_revenue_summary_a1_suffix | publisher_content_owner_shorts_revenue_summary_a1_suffix |
| Monthly YouTube Shorts global ad revenue summary | p_content_owner_shorts_global_ad_revenue_summary_a1_suffix | content_owner_shorts_global_ad_revenue_summary_a1_suffix |
| Daily YouTube Shorts ad revenue summary | p_content_owner_shorts_day_ad_revenue_summary_a1_suffix | content_owner_shorts_day_ad_revenue_summary_a1_suffix |
| Monthly YouTube Shorts country ad revenue summary | p_content_owner_shorts_country_ad_revenue_summary_a1_suffix | content_owner_shorts_country_ad_revenue_summary_a1_suffix |
| Monthly YouTube Shorts ad revenue summary | p_content_owner_shorts_ad_revenue_summary_a1_suffix | content_owner_shorts_ad_revenue_summary_a1_suffix |
| Monthly YouTube Shorts subscriptions revenue summary | p_content_owner_shorts_red_revenue_summary_a1_suffix | content_owner_shorts_red_revenue_summary_a1_suffix |
| Monthly YouTube Shorts subscriptions revenue video summary | p_content_owner_shorts_red_revenue_video_summary_a1_suffix | content_owner_shorts_red_revenue_video_summary_a1_suffix |
| Taxes withholding reports | ||
| Tax withholding | p_content_owner_tax_withholding_a1_suffix | content_owner_tax_withholding_a1_suffix |