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