Transformación de informes de propietarios de contenido de YouTube
Cuando tus informes de propietario del contenido de YouTube o gestionados por el sistema se transfieren a BigQuery, se transforman en las siguientes tablas y vistas de BigQuery.
Cuando veas las tablas y las vistas en BigQuery, el valor de suffix será el sufijo de tabla que hayas configurado al crear la transferencia.
| Informe de propietario del contenido de YouTube | Tabla de BigQuery | Vista de BigQuery |
|---|---|---|
| Informes de vídeo | ||
| Actividad de los usuarios | p_content_owner_basic_a4_suffix | content_owner_basic_a4_suffix |
| Actividad de los usuarios por provincia | p_content_owner_province_a3_suffix | content_owner_province_3_suffix |
| Ubicaciones de reproducción | p_content_owner_playback_location_a3_suffix | content_owner_playback_location_a3_suffix |
| Fuentes de tráfico | p_content_owner_traffic_source_a3_suffix | content_owner_traffic_source_a3_suffix |
| Tipo de dispositivo y sistema operativo | p_content_owner_device_os_a3_suffix | content_owner_device_os_a3_suffix |
| Datos demográficos de la audiencia | p_content_owner_demographics_a1_suffix | content_owner_demographics_a1_suffix |
| Contenido compartido por plataforma | p_content_owner_sharing_service_a1_suffix | content_owner_sharing_service_a1_suffix |
| Anotaciones | p_content_owner_annotations_a1_suffix | content_owner_annotations_a1_suffix |
| Tarjetas | p_content_owner_cards_a1_suffix | content_owner_cards_a1_suffix |
| Pantallas finales | p_content_owner_end_screens_a1_suffix | content_owner_end_screens_a1_suffix |
| Subtítulos | p_content_owner_subtitles_a3_suffix | content_owner_subtitles_a3_suffix |
| Combinado | p_content_owner_combined_a3_suffix | content_owner_combined_a3_suffix |
| Informes de listas de reproducción | ||
| Actividad de los usuarios | p_content_owner_playlist_basic_a2_suffix | content_owner_playlist_basic_a2_suffix |
| Actividad de los usuarios por provincia | p_content_owner_playlist_province_a2_suffix | content_owner_playlist_province_a2_suffix |
| Ubicaciones de reproducción | p_content_owner_playlist_playback_location_a2_suffix | content_owner_playlist_playback_location_a2 |
| Fuentes de tráfico | p_content_owner_playlist_traffic_source_a2 | content_owner_playlist_traffic_source_a2_suffix |
| Tipo de dispositivo y sistema operativo | p_content_owner_playlist_device_os_a2_suffix | content_owner_playlist_device_os_a2_suffix |
| Combinado | p_content_owner_playlist_combined_a2_suffix | content_owner_playlist_combined_a2_suffix |
| Informes de tarifas publicitarias | ||
| Informes de tarifas publicitarias | p_content_owner_ad_rates_a1_suffix | content_owner_ad_rates_a1_suffix |
| Informes de ingresos estimados | ||
| Ingresos estimados de vídeo | p_content_owner_estimated_revenue_a1_suffix | content_owner_estimated_revenue_a1_suffix |
| Ingresos estimados de los recursos | p_content_owner_asset_estimated_revenue_a1_suffix | content_owner_asset_estimated_revenue_a1_suffix |
| Informes de recursos | ||
| Actividad de los usuarios | p_content_owner_asset_basic_a3_suffix | content_owner_asset_basic_a3_suffix |
| Actividad de los usuarios por provincia | p_content_owner_asset_province_a3_suffix | content_owner_asset_province_a3_suffix |
| Ubicaciones de reproducción de vídeo | p_content_owner_asset_playback_location_a3_suffix | content_owner_asset_playback_location_a3_suffix |
| Fuentes de tráfico | p_content_owner_asset_traffic_source_a3_suffix | content_owner_asset_traffic_source_a3_suffix |
| Tipo de dispositivo y sistema operativo | p_content_owner_asset_device_os_a3_suffix | content_owner_asset_device_os_a3_suffix |
| Datos demográficos de la audiencia | p_content_owner_asset_demographics_a1_suffix | content_owner_asset_demographics_a1_suffix |
| Contenido compartido por plataforma | p_content_owner_asset_sharing_service_a1_suffix | content_owner_asset_sharing_service_a1_suffix |
| Anotaciones | p_content_owner_asset_annotations_a1_suffix | content_owner_asset_annotations_a1_suffix |
| Tarjetas | p_content_owner_asset_cards_a1_suffix | content_owner_asset_cards_a1_suffix |
| Pantallas finales | p_content_owner_asset_end_screens_a1_suffix | content_owner_asset_end_screens_a1_suffix |
| Combinado | p_content_owner_asset_combined_a3_suffix | content_owner_asset_combined_a3_suffix |
| Informes gestionados por el sistema de YouTube | Tabla de BigQuery | Vista de BigQuery |
|---|---|---|
| Informes "Ingresos publicitarios" | ||
| Resumen mensual de ingresos publicitarios globales | p_content_owner_global_ad_revenue_summary_a1_suffix | content_owner_global_ad_revenue_summary_a1_suffix |
| Resumen mensual de ingresos publicitarios por país | p_content_owner_country_ad_revenue_summary_a1_suffix | content_owner_country_ad_revenue_summary_a1_suffix |
| Resumen de ingresos publicitarios diarios mensuales | p_content_owner_day_ad_revenue_summary_a1_suffix | content_owner_day_ad_revenue_summary_a1_suffix |
| Resumen semanal de los ingresos publicitarios globales | p_content_owner_global_ad_revenue_summary_weekly_a1_suffix | content_owner_global_ad_revenue_summary_weekly_a1_suffix |
| Resumen semanal de los ingresos publicitarios por país | p_content_owner_country_ad_revenue_summary_weekly_a1_suffix | content_owner_country_ad_revenue_summary_weekly_a1_suffix |
| Resumen de ingresos publicitarios por día de la semana | p_content_owner_day_ad_revenue_summary_weekly_a1_suffix | content_owner_day_ad_revenue_summary_weekly_a1_suffix |
| Ingresos publicitarios agregados por vídeo | p_content_owner_ad_revenue_summary_a1_suffix | content_owner_ad_revenue_summary_a1_suffix |
| Resumen semanal de los ingresos publicitarios de vídeo | p_content_owner_ad_revenue_summary_weekly_a1_suffix | content_owner_ad_revenue_summary_weekly_a1_suffix |
| Ingresos semanales de los anuncios de vídeo | p_content_owner_ad_revenue_raw_weekly_a1_suffix | content_owner_ad_revenue_raw_weekly_a1_suffix |
| Ingresos publicitarios diarios por vídeo | p_content_owner_ad_revenue_raw_a1_suffix | content_owner_ad_revenue_raw_a1_suffix |
| Ingresos publicitarios agregados por recurso | p_content_owner_asset_ad_revenue_summary_a1_suffix | content_owner_asset_ad_revenue_summary_a1_suffix |
| Ingresos publicitarios diarios por recurso | p_content_owner_asset_ad_revenue_raw_a1_suffix | content_owner_asset_ad_revenue_raw_a1_suffix |
| Resumen mensual de ingresos publicitarios reclamados | p_content_owner_claim_ad_revenue_summary_a1_suffix | content_owner_claim_ad_revenue_summary_a1_suffix |
| Resumen semanal de los ingresos publicitarios de las reclamaciones | p_content_owner_claim_ad_revenue_summary_weekly_a1_suffix | content_owner_claim_ad_revenue_summary_weekly_a1_suffix |
| Ingresos publicitarios reclamados mensuales | p_content_owner_claim_ad_revenue_raw_a1_suffix | content_owner_claim_ad_revenue_raw_a1_suffix |
| Ingresos publicitarios de reclamaciones semanales | p_content_owner_claim_ad_revenue_raw_weekly_a1_suffix | content_owner_claim_ad_revenue_raw_weekly_a1_suffix |
| Resumen mensual de ingresos por ajustes de anuncios a nivel mundial | p_content_owner_global_ad_adjustment_revenue_summary_a1_suffix | content_owner_global_ad_adjustment_revenue_summary_a1_suffix |
| Resumen mensual de ingresos por ajustes de anuncios de recursos | p_content_owner_asset_ad_adjustment_revenue_summary_a1_suffix | content_owner_asset_ad_adjustment_revenue_summary_a1_suffix |
| Ingresos mensuales por ajustes de anuncios de recursos | p_content_owner_asset_ad_adjustment_revenue_raw_a1_suffix | content_owner_asset_ad_adjustment_revenue_raw_a1_suffix |
| Resumen mensual de ingresos por ajustes de anuncios de vídeo | p_content_owner_ad_adjustment_revenue_summary_a1_suffix | content_owner_ad_adjustment_revenue_summary_a1_suffix |
| Ingresos brutos por ajustes de anuncios de vídeo mensuales | p_content_owner_ad_adjustment_revenue_raw_a1_suffix | content_owner_ad_adjustment_revenue_raw_a1_suffix |
| Resumen mensual de ingresos por ajustes de anuncios reclamados | p_content_owner_claim_ad_adjustment_revenue_summary_a1_suffix | content_owner_claim_ad_adjustment_revenue_summary_a1_suffix |
| Ingresos mensuales por ajustes de anuncios reclamados | p_content_owner_claim_ad_adjustment_revenue_raw_a1_suffix | content_owner_claim_ad_adjustment_revenue_raw_a1_suffix |
| Resumen mensual de ingresos por ajustes de anuncios por país | p_content_owner_country_ad_adjustment_revenue_summary_a1_suffix | content_owner_country_ad_adjustment_revenue_summary_a1_suffix |
| Resumen mensual de ingresos por ajustes de anuncios por día | p_content_owner_day_ad_adjustment_revenue_summary_a1_suffix | content_owner_day_ad_adjustment_revenue_summary_a1_suffix |
| Informes "Ingresos por suscripciones" | ||
| Resumen de ingresos mensuales de música | p_content_owner_country_music_red_revenue_summary_a1_suffix | content_owner_country_music_red_revenue_summary_a1_suffix |
| Ingresos mensuales de vídeos de discográficas | p_music_content_owner_red_revenue_raw_a1_suffix | music_content_owner_red_revenue_raw_a1_suffix |
| Ingresos mensuales de los recursos de sellos discográficos | p_music_content_owner_asset_red_revenue_raw_a1_suffix | music_content_owner_asset_red_revenue_raw_a1_suffix |
| Resumen de ingresos mensuales de suscriptores de discográficas | p_music_content_owner_subscriber_red_revenue_summary_a1_suffix | music_content_owner_subscriber_red_revenue_summary_a1_suffix |
| Resumen de ingresos mensuales de editoriales musicales | p_publisher_content_owner_music_red_revenue_summary_a1_suffix | publisher_content_owner_music_red_revenue_summary_a1_suffix |
| Resumen de ingresos mensuales por suscripciones de editores musicales | p_publisher_content_owner_subscriber_red_revenue_summary_a1_suffix | publisher_content_owner_subscriber_red_revenue_summary_a1_suffix |
| Resumen de ingresos mensuales por suscripciones no musicales de editoriales musicales | p_publisher_content_owner_non_music_red_revenue_summary_a1_suffix | publisher_content_owner_non_music_red_revenue_summary_a1_suffix |
| Resumen mensual de los ingresos de música de la discográfica | p_music_content_owner_country_music_red_revenue_summary_a1_suffix | music_content_owner_country_music_red_revenue_summary_a1_suffix |
| Ingresos de vídeos musicales por suscripciones mensuales | p_content_owner_music_red_revenue_raw_a1_suffix | content_owner_music_red_revenue_raw_a1_suffix |
| Ingresos de activos musicales por suscripciones mensuales | p_content_owner_music_asset_red_revenue_raw_a1_suffix | content_owner_music_asset_red_revenue_raw_a1_suffix |
| Resumen semanal de ingresos por música | p_music_content_owner_country_music_red_revenue_summary_weekly_a1_suffix | music_content_owner_country_music_red_revenue_summary_weekly_a1_suffix |
| Ingresos semanales de vídeos de sellos discográficos | p_music_content_owner_red_revenue_raw_weekly_a1_suffix | music_content_owner_red_revenue_raw_weekly_a1_suffix |
| Ingresos semanales de los recursos de la discográfica | p_music_content_owner_asset_red_revenue_raw_weekly_a1_suffix | music_content_owner_asset_red_revenue_raw_weekly_a1_suffix |
| Resumen mensual de contenido no musical | p_content_owner_country_non_music_red_revenue_summary_a1_suffix | content_owner_country_non_music_red_revenue_summary_a1_suffix |
| Resumen mensual de ingresos no musicales de discográficas | p_music_content_owner_country_non_music_red_revenue_summary_a1_suffix | music_content_owner_country_non_music_red_revenue_summary_a1_suffix |
| Ingresos de vídeos no musicales por suscripciones mensuales | p_content_owner_non_music_red_revenue_raw_a1_suffix | content_owner_non_music_red_revenue_raw_a1_suffix |
| Ingresos de recursos no musicales por suscripciones mensuales | p_content_owner_non_music_asset_red_revenue_raw_a1_suffix | content_owner_non_music_asset_red_revenue_raw_a1_suffix |
| Resumen semanal de ingresos no musicales | 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 |
| Ingresos brutos mensuales por ajustes de suscripciones de recursos de discográficas | p_music_content_owner_asset_red_adjustment_revenue_raw_a1_suffix | music_content_owner_asset_red_adjustment_revenue_raw_a1_suffix |
| Vídeo musical sin editar de ajustes de suscripciones mensuales | p_music_content_owner_red_adjustment_revenue_raw_a1_suffix | music_content_owner_red_adjustment_revenue_raw_a1_suffix |
| Resumen de ingresos por ajustes de suscripciones de música country de una discográfica al mes | p_music_content_owner_country_music_red_adjustment_revenue_summary_a1_suffix | music_content_owner_country_music_red_adjustment_revenue_summary_a1_suffix |
| Resumen mensual de ingresos por ajustes de suscripciones no musicales por país de discográfica musical | 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 |
| Ingresos brutos por ajustes de suscripciones de recursos no musicales mensuales | p_content_owner_non_music_asset_red_adjustment_revenue_raw_a1_suffix | content_owner_non_music_asset_red_adjustment_revenue_raw_a1_suffix |
| Ingresos brutos por ajustes de suscripciones no musicales mensuales | p_content_owner_non_music_red_adjustment_revenue_raw_a1_suffix | content_owner_non_music_red_adjustment_revenue_raw_a1_suffix |
| Ingresos brutos mensuales por ajustes de suscripciones a vídeos musicales | p_content_owner_music_video_red_adjustment_revenue_raw_a1_suffix | content_owner_music_video_red_adjustment_revenue_raw_a1_suffix |
| Ingresos brutos por ajustes de suscripciones de recursos musicales mensuales | p_content_owner_music_asset_red_adjustment_revenue_raw_a1_suffix | content_owner_music_asset_red_adjustment_revenue_raw_a1_suffix |
| Ingresos brutos mensuales por ajustes de suscripciones a recursos de editores musicales | p_publisher_content_owner_asset_red_adjustment_revenue_raw_a1_suffix | publisher_content_owner_asset_red_adjustment_revenue_raw_a1_suffix |
| Resumen mensual de ingresos por ajustes de suscripciones no musicales por país de editor musical | 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 |
| Resumen mensual de ingresos por ajustes de suscripciones de música country de editores musicales | p_publisher_content_owner_country_music_red_adjustment_revenue_summary_a1_suffix | publisher_content_owner_country_music_red_adjustment_revenue_summary_a1_suffix |
| Informes "Ingresos de Shorts" | ||
| Resumen mensual de los ingresos de los propietarios de contenido de discográficas de YouTube Shorts | p_music_content_owner_shorts_revenue_summary_a1_suffix | music_content_owner_shorts_revenue_summary_a1_suffix |
| Resumen mensual de los ingresos de los propietarios de contenido de editoriales musicales de YouTube Shorts | p_publisher_content_owner_shorts_revenue_summary_a1_suffix | publisher_content_owner_shorts_revenue_summary_a1_suffix |
| Resumen mensual de los ingresos publicitarios globales de YouTube Shorts | p_content_owner_shorts_global_ad_revenue_summary_a2_suffix | content_owner_shorts_global_ad_revenue_summary_a2_suffix |
| Resumen diario de los ingresos publicitarios de YouTube Shorts | p_content_owner_shorts_day_ad_revenue_summary_a2_suffix | content_owner_shorts_day_ad_revenue_summary_a2_suffix |
| Resumen mensual de los ingresos publicitarios de YouTube Shorts por país | p_content_owner_shorts_country_ad_revenue_summary_a2_suffix | content_owner_shorts_country_ad_revenue_summary_a2_suffix |
| Resumen mensual de los ingresos publicitarios de YouTube Shorts | p_content_owner_shorts_ad_revenue_summary_a2_suffix | content_owner_shorts_ad_revenue_summary_a2_suffix |
| Resumen mensual de los ingresos por suscripciones de YouTube Shorts | p_content_owner_shorts_red_revenue_summary_a1_suffix | content_owner_shorts_red_revenue_summary_a1_suffix |
| Resumen mensual de los vídeos de YouTube Shorts que generaron ingresos por suscripciones | p_content_owner_shorts_red_revenue_video_summary_a1_suffix | content_owner_shorts_red_revenue_video_summary_a1_suffix |
| Informes de retención de impuestos | ||
| Retención de impuestos | p_content_owner_tax_withholding_a1_suffix | content_owner_tax_withholding_a1_suffix |
| Informes de vídeos | ||
| Metadatos de vídeo diarios (versión 1.4) | p_content_owner_video_metadata_a4_suffix | content_owner_video_metadata_a4_suffix |
| Informes de recursos | ||
| Informe diario de recursos | p_content_owner_asset_a3_suffix | content_owner_asset_a3_suffix |
| Conflictos de recursos diarios | p_content_owner_asset_conflict_a3_suffix | content_owner_asset_conflict_a3_suffix |
| Informes de referencias | ||
| Referencias semanales | p_content_owner_active_references_a1_suffix | content_owner_active_references_a1_suffix |
| Informes de reclamaciones | ||
| Reclamaciones diarias (versión 1.2) | p_content_owner_active_claims_a3_suffix | content_owner_active_claims_a3_suffix |