Transformación de informes de propietarios del contenido de YouTube
Cuando tus informes de propietario del contenido de YouTube o administrados por el sistema se transfieren a BigQuery, los informes se transforman en las siguientes tablas y vistas de BigQuery.
Cuando ves las tablas y vistas en BigQuery, el valor de suffix es el sufijo de la tabla que configuraste cuando creaste la transferencia.
| Informe de propietario del contenido de YouTube | Tabla de BigQuery | Vista de BigQuery |
|---|---|---|
| Informes de video | ||
| Actividad del usuario | p_content_owner_basic_a3_suffix | content_owner_basic_a3_suffix |
| Actividad del usuario por provincia | p_content_owner_province_a2_suffix | content_owner_province_a2_suffix |
| Ubicaciones de reproducción | p_content_owner_playback_location_a2_suffix | content_owner_playback_location_a2_suffix |
| Fuentes de tráfico | p_content_owner_traffic_source_a2_suffix | content_owner_traffic_source_a2_suffix |
| Tipo de dispositivo y sistema operativo | p_content_owner_device_os_a2_suffix | content_owner_device_os_a2_suffix |
| Datos demográficos del usuario | 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_a2_suffix | content_owner_subtitles_a2_suffix |
| Combinado | p_content_owner_combined_a2_suffix | content_owner_combined_a2_suffix |
| Informes de lista de reproducción | ||
| Actividad del usuario | p_content_owner_playlist_basic_a1_suffix | content_owner_playlist_basic_a1_suffix |
| Actividad del usuario por provincia | p_content_owner_playlist_province_a1_suffix | content_owner_playlist_province_a1_suffix |
| Ubicaciones de reproducción | p_content_owner_playlist_playback_location_a1_suffix | content_owner_playlist_playback_location_a1 |
| Fuentes de tráfico | p_content_owner_playlist_traffic_source_a1 | content_owner_playlist_traffic_source_a1_suffix |
| Tipo de dispositivo y sistema operativo | p_content_owner_playlist_device_os_a1_suffix | content_owner_playlist_device_os_a1_suffix |
| Combinado | p_content_owner_playlist_combined_a1_suffix | content_owner_playlist_combined_a1_suffix |
| Informes de tarifas de ingresos publicitarios | ||
| Informes de tarifas de ingresos publicitarios | p_content_owner_ad_rates_a1_suffix | content_owner_ad_rates_a1_suffix |
| Informes de ingresos estimados | ||
| Ingresos estimados de video | p_content_owner_estimated_revenue_a1_suffix | content_owner_estimated_revenue_a1_suffix |
| Ingresos estimados de activos | p_content_owner_asset_estimated_revenue_a1_suffix | content_owner_asset_estimated_revenue_a1_suffix |
| Informes de activos | ||
| Actividad del usuario | p_content_owner_asset_basic_a2_suffix | content_owner_asset_basic_a2_suffix |
| Actividad del usuario por provincia | p_content_owner_asset_province_a2_suffix | content_owner_asset_province_a2_suffix |
| Ubicaciones de reproducción de video | p_content_owner_asset_playback_location_a2_suffix | content_owner_asset_playback_location_a2_suffix |
| Fuentes de tráfico | p_content_owner_asset_traffic_source_a2_suffix | content_owner_asset_traffic_source_a2_suffix |
| Tipo de dispositivo y sistema operativo | p_content_owner_asset_device_os_a2_suffix | content_owner_asset_device_os_a2_suffix |
| Datos demográficos del usuario | 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_a2_suffix | content_owner_asset_combined_a2_suffix |
| Informes administrados por el sistema de YouTube | Tabla de BigQuery | Vista de BigQuery |
|---|---|---|
| Informes de ingresos por 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 los 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 mensuales por ingresos publicitarios | p_content_owner_day_ad_revenue_summary_a1_suffix | content_owner_day_ad_revenue_summary_a1_suffix |
| Resumen semanal de ingresos publicitarios globales | p_content_owner_global_ad_revenue_summary_weekly_a1_suffix | content_owner_global_ad_revenue_summary_weekly_a1_suffix |
| Resumen de ingresos publicitarios semanales por ingresos publicitarios de 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 | p_content_owner_day_ad_revenue_summary_weekly_a1_suffix | content_owner_day_ad_revenue_summary_weekly_a1_suffix |
| Agregación de ingresos publicitarios por ingresos publicitarios por video | p_content_owner_ad_revenue_summary_a1_suffix | content_owner_ad_revenue_summary_a1_suffix |
| Resumen de ingresos semanales por ingresos publicitarios de video | p_content_owner_ad_revenue_summary_weekly_a1_suffix | content_owner_ad_revenue_summary_weekly_a1_suffix |
| Ingresos por ingresos publicitarios de video semanales | p_content_owner_ad_revenue_raw_weekly_a1_suffix | content_owner_ad_revenue_raw_weekly_a1_suffix |
| Ingresos por ingresos publicitarios diarios por video | p_content_owner_ad_revenue_raw_a1_suffix | content_owner_ad_revenue_raw_a1_suffix |
| Agregación de ingresos por ingresos publicitarios por activo | p_content_owner_asset_ad_revenue_summary_a1_suffix | content_owner_asset_ad_revenue_summary_a1_suffix |
| Ingresos por ingresos publicitarios diarios por activo | p_content_owner_asset_ad_revenue_raw_a1_suffix | content_owner_asset_ad_revenue_raw_a1_suffix |
| Resumen de ingresos mensuales por ingresos publicitarios | p_content_owner_claim_ad_revenue_summary_a1_suffix | content_owner_claim_ad_revenue_summary_a1_suffix |
| Resumen de ingresos por ingresos publicitarios semanales | p_content_owner_claim_ad_revenue_summary_weekly_a1_suffix | content_owner_claim_ad_revenue_summary_weekly_a1_suffix |
| Ingresos publicitarios mensuales de reclamos | p_content_owner_claim_ad_revenue_raw_a1_suffix | content_owner_claim_ad_revenue_raw_a1_suffix |
| Ingresos por ingresos publicitarios semanales | p_content_owner_claim_ad_revenue_raw_weekly_a1_suffix | content_owner_claim_ad_revenue_raw_weekly_a1_suffix |
| Informes de ingresos por suscripciones | ||
| Resumen de ingresos mensuales por música | p_content_owner_country_music_red_revenue_summary_a1_suffix | content_owner_country_music_red_revenue_summary_a1_suffix |
| Resumen mensual sin música | p_content_owner_country_non_music_red_revenue_Summary_a1_suffix | content_owner_country_non_music_red_revenue_summary_a1_suffix |
| Ingresos por activos de música por suscripciones mensuales | p_content_owner_music_asset_red_revenue_raw_a1_suffix | content_owner_music_asset_red_revenue_raw_a1_suffix |
| Ingresos mensuales de videos musicales de suscripciones | p_content_owner_music_red_revenue_raw_a1_suffix | content_owner_music_red_revenue_raw_a1_suffix |
| Ingresos mensuales de activos no musicales | p_content_owner_non_music_asset_red_revenue_raw_a1_suffix | content_owner_non_music_asset_red_revenue_raw_a1_suffix |
| Ingresos mensuales de videos que no son de música | p_content_owner_non_music_red_revenue_raw_a1_suffix | content_owner_non_music_red_revenue_raw_a1_suffix |
| Ingresos por activos mensuales de etiquetas de música | p_music_content_owner_asset_red_revenue_raw_a1_suffix | Music_content_owner_asset_red_revenue_raw_a1_suffix |
| Ingresos semanales de activos de etiquetas de música | p_music_content_owner_asset_red_revenue_raw_weekly_a1_suffix | music_content_owner_asset_red_revenue_raw_weekly_a1_suffix |
| Resumen de ingresos mensuales del sello discográfico | p_music_content_owner_country_music_red_revenue_summary_a1_suffix | music_content_owner_country_music_red_revenue_summary_a1_suffix |
| Resumen de ingresos por música semanal | p_music_content_owner_country_music_red_revenue_summary_weekly_a1_suffix | music_content_owner_country_music_red_revenue_summary_weekly_a1_suffix |
| Resumen de ingresos mensuales de etiquetas de música no musicales | p_music_content_owner_country_non_music_red_revenue_summary_a1_suffix | music_content_owner_country_non_music_red_revenue_summary_a1_suffix |
| Resumen de ingresos semanales que no son de música | 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 mensuales de video de etiquetas de música | p_music_content_owner_red_revenue_raw_a1_suffix | music_content_owner_red_revenue_raw_a1_suffix |
| Ingresos semanales de videos de etiquetas de música | p_music_content_owner_red_revenue_raw_weekly_a1_suffix | music_content_owner_red_revenue_raw_weekly_a1_suffix |
| Resumen de ingresos de suscriptores de etiquetas de música mensuales | p_music_content_owner_subscriber_red_revenue_summary_a1_suffix | music_content_owner_subscriber_red_revenue_summary_a1_suffix |