Transformación de informes de Search Ads 360 (obsoleta)

Asignación de tablas para los informes de Search Ads 360

Cuando los informes de Search Ads 360 (antes conocidos como Doubleclick Search) se transfieren a BigQuery, estos se transforman en las siguientes tablas y vistas de BigQuery.

Cuando ves las tablas y vistas en BigQuery, el valor de advertiser_id es tu ID del anunciante de Search Ads 360.

Informes de Search Ads 360 de Google Tablas de BigQuery Vistas de BigQuery
Informe de 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
Informe de ad p_Ad_advertiser_id
p_AdDeviceStats_advertiser_id
p_AdFloodlightAndDeviceStats_advertiser_id
Ad_advertiser_id
AdDeviceStats_advertiser_id
AdFloodlightAndDeviceStats_advertiser_id
Informe de 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
Informe de adGroupTarget p_AdGroupTarget_advertiser_id
p_AdGroupTargetDeviceStats_advertiser_id
p_AdGroupTargetFloodlightAndDeviceStats_advertiser_id
AdGroupTarget_advertiser_id
AdGroupTargetDeviceStats_advertiser_id
AdGroupTargetFloodlightAndDeviceStats_advertiser_id
Informe de bidStrategy p_BidStrategy_advertiser_id
p_BidStrategyStats_advertiser_id
BidStrategy_advertiser_id
BidStrategyStats_advertiser_id
Informe de 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 (Obsoleto)
CampaignFloodlightAndDeviceStats_advertiser_id
CampaignStats_advertiser_id
CampaignFeedItemStats_advertiser_id
Informe de campaignTarget p_CampaignTarget_advertiser_id
p_CampaignTargetDeviceStats_advertiser_id
p_CampaignTargetFloodlightAndDeviceStats_advertiser_id
CampaignTarget_advertiser_id
CampaignTargetDeviceStats_advertiser_id
CampaignTargetFloodlightAndDeviceStats_advertiser_id
Informe de conversion p_Conversion_advertiser_id
Conversion_advertiser_id
Informe de feedItem p_FeedItem_advertiser_id
p_FeedItemStats_advertiser_id
p_FeedItemFloodlightStats_advertiser_id
FeedItem_advertiser_id
FeedItemStats_advertiser_id
FeedItemFloodlightStats_advertiser_id
Informe de floodlightActivity p_FloodlightActivity_advertiser_id
FloodlightActivity_advertiser_id
Informe de 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
Informe de negativeAdGroupKeyword p_NegativeAdGroupKeyword_advertiser_id
NegativeAdGroupKeyword_advertiser_id
Informe de negativeAdGroupTarget p_NegativeAdGroupTarget_advertiser_id
NegativeAdGroupTarget_advertiser_id
Informe de negativeCampaignKeyword p_NegativeCampaignKeyword_advertiser_id
NegativeCampaignKeyword_advertiser_id
Informe de negativeCampaignTarget p_NegativeCampaignTarget_advertiser_id
NegativeCampaignTarget_advertiser_id
Informe de productAdvertised p_ProductAdvertised_advertiser_id
p_ProductAdvertisedDeviceStats_advertiser_id
p_ProductAdvertisedFloodlightAndDeviceStats_advertiser_id
ProductAdvertised_advertiser_id
ProductAdvertisedDeviceStats_advertiser_id
ProductAdvertisedFloodlightAndDeviceStats_advertiser_id
Informe de productGroup p_ProductGroup_advertiser_id
p_ProductGroupStats_advertiser_id
ProductGroup_advertiser_id
ProductGroupStats_advertiser_id
Informe de productLeadAndCrossSell p_ProductLeadAndCrossSellFloodlightStats_advertiser_id
ProductLeadAndCrossSellFloodlightStats_advertiser_id
Informe de visit p_Visit_advertiser_id
Visit_advertiser_id

Asignación de columnas para informes de anuncios de búsqueda

Las tablas de BigQuery que se crearon en una transferencia de Search Ads 360 constan de las siguientes columnas (campos):

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

Tablas de coincidencia de Search Ads 360

Las tablas de coincidencia de Search Ads 360 son tablas que contienen solo campos de atributos (campos que contienen configuración y otros datos fijos) y están definidos para que los usuarios consulten información de estructuras de cuentas.

Las tablas de coincidencias de Search Ads 360 incluyen lo siguiente:

  • Account
  • Anuncio
  • Anunciante
  • AdGroup
  • AdGroupTarget
  • BidStrategy
  • Campaña
  • CampaignTarget
  • FeedItem
  • FloodlightActivity
  • Palabra clave
  • NegativeAdGroupKeyword
  • NegativeAdGroupTarget
  • NegativeCampaignKeyword
  • NegativeCampaignTarget
  • ProductAdvertised
  • ProductGroup
  • ProductLeadAndCrossSellFloodlightStats