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 BigQuery tables and views described in this document.
When you view the tables and views in BigQuery, the value for network_code is your Ad Manager network code.
Data transfer files
The reports in the following sections provide detailed information about your Ad Manager network activity.
Network requests
Ad Manager files: NetworkRequests and NetworkBackfillRequests
- BigQuery tables:
- p_NetworkRequests_ network_code
p_NetworkBackfillRequests_ network_code - BigQuery views:
- NetworkRequests_ network_code
NetworkBackfillRequests_ network_code
Network code serves
Ad Manager files: NetworkCodeServes and NetworkBackfillCodeServes
- BigQuery tables:
- p_NetworkCodeServes
p_NetworkBackfillCodeServes_ network_code - BigQuery views:
- NetworkCodeServes
NetworkBackfillCodeServes_ network_code
Network impressions
Ad Manager files: NetworkImpressions and NetworkBackfillImpressions
- BigQuery tables:
- p_NetworkImpressions_ network_code
p_NetworkBackfillImpressions_ network_code - BigQuery views:
- NetworkImpressions_ network_code
NetworkBackfillImpressions_ network_code
Network clicks
Ad Manager files: NetworkClicks and NetworkBackfillClicks
- BigQuery tables:
- p_NetworkClicks_ network_code
p_NetworkBackfillClicks_ network_code - BigQuery views:
- NetworkClicks_ network_code
NetworkBackfillClicks_ network_code
Network active views
Ad Manager files: NetworkActiveViews and NetworkBackfillActiveViews
- BigQuery tables:
- p_NetworkActiveViews_ network_code
p_NetworkBackfillActiveViews_ network_code - BigQuery views:
- NetworkActiveViews_ network_code
NetworkBackfillActiveViews_ network_code
Network backfill bids
Ad Manager file: NetworkBackfillBids
- BigQuery table:
- p_NetworkBackfillBids_ network_code
- BigQuery view:
- NetworkBackfillBids_ network_code
Network video conversions
Ad Manager files: NetworkVideoConversions and NetworkBackfillVideoConversions
- BigQuery tables:
- p_NetworkVideoConversions_ network_code
p_NetworkBackfillVideoConversions_ network_code - BigQuery views:
- NetworkVideoConversions_ network_code
NetworkBackfillVideoConversions_ network_code
Network rich media conversions
Ad Manager files: NetworkRichMediaConversions and NetworkBackfillRichMediaConversions
- BigQuery tables:
- p_NetworkRichMediaConversions_ network_code
p_NetworkBackfillRichMediaConversions_ network_code - BigQuery views:
- NetworkRichMediaConversions_ network_code
NetworkBackfillRichMediaConversions_ network_code
Network activities
Ad Manager file: NetworkActivities
- BigQuery table:
- p_NetworkActivities_ network_code
- BigQuery view:
- NetworkActivities_ network_code
Match tables
The tables in the following sections contain attribute fields and metadata for your account.
Ad category
Ad Manager file: AdCategory
- BigQuery table:
- p_MatchTableAdCategory_ network_code
- BigQuery view:
- MatchTableAdCategory_ network_code
Ad unit
Ad Manager file: AdUnit
- BigQuery table:
- p_MatchTableAdUnit_ network_code
- BigQuery view:
- MatchTableAdUnit_ network_code
Audience segment
Ad Manager file: AudienceSegment
- BigQuery table:
- p_MatchTableAudienceSegment_ network_code
- BigQuery view:
- MatchTableAudienceSegment_ network_code
Audience segment category
Ad Manager file: AudienceSegmentCategory
- BigQuery table:
- p_MatchTableAudienceSegmentCategory_ network_code
- BigQuery view:
- MatchTableAudienceSegmentCategory_ network_code
Bandwidth group
Ad Manager file: BandwidthGroup
- BigQuery table:
- p_MatchTableBandwidthGroup_ network_code
- BigQuery view:
- MatchTableBandwidthGroup_ network_code
Browser
Ad Manager file: Browser
- BigQuery table:
- p_MatchTableBrowser_ network_code
- BigQuery view:
- MatchTableBrowser_ network_code
Browser language
Ad Manager file: BrowserLanguage
- BigQuery table:
- p_MatchTableBrowserLanguage_ network_code
- BigQuery view:
- MatchTableBrowserLanguage_ network_code
Company
Ad Manager file: Company
- BigQuery table:
- p_MatchTableCompany_ network_code
- BigQuery view:
- MatchTableCompany_ network_code
Device capability
Ad Manager file: DeviceCapability
- BigQuery table:
- p_MatchTableDeviceCapability_ network_code
- BigQuery view:
- MatchTableDeviceCapability_ network_code
Device category
Ad Manager file: DeviceCategory
- BigQuery table:
- p_MatchTableDeviceCategory_ network_code
- BigQuery view:
- MatchTableDeviceCategory_ network_code
Device manufacturer
Ad Manager file: DeviceManufacturer
- BigQuery table:
- p_MatchTableDeviceManufacturer_ network_code
- BigQuery view:
- MatchTableDeviceManufacturer_ network_code
Exchange rate (deprecated)
Ad Manager file: ExchangeRate
- BigQuery table:
- None
- BigQuery view:
- None
Geo target
Ad Manager file: GeoTarget
- BigQuery table:
- p_MatchTableGeoTarget_ network_code
- BigQuery view:
- MatchTableGeoTarget_ network_code
Line item
Ad Manager file: LineItem
- BigQuery table:
- p_MatchTableLineItem_ network_code
- BigQuery view:
- MatchTableLineItem_ network_code
Mobile carrier
Ad Manager file: MobileCarrier
- BigQuery table:
- p_MatchTableMobileCarrier_ network_code
- BigQuery view:
- MatchTableMobileCarrier_ network_code
Mobile device
Ad Manager file: MobileDevice
- BigQuery table:
- p_MatchTableMobileDevice_ network_code
- BigQuery view:
- MatchTableMobileDevice_ network_code
Mobile device submodel
Ad Manager file: MobileDeviceSubmodel
- BigQuery table:
- p_MatchTableMobileDeviceSubmodel_ network_code
- BigQuery view:
- MatchTableMobileDeviceSubmodel_ network_code
Operating system
Ad Manager file: OperatingSystem
- BigQuery table:
- p_MatchTableOperatingSystem_ network_code
- BigQuery view:
- MatchTableOperatingSystem_ network_code
Operating system version
Ad Manager file: OperatingSystemVersion
- BigQuery table:
- p_MatchTableOperatingSystemVersion_ network_code
- BigQuery view:
- MatchTableOperatingSystemVersion_ network_code
Order
Ad Manager file: Order
- BigQuery table:
- p_MatchTableOrder_ network_code
- BigQuery view:
- MatchTableOrder_ network_code
Placement
Ad Manager file: Placement
- BigQuery table:
- p_MatchTablePlacement_ network_code
- BigQuery view:
- MatchTablePlacement_ network_code
Programmatic buyer
Ad Manager file: ProgrammaticBuyer
- BigQuery table:
- p_MatchTableProgrammaticBuyer_ network_code
- BigQuery view:
- MatchTableProgrammaticBuyer_ network_code
Proposal retraction reason
Ad Manager file: ProposalRetractionReason
- BigQuery table:
- p_MatchTableProposalRetractionReason_ network_code
- BigQuery view:
- MatchTableProposalRetractionReason_ network_code
Third-party company
Ad Manager file: ThirdPartyCompany
- BigQuery table:
- p_MatchTableThirdPartyCompany_ network_code
- BigQuery view:
- MatchTableThirdPartyCompany_ network_code
Time zone
Ad Manager file: TimeZone
- BigQuery table:
- p_MatchTableTimeZone_ network_code
- BigQuery view:
- MatchTableTimeZone_ network_code
User
Ad Manager file: User
- BigQuery table:
- p_MatchTableUser_ network_code
- BigQuery view:
- MatchTableUser_ network_code
