Campaign Manager 보고서 변환
Campaign Manager(이전 명칭: DoubleClick Campaign Manager) 데이터 전송 파일이 BigQuery로 전송되면 파일은 다음과 같은 BigQuery 표와 뷰로 변환됩니다.
BigQuery에서 테이블과 뷰를 볼 때 campaign_manager_id 값은 Campaign Manager 네트워크, 광고주, 플러드라이트 ID입니다.
Campaign Manager 파일 | BigQuery 테이블 | BigQuery 뷰 |
---|---|---|
데이터 전송 파일 | ||
impression | p_impression_campaign_manager_id | impression_campaign_manager_id |
click | 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 |
advertisers | 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 |
browsers | p_match_table_browsers_campaign_manager_id | match_table_browsers_campaign_manager_id |
campaigns | 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 |
creatives | 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 |
placements | 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 |