Transformación de informes de Google Ad Manager

Cuando tus archivos de transferencia de datos de Google Ad Manager (antes conocido como DoubleClick for Publishers) se transfieren a BigQuery, se transforman en las siguientes tablas y vistas de BigQuery.

Cuando ves las tablas y vistas en BigQuery, el valor de network_code es tu código de red de Google Ad Manager.

Archivo de Google Ad Manager Tablas de BigQuery Vistas de BigQuery
Archivos de 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
Tablas de coincidencia
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
Navegador p_MatchTableBrowser_network_code MatchTableBrowser_network_code
BrowserLanguage p_MatchTableBrowserLanguage_network_code MatchTableBrowserLanguage_network_code
Company 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 (obsoleto) - -
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
Order p_MatchTableOrder_network_code MatchTableOrder_network_code
Posición 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
Usuario p_MatchTableUser_network_code MatchTableUser_network_code