YouTube 內容擁有者報表轉換
當您的 YouTube 內容擁有者或系統管理報表移轉至 BigQuery 時，報表會轉換成下列 BigQuery 表格和檢視表。
當您在 BigQuery 中查看資料表和檢視表時，suffix 的值是您在建立移轉時設定的資料表尾碼。
| YouTube 內容擁有者報表 | BigQuery 資料表 | BigQuery 檢視表 |
|---|---|---|
| 影片報表 | ||
| 使用者活動 | p_content_owner_basic_a3_suffix | content_owner_basic_a3_suffix |
| 使用者活動 (按省/直轄市劃分) | p_content_owner_province_a2_suffix | content_owner_province_a2_suffix |
| 播放位置 | p_content_owner_playback_location_a2_suffix | content_owner_playback_location_a2_suffix |
| 流量來源 | p_content_owner_traffic_source_a2_suffix | content_owner_traffic_source_a2_suffix |
| 裝置類型和作業系統 | p_content_owner_device_os_a2_suffix | content_owner_device_os_a2_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_a2_suffix | content_owner_subtitles_a2_suffix |
| 合併 | p_content_owner_combined_a2_suffix | content_owner_combined_a2_suffix |
| 播放清單報表 | ||
| 使用者活動 | p_content_owner_playlist_basic_a1_suffix | content_owner_playlist_basic_a1_suffix |
| 使用者活動 (按省/直轄市劃分) | p_content_owner_playlist_province_a1_suffix | content_owner_playlist_province_a1_suffix |
| 播放位置 | p_content_owner_playlist_playback_location_a1_suffix | content_owner_playlist_playback_location_a1 |
| 流量來源 | p_content_owner_playlist_traffic_source_a1 | content_owner_playlist_traffic_source_a1_suffix |
| 裝置類型和作業系統 | p_content_owner_playlist_device_os_a1_suffix | content_owner_playlist_device_os_a1_suffix |
| 合併 | p_content_owner_playlist_combined_a1_suffix | content_owner_playlist_combined_a1_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_a2_suffix | content_owner_asset_basic_a2_suffix |
| 使用者活動 (按省/直轄市劃分) | p_content_owner_asset_province_a2_suffix | content_owner_asset_province_a2_suffix |
| 影片播放位置 | p_content_owner_asset_playback_location_a2_suffix | content_owner_asset_playback_location_a2_suffix |
| 流量來源 | p_content_owner_asset_traffic_source_a2_suffix | content_owner_asset_traffic_source_a2_suffix |
| 裝置類型和作業系統 | p_content_owner_asset_device_os_a2_suffix | content_owner_asset_device_os_a2_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_a2_suffix | content_owner_asset_combined_a2_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_a1_suffix | content_owner_shorts_global_ad_revenue_summary_a1_suffix |
| 每日 YouTube Shorts 廣告收益摘要 | p_content_owner_shorts_day_ad_revenue_summary_a1_suffix | content_owner_shorts_day_ad_revenue_summary_a1_suffix |
| YouTube Shorts 每月國家/地區廣告收益摘要 | p_content_owner_shorts_country_ad_revenue_summary_a1_suffix | content_owner_shorts_country_ad_revenue_summary_a1_suffix |
| YouTube Shorts 廣告收益月報 | p_content_owner_shorts_ad_revenue_summary_a1_suffix | content_owner_shorts_ad_revenue_summary_a1_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 |
| 影片報表 | ||
| Daily 影片中繼資料 (第 1.2 版) | p_content_owner_video_metadata_a2_suffix | content_owner_video_metadata_a2_suffix |
| Daily 影片中繼資料 (第 1.3 版) | p_content_owner_video_metadata_a3_suffix | content_owner_video_metadata_a3_suffix |
| 素材資源報表 | ||
| 每日素材資源報表 | p_content_owner_asset_a2_suffix | content_owner_asset_a2_suffix |
| 每日資產衝突 | p_content_owner_asset_conflict_a2_suffix | content_owner_asset_conflict_a2_suffix |
| 參考檔案報表 | ||
| 每週參考資料 | p_content_owner_active_references_a1_suffix | content_owner_active_references_a1_suffix |
| 版權聲明報表 | ||
| 每日聲明 (1.1 版) | p_content_owner_active_claims_a2_suffix | content_owner_active_claims_a2_suffix |
| 每日聲明 (第 1.0 版) | p_content_owner_active_claims_a1_suffix | content_owner_active_claims_a1_suffix |