Umwandlung von Search Ads 360-Berichten (verworfen)

Tabellenzuordnung für Search Ads 360-Berichte

Beim Übertragen Ihrer Search Ads 360-Berichte (ehemals DoubleClick Search) an BigQuery werden die Berichte in die folgenden BigQuery-Tabellen und -Ansichten umgewandelt.

Wenn Sie die Tabellen und Ansichten in BigQuery aufrufen, wird der Wert für advertiser_id durch Ihre Search Ads 360-Werbetreibenden-ID ersetzt.

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

Spaltenzuordnung für Search Ads-Berichte

Die BigQuery-Tabellen, die durch eine Search Ads 360-Übertragung erstellt werden, bestehen aus den folgenden Spalten (Feldern):

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

Search Ads 360-Match-Tables enthalten Folgendes:

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