YouTube Content Owner report transformation
When your YouTube Content Owner 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 |
| System managed reports | ||
| Aggregate ad revenue per video | p_content_owner_ad_revenue_summary_a1_suffix | content_owner_ad_revenue_summary_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 |
| Claims | p_content_owner_claim_ad_revenue_summary_a1_suffix | content_owner_claim_ad_revenue_summary_a1_suffix |