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_a2_suffix channel_basic_a2_suffix
User activity by province p_channel_province_a2_suffix channel_province_a2_suffix
Playback locations p_channel_playback_location_a2_suffix channel_playback_location_a2_suffix
Traffic sources p_channel_traffic_source_a2_suffix channel_traffic_source_a2_suffix
Device type and operating system p_channel_device_os_a2_suffix channel_device_os_a2_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_a2_suffix channel_subtitles_a2_suffix
Combined p_channel_combined_a2_suffix channel_combined_a2_suffix
Playlist reports
User activity p_playlist_basic_a1_suffix playlist_basic_a1_suffix
User activity by province p_playlist_province_a1_suffix playlist_province_a1_suffix
Playback locations p_playlist_playback_location_a1_suffix playlist_playback_location_a1_suffix
Traffic sources p_playlist_traffic_source_a1_suffix playlist_traffic_source_a1_suffix
Device type and operating system p_playlist_device_os_a1_suffix playlist_device_os_a1_suffix
Combined p_playlist_combined_a1_suffix playlist_combined_a1_suffix