# 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
<var translate="no">network_code</var> 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](https://support.google.com/admanager/answer/1733124)
and
[NetworkBackfillRequests](https://support.google.com/admanager/answer/1733124)

BigQuery tables:
:
    p_NetworkRequests_<var translate="no">network_code</var>  
    p_NetworkBackfillRequests_<var translate="no">network_code</var>

BigQuery views:
:
    NetworkRequests_<var translate="no">network_code</var>  
    NetworkBackfillRequests_<var translate="no">network_code</var>

### Network code serves

Ad Manager files:
[NetworkCodeServes](https://support.google.com/admanager/answer/1733124)
and
[NetworkBackfillCodeServes](https://support.google.com/admanager/answer/1733124)

BigQuery tables:
:
    p_NetworkCodeServes  
    p_NetworkBackfillCodeServes_<var translate="no">network_code</var>

BigQuery views:
:
    NetworkCodeServes  
    NetworkBackfillCodeServes_<var translate="no">network_code</var>

### Network impressions

Ad Manager files:
[NetworkImpressions](https://support.google.com/admanager/answer/1733124)
and
[NetworkBackfillImpressions](https://support.google.com/admanager/answer/1733124)

BigQuery tables:
:
    p_NetworkImpressions_<var translate="no">network_code</var>  
    p_NetworkBackfillImpressions_<var translate="no">network_code</var>

BigQuery views:
:
    NetworkImpressions_<var translate="no">network_code</var>  
    NetworkBackfillImpressions_<var translate="no">network_code</var>

### Network clicks

Ad Manager files:
[NetworkClicks](https://support.google.com/admanager/answer/1733124)
and
[NetworkBackfillClicks](https://support.google.com/admanager/answer/1733124)

BigQuery tables:
:
    p_NetworkClicks_<var translate="no">network_code</var>  
    p_NetworkBackfillClicks_<var translate="no">network_code</var>

BigQuery views:
:
    NetworkClicks_<var translate="no">network_code</var>  
    NetworkBackfillClicks_<var translate="no">network_code</var>

### Network active views

Ad Manager files:
[NetworkActiveViews](https://support.google.com/admanager/answer/1733124)
and
[NetworkBackfillActiveViews](https://support.google.com/admanager/answer/1733124)

BigQuery tables:
:
    p_NetworkActiveViews_<var translate="no">network_code</var>  
    p_NetworkBackfillActiveViews_<var translate="no">network_code</var>

BigQuery views:
:
    NetworkActiveViews_<var translate="no">network_code</var>  
    NetworkBackfillActiveViews_<var translate="no">network_code</var>

### Network backfill bids

Ad Manager file:
[NetworkBackfillBids](https://support.google.com/admanager/answer/1733124)

BigQuery table:
:
    p_NetworkBackfillBids_<var translate="no">network_code</var>

BigQuery view:
:
    NetworkBackfillBids_<var translate="no">network_code</var>

### Network video conversions

Ad Manager files:
[NetworkVideoConversions](https://support.google.com/admanager/answer/1733124)
and
[NetworkBackfillVideoConversions](https://support.google.com/admanager/answer/1733124)

BigQuery tables:
:
    p_NetworkVideoConversions_<var translate="no">network_code</var>  
    p_NetworkBackfillVideoConversions_<var translate="no">network_code</var>

BigQuery views:
:
    NetworkVideoConversions_<var translate="no">network_code</var>  
    NetworkBackfillVideoConversions_<var translate="no">network_code</var>

### Network rich media conversions

Ad Manager files:
[NetworkRichMediaConversions](https://support.google.com/admanager/answer/1733124)
and
[NetworkBackfillRichMediaConversions](https://support.google.com/admanager/answer/1733124)

BigQuery tables:
:
    p_NetworkRichMediaConversions_<var translate="no">network_code</var>  
    p_NetworkBackfillRichMediaConversions_<var translate="no">network_code</var>

BigQuery views:
:
    NetworkRichMediaConversions_<var translate="no">network_code</var>  
    NetworkBackfillRichMediaConversions_<var translate="no">network_code</var>

### Network activities

Ad Manager file:
[NetworkActivities](https://support.google.com/admanager/answer/1733124)

BigQuery table:
:
    p_NetworkActivities_<var translate="no">network_code</var>

BigQuery view:
:
    NetworkActivities_<var translate="no">network_code</var>

## Match tables

The tables in the following sections contain attribute fields and metadata for your account.

### Ad category

Ad Manager file:
[AdCategory](https://developers.google.com/doubleclick-publishers/docs/pqlreference#matchtables)

BigQuery table:
:   p_MatchTableAdCategory_<var translate="no">network_code</var>

BigQuery view:
:   MatchTableAdCategory_<var translate="no">network_code</var>

### Ad unit

Ad Manager file:
[AdUnit](https://developers.google.com/doubleclick-publishers/docs/pqlreference#matchtables)

BigQuery table:
:   p_MatchTableAdUnit_<var translate="no">network_code</var>

BigQuery view:
:   MatchTableAdUnit_<var translate="no">network_code</var>

### Audience segment

Ad Manager file:
[AudienceSegment](https://developers.google.com/doubleclick-publishers/docs/pqlreference#matchtables)

BigQuery table:
:   p_MatchTableAudienceSegment_<var translate="no">network_code</var>

BigQuery view:
:   MatchTableAudienceSegment_<var translate="no">network_code</var>

### Audience segment category

Ad Manager file:
[AudienceSegmentCategory](https://developers.google.com/doubleclick-publishers/docs/pqlreference#matchtables)

BigQuery table:
:   p_MatchTableAudienceSegmentCategory_<var translate="no">network_code</var>

BigQuery view:
:   MatchTableAudienceSegmentCategory_<var translate="no">network_code</var>

### Bandwidth group

Ad Manager file:
[BandwidthGroup](https://developers.google.com/doubleclick-publishers/docs/pqlreference#matchtables)

BigQuery table:
:   p_MatchTableBandwidthGroup_<var translate="no">network_code</var>

BigQuery view:
:   MatchTableBandwidthGroup_<var translate="no">network_code</var>

### Browser

Ad Manager file:
[Browser](https://developers.google.com/doubleclick-publishers/docs/pqlreference#matchtables)

BigQuery table:
:   p_MatchTableBrowser_<var translate="no">network_code</var>

BigQuery view:
:   MatchTableBrowser_<var translate="no">network_code</var>

### Browser language

Ad Manager file:
[BrowserLanguage](https://developers.google.com/doubleclick-publishers/docs/pqlreference#matchtables)

BigQuery table:
:   p_MatchTableBrowserLanguage_<var translate="no">network_code</var>

BigQuery view:
:   MatchTableBrowserLanguage_<var translate="no">network_code</var>

### Company

Ad Manager file:
[Company](https://developers.google.com/doubleclick-publishers/docs/pqlreference#matchtables)

BigQuery table:
:   p_MatchTableCompany_<var translate="no">network_code</var>

BigQuery view:
:   MatchTableCompany_<var translate="no">network_code</var>

### Device capability

Ad Manager file:
[DeviceCapability](https://developers.google.com/doubleclick-publishers/docs/pqlreference#matchtables)

BigQuery table:
:   p_MatchTableDeviceCapability_<var translate="no">network_code</var>

BigQuery view:
:   MatchTableDeviceCapability_<var translate="no">network_code</var>

### Device category

Ad Manager file:
[DeviceCategory](https://developers.google.com/doubleclick-publishers/docs/pqlreference#matchtables)

BigQuery table:
:   p_MatchTableDeviceCategory_<var translate="no">network_code</var>

BigQuery view:
:   MatchTableDeviceCategory_<var translate="no">network_code</var>

### Device manufacturer

Ad Manager file:
[DeviceManufacturer](https://developers.google.com/doubleclick-publishers/docs/pqlreference#matchtables)

BigQuery table:
:   p_MatchTableDeviceManufacturer_<var translate="no">network_code</var>

BigQuery view:
:   MatchTableDeviceManufacturer_<var translate="no">network_code</var>

### Exchange rate (deprecated)

Ad Manager file:
[ExchangeRate](https://developers.google.com/doubleclick-publishers/docs/pqlreference#matchtables)

BigQuery table:
:   None

BigQuery view:
:   None

### Geo target

Ad Manager file:
[GeoTarget](https://developers.google.com/doubleclick-publishers/docs/pqlreference#matchtables)

BigQuery table:
:   p_MatchTableGeoTarget_<var translate="no">network_code</var>

BigQuery view:
:   MatchTableGeoTarget_<var translate="no">network_code</var>

### Line item

Ad Manager file:
[LineItem](https://developers.google.com/doubleclick-publishers/docs/pqlreference#matchtables)

BigQuery table:
:   p_MatchTableLineItem_<var translate="no">network_code</var>

BigQuery view:
:   MatchTableLineItem_<var translate="no">network_code</var>

### Mobile carrier

Ad Manager file:
[MobileCarrier](https://developers.google.com/doubleclick-publishers/docs/pqlreference#matchtables)

BigQuery table:
:   p_MatchTableMobileCarrier_<var translate="no">network_code</var>

BigQuery view:
:   MatchTableMobileCarrier_<var translate="no">network_code</var>

### Mobile device

Ad Manager file:
[MobileDevice](https://developers.google.com/doubleclick-publishers/docs/pqlreference#matchtables)

BigQuery table:
:   p_MatchTableMobileDevice_<var translate="no">network_code</var>

BigQuery view:
:   MatchTableMobileDevice_<var translate="no">network_code</var>

### Mobile device submodel

Ad Manager file:
[MobileDeviceSubmodel](https://developers.google.com/doubleclick-publishers/docs/pqlreference#matchtables)

BigQuery table:
:   p_MatchTableMobileDeviceSubmodel_<var translate="no">network_code</var>

BigQuery view:
:   MatchTableMobileDeviceSubmodel_<var translate="no">network_code</var>

### Operating system

Ad Manager file:
[OperatingSystem](https://developers.google.com/doubleclick-publishers/docs/pqlreference#matchtables)

BigQuery table:
:   p_MatchTableOperatingSystem_<var translate="no">network_code</var>

BigQuery view:
:   MatchTableOperatingSystem_<var translate="no">network_code</var>

### Operating system version

Ad Manager file:
[OperatingSystemVersion](https://developers.google.com/doubleclick-publishers/docs/pqlreference#matchtables)

BigQuery table:
:   p_MatchTableOperatingSystemVersion_<var translate="no">network_code</var>

BigQuery view:
:   MatchTableOperatingSystemVersion_<var translate="no">network_code</var>

### Order

Ad Manager file:
[Order](https://developers.google.com/doubleclick-publishers/docs/pqlreference#matchtables)

BigQuery table:
:   p_MatchTableOrder_<var translate="no">network_code</var>

BigQuery view:
:   MatchTableOrder_<var translate="no">network_code</var>

### Placement

Ad Manager file:
[Placement](https://developers.google.com/doubleclick-publishers/docs/pqlreference#matchtables)

BigQuery table:
:   p_MatchTablePlacement_<var translate="no">network_code</var>

BigQuery view:
:   MatchTablePlacement_<var translate="no">network_code</var>

### Programmatic buyer

Ad Manager file:
[ProgrammaticBuyer](https://developers.google.com/doubleclick-publishers/docs/pqlreference#matchtables)

BigQuery table:
:   p_MatchTableProgrammaticBuyer_<var translate="no">network_code</var>

BigQuery view:
:   MatchTableProgrammaticBuyer_<var translate="no">network_code</var>

### Third-party company

Ad Manager file:
[ThirdPartyCompany](https://developers.google.com/doubleclick-publishers/docs/pqlreference#matchtables)

BigQuery table:
:   p_MatchTableThirdPartyCompany_<var translate="no">network_code</var>

BigQuery view:
:   MatchTableThirdPartyCompany_<var translate="no">network_code</var>

### Time zone

Ad Manager file:
[TimeZone](https://developers.google.com/doubleclick-publishers/docs/pqlreference#matchtables)

BigQuery table:
:   p_MatchTableTimeZone_<var translate="no">network_code</var>

BigQuery view:
:   MatchTableTimeZone_<var translate="no">network_code</var>

### User

Ad Manager file:
[User](https://developers.google.com/doubleclick-publishers/docs/pqlreference#matchtables)

BigQuery table:
:   p_MatchTableUser_<var translate="no">network_code</var>

BigQuery view:
:   MatchTableUser_<var translate="no">network_code</var>