Trasformazione dei report di Search Ads 360 (non più supportata)

Attenzione: questo documento si basa sulla versione precedente dell'API Search Ads 360 Reporting. A partire dal 31 maggio 2024, BigQuery non supporterà più la precedente API di reporting di Search Ads 360. Per utilizzare la nuova versione di Search Ads 360, devi eseguire la migrazione dei flussi di lavoro di trasferimento di Search Ads 360 seguendo la guida alla migrazione di Search Ads 360. Per consultare la guida al trasferimento aggiornata di Search Ads 360 che utilizza la nuova API Search Ads 360 Reporting, consulta Trasferimenti di Search Ads 360. Questa pagina verrà ritirata il 31 maggio 2024.

Beta

Questo prodotto è soggetto ai "Termini delle offerte pre-GA" nella sezione Termini di servizio generali dei Termini specifici dei servizi. I prodotti pre-GA sono disponibili "così come sono" e potrebbero avere un supporto limitato. Per saperne di più, consulta le descrizioni della fase di lancio.

Mappatura delle tabelle per i report di Search Ads 360

Quando i report di Search Ads 360 (noto in precedenza come DoubleClick Search) vengono trasferiti a BigQuery, vengono trasformati nelle seguenti tabelle e viste di BigQuery.

Quando visualizzi le tabelle e le visualizzazioni in BigQuery, il valore di advertiser_id è l'ID inserzionista Search Ads 360.

Report di Google Search Ads 360	Tabelle BigQuery	Viste BigQuery
report sull'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	Gruppo di annunci_advertiser_id Gruppo di annunciGoogleStats_advertiser_id Gruppo di annunciFloodlightAndFeedItemStats_advertiser_id Gruppo di annunci FloodlightAndDeviceStats_advertiser_id Gruppo di annunci Google Ads_advertiser_id Gruppo di annunci FloodlightItemStats_advertiser_id
Report adGroupTarget	p_AdGroupTarget_advertiser_id p_AdGroupTargetDeviceStats_advertiser_id p_AdGroupTargetFloodlightAndDeviceStats_advertiser_id	Gruppo di annunci target_advertiser_id Gruppo di annunciTargetDeviceStats_advertiser_id Gruppo di annunciTargetFloodlightAndDeviceStats_advertiser_id
Report BidStrategy	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 (Ritiro in corso) 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
Report campagnaTarget	p_CampaignTarget_advertiser_id p_CampaignTargetDeviceStats_advertiser_id p_CampaignTargetFloodlightAndDeviceStats_advertiser_id	CampaignTarget_advertiser_id CampaignTargetDeviceStats_advertiser_id CampaignTargetFloodlightAndDeviceStats_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 Floodlight Activity	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 KeywordStats_advertiser_id KeywordFloodlightAndDeviceStats_advertiser_id KeywordStats_advertiser_id
Rapporto sulle parole chiave escluse	p_NegativeAdGroupKeyword_advertiser_id	NegativeAdGroupKeyword_advertiser_id
Report negativeAdGroupTarget	p_NegativeAdGroupTarget_advertiser_id	NegativeAdGroupTarget_advertiser_id
Report sulle parole chiave escluse	p_NegativeCampaignKeyword_advertiser_id	NegativeCampaignKeyword_advertiser_id
Report negativeCampaignTarget	p_NegativeCampaignTarget_advertiser_id	NegativeCampaignTarget_advertiser_id
Report prodottoPubblicizzato	p_ProductAdvertisingd_advertiser_id p_ProductPubblicitàdDeviceStats_advertiser_id p_ProductAdvertisingdFloodlightAndDeviceStats_advertiser_id	ProdottoPubblicizzato_advertiser_id ProdottoPubblicizzatoDispositivoStats_advertiser_id ProdottoAnnunci FloodlightAndDeviceStats_advertiser_id
Report productGroup	p_ProductGroup_advertiser_id p_ProductGroupStats_advertiser_id	GruppoProdotti_advertiser_id StatGruppo Prodotto_advertiser_id
Report productLeadAndCrossSell	p_ProductLeadAndCrossSellFloodlightStats_advertiser_id	ProductLeadAndCrossSellFloodlightStats_advertiser_id
visita il report	p_Visit_advertiser_id	Visit_advertiser_id

Mappatura delle colonne per i report sugli 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 lastChangeTimestamp status
Report sull'account: tabella AccountDeviceStats	accountEngineId accountId adWordsConversionValue adWordsConversions adWordsView ThroughConversions advertiserId AgencyId avgCpc avgCpm avgPos clic costo ctr date deviceSegment impr visite
report sull'account: tabella AccountFloodlightAndDeviceStats	accountEngineId accountId advertiserId AgencyId date deviceSegment dfa Actions dfaRevenue dfaTransactions dfaWeightedAzioni FloodlightActivityId FloodlightGroupId
Report account: tabella AccountStats	accountEngineId accountId ID inserzionista AgencyId date displayBudgetLostImpressionShare displayImpressionShare displayRankLostImpressionShare qualityScoreAvg searchBudgetLostImpressionShare SearchImpression Share searchRankLostImpressionShare topOfPageBidAvg
Report annunci: tabella annunci	accountId ad adDescription1 adDescription2 adDisplayUrl adEngineId adGroupId adHeadline adHeadline2 adId adLabel adlandingPage adPromotionLine adType advertiserId AgencyId campaignId
Report sugli annunci: tabella AdDeviceStats	ID account adEngineId adGroupId adId adWordsConversionValue adWordsConversions adWordsView ThroughConversions advertiserId agenziaId avgCpc avgCpm avgPos campaignId clic costo ctr date deviceSegment impr visite
report annuncio: tabella AdFloodlightAndDeviceStats	accountId adEngineId adGroupId adId advertiserId AgencyId campaignId date deviceSegment dfa Actions dfaRevenue dfaTransactions dfaWeightedAzioni FloodlightActivityId FloodlightGroupId
Report adGroup: tabella Gruppo di annunci	mod.
Report adGroup: tabella GruppoAnnunciDeviceStats	accountId adGroupEngineId adGroupId adWordsConversionValue adWordsConversions adWordsView ThroughConversions advertiserId agenziaId avgCpc avgCpm avgPos campaignId clic costo ctr date deviceSegment effectiveBidStrategyId impr visite
Report adGroup: tabella GruppodiannunciFeedItemStats	ID account adGroupEngineId adGroupId adWordsConversionValue adWordsConversions adWordsView ThroughConversions advertiserId AgencyId avgCpc avgCpm avgPos campaignId clic clicksWithFeedItemClicks cost costWithFeedItemClicks advertiserId date feedBidStrategy feedeffettiva
Report adGroup: tabella Gruppo di annunciFloodlightAndDeviceStats	accountId adGroupEngineId adGroupId advertiserId AgencyId campaignId date deviceSegment dfa Actions dfaRevenue dfaTransactions dfaWeightedactions effectiveBidStrategyId FloodlightActivityId FloodlightGroupId
Report adGroup: tabella Gruppo di annunci FloodlightAndFeedItemStats	accountId adGroupEngineId adGroupId advertiserId AgencyId campaignId date dfaAzioni dfaRevenue dfaTransactions dfaWeightedactions effectiveBidStrategyId feedId feedItemId feedType FloodlightActivityId FloodlightGroupId
Report adGroup: tabella GruppostatStats	accountId adGroupEngineId adGroupId advertiserId AgencyId campaignId date displayImpressionShare displayRankLostImpressionShare efficaciBidStrategyId qualityScoreAvg SearchImpressionShare searchRankLostImpressionShare topOfPageBidAvg
Report adGroupTarget: tabella TargetTarget	account accountId accountType adGroup adGroupId adGroupStatus adGroupTargetId inserzionista advertiserId ageTargetAgeRange ageTargetBidModifier agenzia agenziaId campaign campaignId campaignStatus createdTimestamp dynamicSearchAdsTargetSearchTypeCopertura
Report adGroupTarget: tabella AdGroupTargetDeviceStats	accountId adGroupId adGroupTargetId adWordsConversionValueAds adWordsConversionValue adWordsConversioni adWordsView attraversoConversioni advertiserId ageTargetAgeRange ageTargetBidModifier AgencyId avgCpc avgCpm avgPos campaignId clic costo ctr Bid dynamicSearch DeviceSegment
Report adGroupTarget: tabella campaignTargetFloodlightAndDeviceStats	accountId adGroupId adGroupTargetId advertiserId ageTargetAgeRange ageTargetBidModifier AgencyId campaignId date deviceSegment dfa Actions dfaRevenue dfaTransactions dfaWeightedAzioni dynamicSearchAdsTargetConditions dynamicSearchAdsTarget Copertura dynamicSearchAdsTargetActivityCpcBidList Floodlightdalla rete
Report inserzionisti: tabella Inserzionisti	inserzionista advertiserCurrencyCode advertiserId agenzia AgencyId CreationTimestamp dfaAdvertiserId dfaNetworkId dfaNetworkTimeZone lastChangeTimestamp status
Report sugli inserzionisti: tabella AdvertiserDeviceStats	adWordsConversionValue adWordsConversions adWordsView ThroughConversions advertiserId agenzieId avgCpc avgCpm avgPos clic costo ctr date deviceSegment dfaAdvertiserId dfaNetworkId impr visite
Report inserzionista: tabella AdvertiserFloodlightAndDeviceStats	inserzionistaId AgencyId date deviceSegment dfa Actions dfaAdvertiserId dfaNetworkId dfaRevenue dfaTransactions dfaWeightedAzioni FloodlightActivityId FloodlightGroupId
Report inserzionisti: tabella AdvertiserStats	inserzionistaId AgencyId date dfaAdvertiserId dfaNetworkId displayBudgetLostImpressionShare displayImpressionShare displayRankLostImpressionShare qualitàScoreAvg searchBudgetpersa Quota impressioni SearchImpressionShare searchRankLostImpressionShare topOfPageBidAvg
Report bidStrategy: tabella BidStrategy	inserzionistaId AgencyId bidStrategy bidStrategyGoal bidStrategyId bidStrategyMaxBid bidStrategyMinBid cpaTarget CreationTimestamp ersTarget FloodlightActivityTargetIds FloodlightConversionsEnabled highPosition lastChangeTimestamp lowPosition monthlySpendTarget roasTarget status
Report bidStrategy: tabella BidStrategyStats	adWordsConversionValue adWordsConversions adWordsView ThroughConversions advertiserId agenzieId avgCpc avgCpm avgPos bidStrategyId clic costo ctr date dfaAzioni dfaRevenue dfaTransactions dfaWeightedactions impr visite
Report campagna: tabella campagna	di <br class="ph-
report campagna: tabella CampaignDeviceStats	accountId adWordsConversionValue adWordsConversions adWordsView ThroughConversions advertiserId agenziaId avgCpc avgCpm avgPos campaignEngineId campaignId clic costo ctr date deviceSegment effettiveBidStrategyId impr visite
report campagna: tabella CampaignFeedItemStats	ID account adWordsConversionValue adWordsConversions adWordsView ThroughConversions advertiserId agenzieId avgCpc avgCpm avgPos campaignEngineId campaignId clic clicksWithFeedItem Serving cost costWithFeedItemClicks ctr feedItem efficaciBidStrategyId feedId
report campagna: tabella CampaignFloodlightAndDeviceStats	accountId advertiserId AgencyId campaignEngineId campaignId date deviceSegment dfaAzioni dfaRevenue dfaTransactions dfaWeightedactions effectiveBidStrategyId FloodlightActivityId FloodlightGroupId
report campagna: tabella CampaignFloodlightAndFeedItemStats	accountId advertiserId AgencyId campaignEngineId campaignId date dfa Actions dfaRevenue dfaTransactions dfaWeightedAzioni effectiveBidStrategyId feedId feedItemId feedType FloodlightActivityId FloodlightGroupId
Report campagna: tabella CampaignFloodtlightAndDeviceStats	accountId advertiserId AgencyId campaignEngineId campaignId date deviceSegment dfaAzioni dfaRevenue dfaTransactions dfaWeightedactions effectiveBidStrategyId FloodlightActivityId FloodlightGroupId
Report campagna: tabella CampaignStats	accountId adWordsConversionValue adWordsConversions adWordsViewthroughConversions advertiserId agenziaId avgCpc avgCpm avgPos campaignEngineId campaignId clic costo ctr date displayBudgetLostImpression Share QuotaImpressioni
Report campaignTarget: tabella CampaignTarget	accountId advertiserId AgencyId campaignId campaignTargetId CreationTimestamp engineRemarketingList engineRemarketingListBidModifier lastChangeTimestamp locationTargetBidModifier locationTargetName status
Report campaignTarget: tabella CampaignTargetDeviceStats	ID account adWordsConversionValue adWordsConversions adWordsView ThroughConversions advertiserId agenziaId avgCpc avgCpm avgPos campaignId campaignTargetId clic costo ctr date deviceSegment impr visite
Report campaignTarget: tabella CampaignTargetFloodlightAndDeviceStats	accountId advertiserId AgencyId campaignId campaignTargetId date deviceSegment dfa Actions dfaRevenue dfaTransactions dfaWeighted Actions FloodlightActivityId FloodlightGroupId
Report sulle conversioni: tabella di conversione	account accountId accountType adGroupId adId inserzionista advertiserConversionId advertiserId agenzia AgencyId campaignId conversionAttributionType conversionDate ConversionId conversioneLastChangeTimestamp conversioneQuantity conversioneRevenue conversioneSearchTerm
Report feedItem: tabella FeedItem	accountId advertiserId AgencyId CreationTimestamp engineStatus feedId feedItemId lastChangeTimestamp locationBusinessName locationCategory locationDetails sitelinkClickserverUrl sitelinkDescription1 sitelinkDescription2 sitelinkDisplayText sitelinklandingPage status
Report feedItem: tabella FeedItemFloodlightStats	accountId advertiserId AgencyId date dfa Actions dfaRevenue dfaTransactions dfaWeighted Actions feedId feedItemId FloodlightActivityId FloodlightGroupId
Report feedItem: tabella FeedItemStats	accountId adWordsConversionValue adWordsConversions adWordsView ThroughConversions advertiserId agenzieId avgCpc avgCpm avgPos clicks clicksWithFeedItem Serving cost costWithFeedItem Serving ctr date dfa Actions avgCpc dfaTransactionsge feed Transaction
Report FloodlightActivity: tabella FloodlightActivity	inserzionistaId AgencyId CreationTimestamp FloodlightActivity FloodlightActivityId FloodlightActivityTag FloodlightConfigurationId FloodlightGroup FloodlightGroupConversionType FloodlightGroupId FloodlightGroupTag lastChangeTimestamp stato
Report sulle parole chiave: tabella parole chiave	account
Report sulle parole chiave: tabella KeywordDeviceStats	ID account adGroupId adId adWordsConversionValue adWordsConversions adWordsView ThroughConversions advertiserId agenzieId avgCpc avgCpm avgPos campaignId clic costo ctr date deviceSegment efficaciBidStrategyId impr parola chiave parola chiave
Report sulle parole chiave: tabella KeywordFloodlightAndDeviceStats	accountId adGroupId adId advertiserId AgencyId campaignId date deviceSegment dfa Actions dfaRevenue dfaTransactions dfaWeightedactions effectiveBidStrategyId FloodlightActivityId FloodlightGroupId parola chiaveEngineId KeywordId
Report sulle parole chiave: tabella KeywordStats	accountId adGroupId advertiserId AgencyId campaignId effectiveBidStrategyId parola chiaveEngineId parola chiave qualitàScoreAvg topOfPageBidAvg
Report negativeAdGroupKeyword: tabella negativeAdGroupKeyword	accountId adGroupId advertiserId AgencyId campaignId CreationTimestamp motoreStatus lastChangeTimestamp negativeAdGroupKeywordId negativeAdGroupKeywordMatchType negativeAdGroupKeywordText stato
Report negativeAdGroupTarget: tabella negativeAdGroupTarget	accountId adGroupId advertiserId ageTargetAgeRange agenzieId campaignId CreationTimestamp dynamicSearchAdsTargetConditions engineRemarketingList genderTargetGenderType lastChangeTimestamp locationTargetName negativeAdGroupTargetId status
Report negativeCampaignKeyword: tabella Parole chiave escluse	accountId advertiserId agentId campaignId CreationTimestamp motoreStatus lastChangeTimestamp negativeCampaignKeywordId negativeCampaignKeywordMatchType negativeCampaignKeywordText stato
Report negativeCampaignTarget: tabella negativeCampaignTarget	accountId advertiserId ageTargetAgeRange AgencyId campaignId CreationTimestamp dynamicSearchAdsTargetConditions engineRemarketingList genereTargetGenderType lastChangeTimestamp locationTargetName negativeCampaignTargetId status
Report prodottoPubblicizzato: tabella Annuncio prodotto	inserzionista ID AgencyId CreationTimestamp lastChangeTimestamp productAgeGroup productavailability productBrand productCategory productCategoryLevel1 productCategoryLevel2 productCategoryLevel3 productCategoryLevel4 productCategoryLevel5 productChannel productChannelExclusivity productColor productCondition productCostOfGoodsDestinationTarget 0 productCondition
Report prodottoPubblicizzato: tabella ProductAdvertisingdDeviceStats	adWordsConversionValue adWordsConversions adWordsView ThroughConversions advertiserId agenzieId avgCpc avgCpm avgPos clic costo ctr date deviceSegment impr productId visite
Report prodottoPubblicizzato: tabella ProductAdvertisingdFloodlightAndDeviceStats	accountId adGroupId advertiserId AgencyId campaignId date deviceSegment dfa Actions dfaRevenue dfaTransactions dfaWeighted Actions FloodlightActivityId FloodlightGroupId productId
Report productGroup: tabella ProductGroup	accountId adGroupId advertiserId advertiserId bidStrategyInherited campaignId CreationTimestamp effectiveBidStrategy effectiveBidStrategyId effectiveLabel effectiveProductGroupMaxCpc engineStatus lastChangeTimestamp productGroup productGroupClickserverUrl productGroupId productGrouplandingPageType productGroupMaxBidStrategyId productPartMinBidPageType
Report productGroup: tabella ProductGroupStats	accountId adGroupId adWordsConversionValue adWordsConversions adWordsView ThroughConversions advertiserId AgencyId avgCpc avgCpm avgPos campaignId clicks cost ctr date dfa Actions dfaRevenue Transazioni dfaBidStrategyIdresp. effettivi strategia di offerta Impr.
Report productLeadAndCrossSell: tabella ProductLeadAndCrossSellFloodlightStats	accountId adGroupId advertiserId AgencyId campaignId crossSellAverageUnitPrice crossSellCostOfGoodsVenduto crossSellGrossFromUnitsSold crossSellGrossProfitMargin crossSellRevenueFromUnitsSold crossSellUnitsSold date deviceSegment Gross Actions dfaRevenue dfa venduto Transazioni dfaRevenue dfa venduto
report sulle visite: tabella delle visite	account accountId accountType adGroupId adId inserzionista advertiserId agenzia AgencyId campaignId deviceSegment feedId feedItemId feedType InventoryAccountId parola chiaveId productChannel productCountry productDateGroupId productId productLanguage visita productStoreId productTargetNetworkId visita di stato visita

Tabelle delle corrispondenze di Search Ads 360

Le tabelle delle corrispondenze di Search Ads 360 sono tabelle che contengono solo i campi Attributo (campi contenenti impostazioni o altri dati fissi) e vengono definite per consentire agli utenti di eseguire query sulle informazioni sulla struttura dell'account.

Nota: gli snapshot delle tabelle delle corrispondenze non verranno aggiornati se utilizzi la finestra di aggiornamento o pianifichi un backfill.

Le tabelle delle corrispondenze 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