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 |