The new Search Ads 360 Reporting API is now available. Join the searchads-api-announcements Google group to stay up to date on upcoming enhancements and releases.

Field mappings for Search Ads 360 Reporting API

The following tables map fields in the old Search Ads 360 API to resources in the new Search Ads 360 Reporting API.

Account report

Column names in the `account` report	new Search Ads 360 Reporting API mapping
`absoluteTopImpressionPercentage`	`metrics.absolute_top_impression_percentage`
`account`	`customer.descriptive_name`
`accountCurrencyCode`	`customer.currency_code`
`accountEngineId`	`customer.engine_id`
`accountId`	`customer.id`
`accountTimeZone`	`customer.time_zone`
`accountType`	`customer.account_type`
`advertiser`	See account management
`advertiserId`	See account management
`adWordsConversions`	`metrics.client_account_conversions`
`adWordsConversionValue`	`metrics.client_account_conversions_value`
`adWordsViewThroughConversions`	`metrics.client_account_view_through_conversions`
`agency`	See account management
`agencyId`	See account management
`avgCpc`	`metrics.average_cpc`
`avgCpm`	`metrics.average_cpm`
`avgPos`	Behavior change
`clicks`	`metrics.clicks`
`cost`	`metrics.cost_micros`
`creationTimestamp`	`customer.creation_time`
`ctr`	`metrics.ctr`
`date`	`segments.date`
`deviceSegment`	`segments.device`
`dfaActions`	`metrics.all_conversions_by_conversion_date` - `metrics.cross_device_conversions_by_conversion_date`
`dfaActionsCrossEnv`	`metrics.all_conversions_by_conversion_date`
`dfaRevenue`	`metrics.all_conversions_value_by_conversion_date` - `metrics.cross_device_conversions_value_by_conversion_date`
`dfaRevenueCrossEnv`	`metrics.all_conversions_value_by_conversion_date`
`dfaTransactions`	`metrics.all_conversions_by_conversion_date` - `metrics.cross_device_conversions_by_conversion_date`
`dfaTransactionsCrossEnv`	`metrics.all_conversions_by_conversion_date`
`dfaWeightedActions`	Behavior change
`dfaWeightedActionsCrossEnv`	Behavior change
`displayBudgetLostImpressionShare`	`metrics.content_budget_lost_impression_share`
`displayImpressionShare`	`metrics.content_impression_share`
`displayRankLostImpressionShare`	`metrics.content_rank_lost_impression_share`
`floodlightActivity`	`segments.conversion_action_name`
`floodlightActivityId`	Use `conversion_action`
`floodlightActivityTag`	Use `conversion_action`
`floodlightGroup`	Behavior change
`floodlightGroupId`	Behavior change
`floodlightGroupTag`	Use `conversion_action`
`impr`	`metrics.impressions`
`lastModifiedTimestamp`	`customer.last_modified_time`
`monthEnd`	Behavior change
`monthStart`	`segments.month`
`qualityScoreAvg`	`metrics.historical_quality_score`
`quarterEnd`	Behavior change
`quarterStart`	`segments.quarter`
`searchAbsoluteTopImpressionShare`	`metrics.search_absolute_top_impression_share`
`searchBudgetLostAbsoluteTopImpressionShare`	`metrics.search_budget_lost_absolute_top_impression_share`
`searchBudgetLostImpressionShare`	`metrics.search_budget_lost_impression_share`
`searchBudgetLostTopImpressionShare`	`metrics.search_budget_lost_top_impression_share`
`searchImpressionShare`	`metrics.search_impression_share`
`searchRankLostAbsoluteTopImpressionShare`	`metrics.search_rank_lost_absolute_top_impression_share`
`searchRankLostImpressionShare`	`metrics.search_rank_lost_impression_share`
`searchRankLostTopImpressionShare`	`metrics.search_rank_lost_top_impression_share`
`searchTopImpressionShare`	`metrics.search_top_impression_share`
`status`	`customer.status`
`topImpressionPercentage`	`metrics.top_impression_percentage`
`topOfPageBidAvg`	Behavior change
`visits`	`metrics.visits`
`weekEnd`	Behavior change
`weekStart`	`segments.week`
`yearEnd`	Behavior change
`yearStart`	`segments.year`

Ad report

Column names in the `ad` report	new Search Ads 360 Reporting API mapping
`account`	`customer.descriptive_name`
`accountEngineId`	`customer.engine_id`
`accountId`	`customer.id`
`accountType`	`customer.account_type`
`ad`	`ad_group_ad.ad.name`
`adDescription1`	`ad_group_ad.ad.{ad type}.description1`¹
`adDescription2`	`ad_group_ad.ad.{ad type}.description2`¹
`adDisplayUrl`	`ad_group_ad.ad.display_url`
`adEngineId`	`ad_group_ad.engine_id` or `ad_group_ad.ad.id`²
`adGroup`	`ad_group.name`
`adGroupId`	`ad_group.id`
`adGroupStatus`	`ad_group.status`
`adHeadline`	`ad_group_ad.ad.{ad type}.headline`³
`adHeadline2`	`ad_group_ad.ad.expanded_text_ad.headline2`
`adHeadline3`	`ad_group_ad.ad.expanded_text_ad.headline3`
`adId`	`ad_group_ad.ad.id`
`adLabels`	`ad_group_ad.labels`
`adLandingPage`	`ad_group_ad.ad.final_urls`
`adPathField1`	`ad_group_ad.ad.{ad type}.path1`⁴
`adPathField2`	`ad_group_ad.ad.{ad type}.path2`⁴
`adPromotionLine`	Behavior change
`adType`	`ad_group_ad.ad.type`
`advertiser`	See account management
`advertiserId`	See account management
`adWordsConversions`	`metrics.client_account_conversions`
`adWordsConversionValue`	`metrics.client_account_conversions_value`
`adWordsViewThroughConversions`	`metrics.client_account_view_through_conversions`
`agency`	See account management
`agencyId`	See account management
`avgCpc`	`metrics.average_cpc`
`avgCpm`	`metrics.average_cpm`
`avgPos`	Behavior change
`campaign`	`campaign.name`
`campaignId`	`campaign.id`
`campaignStatus`	`campaign.status`
`clicks`	`metrics.clicks`
`cost`	`metrics.cost_micros`
`creationTimestamp`	`ad_group_ad.creation_time`
`ctr`	`metrics.ctr`
`date`	`segments.date`
`deviceSegment`	`segments.device`
`dfaActions`	`metrics.all_conversions_by_conversion_date` - `metrics.cross_device_conversions_by_conversion_date`
`dfaActionsCrossEnv`	`metrics.all_conversions_by_conversion_date`
`dfaRevenue`	`metrics.all_conversions_value_by_conversion_date` - `metrics.cross_device_conversions_value_by_conversion_date`
`dfaRevenueCrossEnv`	`metrics.all_conversions_value_by_conversion_date`
`dfaTransactions`	`metrics.all_conversions_by_conversion_date` - `metrics.cross_device_conversions_by_conversion_date`
`dfaTransactionsCrossEnv`	`metrics.all_conversions_by_conversion_date`
`dfaWeightedActions`	Behavior change
`dfaWeightedActionsCrossEnv`	Behavior change
`effectiveLabels`	`Not available in V0`
`engineStatus`	`ad_group_ad.engine_status`
`floodlightActivity`	`segments.conversion_action_name`
`floodlightActivityId`	Use `conversion_action`
`floodlightActivityTag`	Use `conversion_action`
`floodlightGroup`	Behavior change
`floodlightGroupId`	Behavior change
`floodlightGroupTag`	Use `conversion_action`
`impr`	`metrics.impressions`
`isUnattributedAd`	`Not available`
`lastModifiedTimestamp`	`ad_group_ad.last_modified_time`
`monthEnd`	Behavior change
`monthStart`	`segments.month`
`quarterEnd`	Behavior change
`quarterStart`	`segments.quarter`
`status`	`ad_group_ad.status`
`visits`	`metrics.visits`
`weekEnd`	Behavior change
`weekStart`	`segments.week`
`yearEnd`	Behavior change
`yearStart`	`segments.year`

AdGroup report

Column names in the `adGroup` report	new Search Ads 360 Reporting API mapping
`absoluteTopImpressionPercentage`	`metrics.absolute_top_impression_percentage`
`account`	`customer.descriptive_name`
`accountEngineId`	`customer.engine_id`
`accountId`	`customer.id`
`accountType`	`customer.account_type`
`adGroup`	`ad_group.name`
`adGroupBroadMaxCpc`	Behavior change
`adGroupContentMaxCpc`	Behavior change
`adGroupDesktopBidAdjustment`	`ad_group_bid_modifier`
`adGroupEndDate`	`ad_group.end_date`
`adGroupEngineId`	`ad_group.engine_id`
`adGroupExactMaxCpc`	Behavior change
`adGroupId`	`ad_group.id`
`adGroupLabels`	`ad_group.labels label.name`
`adGroupMobileBidAdjustment`	`ad_group_bid_modifier`
`adGroupPhraseMaxCpc`	Behavior change
`adGroupSearchMaxCpc`	`ad_group.cpc_bid_micros`
`adGroupStartDate`	`ad_group.start_date`
`adGroupStatus`	`ad_group.status`
`adGroupTabletBidAdjustment`	`ad_group_bid_modifier`
`adGroupType`	`ad_group.type`
`adRotation`	`ad_group.ad_rotation_mode`
`advertiser`	See account management
`advertiserId`	See account management
`adWordsConversions`	`metrics.client_account_conversions`
`adWordsConversionValue`	`metrics.client_account_conversions_value`
`adWordsViewThroughConversions`	`metrics.client_account_view_through_conversions`
`agency`	See account management
`agencyId`	See account management
`appId`	`asset.mobile_app_asset.app_id`
`appStore`	`asset.mobile_app_asset.app_store`
`avgCpc`	`metrics.average_cpc`
`avgCpm`	`metrics.average_cpm`
`avgPos`	Behavior change
`bidStrategyInherited`	Behavior change
`bingAdsAdDistributions`	Behavior change
`bingAdsLanguage`	`ad_group.language_code`
`callCallOnly`	Behavior change
`callConversionTracker`	`asset.call_asset.call_conversion_action`
`callConversionTrackerId`	Behavior change
`callCountryCode`	`asset.call_asset.country_code`
`callIsTracked`	`asset.call_asset.call_tracking_enabled`
`callPhoneNumber`	`asset.call_asset.phone_number`
`campaign`	`campaign.name`
`campaignId`	`campaign.id`
`campaignStatus`	`campaign.status`
`cityTargets`	`ad_group_criterion.location.geo_target_constant`
`clicks`	`metrics.clicks`
`clicksWithFeedItemShowing`	Behavior change
`cost`	`metrics.cost_micros`
`costWithFeedItemShowing`	Behavior change
`countryTargets`	`ad_group_criterion.location.geo_target_constant`
`creationTimestamp`	`ad_group.creation_time`
`ctr`	`metrics.ctr`
`date`	`segments.date`
`deviceSegment`	`segments.device`
`deviceTargets`	`ad_group_bid_modifier.device.type`
`dfaActions`	`metrics.all_conversions_by_conversion_date` - `metrics.cross_device_conversions_by_conversion_date`
`dfaActionsCrossEnv`	`metrics.all_conversions_by_conversion_date`
`dfaRevenue`	`metrics.all_conversions_value_by_conversion_date` - `metrics.cross_device_conversions_value_by_conversion_date`
`dfaRevenueCrossEnv`	`metrics.all_conversions_value_by_conversion_date`
`dfaTransactions`	`metrics.all_conversions_by_conversion_date` - `metrics.cross_device_conversions_by_conversion_date`
`dfaTransactionsCrossEnv`	`metrics.all_conversions_by_conversion_date`
`dfaWeightedActions`	Behavior change
`dfaWeightedActionsCrossEnv`	Behavior change
`displayImpressionShare`	`metrics.content_impression_share`
`displayRankLostImpressionShare`	`metrics.content_rank_lost_impression_share`
`effectiveBidStrategy`	`bidding_strategy.name`
`effectiveBidStrategyId`	`bidding_strategy.id`
`effectiveCityTargets`	`Same as cityTargets`
`effectiveCountryTargets`	`Same as countryTargets`
`effectiveDeviceTargets`	`ad_group_bid_modifier.device.type`
`effectiveLabels`	`Not available in V0`
`effectiveMetroTargets`	`Same as metroTargets`
`effectiveProvinceTargets`	`Same as provinceTargets`
`engineRemarketingListTargetAll`	`ad_group.targeting_setting.target_restrictions`
`engineStatus`	`ad_group.engine_status`
`feedId`	`asset_set.id`
`feedItemId`	`asset.id`
`feedType`	`asset.type`
`floodlightActivity`	`segments.conversion_action_name`
`floodlightActivityId`	Use `conversion_action`
`floodlightActivityTag`	Use `conversion_action`
`floodlightGroup`	Behavior change
`floodlightGroupId`	Behavior change
`floodlightGroupTag`	Use `conversion_action`
`impr`	`metrics.impressions`
`lastModifiedTimestamp`	`ad_group.last_modified_time`
`locationBusinessName`	`Not available in V0`
`locationCategory`	Behavior change
`locationDetails`	`Not available in V0`
`locationFilter`	Behavior change
`metroTargets`	`ad_group_criterion.location.geo_target_constant`
`monthEnd`	Behavior change
`monthStart`	`segments.month`
`provinceTargets`	`ad_group_criterion.location.geo_target_constant`
`qualityScoreAvg`	`metrics.historical_quality_score`
`quarterEnd`	Behavior change
`quarterStart`	`segments.quarter`
`searchAbsoluteTopImpressionShare`	`metrics.search_absolute_top_impression_share`
`searchImpressionShare`	`metrics.search_impression_share`
`searchRankLostAbsoluteTopImpressionShare`	`metrics.search_rank_lost_absolute_top_impression_share`
`searchRankLostImpressionShare`	`metrics.search_rank_lost_impression_share`
`searchRankLostTopImpressionShare`	`metrics.search_rank_lost_top_impression_share`
`searchTopImpressionShare`	`metrics.search_top_impression_share`
`sitelinkClickserverUrl`	`asset.tracking_url_template`
`sitelinkDescription1`	`asset.sitelink_asset.description_1`
`sitelinkDescription2`	`asset.sitelink_asset.description_2`
`sitelinkDisplayText`	`asset.sitelink_asset.link_text`
`sitelinkLandingPageUrl`	`asset.final_urls`
`status`	`ad_group.status`
`topImpressionPercentage`	`metrics.top_impression_percentage`
`topOfPageBidAvg`	Behavior change
`visits`	`metrics.visits`
`weekEnd`	Behavior change
`weekStart`	`segments.week`
`yearEnd`	Behavior change
`yearStart`	`segments.year`

AdGroupTarget report

Column names in the `adGroupTarget` report	new Search Ads 360 Reporting API mapping
`account`	`customer.descriptive_name`
`accountEngineId`	`customer.engine_id`
`accountId`	`customer.id`
`accountType`	`customer.account_type`
`adGroup`	`ad_group.name`
`adGroupId`	`ad_group.id`
`adGroupStatus`	`ad_group.status`
`adGroupTargetId`	`ad_group_criterion.criterion_id`
`advertiser`	See account management
`advertiserId`	See account management
`adWordsConversions`	`metrics.client_account_conversions`⁵
`adWordsConversionValue`	`metrics.client_account_conversions_value`⁵
`adWordsViewThroughConversions`	`metrics.client_account_view_through_conversions`⁵
`agency`	See account management
`agencyId`	See account management
`ageTargetAgeRange`	`ad_group_criterion.age_range.type`
`ageTargetBidModifier`	`ad_group_criterion.bid_modifier`
`avgCpc`	`metrics.average_cpc`⁵
`avgCpm`	`metrics.average_cpm`⁵
`avgPos`	Behavior change
`campaign`	`campaign.name`
`campaignId`	`campaign.id`
`campaignStatus`	`campaign.status`
`clicks`	`metrics.clicks`⁵
`cost`	`metrics.cost_micros`⁵
`creationTimestamp`	`ad_group_criterion.creation_time`
`ctr`	`metrics.ctr`⁵
`date`	`segments.date`
`deviceSegment`	`segments.device`
`dfaActions`	`metrics.all_conversions_by_conversion_date` - `metrics.cross_device_conversions_by_conversion_date`⁵
`dfaActionsCrossEnv`	`metrics.all_conversions_by_conversion_date`⁵
`dfaRevenue`	`metrics.all_conversions_value_by_conversion_date` - `metrics.cross_device_conversions_value_by_conversion_date`⁵
`dfaRevenueCrossEnv`	`metrics.all_conversions_value_by_conversion_date`⁵
`dfaTransactions`	`metrics.all_conversions_by_conversion_date` - `metrics.cross_device_conversions_by_conversion_date`⁵
`dfaTransactionsCrossEnv`	`metrics.all_conversions_by_conversion_date`⁵
`dfaWeightedActions`	Behavior change
`dfaWeightedActionsCrossEnv`	Behavior change
`dynamicSearchAdsTargetConditions`	`ad_group_criterion.webpage.conditions`
`dynamicSearchAdsTargetCoverage`	`ad_group_criterion.webpage.coverage_percentage`
`dynamicSearchAdsTargetCpcBid`	`ad_group_criterion.cpc_bid_micros`
`dynamicSearchAdsTargetLandingPageUrl`	`dynamic_search_ads_search_term_view.landing_page`
`engineRemarketingList`	`ad_group_criterion.user_list.user_list user_list.name`
`engineRemarketingListBidModifier`	`ad_group_criterion.bid_modifier`
`floodlightActivity`	`segments.conversion_action_name`
`floodlightActivityId`	Use `conversion_action`
`floodlightActivityTag`	Use `conversion_action`
`floodlightGroup`	Behavior change
`floodlightGroupId`	Behavior change
`floodlightGroupTag`	Use `conversion_action`
`genderTargetBidModifier`	`ad_group_criterion.bid_modifier`
`genderTargetGenderType`	`ad_group_criterion.gender.type`
`impr`	`metrics.impressions`⁵
`lastModifiedTimestamp`	`ad_group_criterion.last_modified_time`
`locationTargetBidModifier`	`ad_group_criterion.bid_modifier`
`locationTargetName`	`ad_group_criterion.location.geo_target_constant`
`monthEnd`	Behavior change
`monthStart`	`segments.month`
`quarterEnd`	Behavior change
`quarterStart`	`segments.quarter`
`status`	`ad_group_criterion.status`
`unclassifiedTargetName`	Behavior change
`unclassifiedTargetType`	Behavior change
`visits`	`Not available in V0`
`weekEnd`	Behavior change
`weekStart`	`segments.week`
`yearEnd`	Behavior change
`yearStart`	`segments.year`

Advertiser report

Column names in the `advertiser` report	new Search Ads 360 Reporting API mapping
`absoluteTopImpressionPercentage`	`metrics.absolute_top_impression_percentage`
`advertiser`	`customer.descriptive_name`
`advertiserCurrencyCode`	`customer.currency_code`
`advertiserId`	`customer.id`
`adWordsConversions`	`metrics.client_account_conversions`
`adWordsConversionValue`	`metrics.client_account_conversions_value`
`adWordsViewThroughConversions`	`metrics.client_account_view_through_conversions`
`agency`	See account management
`agencyId`	See account management
`avgCpc`	`metrics.average_cpc`
`avgCpm`	`metrics.average_cpm`
`avgPos`	Behavior change
`clicks`	`metrics.clicks`
`cost`	`metrics.cost_micros`
`creationTimestamp`	`customer.creation_time`
`ctr`	`metrics.ctr`
`date`	`segments.date`
`deviceSegment`	`segments.device`
`dfaActions`	`metrics.all_conversions_by_conversion_date` - `metrics.cross_device_conversions_by_conversion_date`
`dfaActionsCrossEnv`	`metrics.all_conversions_by_conversion_date`
`dfaAdvertiserId`	`customer.double_click_campaign_manager_setting.advertiser_id`
`dfaNetworkId`	`customer.double_click_campaign_manager_setting.network_id`
`dfaNetworkTimeZone`	`customer.double_click_campaign_manager_setting.time_zone`
`dfaRevenue`	`metrics.all_conversions_value_by_conversion_date` - `metrics.cross_device_conversions_value_by_conversion_date`
`dfaRevenueCrossEnv`	`metrics.all_conversions_value_by_conversion_date`
`dfaTransactions`	`metrics.all_conversions_by_conversion_date` - `metrics.cross_device_conversions_by_conversion_date`
`dfaTransactionsCrossEnv`	`metrics.all_conversions_by_conversion_date`
`dfaWeightedActions`	Behavior change
`dfaWeightedActionsCrossEnv`	Behavior change
`displayBudgetLostImpressionShare`	`metrics.content_budget_lost_impression_share`
`displayImpressionShare`	`metrics.content_impression_share`
`displayRankLostImpressionShare`	`metrics.content_rank_lost_impression_share`
`floodlightActivity`	`segments.conversion_action_name`
`floodlightActivityId`	Use `conversion_action`
`floodlightActivityTag`	Use `conversion_action`
`floodlightGroup`	Behavior change
`floodlightGroupId`	Behavior change
`floodlightGroupTag`	Use `conversion_action`
`googleAnalyticsTimeZone`	`Not available in V0`
`impr`	`metrics.impressions`
`lastModifiedTimestamp`	`customer.last_modified_time`
`monthEnd`	Behavior change
`monthStart`	`segments.month`
`qualityScoreAvg`	`metrics.historical_quality_score`
`quarterEnd`	Behavior change
`quarterStart`	`segments.quarter`
`searchAbsoluteTopImpressionShare`	`metrics.search_absolute_top_impression_share`
`searchBudgetLostAbsoluteTopImpressionShare`	`metrics.search_budget_lost_absolute_top_impression_share`
`searchBudgetLostImpressionShare`	`metrics.search_budget_lost_impression_share`
`searchBudgetLostTopImpressionShare`	`metrics.search_budget_lost_top_impression_share`
`searchImpressionShare`	`metrics.search_impression_share`
`searchRankLostAbsoluteTopImpressionShare`	`metrics.search_rank_lost_absolute_top_impression_share`
`searchRankLostImpressionShare`	`metrics.search_rank_lost_impression_share`
`searchRankLostTopImpressionShare`	`metrics.search_rank_lost_top_impression_share`
`searchTopImpressionShare`	`metrics.search_top_impression_share`
`status`	`customer.status`
`topImpressionPercentage`	`metrics.top_impression_percentage`
`topOfPageBidAvg`	Behavior change
`visits`	`Not available in V0`
`weekEnd`	Behavior change
`weekStart`	`segments.week`
`yearEnd`	Behavior change
`yearStart`	`segments.year`

BidStrategy report

Column names in the `bidStrategy` report	new Search Ads 360 Reporting API mapping
`advertiser`	See account management
`advertiserId`	See account management
`adWordsConversions`	`metrics.client_account_conversions`
`adWordsConversionValue`	`metrics.client_account_conversions_value`
`adWordsViewThroughConversions`	`metrics.client_account_view_through_conversions`
`agency`	See account management
`agencyId`	See account management
`avgCpc`	`metrics.average_cpc`
`avgCpm`	`metrics.average_cpm`
`avgPos`	Behavior change
`bidStrategy`	`bidding_strategy.name`
`bidStrategyGoal`	`bidding_strategy.target_*`
`bidStrategyId`	`bidding_strategy.id`
`bidStrategyMaxBid`	`bidding_strategy.target_{}.cpc_bid_ceiling_micros`
`bidStrategyMinBid`	`bidding_strategy.target_{}.cpc_bid_floor_micros`
`clicks`	`metrics.clicks`
`cost`	`metrics.cost_micros`
`cpaTarget`	`bidding_strategy.target_cpa.target_cpa_micros`
`creationTimestamp`	Behavior change
`ctr`	`metrics.ctr`
`date`	`segments.date`
`dfaActions`	`metrics.all_conversions_by_conversion_date` - `metrics.cross_device_conversions_by_conversion_date`
`dfaActionsCrossEnv`	`metrics.all_conversions_by_conversion_date`
`dfaRevenue`	`metrics.all_conversions_value_by_conversion_date` - `metrics.cross_device_conversions_value_by_conversion_date`
`dfaRevenueCrossEnv`	`metrics.all_conversions_value_by_conversion_date`
`dfaTransactions`	`metrics.all_conversions_by_conversion_date` - `metrics.cross_device_conversions_by_conversion_date`
`dfaTransactionsCrossEnv`	`metrics.all_conversions_by_conversion_date`
`dfaWeightedActions`	Behavior change
`dfaWeightedActionsCrossEnv`	Behavior change
`ersTarget`	`bidding_strategy.target_roas.target_roas`
`floodlightActivityTargetIds`	use `segments.conversion_action` to get list of floodlight info
`floodlightOptimizationEnabled`	use `segments.conversion_action` to check if it is optimizing for floodlight conversions
`highPosition`	Behavior change
`impr`	`metrics.impressions`
`lastModifiedTimestamp`	Behavior change
`lowPosition`	Behavior change
`monthEnd`	Behavior change
`monthlySpendTarget`	`bidding_strategy.target_spend.target_spend_micros`
`monthStart`	`segments.month`
`quarterEnd`	Behavior change
`quarterStart`	`segments.quarter`
`roasTarget`	`bidding_strategy.target_roas.target_roas`
`status`	`bidding_strategy.status`
`type`	`bidding_strategy.type`
`visits`	`Not available in V0`
`weekEnd`	Behavior change
`weekStart`	`segments.week`
`yearEnd`	Behavior change
`yearStart`	`segments.year`

Campaign report

Column names in the `campaign` report	new Search Ads 360 Reporting API mapping
`absoluteTopImpressionPercentage`	`metrics.absolute_top_impression_percentage`
`account`	`customer.descriptive_name`
`accountEngineId`	`customer.engine_id`
`accountId`	`customer.id`
`accountType`	`customer.account_type`
`advertiser`	See account management
`advertiserId`	See account management
`adWordsBidStrategy`	`campaign.bidding_strategy_type`
`adWordsConversions`	`metrics.client_account_conversions`
`adWordsConversionValue`	`metrics.client_account_conversions_value`
`adWordsViewThroughConversions`	`metrics.client_account_view_through_conversions`
`agency`	See account management
`agencyId`	See account management
`appId`	`asset.mobile_app_asset.app_id`
`appStore`	`asset.mobile_app_asset.app_store`
`avgCpc`	`metrics.average_cpc`
`avgCpm`	`metrics.average_cpm`
`avgPos`	Behavior change
`bidStrategyInherited`	Behavior change
`bingAdsBudgetType`	`campaign_budget.period campaign_budget.delivery_method`
`callCallOnly`	Behavior change
`callConversionTracker`	`asset.call_asset.call_conversion_action`
`callConversionTrackerId`	Behavior change
`callCountryCode`	`asset.call_asset.country_code`
`callIsTracked`	`asset.call_asset.call_tracking_enabled`
`callPhoneNumber`	`asset.call_asset.phone_number`
`campaign`	`campaign.name`
`campaignDesktopBidAdjustment`	`campaign_criterion.bid_modifier campaign_criterion.device.type`
`campaignEndDate`	`campaign.end_date`
`campaignEngineId`	`campaign.engine_id`
`campaignId`	`campaign.id`
`campaignLabels`	`label.name using campaign_label resource`
`campaignMobileBidAdjustment`	`campaign_criterion.bid_modifier campaign_criterion.device.type`
`campaignStartDate`	`campaign.start_date`
`campaignStatus`	`campaign.status`
`campaignTabletBidAdjustment`	`campaign_criterion.bid_modifier campaign_criterion.device.type`
`campaignType`	`campaign.advertising_channel_type campaign.advertising_channel_sub_type`
`cityTargets`	`campaign_criterion.location.geo_target_constant`
`clicks`	`metrics.clicks`
`clicksWithFeedItemShowing`	Behavior change
`cost`	`metrics.cost_micros`
`costWithFeedItemShowing`	Behavior change
`countryTargets`	`campaign_criterion.location.geo_target_constant`
`creationTimestamp`	`campaign.creation_time`
`ctr`	`metrics.ctr`
`dailyBudget`	`campaign_budget.period campaign_budget.amount_micros`
`date`	`segments.date`
`deliveryMethod`	`campaign_budget.delivery_method`
`deviceSegment`	`segments.device`
`deviceTargets`	`campaign_criterion.device.type`
`dfaActions`	`metrics.all_conversions_by_conversion_date` - `metrics.cross_device_conversions_by_conversion_date`
`dfaActionsCrossEnv`	`metrics.all_conversions_by_conversion_date`
`dfaRevenue`	`metrics.all_conversions_value_by_conversion_date` - `metrics.cross_device_conversions_value_by_conversion_date`
`dfaRevenueCrossEnv`	`metrics.all_conversions_value_by_conversion_date`
`dfaTransactions`	`metrics.all_conversions_by_conversion_date` - `metrics.cross_device_conversions_by_conversion_date`
`dfaTransactionsCrossEnv`	`metrics.all_conversions_by_conversion_date`
`dfaWeightedActions`	Behavior change
`dfaWeightedActionsCrossEnv`	Behavior change
`displayBudgetLostImpressionShare`	`metrics.content_budget_lost_impression_share`
`displayImpressionShare`	`metrics.content_impression_share`
`displayRankLostImpressionShare`	`metrics.content_rank_lost_impression_share`
`effectiveBidStrategy`	`bidding_strategy.name`
`effectiveBidStrategyId`	`bidding_strategy.id`
`effectiveCityTargets`	`campaign_criterion.location.geo_target_constant`
`effectiveCountryTargets`	`campaign_criterion.location.geo_target_constant`
`effectiveDeviceTargets`	`campaign_criterion.device.type`
`effectiveLabels`	`Not available in V0`
`effectiveMetroTargets`	`campaign_criterion.location.geo_target_constant`
`effectiveProvinceTargets`	`campaign_criterion.location.geo_target_constant`
`engineStatus`	`Not available now. It will map to campaign.engine_status`
`excludedCityTargets`	`campaign_criterion.location.geo_target_constant (filtering with campaign_criterion.negative)`⁸
`excludedCountryTargets`	`campaign_criterion.location.geo_target_constant (filtering with campaign_criterion.negative)`⁸
`excludedMetroTargets`	`campaign_criterion.location.geo_target_constant (filtering with campaign_criterion.negative)`⁸
`excludedProvinceTargets`	`campaign_criterion.location.geo_target_constant (filtering with campaign_criterion.negative)`⁸
`feedId`	`asset_set.id`
`feedItemId`	`asset.id`
`feedType`	`asset.type`
`floodlightActivity`	`segments.conversion_action_name`
`floodlightActivityId`	Use `conversion_action`
`floodlightActivityTag`	Use `conversion_action`
`floodlightGroup`	Behavior change
`floodlightGroupId`	Behavior change
`floodlightGroupTag`	Use `conversion_action`
`impr`	`metrics.impressions`
`keywordNearMatchEnabled`	Behavior change
`lastModifiedTimestamp`	`campaign.last_modified_time`
`languageTargets`	`campaign_criterion.language.language_constant`
`locationBusinessName`	`Not available in V0`
`locationCategory`	Behavior change
`locationDetails`	`Not available in V0`
`locationFilter`	Behavior change
`metroTargets`	`campaign_criterion.location.geo_target_constant`
`monthEnd`	Behavior change
`monthlyBudget`	`campaign_budget.period campaign_budget.amount_micros`
`monthStart`	`segments.month`
`networkTarget`	`campaign.network_settings.target_{network_type}`
`provinceTargets`	`campaign_criterion.location.geo_target_constant`
`qualityScoreAvg`	`metrics.historical_quality_score`
`quarterEnd`	Behavior change
`quarterStart`	`segments.quarter`
`searchAbsoluteTopImpressionShare`	`metrics.search_absolute_top_impression_share`
`searchBudgetLostAbsoluteTopImpressionShare`	`metrics.search_budget_lost_absolute_top_impression_share`
`searchBudgetLostImpressionShare`	`metrics.search_budget_lost_impression_share`
`searchBudgetLostTopImpressionShare`	`metrics.search_budget_lost_top_impression_share`
`searchImpressionShare`	`metrics.search_impression_share`
`searchRankLostAbsoluteTopImpressionShare`	`metrics.search_rank_lost_absolute_top_impression_share`
`searchRankLostImpressionShare`	`metrics.search_rank_lost_impression_share`
`searchRankLostTopImpressionShare`	`metrics.search_rank_lost_top_impression_share`
`searchTopImpressionShare`	`metrics.search_top_impression_share`
`sitelinkClickserverUrl`	`asset.tracking_url_template`
`sitelinkDescription1`	`asset.sitelink_asset.description_1`
`sitelinkDescription2`	`asset.sitelink_asset.description_2`
`sitelinkDisplayText`	`asset.sitelink_asset.link_text`
`sitelinkLandingPageUrl`	`asset.final_urls`
`status`	`campaign.status`
`topImpressionPercentage`	`metrics.top_impression_percentage`
`topOfPageBidAvg`	Behavior change
`visits`	`metrics.visits`
`weekEnd`	Behavior change
`weekStart`	`segments.week`
`yahooGeoTargets`	`campaign_criterion.location.geo_target_constant`
`yahooJapanBidStrategy`	`bidding_strategy.name`
`yearEnd`	Behavior change
`yearStart`	`segments.year`

CampaignTarget report

Column names in the `campaignTarget` report	new Search Ads 360 Reporting API mapping
`account`	`customer.descriptive_name`
`accountEngineId`	`customer.engine_id`
`accountId`	`customer.id`
`accountType`	`customer.account_type`
`advertiser`	See account management
`advertiserId`	See account management
`adWordsConversions`	`metrics.client_account_conversions`
`adWordsConversionValue`	`metrics.client_account_conversions_value`
`adWordsViewThroughConversions`	`metrics.client_account_view_through_conversions`
`agency`	See account management
`agencyId`	See account management
`avgCpc`	`metrics.average_cpc`
`avgCpm`	`metrics.average_cpm`
`avgPos`	Behavior change
`campaign`	`campaign.name`
`campaignId`	`campaign.id`
`campaignStatus`	`campaign.status`
`campaignTargetId`	`campaign_criterion.criterion_id`
`clicks`	`metrics.clicks`
`cost`	`metrics.cost_micros`
`creationTimestamp`	Behavior change
`ctr`	`metrics.ctr`
`date`	`segments.date`
`deviceSegment`	`segments.device`
`dfaActions`	`metrics.all_conversions` - `metrics.cross_device_conversions`
`dfaActionsCrossEnv`	`metrics.all_conversions`
`dfaRevenue`	`metrics.all_conversions_value` - `metrics.cross_device_conversions_value`
`dfaRevenueCrossEnv`	`metrics.all_conversions_value`
`dfaTransactions`	`metrics.all_conversions` - `metrics.cross_device_conversions`
`dfaTransactionsCrossEnv`	`metrics.all_conversions`
`dfaWeightedActions`	Behavior change
`dfaWeightedActionsCrossEnv`	Behavior change
`engineRemarketingList`	`campaign_criterion.user_list.user_list user_list.name`
`engineRemarketingListBidModifier`	`campaign_criterion.bid_modifier`
`floodlightActivity`	`segments.conversion_action_name`
`floodlightActivityId`	Use `conversion_action`
`floodlightActivityTag`	Use `conversion_action`
`floodlightGroup`	Behavior change
`floodlightGroupId`	Behavior change
`floodlightGroupTag`	Use `conversion_action`
`impr`	`metrics.impressions`
`lastModifiedTimestamp`	`campaign_criterion.last_modified_time`
`locationTargetBidModifier`	`campaign_criterion.bid_modifier`
`locationTargetName`	`campaign_criterion.location.geo_target_constant`
`monthEnd`	Behavior change
`monthStart`	`segments.month`
`quarterEnd`	Behavior change
`quarterStart`	`segments.quarter`
`status`	`campaign_criterion.status`
`visits`	`Not available in V0`
`weekEnd`	Behavior change
`weekStart`	`segments.week`
`yearEnd`	Behavior change
`yearStart`	`segments.year`

Conversion report

Column names in the `conversion` report	new Search Ads 360 Reporting API mapping
`account`	`customer.descriptive_name`
`accountEngineId`	`customer.engine_id`
`accountId`	`customer.id`
`accountType`	`customer.descriptive_name`
`ad`	`ad_group_ad.ad.name`⁹
`adGroup`	`ad_group.name`
`adGroupId`	`ad_group.id`
`adGroupStatus`	`ad_group.status`
`adId`	`conversion.ad_id`
`advertiser`	See account management
`advertiserConversionId`	`conversion.advertiser_conversion_id`
`advertiserId`	See account management
`agency`	See account management
`agencyId`	See account management
`campaign`	`campaign.name`
`campaignId`	`campaign.id`
`campaignStatus`	`campaign.status`
`conversionAttributionType`	`conversion.attribution_type`
`conversionDate`	`conversion.conversion_date_time`
`conversionId`	`conversion.id`
`conversionLastModifiedTimestamp`	`conversion.conversion_last_modified_date_time`
`conversionQuantity`	`conversion.conversion_quantity`
`conversionRevenue`	`conversion.conversion_revenue_micros`
`conversionSearchTerm`	Behavior change
`conversionTimestamp`	`conversion.conversion_date_time`
`conversionType`	Behavior change
`conversionVisitExternalClickId`	`conversion.click_id`
`conversionVisitId`	`conversion.visit_id`
`conversionVisitTimestamp`	`conversion.conversion_visit_date_time`
`deviceSegment`	`segments.device`
`feedId`	Behavior change
`feedItemId`	Behavior change
`feedType`	Behavior change
`floodlightActivity`	Use `conversion_action`
`floodlightActivityId`	Use `conversion_action`
`floodlightActivityTag`	Use `conversion_action`
`floodlightEventRequestString`	Behavior change
`floodlightGroup`	Use `conversion_action`
`floodlightGroupConversionType`	Use `conversion_action`
`floodlightGroupId`	Behavior change
`floodlightGroupTag`	Use `conversion_action`
`floodlightOrderId`	`conversion.floodlight_order_id`
`floodlightOriginalRevenue`	`conversion.floodlight_original_revenue`
`floodlightReferrer`	Behavior change
`inventoryAccountId`	`conversion.merchant_id`
`isUnattributedAd`	Behavior change
`keywordId`	`conversion.criterion_id`
`keywordMatchType`	`ad_group_criterion.keyword.match_type`
`keywordText`	`ad_group_criterion.keyword.text`
`productChannel`	`conversion.product_channel`
`productCountry`	`conversion.product_country_code`
`productGroupId`	`ad_group_criterion.criterion_id`
`productId`	`conversion.product_id`
`productLanguage`	`conversion.product_language_code`
`productStoreId`	`conversion.product_store_id`
`productTargetId`	Behavior change
`status`	`conversion.status`

FeedItem report

Column names in the `feedItem` report	new Search Ads 360 Reporting API mapping
`account`	`customer.descriptive_name`
`accountEngineId`	`customer.engine_id`
`accountId`	`customer.id`
`accountType`	`customer.account_type`
`advertiser`	See account management
`advertiserId`	See account management
`adWordsConversions`	`metrics.client_account_conversions`⁶
`adWordsConversionValue`	`metrics.client_account_conversions_value`⁶
`adWordsViewThroughConversions`	`metrics.client_account_view_through_conversions`⁶
`agency`	See account management
`agencyId`	See account management
`appId`	`asset.mobile_app_asset.app_id`
`appStore`	`asset.mobile_app_asset.app_store`
`avgCpc`	`metrics.average_cpc`⁶
`avgCpm`	`metrics.average_cpm`⁶
`avgPos`	Behavior change
`callCallOnly`	Behavior change
`callConversionTracker`	`asset.call_asset.call_conversion_action`
`callConversionTrackerId`	Behavior change
`callCountryCode`	`asset.call_asset.country_code`
`callIsTracked`	`asset.call_asset.call_tracking_enabled`
`callPhoneNumber`	`asset.call_asset.phone_number`
`clicks`	`metrics.clicks`⁶
`clicksWithFeedItemShowing`	Behavior change
`cost`	`metrics.cost_micros`⁶
`costWithFeedItemShowing`	Behavior change
`creationTimestamp`	`asset.creation_time`
`ctr`	`metrics.ctr`⁶
`date`	`segments.date`
`dfaActions`	`metrics.all_conversions` - `metrics.cross_device_conversions`⁶
`dfaActionsCrossEnv`	`metrics.all_conversions`⁶
`dfaRevenue`	`metrics.all_conversions_value` - `metrics.cross_device_conversions_value`⁶
`dfaRevenueCrossEnv`	`metrics.all_conversions_value`⁶
`dfaTransactions`	`metrics.all_conversions` - `metrics.cross_device_conversions`⁶
`dfaTransactionsCrossEnv`	`metrics.all_conversions`⁶
`dfaWeightedActions`	Behavior change
`dfaWeightedActionsCrossEnv`	Behavior change
`engineStatus`	`asset.engine_status`
`feedId`	`asset_set.id`
`feedItemId`	`asset.id`
`floodlightActivity`	`segments.conversion_action_name`
`floodlightActivityId`	Use `conversion_action`
`floodlightActivityTag`	Use `conversion_action`
`floodlightGroup`	Behavior change
`floodlightGroupId`	Behavior change
`floodlightGroupTag`	Use `conversion_action`
`impr`	`metrics.impressions`⁶
`lastModifiedTimestamp`	`asset.last_modified_time`
`locationBusinessName`	`Not available in V0`
`locationCategory`	Behavior change
`locationDetails`	`Not available in V0`
`monthEnd`	Behavior change
`monthStart`	`segments.month`
`quarterEnd`	Behavior change
`quarterStart`	`segments.quarter`
`sitelinkClickserverUrl`	`asset.tracking_url_template`
`sitelinkDescription1`	`asset.sitelink_asset.description_1`
`sitelinkDescription2`	`asset.sitelink_asset.description_2`
`sitelinkDisplayText`	`asset.sitelink_asset.link_text`
`sitelinkLandingPageUrl`	`asset.final_urls`
`status`	`asset.status`
`visits`
`weekEnd`	Behavior change
`weekStart`	`segments.week`
`yearEnd`	Behavior change
`yearStart`	`segments.year`

FloodlightActivity report

Column names in the `floodlightActivity` report	new Search Ads 360 Reporting API mapping
`advertiser`	See account management
`advertiserId`	See account management
`agency`	See account management
`agencyId`	See account management
`creationTimestamp`	`conversion_action.creation_time`
`floodlightActivity`	`conversion_action.name`
`floodlightActivityId`	`conversion_action.floodlight_settings.activity_id`
`floodlightActivityTag`	`conversion_action.floodlight_settings.activity_tag`
`floodlightConfigurationId`	Behavior change
`floodlightGroup`	Behavior change
`floodlightGroupConversionType`	`conversion_action.type`
`floodlightGroupId`	Behavior change
`floodlightGroupTag`	`conversion_action.floodlight_settings.activity_group_tag`
`lastModifiedTimestamp`	Behavior change
`status`	`conversion_action.status`

Keyword report

Column names in the `keyword` report	new Search Ads 360 Reporting API mapping
`account`	`customer.descriptive_name`
`accountEngineId`	`customer.engine_id`
`accountId`	`customer.id`
`accountType`	`customer.account_type`
`ad`	`ad_group_ad.ad.name`⁹
`adDescription1`	`ad_group_ad.ad.{ad type}.description1`¹^,⁹
`adDescription2`	`ad_group_ad.ad.{ad type}.description2`¹^,⁹
`adDisplayUrl`	`ad_group_ad.ad.display_url`⁹
`adGroup`	`ad_group.name`
`adGroupId`	`ad_group.id`
`adGroupStatus`	`ad_group.status`
`adHeadline`	`ad_group_ad.ad.{ad type}.headline`³^,⁹
`adHeadline2`	`ad_group_ad.ad.expanded_text_ad.headline2`⁹
`adHeadline3`	`ad_group_ad.ad.expanded_text_ad.headline3`⁹
`adId`	`ad_group_ad.ad.id`⁹
`adLandingPage`	`ad_group_ad.ad.final_urls`⁹
`adPromotionLine`	Behavior change
`adType`	`ad_group_ad.ad.type`⁹
`advertiser`	See account management
`advertiserId`	See account management
`adWordsConversions`	`metrics.client_account_conversions`⁷
`adWordsConversionValue`	`metrics.client_account_conversions_value`⁷
`adWordsViewThroughConversions`	`metrics.client_account_view_through_conversions`⁷
`agency`	See account management
`agencyId`	See account management
`avgCpc`	`metrics.average_cpc`⁷
`avgCpm`	`metrics.average_cpm`⁷
`avgPos`	Behavior change
`bidStrategyInherited`	Behavior change
`bingKeywordParam2`	Behavior change
`bingKeywordParam3`	Behavior change
`campaign`	`campaign.name`
`campaignId`	`campaign.id`
`campaignStatus`	`campaign.status`
`clicks`	`metrics.clicks`⁷
`cost`	`metrics.cost_micros`⁷
`creationTimestamp`	`ad_group_criterion.creation_time`
`ctr`	`metrics.ctr`⁷
`date`	`segments.date`
`deviceSegment`	`segments.device`
`dfaActions`	`metrics.all_conversions_by_conversion_date` - `metrics.cross_device_conversions_by_conversion_date`⁷
`dfaActionsCrossEnv`	`metrics.all_conversions_by_conversion_date`⁷
`dfaRevenue`	`metrics.all_conversions_value_by_conversion_date` - `metrics.cross_device_conversions_value_by_conversion_date`⁷
`dfaRevenueCrossEnv`	`metrics.all_conversions_value_by_conversion_date`⁷
`dfaTransactions`	`metrics.all_conversions_by_conversion_date` - `metrics.cross_device_conversions_by_conversion_date`⁷
`dfaTransactionsCrossEnv`	`metrics.all_conversions_by_conversion_date`⁷
`dfaWeightedActions`	Behavior change
`dfaWeightedActionsCrossEnv`	Behavior change
`effectiveBidStrategy`	`bidding_strategy.name`
`effectiveBidStrategyId`	`bidding_strategy.id`
`effectiveKeywordMaxCpc`	`ad_group_criterion.effective_cpc_bid_micros`
`effectiveLabels`	`Not available in V0`
`engineStatus`	`ad_group_criterion.engine_status`
`floodlightActivity`	`segments.conversion_action_name`
`floodlightActivityId`	Use `conversion_action`
`floodlightActivityTag`	Use `conversion_action`
`floodlightGroup`	Behavior change
`floodlightGroupId`	Behavior change
`floodlightGroupTag`	Use `conversion_action`
`impr`	`metrics.impressions`⁷
`isDisplayKeyword`	Behavior change
`isUnattributedAd`	`Not available in V0`
`keywordClickserverUrl`	`ad_group_criterion.tracking_url_template`
`keywordEngineId`	`ad_group_criterion.engine_id`
`keywordId`	`ad_group_criterion.criterion_id`
`keywordLabels`	`ad_group_criterion_label.label label.name`
`keywordLandingPage`	`ad_group_criterion.final_urls`
`keywordMatchType`	`ad_group_criterion.keyword.match_type`
`keywordMaxBid`	`bidding_strategy.target_{}.cpc_bid_ceiling_micros`
`keywordMaxCpc`	`ad_group_criterion.cpc_bid_micros`
`keywordMinBid`	`bidding_strategy.target_{}.cpc_bid_floor_micros`
`keywordText`	`ad_group_criterion.keyword.text`
`keywordUrlParams`	`ad_group_criterion.final_url_suffix`
`lastModifiedTimestamp`	`ad_group_criterion.last_modified_time`
`monthEnd`	Behavior change
`monthStart`	`segments.month`
`qualityScoreAvg`	`metrics.historical_quality_score`⁷
`qualityScoreCurrent`	`ad_group_criterion.quality_info.quality_score`
`quarterEnd`	Behavior change
`quarterStart`	`segments.quarter`
`status`	`ad_group_criterion.status`
`topOfPageBidAvg`	Behavior change
`topOfPageBidCurrent`	`ad_group_criterion.position_estimates.top_of_page_cpc_micros`
`visits`	`metrics.visits`⁷
`weekEnd`	Behavior change
`weekStart`	`segments.week`
`yearEnd`	Behavior change
`yearStart`	`segments.year`

NegativeAdGroupKeyword report

Column names in the `negativeAdGroupKeyword` report	new Search Ads 360 Reporting API mapping
`account`	`customer.descriptive_name`
`accountEngineId`	`customer.engine_id`
`accountId`	`customer.id`
`accountType`	`customer.account_type`
`adGroup`	`ad_group.name`
`adGroupId`	`ad_group.id`
`adGroupStatus`	`ad_group.status`
`advertiser`	See account management
`advertiserId`	See account management
`agency`	See account management
`agencyId`	See account management
`campaign`	`campaign.name`
`campaignId`	`campaign.id`
`campaignStatus`	`campaign.status`
`creationTimestamp`	`ad_group_criterion.creation_time`
`engineStatus`	Behavior change
`lastModifiedTimestamp`	`ad_group_criterion.last_modified_time`
`negativeAdGroupKeywordId`	`ad_group_criterion.criterion_id (filtering with ad_group_criterion.negative)`⁸
`negativeAdGroupKeywordMatchType`	`ad_group_criterion.keyword.match_type (filtering with ad_group_criterion.negative)`⁸
`negativeAdGroupKeywordText`	`ad_group_criterion.keyword.text (filtering with ad_group_criterion.negative)`⁸
`status`	`ad_group_criterion.status (filtering with ad_group_criterion.negative)`⁸

NegativeAdGroupTarget report

Column names in the `negativeAdGroupTarget` report	new Search Ads 360 Reporting API mapping
`account`	`customer.descriptive_name`
`accountEngineId`	`customer.engine_id`
`accountId`	`customer.id`
`accountType`	`customer.account_type`
`adGroup`	`ad_group.name`
`adGroupId`	`ad_group.id`
`adGroupStatus`	`ad_group.status`
`advertiser`	See account management
`advertiserId`	See account management
`agency`	See account management
`agencyId`	See account management
`ageTargetAgeRange`	`ad_group_criterion.age_range.type (filtering with ad_group_criterion.negative)`⁸
`campaign`	`campaign.name`
`campaignId`	`campaign.id`
`campaignStatus`	`campaign.status`
`creationTimestamp`	`ad_group_criterion.creation_time`
`dynamicSearchAdsTargetConditions`	`ad_group_criterion.webpage.conditions (filtering with ad_group_criterion.negative)`⁸
`engineRemarketingList`	`ad_group_criterion.user_list.user_list user_list.name (filtering with ad_group_criterion.negative)`⁸
`genderTargetGenderType`	`ad_group_criterion.gender.type (filtering with ad_group_criterion.negative)`⁸
`lastModifiedTimestamp`	`ad_group_criterion.last_modified_time`
`locationTargetName`	`ad_group_criterion.location.geo_target_constant (filtering with ad_group_criterion.negative)`⁸
`negativeAdGroupTargetId`	`ad_group_criterion.criterion_id (filtering with ad_group_criterion.negative)`⁸
`status`	`ad_group_criterion.status (filtering with ad_group_criterion.negative)`⁸

NegativeCampaignKeyword report

Column names in the `negativeCampaignKeyword` report	new Search Ads 360 Reporting API mapping
`account`	`customer.descriptive_name`
`accountEngineId`	`customer.engine_id`
`accountId`	`customer.id`
`accountType`	`customer.account_type`
`advertiser`	See account management
`advertiserId`	See account management
`agency`	See account management
`agencyId`	See account management
`campaign`	`campaign.name`
`campaignId`	`campaign.id`
`campaignStatus`	`campaign.status`
`creationTimestamp`	Behavior change
`engineStatus`	Behavior change
`lastModifiedTimestamp`	`campaign_criterion.last_modified_time`
`negativeCampaignKeywordId`	`campaign_criterion.criterion_id (filtering with campaign_criterion.negative)`⁸
`negativeCampaignKeywordMatchType`	`campaign_criterion.keyword.match_type (filtering with campaign_criterion.negative)`⁸
`negativeCampaignKeywordText`	`campaign_criterion.keyword.text (filtering with campaign_criterion.negative)`⁸
`status`	`campaign_criterion.status (filtering with campaign_criterion.negative)`⁸

NegativeCampaignTarget report

Column names in the `negativeCampaignTarget` report	new Search Ads 360 Reporting API mapping
`account`	`customer.descriptive_name`
`accountEngineId`	`customer.engine_id`
`accountId`	`customer.id`
`accountType`	`customer.account_type`
`advertiser`	See account management
`advertiserId`	See account management
`agency`	See account management
`agencyId`	See account management
`ageTargetAgeRange`	`campaign_criterion.age_range.type (filtering with campaign_criterion.negative)`⁸
`campaign`	`campaign.name`
`campaignId`	`campaign.id`
`campaignStatus`	`campaign.status`
`creationTimestamp`	Behavior change
`dynamicSearchAdsTargetConditions`	`campaign_criterion.webpage.conditions (filtering with campaign_criterion.negative)`⁸
`engineRemarketingList`	`campaign_criterion.user_list.user_list user_list.name (filtering with campaign_criterion.negative)`⁸
`genderTargetGenderType`	`campaign_criterion.gender.type (filtering with campaign_criterion.negative)`⁸
`lastModifiedTimestamp`	`campaign_criterion.last_modified_time`
`locationTargetName`	`campaign_criterion.location.geo_target_constant campaign_criterion.negative`⁸
`negativeCampaignTargetId`	`campaign_criterion.criterion_id (filtering with campaign_criterion.negative)`⁸
`status`	`campaign_criterion.status (filtering with campaign_criterion.negative)`⁸

PaidAndOrganic report

Column names in the `paidAndOrganic` report	new Search Ads 360 Reporting API mapping
`account`	`customer.descriptive_name`
`accountEngineId`	`customer.engine_id`
`accountId`	`customer.id`
`accountType`	`customer.account_type`
`adGroup`
`adGroupId`
`advertiser`	See account management
`advertiserId`	See account management
`agency`	See account management
`agencyId`	See account management
`campaign`
`campaignId`
`date`	`segments.date`
`keywordId`	`segments.keyword.ad_group_criterion`
`keywordMatchType`	`segments.keyword.info.match_type`
`keywordText`	`segments.keyword.info.text`
`monthEnd`	Behavior change
`monthStart`	`segments.month`
`organicAvgPos`	Behavior change
`organicClicks`	`metrics.organic_clicks`
`organicCtr`
`organicQueries`	`metrics.organic_queries`
`paidAndOrganicClicks`	`metrics.combined_clicks`
`paidAndOrganicCtr`	`metrics.ctr`
`paidAndOrganicQueries`	`metrics.combined_queries`
`paidAvgPos`	Behavior change
`paidClicks`
`paidCostPerClick`	`metrics.average_cpc`
`paidCtr`
`paidImpressions`
`quarterEnd`	Behavior change
`quarterStart`	`segments.quarter`
`searchQuery`	`paid_organic_search_term_view.search_term`
`serpType`	`segments.search_engine_results_page_type`
`weekEnd`	Behavior change
`weekStart`	`segments.week`
`yearEnd`	Behavior change
`yearStart`	`segments.year`

ProductAdvertised report

Column names in the `productAdvertised` report	new Search Ads 360 Reporting API mapping
`accountId`	`customer.id`
`adGroupId`	`ad_group.id`
`advertiser`	See account management
`advertiserId`	See account management
`adWordsConversions`	`metrics.client_account_conversions`
`adWordsConversionValue`	`metrics.client_account_conversions_value`
`adWordsViewThroughConversions`	Behavior change
`agency`	See account management
`agencyId`	See account management
`avgCpc`	`metrics.average_cpc`
`avgCpm`	Behavior change
`avgPos`	Behavior change
`campaignId`	`campaign.id`
`clicks`	`metrics.clicks`
`cost`	`metrics.cost_micros`
`creationTimestamp`	Behavior change
`ctr`	`metrics.ctr`
`date`	`segments.date`
`deviceSegment`	`segments.device`
`dfaActions`	`metrics.all_conversions_by_conversion_date` - `metrics.cross_device_conversions_by_conversion_date`
`dfaActionsCrossEnv`	`metrics.all_conversions_by_conversion_date`
`dfaRevenue`	`metrics.all_conversions_value_by_conversion_date` - `metrics.cross_device_conversions_value_by_conversion_date`
`dfaRevenueCrossEnv`	`metrics.all_conversions_value_by_conversion_date`
`dfaTransactions`	`metrics.all_conversions_by_conversion_date` - `metrics.cross_device_conversions_by_conversion_date`
`dfaTransactionsCrossEnv`	`metrics.all_conversions_by_conversion_date`
`dfaWeightedActions`	Behavior change
`dfaWeightedActionsCrossEnv`	Behavior change
`floodlightActivity`	`segments.conversion_action_name`
`floodlightActivityId`	Use `conversion_action`
`floodlightActivityTag`	Use `conversion_action`
`floodlightGroup`	Behavior change
`floodlightGroupId`	Behavior change
`floodlightGroupTag`	Use `conversion_action`
`impr`	`metrics.impressions`
`lastModifiedTimestamp`	Behavior change
`monthEnd`	Behavior change
`monthStart`	`segments.month`
`productAgeGroup`	Behavior change
`productAvailability`	Behavior change
`productBrand`	`segments.product_brand`
`productCategory`	Behavior change
`productCategoryLevel1`	`segments.product_bidding_category_level1`
`productCategoryLevel2`	`segments.product_bidding_category_level2`
`productCategoryLevel3`	`segments.product_bidding_category_level3`
`productCategoryLevel4`	`segments.product_bidding_category_level4`
`productCategoryLevel5`	`segments.product_bidding_category_level5`
`productChannel`	`segments.product_channel`
`productChannelExclusivity`	`segments.product_channel_exclusivity`
`productColor`	Behavior change
`productCondition`	`segments.product_condition`
`productCostOfGoodsSold`	Behavior change
`productCountry`	`segments.product_country`
`productCustomLabel0`	`segments.product_custom_attribute0`
`productCustomLabel1`	`segments.product_custom_attribute1`
`productCustomLabel2`	`segments.product_custom_attribute2`
`productCustomLabel3`	`segments.product_custom_attribute3`
`productCustomLabel4`	`segments.product_custom_attribute4`
`productGender`	Behavior change
`productGtin`	Behavior change
`productId`	`segments.product_item_id`
`productItemGroupId`	Behavior change
`productLandingPageUrl`	Behavior change
`productLanguage`	`segments.product_language`
`productMaterial`	Behavior change
`productMpn`	Behavior change
`productPattern`	Behavior change
`productPrice`	Behavior change
`productSalePrice`	Behavior change
`productSize`	Behavior change
`productStoreId`	`segments.product_store_id`
`productTitle`	`segments.product_title`
`productTypeLevel1`	`segments.product_type_l1`
`productTypeLevel2`	`segments.product_type_l2`
`productTypeLevel3`	`segments.product_type_l3`
`productTypeLevel4`	`segments.product_type_l4`
`productTypeLevel5`	`segments.product_type_l5`
`quarterEnd`	Behavior change
`quarterStart`	`segments.quarter`
`status`	Behavior change
`visits`	`Not available in V0`
`weekEnd`	Behavior change
`weekStart`	`segments.week`
`yearEnd`	Behavior change
`yearStart`	`segments.year`

ProductGroup report

Column names in the `productGroup` report	new Search Ads 360 Reporting API mapping
`account`	`customer.descriptive_name`
`accountEngineId`	`customer.engine_id`
`accountId`	`customer.id`
`accountType`	`customer.account_type`
`adGroup`	`ad_group.name`
`adGroupId`	`ad_group.id`
`adGroupStatus`	`ad_group.status`
`advertiser`	See account management
`advertiserId`	See account management
`adWordsConversions`	`metrics.client_account_conversions`
`adWordsConversionValue`	`metrics.client_account_conversions_value`
`adWordsViewThroughConversions`	`metrics.client_account_view_through_conversions`
`agency`	See account management
`agencyId`	See account management
`avgCpc`	`metrics.average_cpc`
`avgCpm`	`metrics.average_cpm`
`avgPos`	Behavior change
`bidStrategyInherited`	Behavior change
`campaign`	`campaign.name`
`campaignId`	`campaign.id`
`campaignStatus`	`campaign.status`
`clicks`	`metrics.clicks`
`cost`	`metrics.cost_micros`
`creationTimestamp`	`ad_group_criterion.creation_time`
`ctr`	`metrics.ctr`
`date`	`segments.date`
`deviceSegment`	`segments.device`
`dfaActions`	`metrics.all_conversions` - `metrics.cross_device_conversions`
`dfaActionsCrossEnv`	`metrics.all_conversions`
`dfaRevenue`	`metrics.all_conversions_value` - `metrics.cross_device_conversions_value`
`dfaRevenueCrossEnv`	`metrics.all_conversions_value`
`dfaTransactions`	`metrics.all_conversions` - `metrics.cross_device_conversions`
`dfaTransactionsCrossEnv`	`metrics.all_conversions`
`dfaWeightedActions`	Behavior change
`dfaWeightedActionsCrossEnv`	Behavior change
`effectiveBidStrategy`	Behavior change
`effectiveBidStrategyId`	Behavior change
`effectiveLabels`	Behavior change
`effectiveProductGroupMaxCpc`	`ad_group_criterion.effective_cpc_bid_micros`
`engineStatus`	`ad_group_criterion.engine_status`
`impr`	`metrics.impressions`
`lastModifiedTimestamp`	`ad_group_criterion.last_modified_time`
`monthEnd`	Behavior change
`monthStart`	`segments.month`
`productGroup`	`product_group_view.resource_name`
`productGroupClickserverUrl`	`ad_group_criterion.tracking_url_template`
`productGroupId`	`ad_group_criterion.criterion_id`
`productGroupLandingPage`	`ad_group_criterion.final_urls`
`productGroupMaxBid`	Behavior change
`productGroupMaxCpc`	`ad_group_criterion.cpc_bid_micros`
`productGroupMinBid`	Behavior change
`productGroupPartitionType`	`ad_group_criterion.listing_group.type`
`quarterEnd`	Behavior change
`quarterStart`	`segments.quarter`
`status`	`ad_group_criterion.status`
`visits`	`Not available in V0`
`weekEnd`	Behavior change
`weekStart`	`segments.week`
`yearEnd`	Behavior change
`yearStart`	`segments.year`

ProductLeadAndCrossSell report

Column names in the `productLeadAndCrossSell` report	new Search Ads 360 Reporting API mapping
`accountId`	`customer.id`
`adGroupId`	`ad_group.id`
`advertiser`	See account management
`advertiserId`	See account management
`agency`	See account management
`agencyId`	See account management
`campaignId`	`campaign.id`
`crossSellAverageUnitPrice`	`metrics.cross_sell_revenue_micros` / `metrics.cross_sell_units_sold`
`crossSellCostOfGoodsSold`	`metrics.cross_sell_cost_of_goods_sold_micros`
`crossSellGrossFromUnitsSold`	`metrics.cross_sell_revenue_micros`
`crossSellGrossProfitMargin`	`metrics.cross_sell_gross_profit_micros`
`crossSellRevenueFromUnitsSold`	`metrics.cross_sell_revenue_micros`
`crossSellUnitsSold`	`metrics.cross_sell_units_sold`
`date`	`segments.date`
`deviceSegment`	`segments.device`
`dfaActions`	Behavior change
`dfaActionsCrossEnv`	Behavior change
`dfaRevenue`	Behavior change
`dfaRevenueCrossEnv`	Behavior change
`dfaTransactions`	Behavior change
`dfaTransactionsCrossEnv`	Behavior change
`dfaWeightedActions`	Behavior change
`dfaWeightedActionsCrossEnv`	Behavior change
`floodlightActivity`	`segments.conversion_action_name`
`floodlightActivityId`	Use `conversion_action`
`floodlightActivityTag`	Use `conversion_action`
`floodlightGroup`	Behavior change
`floodlightGroupId`	Behavior change
`floodlightGroupTag`	Use `conversion_action`
`leadAverageUnitPrice`	`metrics.lead_revenue_micros` / `metrics.lead_units_sold`
`leadCostOfGoodsSold`	`metrics.lead_cost_of_goods_sold_micros`
`leadGrossProfitFromUnitsSold`	`metrics.lead_gross_profit_micros`
`leadGrossProfitMargin`	Behavior change
`leadRevenueFromUnitsSold`	`metrics.lead_revenue_micros`
`leadUnitsSold`	`metrics.lead_units_sold`
`monthEnd`	Behavior change
`monthStart`	`segments.month`
`productAgeGroup`	Behavior change
`productAvailability`	Behavior change
`productAverageUnitPrice`	Behavior change
`productBrand`	`segments.product_brand` `segments.product_sold_brand`
`productCategory`	Behavior change
`productCategoryLevel1`	`segments.product_bidding_category_level1` `segments.product_sold_bidding_category_level1`¹⁰
`productCategoryLevel2`	`segments.product_bidding_category_level2` `segments.product_sold_bidding_category_level2`
`productCategoryLevel3`	`segments.product_bidding_category_level3` `segments.product_sold_bidding_category_level3`
`productCategoryLevel4`	`segments.product_bidding_category_level4` `segments.product_sold_bidding_category_level4`
`productCategoryLevel5`	`segments.product_bidding_category_level5` `segments.product_sold_bidding_category_level5`
`productChannel`	`segments.product_channel` `segments.product_sold_channel`
`productChannelExclusivity`	`segments.product_channel_exclusivity` `segments.product_sold_channel_exclusivity`
`productColor`	Behavior change
`productCondition`	`segments.product_condition` `segments.product_sold_condition`
`productCostOfGoodsSold`	Behavior change
`productCountry`	`segments.product_country` `segments.product_sold_country`
`productCustomLabel0`	`segments.product_custom_attribute0` `segments.product_sold_custom_attribute0`
`productCustomLabel1`	`segments.product_custom_attribute1` `segments.product_sold_custom_attribute1`
`productCustomLabel2`	`segments.product_custom_attribute2` `segments.product_sold_custom_attribute2`
`productCustomLabel3`	`segments.product_custom_attribute3` `segments.product_sold_custom_attribute3`
`productCustomLabel4`	`segments.product_custom_attribute4` `segments.product_sold_custom_attribute4`
`productGender`	Behavior change
`productGtin`	Behavior change
`productId`	`segments.product_item_id` `segments.product_sold_item_id`
`productItemGroupId`	Behavior change
`productLandingPageUrl`	Behavior change
`productLanguage`	`segments.product_language` `segments.product_sold_language`
`productMaterial`	Behavior change
`productMpn`	Behavior change
`productPattern`	Behavior change
`productPrice`	Behavior change
`productRevenueFromUnitsSold`	Behavior change
`productSalePrice`	Behavior change
`productSize`	Behavior change
`productStoreId`	`segments.product_store_id`
`productTitle`	`segments.product_title` `segments.product_sold_title`
`productTypeLevel1`	`segments.product_type_l1` `segments.product_type_l1`
`productTypeLevel2`	`segments.product_type_l2` `segments.product_type_l2`
`productTypeLevel3`	`segments.product_type_l3` `segments.product_type_l3`
`productTypeLevel4`	`segments.product_type_l4` `segments.product_type_l4`
`productTypeLevel5`	`segments.product_type_l5` `segments.product_type_l5`
`productUnitsSold`	Behavior change
`quarterEnd`	Behavior change
`quarterStart`	`segments.quarter`
`weekEnd`	Behavior change
`weekStart`	`segments.week`
`yearEnd`	Behavior change
`yearStart`	`segments.year`

Visit report

Column names in the `visit` report	new Search Ads 360 Reporting API mapping
`account`	`customer.descriptive_name`
`accountEngineId`	`customer.engine_id`
`accountId`	`customer.id`
`accountType`	`customer.account_type`
`ad`	`ad_group_ad.ad.name`⁹
`adGroup`	`ad_group.name`
`adGroupId`	`ad_group.id`
`adGroupStatus`	`ad_group.status`
`adId`	`visit.ad_id`
`advertiser`	See account management
`advertiserId`	See account management
`agency`	See account management
`agencyId`	See account management
`campaign`	`campaign.name`
`campaignId`	`campaign.id`
`campaignStatus`	`campaign.status`
`deviceSegment`	`segments.device`
`feedId`	Behavior change
`feedItemId`	Behavior change
`feedType`	Behavior change
`inventoryAccountId`	`visit.merchant_id`
`isUnattributedAd`	Behavior change
`keywordId`	`visit.criterion_id`
`keywordMatchType`	`ad_group_criterion.keyword.match_type`
`keywordText`	`ad_group_criterion.keyword.text`
`productChannel`	`visit.product_channel`
`productCountry`	`visit.product_country_code`
`productGroupId`	`ad_group_criterion.criterion_id`
`productId`	`visit.product_id`
`productLanguage`	`visit.product_language_code`
`productStoreId`	`visit.product_store_id`
`productTargetId`	Behavior change
`status`	Behavior change
`visitDate`	`segments.date`
`visitExternalClickId`	`visit.click_id`
`visitId`	`visit.id`
`visitNetworkType`	`segments.ad_network_type`
`visitReferrer`	Behavior change
`visitSearchQuery`	Behavior change
`visitTimestamp`	`visit.visit_date_time`

Notes

{ad type} can be text_ad, expanded_text_ad, or expanded_dynamic_search_ad.
Use ad_group_ad.engine_id for Search Ads 360 accounts (e.g., Microsoft, Yahoo Japan, etc.), and ad_group_ad.ad.id for non-Search Ads 360 accounts.
{ad type} can be text_ad or expanded_text_ad.
{ad type} can be expanded_text_ad or responsive_search_ad.
Query metrics using the appropriate resource in the FROM clause (e.g., gender_view for gender criteria). See report mappings.
Query metrics using the appropriate resource in the FROM clause (e.g., campaign_asset for assets created at the campaign level). See Fetching Asset Attributes and Metrics.
Query metrics using keyword_view in the FROM clause.
Filter using negative=true in the WHERE clause. For example, SELECT campaign_criterion.keyword.match_type, campaign_criterion.keyword.text FROM campaign_criterion WHERE campaign_criterion.negative = true
Query ad_group_ad fields from the ad_group_ad resource directly. Then, query other fields from the appropriate resource (e.g., keyword_view) and use ad_id (for conversion and visit) or ad_group_criterion.resource_name (for keyword_view) to link the two queries.
For example,
SELECT ad_group_ad.ad.name, segments.keyword.ad_group_criterion FROM ad_group_ad
SELECT keyword_view.resource_name, metrics.clicks FROM keyword_view WHERE ad_group_criterion.resource_name = '(resource name from first query)'
Use product segments to identify the product that is advertised, and product_sold segments to identify products that are sold