Search Ads 360 report transformation (Deprecated)

Table mapping for Search Ads 360 reports

When your Search Ads 360 (formerly known as Doubleclick Search) reports are transferred to BigQuery, the reports are transformed into the following BigQuery tables and views.

When you view the tables and views in BigQuery, the value for advertiser_id is your Search Ads 360 Advertiser ID.

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

Column mapping for Search Ads reports

The BigQuery tables created by a Search Ads 360 transfer consist of the following columns (fields):

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

Search Ads 360 Match Tables

Search Ads 360 Match Tables are tables that contain Attribute fields (fields containing settings or other fixed data) only, and they are defined for users to query account structure information.

Search Ads 360 Match Tables include the following:

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