YouTube 頻道報表轉換

當您的 YouTube 頻道報表移轉至 BigQuery 時,報表會轉換成下列 BigQuery 資料表和檢視表。

當您在 BigQuery 中查看資料表和檢視表時,suffix 的值是您在建立移轉時設定的資料表尾碼。

YouTube 頻道報告 BigQuery 資料表 BigQuery 檢視區塊
影片報表
使用者活動 p_channel_basic_a3_suffix channel_basic_a3_suffix
依省份劃分的使用者活動 p_channel_province_a3_suffix channel_province_a3_suffix
播放位置 p_channel_playback_location_a3_suffix channel_playback_location_a3_suffix
流量來源 p_channel_traffic_source_a3_suffix channel_traffic_source_a3_suffix
裝置類型和作業系統 p_channel_device_os_a3_suffix channel_device_os_a3_suffix
觀眾客層 p_channel_demographics_a1_suffix channel_demographics_a1_suffix
內容共享 (依平台分組) p_channel_sharing_service_a1_suffix channel_sharing_service_a1_suffix
註解 p_channel_annotations_a1_suffix channel_annotations_a1_suffix
資訊卡 p_channel_cards_a1_suffix channel_cards_a1_suffix
片尾 p_channel_end_screens_a1_suffix channel_end_screens_a1_suffix
字幕 p_channel_subtitles_a3_suffix channel_subtitles_a3_suffix
合併 p_channel_combined_a3_suffix channel_combined_a3_suffix
播放清單報表
使用者活動 p_playlist_basic_a2_suffix playlist_basic_a2_suffix
依省份劃分的使用者活動 p_playlist_province_a2_suffix playlist_province_a2_suffix
播放位置 p_playlist_playback_location_a2_suffix playlist_playback_location_a2_suffix
流量來源 p_playlist_traffic_source_a2_suffix playlist_traffic_source_a2_suffix
裝置類型和作業系統 p_playlist_device_os_a2_suffix playlist_device_os_a2_suffix
合併 p_playlist_combined_a2_suffix playlist_combined_a2_suffix