YouTube 內容擁有者報表轉換
當您的 YouTube 內容擁有者或系統管理報表移轉至 BigQuery 時，報表會轉換成下列 BigQuery 資料表和檢視表。
當您在 BigQuery 中查看資料表和檢視表時，suffix 的值是您在建立移轉時設定的資料表尾碼。
| YouTube 內容擁有者報告 | BigQuery 資料表 | BigQuery 檢視區塊 |
|---|---|---|
| 影片報表 | ||
| 使用者活動 | p_content_owner_basic_a4_suffix | content_owner_basic_a4_suffix |
| 依省份劃分的使用者活動 | p_content_owner_province_a3_suffix | content_owner_province_3_suffix |
| 播放位置 | p_content_owner_playback_location_a3_suffix | content_owner_playback_location_a3_suffix |
| 流量來源 | p_content_owner_traffic_source_a3_suffix | content_owner_traffic_source_a3_suffix |
| 裝置類型和作業系統 | p_content_owner_device_os_a3_suffix | content_owner_device_os_a3_suffix |
| 觀眾客層 | p_content_owner_demographics_a1_suffix | content_owner_demographics_a1_suffix |
| 內容共享 (依平台分組) | p_content_owner_sharing_service_a1_suffix | content_owner_sharing_service_a1_suffix |
| 註解 | p_content_owner_annotations_a1_suffix | content_owner_annotations_a1_suffix |
| 資訊卡 | p_content_owner_cards_a1_suffix | content_owner_cards_a1_suffix |
| 片尾 | p_content_owner_end_screens_a1_suffix | content_owner_end_screens_a1_suffix |
| 字幕 | p_content_owner_subtitles_a3_suffix | content_owner_subtitles_a3_suffix |
| 合併 | p_content_owner_combined_a3_suffix | content_owner_combined_a3_suffix |
| 播放清單報表 | ||
| 使用者活動 | p_content_owner_playlist_basic_a2_suffix | content_owner_playlist_basic_a2_suffix |
| 依省份劃分的使用者活動 | p_content_owner_playlist_province_a2_suffix | content_owner_playlist_province_a2_suffix |
| 播放位置 | p_content_owner_playlist_playback_location_a2_suffix | content_owner_playlist_playback_location_a2 |
| 流量來源 | p_content_owner_playlist_traffic_source_a2 | content_owner_playlist_traffic_source_a2_suffix |
| 裝置類型和作業系統 | p_content_owner_playlist_device_os_a2_suffix | content_owner_playlist_device_os_a2_suffix |
| 合併 | p_content_owner_playlist_combined_a2_suffix | content_owner_playlist_combined_a2_suffix |
| 廣告費率報表 | ||
| 廣告費率報表 | p_content_owner_ad_rates_a1_suffix | content_owner_ad_rates_a1_suffix |
| 預估收益報表 | ||
| 預估影片收益 | p_content_owner_estimated_revenue_a1_suffix | content_owner_estimated_revenue_a1_suffix |
| 預估資產收益 | p_content_owner_asset_estimated_revenue_a1_suffix | content_owner_asset_estimated_revenue_a1_suffix |
| 素材資源報表 | ||
| 使用者活動 | p_content_owner_asset_basic_a3_suffix | content_owner_asset_basic_a3_suffix |
| 依省份劃分的使用者活動 | p_content_owner_asset_province_a3_suffix | content_owner_asset_province_a3_suffix |
| 影片播放位置 | p_content_owner_asset_playback_location_a3_suffix | content_owner_asset_playback_location_a3_suffix |
| 流量來源 | p_content_owner_asset_traffic_source_a3_suffix | content_owner_asset_traffic_source_a3_suffix |
| 裝置類型和作業系統 | p_content_owner_asset_device_os_a3_suffix | content_owner_asset_device_os_a3_suffix |
| 觀眾客層 | p_content_owner_asset_demographics_a1_suffix | content_owner_asset_demographics_a1_suffix |
| 內容共享 (依平台分組) | p_content_owner_asset_sharing_service_a1_suffix | content_owner_asset_sharing_service_a1_suffix |
| 註解 | p_content_owner_asset_annotations_a1_suffix | content_owner_asset_annotations_a1_suffix |
| 資訊卡 | p_content_owner_asset_cards_a1_suffix | content_owner_asset_cards_a1_suffix |
| 片尾 | p_content_owner_asset_end_screens_a1_suffix | content_owner_asset_end_screens_a1_suffix |
| 合併 | p_content_owner_asset_combined_a3_suffix | content_owner_asset_combined_a3_suffix |
| YouTube 系統管理報告 | BigQuery 資料表 | BigQuery 檢視區塊 |
|---|---|---|
| 廣告收益報表 | ||
| 每月全球廣告收益摘要 | p_content_owner_global_ad_revenue_summary_a1_suffix | content_owner_global_ad_revenue_summary_a1_suffix |
| 每月國家/地區廣告收益摘要 | p_content_owner_country_ad_revenue_summary_a1_suffix | content_owner_country_ad_revenue_summary_a1_suffix |
| 每月每日廣告收益摘要 | p_content_owner_day_ad_revenue_summary_a1_suffix | content_owner_day_ad_revenue_summary_a1_suffix |
| 每週全球廣告收益摘要 | p_content_owner_global_ad_revenue_summary_weekly_a1_suffix | content_owner_global_ad_revenue_summary_weekly_a1_suffix |
| 每週國家/地區廣告收益摘要 | p_content_owner_country_ad_revenue_summary_weekly_a1_suffix | content_owner_country_ad_revenue_summary_weekly_a1_suffix |
| 每週每日廣告收益摘要 | p_content_owner_day_ad_revenue_summary_weekly_a1_suffix | content_owner_day_ad_revenue_summary_weekly_a1_suffix |
| 每部影片的匯總廣告收益 | p_content_owner_ad_revenue_summary_a1_suffix | content_owner_ad_revenue_summary_a1_suffix |
| 每週影片廣告收益摘要 | p_content_owner_ad_revenue_summary_weekly_a1_suffix | content_owner_ad_revenue_summary_weekly_a1_suffix |
| 每週影片廣告收益 | p_content_owner_ad_revenue_raw_weekly_a1_suffix | content_owner_ad_revenue_raw_weekly_a1_suffix |
| 每部影片的每日廣告收益 | p_content_owner_ad_revenue_raw_a1_suffix | content_owner_ad_revenue_raw_a1_suffix |
| 每項資產的匯總廣告收益 | p_content_owner_asset_ad_revenue_summary_a1_suffix | content_owner_asset_ad_revenue_summary_a1_suffix |
| 每個資產的每日廣告收益 | p_content_owner_asset_ad_revenue_raw_a1_suffix | content_owner_asset_ad_revenue_raw_a1_suffix |
| 每月聲明廣告收益摘要 | p_content_owner_claim_ad_revenue_summary_a1_suffix | content_owner_claim_ad_revenue_summary_a1_suffix |
| 每週著作權聲明廣告收益摘要 | p_content_owner_claim_ad_revenue_summary_weekly_a1_suffix | content_owner_claim_ad_revenue_summary_weekly_a1_suffix |
| 每月聲明廣告收益 | p_content_owner_claim_ad_revenue_raw_a1_suffix | content_owner_claim_ad_revenue_raw_a1_suffix |
| 每週聲明廣告收益 | p_content_owner_claim_ad_revenue_raw_weekly_a1_suffix | content_owner_claim_ad_revenue_raw_weekly_a1_suffix |
| 每月全球廣告調整項收益摘要 | p_content_owner_global_ad_adjustment_revenue_summary_a1_suffix | content_owner_global_ad_adjustment_revenue_summary_a1_suffix |
| 每月素材資源廣告調整項收益摘要 | p_content_owner_asset_ad_adjustment_revenue_summary_a1_suffix | content_owner_asset_ad_adjustment_revenue_summary_a1_suffix |
| 每月素材資源廣告調整項收益 | p_content_owner_asset_ad_adjustment_revenue_raw_a1_suffix | content_owner_asset_ad_adjustment_revenue_raw_a1_suffix |
| 每月影片廣告調整項收益摘要 | p_content_owner_ad_adjustment_revenue_summary_a1_suffix | content_owner_ad_adjustment_revenue_summary_a1_suffix |
| 每月影片廣告調整項收益原始資料 | p_content_owner_ad_adjustment_revenue_raw_a1_suffix | content_owner_ad_adjustment_revenue_raw_a1_suffix |
| 每月聲明廣告調整項收益摘要 | p_content_owner_claim_ad_adjustment_revenue_summary_a1_suffix | content_owner_claim_ad_adjustment_revenue_summary_a1_suffix |
| 每月著作權聲明廣告調整項收益 | p_content_owner_claim_ad_adjustment_revenue_raw_a1_suffix | content_owner_claim_ad_adjustment_revenue_raw_a1_suffix |
| 每月國家/地區廣告調整項收益摘要 | p_content_owner_country_ad_adjustment_revenue_summary_a1_suffix | content_owner_country_ad_adjustment_revenue_summary_a1_suffix |
| 每月每日廣告調整項收益摘要 | p_content_owner_day_ad_adjustment_revenue_summary_a1_suffix | content_owner_day_ad_adjustment_revenue_summary_a1_suffix |
| 訂閱收益報表 | ||
| 每月音樂收益摘要 | p_content_owner_country_music_red_revenue_summary_a1_suffix | content_owner_country_music_red_revenue_summary_a1_suffix |
| 每月音樂唱片公司影片收益 | p_music_content_owner_red_revenue_raw_a1_suffix | music_content_owner_red_revenue_raw_a1_suffix |
| 每月音樂唱片公司資產收益 | p_music_content_owner_asset_red_revenue_raw_a1_suffix | music_content_owner_asset_red_revenue_raw_a1_suffix |
| 每月音樂唱片公司訂閱者收益摘要 | p_music_content_owner_subscriber_red_revenue_summary_a1_suffix | music_content_owner_subscriber_red_revenue_summary_a1_suffix |
| 每月音樂發行商收益摘要 | p_publisher_content_owner_music_red_revenue_summary_a1_suffix | publisher_content_owner_music_red_revenue_summary_a1_suffix |
| 每月音樂發行商訂閱收益摘要 | p_publisher_content_owner_subscriber_red_revenue_summary_a1_suffix | publisher_content_owner_subscriber_red_revenue_summary_a1_suffix |
| 每月音樂發行商非音樂訂閱收益摘要 | p_publisher_content_owner_non_music_red_revenue_summary_a1_suffix | publisher_content_owner_non_music_red_revenue_summary_a1_suffix |
| 每月音樂唱片公司音樂收益摘要 | p_music_content_owner_country_music_red_revenue_summary_a1_suffix | music_content_owner_country_music_red_revenue_summary_a1_suffix |
| 月費方案音樂影片收益 | p_content_owner_music_red_revenue_raw_a1_suffix | content_owner_music_red_revenue_raw_a1_suffix |
| 月繳方案音樂資產收益 | p_content_owner_music_asset_red_revenue_raw_a1_suffix | content_owner_music_asset_red_revenue_raw_a1_suffix |
| 每週音樂收益摘要 | p_music_content_owner_country_music_red_revenue_summary_weekly_a1_suffix | music_content_owner_country_music_red_revenue_summary_weekly_a1_suffix |
| 唱片公司每週影片收益 | p_music_content_owner_red_revenue_raw_weekly_a1_suffix | music_content_owner_red_revenue_raw_weekly_a1_suffix |
| 每週音樂唱片公司資產收益 | p_music_content_owner_asset_red_revenue_raw_weekly_a1_suffix | music_content_owner_asset_red_revenue_raw_weekly_a1_suffix |
| 每月非音樂摘要 | p_content_owner_country_non_music_red_revenue_summary_a1_suffix | content_owner_country_non_music_red_revenue_summary_a1_suffix |
| 每月音樂唱片公司非音樂收益摘要 | p_music_content_owner_country_non_music_red_revenue_summary_a1_suffix | music_content_owner_country_non_music_red_revenue_summary_a1_suffix |
| 非音樂影片的每月訂閱收益 | p_content_owner_non_music_red_revenue_raw_a1_suffix | content_owner_non_music_red_revenue_raw_a1_suffix |
| 每月訂閱非音樂資產收益 | p_content_owner_non_music_asset_red_revenue_raw_a1_suffix | content_owner_non_music_asset_red_revenue_raw_a1_suffix |
| 每週非音樂收益摘要 | 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 |
| 每月音樂唱片公司資產訂閱調整項收益原始資料 | p_music_content_owner_asset_red_adjustment_revenue_raw_a1_suffix | music_content_owner_asset_red_adjustment_revenue_raw_a1_suffix |
| 月費方案調整項音樂影片原始資料 | p_music_content_owner_red_adjustment_revenue_raw_a1_suffix | music_content_owner_red_adjustment_revenue_raw_a1_suffix |
| 每月音樂唱片公司國家/地區音樂訂閱調整項收益摘要 | p_music_content_owner_country_music_red_adjustment_revenue_summary_a1_suffix | music_content_owner_country_music_red_adjustment_revenue_summary_a1_suffix |
| 每月音樂唱片公司國家/地區非音樂訂閱調整項收益摘要 | 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 |
| 每月非音樂資產訂閱調整項收益原始資料 | p_content_owner_non_music_asset_red_adjustment_revenue_raw_a1_suffix | content_owner_non_music_asset_red_adjustment_revenue_raw_a1_suffix |
| 每月非音樂訂閱調整項收益原始資料 | p_content_owner_non_music_red_adjustment_revenue_raw_a1_suffix | content_owner_non_music_red_adjustment_revenue_raw_a1_suffix |
| 每月音樂影片訂閱調整項收益原始資料 | p_content_owner_music_video_red_adjustment_revenue_raw_a1_suffix | content_owner_music_video_red_adjustment_revenue_raw_a1_suffix |
| 每月音樂資產訂閱調整項收益原始資料 | p_content_owner_music_asset_red_adjustment_revenue_raw_a1_suffix | content_owner_music_asset_red_adjustment_revenue_raw_a1_suffix |
| 每月音樂發布者資產訂閱調整項收益原始資料 | p_publisher_content_owner_asset_red_adjustment_revenue_raw_a1_suffix | publisher_content_owner_asset_red_adjustment_revenue_raw_a1_suffix |
| 每月音樂發行商國家/地區非音樂訂閱調整項收益摘要 | 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 |
| 每月音樂發行商國家/地區音樂訂閱調整項收益摘要 | p_publisher_content_owner_country_music_red_adjustment_revenue_summary_a1_suffix | publisher_content_owner_country_music_red_adjustment_revenue_summary_a1_suffix |
| Shorts 收益報表 | ||
| 每月 YouTube Shorts 唱片公司內容擁有者收益摘要 | p_music_content_owner_shorts_revenue_summary_a1_suffix | music_content_owner_shorts_revenue_summary_a1_suffix |
| 每月 YouTube Shorts 音樂發行商內容擁有者收益摘要 | p_publisher_content_owner_shorts_revenue_summary_a1_suffix | publisher_content_owner_shorts_revenue_summary_a1_suffix |
| 每月 YouTube Shorts 全球廣告收益摘要 | p_content_owner_shorts_global_ad_revenue_summary_a2_suffix | content_owner_shorts_global_ad_revenue_summary_a2_suffix |
| 每日 YouTube Shorts 廣告收益摘要 | p_content_owner_shorts_day_ad_revenue_summary_a2_suffix | content_owner_shorts_day_ad_revenue_summary_a2_suffix |
| 每月 YouTube Shorts 國家/地區廣告收益摘要 | p_content_owner_shorts_country_ad_revenue_summary_a2_suffix | content_owner_shorts_country_ad_revenue_summary_a2_suffix |
| 每月 YouTube Shorts 廣告收益摘要 | p_content_owner_shorts_ad_revenue_summary_a2_suffix | content_owner_shorts_ad_revenue_summary_a2_suffix |
| 每月 YouTube Shorts 訂閱收益摘要 | p_content_owner_shorts_red_revenue_summary_a1_suffix | content_owner_shorts_red_revenue_summary_a1_suffix |
| 每月 YouTube Shorts 訂閱收益影片摘要 | p_content_owner_shorts_red_revenue_video_summary_a1_suffix | content_owner_shorts_red_revenue_video_summary_a1_suffix |
| 扣繳稅額報表 | ||
| 預扣稅額 | p_content_owner_tax_withholding_a1_suffix | content_owner_tax_withholding_a1_suffix |
| 影片報表 | ||
| 每日影片中繼資料 (1.4 版) | p_content_owner_video_metadata_a4_suffix | content_owner_video_metadata_a4_suffix |
| 素材資源報表 | ||
| 每日資產報表 | p_content_owner_asset_a3_suffix | content_owner_asset_a3_suffix |
| 每日資產衝突 | p_content_owner_asset_conflict_a3_suffix | content_owner_asset_conflict_a3_suffix |
| 參考檔案報表 | ||
| 每週參考資料 | p_content_owner_active_references_a1_suffix | content_owner_active_references_a1_suffix |
| 著作權聲明報表 | ||
| 每日兌換次數 (1.2 版) | p_content_owner_active_claims_a3_suffix | content_owner_active_claims_a3_suffix |