Trasformazione dei rapporti di Google Ad Manager
Quando i file Data Transfer di Google Ad Manager (precedentemente noto come DoubleClick for Publishers) vengono trasferiti in BigQuery, vengono trasformati nelle seguenti tabelle e viste BigQuery.
Quando visualizzi le tabelle e le visualizzazioni in BigQuery, il valore di network_code è il tuo codice di rete Google Ad Manager.
File di Google Ad Manager | Tabelle BigQuery | Viste 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 |
NetworkImpressioni NetworkBackfillImpressions | p_NetworkImpressioni_network_code p_NetworkBackfillImpressioni_network_code | Impressioni di rete_network_code Impressioni di rete di backfill_network_code |
NetworkClicks NetworkBackfillClicks | p_NetworkClicks_network_code p_NetworkBackfillClicks_network_code | Clic di Rete_network_code Clic di Backfill di Rete_network_code |
NetworkActiveViews NetworkBackfillActiveViews | p_NetworkActiveViews_network_code p_NetworkBackfillActiveViews_network_code | ReteActiveViews_network_code NetworkBackfillActiveViews_network_code |
NetworkBackfillBids | p_NetworkBackfillBids_network_code | NetworkBackfillBids_network_code |
NetworkVideoConversion NetworkBackfillVideoConversioni | p_NetworkVideoConversioni_network_code p_NetworkBackfillVideoConversioni_network_code | NetworkVideoConversioni_network_code NetworkBackfillVideoConversioni_network_code |
NetworkRichMediaConversioni NetworkBackfillRichMediaConversioni | p_NetworkRichMediaConversioni_network_code p_NetworkBackfillRichMediaConversioni_network_code | NetworkRichMediaConversioni_network_code NetworkBackfillRichMediaConversioni_network_code |
NetworkActivities | p_NetworkActivities_network_code | NetworkActivities_network_code |
Tabelle delle corrispondenze | ||
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 |