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 - 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 行為變更
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_id
adGroup ad_group.name
adGroupId ad_group.id
adGroupStatus ad_group.status
adHeadline ad_group_ad.ad.{ad type}.headline2
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}.path13
adPathField2 ad_group_ad.ad.{ad type}.path23
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 - 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 行為變更
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 - 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 行為變更
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報表中的資料欄名稱 新版 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_conversions4
adWordsConversionValue metrics.client_account_conversions_value4
adWordsViewThroughConversions metrics.client_account_view_through_conversions4
agency 請參閱帳戶管理
agencyId 請參閱帳戶管理
ageTargetAgeRange ad_group_criterion.age_range.type
ageTargetBidModifier ad_group_criterion.bid_modifier
avgCpc metrics.average_cpc4
avgCpm metrics.average_cpm4
avgPos 行為變更
campaign campaign.name
campaignId campaign.id
campaignStatus campaign.status
clicks metrics.clicks4
cost metrics.cost_micros4
creationTimestamp ad_group_criterion.creation_time
ctr metrics.ctr4
date segments.date
deviceSegment segments.device
dfaActions metrics.all_conversions - metrics.cross_device_conversions4
dfaActionsCrossEnv metrics.all_conversions4
dfaRevenue metrics.all_conversions_value - metrics.cross_device_conversions_value4
dfaRevenueCrossEnv metrics.all_conversions_value4
dfaTransactions metrics.all_conversions - metrics.cross_device_conversions4
dfaTransactionsCrossEnv metrics.all_conversions4
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.impressions4
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 - 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 行為變更
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報表中的資料欄名稱 新版 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 - 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 行為變更
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 - 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 行為變更
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 使用 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.name7
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報表中的資料欄名稱 新版 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 請參閱帳戶管理
appId asset.mobile_app_asset.app_id
appStore asset.mobile_app_asset.app_store
avgCpc metrics.average_cpc
avgCpm metrics.average_cpm
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.clicks
clicksWithFeedItemShowing 行為變更
cost metrics.cost_micros
costWithFeedItemShowing 行為變更
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 行為變更
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.impressions
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.name
adDescription1 ad_group_ad.ad.{ad type}.description11
adDescription2 ad_group_ad.ad.{ad type}.description21
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}.headline2
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 行為變更
adType ad_group_ad.ad.type
advertiser 請參閱帳戶管理
advertiserId 請參閱帳戶管理
adWordsConversions metrics.client_account_conversions5
adWordsConversionValue metrics.client_account_conversions_value5
adWordsViewThroughConversions metrics.client_account_view_through_conversions5
agency 請參閱帳戶管理
agencyId 請參閱帳戶管理
avgCpc metrics.average_cpc5
avgCpm metrics.average_cpm5
avgPos 行為變更
bidStrategyInherited 行為變更
bingKeywordParam2 行為變更
bingKeywordParam3 行為變更
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 - metrics.cross_device_conversions5
dfaActionsCrossEnv metrics.all_conversions5
dfaRevenue metrics.all_conversions_value - metrics.cross_device_conversions_value5
dfaRevenueCrossEnv metrics.all_conversions_value5
dfaTransactions metrics.all_conversions - metrics.cross_device_conversions5
dfaTransactionsCrossEnv metrics.all_conversions5
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.impressions5
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_score5
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.visits5
weekEnd 行為變更
weekStart segments.week
yearEnd 行為變更
yearStart segments.year

排除廣告群組關鍵字報表

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)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報表中的資料欄名稱 新版 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)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報表中的資料欄名稱 新版 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)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

ExcludeCampaignTarget 報表

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)6
campaign campaign.name
campaignId campaign.id
campaignStatus campaign.status
creationTimestamp 行為變更
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.negative6
negativeCampaignTargetId campaign_criterion.criterion_id (filtering with campaign_criterion.negative)6
status campaign_criterion.status (filtering with campaign_criterion.negative)6

付費和自然搜尋報表

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報表中的資料欄名稱 新版 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 - 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 行為變更
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 報表

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_level18
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.name7
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 type} 可以是 text_adexpanded_text_ad
  3. {ad type} 可以是 expanded_text_adresponsive_search_ad
  4. 請在 FROM 子句中使用合適的資源查詢指標 (例如gender_view)。請參閱「報表對應項目」一文。
  5. FROM 子句中使用 keyword_view 的查詢指標。
  6. WHERE 子句中使用 negative=true 進行篩選。例如,SELECT campaign_criterion.keyword.match_type, campaign_criterion.keyword.text FROM campaign_criterion WHERE campaign_criterion.negative = true
  7. 請勿直接使用 ad_group_ad.ad.name 欄位,下載先前從 ad_group_ad 取得的多個名稱和其他欄位,找出從 conversion.ad_idvisit.ad_id 取得的 ID 專屬名稱
  8. 使用「product」區隔來識別廣告宣傳的產品,使用 product_sold 個區隔來識別售出的產品