Transformação de relatório do Search Ads 360 (descontinuado)

Mapeamento de tabelas em relatórios do Search Ads 360

Quando os relatórios do Search Ads 360 (anteriormente conhecidos como Doubleclick Search) são transferidos para o BigQuery, eles são transformados nas tabelas e visualizações do BigQuery a seguir.

Quando você vê as tabelas e visualizações no BigQuery, o valor de advertiser_id é seu ID de anunciante do Search Ads 360.

Relatórios do Google Search Ads 360 Tabelas do BigQuery Visualizações do BigQuery
Relatório account 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
Relatório ad p_Ad_advertiser_id
p_AdDeviceStats_advertiser_id
p_AdFloodlightAndDeviceStats_advertiser_id
Ad_advertiser_id
AdDeviceStats_advertiser_id
AdFloodlightAndDeviceStats_advertiser_id
Relatório adGroup 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
Relatório adGroupTarget p_AdGroupTarget_advertiser_id
p_AdGroupTargetDeviceStats_advertiser_id
p_AdGroupTargetFloodlightAndDeviceStats_advertiser_id
AdGroupTarget_advertiser_id
AdGroupTargetDeviceStats_advertiser_id
AdGroupTargetFloodlightAndDeviceStats_advertiser_id
Relatório bidStrategy p_BidStrategy_advertiser_id
p_BidStrategyStats_advertiser_id
BidStrategy_advertiser_id
BidStrategyStats_advertiser_id
Relatório campaign p_Campaign_advertiser_id
p_CampaignDeviceStats_advertiser_id
p_CampaignFloodlightAndFeedItemStats_advertiser_id
p_CampaignFloodtlightAndDeviceStats_advertiser_id (Deprecating)
p_CampaignFloodlightAndDeviceStats_advertiser_id
p_CampaignStats_advertiser_id
p_CampaignFeedItemStats_advertiser_id
Campaign_advertiser_id
CampaignDeviceStats_advertiser_id
CampaignFloodlightAndFeedItemStats_advertiser_id
CampaignFloodtlightAndDeviceStats_advertiser_id (Deprecating)
CampaignFloodlightAndDeviceStats_advertiser_id
CampaignStats_advertiser_id
CampaignFeedItemStats_advertiser_id
Relatório campaignTarget p_CampaignTarget_advertiser_id
p_CampaignTargetDeviceStats_advertiser_id
p_CampaignTargetFloodlightAndDeviceStats_advertiser_id
CampaignTarget_advertiser_id
CampaignTargetDeviceStats_advertiser_id
CampaignTargetFloodlightAndDeviceStats_advertiser_id
Relatório conversion p_Conversion_advertiser_id
Conversion_advertiser_id
Relatório feedItem p_FeedItem_advertiser_id
p_FeedItemStats_advertiser_id
p_FeedItemFloodlightStats_advertiser_id
FeedItem_advertiser_id
FeedItemStats_advertiser_id
FeedItemFloodlightStats_advertiser_id
Relatório floodlightActivity p_FloodlightActivity_advertiser_id
FloodlightActivity_advertiser_id
Relatório keyword 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
Relatório negativeAdGroupKeyword p_NegativeAdGroupKeyword_advertiser_id
NegativeAdGroupKeyword_advertiser_id
Relatório negativeAdGroupTarget p_NegativeAdGroupTarget_advertiser_id
NegativeAdGroupTarget_advertiser_id
Relatório negativeCampaignKeyword p_NegativeCampaignKeyword_advertiser_id
NegativeCampaignKeyword_advertiser_id
Relatório negativeCampaignTarget p_NegativeCampaignTarget_advertiser_id
NegativeCampaignTarget_advertiser_id
Relatório productAdvertised p_ProductAdvertised_advertiser_id
p_ProductAdvertisedDeviceStats_advertiser_id
p_ProductAdvertisedFloodlightAndDeviceStats_advertiser_id
ProductAdvertised_advertiser_id
ProductAdvertisedDeviceStats_advertiser_id
ProductAdvertisedFloodlightAndDeviceStats_advertiser_id
Relatório productGroup p_ProductGroup_advertiser_id
p_ProductGroupStats_advertiser_id
ProductGroup_advertiser_id
ProductGroupStats_advertiser_id
Relatório productLeadAndCrossSell p_ProductLeadAndCrossSellFloodlightStats_advertiser_id
ProductLeadAndCrossSellFloodlightStats_advertiser_id
Relatório visit p_Visit_advertiser_id
Visit_advertiser_id

Mapeamento de colunas em relatórios de anúncios de pesquisa

As tabelas do BigQuery criadas por uma transferência do Search Ads 360 têm as colunas ou campos a seguir:

Tabelas do BigQuery Colunas
Relatório account: tabela Account account
accountCurrencyCode
accountEngineId
accountId
accountTimeZone
accountType
advertiserId
agencyId
creationTimestamp
lastModifiedTimestamp
status
Relatório account: tabela AccountDeviceStats accountEngineId
accountId
adWordsConversionValue
adWordsConversions
adWordsViewThroughConversions
advertiserId
agencyId
avgCpc
avgCpm
avgPos
clicks
cost
ctr
date
deviceSegment
impr
visits
Relatório account: tabela AccountFloodlightAndDeviceStats accountEngineId
accountId
advertiserId
agencyId
date
deviceSegment
dfaActions
dfaRevenue
dfaTransactions
dfaWeightedActions
floodlightActivityId
floodlightGroupId
Relatório account: tabela AccountStats accountEngineId
accountId
advertiserId
agencyId
date
displayBudgetLostImpressionShare
displayImpressionShare
displayRankLostImpressionShare
qualityScoreAvg
searchBudgetLostImpressionShare
searchImpressionShare
searchRankLostImpressionShare
topOfPageBidAvg
Relatório ad: tabela Ad accountId
ad
adDescription1
adDescription2
adDisplayUrl
adEngineId
adGroupId
adHeadline
adHeadline2
adId
adLabels
adLandingPage
adPromotionLine
adType
advertiserId
agencyId
campaignId
creationTimestamp
effectiveLabels
engineStatus
isUnattributedAd
lastModifiedTimestamp
status
Relatório ad: tabela AdDeviceStats accountId
adEngineId
adGroupId
adId
adWordsConversionValue
adWordsConversions
adWordsViewThroughConversions
advertiserId
agencyId
avgCpc
avgCpm
avgPos
campaignId
clicks
cost
ctr
date
deviceSegment
impr
visits
Relatório ad: tabela AdFloodlightAndDeviceStats accountId
adEngineId
adGroupId
adId
advertiserId
agencyId
campaignId
date
deviceSegment
dfaActions
dfaRevenue
dfaTransactions
dfaWeightedActions
floodlightActivityId
floodlightGroupId
Relatório adGroup: tabela 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
Relatório adGroup: tabela AdGroupDeviceStats accountId
adGroupEngineId
adGroupId
adWordsConversionValue
adWordsConversions
adWordsViewThroughConversions
advertiserId
agencyId
avgCpc
avgCpm
avgPos
campaignId
clicks
cost
ctr
date
deviceSegment
effectiveBidStrategyId
impr
visits
Relatório adGroup: tabela 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
Relatório adGroup: tabela AdGroupFloodlightAndDeviceStats accountId
adGroupEngineId
adGroupId
advertiserId
agencyId
campaignId
date
deviceSegment
dfaActions
dfaRevenue
dfaTransactions
dfaWeightedActions
effectiveBidStrategyId
floodlightActivityId
floodlightGroupId
Relatório adGroup: tabela AdGroupFloodlightAndFeedItemStats accountId
adGroupEngineId
adGroupId
advertiserId
agencyId
campaignId
date
dfaActions
dfaRevenue
dfaTransactions
dfaWeightedActions
effectiveBidStrategyId
feedId
feedItemId
feedType
floodlightActivityId
floodlightGroupId
Relatório adGroup: tabela AdGroupStats accountId
adGroupEngineId
adGroupId
advertiserId
agencyId
campaignId
date
displayImpressionShare
displayRankLostImpressionShare
effectiveBidStrategyId
qualityScoreAvg
searchImpressionShare
searchRankLostImpressionShare
topOfPageBidAvg
Relatório adGroupTarget: tabela 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
Relatório adGroupTarget: tabela 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
Relatório adGroupTarget: tabela 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
Relatório advertiser: tabela Advertiser advertiser
advertiserCurrencyCode
advertiserId
agency
agencyId
creationTimestamp
dfaAdvertiserId
dfaNetworkId
dfaNetworkTimeZone
lastModifiedTimestamp
status
Relatório advertiser: tabela AdvertiserDeviceStats adWordsConversionValue
adWordsConversions
adWordsViewThroughConversions
advertiserId
agencyId
avgCpc
avgCpm
avgPos
clicks
cost
ctr
date
deviceSegment
dfaAdvertiserId
dfaNetworkId
impr
visits
Relatório advertiser: tabela AdvertiserFloodlightAndDeviceStats advertiserId
agencyId
date
deviceSegment
dfaActions
dfaAdvertiserId
dfaNetworkId
dfaRevenue
dfaTransactions
dfaWeightedActions
floodlightActivityId
floodlightGroupId
Relatório advertiser: tabela AdvertiserStats advertiserId
agencyId
date
dfaAdvertiserId
dfaNetworkId
displayBudgetLostImpressionShare
displayImpressionShare
displayRankLostImpressionShare
qualityScoreAvg
searchBudgetLostImpressionShare
searchImpressionShare
searchRankLostImpressionShare
topOfPageBidAvg
Relatório bidStrategy: tabela BidStrategy advertiserId
agencyId
bidStrategy
bidStrategyGoal
bidStrategyId
bidStrategyMaxBid
bidStrategyMinBid
cpaTarget
creationTimestamp
ersTarget
floodlightActivityTargetIds
floodlightOptimizationEnabled
highPosition
lastModifiedTimestamp
lowPosition
monthlySpendTarget
roasTarget
status
Relatório bidStrategy: tabela BidStrategyStats adWordsConversionValue
adWordsConversions
adWordsViewThroughConversions
advertiserId
agencyId
avgCpc
avgCpm
avgPos
bidStrategyId
clicks
cost
ctr
date
dfaActions
dfaRevenue
dfaTransactions
dfaWeightedActions
impr
visits
Relatório campaign: tabela 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
Relatório campaign: tabela CampaignDeviceStats accountId
adWordsConversionValue
adWordsConversions
adWordsViewThroughConversions
advertiserId
agencyId
avgCpc
avgCpm
avgPos
campaignEngineId
campaignId
clicks
cost
ctr
date
deviceSegment
effectiveBidStrategyId
impr
visits
Relatório campaign: tabela CampaignFeedItemStats accountId
adWordsConversionValue
adWordsConversions
adWordsViewThroughConversions
advertiserId
agencyId
avgCpc
avgCpm
avgPos
campaignEngineId
campaignId
clicks
clicksWithFeedItemShowing
cost
costWithFeedItemShowing
ctr
date
effectiveBidStrategyId
feedId
feedItemId
feedType
impr
visits
Relatório campaign: tabela CampaignFloodlightAndDeviceStats accountId
advertiserId
agencyId
campaignEngineId
campaignId
date
deviceSegment
dfaActions
dfaRevenue
dfaTransactions
dfaWeightedActions
effectiveBidStrategyId
floodlightActivityId
floodlightGroupId
Relatório campaign: tabela CampaignFloodlightAndFeedItemStats accountId
advertiserId
agencyId
campaignEngineId
campaignId
date
dfaActions
dfaRevenue
dfaTransactions
dfaWeightedActions
effectiveBidStrategyId
feedId
feedItemId
feedType
floodlightActivityId
floodlightGroupId
Relatório campaign: tabela CampaignFloodtlightAndDeviceStats accountId
advertiserId
agencyId
campaignEngineId
campaignId
date
deviceSegment
dfaActions
dfaRevenue
dfaTransactions
dfaWeightedActions
effectiveBidStrategyId
floodlightActivityId
floodlightGroupId
Relatório campaign: tabela 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
Relatório campaignTarget: tabela CampaignTarget accountId
advertiserId
agencyId
campaignId
campaignTargetId
creationTimestamp
engineRemarketingList
engineRemarketingListBidModifier
lastModifiedTimestamp
locationTargetBidModifier
locationTargetName
status
Relatório campaignTarget: tabela CampaignTargetDeviceStats accountId
adWordsConversionValue
adWordsConversions
adWordsViewThroughConversions
advertiserId
agencyId
avgCpc
avgCpm
avgPos
campaignId
campaignTargetId
clicks
cost
ctr
date
deviceSegment
impr
visits
Relatório campaignTarget: tabela CampaignTargetFloodlightAndDeviceStats accountId
advertiserId
agencyId
campaignId
campaignTargetId
date
deviceSegment
dfaActions
dfaRevenue
dfaTransactions
dfaWeightedActions
floodlightActivityId
floodlightGroupId
Relatório conversion: tabela 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
Relatório feedItem: tabela FeedItem accountId
advertiserId
agencyId
creationTimestamp
engineStatus
feedId
feedItemId
lastModifiedTimestamp
locationBusinessName
locationCategory
locationDetails
sitelinkClickserverUrl
sitelinkDescription1
sitelinkDescription2
sitelinkDisplayText
sitelinkLandingPageUrl
status
Relatório feedItem: tabela FeedItemFloodlightStats accountId
advertiserId
agencyId
date
dfaActions
dfaRevenue
dfaTransactions
dfaWeightedActions
feedId
feedItemId
floodlightActivityId
floodlightGroupId
Relatório feedItem: tabela FeedItemStats accountId
adWordsConversionValue
adWordsConversions
adWordsViewThroughConversions
advertiserId
agencyId
avgCpc
avgCpm
avgPos
clicks
clicksWithFeedItemShowing
cost
costWithFeedItemShowing
ctr
date
dfaActions
dfaRevenue
dfaTransactions
dfaWeightedActions
feedId
feedItemId
impr
visits
Relatório floodlightActivity: tabela FloodlightActivity advertiserId
agencyId
creationTimestamp
floodlightActivity
floodlightActivityId
floodlightActivityTag
floodlightConfigurationId
floodlightGroup
floodlightGroupConversionType
floodlightGroupId
floodlightGroupTag
lastModifiedTimestamp
status
Relatório keyword: tabela 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
Relatório keyword: tabela KeywordDeviceStats accountId
adGroupId
adId
adWordsConversionValue
adWordsConversions
adWordsViewThroughConversions
advertiserId
agencyId
avgCpc
avgCpm
avgPos
campaignId
clicks
cost
ctr
date
deviceSegment
effectiveBidStrategyId
impr
keywordEngineId
keywordId
visits
Relatório keyword: tabela KeywordFloodlightAndDeviceStats accountId
adGroupId
adId
advertiserId
agencyId
campaignId
date
deviceSegment
dfaActions
dfaRevenue
dfaTransactions
dfaWeightedActions
effectiveBidStrategyId
floodlightActivityId
floodlightGroupId
keywordEngineId
keywordId
Relatório keyword: tabela KeywordStats accountId
adGroupId
advertiserId
agencyId
campaignId
effectiveBidStrategyId
keywordEngineId
keywordId
qualityScoreAvg
topOfPageBidAvg
Relatório negativeAdGroupKeyword: tabela NegativeAdGroupKeyword accountId
adGroupId
advertiserId
agencyId
campaignId
creationTimestamp
engineStatus
lastModifiedTimestamp
negativeAdGroupKeywordId
negativeAdGroupKeywordMatchType
negativeAdGroupKeywordText
status
Relatório negativeAdGroupTarget: tabela NegativeAdGroupTarget accountId
adGroupId
advertiserId
ageTargetAgeRange
agencyId
campaignId
creationTimestamp
dynamicSearchAdsTargetConditions
engineRemarketingList
genderTargetGenderType
lastModifiedTimestamp
locationTargetName
negativeAdGroupTargetId
status
Relatório negativeCampaignKeyword: tabela NegativeCampaignKeyword accountId
advertiserId
agencyId
campaignId
creationTimestamp
engineStatus
lastModifiedTimestamp
negativeCampaignKeywordId
negativeCampaignKeywordMatchType
negativeCampaignKeywordText
status
Relatório negativeCampaignTarget: tabela NegativeCampaignTarget accountId
advertiserId
ageTargetAgeRange
agencyId
campaignId
creationTimestamp
dynamicSearchAdsTargetConditions
engineRemarketingList
genderTargetGenderType
lastModifiedTimestamp
locationTargetName
negativeCampaignTargetId
status
Relatório productAdvertised: tabela 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
Relatório productAdvertised: tabela ProductAdvertisedDeviceStats adWordsConversionValue
adWordsConversions
adWordsViewThroughConversions
advertiserId
agencyId
avgCpc
avgCpm
avgPos
clicks
cost
ctr
date
deviceSegment
impr
productId
visits
Relatório productAdvertised: tabela ProductAdvertisedFloodlightAndDeviceStats accountId
adGroupId
advertiserId
agencyId
campaignId
date
deviceSegment
dfaActions
dfaRevenue
dfaTransactions
dfaWeightedActions
floodlightActivityId
floodlightGroupId
productId
Relatório productGroup: tabela ProductGroup accountId
adGroupId
advertiserId
agencyId
bidStrategyInherited
campaignId
creationTimestamp
effectiveBidStrategy
effectiveBidStrategyId
effectiveLabels
effectiveProductGroupMaxCpc
engineStatus
lastModifiedTimestamp
productGroup
productGroupClickserverUrl
productGroupId
productGroupLandingPage
productGroupMaxBid
productGroupMaxCpc
productGroupMinBid
productGroupPartitionType
status
Relatório productGroup: tabela ProductGroupStats accountId
adGroupId
adWordsConversionValue
adWordsConversions
adWordsViewThroughConversions
advertiserId
agencyId
avgCpc
avgCpm
avgPos
campaignId
clicks
cost
ctr
date
dfaActions
dfaRevenue
dfaTransactions
dfaWeightedActions
effectiveBidStrategyId
impr
productGroupId
visits
Relatório productLeadAndCrossSell: tabela 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
Relatório visit: tabela 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

Tabelas de correspondências do Search Ads 360

As tabelas de correspondências do Search Ads 360 são tabelas que contêm apenas campos de atributos (campos que contêm configurações ou outros dados fixos) e que são definidas para que os usuários consultem as informações de estrutura da conta.

.

As tabelas de correspondências do Search Ads 360 incluem os seguinte:

  • Conta
  • Ad
  • Advertiser
  • AdGroup
  • AdGroupTarget
  • BidStrategy
  • Campaign
  • CampaignTarget
  • FeedItem
  • FloodlightActivity
  • Keyword
  • NegativeAdGroupKeyword
  • NegativeAdGroupTarget
  • NegativeCampaignKeyword
  • NegativeCampaignTarget
  • ProductAdvertised
  • ProductGroup
  • ProductLeadAndCrossSellFloodlightStats