YouTube 内容所有者报告转换
当 YouTube 内容所有者报告或系统管理的报告转移到 BigQuery 时,报告将转换为以下 BigQuery 表和视图。
当您在 BigQuery 中查看表和视图时,suffix 的值是您在创建转移作业时配置的表后缀。
| YouTube 内容所有者报告 | BigQuery 表 | BigQuery 视图 |
|---|---|---|
| 视频报告 | ||
| 用户活动 | p_content_owner_basic_a4_suffix | content_owner_basic_a4_suffix |
| 用户活动(按省份) | p_content_owner_province_a3_suffix | content_owner_province_3_suffix |
| 播放位置 | p_content_owner_playback_location_a3_suffix | content_owner_playback_location_a3_suffix |
| 流量来源 | p_content_owner_traffic_source_a3_suffix | content_owner_traffic_source_a3_suffix |
| 设备类型和操作系统 | p_content_owner_device_os_a3_suffix | content_owner_device_os_a3_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_a3_suffix | content_owner_subtitles_a3_suffix |
| 合并 | p_content_owner_combined_a3_suffix | content_owner_combined_a3_suffix |
| 播放列表报告 | ||
| 用户活动 | p_content_owner_playlist_basic_a2_suffix | content_owner_playlist_basic_a2_suffix |
| 用户活动(按省份) | p_content_owner_playlist_province_a2_suffix | content_owner_playlist_province_a2_suffix |
| 播放位置 | p_content_owner_playlist_playback_location_a2_suffix | content_owner_playlist_playback_location_a2 |
| 流量来源 | p_content_owner_playlist_traffic_source_a2 | content_owner_playlist_traffic_source_a2_suffix |
| 设备类型和操作系统 | p_content_owner_playlist_device_os_a2_suffix | content_owner_playlist_device_os_a2_suffix |
| 合并 | p_content_owner_playlist_combined_a2_suffix | content_owner_playlist_combined_a2_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_a3_suffix | content_owner_asset_basic_a3_suffix |
| 用户活动(按省份) | p_content_owner_asset_province_a3_suffix | content_owner_asset_province_a3_suffix |
| 视频播放位置 | p_content_owner_asset_playback_location_a3_suffix | content_owner_asset_playback_location_a3_suffix |
| 流量来源 | p_content_owner_asset_traffic_source_a3_suffix | content_owner_asset_traffic_source_a3_suffix |
| 设备类型和操作系统 | p_content_owner_asset_device_os_a3_suffix | content_owner_asset_device_os_a3_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_a3_suffix | content_owner_asset_combined_a3_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_a2_suffix | content_owner_shorts_global_ad_revenue_summary_a2_suffix |
| 每日 YouTube Shorts 广告收入摘要 | p_content_owner_shorts_day_ad_revenue_summary_a2_suffix | content_owner_shorts_day_ad_revenue_summary_a2_suffix |
| 每月 YouTube Shorts 国家/地区广告收入摘要 | p_content_owner_shorts_country_ad_revenue_summary_a2_suffix | content_owner_shorts_country_ad_revenue_summary_a2_suffix |
| 每月 YouTube Shorts 广告收入摘要 | p_content_owner_shorts_ad_revenue_summary_a2_suffix | content_owner_shorts_ad_revenue_summary_a2_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 |
| 视频报告 | ||
| 每日视频元数据(1.4 版) | p_content_owner_video_metadata_a4_suffix | content_owner_video_metadata_a4_suffix |
| 资产报告 | ||
| 每日资产报告 | p_content_owner_asset_a3_suffix | content_owner_asset_a3_suffix |
| 每日资产冲突 | p_content_owner_asset_conflict_a3_suffix | content_owner_asset_conflict_a3_suffix |
| 参考文件报告 | ||
| 每周引用次数 | p_content_owner_active_references_a1_suffix | content_owner_active_references_a1_suffix |
| 版权主张报告 | ||
| 每日版权主张(1.2 版) | p_content_owner_active_claims_a3_suffix | content_owner_active_claims_a3_suffix |