Search Ads 360 Reporting API 的字段映射

下表将旧版 Search Ads 360 API 中的字段映射到新版 Search Ads 360 Reporting API 中的资源。

账号报告

account 报告中的列名称 新版 Search Ads 360 Reporting API 映射
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 请参阅账号管理
advertiserId 请参阅账号管理
adWordsConversions metrics.client_account_conversions
adWordsConversionValue metrics.client_account_conversions_value
adWordsViewThroughConversions metrics.client_account_view_through_conversions
agency 请参阅账号管理
agencyId 请参阅账号管理
avgCpc metrics.average_cpc
avgCpm metrics.average_cpm
avgPos 行为变更
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 行为变更
dfaWeightedActionsCrossEnv 行为变更
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 使用 conversion_action
floodlightActivityTag 使用 conversion_action
floodlightGroup 行为变更
floodlightGroupId 行为变更
floodlightGroupTag 使用 conversion_action
impr metrics.impressions
lastModifiedTimestamp customer.last_modified_time
monthEnd 行为变更
monthStart segments.month
qualityScoreAvg metrics.historical_quality_score
quarterEnd 行为变更
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 行为变更
visits metrics.visits
weekEnd 行为变更
weekStart segments.week
yearEnd 行为变更
yearStart segments.year

广告报告

ad 报告中的列名称 新版 Search Ads 360 Reporting API 映射
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}.description11
adDescription2 ad_group_ad.ad.{ad type}.description21
adDisplayUrl ad_group_ad.ad.display_url
adEngineId ad_group_ad.engine_idad_group_ad.ad.id2
adGroup ad_group.name
adGroupId ad_group.id
adGroupStatus ad_group.status
adHeadline ad_group_ad.ad.{ad type}.headline3
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}.path14
adPathField2 ad_group_ad.ad.{ad type}.path24
adPromotionLine 行为变更
adType ad_group_ad.ad.type
advertiser 请参阅账号管理
advertiserId 请参阅账号管理
adWordsConversions metrics.client_account_conversions
adWordsConversionValue metrics.client_account_conversions_value
adWordsViewThroughConversions metrics.client_account_view_through_conversions
agency 请参阅账号管理
agencyId 请参阅账号管理
avgCpc metrics.average_cpc
avgCpm metrics.average_cpm
avgPos 行为变更
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 行为变更
dfaWeightedActionsCrossEnv 行为变更
effectiveLabels Not available in V0
engineStatus ad_group_ad.engine_status
floodlightActivity segments.conversion_action_name
floodlightActivityId 使用 conversion_action
floodlightActivityTag 使用 conversion_action
floodlightGroup 行为变更
floodlightGroupId 行为变更
floodlightGroupTag 使用 conversion_action
impr metrics.impressions
isUnattributedAd Not available
lastModifiedTimestamp ad_group_ad.last_modified_time
monthEnd 行为变更
monthStart segments.month
quarterEnd 行为变更
quarterStart segments.quarter
status ad_group_ad.status
visits metrics.visits
weekEnd 行为变更
weekStart segments.week
yearEnd 行为变更
yearStart segments.year

广告组报告

adGroup 报告中的列名称 新版 Search Ads 360 Reporting API 映射
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 行为变更
adGroupContentMaxCpc 行为变更
adGroupDesktopBidAdjustment ad_group_bid_modifier
adGroupEndDate ad_group.end_date
adGroupEngineId ad_group.engine_id
adGroupExactMaxCpc 行为变更
adGroupId ad_group.id
adGroupLabels ad_group.labels label.name
adGroupMobileBidAdjustment ad_group_bid_modifier
adGroupPhraseMaxCpc 行为变更
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 请参阅账号管理
advertiserId 请参阅账号管理
adWordsConversions metrics.client_account_conversions
adWordsConversionValue metrics.client_account_conversions_value
adWordsViewThroughConversions metrics.client_account_view_through_conversions
agency 请参阅账号管理
agencyId 请参阅账号管理
appId asset.mobile_app_asset.app_id
appStore asset.mobile_app_asset.app_store
avgCpc metrics.average_cpc
avgCpm metrics.average_cpm
avgPos 行为变更
bidStrategyInherited 行为变更
bingAdsAdDistributions 行为变更
bingAdsLanguage ad_group.language_code
callCallOnly 行为变更
callConversionTracker asset.call_asset.call_conversion_action
callConversionTrackerId 行为变更
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 行为变更
cost metrics.cost_micros
costWithFeedItemShowing 行为变更
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 行为变更
dfaWeightedActionsCrossEnv 行为变更
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 使用 conversion_action
floodlightActivityTag 使用 conversion_action
floodlightGroup 行为变更
floodlightGroupId 行为变更
floodlightGroupTag 使用 conversion_action
impr metrics.impressions
lastModifiedTimestamp ad_group.last_modified_time
locationBusinessName Not available in V0
locationCategory 行为变更
locationDetails Not available in V0
locationFilter 行为变更
metroTargets ad_group_criterion.location.geo_target_constant
monthEnd 行为变更
monthStart segments.month
provinceTargets ad_group_criterion.location.geo_target_constant
qualityScoreAvg metrics.historical_quality_score
quarterEnd 行为变更
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 行为变更
visits metrics.visits
weekEnd 行为变更
weekStart segments.week
yearEnd 行为变更
yearStart segments.year

AdGroupTarget 报告

adGroupTarget 报告中的列名称 新版 Search Ads 360 Reporting API 映射
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 请参阅账号管理
advertiserId 请参阅账号管理
adWordsConversions metrics.client_account_conversions5
adWordsConversionValue metrics.client_account_conversions_value5
adWordsViewThroughConversions metrics.client_account_view_through_conversions5
agency 请参阅账号管理
agencyId 请参阅账号管理
ageTargetAgeRange ad_group_criterion.age_range.type
ageTargetBidModifier ad_group_criterion.bid_modifier
avgCpc metrics.average_cpc5
avgCpm metrics.average_cpm5
avgPos 行为变更
campaign campaign.name
campaignId campaign.id
campaignStatus campaign.status
clicks metrics.clicks5
cost metrics.cost_micros5
creationTimestamp ad_group_criterion.creation_time
ctr metrics.ctr5
date segments.date
deviceSegment segments.device
dfaActions metrics.all_conversions_by_conversion_date - metrics.cross_device_conversions_by_conversion_date5
dfaActionsCrossEnv metrics.all_conversions_by_conversion_date5
dfaRevenue metrics.all_conversions_value_by_conversion_date - metrics.cross_device_conversions_value_by_conversion_date5
dfaRevenueCrossEnv metrics.all_conversions_value_by_conversion_date5
dfaTransactions metrics.all_conversions_by_conversion_date - metrics.cross_device_conversions_by_conversion_date5
dfaTransactionsCrossEnv metrics.all_conversions_by_conversion_date5
dfaWeightedActions 行为变更
dfaWeightedActionsCrossEnv 行为变更
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 使用 conversion_action
floodlightActivityTag 使用 conversion_action
floodlightGroup 行为变更
floodlightGroupId 行为变更
floodlightGroupTag 使用 conversion_action
genderTargetBidModifier ad_group_criterion.bid_modifier
genderTargetGenderType ad_group_criterion.gender.type
impr metrics.impressions5
lastModifiedTimestamp ad_group_criterion.last_modified_time
locationTargetBidModifier ad_group_criterion.bid_modifier
locationTargetName ad_group_criterion.location.geo_target_constant
monthEnd 行为变更
monthStart segments.month
quarterEnd 行为变更
quarterStart segments.quarter
status ad_group_criterion.status
unclassifiedTargetName 行为变更
unclassifiedTargetType 行为变更
visits Not available in V0
weekEnd 行为变更
weekStart segments.week
yearEnd 行为变更
yearStart segments.year

广告客户报告

advertiser 报告中的列名称 新版 Search Ads 360 Reporting API 映射
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 请参阅账号管理
agencyId 请参阅账号管理
avgCpc metrics.average_cpc
avgCpm metrics.average_cpm
avgPos 行为变更
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 行为变更
dfaWeightedActionsCrossEnv 行为变更
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 使用 conversion_action
floodlightActivityTag 使用 conversion_action
floodlightGroup 行为变更
floodlightGroupId 行为变更
floodlightGroupTag 使用 conversion_action
googleAnalyticsTimeZone Not available in V0
impr metrics.impressions
lastModifiedTimestamp customer.last_modified_time
monthEnd 行为变更
monthStart segments.month
qualityScoreAvg metrics.historical_quality_score
quarterEnd 行为变更
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 行为变更
visits Not available in V0
weekEnd 行为变更
weekStart segments.week
yearEnd 行为变更
yearStart segments.year

BidStrategy 报告

bidStrategy 报告中的列名称 新版 Search Ads 360 Reporting API 映射
advertiser 请参阅账号管理
advertiserId 请参阅账号管理
adWordsConversions metrics.client_account_conversions
adWordsConversionValue metrics.client_account_conversions_value
adWordsViewThroughConversions metrics.client_account_view_through_conversions
agency 请参阅账号管理
agencyId 请参阅账号管理
avgCpc metrics.average_cpc
avgCpm metrics.average_cpm
avgPos 行为变更
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 行为变更
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 行为变更
dfaWeightedActionsCrossEnv 行为变更
ersTarget bidding_strategy.target_roas.target_roas
floodlightActivityTargetIds 使用 segments.conversion_action 获取 Floodlight 信息列表
floodlightOptimizationEnabled 使用 segments.conversion_action 检查其是否针对 Floodlight 转化进行优化
highPosition 行为变更
impr metrics.impressions
lastModifiedTimestamp 行为变更
lowPosition 行为变更
monthEnd 行为变更
monthlySpendTarget bidding_strategy.target_spend.target_spend_micros
monthStart segments.month
quarterEnd 行为变更
quarterStart segments.quarter
roasTarget bidding_strategy.target_roas.target_roas
status bidding_strategy.status
type bidding_strategy.type
visits Not available in V0
weekEnd 行为变更
weekStart segments.week
yearEnd 行为变更
yearStart segments.year

广告系列报告

campaign 报告中的列名称 新版 Search Ads 360 Reporting API 映射
absoluteTopImpressionPercentage metrics.absolute_top_impression_percentage
account customer.descriptive_name
accountEngineId customer.engine_id
accountId customer.id
accountType customer.account_type
advertiser 请参阅账号管理
advertiserId 请参阅账号管理
adWordsBidStrategy campaign.bidding_strategy_type
adWordsConversions metrics.client_account_conversions
adWordsConversionValue metrics.client_account_conversions_value
adWordsViewThroughConversions metrics.client_account_view_through_conversions
agency 请参阅账号管理
agencyId 请参阅账号管理
appId asset.mobile_app_asset.app_id
appStore asset.mobile_app_asset.app_store
avgCpc metrics.average_cpc
avgCpm metrics.average_cpm
avgPos 行为变更
bidStrategyInherited 行为变更
bingAdsBudgetType campaign_budget.period campaign_budget.delivery_method
callCallOnly 行为变更
callConversionTracker asset.call_asset.call_conversion_action
callConversionTrackerId 行为变更
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 行为变更
cost metrics.cost_micros
costWithFeedItemShowing 行为变更
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 行为变更
dfaWeightedActionsCrossEnv 行为变更
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)8
excludedCountryTargets campaign_criterion.location.geo_target_constant (filtering with campaign_criterion.negative)8
excludedMetroTargets campaign_criterion.location.geo_target_constant (filtering with campaign_criterion.negative)8
excludedProvinceTargets campaign_criterion.location.geo_target_constant (filtering with campaign_criterion.negative)8
feedId asset_set.id
feedItemId asset.id
feedType asset.type
floodlightActivity segments.conversion_action_name
floodlightActivityId 使用 conversion_action
floodlightActivityTag 使用 conversion_action
floodlightGroup 行为变更
floodlightGroupId 行为变更
floodlightGroupTag 使用 conversion_action
impr metrics.impressions
keywordNearMatchEnabled 行为变更
lastModifiedTimestamp campaign.last_modified_time
languageTargets campaign_criterion.language.language_constant
locationBusinessName Not available in V0
locationCategory 行为变更
locationDetails Not available in V0
locationFilter 行为变更
metroTargets campaign_criterion.location.geo_target_constant
monthEnd 行为变更
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 行为变更
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 行为变更
visits metrics.visits
weekEnd 行为变更
weekStart segments.week
yahooGeoTargets campaign_criterion.location.geo_target_constant
yahooJapanBidStrategy bidding_strategy.name
yearEnd 行为变更
yearStart segments.year

CampaignTarget 报告

campaignTarget 报告中的列名称 新版 Search Ads 360 Reporting API 映射
account customer.descriptive_name
accountEngineId customer.engine_id
accountId customer.id
accountType customer.account_type
advertiser 请参阅账号管理
advertiserId 请参阅账号管理
adWordsConversions metrics.client_account_conversions
adWordsConversionValue metrics.client_account_conversions_value
adWordsViewThroughConversions metrics.client_account_view_through_conversions
agency 请参阅账号管理
agencyId 请参阅账号管理
avgCpc metrics.average_cpc
avgCpm metrics.average_cpm
avgPos 行为变更
campaign campaign.name
campaignId campaign.id
campaignStatus campaign.status
campaignTargetId campaign_criterion.criterion_id
clicks metrics.clicks
cost metrics.cost_micros
creationTimestamp 行为变更
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 行为变更
dfaWeightedActionsCrossEnv 行为变更
engineRemarketingList campaign_criterion.user_list.user_list user_list.name
engineRemarketingListBidModifier campaign_criterion.bid_modifier
floodlightActivity segments.conversion_action_name
floodlightActivityId 使用 conversion_action
floodlightActivityTag 使用 conversion_action
floodlightGroup 行为变更
floodlightGroupId 行为变更
floodlightGroupTag 使用 conversion_action
impr metrics.impressions
lastModifiedTimestamp campaign_criterion.last_modified_time
locationTargetBidModifier campaign_criterion.bid_modifier
locationTargetName campaign_criterion.location.geo_target_constant
monthEnd 行为变更
monthStart segments.month
quarterEnd 行为变更
quarterStart segments.quarter
status campaign_criterion.status
visits Not available in V0
weekEnd 行为变更
weekStart segments.week
yearEnd 行为变更
yearStart segments.year

转化报告

conversion 报告中的列名称 新版 Search Ads 360 Reporting API 映射
account customer.descriptive_name
accountEngineId customer.engine_id
accountId customer.id
accountType customer.descriptive_name
ad ad_group_ad.ad.name9
adGroup ad_group.name
adGroupId ad_group.id
adGroupStatus ad_group.status
adId conversion.ad_id
advertiser 请参阅账号管理
advertiserConversionId conversion.advertiser_conversion_id
advertiserId 请参阅账号管理
agency 请参阅账号管理
agencyId 请参阅账号管理
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 行为变更
conversionTimestamp conversion.conversion_date_time
conversionType 行为变更
conversionVisitExternalClickId conversion.click_id
conversionVisitId conversion.visit_id
conversionVisitTimestamp conversion.conversion_visit_date_time
deviceSegment segments.device
feedId 行为变更
feedItemId 行为变更
feedType 行为变更
floodlightActivity 使用 conversion_action
floodlightActivityId 使用 conversion_action
floodlightActivityTag 使用 conversion_action
floodlightEventRequestString 行为变更
floodlightGroup 使用 conversion_action
floodlightGroupConversionType 使用 conversion_action
floodlightGroupId 行为变更
floodlightGroupTag 使用 conversion_action
floodlightOrderId conversion.floodlight_order_id
floodlightOriginalRevenue conversion.floodlight_original_revenue
floodlightReferrer 行为变更
inventoryAccountId conversion.merchant_id
isUnattributedAd 行为变更
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 行为变更
status conversion.status

FeedItem 报告

feedItem 报告中的列名称 新版 Search Ads 360 Reporting API 的对应关系
account customer.descriptive_name
accountEngineId customer.engine_id
accountId customer.id
accountType customer.account_type
advertiser 请参阅账号管理
advertiserId 请参阅账号管理
adWordsConversions metrics.client_account_conversions6
adWordsConversionValue metrics.client_account_conversions_value6
adWordsViewThroughConversions metrics.client_account_view_through_conversions6
agency 请参阅账号管理
agencyId 请参阅账号管理
appId asset.mobile_app_asset.app_id
appStore asset.mobile_app_asset.app_store
avgCpc metrics.average_cpc6
avgCpm metrics.average_cpm6
avgPos 行为变更
callCallOnly 行为变更
callConversionTracker asset.call_asset.call_conversion_action
callConversionTrackerId 行为变更
callCountryCode asset.call_asset.country_code
callIsTracked asset.call_asset.call_tracking_enabled
callPhoneNumber asset.call_asset.phone_number
clicks metrics.clicks6
clicksWithFeedItemShowing 行为变更
cost metrics.cost_micros6
costWithFeedItemShowing 行为变更
creationTimestamp asset.creation_time
ctr metrics.ctr6
date segments.date
dfaActions metrics.all_conversions - metrics.cross_device_conversions6
dfaActionsCrossEnv metrics.all_conversions6
dfaRevenue metrics.all_conversions_value - metrics.cross_device_conversions_value6
dfaRevenueCrossEnv metrics.all_conversions_value6
dfaTransactions metrics.all_conversions - metrics.cross_device_conversions6
dfaTransactionsCrossEnv metrics.all_conversions6
dfaWeightedActions 行为变更
dfaWeightedActionsCrossEnv 行为变更
engineStatus asset.engine_status
feedId asset_set.id
feedItemId asset.id
floodlightActivity segments.conversion_action_name
floodlightActivityId 使用 conversion_action
floodlightActivityTag 使用 conversion_action
floodlightGroup 行为变更
floodlightGroupId 行为变更
floodlightGroupTag 使用 conversion_action
impr metrics.impressions6
lastModifiedTimestamp asset.last_modified_time
locationBusinessName Not available in V0
locationCategory 行为变更
locationDetails Not available in V0
monthEnd 行为变更
monthStart segments.month
quarterEnd 行为变更
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 行为变更
weekStart segments.week
yearEnd 行为变更
yearStart segments.year

FloodlightActivity 报告

floodlightActivity 报告中的列名称 新版 Search Ads 360 Reporting API 映射
advertiser 请参阅账号管理
advertiserId 请参阅账号管理
agency 请参阅账号管理
agencyId 请参阅账号管理
creationTimestamp conversion_action.creation_time
floodlightActivity conversion_action.name
floodlightActivityId conversion_action.floodlight_settings.activity_id
floodlightActivityTag conversion_action.floodlight_settings.activity_tag
floodlightConfigurationId 行为变更
floodlightGroup 行为变更
floodlightGroupConversionType conversion_action.type
floodlightGroupId 行为变更
floodlightGroupTag conversion_action.floodlight_settings.activity_group_tag
lastModifiedTimestamp 行为变更
status conversion_action.status

关键字报告

keyword 报告中的列名称 新版 Search Ads 360 Reporting API 映射
account customer.descriptive_name
accountEngineId customer.engine_id
accountId customer.id
accountType customer.account_type
ad ad_group_ad.ad.name9
adDescription1 ad_group_ad.ad.{ad type}.description119
adDescription2 ad_group_ad.ad.{ad type}.description219
adDisplayUrl ad_group_ad.ad.display_url9
adGroup ad_group.name
adGroupId ad_group.id
adGroupStatus ad_group.status
adHeadline ad_group_ad.ad.{ad type}.headline39
adHeadline2 ad_group_ad.ad.expanded_text_ad.headline29
adHeadline3 ad_group_ad.ad.expanded_text_ad.headline39
adId ad_group_ad.ad.id9
adLandingPage ad_group_ad.ad.final_urls9
adPromotionLine 行为变更
adType ad_group_ad.ad.type9
advertiser 请参阅账号管理
advertiserId 请参阅账号管理
adWordsConversions metrics.client_account_conversions7
adWordsConversionValue metrics.client_account_conversions_value7
adWordsViewThroughConversions metrics.client_account_view_through_conversions7
agency 请参阅账号管理
agencyId 请参阅账号管理
avgCpc metrics.average_cpc7
avgCpm metrics.average_cpm7
avgPos 行为变更
bidStrategyInherited 行为变更
bingKeywordParam2 行为变更
bingKeywordParam3 行为变更
campaign campaign.name
campaignId campaign.id
campaignStatus campaign.status
clicks metrics.clicks7
cost metrics.cost_micros7
creationTimestamp ad_group_criterion.creation_time
ctr metrics.ctr7
date segments.date
deviceSegment segments.device
dfaActions metrics.all_conversions_by_conversion_date - metrics.cross_device_conversions_by_conversion_date7
dfaActionsCrossEnv metrics.all_conversions_by_conversion_date7
dfaRevenue metrics.all_conversions_value_by_conversion_date - metrics.cross_device_conversions_value_by_conversion_date7
dfaRevenueCrossEnv metrics.all_conversions_value_by_conversion_date7
dfaTransactions metrics.all_conversions_by_conversion_date - metrics.cross_device_conversions_by_conversion_date7
dfaTransactionsCrossEnv metrics.all_conversions_by_conversion_date7
dfaWeightedActions 行为变更
dfaWeightedActionsCrossEnv 行为变更
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 使用 conversion_action
floodlightActivityTag 使用 conversion_action
floodlightGroup 行为变更
floodlightGroupId 行为变更
floodlightGroupTag 使用 conversion_action
impr metrics.impressions7
isDisplayKeyword 行为变更
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 行为变更
monthStart segments.month
qualityScoreAvg metrics.historical_quality_score7
qualityScoreCurrent ad_group_criterion.quality_info.quality_score
quarterEnd 行为变更
quarterStart segments.quarter
status ad_group_criterion.status
topOfPageBidAvg 行为变更
topOfPageBidCurrent ad_group_criterion.position_estimates.top_of_page_cpc_micros
visits metrics.visits7
weekEnd 行为变更
weekStart segments.week
yearEnd 行为变更
yearStart segments.year

NegativeAdGroupKeyword 报告

negativeAdGroupKeyword 报告中的列名称 新版 Search Ads 360 Reporting API 映射
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 请参阅账号管理
advertiserId 请参阅账号管理
agency 请参阅账号管理
agencyId 请参阅账号管理
campaign campaign.name
campaignId campaign.id
campaignStatus campaign.status
creationTimestamp ad_group_criterion.creation_time
engineStatus 行为变更
lastModifiedTimestamp ad_group_criterion.last_modified_time
negativeAdGroupKeywordId ad_group_criterion.criterion_id (filtering with ad_group_criterion.negative)8
negativeAdGroupKeywordMatchType ad_group_criterion.keyword.match_type (filtering with ad_group_criterion.negative)8
negativeAdGroupKeywordText ad_group_criterion.keyword.text (filtering with ad_group_criterion.negative)8
status ad_group_criterion.status (filtering with ad_group_criterion.negative)8

NegativeAdGroupTarget 报告

negativeAdGroupTarget 报告中的列名称 新版 Search Ads 360 Reporting API 映射
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 请参阅账号管理
advertiserId 请参阅账号管理
agency 请参阅账号管理
agencyId 请参阅账号管理
ageTargetAgeRange ad_group_criterion.age_range.type (filtering with ad_group_criterion.negative)8
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)8
engineRemarketingList ad_group_criterion.user_list.user_list user_list.name (filtering with ad_group_criterion.negative)8
genderTargetGenderType ad_group_criterion.gender.type (filtering with ad_group_criterion.negative)8
lastModifiedTimestamp ad_group_criterion.last_modified_time
locationTargetName ad_group_criterion.location.geo_target_constant (filtering with ad_group_criterion.negative)8
negativeAdGroupTargetId ad_group_criterion.criterion_id (filtering with ad_group_criterion.negative)8
status ad_group_criterion.status (filtering with ad_group_criterion.negative)8

NegativeCampaignKeyword 报告

negativeCampaignKeyword 报告中的列名称 新版 Search Ads 360 Reporting API 映射
account customer.descriptive_name
accountEngineId customer.engine_id
accountId customer.id
accountType customer.account_type
advertiser 请参阅账号管理
advertiserId 请参阅账号管理
agency 请参阅账号管理
agencyId 请参阅账号管理
campaign campaign.name
campaignId campaign.id
campaignStatus campaign.status
creationTimestamp 行为变更
engineStatus 行为变更
lastModifiedTimestamp campaign_criterion.last_modified_time
negativeCampaignKeywordId campaign_criterion.criterion_id (filtering with campaign_criterion.negative)8
negativeCampaignKeywordMatchType campaign_criterion.keyword.match_type (filtering with campaign_criterion.negative)8
negativeCampaignKeywordText campaign_criterion.keyword.text (filtering with campaign_criterion.negative)8
status campaign_criterion.status (filtering with campaign_criterion.negative)8

NegativeCampaignTarget 报告

negativeCampaignTarget 报告中的列名称 新版 Search Ads 360 Reporting API 映射
account customer.descriptive_name
accountEngineId customer.engine_id
accountId customer.id
accountType customer.account_type
advertiser 请参阅账号管理
advertiserId 请参阅账号管理
agency 请参阅账号管理
agencyId 请参阅账号管理
ageTargetAgeRange campaign_criterion.age_range.type (filtering with campaign_criterion.negative)8
campaign campaign.name
campaignId campaign.id
campaignStatus campaign.status
creationTimestamp 行为变更
dynamicSearchAdsTargetConditions campaign_criterion.webpage.conditions (filtering with campaign_criterion.negative)8
engineRemarketingList campaign_criterion.user_list.user_list user_list.name (filtering with campaign_criterion.negative)8
genderTargetGenderType campaign_criterion.gender.type (filtering with campaign_criterion.negative)8
lastModifiedTimestamp campaign_criterion.last_modified_time
locationTargetName campaign_criterion.location.geo_target_constant campaign_criterion.negative8
negativeCampaignTargetId campaign_criterion.criterion_id (filtering with campaign_criterion.negative)8
status campaign_criterion.status (filtering with campaign_criterion.negative)8

PaidAndOrganic 报告

paidAndOrganic 报告中的列名称 新版 Search Ads 360 Reporting API 的对应关系
account customer.descriptive_name
accountEngineId customer.engine_id
accountId customer.id
accountType customer.account_type
adGroup
adGroupId
advertiser 请参阅账号管理
advertiserId 请参阅账号管理
agency 请参阅账号管理
agencyId 请参阅账号管理
campaign
campaignId
date segments.date
keywordId segments.keyword.ad_group_criterion
keywordMatchType segments.keyword.info.match_type
keywordText segments.keyword.info.text
monthEnd 行为变更
monthStart segments.month
organicAvgPos 行为变更
organicClicks metrics.organic_clicks
organicCtr
organicQueries metrics.organic_queries
paidAndOrganicClicks metrics.combined_clicks
paidAndOrganicCtr metrics.ctr
paidAndOrganicQueries metrics.combined_queries
paidAvgPos 行为变更
paidClicks
paidCostPerClick metrics.average_cpc
paidCtr
paidImpressions
quarterEnd 行为变更
quarterStart segments.quarter
searchQuery paid_organic_search_term_view.search_term
serpType segments.search_engine_results_page_type
weekEnd 行为变更
weekStart segments.week
yearEnd 行为变更
yearStart segments.year

ProductAdvertised 报告

productAdvertised 报告中的列名称 新版 Search Ads 360 Reporting API 映射
accountId customer.id
adGroupId ad_group.id
advertiser 请参阅账号管理
advertiserId 请参阅账号管理
adWordsConversions metrics.client_account_conversions
adWordsConversionValue metrics.client_account_conversions_value
adWordsViewThroughConversions 行为变更
agency 请参阅账号管理
agencyId 请参阅账号管理
avgCpc metrics.average_cpc
avgCpm 行为变更
avgPos 行为变更
campaignId campaign.id
clicks metrics.clicks
cost metrics.cost_micros
creationTimestamp 行为变更
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 行为变更
dfaWeightedActionsCrossEnv 行为变更
floodlightActivity segments.conversion_action_name
floodlightActivityId 使用 conversion_action
floodlightActivityTag 使用 conversion_action
floodlightGroup 行为变更
floodlightGroupId 行为变更
floodlightGroupTag 使用 conversion_action
impr metrics.impressions
lastModifiedTimestamp 行为变更
monthEnd 行为变更
monthStart segments.month
productAgeGroup 行为变更
productAvailability 行为变更
productBrand segments.product_brand
productCategory 行为变更
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 行为变更
productCondition segments.product_condition
productCostOfGoodsSold 行为变更
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 行为变更
productGtin 行为变更
productId segments.product_item_id
productItemGroupId 行为变更
productLandingPageUrl 行为变更
productLanguage segments.product_language
productMaterial 行为变更
productMpn 行为变更
productPattern 行为变更
productPrice 行为变更
productSalePrice 行为变更
productSize 行为变更
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 行为变更
quarterStart segments.quarter
status 行为变更
visits Not available in V0
weekEnd 行为变更
weekStart segments.week
yearEnd 行为变更
yearStart segments.year

产品组报告

productGroup 报告中的列名称 新版 Search Ads 360 Reporting API 映射
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 请参阅账号管理
advertiserId 请参阅账号管理
adWordsConversions metrics.client_account_conversions
adWordsConversionValue metrics.client_account_conversions_value
adWordsViewThroughConversions metrics.client_account_view_through_conversions
agency 请参阅账号管理
agencyId 请参阅账号管理
avgCpc metrics.average_cpc
avgCpm metrics.average_cpm
avgPos 行为变更
bidStrategyInherited 行为变更
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 行为变更
dfaWeightedActionsCrossEnv 行为变更
effectiveBidStrategy 行为变更
effectiveBidStrategyId 行为变更
effectiveLabels 行为变更
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 行为变更
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 行为变更
productGroupMaxCpc ad_group_criterion.cpc_bid_micros
productGroupMinBid 行为变更
productGroupPartitionType ad_group_criterion.listing_group.type
quarterEnd 行为变更
quarterStart segments.quarter
status ad_group_criterion.status
visits Not available in V0
weekEnd 行为变更
weekStart segments.week
yearEnd 行为变更
yearStart segments.year

ProductLeadAndCrossSell 报告

productLeadAndCrossSell 报告中的列名称 新版 Search Ads 360 Reporting API 的对应关系
accountId customer.id
adGroupId ad_group.id
advertiser 请参阅账号管理
advertiserId 请参阅账号管理
agency 请参阅账号管理
agencyId 请参阅账号管理
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 行为变更
dfaActionsCrossEnv 行为变更
dfaRevenue 行为变更
dfaRevenueCrossEnv 行为变更
dfaTransactions 行为变更
dfaTransactionsCrossEnv 行为变更
dfaWeightedActions 行为变更
dfaWeightedActionsCrossEnv 行为变更
floodlightActivity segments.conversion_action_name
floodlightActivityId 使用 conversion_action
floodlightActivityTag 使用 conversion_action
floodlightGroup 行为变更
floodlightGroupId 行为变更
floodlightGroupTag 使用 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 行为变更
leadRevenueFromUnitsSold metrics.lead_revenue_micros
leadUnitsSold metrics.lead_units_sold
monthEnd 行为变更
monthStart segments.month
productAgeGroup 行为变更
productAvailability 行为变更
productAverageUnitPrice 行为变更
productBrand segments.product_brand segments.product_sold_brand
productCategory 行为变更
productCategoryLevel1 segments.product_bidding_category_level1 segments.product_sold_bidding_category_level110
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 行为变更
productCondition segments.product_condition segments.product_sold_condition
productCostOfGoodsSold 行为变更
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 行为变更
productGtin 行为变更
productId segments.product_item_id segments.product_sold_item_id
productItemGroupId 行为变更
productLandingPageUrl 行为变更
productLanguage segments.product_language segments.product_sold_language
productMaterial 行为变更
productMpn 行为变更
productPattern 行为变更
productPrice 行为变更
productRevenueFromUnitsSold 行为变更
productSalePrice 行为变更
productSize 行为变更
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 行为变更
quarterEnd 行为变更
quarterStart segments.quarter
weekEnd 行为变更
weekStart segments.week
yearEnd 行为变更
yearStart segments.year

访问报告

visit 报告中的列名称 新版 Search Ads 360 Reporting API 映射
account customer.descriptive_name
accountEngineId customer.engine_id
accountId customer.id
accountType customer.account_type
ad ad_group_ad.ad.name9
adGroup ad_group.name
adGroupId ad_group.id
adGroupStatus ad_group.status
adId visit.ad_id
advertiser 请参阅账号管理
advertiserId 请参阅账号管理
agency 请参阅账号管理
agencyId 请参阅账号管理
campaign campaign.name
campaignId campaign.id
campaignStatus campaign.status
deviceSegment segments.device
feedId 行为变更
feedItemId 行为变更
feedType 行为变更
inventoryAccountId visit.merchant_id
isUnattributedAd 行为变更
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 行为变更
status 行为变更
visitDate segments.date
visitExternalClickId visit.click_id
visitId visit.id
visitNetworkType segments.ad_network_type
visitReferrer 行为变更
visitSearchQuery 行为变更
visitTimestamp visit.visit_date_time

备注

  1. {ad type} 可以是 text_adexpanded_text_adexpanded_dynamic_search_ad
  2. 使用 ad_group_ad.engine_id 为 Search Ads 360 账号(例如Microsoft、Yahoo Japan 等)和 ad_group_ad.ad.id(针对非 Search Ads 360 账号)。
  3. {ad type} 可以是 text_adexpanded_text_ad
  4. {ad type} 可以是 expanded_text_adresponsive_search_ad
  5. FROM 子句中使用适当的资源(例如gender_view)。请参阅报告映射
  6. 使用 FROM 子句中的适当资源(例如campaign_asset(对于在广告系列一级制作的素材资源)。请参阅提取资源属性和指标
  7. FROM 子句中使用 keyword_view 查询指标。
  8. WHERE 子句中使用 negative=true 进行过滤。例如 SELECT campaign_criterion.keyword.match_type, campaign_criterion.keyword.text FROM campaign_criterion WHERE campaign_criterion.negative = true
  9. 直接从 ad_group_ad 资源查询 ad_group_ad 字段。然后,从相应资源(例如keyword_view),并使用 ad_id(对于 conversionvisit)或 ad_group_criterion.resource_name(对于 keyword_view)将这两个查询关联起来。
    例如
    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)'
  10. 使用 product 细分来标识宣传的产品,使用 product_sold 细分来标识销售的产品