Trasformazione dei report di Search Ads 360 (deprecata)

Attenzione: questo documento si basa sulla versione precedente dell'API di reporting di Search Ads 360. Dal 31 maggio 2024 BigQuery non supporterà più la vecchia API di reporting di Search Ads 360. Devi eseguire la migrazione dei flussi di lavoro di trasferimento di Search Ads 360 per utilizzare la nuova versione 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 di reporting di Search Ads 360, 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 (precedentemente noto come DoubleClick Search) vengono trasferiti a BigQuery, vengono trasformati nelle seguenti tabelle e viste 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	Visualizzazioni 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 GroupsDeviceStats_advertiser_id Gruppo di annunciFloodlightAndFeedItemStats_advertiser_id Gruppo annunciFloodlightAndDeviceStats_advertiser_id GroupsStats_advertiser_id GruppoAnnunciFeedItemStats_advertiser_id
Report adGroupTarget	p_AdGroupTarget_advertiser_id p_AdGroupTargetDeviceStats_advertiser_id p_AdGroupTargetFloodlightAndDeviceStats_advertiser_id	GruppoAnnunci_advertiser_id GruppoAnnunciTargetDeviceStats_advertiser_id TargetTargetFloodlightAndDeviceStats_advertiser_id
Report sulla strategia di offerta	p_BidStrategy_advertiser_id p_BidStrategyStats_advertiser_id	BidStrategy_advertiser_id BidStrategyStats_advertiser_id
report sulle campagne	p_Campaign_advertiser_id p_CampaignDeviceStats_advertiser_id p_CampaignFloodlightAndFeedItemStats_advertiser_id p_CampaignFloodtlightAndDeviceStats_advertiser_id (deprecating) p_CampaignFloodlightAndDeviceStats_advertiser_id p_CampaignFloodlightAndDeviceStats_advertiser_id p_CampaignFeedItemStats_advertiser_id	Campagna_advertiser_id CampaignDeviceStats_advertiser_id CampaignFloodlightAndFeedItemStats_advertiser_id CampaignFloodtlightAndDeviceStats_advertiser_id (Deprecating) CampaignFloodlightAndDeviceStats_advertiser_id CampaignStats_advertiser_id CampaignFeedItemStats_advertiser_id
report sul target della campagna	p_CampaignTarget_advertiser_id p_CampaignTargetDeviceStats_advertiser_id p_CampaignTargetFloodlightAndDeviceStats_advertiser_id	TargetCampagna_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 attività Floodlight	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 sulle parole chiave escluse del gruppo di annunci	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 prodotto pubblicizzato	p_ProductAdvertisingd_advertiser_id p_ProductAdvertisingdDeviceStats_advertiser_id p_ProductAdvertisingdFloodlightAndDeviceStats_advertiser_id	ProdottoPubblicizzato_advertiser_id Prodotto Stato pubblicitario_del_prodotto_advertiser_id Stato_prodottoPubblicizzatoFloodlightAndDeviceStats_advertiser_id
Report gruppo di prodotti	p_ProductGroup_advertiser_id p_ProductGroupStats_advertiser_id	ProductGroup_advertiser_id ProductGroupStats_advertiser_id
Report su 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 composte dalle seguenti colonne (campi):

Tabelle BigQuery	Colonne
Report sull'account: tabella dell'account	account accountCurrencyCode accountEngineId accountId accountTimeZone accountType advertiserId agencyId CreationTimestamp lastModifiedTimestamp status
Report sull'account: tabella AccountDeviceStats	accountEngineId accountId adWordsConversionValue adWordsConversioni adWordsViewThroughConversioni advertiserId agenziaId avgCpc avgCpm avgPos clic costo ctr data deviceSegment impr visite
Report sull'account: tabella AccountFloodlightAndDeviceStats	accountEngineId accountId advertiserId rappresentaId date deviceSegment dfaActions dfaRevenue dfaTransactions dfapossibiliAzioni FloodlightActivityId FloodlightGroupId
Report sull'account: tabella AccountStats	accountEngineId accountId advertiserId AgencyId date displayBudgetLostImpressionShare displayImpressionShare displayRankLostImpressionShare qualitàScoreAvg searchBudgetLostImpressionShare searchImpressionShare searchRankLostImpressionShare topOfPageBidAvg
Report sugli annunci: tabella annunci	accountId ad adDescription1 adDescription2 adDisplayUrl adEngineId adGroupId adHeadline adHeadline2 adId adLabels ad LandingPage adPromotionLine adType advertiserId AgencyId campaignId CreationTimestamp effectiveLabels EngineStatus isUnattributeTimestampdAd lastModified
Report sugli annunci: tabella AdDeviceStats	accountId adEngineId adGroupId adId adWordsConversionValue adWordsConversioni adWordsViewThroughconversions advertiserId AgencyId avgCpc avgCpm avgPos campaignId clic costo ctr data deviceSegment impr visite
Report sugli annunci: tabella AdFloodlightAndDeviceStats	accountId adEngineId adGroupId adId advertiserId agenziaId campaignId date deviceSegment dfaActions dfaRevenue dfaTransactions dfaSupportedActions FloodlightActivityId FloodlightGroupId
Report sul gruppo di annunci: tabella del gruppo di annunci	accountId adGroup adGroupBroadMaxCpc adGroupContentMaxCpc adGroupEndDate adGroupEngineId adGroupExactMaxCpc adGroupId adGroupLabels adGroupMobileBid attraverso di aggiustamento adGroup finiMaxCpc adGroupSearchMaxCpc adGroupStartDate advertiserId agencyId bidStrategyInherited
Report sul gruppo di annunci: tabella GroupDeviceStats	accountId adGroupEngineId adGroupId adWordsConversionValue adWordsConversioni adWordsViewThroughConversioni advertiserId agencyId avgCpc avgCpm avgPos campaignId clicks cost ctr date deviceSegment EffectiveBidStrategyId impr visite
Report sul gruppo di annunci: tabella BigtableFeedItemStats	accountId adGroupEngineId adGroupId adWordsConversionValue adWordsConversioni adWordsViewThroughconversions advertiserId agencyId avgCpc avgCpm avgPos campaignId clicks clicksWithFeedItemReporting cost costWithFeedItemAbout ctr feedStrategy feedStrategy feed
Report sul gruppo di annunci: tabella Gruppo di annunciFloodlightAndDeviceStats	accountId adGroupEngineId adGroupId advertiserId agencyId campaignId date deviceSegment dfaActions dfaRevenue dfaTransactions dfaPersonalizedActions effectiveBidStrategyId FloodlightActivityId FloodlightGroupId
Report sul gruppo di annunci: tabella Gruppo di annunciFloodlightAndFeedItemStats	accountId adGroupEngineId adGroupId advertiserId AgencyId campaignId date dfaActions dfaRevenue dfaTransactions dfapossibiliActions effectiveBidStrategyId feedId feedItemId feedType FloodlightActivityId FloodlightGroupId
Report sul gruppo di annunci: tabella Statistiche del gruppo di annunci	accountId adGroupEngineId adGroupId advertiserId AgencyId campaignId date displayImpressionShare displayRankLostImpressionShare effectiveBidStrategyId qualitàScoreAvg searchImpressionShare searchRankLostImpressionShare topOfPageBidAvg
Report su adGroupTarget: tabella TargetTarget	account accountId accountType adGroup adGroupId adGroupStatus adGroupTargetId advertiser advertiserId ageTargetAgeRange ageTargetBidModifier agenzia AgencyId campaign campaignId campaign CreationTimestamp dynamicSearchAdsTargetConditions dynamicSearchAdsTargetCoverage dynamicSearchAdsTargetGender CBidPC
Report adGroupTarget: tabella GruppoTargetingDeviceStats	accountId adGroupId adGroupTargetId adWordsConversionValue adWordsConversioni adWordsViewThroughConversioni advertiserId ageTargetAgeRange ageTargetBidModifier AgencyId avgCpc avgCpm avg RemarketingPos campaignId clicks cost ctr dynamicGenderGenderRange deviceCondition
Report adGroupTarget: tabella GruppoTargetingFloodlightAndDeviceStats	accountId adGroupId adGroupTargetId advertiserId ageTargetAgeRange ageTargetBidModifier rappresenta l'ID dell'agenzia campaignId date deviceSegment dfaActions dfaRevenue dfaTransaction dfaBidActions dynamicSearchAdsTargetConditions dynamicSearchAdsTarget errato
Report sugli inserzionisti: tabella Inserzionisti	inserzionista advertiserCurrencyCode advertiserId agenzia agencyId CreationTimestamp dfaAdvertiserId dfaNetworkId dfaNetworkTimeZone lastModifiedTimestamp stato
Report inserzionista: tabella AdvertiserDeviceStats	adWordsConversionValue adWordsconversions adWordsViewThroughconversions advertiserId agencyId avgCpc avgCpm avgPos clic costo ctr date deviceSegment dfaAdvertiserId dfaNetworkId impr visite
Report sugli inserzionisti: tabella AdvertiserFloodlightAndDeviceStats	inserzionistaId AgencyId date deviceSegment dfaActions dfaAdvertiserId dfaNetworkId dfaRevenue dfaTransactions dfaPersonalizedActions FloodlightActivityId FloodlightGroupId
Report inserzionista: tabella AdvertiserStats	inserzionistaId agenziaId date dfaAdvertiserId dfaNetworkId displayBudgetLostImpressionShare displayImpressionShare displayRankLostImpressionShare qualityScoreAvg searchBudgetLostImpressionShare searchImpressionShare searchRankLostImpressionShare topOfPageBidAvg
Report strategia di offerta: tabella BidStrategy	advertiserId AgencyId bidStrategy bidStrategyGoal bidStrategyId bidStrategyMaxBid bidStrategyMinBid cpaTarget CreationTimestamp ersTarget FloodlightActivityTargetIds FloodlightOptimizingEnabled highPosition lastModifiedTimestamp lowPosition monthlySpendTarget roasTarget status
Report sulla strategia di offerta: tabella BidStrategyStats	adWordsConversionValue adWordsConversion adWordsViewThroughconversions advertiserId AgencyId avgCpc avgCpm avgPos bidStrategyId clic cost ctr date dfaActions dfaRevenue dfaTransactions dfaAvgActions impr visite
Report sulla campagna: tabella delle campagne	accountId adRotazione adWordsBidStrategy advertiserId agencyId bidStrategyInherited bingAdsBudgetType campaign campaignEndDate campaignEngineId campaignId campaignLabels campaignMobileBid attraverso di aggiustamento campaignStartDate campaignType cityTarget countryBidClickGoals targeti giornalieroBudget deliveryMethod target della strategia efficace
Report sulla campagna: tabella CampaignDeviceStats	accountId adWordsConversionValue adWordsconversions adWordsViewThroughconversions advertiserId agenziaId avgCpc avgCpm avgPos campaignEngineId campaignId clic costo ctr date deviceSegment effectiveBidStrategyId impr visite
Report sulla campagna: tabella CampaignFeedItemStats	accountId adWordsConversionValue adWordsconversions adWordsViewThroughconversions advertiserId agencyId avgCpc avgCpm avgPos campaignEngineId campaignId clicks clicksWithFeedItemReporting cost costWithFeedItemReporting ctr date effectiveStrategy feedId feedId feed
Report sulla campagna: tabella CampaignFloodlightAndDeviceStats	accountId advertiserId agencyId campaignEngineId campaignId date deviceSegment dfaActions dfaRevenue dfaTransactions dfaPersonalizedActions effectiveBidStrategyId FloodlightActivityId FloodlightGroupId
Report sulla campagna: tabella CampaignFloodlightAndFeedItemStats	accountId advertiserId AgencyId campaignEngineId campaignId date dfaActions dfaRevenue dfaTransaction dfaPersonalizedActions effectiveBidStrategyId feedId feedItemId feedType FloodlightActivityId FloodlightGroupId
Report sulla campagna: tabella CampaignFloodtlightAndDeviceStats	accountId advertiserId agencyId campaignEngineId campaignId date deviceSegment dfaActions dfaRevenue dfaTransactions dfaPersonalizedActions effectiveBidStrategyId FloodlightActivityId FloodlightGroupId
Report sulla campagna: tabella CampaignStats	accountId adWordsConversionValue adWordsConversioni adWordsViewThroughConversioni advertiserId agenziaId avgCpc avgCpm avgPos campaignEngineId campaignId clic costo ctr date displayBudgetLostImpressionShare displayImpressionShare in media le visite
Report campaignTarget: tabella CampaignTarget	accountId advertiserId advertiserId campaignId campaignTargetId CreationTimestamp EngineRemarketingList EngineRemarketingListBidModifier lastModifiedTimestamp locationTargetBidModifier locationTargetName status
Report campaignTarget: tabella CampaignTargetDeviceStats	accountId adWordsConversionValue adWordsConversioni adWordsViewThroughConversioni 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 dfaActions dfaRevenue dfaTransactions dfaPersonalizedActions FloodlightActivityId FloodlightGroupId
report sulle conversioni: tabella delle conversioni	account account FloodlightID Floodlight accountType Floodlight IDID FloodlightBibBattibdBboridattive adIdIDIDLID prodotto Floodlight ID FloodlightGroupdBisole di prodotto originale IDIDIDIDimproduttore del prodotto IDID prodotto FloodlightBilancio di prodotto IDIDIDIDelimoggetto di campagna del referrer ID dell'inserzionista ID dell'inserzionista agenzia ID dell'agenzia ID campagna
Report sugli elementi del feed: tabella FeedItem	accountId advertiserId agencyId CreationTimestamp EngineStatus feedId feedItemId lastModifiedTimestamp locationBusinessName locationCategory locationDetails sitelinkClickserverUrl sitelinkDescription1 sitelinkDescription2 sitelinkDisplayText sitelink LandingPageUrl status
Report feedItem: tabella FeedItemFloodlightStats	accountId advertiserId AgencyId date dfaActions dfaRevenue dfaTransactions dfaSupportedActions feedId feedItemId FloodlightActivityId FloodlightGroupId
Report feedItem: tabella FeedItemStats	accountId adWordsConversionValue adWordsConversioni adWordsViewThroughConversioni advertiserId AgencyId avgCpc avgCpm avgPos clic clicksWithFeedItem rendering cost costWithFeedItemReporting ctr date dfaActions dfaRevenue dfa Item id Transazioni feed d'impr.
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 effectiveLabel EngineStatus isDisplayKeyword keywordClickserverUrl KeywordEngineId KeywordId KeywordLabels parola chiavePagina di destinazione parola chiave parola chiave
Report sulle parole chiave: tabella KeywordDeviceStats	accountId adGroupId adId adWordsConversionValue adWordsconversions adWordsViewThroughconversions advertiserId agenziaId avgCpc avgCpm avgPos campaignId clicks cost ctr date deviceSegment currentBidStrategyId impr KeywordEngineId parola chiave
Report sulle parole chiave: tabella KeywordFloodlightAndDeviceStats	accountId adGroupId adId advertiserId rappresentaId campaignId date deviceSegment dfaActions dfaRevenue dfaTransactions dfapossibiliActions effectiveBidStrategyId FloodlightActivityId FloodlightGroupId KeywordEngineId KeywordId
Report sulle parole chiave: tabella KeywordStats	accountId adGroupId advertiserId agenziaId campaignId effectiveBidStrategyId KeywordEngineId KeywordId qualitàScoreAvg topOfPageBidAvg
Report sulle parole chiave escluse del gruppo di annunci: tabella Parole chiave escluse di AdGroup	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 motoreRemarketingList genereTargetGenderType lastModifiedTimestamp locationTargetName negativeCampaignTargetId stato
Report prodotto pubblicizzato: tabella Prodotto pubblicizzato	inserzionistaId agenziaId CreationTimestamp lastModifiedTimestamp prodotto productAgeGroup productAvailability productBrand productCategory productCategoryLevel1 productCategoryLevel2 productCategoryLevel3 productcategoryLevel4 productCategoryLevel5 productChannel productChannelExclusivity productColor productCondition productCostOfGoodsSold product Country product
Report productannunciato: tabella ProductAdvertisingdDeviceStats	adWordsConversionValue adWordsconversions adWordsViewThrough Campaigns IDinserzionista ID agenzia avgCpc avgCpm avgPos clic costo ctr date deviceSegment impr productId visite
Report productannunciato: tabella ProductAdvertisingdFloodlightAndDeviceStats	accountId adGroupId advertiserId agencyId campaignId date deviceSegment dfaActions dfaRevenue dfaTransactions dfapossibiliActions FloodlightActivityId FloodlightGroupId productId
Report gruppo di prodotti: tabella Gruppo di prodotti	accountId adGroupId advertiserId agencyId bidStrategyInherited campaignId CreationTimestamp effectiveBidStrategy effectiveBidStrategyId effectiveLabels effectiveProductGroupMaxCpc EngineStatus lastModifiedTimestamp productGroup productGroupClickserverUrl productGroupId productGroup LandingPage productGroupBidPart productGroupMaxC productGroupBidPartMax
Report gruppo di prodotti: tabella ProductGroupStats	accountId adGroupId adWordsConversionValue adWordsConversioni adWordsViewThroughConversioni advertiserId agenziaId avgCpc avgCpm avgPos campaignId clicks cost ctr date dfaActions dfaRevenue dfaTransactions Strategy CampaignIdActions imprBid Bidding
Report productLeadAndCrossSell: tabella ProductLeadAndCrossSellFloodlightStats	accountdfaUnitId adGroupId advertiserId agencyId campaignId crossSellAverageUnitPrice crossSellCostOfGoodsSold crossSellGrossFromUnitsSold crossSellGrossProfitMargin crossSellRevenueFromUnitsSold crossSellUnitsSold date deviceSegment dfaActions dfa TransactionRevenue
visita Report: tabella visite	account accountId accountType adGroupId adId advertiser advertiserId rappresentanza advertiserId campaignId deviceSegment feedId feedItemId feedType InventoryAccountId KeywordId productChannel productNetwork productGroupId productId productLanguage productStoreId productTargetDateId visita visita, productStoreId productTargetDateId visita

Tabelle delle corrispondenze di Search Ads 360

Le tabelle delle corrispondenze di Search Ads 360 sono tabelle contenenti solo campi Attributo (campi contenenti impostazioni o altri dati fissi) 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