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_a4_ `suffix`	content_owner_basic_a4_ `suffix`
User activity by province	p_content_owner_province_a3_ `suffix`	content_owner_province_3_ `suffix`
Playback locations	p_content_owner_playback_location_a3_ `suffix`	content_owner_playback_location_a3_ `suffix`
Traffic sources	p_content_owner_traffic_source_a3_ `suffix`	content_owner_traffic_source_a3_ `suffix`
Device type and operating system	p_content_owner_device_os_a3_ `suffix`	content_owner_device_os_a3_ `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_a3_ `suffix`	content_owner_subtitles_a3_ `suffix`
Combined	p_content_owner_combined_a3_ `suffix`	content_owner_combined_a3_ `suffix`
Playlist reports
User activity	p_content_owner_playlist_basic_a2_ `suffix`	content_owner_playlist_basic_a2_ `suffix`
User activity by province	p_content_owner_playlist_province_a2_ `suffix`	content_owner_playlist_province_a2_ `suffix`
Playback locations	p_content_owner_playlist_playback_location_a2_ `suffix`	content_owner_playlist_playback_location_a2
Traffic sources	p_content_owner_playlist_traffic_source_a2	content_owner_playlist_traffic_source_a2_ `suffix`
Device type and operating system	p_content_owner_playlist_device_os_a2_ `suffix`	content_owner_playlist_device_os_a2_ `suffix`
Combined	p_content_owner_playlist_combined_a2_ `suffix`	content_owner_playlist_combined_a2_ `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_a3_ `suffix`	content_owner_asset_basic_a3_ `suffix`
User activity by province	p_content_owner_asset_province_a3_ `suffix`	content_owner_asset_province_a3_ `suffix`
Video playback locations	p_content_owner_asset_playback_location_a3_ `suffix`	content_owner_asset_playback_location_a3_ `suffix`
Traffic sources	p_content_owner_asset_traffic_source_a3_ `suffix`	content_owner_asset_traffic_source_a3_ `suffix`
Device type and operating system	p_content_owner_asset_device_os_a3_ `suffix`	content_owner_asset_device_os_a3_ `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_a3_ `suffix`	content_owner_asset_combined_a3_ `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_a2_ `suffix`	content_owner_shorts_global_ad_revenue_summary_a2_ `suffix`
Daily YouTube Shorts ad revenue summary	p_content_owner_shorts_day_ad_revenue_summary_a2_ `suffix`	content_owner_shorts_day_ad_revenue_summary_a2_ `suffix`
Monthly YouTube Shorts country ad revenue summary	p_content_owner_shorts_country_ad_revenue_summary_a2_ `suffix`	content_owner_shorts_country_ad_revenue_summary_a2_ `suffix`
Monthly YouTube Shorts ad revenue summary	p_content_owner_shorts_ad_revenue_summary_a2_ `suffix`	content_owner_shorts_ad_revenue_summary_a2_ `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`
Videos reports
Daily video metadata (version 1.4)	p_content_owner_video_metadata_a4_ `suffix`	content_owner_video_metadata_a4_ `suffix`
Assets reports
Daily asset report	p_content_owner_asset_a3_ `suffix`	content_owner_asset_a3_ `suffix`
Daily asset conflicts	p_content_owner_asset_conflict_a3_ `suffix`	content_owner_asset_conflict_a3_ `suffix`
References reports
Weekly references	p_content_owner_active_references_a1_ `suffix`	content_owner_active_references_a1_ `suffix`
Claims reports
Daily claims (Version 1.2)	p_content_owner_active_claims_a3_ `suffix`	content_owner_active_claims_a3_ `suffix`