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 |