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_a4_suffix | content_owner_basic_a4_suffix |
| Aktivitas pengguna berdasarkan provinsi | p_content_owner_province_a3_suffix | content_owner_province_3_suffix |
| Lokasi pemutaran | p_content_owner_playback_location_a3_suffix | content_owner_playback_location_a3_suffix |
| Sumber lalu lintas | p_content_owner_traffic_source_a3_suffix | content_owner_traffic_source_a3_suffix |
| Jenis perangkat dan sistem operasi | p_content_owner_device_os_a3_suffix | content_owner_device_os_a3_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_a3_suffix | content_owner_subtitles_a3_suffix |
| Gabungan | p_content_owner_combined_a3_suffix | content_owner_combined_a3_suffix |
| Laporan playlist | ||
| Aktivitas pengguna | p_content_owner_playlist_basic_a2_suffix | content_owner_playlist_basic_a2_suffix |
| Aktivitas pengguna berdasarkan provinsi | p_content_owner_playlist_province_a2_suffix | content_owner_playlist_province_a2_suffix |
| Lokasi pemutaran | p_content_owner_playlist_playback_location_a2_suffix | content_owner_playlist_playback_location_a2 |
| Sumber lalu lintas | p_content_owner_playlist_traffic_source_a2 | content_owner_playlist_traffic_source_a2_suffix |
| Jenis perangkat dan sistem operasi | p_content_owner_playlist_device_os_a2_suffix | content_owner_playlist_device_os_a2_suffix |
| Gabungan | p_content_owner_playlist_combined_a2_suffix | content_owner_playlist_combined_a2_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_a3_suffix | content_owner_asset_basic_a3_suffix |
| Aktivitas pengguna berdasarkan provinsi | p_content_owner_asset_province_a3_suffix | content_owner_asset_province_a3_suffix |
| Lokasi pemutaran video | p_content_owner_asset_playback_location_a3_suffix | content_owner_asset_playback_location_a3_suffix |
| Sumber lalu lintas | p_content_owner_asset_traffic_source_a3_suffix | content_owner_asset_traffic_source_a3_suffix |
| Jenis perangkat dan sistem operasi | p_content_owner_asset_device_os_a3_suffix | content_owner_asset_device_os_a3_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_a3_suffix | content_owner_asset_combined_a3_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 |
| Ringkasan pendapatan penyesuaian iklan global bulanan | p_content_owner_global_ad_adjustment_revenue_summary_a1_suffix | content_owner_global_ad_adjustment_revenue_summary_a1_suffix |
| Ringkasan pendapatan penyesuaian iklan aset bulanan | p_content_owner_asset_ad_adjustment_revenue_summary_a1_suffix | content_owner_asset_ad_adjustment_revenue_summary_a1_suffix |
| Pendapatan penyesuaian iklan aset bulanan | p_content_owner_asset_ad_adjustment_revenue_raw_a1_suffix | content_owner_asset_ad_adjustment_revenue_raw_a1_suffix |
| Ringkasan pendapatan iklan video bulanan setelah penyesuaian | p_content_owner_ad_adjustment_revenue_summary_a1_suffix | content_owner_ad_adjustment_revenue_summary_a1_suffix |
| Pendapatan penyesuaian iklan video bulanan (mentah) | p_content_owner_ad_adjustment_revenue_raw_a1_suffix | content_owner_ad_adjustment_revenue_raw_a1_suffix |
| Ringkasan pendapatan penyesuaian iklan bulanan dari video yang Anda klaim | p_content_owner_claim_ad_adjustment_revenue_summary_a1_suffix | content_owner_claim_ad_adjustment_revenue_summary_a1_suffix |
| Penyesuaian pendapatan iklan bulanan dari video yang Anda klaim | p_content_owner_claim_ad_adjustment_revenue_raw_a1_suffix | content_owner_claim_ad_adjustment_revenue_raw_a1_suffix |
| Ringkasan pendapatan penyesuaian iklan bulanan per negara | p_content_owner_country_ad_adjustment_revenue_summary_a1_suffix | content_owner_country_ad_adjustment_revenue_summary_a1_suffix |
| Ringkasan pendapatan iklan harian dalam satu bulan setelah penyesuaian | p_content_owner_day_ad_adjustment_revenue_summary_a1_suffix | content_owner_day_ad_adjustment_revenue_summary_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 |
| Pendapatan video bulanan untuk label musik | p_music_content_owner_red_revenue_raw_a1_suffix | music_content_owner_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 |
| 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 |
| Ringkasan pendapatan bulanan untuk penerbit musik | p_publisher_content_owner_music_red_revenue_summary_a1_suffix | publisher_content_owner_music_red_revenue_summary_a1_suffix |
| Ringkasan pendapatan langganan bulanan untuk penerbit musik | p_publisher_content_owner_subscriber_red_revenue_summary_a1_suffix | publisher_content_owner_subscriber_red_revenue_summary_a1_suffix |
| Ringkasan pendapatan langganan non-musik bulanan untuk penerbit musik | p_publisher_content_owner_non_music_red_revenue_summary_a1_suffix | publisher_content_owner_non_music_red_revenue_summary_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 |
| Pendapatan video musik dari langganan bulanan | p_content_owner_music_red_revenue_raw_a1_suffix | content_owner_music_red_revenue_raw_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 |
| 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 |
| 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 |
| 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 non-musik bulanan | p_content_owner_country_non_music_red_revenue_summary_a1_suffix | content_owner_country_non_music_red_revenue_summary_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 |
| 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 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 |
| 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 penyesuaian langganan aset label musik bulanan (mentah) | p_music_content_owner_asset_red_adjustment_revenue_raw_a1_suffix | music_content_owner_asset_red_adjustment_revenue_raw_a1_suffix |
| Data mentah penyesuaian langganan bulanan video musik | p_music_content_owner_red_adjustment_revenue_raw_a1_suffix | music_content_owner_red_adjustment_revenue_raw_a1_suffix |
| Ringkasan pendapatan penyesuaian langganan musik country bulanan untuk label musik | p_music_content_owner_country_music_red_adjustment_revenue_summary_a1_suffix | music_content_owner_country_music_red_adjustment_revenue_summary_a1_suffix |
| Ringkasan pendapatan penyesuaian langganan non-musik bulanan untuk label musik per negara | p_music_content_owner_country_non_music_red_adjustment_revenue_summary_a1_suffix | music_content_owner_country_non_music_red_adjustment_revenue_summary_a1_suffix |
| Pendapatan mentah penyesuaian langganan aset non-musik bulanan | p_content_owner_non_music_asset_red_adjustment_revenue_raw_a1_suffix | content_owner_non_music_asset_red_adjustment_revenue_raw_a1_suffix |
| Pendapatan penyesuaian langganan non-musik bulanan mentah | p_content_owner_non_music_red_adjustment_revenue_raw_a1_suffix | content_owner_non_music_red_adjustment_revenue_raw_a1_suffix |
| Pendapatan penyesuaian langganan video musik bulanan (mentah) | p_content_owner_music_video_red_adjustment_revenue_raw_a1_suffix | content_owner_music_video_red_adjustment_revenue_raw_a1_suffix |
| Pendapatan penyesuaian langganan aset musik bulanan (mentah) | p_content_owner_music_asset_red_adjustment_revenue_raw_a1_suffix | content_owner_music_asset_red_adjustment_revenue_raw_a1_suffix |
| Pendapatan penyesuaian langganan aset penerbit musik bulanan (mentah) | p_publisher_content_owner_asset_red_adjustment_revenue_raw_a1_suffix | publisher_content_owner_asset_red_adjustment_revenue_raw_a1_suffix |
| Ringkasan pendapatan penyesuaian langganan non-musik bulanan per negara untuk penerbit musik | p_publisher_content_owner_country_non_music_red_adjustment_revenue_summary_a1_suffix | publisher_content_owner_country_non_music_red_adjustment_revenue_summary_a1_suffix |
| Ringkasan pendapatan penyesuaian langganan musik bulanan untuk penerbit musik | p_publisher_content_owner_country_music_red_adjustment_revenue_summary_a1_suffix | publisher_content_owner_country_music_red_adjustment_revenue_summary_a1_suffix |
| Laporan pendapatan Shorts | ||
| Ringkasan pendapatan bulanan pemilik konten label musik dari YouTube Shorts | p_music_content_owner_shorts_revenue_summary_a1_suffix | music_content_owner_shorts_revenue_summary_a1_suffix |
| Ringkasan pendapatan bulanan pemilik konten penerbit musik YouTube Shorts | p_publisher_content_owner_shorts_revenue_summary_a1_suffix | publisher_content_owner_shorts_revenue_summary_a1_suffix |
| Ringkasan pendapatan iklan global YouTube Shorts bulanan | p_content_owner_shorts_global_ad_revenue_summary_a2_suffix | content_owner_shorts_global_ad_revenue_summary_a2_suffix |
| Ringkasan pendapatan iklan YouTube Shorts harian | p_content_owner_shorts_day_ad_revenue_summary_a2_suffix | content_owner_shorts_day_ad_revenue_summary_a2_suffix |
| Ringkasan pendapatan iklan YouTube Shorts bulanan per negara | p_content_owner_shorts_country_ad_revenue_summary_a2_suffix | content_owner_shorts_country_ad_revenue_summary_a2_suffix |
| Ringkasan pendapatan iklan YouTube Shorts bulanan | p_content_owner_shorts_ad_revenue_summary_a2_suffix | content_owner_shorts_ad_revenue_summary_a2_suffix |
| Ringkasan pendapatan langganan YouTube Shorts bulanan | p_content_owner_shorts_red_revenue_summary_a1_suffix | content_owner_shorts_red_revenue_summary_a1_suffix |
| Ringkasan video pendapatan langganan YouTube Shorts bulanan | p_content_owner_shorts_red_revenue_video_summary_a1_suffix | content_owner_shorts_red_revenue_video_summary_a1_suffix |
| Laporan pajak potong/pungut | ||
| Pemotongan pajak | p_content_owner_tax_withholding_a1_suffix | content_owner_tax_withholding_a1_suffix |
| Laporan video | ||
| Metadata video harian (versi 1.4) | p_content_owner_video_metadata_a4_suffix | content_owner_video_metadata_a4_suffix |
| Laporan aset | ||
| Laporan aset harian | p_content_owner_asset_a3_suffix | content_owner_asset_a3_suffix |
| Konflik aset harian | p_content_owner_asset_conflict_a3_suffix | content_owner_asset_conflict_a3_suffix |
| Laporan referensi | ||
| Referensi mingguan | p_content_owner_active_references_a1_suffix | content_owner_active_references_a1_suffix |
| Laporan klaim | ||
| Klaim harian (Versi 1.2) | p_content_owner_active_claims_a3_suffix | content_owner_active_claims_a3_suffix |