YouTube Channel report transformation

When your YouTube Channel 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 Channel report	BigQuery table	BigQuery view
Video reports
User activity	p_channel_basic_a3_ `suffix`	channel_basic_a3_ `suffix`
User activity by province	p_channel_province_a3_ `suffix`	channel_province_a3_ `suffix`
Playback locations	p_channel_playback_location_a3_ `suffix`	channel_playback_location_a3_ `suffix`
Traffic sources	p_channel_traffic_source_a3_ `suffix`	channel_traffic_source_a3_ `suffix`
Device type and operating system	p_channel_device_os_a3_ `suffix`	channel_device_os_a3_ `suffix`
Viewer demographics	p_channel_demographics_a1_ `suffix`	channel_demographics_a1_ `suffix`
Content sharing by platform	p_channel_sharing_service_a1_ `suffix`	channel_sharing_service_a1_ `suffix`
Annotations	p_channel_annotations_a1_ `suffix`	channel_annotations_a1_ `suffix`
Cards	p_channel_cards_a1_ `suffix`	channel_cards_a1_ `suffix`
End screens	p_channel_end_screens_a1_ `suffix`	channel_end_screens_a1_ `suffix`
Subtitles	p_channel_subtitles_a3_ `suffix`	channel_subtitles_a3_ `suffix`
Combined	p_channel_combined_a3_ `suffix`	channel_combined_a3_ `suffix`
Playlist reports
User activity	p_playlist_basic_a2_ `suffix`	playlist_basic_a2_ `suffix`
User activity by province	p_playlist_province_a2_ `suffix`	playlist_province_a2_ `suffix`
Playback locations	p_playlist_playback_location_a2_ `suffix`	playlist_playback_location_a2_ `suffix`
Traffic sources	p_playlist_traffic_source_a2_ `suffix`	playlist_traffic_source_a2_ `suffix`
Device type and operating system	p_playlist_device_os_a2_ `suffix`	playlist_device_os_a2_ `suffix`
Combined	p_playlist_combined_a2_ `suffix`	playlist_combined_a2_ `suffix`