Google Ad Manager report transformation
When your Google Ad Manager (formerly known as DoubleClick for Publishers) data transfer files are transferred to BigQuery, the files are transformed into the following BigQuery tables and views.
When you view the tables and views in BigQuery, the value for network_code is your Google Ad Manager network code.
Google Ad Manager file | BigQuery table(s) | BigQuery view(s) |
---|---|---|
Data Transfer files
|
||
p_NetworkRequests_ network_code p_NetworkBackfillRequests_ network_code | NetworkRequests_ network_code NetworkBackfillRequests_ network_code | |
p_NetworkCodeServes p_NetworkBackfillCodeServes_ network_code | NetworkCodeServes NetworkBackfillCodeServes_ network_code | |
p_NetworkImpressions_ network_code p_NetworkBackfillImpressions_ network_code | NetworkImpressions_ network_code NetworkBackfillImpressions_ network_code | |
p_NetworkClicks_ network_code p_NetworkBackfillClicks_ network_code | NetworkClicks_ network_code NetworkBackfillClicks_ network_code | |
p_NetworkActiveViews_ network_code p_NetworkBackfillActiveViews_ network_code | NetworkActiveViews_ network_code NetworkBackfillActiveViews_ network_code | |
p_NetworkBackfillBids_ network_code | NetworkBackfillBids_ network_code | |
p_NetworkVideoConversions_ network_code p_NetworkBackfillVideoConversions_ network_code | NetworkVideoConversions_ network_code NetworkBackfillVideoConversions_ network_code | |
p_NetworkRichMediaConversions_ network_code p_NetworkBackfillRichMediaConversions_ network_code | NetworkRichMediaConversions_ network_code NetworkBackfillRichMediaConversions_ network_code | |
p_NetworkActivities_ network_code | NetworkActivities_ network_code | |
Match Tables
|
||
p_MatchTableAdCategory_ network_code | MatchTableAdCategory_ network_code | |
p_MatchTableAdUnit_ network_code | MatchTableAdUnit_ network_code | |
p_MatchTableAudienceSegment_ network_code | MatchTableAudienceSegment_ network_code | |
p_MatchTableAudienceSegmentCategory_ network_code | MatchTableAudienceSegmentCategory_ network_code | |
p_MatchTableBandwidthGroup_ network_code | MatchTableBandwidthGroup_ network_code | |
p_MatchTableBrowser_ network_code | MatchTableBrowser_ network_code | |
p_MatchTableBrowserLanguage_ network_code | MatchTableBrowserLanguage_ network_code | |
p_MatchTableCompany_ network_code | MatchTableCompany_ network_code | |
p_MatchTableDeviceCapability_ network_code | MatchTableDeviceCapability_ network_code | |
p_MatchTableDeviceCategory_ network_code | MatchTableDeviceCategory_ network_code | |
p_MatchTableDeviceManufacturer_ network_code | MatchTableDeviceManufacturer_ network_code | |
ExchangeRate
(deprecated)
|
- | - |
p_MatchTableGeoTarget_ network_code | MatchTableGeoTarget_ network_code | |
p_MatchTableLineItem_ network_code | MatchTableLineItem_ network_code | |
p_MatchTableMobileCarrier_ network_code | MatchTableMobileCarrier_ network_code | |
p_MatchTableMobileDevice_ network_code | MatchTableMobileDevice_ network_code | |
p_MatchTableMobileDeviceSubmodel_ network_code | MatchTableMobileDeviceSubmodel_ network_code | |
p_MatchTableOperatingSystem_ network_code | MatchTableOperatingSystem_ network_code | |
p_MatchTableOperatingSystemVersion_ network_code | MatchTableOperatingSystemVersion_ network_code | |
p_MatchTableOrder_ network_code | MatchTableOrder_ network_code | |
p_MatchTablePlacement_ network_code | MatchTablePlacement_ network_code | |
p_MatchTableProgrammaticBuyer_ network_code | MatchTableProgrammaticBuyer_ network_code | |
p_MatchTableProposalRetractionReason_ network_code | MatchTableProposalRetractionReason_ network_code | |
p_MatchTableThirdPartyCompany_ network_code | MatchTableThirdPartyCompany_ network_code | |
p_MatchTableTimeZone_ network_code | MatchTableTimeZone_ network_code | |
p_MatchTableUser_ network_code | MatchTableUser_ network_code |