Transformación de informes de propietarios del contenido de YouTube
Cuando tus informes de propietario del contenido de YouTube o los 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 de ingresos publicitarios globales por mes | p_content_owner_global_ad_revenue_summary_a1_suffix | content_owner_global_ad_revenue_summary_a1_suffix |
| Resumen de ingresos publicitarios mensuales 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 de ingresos publicitarios globales por semana | 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 relacionados con música | p_content_owner_country_music_red_revenue_summary_a1_suffix | content_owner_country_music_red_revenue_summary_a1_suffix |
| Resumen de ingresos mensuales que no se relacionan con música | p_content_owner_country_non_music_red_revenue_summary_a1_suffix | content_owner_country_non_music_red_revenue_summary_a1_suffix |
| Ingresos mensuales de activos musicales por suscripciones | 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 por suscripciones | 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 no musicales por suscripciones | p_content_owner_non_music_red_revenue_raw_a1_suffix | content_owner_non_music_red_revenue_raw_a1_suffix |
| Ingresos mensuales por activos de sellos discográficos | p_music_content_owner_asset_red_revenue_raw_a1_suffix | music_content_owner_asset_red_revenue_raw_a1_suffix |
| Ingresos semanales por activos de sellos discográficos | 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 de sellos discográficos | p_music_content_owner_country_music_red_revenue_summary_a1_suffix | music_content_owner_country_music_red_revenue_summary_a1_suffix |
| Resumen de ingresos semanales de 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 |
| Resumen de ingresos mensuales de sellos discográficos que no se relacionan con música | 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 no musicales semanales | 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 por videos de sellos discográficos | p_music_content_owner_red_revenue_raw_a1_suffix | music_content_owner_red_revenue_raw_a1_suffix |
| Ingresos semanales por videos de sellos discográficos | p_music_content_owner_red_revenue_raw_weekly_a1_suffix | music_content_owner_red_revenue_raw_weekly_a1_suffix |
| Resumen de ingresos mensuales por suscriptores de sellos discográficos | p_music_content_owner_subscriber_red_revenue_summary_a1_suffix | music_content_owner_subscriber_red_revenue_summary_a1_suffix |