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