YouTube Channel report transformation
When your YouTube Channel reports are transferred to BigQuery,the reports are transformed into the following BigQuery tablesand views.
When you view the tables and views in BigQuery, the value forsuffix is the table suffix you configured when you created thetransfer.
| 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 |
| Reach reports | ||
| Reach basic | p_channel_reach_basic_a1_suffix | channel_reach_basic_a1_suffix |
| Reach combined | p_channel_reach_combined_a1_suffix | channel_reach_combined_a1_suffix |
Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2026-02-18 UTC.