新版 Search Ads 360 Reporting API 現已開放使用。歡迎加入 searchads-api-announcements Google 群組，即時掌握即將發布的強化項目和版本資訊。

本頁面由 Cloud Translation API 翻譯而成。

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}.description1`¹
`adDescription2`	`ad_group_ad.ad.{ad type}.description2`¹
`adDisplayUrl`	`ad_group_ad.ad.display_url`
`adEngineId`	`ad_group_ad.engine_id` 或 `ad_group_ad.ad.id`²
`adGroup`	`ad_group.name`
`adGroupId`	`ad_group.id`
`adGroupStatus`	`ad_group.status`
`adHeadline`	`ad_group_ad.ad.{ad type}.headline`³
`adHeadline2`	`ad_group_ad.ad.expanded_text_ad.headline2`
`adHeadline3`	`ad_group_ad.ad.expanded_text_ad.headline3`
`adId`	`ad_group_ad.ad.id`
`adLabels`	`ad_group_ad.labels`
`adLandingPage`	`ad_group_ad.ad.final_urls`
`adPathField1`	`ad_group_ad.ad.{ad type}.path1`⁴
`adPathField2`	`ad_group_ad.ad.{ad type}.path2`⁴
`adPromotionLine`	行為變更
`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_conversions`⁵
`adWordsConversionValue`	`metrics.client_account_conversions_value`⁵
`adWordsViewThroughConversions`	`metrics.client_account_view_through_conversions`⁵
`agency`	查看帳戶管理
`agencyId`	請參閱帳戶管理
`ageTargetAgeRange`	`ad_group_criterion.age_range.type`
`ageTargetBidModifier`	`ad_group_criterion.bid_modifier`
`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_criterion.creation_time`
`ctr`	`metrics.ctr`^{5 個}
`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`^{5 個}
`dfaTransactions`	`metrics.all_conversions_by_conversion_date` - `metrics.cross_device_conversions_by_conversion_date`⁵
`dfaTransactionsCrossEnv`	`metrics.all_conversions_by_conversion_date`⁵
`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.impressions`^{5 個}
`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)`⁸
`excludedCountryTargets`	`campaign_criterion.location.geo_target_constant (filtering with campaign_criterion.negative)`⁸
`excludedMetroTargets`	`campaign_criterion.location.geo_target_constant (filtering with campaign_criterion.negative)`⁸
`excludedProvinceTargets`	`campaign_criterion.location.geo_target_constant (filtering with campaign_criterion.negative)`⁸
`feedId`	`asset_set.id`
`feedItemId`	`asset.id`
`feedType`	`asset.type`
`floodlightActivity`	`segments.conversion_action_name`
`floodlightActivityId`	使用 `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.name`⁹
`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}.description1`¹^,⁹
`adDescription2`	`ad_group_ad.ad.{ad type}.description2`¹^,⁹
`adDisplayUrl`	`ad_group_ad.ad.display_url`⁹
`adGroup`	`ad_group.name`
`adGroupId`	`ad_group.id`
`adGroupStatus`	`ad_group.status`
`adHeadline`	`ad_group_ad.ad.{ad type}.headline`³^,⁹
`adHeadline2`	`ad_group_ad.ad.expanded_text_ad.headline2`⁹
`adHeadline3`	`ad_group_ad.ad.expanded_text_ad.headline3`⁹
`adId`	`ad_group_ad.ad.id`⁹
`adLandingPage`	`ad_group_ad.ad.final_urls`⁹
`adPromotionLine`	行為變更
`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`	行為變更
`bidStrategyInherited`	行為變更
`bingKeywordParam2`	行為變更
`bingKeywordParam3`	行為變更
`campaign`	`campaign.name`
`campaignId`	`campaign.id`
`campaignStatus`	`campaign.status`
`clicks`	`metrics.clicks`⁷
`cost`	`metrics.cost_micros`⁷
`creationTimestamp`	`ad_group_criterion.creation_time`
`ctr`	`metrics.ctr`⁷
`date`	`segments.date`
`deviceSegment`	`segments.device`
`dfaActions`	`metrics.all_conversions_by_conversion_date` - `metrics.cross_device_conversions_by_conversion_date`⁷
`dfaActionsCrossEnv`	`metrics.all_conversions_by_conversion_date`⁷
`dfaRevenue`	`metrics.all_conversions_value_by_conversion_date` - `metrics.cross_device_conversions_value_by_conversion_date`⁷
`dfaRevenueCrossEnv`	`metrics.all_conversions_value_by_conversion_date`⁷
`dfaTransactions`	`metrics.all_conversions_by_conversion_date` - `metrics.cross_device_conversions_by_conversion_date`⁷
`dfaTransactionsCrossEnv`	`metrics.all_conversions_by_conversion_date`⁷
`dfaWeightedActions`	行為變更
`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.impressions`⁷
`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_score`⁷
`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.visits`⁷。
`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)`⁸
`negativeAdGroupKeywordMatchType`	`ad_group_criterion.keyword.match_type (filtering with ad_group_criterion.negative)`⁸
`negativeAdGroupKeywordText`	`ad_group_criterion.keyword.text (filtering with ad_group_criterion.negative)`⁸
`status`	`ad_group_criterion.status (filtering with ad_group_criterion.negative)`⁸

NegativeAdGroupTarget 報表

`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)`⁸
`campaign`	`campaign.name`
`campaignId`	`campaign.id`
`campaignStatus`	`campaign.status`
`creationTimestamp`	`ad_group_criterion.creation_time`
`dynamicSearchAdsTargetConditions`	`ad_group_criterion.webpage.conditions (filtering with ad_group_criterion.negative)`⁸
`engineRemarketingList`	`ad_group_criterion.user_list.user_list user_list.name (filtering with ad_group_criterion.negative)`⁸
`genderTargetGenderType`	`ad_group_criterion.gender.type (filtering with ad_group_criterion.negative)`⁸
`lastModifiedTimestamp`	`ad_group_criterion.last_modified_time`
`locationTargetName`	`ad_group_criterion.location.geo_target_constant (filtering with ad_group_criterion.negative)`⁸
`negativeAdGroupTargetId`	`ad_group_criterion.criterion_id (filtering with ad_group_criterion.negative)`⁸
`status`	`ad_group_criterion.status (filtering with ad_group_criterion.negative)`⁸

「NegativeCampaignKeyword」報表

`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)`⁸
`negativeCampaignKeywordMatchType`	`campaign_criterion.keyword.match_type (filtering with campaign_criterion.negative)`⁸
`negativeCampaignKeywordText`	`campaign_criterion.keyword.text (filtering with campaign_criterion.negative)`⁸
`status`	`campaign_criterion.status (filtering with campaign_criterion.negative)`⁸

「NegativeCampaignTarget」報表

`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)`⁸
`campaign`	`campaign.name`
`campaignId`	`campaign.id`
`campaignStatus`	`campaign.status`
`creationTimestamp`	行為變更
`dynamicSearchAdsTargetConditions`	`campaign_criterion.webpage.conditions (filtering with campaign_criterion.negative)`⁸
`engineRemarketingList`	`campaign_criterion.user_list.user_list user_list.name (filtering with campaign_criterion.negative)`⁸
`genderTargetGenderType`	`campaign_criterion.gender.type (filtering with campaign_criterion.negative)`⁸
`lastModifiedTimestamp`	`campaign_criterion.last_modified_time`
`locationTargetName`	`campaign_criterion.location.geo_target_constant campaign_criterion.negative`⁸
`negativeCampaignTargetId`	`campaign_criterion.criterion_id (filtering with campaign_criterion.negative)`⁸
`status`	`campaign_criterion.status (filtering with campaign_criterion.negative)`⁸

PaidAndOrganic 報表

`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_level1`¹⁰
`productCategoryLevel2`	`segments.product_bidding_category_level2` `segments.product_sold_bidding_category_level2`
`productCategoryLevel3`	`segments.product_bidding_category_level3` `segments.product_sold_bidding_category_level3`
`productCategoryLevel4`	`segments.product_bidding_category_level4` `segments.product_sold_bidding_category_level4`
`productCategoryLevel5`	`segments.product_bidding_category_level5` `segments.product_sold_bidding_category_level5`
`productChannel`	`segments.product_channel` `segments.product_sold_channel`
`productChannelExclusivity`	`segments.product_channel_exclusivity` `segments.product_sold_channel_exclusivity`
`productColor`	行為變更
`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.name`⁹
`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`

附註

{ad type} 可以是 text_ad、expanded_text_ad 或 expanded_dynamic_search_ad。
使用 ad_group_ad.engine_id 為 Search Ads 360 帳戶 (例如Microsoft、Yahoo Japan 等)，而非 Search Ads 360 帳戶則為 ad_group_ad.ad.id。
{ad type} 可以是 text_ad 或 expanded_text_ad。
{ad type} 可以是 expanded_text_ad 或 responsive_search_ad。
在 FROM 子句中使用適當資源查詢指標 (例如gender_view 代表性別條件。請參閱報表對應。
在 FROM 子句中使用適當資源查詢指標 (例如campaign_asset：適用於在廣告活動層級建立的素材資源)。請參閱「擷取素材資源屬性和指標」。
在 FROM 子句中使用 keyword_view 查詢指標。
在 WHERE 子句中使用 negative=true 進行篩選。例如：SELECT campaign_criterion.keyword.match_type, campaign_criterion.keyword.text FROM campaign_criterion WHERE campaign_criterion.negative = true
直接查詢 ad_group_ad 資源中的 ad_group_ad 欄位。接著，請查詢適當資源的其他欄位 (例如keyword_view)，並使用 ad_id (適用於 conversion 和 visit) 或 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)'
使用 product 區隔來識別宣傳的產品，並使用 product_sold 區隔來識別售出的產品

Search Ads 360 Reporting API 的欄位對應 透過集合功能整理內容 你可以依據偏好儲存及分類內容。