Transformação de relatórios do Campaign Manager
Quando os ficheiros de transferência de dados do Campaign Manager (anteriormente conhecido como DoubleClick Campaign Manager) são transferidos para o BigQuery, os ficheiros são transformados nas seguintes tabelas e vistas do BigQuery.
Quando vê as tabelas e as vistas no BigQuery, o valor de campaign_manager_id é a sua rede do Campaign Manager, anunciante ou ID do Floodlight.
| Ficheiro do Campaign Manager | Tabela do BigQuery | Vista do BigQuery |
|---|---|---|
| Ficheiros da Transferência de dados | ||
| impressão | p_impression_campaign_manager_id | impression_campaign_manager_id |
| clique | p_click_campaign_manager_id | click_campaign_manager_id |
| atividade | p_activity_campaign_manager_id | activity_campaign_manager_id |
| rich_media | p_rich_media_campaign_manager_id | rich_media_campaign_manager_id |
| Tabelas de correspondência | ||
| activity_cats | p_match_table_activity_cats_campaign_manager_id | match_table_activity_cats_campaign_manager_id |
| activity_types | p_match_table_activity_types_campaign_manager_id | match_table_activity_types_campaign_manager_id |
| anúncios | p_match_table_ads_campaign_manager_id | match_table_ads_campaign_manager_id |
| ad_placement_assignments | p_match_table_ad_placement_assignments_campaign_manager_id | match_table_ad_placement_assignments_campaign_manager_id |
| anunciantes | p_match_table_advertisers_campaign_manager_id | match_table_advertisers_campaign_manager_id |
| recursos | p_match_table_assets_campaign_manager_id | match_table_assets_campaign_manager_id |
| navegadores | p_match_table_browsers_campaign_manager_id | match_table_browsers_campaign_manager_id |
| campanhas | p_match_table_campaigns_campaign_manager_id | match_table_campaigns_campaign_manager_id |
| cities | p_match_table_cities_campaign_manager_id | match_table_cities_campaign_manager_id |
| criativos | p_match_table_creatives_campaign_manager_id | match_table_creatives_campaign_manager_id |
| creative_ad_assignments | p_match_table_creative_ad_assignments_campaign_manager_id | match_table_creative_ad_assignments_campaign_manager_id |
| custom_creative_fields | p_match_table_custom_creative_fields_campaign_manager_id | match_table_custom_creative_fields_campaign_manager_id |
| paid_search | p_match_table_paid_search_campaign_manager_id | match_table_paid_search_campaign_manager_id |
| designated_market_areas | p_match_table_designated_market_areas_campaign_manager_id | match_table_designated_market_areas_campaign_manager_id |
| keyword_value | p_match_table_keyword_value_campaign_manager_id | match_table_keyword_value_campaign_manager_id |
| Categorias de motivos do ID do utilizador nulo | Atualmente não suportado | Atualmente não suportado |
| ID do evento padrão e do tipo de evento de meios interativos | Atualmente não suportado | Atualmente não suportado |
| custom_rich_media | p_match_table_custom_rich_media_campaign_manager_id | match_table_custom_rich_media_campaign_manager_id |
| operating_systems | p_match_table_operating_systems_campaign_manager_id | match_table_operating_systems_campaign_manager_id |
| posicionamentos | p_match_table_placements_campaign_manager_id | match_table_placements_campaign_manager_id |
| placement_cost | p_match_table_placement_cost_campaign_manager_id | match_table_placement_cost_campaign_manager_id |
| sites | p_match_table_sites_campaign_manager_id | match_table_sites_campaign_manager_id |
| estados | p_match_table_states_campaign_manager_id | match_table_states_campaign_manager_id |
| custom_floodlight_variables | p_match_table_custom_floodlight_variables_campaign_manager_id | match_table_custom_floodlight_variables_campaign_manager_id |
| landing_page_url | p_match_table_landing_page_url_campaign_manager_id | match_table_landing_page_url_campaign_manager_id |