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 |
| 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 penyesuaian iklan video bulanan | p_content_owner_ad_adjustment_revenue_summary_a1_suffix | content_owner_ad_adjustment_revenue_summary_a1_suffix |
| Pendapatan penyesuaian iklan video bulanan dalam bentuk mentah | p_content_owner_ad_adjustment_revenue_raw_a1_suffix | content_owner_ad_adjustment_revenue_raw_a1_suffix |
| Ringkasan pendapatan penyesuaian iklan klaim bulanan | p_content_owner_claim_ad_adjustment_revenue_summary_a1_suffix | content_owner_claim_ad_adjustment_revenue_summary_a1_suffix |
| Pendapatan penyesuaian 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 penyesuaian iklan harian dalam satu bulan | 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 penerbit musik bulanan | p_publisher_content_owner_music_red_revenue_summary_a1_suffix | publisher_content_owner_music_red_revenue_summary_a1_suffix |
| Ringkasan pendapatan langganan penerbit musik bulanan | 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 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 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 | p_music_content_owner_asset_red_adjustment_revenue_raw_a1_suffix | music_content_owner_asset_red_adjustment_revenue_raw_a1_suffix |
| Video musik raw penyesuaian langganan bulanan | p_music_content_owner_red_adjustment_revenue_raw_a1_suffix | music_content_owner_red_adjustment_revenue_raw_a1_suffix |
| Ringkasan pendapatan penyesuaian langganan musik negara untuk label musik bulanan | 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 per negara untuk label musik bulanan | 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 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 dalam bentuk 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 dalam bentuk 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 | 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 per negara penerbit musik bulanan | 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 negara untuk penerbit musik bulanan | 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 untuk pemilik konten label musik YouTube Shorts | p_music_content_owner_shorts_revenue_summary_a1_suffix | music_content_owner_shorts_revenue_summary_a1_suffix |
| Ringkasan pendapatan pemilik konten penerbit musik YouTube Shorts bulanan | 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_a1_suffix | content_owner_shorts_global_ad_revenue_summary_a1_suffix |
| Ringkasan pendapatan iklan YouTube Shorts harian | p_content_owner_shorts_day_ad_revenue_summary_a1_suffix | content_owner_shorts_day_ad_revenue_summary_a1_suffix |
| Ringkasan pendapatan iklan bulanan per negara YouTube Shorts | p_content_owner_shorts_country_ad_revenue_summary_a1_suffix | content_owner_shorts_country_ad_revenue_summary_a1_suffix |
| Ringkasan pendapatan iklan YouTube Shorts bulanan | p_content_owner_shorts_ad_revenue_summary_a1_suffix | content_owner_shorts_ad_revenue_summary_a1_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 pemotongan/pemungutan pajak | ||
| Pemotongan/pemungutan pajak | p_content_owner_tax_withholding_a1_suffix | content_owner_tax_withholding_a1_suffix |