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