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 |
| YouTube 系统管理的报告 | BigQuery 表 | BigQuery 视图 |
|---|---|---|
| 广告收入报告 | ||
| 每月全球广告收入摘要 | p_content_owner_global_ad_revenue_summary_a1_suffix | content_owner_global_ad_revenue_summary_a1_suffix |
| 每月国家/地区广告收入摘要 | p_content_owner_country_ad_revenue_summary_a1_suffix | content_owner_country_ad_revenue_summary_a1_suffix |
| 每月广告收入摘要 | p_content_owner_day_ad_revenue_summary_a1_suffix | content_owner_day_ad_revenue_summary_a1_suffix |
| 每周全球广告收入摘要 | p_content_owner_global_ad_revenue_summary_weekly_a1_suffix | content_owner_global_ad_revenue_summary_weekly_a1_suffix |
| 每周国家/地区广告收入摘要 | p_content_owner_country_ad_revenue_summary_weekly_a1_suffix | content_owner_country_ad_revenue_summary_weekly_a1_suffix |
| 每周广告收入摘要 | p_content_owner_day_ad_revenue_summary_weekly_a1_suffix | content_owner_day_ad_revenue_summary_weekly_a1_suffix |
| 每个视频的广告收入汇总 | p_content_owner_ad_revenue_summary_a1_suffix | content_owner_ad_revenue_summary_a1_suffix |
| 每周视频广告收入摘要 | p_content_owner_ad_revenue_summary_weekly_a1_suffix | content_owner_ad_revenue_summary_weekly_a1_suffix |
| 每周视频广告收入 | p_content_owner_ad_revenue_raw_weekly_a1_suffix | content_owner_ad_revenue_raw_weekly_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 |
| 每周版权主张广告收入摘要 | p_content_owner_claim_ad_revenue_summary_weekly_a1_suffix | content_owner_claim_ad_revenue_summary_weekly_a1_suffix |
| 每月版权主张广告收入 | p_content_owner_claim_ad_revenue_raw_a1_suffix | content_owner_claim_ad_revenue_raw_a1_suffix |
| 每周版权主张广告收入 | p_content_owner_claim_ad_revenue_raw_weekly_a1_suffix | content_owner_claim_ad_revenue_raw_weekly_a1_suffix |
| 每月全球广告调整收入摘要 | p_content_owner_global_ad_adjustment_revenue_summary_a1_suffix | content_owner_global_ad_adjustment_revenue_summary_a1_suffix |
| 每月资产广告调整收入摘要 | p_content_owner_asset_ad_adjustment_revenue_summary_a1_suffix | content_owner_asset_ad_adjustment_revenue_summary_a1_suffix |
| 每月资产广告调整收入 | p_content_owner_asset_ad_adjustment_revenue_raw_a1_suffix | content_owner_asset_ad_adjustment_revenue_raw_a1_suffix |
| 每月视频广告调整收入摘要 | p_content_owner_ad_adjustment_revenue_summary_a1_suffix | content_owner_ad_adjustment_revenue_summary_a1_suffix |
| 每月视频广告调整收入（原始值） | p_content_owner_ad_adjustment_revenue_raw_a1_suffix | content_owner_ad_adjustment_revenue_raw_a1_suffix |
| 每月版权主张广告调整收入摘要 | p_content_owner_claim_ad_adjustment_revenue_summary_a1_suffix | content_owner_claim_ad_adjustment_revenue_summary_a1_suffix |
| 每月版权主张广告调整收入 | p_content_owner_claim_ad_adjustment_revenue_raw_a1_suffix | content_owner_claim_ad_adjustment_revenue_raw_a1_suffix |
| 每月国家/地区广告调整收入摘要 | p_content_owner_country_ad_adjustment_revenue_summary_a1_suffix | content_owner_country_ad_adjustment_revenue_summary_a1_suffix |
| 每月广告收入调整摘要 | p_content_owner_day_ad_adjustment_revenue_summary_a1_suffix | content_owner_day_ad_adjustment_revenue_summary_a1_suffix |
| 订阅收入报告 | ||
| 每月音乐收入摘要 | p_content_owner_country_music_red_revenue_summary_a1_suffix | content_owner_country_music_red_revenue_summary_a1_suffix |
| 唱片公司每月视频收入 | p_music_content_owner_red_revenue_raw_a1_suffix | music_content_owner_red_revenue_raw_a1_suffix |
| 唱片公司每月资产收入 | p_music_content_owner_asset_red_revenue_raw_a1_suffix | music_content_owner_asset_red_revenue_raw_a1_suffix |
| 唱片公司每月订阅收入摘要 | p_music_content_owner_subscriber_red_revenue_summary_a1_suffix | music_content_owner_subscriber_red_revenue_summary_a1_suffix |
| 音乐发布商每月收入摘要 | p_publisher_content_owner_music_red_revenue_summary_a1_suffix | publisher_content_owner_music_red_revenue_summary_a1_suffix |
| 音乐发布商每月订阅收入摘要 | p_publisher_content_owner_subscriber_red_revenue_summary_a1_suffix | publisher_content_owner_subscriber_red_revenue_summary_a1_suffix |
| 音乐发布商每月非音乐订阅收入摘要 | p_publisher_content_owner_non_music_red_revenue_summary_a1_suffix | publisher_content_owner_non_music_red_revenue_summary_a1_suffix |
| 唱片公司每月音乐收入摘要 | p_music_content_owner_country_music_red_revenue_summary_a1_suffix | music_content_owner_country_music_red_revenue_summary_a1_suffix |
| 按月订阅的音乐视频收入 | p_content_owner_music_red_revenue_raw_a1_suffix | content_owner_music_red_revenue_raw_a1_suffix |
| 按月订阅的音乐资产收入 | p_content_owner_music_asset_red_revenue_raw_a1_suffix | content_owner_music_asset_red_revenue_raw_a1_suffix |
| 每周音乐收入摘要 | p_music_content_owner_country_music_red_revenue_summary_weekly_a1_suffix | music_content_owner_country_music_red_revenue_summary_weekly_a1_suffix |
| 唱片公司每周视频收入 | p_music_content_owner_red_revenue_raw_weekly_a1_suffix | music_content_owner_red_revenue_raw_weekly_a1_suffix |
| 唱片公司每周资产收入 | p_music_content_owner_asset_red_revenue_raw_weekly_a1_suffix | music_content_owner_asset_red_revenue_raw_weekly_a1_suffix |
| 每月非音乐摘要 | p_content_owner_country_non_music_red_revenue_summary_a1_suffix | content_owner_country_non_music_red_revenue_summary_a1_suffix |
| 唱片公司非音乐收入月度摘要 | p_music_content_owner_country_non_music_red_revenue_summary_a1_suffix | music_content_owner_country_non_music_red_revenue_summary_a1_suffix |
| 按月订阅的非音乐视频收入 | p_content_owner_non_music_red_revenue_raw_a1_suffix | content_owner_non_music_red_revenue_raw_a1_suffix |
| 按月订阅的非音乐资产收入 | p_content_owner_non_music_asset_red_revenue_raw_a1_suffix | content_owner_non_music_asset_red_revenue_raw_a1_suffix |
| 每周非音乐收入摘要 | p_music_content_owner_country_non_music_red_revenue_summary_weekly_a1_suffix | music_content_owner_country_non_music_red_revenue_summary_weekly_a1_suffix |
| 唱片公司每月资产订阅调整收入（原始数据） | p_music_content_owner_asset_red_adjustment_revenue_raw_a1_suffix | music_content_owner_asset_red_adjustment_revenue_raw_a1_suffix |
| 按月订阅调整项（音乐视频） | p_music_content_owner_red_adjustment_revenue_raw_a1_suffix | music_content_owner_red_adjustment_revenue_raw_a1_suffix |
| 唱片公司每月国家/地区音乐订阅调整收入摘要 | p_music_content_owner_country_music_red_adjustment_revenue_summary_a1_suffix | music_content_owner_country_music_red_adjustment_revenue_summary_a1_suffix |
| 唱片公司每月国家/地区非音乐订阅调整收入摘要 | p_music_content_owner_country_non_music_red_adjustment_revenue_summary_a1_suffix | music_content_owner_country_non_music_red_adjustment_revenue_summary_a1_suffix |
| 非音乐资产订阅调整收入（原始值） | p_content_owner_non_music_asset_red_adjustment_revenue_raw_a1_suffix | content_owner_non_music_asset_red_adjustment_revenue_raw_a1_suffix |
| 每月非音乐订阅调整收入（原始值） | p_content_owner_non_music_red_adjustment_revenue_raw_a1_suffix | content_owner_non_music_red_adjustment_revenue_raw_a1_suffix |
| 每月音乐视频订阅调整收入（原始数据） | p_content_owner_music_video_red_adjustment_revenue_raw_a1_suffix | content_owner_music_video_red_adjustment_revenue_raw_a1_suffix |
| 每月音乐资产订阅调整收入（原始数据） | p_content_owner_music_asset_red_adjustment_revenue_raw_a1_suffix | content_owner_music_asset_red_adjustment_revenue_raw_a1_suffix |
| 每月音乐发布商资产订阅调整收入（原始数据） | p_publisher_content_owner_asset_red_adjustment_revenue_raw_a1_suffix | publisher_content_owner_asset_red_adjustment_revenue_raw_a1_suffix |
| 音乐发布商每月国家/地区非音乐订阅调整收入摘要 | p_publisher_content_owner_country_non_music_red_adjustment_revenue_summary_a1_suffix | publisher_content_owner_country_non_music_red_adjustment_revenue_summary_a1_suffix |
| 音乐发布商每月国家/地区音乐订阅调整收入摘要 | p_publisher_content_owner_country_music_red_adjustment_revenue_summary_a1_suffix | publisher_content_owner_country_music_red_adjustment_revenue_summary_a1_suffix |
| Shorts 收入报告 | ||
| YouTube Shorts 唱片公司内容所有者每月收入摘要 | p_music_content_owner_shorts_revenue_summary_a1_suffix | music_content_owner_shorts_revenue_summary_a1_suffix |
| YouTube Shorts 音乐发布商内容所有者每月收入摘要 | p_publisher_content_owner_shorts_revenue_summary_a1_suffix | publisher_content_owner_shorts_revenue_summary_a1_suffix |
| 每月 YouTube Shorts 全球广告收入摘要 | p_content_owner_shorts_global_ad_revenue_summary_a1_suffix | content_owner_shorts_global_ad_revenue_summary_a1_suffix |
| 每日 YouTube Shorts 广告收入摘要 | p_content_owner_shorts_day_ad_revenue_summary_a1_suffix | content_owner_shorts_day_ad_revenue_summary_a1_suffix |
| 每月 YouTube Shorts 国家/地区广告收入摘要 | p_content_owner_shorts_country_ad_revenue_summary_a1_suffix | content_owner_shorts_country_ad_revenue_summary_a1_suffix |
| 每月 YouTube Shorts 广告收入摘要 | p_content_owner_shorts_ad_revenue_summary_a1_suffix | content_owner_shorts_ad_revenue_summary_a1_suffix |
| YouTube Shorts 订阅收入月度摘要 | p_content_owner_shorts_red_revenue_summary_a1_suffix | content_owner_shorts_red_revenue_summary_a1_suffix |
| YouTube Shorts 订阅收入按月视频摘要 | p_content_owner_shorts_red_revenue_video_summary_a1_suffix | content_owner_shorts_red_revenue_video_summary_a1_suffix |
| 预扣税报告 | ||
| 税款预扣 | p_content_owner_tax_withholding_a1_suffix | content_owner_tax_withholding_a1_suffix |