Trasformazione dei rapporti di Google Ad Manager

Quando i file di trasferimento dei dati di Google Ad Manager (in precedenza DoubleClick for Publishers) vengono trasferiti a BigQuery, vengono trasformati nelle seguenti tabelle e viste BigQuery.

Quando visualizzi le tabelle e le viste in BigQuery, il valore di network_code è il codice di rete di Google Ad Manager.

File Google Ad Manager Tabella o tabelle BigQuery Visualizzazioni BigQuery
File Data Transfer
NetworkRequests NetworkBackfillRequests p_NetworkRequests_network_code p_NetworkBackfillRequests_network_code NetworkRequests_network_code NetworkBackfillRequests_network_code
NetworkCodeServes NetworkBackfillCodeServes p_NetworkCodeServes p_NetworkBackfillCodeServes_network_code NetworkCodeServes NetworkBackfillCodeServes_network_code
NetworkImpressions NetworkBackfillImpressions p_NetworkImpressions_network_code p_NetworkBackfillImpressions_network_code NetworkImpressions_network_code NetworkBackfillImpressions_network_code
NetworkClicks NetworkBackfillClicks p_NetworkClicks_network_code p_NetworkBackfillClicks_network_code NetworkClicks_network_code NetworkBackfillClicks_network_code
NetworkActiveViews NetworkBackfillActiveViews p_NetworkActiveViews_network_code p_NetworkBackfillActiveViews_network_code NetworkActiveViews_network_code NetworkBackfillActiveViews_network_code
NetworkBackfillBids p_NetworkBackfillBids_network_code NetworkBackfillBids_network_code
NetworkVideoConversions NetworkBackfillVideoConversions p_NetworkVideoConversions_network_code p_NetworkBackfillVideoConversions_network_code NetworkVideoConversions_network_code NetworkBackfillVideoConversions_network_code
NetworkRichMediaConversions NetworkBackfillRichMediaConversions p_NetworkRichMediaConversions_network_code p_NetworkBackfillRichMediaConversions_network_code NetworkRichMediaConversions_network_code NetworkBackfillRichMediaConversions_network_code
NetworkActivities p_NetworkActivities_network_code NetworkActivities_network_code
Associa tabelle
AdCategory p_MatchTableAdCategory_network_code MatchTableAdCategory_network_code
AdUnit p_MatchTableAdUnit_network_code MatchTableAdUnit_network_code
AudienceSegment p_MatchTableAudienceSegment_network_code MatchTableAudienceSegment_network_code
AudienceSegmentCategory p_MatchTableAudienceSegmentCategory_network_code MatchTableAudienceSegmentCategory_network_code
BandwidthGroup p_MatchTableBandwidthGroup_network_code MatchTableBandwidthGroup_network_code
Browser p_MatchTableBrowser_network_code MatchTableBrowser_network_code
BrowserLanguage p_MatchTableBrowserLanguage_network_code MatchTableBrowserLanguage_network_code
Azienda p_MatchTableCompany_network_code MatchTableCompany_network_code
DeviceCapability p_MatchTableDeviceCapability_network_code MatchTableDeviceCapability_network_code
DeviceCategory p_MatchTableDeviceCategory_network_code MatchTableDeviceCategory_network_code
DeviceManufacturer p_MatchTableDeviceManufacturer_network_code MatchTableDeviceManufacturer_network_code
ExchangeRate (deprecato) - -
GeoTarget p_MatchTableGeoTarget_network_code MatchTableGeoTarget_network_code
LineItem p_MatchTableLineItem_network_code MatchTableLineItem_network_code
MobileCarrier p_MatchTableMobileCarrier_network_code MatchTableMobileCarrier_network_code
MobileDevice p_MatchTableMobileDevice_network_code MatchTableMobileDevice_network_code
MobileDeviceSubmodel p_MatchTableMobileDeviceSubmodel_network_code MatchTableMobileDeviceSubmodel_network_code
OperatingSystem p_MatchTableOperatingSystem_network_code MatchTableOperatingSystem_network_code
OperatingSystemVersion p_MatchTableOperatingSystemVersion_network_code MatchTableOperatingSystemVersion_network_code
Ordine p_MatchTableOrder_network_code MatchTableOrder_network_code
Posizionamento p_MatchTablePlacement_network_code MatchTablePlacement_network_code
ProgrammaticBuyer p_MatchTableProgrammaticBuyer_network_code MatchTableProgrammaticBuyer_network_code
ProposalRetractionReason p_MatchTableProposalRetractionReason_network_code MatchTableProposalRetractionReason_network_code
ThirdPartyCompany p_MatchTableThirdPartyCompany_network_code MatchTableThirdPartyCompany_network_code
TimeZone p_MatchTableTimeZone_network_code MatchTableTimeZone_network_code
User p_MatchTableUser_network_code MatchTableUser_network_code