Transformasi laporan Pemilik Konten YouTube
Saat laporan Pemilik Konten YouTube atau laporan yang dikelola sistem ditransfer ke BigQuery, laporan tersebut akan diubah menjadi tabel dan tabel virtual BigQuery seperti berikut.
Saat Anda melihat tabel dan tabel virtual di BigQuery, nilai untuk suffix adalah akhiran tabel yang dikonfigurasi saat membuat transfer.
Laporan Pemilik Konten YouTube | Tabel BigQuery | Tabel virtual BigQuery |
---|---|---|
Laporan video | ||
Aktivitas pengguna | p_content_owner_basic_a3_suffix | content_owner_basic_a3_suffix |
Aktivitas pengguna berdasarkan provinsi | p_content_owner_province_a2_suffix | content_owner_province_a2_suffix |
Lokasi pemutaran | p_content_owner_playback_location_a2_suffix | content_owner_playback_location_a2_suffix |
Sumber lalu lintas | p_content_owner_traffic_source_a2_suffix | content_owner_traffic_source_a2_suffix |
Jenis perangkat dan sistem operasi | p_content_owner_device_os_a2_suffix | content_owner_device_os_a2_suffix |
Demografi penonton | p_content_owner_demographics_a1_suffix | content_owner_demographics_a1_suffix |
Berbagi konten berdasarkan platform | p_content_owner_sharing_service_a1_suffix | content_owner_sharing_service_a1_suffix |
Anotasi | p_content_owner_annotations_a1_suffix | content_owner_annotations_a1_suffix |
Kartu | p_content_owner_cards_a1_suffix | content_owner_cards_a1_suffix |
Layar akhir | p_content_owner_end_screens_a1_suffix | content_owner_end_screens_a1_suffix |
Subtitel | p_content_owner_subtitles_a2_suffix | content_owner_subtitles_a2_suffix |
Gabungan | p_content_owner_combined_a2_suffix | content_owner_combined_a2_suffix |
Laporan playlist | ||
Aktivitas pengguna | p_content_owner_playlist_basic_a1_suffix | content_owner_playlist_basic_a1_suffix |
Aktivitas pengguna berdasarkan provinsi | p_content_owner_playlist_province_a1_suffix | content_owner_playlist_province_a1_suffix |
Lokasi pemutaran | p_content_owner_playlist_playback_location_a1_suffix | content_owner_playlist_playback_location_a1 |
Sumber lalu lintas | p_content_owner_playlist_traffic_source_a1 | content_owner_playlist_traffic_source_a1_suffix |
Jenis perangkat dan sistem operasi | p_content_owner_playlist_device_os_a1_suffix | content_owner_playlist_device_os_a1_suffix |
Gabungan | p_content_owner_playlist_combined_a1_suffix | content_owner_playlist_combined_a1_suffix |
Laporan rasio iklan | ||
Laporan rasio iklan | p_content_owner_ad_rates_a1_suffix | content_owner_ad_rates_a1_suffix |
Laporan estimasi pendapatan | ||
Estimasi pendapatan video | p_content_owner_estimated_revenue_a1_suffix | content_owner_estimated_revenue_a1_suffix |
Estimasi pendapatan aset | p_content_owner_asset_estimated_revenue_a1_suffix | content_owner_asset_estimated_revenue_a1_suffix |
Laporan aset | ||
Aktivitas pengguna | p_content_owner_asset_basic_a2_suffix | content_owner_asset_basic_a2_suffix |
Aktivitas pengguna berdasarkan provinsi | p_content_owner_asset_province_a2_suffix | content_owner_asset_province_a2_suffix |
Lokasi pemutaran video | p_content_owner_asset_playback_location_a2_suffix | content_owner_asset_playback_location_a2_suffix |
Sumber lalu lintas | p_content_owner_asset_traffic_source_a2_suffix | content_owner_asset_traffic_source_a2_suffix |
Jenis perangkat dan sistem operasi | p_content_owner_asset_device_os_a2_suffix | content_owner_asset_device_os_a2_suffix |
Demografi penonton | p_content_owner_asset_demographics_a1_suffix | content_owner_asset_demographics_a1_suffix |
Berbagi konten berdasarkan platform | p_content_owner_asset_sharing_service_a1_suffix | content_owner_asset_sharing_service_a1_suffix |
Anotasi | p_content_owner_asset_annotations_a1_suffix | content_owner_asset_annotations_a1_suffix |
Kartu | p_content_owner_asset_cards_a1_suffix | content_owner_asset_cards_a1_suffix |
Layar akhir | p_content_owner_asset_end_screens_a1_suffix | content_owner_asset_end_screens_a1_suffix |
Gabungan | p_content_owner_asset_combined_a2_suffix | content_owner_asset_combined_a2_suffix |
Laporan yang dikelola Sistem YouTube | Tabel BigQuery | Tabel virtual BigQuery |
---|---|---|
Laporan pendapatan iklan | ||
Ringkasan pendapatan iklan global bulanan | p_content_owner_global_ad_revenue_summary_a1_suffix | content_owner_global_ad_revenue_summary_a1_suffix |
Ringkasan pendapatan iklan bulanan per negara | p_content_owner_country_ad_revenue_summary_a1_suffix | content_owner_country_ad_revenue_summary_a1_suffix |
Ringkasan pendapatan iklan harian dalam satu bulan | p_content_owner_day_ad_revenue_summary_a1_suffix | content_owner_day_ad_revenue_summary_a1_suffix |
Ringkasan pendapatan iklan global mingguan | p_content_owner_global_ad_revenue_summary_weekly_a1_suffix | content_owner_global_ad_revenue_summary_weekly_a1_suffix |
Ringkasan pendapatan iklan mingguan per negara | p_content_owner_country_ad_revenue_summary_weekly_a1_suffix | content_owner_country_ad_revenue_summary_weekly_a1_suffix |
Ringkasan pendapatan iklan harian dalam satu minggu | p_content_owner_day_ad_revenue_summary_weekly_a1_suffix | content_owner_day_ad_revenue_summary_weekly_a1_suffix |
Pendapatan iklan gabungan per video | p_content_owner_ad_revenue_summary_a1_suffix | content_owner_ad_revenue_summary_a1_suffix |
Ringkasan pendapatan iklan video mingguan | p_content_owner_ad_revenue_summary_weekly_a1_suffix | content_owner_ad_revenue_summary_weekly_a1_suffix |
Pendapatan iklan video mingguan | p_content_owner_ad_revenue_raw_weekly_a1_suffix | content_owner_ad_revenue_raw_weekly_a1_suffix |
Pendapatan iklan harian per video | p_content_owner_ad_revenue_raw_a1_suffix | content_owner_ad_revenue_raw_a1_suffix |
Pendapatan iklan gabungan per aset | p_content_owner_asset_ad_revenue_summary_a1_suffix | content_owner_asset_ad_revenue_summary_a1_suffix |
Pendapatan iklan harian per aset | p_content_owner_asset_ad_revenue_raw_a1_suffix | content_owner_asset_ad_revenue_raw_a1_suffix |
Ringkasan pendapatan iklan bulanan dari video yang Anda klaim | p_content_owner_claim_ad_revenue_summary_a1_suffix | content_owner_claim_ad_revenue_summary_a1_suffix |
Ringkasan pendapatan iklan mingguan dari video yang Anda klaim | p_content_owner_claim_ad_revenue_summary_weekly_a1_suffix | content_owner_claim_ad_revenue_summary_weekly_a1_suffix |
Pendapatan iklan bulanan dari video yang Anda klaim | p_content_owner_claim_ad_revenue_raw_a1_suffix | content_owner_claim_ad_revenue_raw_a1_suffix |
Pendapatan iklan mingguan dari video yang Anda klaim | p_content_owner_claim_ad_revenue_raw_weekly_a1_suffix | content_owner_claim_ad_revenue_raw_weekly_a1_suffix |
Laporan pendapatan langganan | ||
Ringkasan pendapatan musik bulanan | p_content_owner_country_music_red_revenue_summary_a1_suffix | content_owner_country_music_red_revenue_summary_a1_suffix |
Ringkasan pendapatan non-musik bulanan | p_content_owner_country_non_music_red_revenue_summary_a1_suffix | content_owner_country_non_music_red_revenue_summary_a1_suffix |
Pendapatan langganan bulanan dari aset musik | p_content_owner_music_asset_red_revenue_raw_a1_suffix | content_owner_music_asset_red_revenue_raw_a1_suffix |
Pendapatan langganan bulanan dari video musik | p_content_owner_music_red_revenue_raw_a1_suffix | content_owner_music_red_revenue_raw_a1_suffix |
Pendapatan langganan bulanan dari aset non-musik | p_content_owner_non_music_asset_red_revenue_raw_a1_suffix | content_owner_non_music_asset_red_revenue_raw_a1_suffix |
Pendapatan langganan bulanan dari video non-musik | p_content_owner_non_music_red_revenue_raw_a1_suffix | content_owner_non_music_red_revenue_raw_a1_suffix |
Pendapatan bulanan untuk aset label musik | p_music_content_owner_asset_red_revenue_raw_a1_suffix | music_content_owner_asset_red_revenue_raw_a1_suffix |
Pendapatan mingguan untuk aset label musik | p_music_content_owner_asset_red_revenue_raw_weekly_a1_suffix | music_content_owner_asset_red_revenue_raw_weekly_a1_suffix |
Ringkasan pendapatan bulanan untuk label musik dari konten musik | p_music_content_owner_country_music_red_revenue_summary_a1_suffix | music_content_owner_country_music_red_revenue_summary_a1_suffix |
Ringkasan pendapatan musik mingguan | p_music_content_owner_country_music_red_revenue_summary_weekly_a1_suffix | music_content_owner_country_music_red_revenue_summary_weekly_a1_suffix |
Ringkasan pendapatan non-musik bulanan untuk label musik | p_music_content_owner_country_non_music_red_revenue_summary_a1_suffix | music_content_owner_country_non_music_red_revenue_summary_a1_suffix |
Ringkasan pendapatan non-musik mingguan | p_music_content_owner_country_non_music_red_revenue_summary_weekly_a1_suffix | music_content_owner_country_non_music_red_revenue_summary_weekly_a1_suffix |
Pendapatan video bulanan untuk label musik | p_music_content_owner_red_revenue_raw_a1_suffix | music_content_owner_red_revenue_raw_a1_suffix |
Pendapatan video mingguan untuk label musik | p_music_content_owner_red_revenue_raw_weekly_a1_suffix | music_content_owner_red_revenue_raw_weekly_a1_suffix |
Ringkasan pendapatan pelanggan bulanan untuk label musik | p_music_content_owner_subscriber_red_revenue_summary_a1_suffix | music_content_owner_subscriber_red_revenue_summary_a1_suffix |