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 - 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 |
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 1 |
adDescription2 |
ad_group_ad.ad.{ad_type}.description2 1 |
adDisplayUrl |
ad_group_ad.ad.display_url |
adEngineId |
ad_group_ad.engine_id |
adGroup |
ad_group.name |
adGroupId |
ad_group.id |
adGroupStatus |
ad_group.status |
adHeadline |
ad_group_ad.ad.{ad_type}.headline 2 |
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 3 |
adPathField2 |
ad_group_ad.ad.{ad type}.path2 3 |
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 - 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 |
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 - 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 |
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 4 |
adWordsConversionValue |
metrics.client_account_conversions_value 4 |
adWordsViewThroughConversions |
metrics.client_account_view_through_conversions 4 |
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 4 |
avgCpm |
metrics.average_cpm 4 |
avgPos |
Behavior change |
campaign |
campaign.name |
campaignId |
campaign.id |
campaignStatus |
campaign.status |
clicks |
metrics.clicks 4 |
cost |
metrics.cost_micros 4 |
creationTimestamp |
ad_group_criterion.creation_time |
ctr |
metrics.ctr 4 |
date |
segments.date |
deviceSegment |
segments.device |
dfaActions |
metrics.all_conversions - metrics.cross_device_conversions 4 |
dfaActionsCrossEnv |
metrics.all_conversions 4 |
dfaRevenue |
metrics.all_conversions_value - metrics.cross_device_conversions_value 4 |
dfaRevenueCrossEnv |
metrics.all_conversions_value 4 |
dfaTransactions |
metrics.all_conversions - metrics.cross_device_conversions 4 |
dfaTransactionsCrossEnv |
metrics.all_conversions 4 |
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 4 |
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 - metrics.cross_device_conversions |
dfaActionsCrossEnv |
metrics.all_conversions |
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 - 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 |
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 - 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 |
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 - 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 |
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) 6 |
excludedCountryTargets |
campaign_criterion.location.geo_target_constant (filtering with campaign_criterion.negative) 6 |
excludedMetroTargets |
campaign_criterion.location.geo_target_constant (filtering with campaign_criterion.negative) 6 |
excludedProvinceTargets |
campaign_criterion.location.geo_target_constant (filtering with campaign_criterion.negative) 6 |
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 (filtering with conversion.ad_id) |
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_timestamp |
conversionId |
conversion.conversion_id |
conversionLastModifiedTimestamp |
conversion.conversion_last_modified_timestamp_millis |
conversionQuantity |
conversion.conversion_quantity |
conversionRevenue |
conversion.conversion_revenue_micros |
conversionSearchTerm |
Behavior change |
conversionTimestamp |
conversion.conversion_timestamp_millis |
conversionType |
Behavior change |
conversionVisitExternalClickId |
conversion.click_id |
conversionVisitId |
conversion.ds_visit_id |
conversionVisitTimestamp |
conversion_visit_timestamp_millis |
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 1 |
adDescription2 |
ad_group_ad.ad.{ad_type}.description2 1 |
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 2 |
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 5 |
adWordsConversionValue |
metrics.client_account_conversions_value 5 |
adWordsViewThroughConversions |
metrics.client_account_view_through_conversions 5 |
agency |
See account management |
agencyId |
See account management |
avgCpc |
metrics.average_cpc 5 |
avgCpm |
metrics.average_cpm 5 |
avgPos |
Behavior change |
bidStrategyInherited |
Behavior change |
bingKeywordParam2 |
Behavior change |
bingKeywordParam3 |
Behavior change |
campaign |
campaign.name |
campaignId |
campaign.id |
campaignStatus |
campaign.status |
clicks |
metrics.clicks 5 |
cost |
metrics.cost_micros 5 |
creationTimestamp |
ad_group_criterion.creation_time |
ctr |
metrics.ctr 5 |
date |
segments.date |
deviceSegment |
segments.device |
dfaActions |
metrics.all_conversions - metrics.cross_device_conversions 5 |
dfaActionsCrossEnv |
metrics.all_conversions 5 |
dfaRevenue |
metrics.all_conversions_value - metrics.cross_device_conversions_value 5 |
dfaRevenueCrossEnv |
metrics.all_conversions_value 5 |
dfaTransactions |
metrics.all_conversions - metrics.cross_device_conversions 5 |
dfaTransactionsCrossEnv |
metrics.all_conversions 5 |
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 5 |
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 5 |
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 5 |
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) 6 |
negativeAdGroupKeywordMatchType |
ad_group_criterion.keyword.match_type (filtering with ad_group_criterion.negative) 6 |
negativeAdGroupKeywordText |
ad_group_criterion.keyword.text (filtering with ad_group_criterion.negative) 6 |
status |
ad_group_criterion.status (filtering with ad_group_criterion.negative) 6 |
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) 6 |
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) 6 |
engineRemarketingList |
ad_group_criterion.user_list.user_list user_list.name (filtering with ad_group_criterion.negative) 6 |
genderTargetGenderType |
ad_group_criterion.gender.type (filtering with ad_group_criterion.negative) 6 |
lastModifiedTimestamp |
ad_group_criterion.last_modified_time |
locationTargetName |
ad_group_criterion.location.geo_target_constant (filtering with ad_group_criterion.negative) 6 |
negativeAdGroupTargetId |
ad_group_criterion.criterion_id (filtering with ad_group_criterion.negative) 6 |
status |
ad_group_criterion.status (filtering with ad_group_criterion.negative) 6 |
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) 6 |
negativeCampaignKeywordMatchType |
campaign_criterion.keyword.match_type (filtering with campaign_criterion.negative) 6 |
negativeCampaignKeywordText |
campaign_criterion.keyword.text (filtering with campaign_criterion.negative) 6 |
status |
campaign_criterion.status (filtering with campaign_criterion.negative) 6 |
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) 6 |
campaign |
campaign.name |
campaignId |
campaign.id |
campaignStatus |
campaign.status |
creationTimestamp |
Behavior change |
dynamicSearchAdsTargetConditions |
campaign_criterion.webpage.conditions (filtering with campaign_criterion.negative) 6 |
engineRemarketingList |
campaign_criterion.user_list.user_list user_list.name (filtering with campaign_criterion.negative) 6 |
genderTargetGenderType |
campaign_criterion.gender.type (filtering with campaign_criterion.negative) 6 |
lastModifiedTimestamp |
campaign_criterion.last_modified_time |
locationTargetName |
campaign_criterion.location.geo_target_constant campaign_criterion.negative 6 |
negativeCampaignTargetId |
campaign_criterion.criterion_id (filtering with campaign_criterion.negative) 6 |
status |
campaign_criterion.status (filtering with campaign_criterion.negative) 6 |
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 - 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 |
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 |
|
advertiser |
|
advertiserId |
|
agency |
|
agencyId |
|
campaignId |
|
crossSellAverageUnitPrice |
|
crossSellCostOfGoodsSold |
|
crossSellGrossFromUnitsSold |
|
crossSellGrossProfitMargin |
|
crossSellRevenueFromUnitsSold |
|
crossSellUnitsSold |
|
date |
|
deviceSegment |
|
dfaActions |
|
dfaActionsCrossEnv |
|
dfaRevenue |
|
dfaRevenueCrossEnv |
|
dfaTransactions |
|
dfaTransactionsCrossEnv |
|
dfaWeightedActions |
|
dfaWeightedActionsCrossEnv |
|
floodlightActivity |
|
floodlightActivityId |
|
floodlightActivityTag |
|
floodlightGroup |
|
floodlightGroupId |
|
floodlightGroupTag |
|
leadAverageUnitPrice |
|
leadCostOfGoodsSold |
|
leadGrossProfitFromUnitsSold |
|
leadGrossProfitMargin |
|
leadRevenueFromUnitsSold |
|
leadUnitsSold |
|
monthEnd |
|
monthStart |
|
productAgeGroup |
|
productAvailability |
|
productAverageUnitPrice |
|
productBrand |
|
productCategory |
|
productCategoryLevel1 |
|
productCategoryLevel2 |
|
productCategoryLevel3 |
|
productCategoryLevel4 |
|
productCategoryLevel5 |
|
productChannel |
|
productChannelExclusivity |
|
productColor |
|
productCondition |
|
productCostOfGoodsSold |
|
productCountry |
|
productCustomLabel0 |
|
productCustomLabel1 |
|
productCustomLabel2 |
|
productCustomLabel3 |
|
productCustomLabel4 |
|
productGender |
|
productGtin |
|
productId |
|
productItemGroupId |
|
productLandingPageUrl |
|
productLanguage |
|
productMaterial |
|
productMpn |
|
productPattern |
|
productPrice |
|
productRevenueFromUnitsSold |
|
productSalePrice |
|
productSize |
|
productStoreId |
|
productTitle |
|
productTypeLevel1 |
|
productTypeLevel2 |
|
productTypeLevel3 |
|
productTypeLevel4 |
|
productTypeLevel5 |
|
productUnitsSold |
|
quarterEnd |
|
quarterStart |
|
weekEnd |
|
weekStart |
|
yearEnd |
|
yearStart |
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.name (filtering with conversion.ad_id) |
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 |
visitReferrer |
Behavior change |
visitSearchQuery |
Behavior change |
visitTimestamp |
visit.visit_date_time |
Notes
{ad type}
can betext_ad
,expanded_text_ad
, orexpanded_dynamic_search_ad
.{ad type}
can betext_ad
orexpanded_text_ad
.{ad type}
can beexpanded_text_ad
orresponsive_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
keyword_view
in theFROM
clause. - Filter using
negative=true
in theWHERE
clause. For example,SELECT campaign_criterion.keyword.match_type, campaign_criterion.keyword.text FROM campaign_criterion WHERE campaign_criterion.negative = true