Transformación de informes de Campaign Manager

Cuando los archivos de transferencia de datos de Campaign Manager (antes conocido como DoubleClick Campaign Manager) se transfieren a BigQuery, los archivos se transforman en las siguientes tablas y vistas de BigQuery.

Cuando veas las tablas y vistas en BigQuery, el valor de [DOUBLECLICK_ID] es tu red de Campaign Manager Network, anunciante o ID Floodlight.

Archivo de Campaign Manager Tabla de BigQuery Vista de BigQuery
Archivos de transferencia de datos
Impresión p_impression_[DOUBLECLICK_ID] impression_[DOUBLECLICK_ID]
Clic p_click_[DOUBLECLICK_ID] click_[DOUBLECLICK_ID]
Actividad p_activity_[DOUBLECLICK_ID] activity_[DOUBLECLICK_ID]
Rich Media p_rich_media_[DOUBLECLICK_ID] rich_media_[DOUBLECLICK_ID]
Tablas de coincidencia
activity_cats p_match_table_activity_cats_[DOUBLECLICK_ID] match_table_activity_cats_[DOUBLECLICK_ID]
activity_types p_match_table_activity_types_[DOUBLECLICK_ID] match_table_activity_types_[DOUBLECLICK_ID]
Anuncios p_match_table_ads_[DOUBLECLICK_ID] match_table_ads_[DOUBLECLICK_ID]
ad_placement_assignments p_match_table_ad_placement_assignments_[DOUBLECLICK_ID] match_table_ad_placement_assignments_[DOUBLECLICK_ID]
Anunciantes p_match_table_advertisers_[DOUBLECLICK_ID] match_table_advertisers_[DOUBLECLICK_ID]
Elementos p_match_table_assets_[DOUBLECLICK_ID] match_table_assets_[DOUBLECLICK_ID]
Navegadores p_match_table_browsers_[DOUBLECLICK_ID] match_table_browsers_[DOUBLECLICK_ID]
Campañas p_match_table_campaigns_[DOUBLECLICK_ID] match_table_campaigns_[DOUBLECLICK_ID]
Ciudades p_match_table_cities_[DOUBLECLICK_ID] match_table_cities_[DOUBLECLICK_ID]
Creatividades p_match_table_creatives_[DOUBLECLICK_ID] match_table_creatives_[DOUBLECLICK_ID]
creative_ad_assignments p_match_table_creative_ad_assignments_[DOUBLECLICK_ID] match_table_creative_ad_assignments_[DOUBLECLICK_ID]
custom_creative_fields p_match_table_custom_creative_fields_[DOUBLECLICK_ID] match_table_custom_creative_fields_[DOUBLECLICK_ID]
paid_search p_match_table_paid_search_[DOUBLECLICK_ID] match_table_paid_search_[DOUBLECLICK_ID]
designated_market_areas p_match_table_designated_market_areas_[DOUBLECLICK_ID] match_table_designated_market_areas_[DOUBLECLICK_ID]
keyword_value p_match_table_keyword_value_[DOUBLECLICK_ID] match_table_keyword_value_[DOUBLECLICK_ID]
Categorías de motivos de ID de usuario nulo Actualmente no es compatible Actualmente no es compatible
ID de tipo de evento y evento estándar de rich media Actualmente no es compatible Actualmente no es compatible
custom_rich_media p_match_table_custom_rich_media_[DOUBLECLICK_ID] match_table_custom_rich_media_[DOUBLECLICK_ID]
Sistemas operativos p_match_table_operating_systems_[DOUBLECLICK_ID] match_table_operating_systems_[DOUBLECLICK_ID]
Posiciones p_match_table_placements_[DOUBLECLICK_ID] match_table_placements_[DOUBLECLICK_ID]
placement_cost p_match_table_placement_cost_[DOUBLECLICK_ID] match_table_placement_cost_[DOUBLECLICK_ID]
Sitios p_match_table_sites_[DOUBLECLICK_ID] match_table_sites_[DOUBLECLICK_ID]
Estados p_match_table_states_[DOUBLECLICK_ID] match_table_states_[DOUBLECLICK_ID]
custom_floodlight_variables p_match_table_custom_floodlight_variables_[DOUBLECLICK_ID] match_table_custom_floodlight_variables_[DOUBLECLICK_ID]
landing_page_url p_match_table_landing_page_url_[DOUBLECLICK_ID] match_table_landing_page_url_[DOUBLECLICK_ID]
¿Te sirvió esta página? Envíanos tu opinión:

Enviar comentarios sobre…

¿Necesitas ayuda? Visita nuestra página de asistencia.