Campaign Manager report transformation

When your Campaign Manager (formerly known as DoubleClick Campaign Manager) data transfer files are transferred to BigQuery, the files are transformed into the following BigQuery tables and views.

When you view the tables and views in BigQuery, the value for campaign_manager_id is your Campaign Manager Network, Advertiser, or Floodlight ID.

Campaign Manager file	BigQuery table	BigQuery view
Data Transfer files
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`
Match Tables
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 user ID reason categories	Currently unsupported	Currently unsupported
rich media standard event and event type IDs	Currently unsupported	Currently unsupported
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`