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
系统管理的报告
每个视频的广告收入汇总 p_content_owner_ad_revenue_summary_a1_suffix content_owner_ad_revenue_summary_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