Trasformazione dei report di Search Ads 360 (ritirata)
Mappatura delle tabelle per i report di Search Ads 360
Quando i report di Search Ads 360 (in precedenza DoubleClick Search) vengono trasferiti a BigQuery, vengono trasformati nelle seguenti tabelle e viste BigQuery.
Quando visualizzi le tabelle e le viste in BigQuery, il valore di advertiser_id è l'ID inserzionista di Search Ads 360.
| Report di Google Search Ads 360 | Tabelle BigQuery | Viste BigQuery |
|---|---|---|
| Report 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 |
| Report sugli annunci |
p_Ad_advertiser_id p_AdDeviceStats_advertiser_id p_AdFloodlightAndDeviceStats_advertiser_id |
Ad_advertiser_id AdDeviceStats_advertiser_id AdFloodlightAndDeviceStats_advertiser_id |
| Report gruppo di annunci |
p_AdGroup_advertiser_id p_AdGroupDeviceStats_advertiser_id p_AdGroupFloodlightAndFeedItemStats_advertiser_id p_AdGroupFloodlightAndDeviceStats_advertiser_id p_AdGroupStats_advertiser_id p_AdGroupFeedItemStats_advertiser_id |
GruppoDiAnnunci_advertiser_id GruppoDiAnnunciDatiDispositivo_advertiser_id GruppoDiAnnunciDatiFloodlightEElementoFeed_advertiser_id GruppoDiAnnunciDatiFloodlightEDispositivo_advertiser_id GruppoDiAnnunciDati_advertiser_id GruppoDiAnnunciDatiElementoFeed_advertiser_id |
| Report adGroupTarget |
p_AdGroupTarget_advertiser_id p_AdGroupTargetDeviceStats_advertiser_id p_AdGroupTargetFloodlightAndDeviceStats_advertiser_id |
TargetGruppoAnnunci_advertiser_id StatisticheDispositiviTargetGruppoAnnunci_advertiser_id StatisticheFloodlightEDispositiviTargetGruppoAnnunci_advertiser_id |
| Report strategia di offerta |
p_BidStrategy_advertiser_id p_BidStrategyStats_advertiser_id |
BidStrategy_advertiser_id BidStrategyStats_advertiser_id |
| Report sulla campagna |
p_Campaign_advertiser_id p_CampaignDeviceStats_advertiser_id p_CampaignFloodlightAndFeedItemStats_advertiser_id p_CampaignFloodtlightAndDeviceStats_advertiser_id (Inutilizzabile) p_CampaignFloodlightAndDeviceStats_advertiser_id p_CampaignStats_advertiser_id p_CampaignFeedItemStats_advertiser_id |
Campaign_advertiser_id CampaignDeviceStats_advertiser_id CampaignFloodlightAndFeedItemStats_advertiser_id CampaignFloodtlightAndDeviceStats_advertiser_id (Inutilizzata) CampaignFloodlightAndDeviceStats_advertiser_id CampaignStats_advertiser_id CampaignFeedItemStats_advertiser_id |
| Report campaignTarget |
p_CampaignTarget_advertiser_id p_CampaignTargetDeviceStats_advertiser_id p_CampaignTargetFloodlightAndDeviceStats_advertiser_id |
TargetCampagna_advertiser_id StatisticheDispositivoTargetCampagna_advertiser_id StatisticheFloodlightEDispositivoTargetCampagna_advertiser_id |
| Report sulle conversioni |
p_Conversion_advertiser_id |
Conversion_advertiser_id |
| Report feedItem |
p_FeedItem_advertiser_id p_FeedItemStats_advertiser_id p_FeedItemFloodlightStats_advertiser_id |
FeedItem_advertiser_id FeedItemStats_advertiser_id FeedItemFloodlightStats_advertiser_id |
| Report floodlightActivity |
p_FloodlightActivity_advertiser_id |
FloodlightActivity_advertiser_id |
| Report sulle parole chiave |
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 |
| Report negativeAdGroupKeyword |
p_NegativeAdGroupKeyword_advertiser_id |
NegativeAdGroupKeyword_advertiser_id |
| Report negativeAdGroupTarget |
p_NegativeAdGroupTarget_advertiser_id |
NegativeAdGroupTarget_advertiser_id |
| Report negativeCampaignKeyword |
p_NegativeCampaignKeyword_advertiser_id |
NegativeCampaignKeyword_advertiser_id |
| Report negativeCampaignTarget |
p_NegativeCampaignTarget_advertiser_id |
NegativeCampaignTarget_advertiser_id |
| Report productAdvertised |
p_ProductAdvertised_advertiser_id p_ProductAdvertisedDeviceStats_advertiser_id p_ProductAdvertisedFloodlightAndDeviceStats_advertiser_id |
ProductAdvertised_advertiser_id ProductAdvertisedDeviceStats_advertiser_id ProductAdvertisedFloodlightAndDeviceStats_advertiser_id |
| Report productGroup |
p_ProductGroup_advertiser_id p_ProductGroupStats_advertiser_id |
ProductGroup_advertiser_id ProductGroupStats_advertiser_id |
| Report productLeadAndCrossSell |
p_ProductLeadAndCrossSellFloodlightStats_advertiser_id |
ProductLeadAndCrossSellFloodlightStats_advertiser_id |
| Report sulle visite |
p_Visit_advertiser_id |
Visit_advertiser_id |
Mappatura delle colonne per i report Annunci della rete di ricerca
Le tabelle BigQuery create da un trasferimento di Search Ads 360 sono costituite dalle seguenti colonne (campi):
| Tabelle BigQuery | Colonne |
|---|---|
| Report account: tabella Account |
account accountCurrencyCode accountEngineId accountId accountTimeZone accountType advertiserId agencyId creationTimestamp lastModifiedTimestamp status |
| Report account: tabella AccountDeviceStats |
accountEngineId accountId adWordsConversionValue adWordsConversions adWordsViewThroughConversions advertiserId agencyId avgCpc avgCpm avgPos clicks cost ctr date deviceSegment impr visits |
| Report account: tabella AccountFloodlightAndDeviceStats |
accountEngineId accountId advertiserId agencyId date deviceSegment dfaActions dfaRevenue dfaTransactions dfaWeightedActions floodlightActivityId floodlightGroupId |
| Report account: tabella AccountStats |
accountEngineId accountId advertiserId agencyId date displayBudgetLostImpressionShare displayImpressionShare displayRankLostImpressionShare qualityScoreAvg searchBudgetLostImpressionShare searchImpressionShare searchRankLostImpressionShare topOfPageBidAvg |
| Report Annunci: tabella annunci |
accountId ad adDescription1 adDescription2 adDisplayUrl adEngineId adGroupId adHeadline adHeadline2 adId adLabels adLandingPage adPromotionLine adType advertiserId agencyId campaignId creationTimestamp effectiveLabels engineStatus isUnattributedAd lastModifiedTimestamp status |
| Report sugli annunci: tabella AdDeviceStats |
accountId adEngineId adGroupId adId adWordsConversionValue adWordsConversions adWordsViewThroughConversions advertiserId agencyId avgCpc avgCpm avgPos campaignId clicks cost ctr date deviceSegment impr visits |
| Report sugli annunci: tabella AdFloodlightAndDeviceStats |
accountId adEngineId adGroupId adId advertiserId agencyId campaignId date deviceSegment dfaActions dfaRevenue dfaTransactions dfaWeightedActions floodlightActivityId floodlightGroupId |
| Report gruppo di annunci: tabella Gruppo di annunci |
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 |
| Report sul gruppo di annunci: tabella AdGroupDeviceStats |
accountId adGroupEngineId adGroupId adWordsConversionValue adWordsConversions adWordsViewThroughConversions advertiserId agencyId avgCpc avgCpm avgPos campaignId clicks cost ctr date deviceSegment effectiveBidStrategyId impr visits |
| Report gruppo di annunci: tabella 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 |
| Report gruppo di annunci: tabella AdGroupFloodlightAndDeviceStats |
accountId adGroupEngineId adGroupId advertiserId agencyId campaignId date deviceSegment dfaActions dfaRevenue dfaTransactions dfaWeightedActions effectiveBidStrategyId floodlightActivityId floodlightGroupId |
| Report gruppo di annunci: tabella AdGroupFloodlightAndFeedItemStats |
accountId adGroupEngineId adGroupId advertiserId agencyId campaignId date dfaActions dfaRevenue dfaTransactions dfaWeightedActions effectiveBidStrategyId feedId feedItemId feedType floodlightActivityId floodlightGroupId |
| Report gruppo di annunci: tabella AdGroupStats |
accountId adGroupEngineId adGroupId advertiserId agencyId campaignId date displayImpressionShare displayRankLostImpressionShare effectiveBidStrategyId qualityScoreAvg searchImpressionShare searchRankLostImpressionShare topOfPageBidAvg |
| Report adGroupTarget: tabella 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 |
| Report adGroupTarget: tabella 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 |
| Report adGroupTarget: tabella 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 |
| Report inserzionista: tabella Inserzionista |
advertiser advertiserCurrencyCode advertiserId agency agencyId creationTimestamp dfaAdvertiserId dfaNetworkId dfaNetworkTimeZone lastModifiedTimestamp status |
| Report sugli inserzionisti: tabella AdvertiserDeviceStats |
adWordsConversionValue adWordsConversions adWordsViewThroughConversions advertiserId agencyId avgCpc avgCpm avgPos clicks cost ctr date deviceSegment dfaAdvertiserId dfaNetworkId impr visits |
| Report sugli inserzionisti: tabella AdvertiserFloodlightAndDeviceStats |
advertiserId agencyId date deviceSegment dfaActions dfaAdvertiserId dfaNetworkId dfaRevenue dfaTransactions dfaWeightedActions floodlightActivityId floodlightGroupId |
| Report inserzionista: tabella AdvertiserStats |
advertiserId agencyId date dfaAdvertiserId dfaNetworkId displayBudgetLostImpressionShare displayImpressionShare displayRankLostImpressionShare qualityScoreAvg searchBudgetLostImpressionShare searchImpressionShare searchRankLostImpressionShare topOfPageBidAvg |
| Report bidStrategy: tabella BidStrategy |
advertiserId agencyId bidStrategy bidStrategyGoal bidStrategyId bidStrategyMaxBid bidStrategyMinBid cpaTarget creationTimestamp ersTarget floodlightActivityTargetIds floodlightOptimizationEnabled highPosition lastModifiedTimestamp lowPosition monthlySpendTarget roasTarget status |
| Report sulla strategia di offerta: tabella BidStrategyStats |
adWordsConversionValue adWordsConversions adWordsViewThroughConversions advertiserId agencyId avgCpc avgCpm avgPos bidStrategyId clicks cost ctr date dfaActions dfaRevenue dfaTransactions dfaWeightedActions impr visits |
| Report Campagna: tabella Campagna |
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 |
| Report sulle campagne: tabella CampaignDeviceStats |
accountId adWordsConversionValue adWordsConversions adWordsViewThroughConversions advertiserId agencyId avgCpc avgCpm avgPos campaignEngineId campaignId clicks cost ctr date deviceSegment effectiveBidStrategyId impr visits |
| Report Campagna: tabella CampaignFeedItemStats |
accountId adWordsConversionValue adWordsConversions adWordsViewThroughConversions advertiserId agencyId avgCpc avgCpm avgPos campaignEngineId campaignId clicks clicksWithFeedItemShowing cost costWithFeedItemShowing ctr date effectiveBidStrategyId feedId feedItemId feedType impr visits |
| Report Campagna: tabella CampaignFloodlightAndDeviceStats |
accountId advertiserId agencyId campaignEngineId campaignId date deviceSegment dfaActions dfaRevenue dfaTransactions dfaWeightedActions effectiveBidStrategyId floodlightActivityId floodlightGroupId |
| Report Campagna: tabella CampaignFloodlightAndFeedItemStats |
accountId advertiserId agencyId campaignEngineId campaignId date dfaActions dfaRevenue dfaTransactions dfaWeightedActions effectiveBidStrategyId feedId feedItemId feedType floodlightActivityId floodlightGroupId |
| Report Campagna: tabella CampaignFloodlightAndDeviceStats |
accountId advertiserId agencyId campaignEngineId campaignId date deviceSegment dfaActions dfaRevenue dfaTransactions dfaWeightedActions effectiveBidStrategyId floodlightActivityId floodlightGroupId |
| Report sulle campagne: tabella 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 |
| Report campaignTarget: tabella CampaignTarget |
accountId advertiserId agencyId campaignId campaignTargetId creationTimestamp engineRemarketingList engineRemarketingListBidModifier lastModifiedTimestamp locationTargetBidModifier locationTargetName status |
| Report campaignTarget: tabella CampaignTargetDeviceStats |
accountId adWordsConversionValue adWordsConversions adWordsViewThroughConversions advertiserId agencyId avgCpc avgCpm avgPos campaignId campaignTargetId clicks cost ctr date deviceSegment impr visits |
| Report campaignTarget: tabella CampaignTargetFloodlightAndDeviceStats |
accountId advertiserId agencyId campaignId campaignTargetId date deviceSegment dfaActions dfaRevenue dfaTransactions dfaWeightedActions floodlightActivityId floodlightGroupId |
| Report sulle conversioni: tabella delle conversioni |
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 |
| Report feedItem: tabella FeedItem |
accountId advertiserId agencyId creationTimestamp engineStatus feedId feedItemId lastModifiedTimestamp locationBusinessName locationCategory locationDetails sitelinkClickserverUrl sitelinkDescription1 sitelinkDescription2 sitelinkDisplayText sitelinkLandingPageUrl status |
| Report feedItem: tabella FeedItemFloodlightStats |
accountId advertiserId agencyId date dfaActions dfaRevenue dfaTransactions dfaWeightedActions feedId feedItemId floodlightActivityId floodlightGroupId |
| Report feedItem: tabella FeedItemStats |
accountId adWordsConversionValue adWordsConversions adWordsViewThroughConversions advertiserId agencyId avgCpc avgCpm avgPos clicks clicksWithFeedItemShowing cost costWithFeedItemShowing ctr date dfaActions dfaRevenue dfaTransactions dfaWeightedActions feedId feedItemId impr visits |
| Report floodlightActivity: tabella FloodlightActivity |
advertiserId agencyId creationTimestamp floodlightActivity floodlightActivityId floodlightActivityTag floodlightConfigurationId floodlightGroup floodlightGroupConversionType floodlightGroupId floodlightGroupTag lastModifiedTimestamp status |
| Report sulle parole chiave: tabella delle parole chiave |
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 |
| Report sulle parole chiave: tabella KeywordDeviceStats |
accountId adGroupId adId adWordsConversionValue adWordsConversions adWordsViewThroughConversions advertiserId agencyId avgCpc avgCpm avgPos campaignId clicks cost ctr date deviceSegment effectiveBidStrategyId impr keywordEngineId keywordId visits |
| Report sulle parole chiave: tabella KeywordFloodlightAndDeviceStats |
accountId adGroupId adId advertiserId agencyId campaignId date deviceSegment dfaActions dfaRevenue dfaTransactions dfaWeightedActions effectiveBidStrategyId floodlightActivityId floodlightGroupId keywordEngineId keywordId |
| Report sulle parole chiave: tabella KeywordStats |
accountId adGroupId advertiserId agencyId campaignId effectiveBidStrategyId keywordEngineId keywordId qualityScoreAvg topOfPageBidAvg |
| Report negativeAdGroupKeyword: tabella NegativeAdGroupKeyword |
accountId adGroupId advertiserId agencyId campaignId creationTimestamp engineStatus lastModifiedTimestamp negativeAdGroupKeywordId negativeAdGroupKeywordMatchType negativeAdGroupKeywordText status |
| Report negativeAdGroupTarget: tabella NegativeAdGroupTarget |
accountId adGroupId advertiserId ageTargetAgeRange agencyId campaignId creationTimestamp dynamicSearchAdsTargetConditions engineRemarketingList genderTargetGenderType lastModifiedTimestamp locationTargetName negativeAdGroupTargetId status |
| Report negativeCampaignKeyword: tabella NegativeCampaignKeyword |
accountId advertiserId agencyId campaignId creationTimestamp engineStatus lastModifiedTimestamp negativeCampaignKeywordId negativeCampaignKeywordMatchType negativeCampaignKeywordText status |
| Report negativeCampaignTarget: tabella NegativeCampaignTarget |
accountId advertiserId ageTargetAgeRange agencyId campaignId creationTimestamp dynamicSearchAdsTargetConditions engineRemarketingList genderTargetGenderType lastModifiedTimestamp locationTargetName negativeCampaignTargetId status |
| Report productAdvertised: tabella 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 |
| Report prodotto pubblicizzato: tabella ProductAdvertisedDeviceStats |
adWordsConversionValue adWordsConversions adWordsViewThroughConversions advertiserId agencyId avgCpc avgCpm avgPos clicks cost ctr date deviceSegment impr productId visits |
| Report productAdvertised: tabella ProductAdvertisedFloodlightAndDeviceStats |
accountId adGroupId advertiserId agencyId campaignId date deviceSegment dfaActions dfaRevenue dfaTransactions dfaWeightedActions floodlightActivityId floodlightGroupId productId |
| Report productGroup: tabella ProductGroup |
accountId adGroupId advertiserId agencyId bidStrategyInherited campaignId creationTimestamp effectiveBidStrategy effectiveBidStrategyId effectiveLabels effectiveProductGroupMaxCpc engineStatus lastModifiedTimestamp productGroup productGroupClickserverUrl productGroupId productGroupLandingPage productGroupMaxBid productGroupMaxCpc productGroupMinBid productGroupPartitionType status |
| Report sul gruppo di prodotti: tabella ProductGroupStats |
accountId adGroupId adWordsConversionValue adWordsConversions adWordsViewThroughConversions advertiserId agencyId avgCpc avgCpm avgPos campaignId clicks cost ctr date dfaActions dfaRevenue dfaTransactions dfaWeightedActions effectiveBidStrategyId impr productGroupId visits |
| Report sulle campagne di lead e cross-sell dei prodotti: tabella 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 |
| Report sulle visite: tabella 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 |
Tabelle di corrispondenza di Search Ads 360
Le tabelle delle corrispondenze di Search Ads 360 sono tabelle che contengono solo campi Attributo (campi contenenti impostazioni o altri dati fissi) e sono definite per consentire agli utenti di eseguire query sulle informazioni sulla struttura dell'account.
Le tabelle di corrispondenza di Search Ads 360 includono quanto segue:
- Account
- Annuncio
- Inserzionista
- AdGroup
- AdGroupTarget
- BidStrategy
- Campagna
- CampaignTarget
- FeedItem
- FloodlightActivity
- Parola chiave
- NegativeAdGroupKeyword
- NegativeAdGroupTarget
- NegativeCampaignKeyword
- NegativeCampaignTarget
- ProductAdvertised
- ProductGroup
- ProductLeadAndCrossSellFloodlightStats