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 報表中的欄名 新版 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 報表中的欄名 新版 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}.description11,9
adDescription2 ad_group_ad.ad.{ad type}.description21,9
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}.headline3,9
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 報表中的資料欄名稱 新版 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 報表

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 等),而非 Search Ads 360 帳戶則為 ad_group_ad.ad.id
  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 區隔來識別售出的產品