YouTube 頻道報表轉換
當您的 YouTube 頻道報表移轉至 BigQuery 時,報表會轉換成下列 BigQuery 資料表和檢視表。
當您在 BigQuery 中查看資料表和檢視表時,suffix 的值是您在建立移轉時設定的資料表尾碼。
YouTube 頻道報告 | BigQuery 資料表 | BigQuery 檢視表 |
---|---|---|
影片報表 | ||
使用者活動 | p_channel_basic_a2_suffix | channel_basic_a2_suffix |
使用者活動 (按省/直轄市劃分) | p_channel_province_a2_suffix | channel_province_a2_suffix |
播放位置 | p_channel_playback_location_a2_suffix | channel_playback_location_a2_suffix |
流量來源 | p_channel_traffic_source_a2_suffix | channel_traffic_source_a2_suffix |
裝置類型和作業系統 | p_channel_device_os_a2_suffix | channel_device_os_a2_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_a2_suffix | channel_subtitles_a2_suffix |
合併 | p_channel_combined_a2_suffix | channel_combined_a2_suffix |
播放清單報表 | ||
使用者活動 | p_playlist_basic_a1_suffix | playlist_basic_a1_suffix |
使用者活動 (按省/直轄市劃分) | p_playlist_province_a1_suffix | playlist_province_a1_suffix |
播放位置 | p_playlist_playback_location_a1_suffix | playlist_playback_location_a1_suffix |
流量來源 | p_playlist_traffic_source_a1_suffix | playlist_traffic_source_a1_suffix |
裝置類型和作業系統 | p_playlist_device_os_a1_suffix | playlist_device_os_a1_suffix |
合併 | p_playlist_combined_a1_suffix | playlist_combined_a1_suffix |