Search Ads 360 报告转换

Search Ads 360 报告的表映射

当 Search Ads 360(以前称为 Doubleclick Search)报告转移到 BigQuery 时,报告将转换为以下 BigQuery 表和视图。

当您在 BigQuery 中查看表和视图时,advertiser_id 的值是您的 Search Ads 360 广告客户 ID。

Google Search Ads 360 报告 BigQuery 表 BigQuery 视图
帐号报告 p_Account_advertiser_id
p_AccountDeviceStats_advertiser_id
p_AccountFloodlightAndDeviceStats_advertiser_id
p_AccountStats_advertiser_id
Account_advertiser_id
AccountDeviceStats_advertiser_id
AccountFloodlightAndDeviceStats_advertiser_id
AccountStats_advertiser_id
广告报告 p_Ad_advertiser_id
p_AdDeviceStats_advertiser_id
p_AdFloodlightAndDeviceStats_advertiser_id
Ad_advertiser_id
AdDeviceStats_advertiser_id
AdFloodlightAndDeviceStats_advertiser_id
广告组报告 p_AdGroup_advertiser_id
p_AdGroupDeviceStats_advertiser_id
p_AdGroupFloodlightAndFeedItemStats_advertiser_id
p_AdGroupFloodlightAndDeviceStats_advertiser_id
p_AdGroupStats_advertiser_id
p_AdGroupFeedItemStats_advertiser_id
AdGroup_advertiser_id
AdGroupDeviceStats_advertiser_id
AdGroupFloodlightAndFeedItemStats_advertiser_id
AdGroupFloodlightAndDeviceStats_advertiser_id
AdGroupStats_advertiser_id
AdGroupFeedItemStats_advertiser_id
adGroupTarget 报告 p_AdGroupTarget_advertiser_id
p_AdGroupTargetDeviceStats_advertiser_id
p_AdGroupTargetFloodlightAndDeviceStats_advertiser_id
AdGroupTarget_advertiser_id
AdGroupTargetDeviceStats_advertiser_id
AdGroupTargetFloodlightAndDeviceStats_advertiser_id
bidStrategy 报告 p_BidStrategy_advertiser_id
p_BidStrategyStats_advertiser_id
BidStrategy_advertiser_id
BidStrategyStats_advertiser_id
广告系列报告 p_Campaign_advertiser_id
p_CampaignDeviceStats_advertiser_id
p_CampaignFloodlightAndFeedItemStats_advertiser_id
p_CampaignFloodtlightAndDeviceStats_advertiser_id(即将弃用)
p_CampaignFloodlightAndDeviceStats_advertiser_id
p_CampaignStats_advertiser_id
p_CampaignFeedItemStats_advertiser_id
Campaign_advertiser_id
CampaignDeviceStats_advertiser_id
CampaignFloodlightAndFeedItemStats_advertiser_id
CampaignFloodtlightAndDeviceStats_advertiser_id(即将弃用)
CampaignFloodlightAndDeviceStats_advertiser_id
CampaignStats_advertiser_id
CampaignFeedItemStats_advertiser_id
campaignTarget 报告 p_CampaignTarget_advertiser_id
p_CampaignTargetDeviceStats_advertiser_id
p_CampaignTargetFloodlightAndDeviceStats_advertiser_id
CampaignTarget_advertiser_id
CampaignTargetDeviceStats_advertiser_id
CampaignTargetFloodlightAndDeviceStats_advertiser_id
转化报告 p_Conversion_advertiser_id
Conversion_advertiser_id
feedItem 报告 p_FeedItem_advertiser_id
p_FeedItemStats_advertiser_id
p_FeedItemFloodlightStats_advertiser_id
FeedItem_advertiser_id
FeedItemStats_advertiser_id
FeedItemFloodlightStats_advertiser_id
floodlightActivity 报告 p_FloodlightActivity_advertiser_id
FloodlightActivity_advertiser_id
关键字报告 p_Keyword_advertiser_id
p_KeywordDeviceStats_advertiser_id
p_KeywordFloodlightAndDeviceStats_advertiser_id
p_KeywordStats_advertiser_id
Keyword_advertiser_id
KeywordDeviceStats_advertiser_id
KeywordFloodlightAndDeviceStats_advertiser_id
KeywordStats_advertiser_id
negativeAdGroupKeyword 报告 p_NegativeAdGroupKeyword_advertiser_id
NegativeAdGroupKeyword_advertiser_id
negativeAdGroupTarget 报告 p_NegativeAdGroupTarget_advertiser_id
NegativeAdGroupTarget_advertiser_id
negativeCampaignKeyword 报告 p_NegativeCampaignKeyword_advertiser_id
NegativeCampaignKeyword_advertiser_id
negativeCampaignTarget 报告 p_NegativeCampaignTarget_advertiser_id
NegativeCampaignTarget_advertiser_id
productAdvertised 报告 p_ProductAdvertised_advertiser_id
p_ProductAdvertisedDeviceStats_advertiser_id
p_ProductAdvertisedFloodlightAndDeviceStats_advertiser_id
ProductAdvertised_advertiser_id
ProductAdvertisedDeviceStats_advertiser_id
ProductAdvertisedFloodlightAndDeviceStats_advertiser_id
productGroup 报告 p_ProductGroup_advertiser_id
p_ProductGroupStats_advertiser_id
ProductGroup_advertiser_id
ProductGroupStats_advertiser_id
productLeadAndCrossSell 报告 p_ProductLeadAndCrossSellFloodlightStats_advertiser_id
ProductLeadAndCrossSellFloodlightStats_advertiser_id
访问报告 p_Visit_advertiser_id
Visit_advertiser_id

Google Ads 报告的列映射

Search Ads 360 转移作业创建的 BigQuery 表包含以下列(字段):

BigQuery 表
帐号报告:Account 表 account
accountCurrencyCode accountEngineId accountId accountTimeZone accountType advertiserId agencyId creationTimestamp lastModifiedTimestamp status
帐号报告:AccountDeviceStats 表 accountEngineId
accountId adWordsConversionValue adWordsConversions adWordsViewThroughConversions advertiserId agencyId avgCpc avgCpm avgPos clicks cost ctr date deviceSegment impr visits
帐号报告:AccountFloodlightAndDeviceStats 表 accountEngineId
accountId advertiserId agencyId date deviceSegment dfaActions dfaRevenue dfaTransactions dfaWeightedActions floodlightActivityId floodlightGroupId
帐号报告:AccountStats 表 accountEngineId
accountId advertiserId agencyId date displayBudgetLostImpressionShare displayImpressionShare displayRankLostImpressionShare qualityScoreAvg searchBudgetLostImpressionShare searchImpressionShare searchRankLostImpressionShare topOfPageBidAvg
广告报告:Ad 表 accountId
ad adDescription1 adDescription2 adDisplayUrl adEngineId adGroupId adHeadline adHeadline2 adId adLabels adLandingPage adPromotionLine adType advertiserId agencyId campaignId creationTimestamp effectiveLabels engineStatus isUnattributedAd lastModifiedTimestamp status
广告报告:AdDeviceStats 表 accountId
adEngineId adGroupId adId adWordsConversionValue adWordsConversions adWordsViewThroughConversions advertiserId agencyId avgCpc avgCpm avgPos campaignId clicks cost ctr date deviceSegment impr visits
广告报告:AdFloodlightAndDeviceStats 表 accountId
adEngineId adGroupId adId advertiserId agencyId campaignId date deviceSegment dfaActions dfaRevenue dfaTransactions dfaWeightedActions floodlightActivityId floodlightGroupId
广告组报告:AdGroup 表 accountId
adGroup adGroupBroadMaxCpc adGroupContentMaxCpc adGroupEndDate adGroupEngineId adGroupExactMaxCpc adGroupId adGroupLabels adGroupMobileBidAdjustment adGroupPhraseMaxCpc adGroupSearchMaxCpc adGroupStartDate advertiserId agencyId bidStrategyInherited bingAdsAdDistributions bingAdsLanguage campaignId cityTargets countryTargets creationTimestamp deviceTargets effectiveBidStrategyId effectiveCityTargets effectiveCountryTargets effectiveDeviceTargets effectiveLabels effectiveMetroTargets effectiveProvinceTargets engineRemarketingListTargetAll engineStatus lastModifiedTimestamp metroTargets provinceTargets status
广告组报告:AdGroupDeviceStats 表 accountId
adGroupEngineId adGroupId adWordsConversionValue adWordsConversions adWordsViewThroughConversions advertiserId agencyId avgCpc avgCpm avgPos campaignId clicks cost ctr date deviceSegment effectiveBidStrategyId impr visits
广告组报告:AdGroupFeedItemStats 表 accountId
adGroupEngineId adGroupId adWordsConversionValue adWordsConversions adWordsViewThroughConversions advertiserId agencyId avgCpc avgCpm avgPos campaignId clicks clicksWithFeedItemShowing cost costWithFeedItemShowing ctr date effectiveBidStrategyId feedId feedItemId feedType impr visits
广告组报告:AdGroupFloodlightAndDeviceStats 表 accountId
adGroupEngineId adGroupId advertiserId agencyId campaignId date deviceSegment dfaActions dfaRevenue dfaTransactions dfaWeightedActions effectiveBidStrategyId floodlightActivityId floodlightGroupId
广告组报告:AdGroupFloodlightAndFeedItemStats 表 accountId
adGroupEngineId adGroupId advertiserId agencyId campaignId date dfaActions dfaRevenue dfaTransactions dfaWeightedActions effectiveBidStrategyId feedId feedItemId feedType floodlightActivityId floodlightGroupId
广告组报告:AdGroupStats 表 accountId
adGroupEngineId adGroupId advertiserId agencyId campaignId date displayImpressionShare displayRankLostImpressionShare effectiveBidStrategyId qualityScoreAvg searchImpressionShare searchRankLostImpressionShare topOfPageBidAvg
adGroupTarget 报告:AdGroupTarget 表 account
accountId accountType adGroup adGroupId adGroupStatus adGroupTargetId advertiser advertiserId ageTargetAgeRange ageTargetBidModifier agency agencyId campaign campaignId campaignStatus creationTimestamp dynamicSearchAdsTargetConditions dynamicSearchAdsTargetCoverage dynamicSearchAdsTargetCpcBid dynamicSearchAdsTargetLandingPageUrl engineRemarketingList engineRemarketingListBidModifier genderTargetBidModifier genderTargetGenderType lastModifiedTimestamp locationTargetBidModifier locationTargetName status
adGroupTarget 报告:AdGroupTargetDeviceStats 表 accountId
adGroupId adGroupTargetId adWordsConversionValue adWordsConversions adWordsViewThroughConversions advertiserId ageTargetAgeRange ageTargetBidModifier agencyId avgCpc avgCpm avgPos campaignId clicks cost ctr date deviceSegment dynamicSearchAdsTargetConditions dynamicSearchAdsTargetCoverage dynamicSearchAdsTargetCpcBid dynamicSearchAdsTargetLandingPageUrl engineRemarketingList engineRemarketingListBidModifier genderTargetBidModifier genderTargetGenderType impr locationTargetBidModifier locationTargetName visits
adGroupTarget 报告:AdGroupTargetFloodlightAndDeviceStats 表 accountId
adGroupId adGroupTargetId advertiserId ageTargetAgeRange ageTargetBidModifier agencyId campaignId date deviceSegment dfaActions dfaRevenue dfaTransactions dfaWeightedActions dynamicSearchAdsTargetConditions dynamicSearchAdsTargetCoverage dynamicSearchAdsTargetCpcBid dynamicSearchAdsTargetLandingPageUrl engineRemarketingList engineRemarketingListBidModifier floodlightActivityId floodlightGroupId genderTargetBidModifier genderTargetGenderType locationTargetBidModifier locationTargetName
广告客户报告:Advertiser 表 advertiser
advertiserCurrencyCode advertiserId agency agencyId creationTimestamp dfaAdvertiserId dfaNetworkId dfaNetworkTimeZone lastModifiedTimestamp status
广告客户报告:AdvertiserDeviceStats 表 adWordsConversionValue
adWordsConversions adWordsViewThroughConversions advertiserId agencyId avgCpc avgCpm avgPos clicks cost ctr date deviceSegment dfaAdvertiserId dfaNetworkId impr visits
广告客户报告:AdvertiserFloodlightAndDeviceStats 表 advertiserId
agencyId date deviceSegment dfaActions dfaAdvertiserId dfaNetworkId dfaRevenue dfaTransactions dfaWeightedActions floodlightActivityId floodlightGroupId
广告客户报告:AdvertiserStats 表 advertiserId
agencyId date dfaAdvertiserId dfaNetworkId displayBudgetLostImpressionShare displayImpressionShare displayRankLostImpressionShare qualityScoreAvg searchBudgetLostImpressionShare searchImpressionShare searchRankLostImpressionShare topOfPageBidAvg
bidStrategy 报告:BidStrategy 表 advertiserId
agencyId bidStrategy bidStrategyGoal bidStrategyId bidStrategyMaxBid bidStrategyMinBid cpaTarget creationTimestamp ersTarget floodlightActivityTargetIds floodlightOptimizationEnabled highPosition lastModifiedTimestamp lowPosition monthlySpendTarget roasTarget status
bidStrategy 报告:BidStrategyStats 表 adWordsConversionValue
adWordsConversions adWordsViewThroughConversions advertiserId agencyId avgCpc avgCpm avgPos bidStrategyId clicks cost ctr date dfaActions dfaRevenue dfaTransactions dfaWeightedActions impr visits
广告系列报告:Campaign 表 accountId
adRotation adWordsBidStrategy advertiserId agencyId bidStrategyInherited bingAdsBudgetType campaign campaignEndDate campaignEngineId campaignId campaignLabels campaignMobileBidAdjustment campaignStartDate campaignType cityTargets countryTargets creationTimestamp dailyBudget deliveryMethod deviceTargets effectiveBidStrategyId effectiveCityTargets effectiveCountryTargets effectiveDeviceTargets effectiveLabels effectiveMetroTargets effectiveProvinceTargets engineStatus excludedCityTargets excludedCountryTargets excludedMetroTargets excludedProvinceTargets keywordNearMatchEnabled languageTargets lastModifiedTimestamp metroTargets monthlyBudget networkTarget provinceTargets status yahooGeoTargets yahooJapanBidStrategy
广告系列报告:CampaignDeviceStats 表 accountId
adWordsConversionValue adWordsConversions adWordsViewThroughConversions advertiserId agencyId avgCpc avgCpm avgPos campaignEngineId campaignId clicks cost ctr date deviceSegment effectiveBidStrategyId impr visits
广告系列报告:CampaignFeedItemStats 表 accountId
adWordsConversionValue adWordsConversions adWordsViewThroughConversions advertiserId agencyId avgCpc avgCpm avgPos campaignEngineId campaignId clicks clicksWithFeedItemShowing cost costWithFeedItemShowing ctr date effectiveBidStrategyId feedId feedItemId feedType impr visits
广告系列报告:CampaignFloodlightAndDeviceStats 表 accountId
advertiserId agencyId campaignEngineId campaignId date deviceSegment dfaActions dfaRevenue dfaTransactions dfaWeightedActions effectiveBidStrategyId floodlightActivityId floodlightGroupId
广告系列报告:CampaignFloodlightAndFeedItemStats 表 accountId
advertiserId agencyId campaignEngineId campaignId date dfaActions dfaRevenue dfaTransactions dfaWeightedActions effectiveBidStrategyId feedId feedItemId feedType floodlightActivityId floodlightGroupId
广告系列报告:CampaignFloodtlightAndDeviceStats 表 accountId
advertiserId agencyId campaignEngineId campaignId date deviceSegment dfaActions dfaRevenue dfaTransactions dfaWeightedActions effectiveBidStrategyId floodlightActivityId floodlightGroupId
广告系列报告:CampaignStats 表 accountId
adWordsConversionValue adWordsConversions adWordsViewThroughConversions advertiserId agencyId avgCpc avgCpm avgPos campaignEngineId campaignId clicks cost ctr date displayBudgetLostImpressionShare displayImpressionShare displayRankLostImpressionShare effectiveBidStrategyId impr qualityScoreAvg searchBudgetLostImpressionShare searchImpressionShare searchRankLostImpressionShare topOfPageBidAvg visits
campaignTarget 报告:CampaignTarget 表 accountId
advertiserId agencyId campaignId campaignTargetId creationTimestamp engineRemarketingList engineRemarketingListBidModifier lastModifiedTimestamp locationTargetBidModifier locationTargetName status
campaignTarget 报告:CampaignTargetDeviceStats 表 accountId
adWordsConversionValue adWordsConversions adWordsViewThroughConversions advertiserId agencyId avgCpc avgCpm avgPos campaignId campaignTargetId clicks cost ctr date deviceSegment impr visits
campaignTarget 报告:CampaignTargetFloodlightAndDeviceStats 表 accountId
advertiserId agencyId campaignId campaignTargetId date deviceSegment dfaActions dfaRevenue dfaTransactions dfaWeightedActions floodlightActivityId floodlightGroupId
转化报告:Conversion 表 account
accountId accountType adGroupId adId advertiser advertiserConversionId advertiserId agency agencyId campaignId conversionAttributionType conversionDate conversionId conversionLastModifiedTimestamp conversionQuantity conversionRevenue conversionSearchTerm conversionTimestamp conversionType conversionVisitExternalClickId conversionVisitId conversionVisitTimestamp deviceSegment feedId feedItemId feedType floodlightActivity floodlightActivityId floodlightActivityTag floodlightEventRequestString floodlightGroup floodlightGroupConversionType floodlightGroupId floodlightGroupTag floodlightOrderId floodlightOriginalRevenue floodlightReferrer inventoryAccountId keywordId productChannel productCountry productGroupId productId productLanguage productStoreId productTargetId status
feedItem 报告:FeedItem 表 accountId
advertiserId agencyId creationTimestamp engineStatus feedId feedItemId lastModifiedTimestamp locationBusinessName locationCategory locationDetails sitelinkClickserverUrl sitelinkDescription1 sitelinkDescription2 sitelinkDisplayText sitelinkLandingPageUrl status
feedItem 报告:FeedItemFloodlightStats 表 accountId
advertiserId agencyId date dfaActions dfaRevenue dfaTransactions dfaWeightedActions feedId feedItemId floodlightActivityId floodlightGroupId
feedItem 报告:FeedItemStats 表 accountId
adWordsConversionValue adWordsConversions adWordsViewThroughConversions advertiserId agencyId avgCpc avgCpm avgPos clicks clicksWithFeedItemShowing cost costWithFeedItemShowing ctr date dfaActions dfaRevenue dfaTransactions dfaWeightedActions feedId feedItemId impr visits
floodlightActivity 报告:FloodlightActivity 表 advertiserId
agencyId creationTimestamp floodlightActivity floodlightActivityId floodlightActivityTag floodlightConfigurationId floodlightGroup floodlightGroupConversionType floodlightGroupId floodlightGroupTag lastModifiedTimestamp status
关键字报告:Keyword 表 accountId
adGroupId advertiserId agencyId bidStrategyInherited bingKeywordParam2 bingKeywordParam3 campaignId creationTimestamp effectiveBidStrategyId effectiveKeywordMaxCpc effectiveLabels engineStatus isDisplayKeyword keywordClickserverUrl keywordEngineId keywordId keywordLabels keywordLandingPage keywordMatchType keywordMaxBid keywordMaxCpc keywordMinBid keywordText keywordUrlParams lastModifiedTimestamp qualityScoreCurrent status topOfPageBidCurrent
关键字报告:KeywordDeviceStats 表 accountId
adGroupId adId adWordsConversionValue adWordsConversions adWordsViewThroughConversions advertiserId agencyId avgCpc avgCpm avgPos campaignId clicks cost ctr date deviceSegment effectiveBidStrategyId impr keywordEngineId keywordId visits
关键字报告:KeywordFloodlightAndDeviceStats 表 accountId
adGroupId adId advertiserId agencyId campaignId date deviceSegment dfaActions dfaRevenue dfaTransactions dfaWeightedActions effectiveBidStrategyId floodlightActivityId floodlightGroupId keywordEngineId keywordId
关键字报告:KeywordStats 表 accountId
adGroupId advertiserId agencyId campaignId effectiveBidStrategyId keywordEngineId keywordId qualityScoreAvg topOfPageBidAvg
negativeAdGroupKeyword 报告:NegativeAdGroupKeyword 表 accountId
adGroupId advertiserId agencyId campaignId creationTimestamp engineStatus lastModifiedTimestamp negativeAdGroupKeywordId negativeAdGroupKeywordMatchType negativeAdGroupKeywordText status
negativeAdGroupTarget 报告:NegativeAdGroupTarget 表 accountId
adGroupId advertiserId ageTargetAgeRange agencyId campaignId creationTimestamp dynamicSearchAdsTargetConditions engineRemarketingList genderTargetGenderType lastModifiedTimestamp locationTargetName negativeAdGroupTargetId status
negativeCampaignKeyword 报告:NegativeCampaignKeyword 表 accountId
advertiserId agencyId campaignId creationTimestamp engineStatus lastModifiedTimestamp negativeCampaignKeywordId negativeCampaignKeywordMatchType negativeCampaignKeywordText status
negativeCampaignTarget 报告:NegativeCampaignTarget 表 accountId
advertiserId ageTargetAgeRange agencyId campaignId creationTimestamp dynamicSearchAdsTargetConditions engineRemarketingList genderTargetGenderType lastModifiedTimestamp locationTargetName negativeCampaignTargetId status
productAdvertised 报告:ProductAdvertised 表 advertiserId
agencyId creationTimestamp lastModifiedTimestamp productAgeGroup productAvailability productBrand productCategory productCategoryLevel1 productCategoryLevel2 productCategoryLevel3 productCategoryLevel4 productCategoryLevel5 productChannel productChannelExclusivity productColor productCondition productCostOfGoodsSold productCountry productCustomLabel0 productCustomLabel1 productCustomLabel2 productCustomLabel3 productCustomLabel4 productGender productGtin productId productItemGroupId productLandingPageUrl productLanguage productMaterial productMpn productPattern productPrice productSalePrice productSize productStoreId productTitle productTypeLevel1 productTypeLevel2 productTypeLevel3 productTypeLevel4 productTypeLevel5 status
productAdvertised 报告:ProductAdvertisedDeviceStats 表 adWordsConversionValue
adWordsConversions adWordsViewThroughConversions advertiserId agencyId avgCpc avgCpm avgPos clicks cost ctr date deviceSegment impr productId visits
productAdvertised 报告:ProductAdvertisedFloodlightAndDeviceStats 表 accountId
adGroupId advertiserId agencyId campaignId date deviceSegment dfaActions dfaRevenue dfaTransactions dfaWeightedActions floodlightActivityId floodlightGroupId productId
productGroup 报告:ProductGroup 表 accountId
adGroupId advertiserId agencyId bidStrategyInherited campaignId creationTimestamp effectiveBidStrategy effectiveBidStrategyId effectiveLabels effectiveProductGroupMaxCpc engineStatus lastModifiedTimestamp productGroup productGroupClickserverUrl productGroupId productGroupLandingPage productGroupMaxBid productGroupMaxCpc productGroupMinBid productGroupPartitionType status
productGroup 报告:ProductGroupStats 表 accountId
adGroupId adWordsConversionValue adWordsConversions adWordsViewThroughConversions advertiserId agencyId avgCpc avgCpm avgPos campaignId clicks cost ctr date dfaActions dfaRevenue dfaTransactions dfaWeightedActions effectiveBidStrategyId impr productGroupId visits
productLeadAndCrossSell 报告:ProductLeadAndCrossSellFloodlightStats 表 accountId
adGroupId advertiserId agencyId campaignId crossSellAverageUnitPrice crossSellCostOfGoodsSold crossSellGrossFromUnitsSold crossSellGrossProfitMargin crossSellRevenueFromUnitsSold crossSellUnitsSold date deviceSegment dfaActions dfaRevenue dfaTransactions dfaWeightedActions floodlightActivityId floodlightGroupId leadAverageUnitPrice leadCostOfGoodsSold leadGrossProfitFromUnitsSold leadGrossProfitMargin leadRevenueFromUnitsSold leadUnitsSold productAverageUnitPrice productIdSold productId productRevenueFromUnitsSold productUnitsSold
访问报告:Visit 表 account
accountId accountType adGroupId adId advertiser advertiserId agency agencyId campaignId deviceSegment feedId feedItemId feedType inventoryAccountId keywordId productChannel productCountry productGroupId productId productLanguage productStoreId productTargetId status visitDate visitExternalClickId visitId visitNetworkType visitReferrer visitSearchQuery visitTimestamp