Transformasi laporan Channel YouTube
Saat laporan Channel YouTube Anda ditransfer ke BigQuery, laporan tersebut akan diubah menjadi tabel dan tabel virtual BigQuery berikut.
Saat Anda melihat tabel dan tabel virtual di BigQuery, nilai untuk suffix adalah akhiran tabel yang dikonfigurasi saat membuat transfer.
| Laporan Channel YouTube | Tabel BigQuery | Tabel virtual BigQuery |
|---|---|---|
| Laporan video | ||
| Aktivitas pengguna | p_channel_basic_a2_suffix | channel_basic_a2_suffix |
| Aktivitas pengguna berdasarkan provinsi | p_channel_province_a2_suffix | channel_province_a2_suffix |
| Lokasi pemutaran | p_channel_playback_location_a2_suffix | channel_playback_location_a2_suffix |
| Sumber lalu lintas | p_channel_traffic_source_a2_suffix | channel_traffic_source_a2_suffix |
| Jenis perangkat dan sistem operasi | p_channel_device_os_a2_suffix | channel_device_os_a2_suffix |
| Demografi penonton | p_channel_demographics_a1_suffix | channel_demographics_a1_suffix |
| Berbagi konten berdasarkan platform | p_channel_sharing_service_a1_suffix | channel_sharing_service_a1_suffix |
| Anotasi | p_channel_annotations_a1_suffix | channel_annotations_a1_suffix |
| Kartu | p_channel_cards_a1_suffix | channel_cards_a1_suffix |
| Layar akhir | p_channel_end_screens_a1_suffix | channel_end_screens_a1_suffix |
| Subtitel | p_channel_subtitles_a2_suffix | channel_subtitles_a2_suffix |
| Gabungan | p_channel_combined_a2_suffix | channel_combined_a2_suffix |
| Laporan playlist | ||
| Aktivitas pengguna | p_playlist_basic_a1_suffix | playlist_basic_a1_suffix |
| Aktivitas pengguna berdasarkan provinsi | p_playlist_province_a1_suffix | playlist_province_a1_suffix |
| Lokasi pemutaran | p_playlist_playback_location_a1_suffix | playlist_playback_location_a1_suffix |
| Sumber lalu lintas | p_playlist_traffic_source_a1_suffix | playlist_traffic_source_a1_suffix |
| Jenis perangkat dan sistem operasi | p_playlist_device_os_a1_suffix | playlist_device_os_a1_suffix |
| Gabungan | p_playlist_combined_a1_suffix | playlist_combined_a1_suffix |