Campaign Manager 報表轉換
當您的 Campaign Manager (原名為 DoubleClick Campaign Manager) 資料移轉檔案移轉到 BigQuery 時，檔案會轉換成下列 BigQuery 表格和視圖。
當您在 BigQuery 中檢視資料表和檢視表時，campaign_manager_id 的值是您的 Campaign Manager Network、廣告客戶或 Floodlight ID。
| Campaign Manager 檔案 | BigQuery 資料表 | BigQuery 檢視表 |
|---|---|---|
| 資料移轉檔案 | ||
| 曝光 | p_impression_campaign_manager_id | impression_campaign_manager_id |
| 點擊 | p_click_campaign_manager_id | click_campaign_manager_id |
| activity | p_activity_campaign_manager_id | activity_campaign_manager_id |
| rich_media | p_rich_media_campaign_manager_id | rich_media_campaign_manager_id |
| 比對資料表 | ||
| 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 |
| ads | 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 |
| 廣告主 | p_match_table_advertisers_campaign_manager_id | match_table_advertisers_campaign_manager_id |
| assets | p_match_table_assets_campaign_manager_id | match_table_assets_campaign_manager_id |
| 瀏覽器 | p_match_table_browsers_campaign_manager_id | match_table_browsers_campaign_manager_id |
| 廣告活動 | p_match_table_campaigns_campaign_manager_id | match_table_campaigns_campaign_manager_id |
| 城市 | p_match_table_cities_campaign_manager_id | match_table_cities_campaign_manager_id |
| 廣告素材 | 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 |
| null 使用者 ID 原因類別 | 目前不支援 | 目前不支援 |
| 互動式多媒體標準事件和事件類型 ID | 目前不支援 | 目前不支援 |
| 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 |
| 刊登位置 | 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 |
| states | 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 |