Reminder: v201705 will be sunset on May 31, 2018.

type ReportQuery (v201802)

A ReportQuery object allows you to specify the selection criteria for generating a report. Only reports with at least one Column are supported.


Namespace
https://www.google.com/apis/ads/publisher/v201802

Field

dimensions

Dimension[]

The list of break-down types being requested in the report. The generated report will contain the dimensions in the same order as requested. This field is required.


Enumerations
MONTH_AND_YEAR
Breaks down reporting data by month and year in the network time zone. Can be used to filter on month using ISO 4601 format 'YYYY-MM'.

Note: In v201802 and later, this dimension is compatible with the following time zone types:

  • TimeZoneType.PUBLISHER
  • TimeZoneType.PROPOSAL_LOCAL

Corresponds to "Month and year" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SELL_THROUGH, REACH, SALES, PARTNER_FINANCE, SAMPLED_HISTORICAL.

WEEK
Breaks down reporting data by week of the year in the network time zone. Cannot be used for filtering.

Note: In v201802 and later, this dimension is compatible with the following time zone types:

  • TimeZoneType.PUBLISHER
  • TimeZoneType.PROPOSAL_LOCAL

Corresponds to "Week" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SELL_THROUGH, REACH, SALES, DATA_LEAKAGE, SAMPLED_HISTORICAL.

DATE
Breaks down reporting data by date in the network time zone. Can be used to filter by date using ISO 8601's format 'YYYY-MM-DD'".

Note: In v201802 and later, this dimension is compatible with the following time zone types:

  • TimeZoneType.PUBLISHER
  • TimeZoneType.PROPOSAL_LOCAL

Corresponds to "Date" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SELL_THROUGH, REACH, SALES, BUSINESS_INTELLIGENCE, DFP_HISTORICAL_DATA_STUDIO, SAMPLED_HISTORICAL.

DAY
Breaks down reporting data by day of the week in the network time zone. Can be used to filter by day of the week using the index of the day (from 1 for Monday is 1 to 7 for Sunday).

Corresponds to "Day of week" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SELL_THROUGH, REACH, SALES, SAMPLED_HISTORICAL.

HOUR
Breaks down reporting data by hour of the day in the network time zone. Can be used to filter by hour of the day (from 0 to 23).

Corresponds to "Hour" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH, SAMPLED_HISTORICAL.

LINE_ITEM_ID
Breaks down reporting data by LineItem.id. Can be used to filter by LineItem.id.

Compatible with any of the following report types: HISTORICAL, SELL_THROUGH, REACH, SALES, DATA_LEAKAGE, SAMPLED_HISTORICAL.

LINE_ITEM_NAME
Breaks down reporting data by line item. LineItem.name and LineItem.id are automatically included as columns in the report. Can be used to filter by LineItem.name.

Corresponds to "Line item" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SELL_THROUGH, REACH, SALES, DATA_LEAKAGE, DFP_HISTORICAL_DATA_STUDIO, SAMPLED_HISTORICAL.

LINE_ITEM_TYPE
Breaks down reporting data by LineItem.lineItemType. Can be used to filter by line item type using LineItemType enumeration names.

Corresponds to "Line item type" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SELL_THROUGH, REACH, DATA_LEAKAGE, DFP_HISTORICAL_DATA_STUDIO, SAMPLED_HISTORICAL.

AGGREGATED_DEMAND_CHANNEL
Breaks down reporting data by aggregated demand channel type.

This field is deprecated and will be removed in v201805.

Compatible with any of the following report types: HISTORICAL, REACH, SAMPLED_HISTORICAL.

ORDER_ID
Breaks down reporting data by Order.id. Can be used to filter by Order.id.

Compatible with any of the following report types: HISTORICAL, SELL_THROUGH, REACH, SALES, DATA_LEAKAGE, SAMPLED_HISTORICAL.

ORDER_NAME
Breaks down reporting data by order. Order.name and Order.id are automatically included as columns in the report. Can be used to filter by Order.name.

Corresponds to "Order" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SELL_THROUGH, REACH, SALES, DATA_LEAKAGE, DFP_HISTORICAL_DATA_STUDIO, SAMPLED_HISTORICAL.

ORDER_DELIVERY_STATUS
Delivery status of the order. Not available as a dimension to report on, but exists as a dimension in order to filter on it using PQL. Valid values are 'STARTED', 'NOT_STARTED' and 'COMPLETED'.

Compatible with any of the following report types: HISTORICAL, REACH, SAMPLED_HISTORICAL.

ADVERTISER_ID
Breaks down reporting data by advertising company Company.id. Can be used to filter by Company.id.

Compatible with any of the following report types: HISTORICAL, SELL_THROUGH, REACH, SALES, DATA_LEAKAGE, SAMPLED_HISTORICAL.

ADVERTISER_NAME
Breaks down reporting data by advertising company. Company.name and Company.id are automatically included as columns in the report. Can be used to filter by Company.name.

Corresponds to "Advertiser" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SELL_THROUGH, REACH, SALES, DATA_LEAKAGE, DFP_HISTORICAL_DATA_STUDIO, SAMPLED_HISTORICAL.

AD_NETWORK_ID
The network that provided the ad for SDK ad mediation.

If selected for a report, that report will include only SDK mediation ads and will not contain non-SDK mediation ads.

SDK mediation ads are ads for mobile devices. They have a list of ad networks which can provide ads to serve. Not every ad network will have an ad to serve so the device will try each network one-by-one until it finds an ad network with an ad to serve. The ad network that ends up serving the ad will appear here. Note that this id does not correlate to anything in the companies table and is not the same id as is served by ADVERTISER_ID.

Compatible with any of the following report types: HISTORICAL, REACH, SAMPLED_HISTORICAL.

AD_NETWORK_NAME
The name of the network defined in AD_NETWORK_ID.

Corresponds to "Ad network name" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH.

SALESPERSON_ID
Breaks down reporting data by salesperson User.id. Can be used to filter by User.id.

Compatible with any of the following report types: HISTORICAL, SELL_THROUGH, REACH, SALES, DATA_LEAKAGE, SAMPLED_HISTORICAL.

SALESPERSON_NAME
Breaks down reporting data by salesperson. User.name and User.id of the salesperson are automatically included as columns in the report. Can be used to filter by User.name.

Corresponds to "Salesperson" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SELL_THROUGH, REACH, SALES, DATA_LEAKAGE, SAMPLED_HISTORICAL.

CREATIVE_ID
Breaks down reporting data by Creative.id or creative set id (master's Creative.id) if the creative is part of a creative set. Can be used to filter by Creative.id.

Compatible with any of the following report types: HISTORICAL, REACH, DATA_LEAKAGE, SAMPLED_HISTORICAL.

CREATIVE_NAME
Breaks down reporting data by creative. Creative.name and Creative.id are automatically included as columns in the report. Can be used to filter by Creative.name.

Corresponds to "Creative" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH, DATA_LEAKAGE, DFP_HISTORICAL_DATA_STUDIO, SAMPLED_HISTORICAL.

CREATIVE_TYPE
Breaks down reporting data by creative type.

Corresponds to "Creative type" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH, SAMPLED_HISTORICAL.

CREATIVE_BILLING_TYPE
Breaks down reporting data by creative billing type.

Corresponds to "Creative billing type" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH, SAMPLED_HISTORICAL.

CUSTOM_EVENT_ID
Breaks down reporting data by custom event ID.

Compatible with any of the following report types: HISTORICAL, REACH, SAMPLED_HISTORICAL.

CUSTOM_EVENT_NAME
Breaks down reporting data by custom event name.

Corresponds to "Custom event" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH, SAMPLED_HISTORICAL.

CUSTOM_EVENT_TYPE
Breaks down reporting data by custom event type (timer/exit/counter).

Corresponds to "Custom event type" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH, SAMPLED_HISTORICAL.

CREATIVE_SIZE
Breaks down reporting data by Creative.size. Cannot be used for filtering.

Corresponds to "Creative size" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH, BUSINESS_INTELLIGENCE, SAMPLED_HISTORICAL.

AD_UNIT_ID
Breaks down reporting data by AdUnit.id. Can be used to filter by AdUnit.id. AD_UNIT_NAME, i.e. AdUnit.name, is automatically included as a dimension in the report.

Compatible with any of the following report types: HISTORICAL, SELL_THROUGH, REACH, SALES, BUSINESS_INTELLIGENCE, SAMPLED_HISTORICAL.

AD_UNIT_NAME
Breaks down reporting data by ad unit. AdUnit.name and AdUnit.id are automatically included as columns in the report. Can be used to filter by AdUnit.name.

Corresponds to "Ad unit" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SELL_THROUGH, REACH, SALES, BUSINESS_INTELLIGENCE, DFP_HISTORICAL_DATA_STUDIO, SAMPLED_HISTORICAL.

PARENT_AD_UNIT_ID
Used to filter on all the descendants of an ad unit by AdUnit.id. Not available as a dimension to report on.

Compatible with any of the following report types: HISTORICAL, SELL_THROUGH, REACH, SALES, BUSINESS_INTELLIGENCE, SAMPLED_HISTORICAL.

PARENT_AD_UNIT_NAME
Used to filter on all the descendants of an ad unit by AdUnit.name. Not available as a dimension to report on.

Compatible with any of the following report types: HISTORICAL, SELL_THROUGH, REACH, SALES, BUSINESS_INTELLIGENCE, SAMPLED_HISTORICAL.

PLACEMENT_ID
Breaks down reporting data by Placement.id. Can be used to filter by Placement.id.

Compatible with any of the following report types: HISTORICAL, SELL_THROUGH, REACH, SAMPLED_HISTORICAL.

PLACEMENT_NAME
Breaks down reporting data by placement. Placement.name and Placement.id are automatically included as columns in the report. Can be used to filter by Placement.name.

Corresponds to "Placement" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SELL_THROUGH, REACH, DFP_HISTORICAL_DATA_STUDIO, SAMPLED_HISTORICAL.

PLACEMENT_STATUS
Status of the placement. Not available as a dimension to report on, but exists as a dimension in order to filter on it using PQL. Can be used to filter on Placement.status by using InventoryStatus enumeration names.

Compatible with any of the following report types: HISTORICAL, SELL_THROUGH, REACH, SAMPLED_HISTORICAL.

TARGETING
Breaks down reporting data by criteria predefined by DoubleClick For Publishers like the operating system, browser etc. Cannot be used for filtering.

Corresponds to "Targeting" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH.

DEVICE_CATEGORY_ID
The ID of the device category to which an ad is being targeted. Can be used to filter by device category ID.

Compatible with any of the following report types: HISTORICAL, REACH, SAMPLED_HISTORICAL.

DEVICE_CATEGORY_NAME
The category of device (smartphone, feature phone, tablet, or desktop) to which an ad is being targeted. Can be used to filter by device category name.

Corresponds to "Device category" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH, DFP_HISTORICAL_DATA_STUDIO, SAMPLED_HISTORICAL.

COUNTRY_CRITERIA_ID
Breaks down reporting data by country criteria ID. Can be used to filter by country criteria ID.

Compatible with any of the following report types: HISTORICAL, SELL_THROUGH, REACH, SAMPLED_HISTORICAL.

COUNTRY_NAME
Breaks down reporting data by country name. The country name and the country criteria ID are automatically included as columns in the report. Can be used to filter by country name using the US English name.

Corresponds to "Country" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SELL_THROUGH, REACH, DFP_HISTORICAL_DATA_STUDIO, SAMPLED_HISTORICAL.

REGION_CRITERIA_ID
Breaks down reporting data by region criteria ID. Can be used to filter by region criteria ID.

Compatible with any of the following report types: HISTORICAL, REACH, SAMPLED_HISTORICAL.

REGION_NAME
Breaks down reporting data by region name. The region name and the region criteria ID are automatically included as columns in the report. Can be used to filter by region name using the US English name.

Corresponds to "Region" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH, SAMPLED_HISTORICAL.

CITY_CRITERIA_ID
Breaks down reporting data by city criteria ID. Can be used to filter by city criteria ID.

Compatible with any of the following report types: HISTORICAL, REACH, SAMPLED_HISTORICAL.

CITY_NAME
Breaks down reporting data by city name. The city name and the city criteria ID are automatically included as columns in the report. Can be used to filter by city name using the US English name.

Corresponds to "City" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH, DFP_HISTORICAL_DATA_STUDIO, SAMPLED_HISTORICAL.

METRO_CRITERIA_ID
Breaks down reporting data by metro criteria ID. Can be used to filter by metro criteria ID.

Compatible with any of the following report types: HISTORICAL, REACH, SAMPLED_HISTORICAL.

METRO_NAME
Breaks down reporting data by metro name. The metro name and the metro criteria ID are automatically included as columns in the report. Can be used to filter by metro name using the US English name.

Corresponds to "Metro" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH, SAMPLED_HISTORICAL.

POSTAL_CODE_CRITERIA_ID
Breaks down reporting data by postal code criteria ID. Can be used to filter by postal code criteria ID.

Compatible with any of the following report types: HISTORICAL, REACH, SAMPLED_HISTORICAL.

POSTAL_CODE
Breaks down reporting data by postal code. The postal code and the postal code criteria ID are automatically included as columns in the report. Can be used to filter by postal code.

Corresponds to "Postal code" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH.

CUSTOM_TARGETING_VALUE_ID
Breaks down reporting data by CustomTargetingValue.id. Can be used to filter by CustomTargetingValue.id.

Compatible with any of the following report types: HISTORICAL, REACH, SALES.

CUSTOM_CRITERIA
Breaks down reporting data by custom criteria. The CustomTargetingValue is displayed in the form: CUSTOM_TARGETING_VALUE_ID, i.e. CustomTargetingValue.id is automatically included as a column in the report. Cannot be used for filtering; use CUSTOM_TARGETING_VALUE_ID instead.

When using this Dimension, metrics for freeform key values are only reported on when they are registered with CustomTargetingService.

Corresponds to "Key-values" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH, SALES.

ACTIVITY_ID
Breaks down reporting data by activity ID. Can be used to filter by activity ID.

Compatible with any of the following report types: HISTORICAL, REACH.

ACTIVITY_NAME
Breaks down reporting data by activity. The activity name and the activity ID are automatically included as columns in the report. Can be used to filter by activity name.

Corresponds to "Activity" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH.

ACTIVITY_GROUP_ID
Breaks down reporting data by activity group ID. Can be used to filter by activity group ID.

Compatible with any of the following report types: HISTORICAL, REACH.

ACTIVITY_GROUP_NAME
Breaks down reporting data by activity group. The activity group name and the activity group ID are automatically included as columns in the report. Can be used to filter by activity group name.

Corresponds to "Activity group" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH.

CONTENT_ID
Breaks down reporting data by Content.id. Can be used to filter by Content.id.

Compatible with any of the following report types: HISTORICAL, SELL_THROUGH, REACH, SAMPLED_HISTORICAL.

CONTENT_NAME
Breaks down reporting data by content. Content.name and Content.id are automatically included as columns in the report. Can be used to filter by Content.name.

Corresponds to "Content" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SELL_THROUGH, REACH, SAMPLED_HISTORICAL.

CONTENT_BUNDLE_ID
Breaks down reporting data by ContentBundle.id. Can be used to filter by ContentBundle.id.

Compatible with any of the following report types: HISTORICAL, SELL_THROUGH, REACH, SAMPLED_HISTORICAL.

CONTENT_BUNDLE_NAME
Breaks down reporting data by content bundle. ContentBundle.name and ContentBundle.id are automatically included as columns in the report. Can be used to filter by ContentBundle.name.

Corresponds to "Content bundle" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SELL_THROUGH, REACH, SAMPLED_HISTORICAL.

CONTENT_HIERARCHY
Breaks down reporting data by the content hierarchy. To use this dimension, a list of custom targeting key IDs must be specified in ReportQuery.contentMetadataKeyHierarchyCustomTargetingKeyIds.

This dimension can be used as a filter in the Statement in PQL syntax: CONTENT_HIERARCHY_CUSTOM_TARGETING_KEY[contentMetadataKeyHierarchyCustomTargetingKeyId]_ID = custom targeting value ID

For example: WHERE CONTENT_HIERARCHY_CUSTOM_TARGETING_KEY[4242]_ID = 53423

VIDEO_FALLBACK_POSITION
Breaks down reporting data by the fallback position of the video ad, i.e., NON_FALLBACK, FALLBACK_POSITION_1, FALLBACK_POSITION_2, etc. Can be used for filtering.

Corresponds to "Fallback position" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH, SAMPLED_HISTORICAL.

POSITION_OF_POD
Breaks down reporting data by the position of the video ad within the video stream, i.e., UNKNOWN_POSITION, PREROLL, POSTROLL, UNKNOWN_MIDROLL, MIDROLL_1, MIDROLL_2, etc. UNKNOWN_MIDROLL represents a midroll, but which specific midroll is unknown. Can be used for filtering.

Corresponds to "Position of pod" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SELL_THROUGH, REACH, SAMPLED_HISTORICAL.

POSITION_IN_POD
Breaks down reporting data by the position of the video ad within the pod, i.e., UNKNOWN_POSITION, POSITION_1, POSITION_2, etc. Can be used for filtering.

Corresponds to "Position in pod" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH, SAMPLED_HISTORICAL.

PARTNER_MANAGEMENT_PARTNER_ID
Breaks down reporting data by partner Company.id.

Compatible with any of the following report types: HISTORICAL, REACH, PARTNER_FINANCE.

PARTNER_MANAGEMENT_PARTNER_NAME
Breaks down reporting data by partner Company.name and Company.id are automatically included as columns in the report.

Corresponds to "Partner" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH, PARTNER_FINANCE.

PARTNER_MANAGEMENT_PARTNER_LABEL_ID
Breaks down reporting data by partner label Label.id.

Compatible with any of the following report types: HISTORICAL, REACH, PARTNER_FINANCE.

PARTNER_MANAGEMENT_PARTNER_LABEL_NAME
Breaks down reporting data by partner label. Label.name and Label.id are automatically included as columns in the report.

Corresponds to "Partner label" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH, PARTNER_FINANCE.

PARTNER_MANAGEMENT_ASSIGNMENT_ID
Breaks down reporting data by partner assignment id.

Compatible with any of the following report types: HISTORICAL, REACH, PARTNER_FINANCE.

PARTNER_MANAGEMENT_ASSIGNMENT_NAME
Breaks down reporting data by partner assignment name. ParnterAssignment name and id are automatically included as columns in the report.

Corresponds to "Assignment" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH, PARTNER_FINANCE.

GRP_DEMOGRAPHICS
Breaks down reporting data by gender and age group, i.e., MALE_13_TO_17, MALE_18_TO_24, MALE_25_TO_34, MALE_35_TO_44, MALE_45_TO_54, MALE_55_TO_64, MALE_65_PLUS, FEMALE_13_TO_17, FEMALE_18_TO_24, FEMALE_25_TO_34, FEMALE_35_TO_44, FEMALE_45_TO_54, FEMALE_55_TO_64, FEMALE_65_PLUS, UNKNOWN_0_TO_17 and UNKNOWN. Whenever this dimension is selected, COUNTRY_NAME must be selected.

This dimension is supported only for GRP columns.

Can correspond to any of the following in the DFP UI: Demographics, comScore vCE demographics. Compatible with any of the following report types: HISTORICAL, REACH.

AD_REQUEST_SIZE
Size of the creative requested for an ad.

Corresponds to "Ad request size" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH.

AD_REQUEST_AD_UNIT_SIZES
Breaks down reporting data by the ad unit sizes specified in ad requests.

Formatted as comma separated values, e.g. "300x250,300x250v,300x60".

This dimension is supported only for sell-through columns.

Corresponds to "Ad request sizes" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SELL_THROUGH, REACH.

AD_REQUEST_CUSTOM_CRITERIA
Breaks down reporting data by the custom criteria specified in ad requests.

Formatted as comma separated key-values, where a key-value is formatted as key1=value_1|...|value_n,key2=value_1|...|value_n,....

This dimension is supported only for sell-through columns.

Corresponds to "Key-values" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SELL_THROUGH, REACH.

BUYER_ID
The unique identifier used for an ad network that is associated with the company that the ad is served for.

Compatible with any of the following report types: BUSINESS_INTELLIGENCE, SAMPLED_HISTORICAL.

BUYER_NAME
The name of the ad network that is associated with the company that the ad is served for.

Corresponds to "Buyer" in the DFP UI. Compatible with any of the following report types: BUSINESS_INTELLIGENCE, SAMPLED_HISTORICAL.

IS_FIRST_LOOK_DEAL
Whether the report contains only Ad Exchange traffic fulfilled by First Look Deals or omits it. If this filter isn't included, the report will include First Look Deals traffic in addition to any other traffic. Not available as a dimension to report on.

Compatible with any of the following report types: HISTORICAL, REACH, SAMPLED_HISTORICAL.

MEDIATION_GROUP_ID
Breaks down reporting data by mediation group ID. A mediation group is an abstraction of inventory used in the DFP Mediation.

This field is deprecated and will be removed in v201805.

Compatible with any of the following report types: HISTORICAL, REACH, SAMPLED_HISTORICAL.

MEDIATION_GROUP_NAME
Breaks down reporting data by mediation group name. A mediation group is an abstraction of inventory used in the DFP Mediation.

This field is deprecated and will be removed in v201805.

Compatible with any of the following report types: HISTORICAL, REACH, SAMPLED_HISTORICAL.

YIELD_GROUP_ID
Breaks down reporting data by yield group ID.

Compatible with any of the following report types: HISTORICAL, REACH.

YIELD_GROUP_NAME
Breaks down reporting data by yield group name.

Corresponds to "Yield group" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH.

YIELD_PARTNER
Breaks down reporting data by yield partner.

Corresponds to "Yield partner" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH, DFP_HISTORICAL_DATA_STUDIO.

YIELD_PARTNER_TAG
Breaks down reporting data by the tag of a yield partner in a yield group.

Corresponds to "Yield partner tag" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH.

MEDIATION_NETWORK
Breaks down mapped Ad Exchange web property data by mediation network.

This field is deprecated and will be removed in v201805.

Compatible with any of the following report types: HISTORICAL, REACH, SAMPLED_HISTORICAL.

MEDIATION_NETWORK_TAG
Breaks down mapped Ad Exchange web property data by Ad Exchange network tag name.

This field is deprecated and will be removed in v201805.

Compatible with any of the following report types: HISTORICAL, REACH, SAMPLED_HISTORICAL.

MEDIATION_TYPE
Breaks down reporting data by mediation type. A mediation type can be web, mobile app or video.

Corresponds to "Mediation type" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH, SAMPLED_HISTORICAL.

NATIVE_TEMPLATE_ID
Breaks down reporting data by native template (also known as creative template) ID.

Compatible with any of the following report types: HISTORICAL, REACH, SAMPLED_HISTORICAL.

NATIVE_TEMPLATE_NAME
Breaks down reporting data by native template (also known as creative template) name.

Corresponds to "Native ad format name" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH, SAMPLED_HISTORICAL.

NATIVE_STYLE_ID
Breaks down reporting data by native style ID.

Compatible with any of the following report types: HISTORICAL, REACH, SAMPLED_HISTORICAL.

NATIVE_STYLE_NAME
Breaks down reporting data by native style name.

Corresponds to "Native style name" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH, SAMPLED_HISTORICAL.

MOBILE_APP_NAME
Breaks down reporting data by mobile app name. Can be used for filtering.

Corresponds to "App names" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH, DFP_HISTORICAL_DATA_STUDIO, SAMPLED_HISTORICAL.

MOBILE_DEVICE_NAME
Breaks down reporting data by device name. Can be used for filtering.

Corresponds to "Devices" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH, DFP_HISTORICAL_DATA_STUDIO, SAMPLED_HISTORICAL.

MOBILE_INVENTORY_TYPE
Breaks down reporting data by inventory type. Can be used for filtering.

Corresponds to "Inventory types" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH, DFP_HISTORICAL_DATA_STUDIO, SAMPLED_HISTORICAL.

REQUEST_TYPE
Breaks down reporting data by request type. Can be used for filtering.

Corresponds to "Request type" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH, DFP_HISTORICAL_DATA_STUDIO, SAMPLED_HISTORICAL.

VERIFIED_ADVERTISER_ID
ID of the advertiser that filled the ad either directly (through DFP) or indirectly via Google Ad Exchange or another ad network or exchange.

Compatible with any of the following report types: BUSINESS_INTELLIGENCE, SAMPLED_HISTORICAL.

VERIFIED_ADVERTISER_NAME
Name of the advertiser that filled the ad either directly (through DFP) or indirectly via Google Ad Exchange or another ad network or exchange.

Corresponds to "Verified advertiser" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH, SAMPLED_HISTORICAL.

AD_UNIT_STATUS
Status of the ad unit. Not available as a dimension to report on, but exists as a dimension in order to filter on it using PQL. Valid values correspond to InventoryStatus.

Compatible with any of the following report types: HISTORICAL, SELL_THROUGH, REACH, SAMPLED_HISTORICAL.

MASTER_COMPANION_CREATIVE_ID
Breaks down reporting data by Creative.id. This includes regular creatives, and master and companions in case of creative sets.

Compatible with any of the following report types: HISTORICAL, REACH, SAMPLED_HISTORICAL.

MASTER_COMPANION_CREATIVE_NAME
Breaks down reporting data by creative. This includes regular creatives, and master and companions in case of creative sets.

Corresponds to "Master and Companion creative" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH, DFP_HISTORICAL_DATA_STUDIO, SAMPLED_HISTORICAL.

PROPOSAL_LINE_ITEM_ID
Breaks down reporting data by ProposalLineItem.id. Can be used to filter by ProposalLineItem.id.

Compatible with any of the following report types: HISTORICAL, SELL_THROUGH, REACH, SALES, SAMPLED_HISTORICAL.

PROPOSAL_LINE_ITEM_NAME
Breaks down reporting data by ProposalLineItem.name. Can be used to filter by ProposalLineItem.name.

Corresponds to "Proposal line item" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SELL_THROUGH, REACH, SALES, SAMPLED_HISTORICAL.

PROPOSAL_ID
Breaks down reporting data by Proposal.id. Can be used to filter by Proposal.id.

Compatible with any of the following report types: HISTORICAL, SELL_THROUGH, REACH, SALES, SAMPLED_HISTORICAL.

PROPOSAL_NAME
Breaks down reporting data by Proposal.name. Can be used to filter by Proposal.name.

Corresponds to "Proposal" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SELL_THROUGH, REACH, SALES, SAMPLED_HISTORICAL.

ALL_SALESPEOPLE_ID
Breaks down reporting data by salesperson User.id, including both salesperson and secondary salespeople. Can be used to filter by all salespeople User.id.

Compatible with any of the following report types: HISTORICAL, REACH, SALES, SAMPLED_HISTORICAL.

ALL_SALESPEOPLE_NAME
Breaks down reporting data by salesperson User.name, including both salesperson and secondary salespeople. Can be used to filter by all salespeople User.name.

Corresponds to "All salespeople" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH, SALES, SAMPLED_HISTORICAL.

SALES_TEAM_ID
Used to filter by User.id in sales team. Sales team includes salesperson, secondary salesperson, sales planners. Not available as a dimension to report on.

Compatible with any of the following report types: HISTORICAL, REACH, SALES, SAMPLED_HISTORICAL.

SALES_TEAM_NAME
Used to filter by User.name in sales team. Sales team includes salesperson, secondary salesperson, sales planners. Not available as a dimension to report on.

Compatible with any of the following report types: HISTORICAL, REACH, SALES, SAMPLED_HISTORICAL.

PROPOSAL_AGENCY_ID
Breaks down reporting data by proposal agency Company.id. Can be used to filter by proposal agency Company.id.

Compatible with any of the following report types: HISTORICAL, REACH, SALES, SAMPLED_HISTORICAL.

PROPOSAL_AGENCY_NAME
Breaks down reporting data by proposal agency Company.name. Can be used to filter by proposal agency Company.name.

Corresponds to "Proposal agency" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH, SALES, SAMPLED_HISTORICAL.

PRODUCT_ID
Breaks down reporting data by Product.id. Can be used to filter by Product.id.

Compatible with any of the following report types: HISTORICAL, REACH, SALES, SAMPLED_HISTORICAL.

PRODUCT_NAME
Breaks down reporting data by Product.name.

Corresponds to "Product" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH, SALES, SAMPLED_HISTORICAL.

PRODUCT_TEMPLATE_ID
Breaks down reporting data by ProductTemplate.id. Can be used to filter by ProductTemplate.id.

Compatible with any of the following report types: HISTORICAL, REACH, SALES, SAMPLED_HISTORICAL.

PRODUCT_TEMPLATE_NAME
Breaks down reporting data by ProductTemplate.name. Can be used to filter by ProductTemplate.name.

Corresponds to "Product template" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH, SALES, SAMPLED_HISTORICAL.

RATE_CARD_ID
Breaks down reporting data by RateCard.id. Can be used to filter by RateCard.id.

Compatible with any of the following report types: HISTORICAL, REACH, SALES, SAMPLED_HISTORICAL.

RATE_CARD_NAME
Breaks down reporting data by RateCard.name. Can be used to filter by RateCard.name.

Corresponds to "Rate card" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH, SALES, SAMPLED_HISTORICAL.

WORKFLOW_ID
Used to filter by Workflow.id. Not available as a dimension to report on.

Compatible with any of the following report types: HISTORICAL, REACH, SALES, SAMPLED_HISTORICAL.

WORKFLOW_NAME
Used to filter by Workflow.name. Not available as a dimension to report on.

Compatible with any of the following report types: HISTORICAL, REACH, SALES, SAMPLED_HISTORICAL.

PACKAGE_ID
Breaks down reporting data by Package.id.

Compatible with any of the following report types: HISTORICAL, REACH, SALES, SAMPLED_HISTORICAL.

PACKAGE_NAME
Breaks down reporting data by Package.name.

Corresponds to "Package" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH, SALES, SAMPLED_HISTORICAL.

PRODUCT_PACKAGE_ID
Breaks down reporting data by ProductPackage.id. Can be used to filter by ProductPackage.id.

Compatible with any of the following report types: HISTORICAL, REACH, SALES, SAMPLED_HISTORICAL.

PRODUCT_PACKAGE_NAME
Breaks down reporting data by ProductPackage.name. Can be used to filter by ProductPackage.name.

Corresponds to "Product package" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH, SALES, SAMPLED_HISTORICAL.

AUDIENCE_SEGMENT_ID
Breaks down reporting data by billable audience segment ID.

Compatible with any of the following report types: HISTORICAL, REACH.

AUDIENCE_SEGMENT_NAME
Breaks down reporting data by billable audience segment name.

Corresponds to "Audience segment (billable)" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH.

AUDIENCE_SEGMENT_DATA_PROVIDER_NAME
Breaks down reporting data by audience segment data provider name.

Corresponds to "Data partner" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH.

AD_EXCHANGE_INVENTORY_SIZE
Breaks down mapped Ad Exchange web property data by Ad Exchange inventory size.

Corresponds to "Inventory sizes" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_INVENTORY_SIZE_CODE
Breaks down mapped Ad Exchange web property data by Ad Exchange inventory size code.

Compatible with any of the following report types: HISTORICAL, REACH.

AD_EXCHANGE_DEVICE_CATEGORY
Breaks down mapped Ad Exchange web property data by Ad Exchange device category.

Corresponds to "Device categories" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_PRICING_RULE_ID
Breaks down mapped Ad Exchange web property data by Ad Exchange pricing rule ID.

Compatible with any of the following report types: HISTORICAL, REACH.

AD_EXCHANGE_PRICING_RULE_NAME
Breaks down mapped Ad Exchange web property data by Ad Exchange pricing rule.

Corresponds to "Pricing rules" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_TAG_NAME
Breaks down mapped Ad Exchange web property data by Ad Exchange tag.

Corresponds to "Tags" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_URL
Breaks down mapped Ad Exchange web property data by Ad Exchange URL.

Corresponds to "URLs" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_WEB_PROPERTY_CODE
Breaks down data by Ad Exchange mapped web property code.

Compatible with any of the following report types: HISTORICAL, REACH.

AD_EXCHANGE_CREATIVE_SIZES
Breaks down mapped Ad Exchange web property data by Ad Exchange creative size.

Corresponds to "Creative sizes" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_AD_TYPE
Breaks down mapped Ad Exchange web property data by Ad Exchange ad type.

Corresponds to "Ad Types" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_CHANNEL_NAME
Breaks down mapped Ad Exchange web property data by Ad Exchange channel.

Corresponds to "Channels" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_PRODUCT_NAME
Breaks down mapped Ad Exchange web property data by Ad Exchange product.

Corresponds to "Products" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_PRODUCT_CODE
Breaks down mapped Ad Exchange web property data by Ad Exchange product code.

Compatible with any of the following report types: HISTORICAL, REACH.

AD_EXCHANGE_SITE_NAME
Breaks down mapped Ad Exchange web property data by Ad Exchange site.

Corresponds to "Sites" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_REQUEST_SOURCES
Breaks down mapped Ad Exchange web property data by Ad Exchange request source.

Corresponds to "Request sources" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_ADVERTISER_NAME
Breaks down mapped Ad Exchange web property data by the Ad Exchange advertiser name that bids on ads.

Corresponds to "Advertisers" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_BRAND_NAME
Breaks down mapped Ad Exchange web property data by the Ad Exchange brand name that bids on ads.

Corresponds to "Brands" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_AGENCY
Breaks down mapped Ad Exchange web property data by Ad Exchange agency.

Corresponds to "Agencies" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_BID_TYPE_CODE
Breaks down mapped Ad Exchange web property data by Ad Exchange bid type code.

Compatible with any of the following report types: HISTORICAL, REACH.

AD_EXCHANGE_BRANDING_TYPE_CODE
Breaks down mapped Ad Exchange web property data by Ad Exchange branding type code.

Compatible with any of the following report types: HISTORICAL, REACH.

AD_EXCHANGE_BRANDING_TYPE
Breaks down mapped Ad Exchange web property data by Ad Exchange branding type. Examples: Branded, Anonymous.

Corresponds to "Branding types" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_BUYER_NETWORK_NAME
Breaks down mapped Ad Exchange web property data by Ad Exchange ad network name. Example: Google Adwords.

Corresponds to "Buyer networks" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_BUYER_NETWORK_ID
Breaks down mapped Ad Exchange web property data by Ad Exchange ad network ID.

Compatible with any of the following report types: HISTORICAL, REACH.

AD_EXCHANGE_CUSTOM_CHANNEL_CODE
Breaks down mapped Ad Exchange web property data by Ad Exchange custom channel code.

Compatible with any of the following report types: HISTORICAL, REACH.

AD_EXCHANGE_CUSTOM_CHANNEL_ID
Breaks down mapped Ad Exchange web property data by Ad Exchange custom channel ID.

Compatible with any of the following report types: HISTORICAL, REACH.

AD_EXCHANGE_DATE
Breaks down mapped Ad Exchange web property data by Ad Exchange date, in Ad Exchange timezone.

Note: In v201802 and later, this dimension is compatible with the following time zone types:

  • TimeZoneType.AD_EXCHANGE

Corresponds to "Days" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_DEAL_ID
Breaks down mapped Ad Exchange web property data by Ad Exchange deal id.

Corresponds to "Deal IDs" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_DEAL_NAME
Breaks down mapped Ad Exchange web property data by Ad Exchange deal name.

Corresponds to "Deal names" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_TRANSACTION_TYPE
Breaks down mapped Ad Exchange web property data by Ad Exchange deal/transaction type. Example: Open auction.

Corresponds to "Transaction types" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_DSP_BUYER_NETWORK_NAME
Breaks down mapped Ad Exchange web property data by Ad Exchange DSP buyer network name.

Corresponds to "DSPs" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_EXPANSION_TYPE
Breaks down mapped Ad Exchange web property data by Ad Exchange expansion type.

Corresponds to "Expandable types" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_COUNTRY_CODE
Breaks down mapped Ad Exchange web property data by Ad Exchange country code.

Compatible with any of the following report types: HISTORICAL, REACH.

AD_EXCHANGE_COUNTRY_NAME
Breaks down mapped Ad Exchange web property data by Ad Exchange country name.

Corresponds to "Countries" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_DFP_AD_UNIT_ID
Breaks down mapped Ad Exchange web property data by Ad Exchange DFP ad unit ID.

Compatible with any of the following report types: HISTORICAL, REACH.

AD_EXCHANGE_DFP_AD_UNIT
Breaks down mapped Ad Exchange web property data by Ad Exchange DFP ad unit.

Corresponds to "DFP Ad Units" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_INVENTORY_OWNERSHIP
Breaks down mapped Ad Exchange web property data by Ad Exchange inventory ownership.

Corresponds to "Inventory ownership" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_ADVERTISER_DOMAIN
Breaks down mapped Ad Exchange web property data by Ad Exchange advertiser domain.

Corresponds to "Advertiser domains" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_MOBILE_APP_NAME
Breaks down mapped Ad Exchange web property data by Ad Exchange mobile app name.

Corresponds to "App names" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_MOBILE_CARRIER_NAME
Breaks down mapped Ad Exchange web property data by Ad Exchange mobile carrier name.

Corresponds to "Carrier names" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_MOBILE_DEVICE_NAME
Breaks down mapped Ad Exchange web property data by Ad Exchange mobile device name.

Corresponds to "Devices" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_MOBILE_INVENTORY_TYPE
Breaks down mapped Ad Exchange web property data by Ad Exchange mobile inventory type.

Corresponds to "Inventory types" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_MONTH
Breaks down mapped Ad Exchange web property data by Ad Exchange month, in Ad Exchange timezone.

Note: In v201802 and later, this dimension is compatible with the following time zone types:

  • TimeZoneType.AD_EXCHANGE

Corresponds to "Months" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_NETWORK_PARTNER_NAME
Breaks down mapped Ad Exchange web property data by Ad Exchange network partner name.

Corresponds to "Network partner names" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_OPERATING_SYSTEM
Breaks down mapped Ad Exchange web property data by Ad Exchange operating system version.

Corresponds to "Operating systems" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_TAG_CODE
Breaks down mapped Ad Exchange web property data by Ad Exchange tags.

Compatible with any of the following report types: HISTORICAL, REACH.

AD_EXCHANGE_TARGETING_TYPE_CODE
Breaks down mapped Ad Exchange web property data by Ad Exchange targeting type code.

Compatible with any of the following report types: HISTORICAL, REACH.

AD_EXCHANGE_TARGETING_TYPE
Breaks down mapped Ad Exchange web property data by Ad Exchange targeting type.

Corresponds to "Targeting types" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_TRANSACTION_TYPE_CODE
Breaks down mapped Ad Exchange web property data by Ad Exchange transaction type code

Compatible with any of the following report types: HISTORICAL, REACH.

AD_EXCHANGE_URL_ID
Breaks down mapped Ad Exchange web property data by Ad Exchange URL ID.

Compatible with any of the following report types: HISTORICAL, REACH.

AD_EXCHANGE_USER_BANDWIDTH_NAME
Breaks down mapped Ad Exchange web property data by Ad Exchange user bandwidth.

Corresponds to "Bandwidth" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_VIDEO_AD_DURATION
Breaks down mapped Ad Exchange web property data by Ad Exchange video ad duration.

Compatible with any of the following report types: HISTORICAL, REACH.

AD_EXCHANGE_VIDEO_AD_DURATION_RAW
Breaks down mapped Ad Exchange web property data by Ad Exchange raw video ad duration.

Corresponds to "Video ad durations" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_VIDEO_AD_TYPE
Breaks down mapped Ad Exchange web property data by Ad Exchange video ad type.

Corresponds to "Video ad types" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_WEEK
Breaks down mapped Ad Exchange web property data by Ad Exchange week, in Ad Exchange timezone.

Note: In v201802 and later, this dimension is compatible with the following time zone types:

  • TimeZoneType.AD_EXCHANGE

Corresponds to "Weeks" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_AD_LOCATION
Breaks down mapped Ad Exchange web property data by Ad Exchange ad location.

Corresponds to "Ad locations" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_ADVERTISER_VERTICAL
Breaks down mapped Ad Exchange web property data by Ad Exchange advertiser vertical.

Corresponds to "Advertiser verticals" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

NIELSEN_SEGMENT
Campaign date segment of Nielsen Digital Ad Ratings reporting.

Corresponds to "Nielsen Digital Ad Ratings segment" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH.

NIELSEN_DEMOGRAPHICS
Breaks down reporting data by gender and age group, i.e., MALE_18_TO_20, MALE_21_TO_24, MALE_25_TO_29, MALE_30_TO_35, MALE_35_TO_39, MALE_40_TO_44, MALE_45_TO_49, MALE_50_TO_54, MALE_55_TO_64, MALE_65_PLUS, FEMALE_18_TO_20, FEMALE_21_TO_24, FEMALE_25_TO_29, FEMALE_30_TO_34, FEMALE_35_TO_39, FEMALE_40_TO_44, FEMALE_45_TO_49, FEMALE_50_TO_54, FEMALE_55_TO_64, FEMALE_65_PLUS, and OTHER.
NIELSEN_RESTATEMENT_DATE
Data restatement date of Nielsen Digital Ad Ratings data.

Corresponds to "Nielsen Digital Ad Ratings restatement date" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH.

PROGRAMMATIC_BUYER_ID
Breaks down reporting data by ProposalMarketplaceInfo.buyerAccountId.

Compatible with any of the following report types: HISTORICAL, REACH, SALES, SAMPLED_HISTORICAL.

PROGRAMMATIC_BUYER_NAME
Breaks down reporting data by programmatic buyer name.

Corresponds to "Programmatic buyer" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH, SALES, SAMPLED_HISTORICAL.

REQUESTED_AD_SIZES
Breaks down reporting data by requested ad size(s). This can be a chain of sizes or a single size.

Corresponds to "Requested ad sizes" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH, DFP_HISTORICAL_DATA_STUDIO, SAMPLED_HISTORICAL.

CREATIVE_SIZE_DELIVERED
Breaks down reporting data by the creative size the ad was delivered to.

Corresponds to "Creative size (delivered)" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH, DFP_HISTORICAL_DATA_STUDIO, SAMPLED_HISTORICAL.

DEMAND_CHANNEL_ID
Breaks down reporting data by demand channels.

Compatible with any of the following report types: HISTORICAL, REACH, SAMPLED_HISTORICAL.

DEMAND_CHANNEL_NAME
Breaks down reporting data by demand channel name.

Corresponds to "Demand channel" in the DFP UI. Compatible with any of the following report types: HISTORICAL, REACH, DFP_HISTORICAL_DATA_STUDIO, SAMPLED_HISTORICAL.

adUnitView

ReportQuery.AdUnitView

The ad unit view for the report. Defaults to AdUnitView.TOP_LEVEL.


Enumerations
TOP_LEVEL
Only the top level ad units. Metrics include events for their descendants that are not filtered out.
FLAT
All the ad units. Metrics do not include events for the descendants.
HIERARCHICAL
Use the ad unit hierarchy. There will be as many ad unit columns as levels of ad units in the generated report:
  • The column Dimension.AD_UNIT_NAME is replaced with columns "Ad unit 1", "Ad unit 2", ... "Ad unit n". If level is not applicable to a row, "N/A" is returned as the value.
  • The column Dimension.AD_UNIT_ID is replaced with columns "Ad unit ID 1", "Ad unit ID 2", ... "Ad unit ID n". If level is not applicable to a row, "N/A" is returned as the value.

Metrics do not include events for the descendants.

columns

Column[]

The list of trafficking statistics and revenue information being requested in the report. The generated report will contain the columns in the same order as requested. This field is required.


Enumerations
AD_SERVER_IMPRESSIONS
The number of impressions delivered by the ad server.

Corresponds to "Ad server impressions" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE, SAMPLED_HISTORICAL.

AD_SERVER_DOWNLOADED_IMPRESSIONS
The number of downloaded impressions delivered by the ad server.

Corresponds to "Ad server downloaded impressions" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE, SAMPLED_HISTORICAL.

AD_SERVER_TARGETED_IMPRESSIONS
The number of impressions delivered by the ad server by explicit custom criteria targeting.

Corresponds to "Ad server targeted impressions" in the DFP UI. Compatible with the HISTORICAL report type.

AD_SERVER_CLICKS
The number of clicks delivered by the ad server.

Corresponds to "Ad server clicks" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE, SAMPLED_HISTORICAL.

AD_SERVER_TARGETED_CLICKS
The number of clicks delivered by the ad server by explicit custom criteria targeting.

Corresponds to "Ad server targeted clicks" in the DFP UI. Compatible with the HISTORICAL report type.

AD_SERVER_CTR
The CTR for an ad delivered by the ad server.

Corresponds to "Ad server CTR" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE, SAMPLED_HISTORICAL.

AD_SERVER_CPM_AND_CPC_REVENUE
The CPM and CPC revenue earned, calculated in publisher currency, for the ads delivered by the ad server.

Corresponds to "Ad server CPM and CPC revenue" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE, SAMPLED_HISTORICAL.

AD_SERVER_CPD_REVENUE
The CPD revenue earned, calculated in publisher currency, for the ads delivered by the ad server.

Corresponds to "Ad server CPD revenue" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

AD_SERVER_CPA_REVENUE
The CPA revenue earned, calculated in publisher currency, for the ads delivered by the ad server.

Corresponds to "CPA revenue" in the DFP UI. Compatible with the HISTORICAL report type.

AD_SERVER_ALL_REVENUE
The CPM, CPC and CPD revenue earned, calculated in publisher currency, for the ads delivered by the ad server.

Can correspond to any of the following in the DFP UI: Ad server CPM, CPC, CPD, and vCPM revenue, Ad server CPM, CPC and CPD revenue. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

AD_SERVER_WITHOUT_CPD_AVERAGE_ECPM
The average estimated cost-per-thousand-impressions earned from the CPM and CPC ads delivered by the ad server.

Corresponds to "Ad server average eCPM" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE, SAMPLED_HISTORICAL.

AD_SERVER_WITH_CPD_AVERAGE_ECPM
The average estimated cost-per-thousand-impressions earned from the CPM, CPC and CPD ads delivered by the ad server.
AD_SERVER_INVENTORY_LEVEL_PERCENT_IMPRESSIONS
The ratio of the number of impressions delivered to the total impressions delivered when no LineItem reservation could be found by the ad server for inventory-level dynamic allocation. For premium networks, this includes line item-level dynamic allocation as well. Represented as a percentage.

Corresponds to "Ad server impressions (%)" in the DFP UI. Compatible with the HISTORICAL report type.

AD_SERVER_LINE_ITEM_LEVEL_PERCENT_IMPRESSIONS
The ratio of the number of impressions delivered to the total impressions delivered by the ad server for line item-level dynamic allocation. Represented as a percentage.

Corresponds to "Ad server impressions (%)" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

AD_SERVER_INVENTORY_LEVEL_PERCENT_CLICKS
The ratio of the number of clicks delivered to the total clicks delivered when no LineItem reservation could be found by the ad server for inventory-level dynamic allocation. For premium networks, this includes line item-level dynamic allocation as well. Represented as a percentage.

Corresponds to "Ad server clicks (%)" in the DFP UI. Compatible with the HISTORICAL report type.

AD_SERVER_LINE_ITEM_LEVEL_PERCENT_CLICKS
The ratio of the number of clicks delivered to the total clicks delivered by the ad server for line item-level dynamic allocation. Represented as a percentage.

Corresponds to "Ad server clicks (%)" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

AD_SERVER_INVENTORY_LEVEL_WITHOUT_CPD_PERCENT_REVENUE
The ratio of revenue generated by ad server to the total CPM and CPC revenue earned by ads delivered when no LineItem reservation could be found by the ad server for inventory-level dynamic allocation. For premium networks, this includes line item-level dynamic allocation as well. Represented as a percentage.

Corresponds to "Ad server revenue (%)" in the DFP UI. Compatible with the HISTORICAL report type.

AD_SERVER_INVENTORY_LEVEL_WITH_CPD_PERCENT_REVENUE
The ratio of revenue generated by ad server to the total CPM, CPC and CPD revenue earned by ads delivered when no LineItem reservation could be found by the ad server for inventory-level dynamic allocation. For premium networks, this includes line item-level dynamic allocation as well. Represented as a percentage.
AD_SERVER_LINE_ITEM_LEVEL_WITHOUT_CPD_PERCENT_REVENUE
The ratio of revenue generated by ad server to the total CPM and CPC revenue earned by the ads delivered for line item-level dynamic allocation. Represented as a percentage.

Corresponds to "Ad server revenue (%)" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

AD_SERVER_LINE_ITEM_LEVEL_WITH_CPD_PERCENT_REVENUE
The ratio of revenue generated by ad server to the total CPM, CPC and CPD revenue earned by the ads delivered for line item-level dynamic allocation. Represented as a percentage.
AD_SERVER_CODE_SERVED_COUNT
The number of times that the code for an ad is served by the ad server.

Corresponds to "Ad server code served count" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE, SAMPLED_HISTORICAL.

AD_SERVER_UNFILTERED_IMPRESSIONS
The number of downloaded impressions delivered by the ad server including impressions recognized as spam.

Corresponds to "Ad server unfiltered downloaded impressions" in the DFP UI. Compatible with the HISTORICAL report type.

AD_SERVER_UNFILTERED_CLICKS
The number of clicks delivered by the ad server including clicks recognized as spam.

Corresponds to "Ad server unfiltered clicks" in the DFP UI. Compatible with the HISTORICAL report type.

DYNAMIC_ALLOCATION_INVENTORY_LEVEL_IMPRESSIONS
The number of impressions a dynamic allocation ad delivered when no LineItem reservation could be found by the ad server for inventory-level dynamic allocation. For premium networks, this includes line item-level dynamic allocation as well.

Can correspond to any of the following in the DFP UI: AdSense / Ad Exchange impressions, AdSense impressions. Compatible with the HISTORICAL report type.

ADSENSE_LINE_ITEM_LEVEL_IMPRESSIONS
The number of impressions an AdSense ad delivered for line item-level dynamic allocation.

Corresponds to "AdSense impressions" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

ADSENSE_LINE_ITEM_LEVEL_TARGETED_IMPRESSIONS
The number of impressions an AdSense ad delivered for line item-level dynamic allocation by explicit custom criteria targeting.

Corresponds to "AdSense targeted impressions" in the DFP UI. Compatible with the HISTORICAL report type.

DYNAMIC_ALLOCATION_INVENTORY_LEVEL_CLICKS
The number of clicks a dynamic allocation ad delivered when no LineItem reservation could be found by the ad server for inventory-level dynamic allocation. For premium networks, this includes line item-level dynamic allocation as well.

Can correspond to any of the following in the DFP UI: AdSense / Ad Exchange clicks, AdSense clicks. Compatible with the HISTORICAL report type.

ADSENSE_LINE_ITEM_LEVEL_CLICKS
The number of clicks an AdSense ad delivered for line item-level dynamic allocation.

Corresponds to "AdSense clicks" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

ADSENSE_LINE_ITEM_LEVEL_TARGETED_CLICKS
The number of clicks an AdSense ad delivered for line item-level dynamic allocation by explicit custom criteria targeting.

Corresponds to "AdSense targeted clicks" in the DFP UI. Compatible with the HISTORICAL report type.

DYNAMIC_ALLOCATION_INVENTORY_LEVEL_CTR
The ratio of clicks a dynamic allocation ad delivered to the number of impressions it delivered when no LineItem reservation could be found by the ad server for inventory-level dynamic allocation. For premium networks, this includes line item-level dynamic allocation as well.

Can correspond to any of the following in the DFP UI: AdSense / Ad Exchange CTR, AdSense CTR. Compatible with the HISTORICAL report type.

ADSENSE_LINE_ITEM_LEVEL_CTR
The ratio of clicks an AdSense reservation ad delivered to the number of impressions it delivered, including line item-level dynamic allocation.

Corresponds to "AdSense CTR" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

DYNAMIC_ALLOCATION_INVENTORY_LEVEL_REVENUE
Revenue generated from ads delivered for dynamic allocation when no LineItem reservation could be found by the ad server for inventory-level dynamic allocation. For premium networks, this includes line item-level dynamic allocation as well.

Can correspond to any of the following in the DFP UI: AdSense / Ad Exchange revenue, AdSense revenue. Compatible with the HISTORICAL report type.

ADSENSE_LINE_ITEM_LEVEL_REVENUE
Revenue generated from AdSense ads delivered for line item-level dynamic allocation.

Corresponds to "AdSense revenue" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

DYNAMIC_ALLOCATION_INVENTORY_LEVEL_AVERAGE_ECPM
The average estimated cost-per-thousand-impressions earned from dynamic allocation ads delivered when no LineItem reservation could be found by the ad server for inventory-level dynamic allocation. For premium networks, this includes line item-level dynamic allocation as well.

Can correspond to any of the following in the DFP UI: AdSense / Ad Exchange average eCPM, AdSense average eCPM. Compatible with the HISTORICAL report type.

ADSENSE_LINE_ITEM_LEVEL_AVERAGE_ECPM
The average estimated cost-per-thousand-impressions earned from the ads delivered by AdSense for line item-level dynamic allocation.

Corresponds to "AdSense average eCPM" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

DYNAMIC_ALLOCATION_INVENTORY_LEVEL_PERCENT_IMPRESSIONS
The ratio of the number of impressions delivered by dynamic allocation ads to the total impressions delivered when no LineItem reservation could be found by the ad server for inventory-level dynamic allocation. For premium networks, this includes line item-level dynamic allocation as well. Represented as a percentage.

Can correspond to any of the following in the DFP UI: AdSense / Ad Exchange impressions (%), AdSense impressions (%). Compatible with the HISTORICAL report type.

ADSENSE_LINE_ITEM_LEVEL_PERCENT_IMPRESSIONS
The ratio of the number of impressions delivered by AdSense reservation ads to the total impressions delivered for line item-level dynamic allocation. Represented as a percentage.

Corresponds to "AdSense impressions (%)" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

DYNAMIC_ALLOCATION_INVENTORY_LEVEL_PERCENT_CLICKS
The ratio of the number of clicks delivered by dynamic allocation ads to the total clicks delivered when no LineItem reservation could be found by the ad server for inventory-level dynamic allocation. For premium networks, this includes line item-level dynamic allocation as well. Represented as a percentage.

Can correspond to any of the following in the DFP UI: AdSense / Ad Exchange clicks (%), AdSense clicks (%). Compatible with the HISTORICAL report type.

ADSENSE_LINE_ITEM_LEVEL_PERCENT_CLICKS
The ratio of the number of clicks delivered by AdSense reservation ads to the total clicks delivered for line item-level dynamic allocation. Represented as a percentage.

Corresponds to "AdSense clicks (%)" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

DYNAMIC_ALLOCATION_INVENTORY_LEVEL_WITHOUT_CPD_PERCENT_REVENUE
The ratio of revenue to the total revenue earned from the dynamic allocation CPM and CPC ads delivered when no LineItem reservation could be found by the ad server for inventory-level dynamic allocation. For premium networks, this includes line item-level dynamic allocation as well. Represented as a percentage.

Can correspond to any of the following in the DFP UI: AdSense / Ad Exchange revenue (%), AdSense revenue (%). Compatible with the HISTORICAL report type.

DYNAMIC_ALLOCATION_INVENTORY_LEVEL_WITH_CPD_PERCENT_REVENUE
The ratio of revenue to the total revenue earned from the dynamic allocation CPM, CPC and CPD ads delivered when no LineItem reservation could be found by the ad server for inventory-level dynamic allocation. For premium networks, this includes line item-level dynamic allocation as well. Represented as a percentage.
ADSENSE_LINE_ITEM_LEVEL_WITHOUT_CPD_PERCENT_REVENUE
The ratio of revenue to the total revenue earned from the CPM and CPC ads delivered by AdSense for line item-level dynamic allocation. Represented as a percentage.

Corresponds to "AdSense revenue (%)" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

ADSENSE_LINE_ITEM_LEVEL_WITH_CPD_PERCENT_REVENUE
The ratio of revenue to the total revenue earned from the CPM, CPC and CPD ads delivered by AdSense for line item-level dynamic allocation. Represented as a percentage.
AD_EXCHANGE_LINE_ITEM_LEVEL_IMPRESSIONS
The number of impressions an Ad Exchange ad delivered for line item-level dynamic allocation.

Corresponds to "Ad Exchange impressions" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

AD_EXCHANGE_IMPRESSIONS
Ad Impressions on mapped Ad Exchange properties. When multiple text ads fill a single display slot it is only counted once, when the top text ad is recognized. In these cases, the Ad Impression is attributed to the top text ad.

Corresponds to "Ad impressions" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_MATCHED_REQUESTS
Number of requests where a buyer was matched with the Ad request, for mapped Ad Exchange properties.

Corresponds to "Matched requests" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_AD_ECPM
Ad revenue per 1000 ad impressions, for mapped Ad Exchange properties.

Corresponds to "Ad eCPM" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_CLICKS
The number of clicks delivered by mapped Ad Exchange properties.

Corresponds to "Clicks" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_ESTIMATED_REVENUE
The estimated net revenue generated by mapped Ad Exchange properties.

Corresponds to "Estimated revenue" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_COVERAGE
The coverage reported by mapped Ad Exchange properties.

Corresponds to "Coverage" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_CTR
The matched queries click-through rate delivered by mapped Ad Exchange properties.

Corresponds to "CTR" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_LIFT
The total lift generated by mapped Ad Exchange properties.

Corresponds to "Lift" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_CPC
The cost-per-click generated by mapped Ad Exchange properties.

Corresponds to "CPC" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_AD_REQUESTS
The number of ad requests issued by mapped Ad Exchange properties.

Corresponds to "Ad requests" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_AD_REQUEST_ECPM
The average estimated cost-per-thousand-ad requests earned by mapped Ad Exchange properties.

Corresponds to "Ad request eCPM" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_AD_REQUEST_CTR
The click-through rate of ad requests issued by mapped Ad Exchange properties.

Corresponds to "Ad request CTR" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_AD_CTR
The click-through rate of impressions issued by mapped Ad Exchange properties.

Corresponds to "Ad CTR" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_VIDEO_DROPOFF_RATE
The video drop off rate for mapped Ad Exchange properties.

Corresponds to "Video drop-off rate" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_VIDEO_ABANDONMENT_RATE
The video abandonment rate for mapped Ad Exchange properties.

Corresponds to "Video abandonment rate" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_MATCHED_ECPM
The average estimated cost-per-thousand-impressions generated by mapped Ad Exchange properties.

Corresponds to "Matched eCPM" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_ACTIVE_VIEW_MEASURABLE
The estimated percentage of impressions generated by mapped Ad Exchange properties that are eligible for Active View measurement.

Corresponds to "Active view measurable" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_ACTIVE_VIEW_VIEWABLE
The percentage of viewable impressions out of all measurable impressions generated by mapped Ad Exchange properties.

Corresponds to "Active view viewable" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_AVERAGE_VIEWABLE_TIME
The average time (in seconds) that an individual ad impression generated by mapped Ad Exchange properties was viewable.

Corresponds to "Average viewable time (secs)" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_ACTIVE_VIEW_ENABLED_IMPRESSIONS
Total number of impressions generated by mapped Ad Exchange properties that were eligible to measure viewability.

Corresponds to "Active view enabled impressions" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_ACTIVE_VIEW_MEASURED_IMPRESSIONS
Total number of eligible impressions generated by mapped Ad Exchange properties that were measurable by Active View.

Corresponds to "Active view measured impressions" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_ACTIVE_VIEW_VIEWED_IMPRESSIONS
Total number of Active View measurable impressions generated by mapped Ad Exchange properties that were viewable.

Corresponds to "Active view viewed impressions" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_DEALS_BID_RESPONSES
Number of responses that shows that a buyer is bidding, for mapped Ad Exchange properties.

Corresponds to "Deals bid responses" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_DEALS_MATCHED_REQUESTS
Deal ad requests for mapped Ad Exchange properties which were ?matched? with demand from the buyer associated with the Deal. Each ?Deals matched request? represents one opportunity for the Deal Buyer to serve their ad in the context of the Deal.

Corresponds to "Deals matched requests" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_DEALS_AD_REQUESTS
Total ad requests associated with a given Deal, for mapped Ad Exchange properties.

Corresponds to "Deals ad requests" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_DEALS_MATCH_RATE
Deals matched requests divided by Deals ad requests, for mapped Ad Exchange properties.

Corresponds to "Deals match rate" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_VIDEO_QUARTILE_1
A count of how many users watch the first 25% of a video ad, for mapped Ad Exchange properties.
AD_EXCHANGE_VIDEO_QUARTILE_3
A count of how many users watch the first 75% of a video ad, for mapped Ad Exchange properties.
AD_EXCHANGE_VIDEO_TRUEVIEW_SKIP_RATE
Percentage of times a user clicked Skip, for mapped Ad Exchange properties.

Corresponds to "TrueView skip rate" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_VIDEO_TRUEVIEW_VIEWS
Number of times a video ad has been viewed to completion or watched to 30 seconds, whichever happens first, for mapped Ad Exchange properties.

Corresponds to "TrueView views" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_VIDEO_TRUEVIEW_VTR
TrueView views divided by TrueView impressions, for mapped Ad Exchange properties.

Corresponds to "TrueView VTR" in the DFP UI. Compatible with the AD_EXCHANGE_HISTORICAL report type.

AD_EXCHANGE_THIRD_PARTY_FILL_RATE
The third-party fill rate by Ad Exchange properties linked to DFP.

This experimental column only works with Ad Exchange web properties linked with an active status.

This field is deprecated and will be removed in v201805.

Corresponds to "Mediation fill rate" in the DFP UI. Compatible with the HISTORICAL report type.

MEDIATION_IMPRESSIONS
Impressions generated for mediation requests. This includes third-party network and Ad Exchange impressions for mediation.

This field is deprecated and will be removed in v201805.

Compatible with the HISTORICAL report type.

MEDIATION_ESTIMATED_REVENUE
Estimated revenue generated for mediation requests. This combines estimated revenue from third-parties along with Ad Exchange.

This field is deprecated and will be removed in v201805.

Compatible with the HISTORICAL report type.

MEDIATION_ECPM
The average estimated cost-per-thousand-impressions earned from mediation ads.

This field is deprecated and will be removed in v201805.

Compatible with the HISTORICAL report type.

MEDIATION_THIRD_PARTY_ECPM
Mediation third-party average cost-per-thousand-impressions.

Compatible with the HISTORICAL report type.

MEDIATION_FILL_RATE
Mediation fill rate indicating how often a network fills an ad request.

This field is deprecated and will be removed in v201805.

Compatible with the HISTORICAL report type.

MEDIATION_PASSBACKS
Mediation passbacks recorded when a network does not fill an ad request.

This field is deprecated and will be removed in v201805.

Compatible with the HISTORICAL report type.

AD_EXCHANGE_LINE_ITEM_LEVEL_TARGETED_IMPRESSIONS
The number of impressions an Ad Exchange ad delivered for line item-level dynamic allocation by explicit custom criteria targeting.

Corresponds to "Ad Exchange targeted impressions" in the DFP UI. Compatible with the HISTORICAL report type.

AD_EXCHANGE_LINE_ITEM_LEVEL_CLICKS
The number of clicks an Ad Exchange ad delivered for line item-level dynamic allocation.

Corresponds to "Ad Exchange clicks" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

AD_EXCHANGE_LINE_ITEM_LEVEL_TARGETED_CLICKS
The number of clicks an Ad Exchange ad delivered for line item-level dynamic allocation by explicit custom criteria targeting.

Corresponds to "Ad Exchange targeted clicks" in the DFP UI. Compatible with the HISTORICAL report type.

AD_EXCHANGE_LINE_ITEM_LEVEL_CTR
The ratio of clicks an Ad Exchange ad delivered to the number of impressions it delivered for line item-level dynamic allocation.

Corresponds to "Ad Exchange CTR" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

AD_EXCHANGE_LINE_ITEM_LEVEL_PERCENT_IMPRESSIONS
The ratio of the number of impressions delivered to the total impressions delivered by Ad Exchange for line item-level dynamic allocation. Represented as a percentage.

Corresponds to "Ad Exchange impressions (%)" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

AD_EXCHANGE_LINE_ITEM_LEVEL_PERCENT_CLICKS
The ratio of the number of clicks delivered to the total clicks delivered by Ad Exchange for line item-level dynamic allocation. Represented as a percentage.

Corresponds to "Ad Exchange clicks (%)" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

AD_EXCHANGE_LINE_ITEM_LEVEL_REVENUE
Revenue generated from Ad Exchange ads delivered for line item-level dynamic allocation. Represented in publisher currency and time zone.

Corresponds to "Ad Exchange revenue" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

AD_EXCHANGE_LINE_ITEM_LEVEL_WITHOUT_CPD_PERCENT_REVENUE
The ratio of revenue generated by Ad Exchange to the total revenue earned by CPM and CPC ads delivered for line item-level dynamic allocation. Represented as a percentage.

Corresponds to "Ad Exchange revenue (%)" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

AD_EXCHANGE_LINE_ITEM_LEVEL_WITH_CPD_PERCENT_REVENUE
The ratio of revenue generated by Ad Exchange to the total revenue earned by CPM, CPC and CPD ads delivered for line item-level dynamic allocation. Represented as a percentage.
AD_EXCHANGE_LINE_ITEM_LEVEL_AVERAGE_ECPM
The average estimated cost-per-thousand-impressions earned from the delivery of Ad Exchange ads for line item-level dynamic allocation.

Corresponds to "Ad Exchange average eCPM" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

TOTAL_INVENTORY_LEVEL_IMPRESSIONS
The total number of impressions delivered by the ad servers including inventory-level dynamic allocation.

Corresponds to "Total impressions" in the DFP UI. Compatible with the HISTORICAL report type.

TOTAL_LINE_ITEM_LEVEL_IMPRESSIONS
The total number of impressions delivered including line item-level dynamic allocation.

Corresponds to "Total impressions" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE, DFP_HISTORICAL_DATA_STUDIO.

TOTAL_LINE_ITEM_LEVEL_TARGETED_IMPRESSIONS
The total number of impressions delivered including line item-level dynamic allocation by explicit custom criteria targeting.

Corresponds to "Total targeted impressions" in the DFP UI. Compatible with the HISTORICAL report type.

TOTAL_INVENTORY_LEVEL_CLICKS
The total number of clicks delivered by the ad servers including inventory-level dynamic allocation.

Corresponds to "Total clicks" in the DFP UI. Compatible with the HISTORICAL report type.

TOTAL_LINE_ITEM_LEVEL_CLICKS
The total number of clicks delivered including line item-level dynamic allocation.

Corresponds to "Total clicks" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE, DFP_HISTORICAL_DATA_STUDIO.

TOTAL_LINE_ITEM_LEVEL_TARGETED_CLICKS
The total number of clicks delivered including line item-level dynamic allocation by explicit custom criteria targeting

Corresponds to "Total targeted clicks" in the DFP UI. Compatible with the HISTORICAL report type.

TOTAL_INVENTORY_LEVEL_CTR
The ratio of total clicks on ads delivered by the ad servers to the total number of impressions delivered for an ad including inventory-level dynamic allocation.

Corresponds to "Total CTR" in the DFP UI. Compatible with the HISTORICAL report type.

TOTAL_LINE_ITEM_LEVEL_CTR
The ratio of total clicks on ads delivered by the ad servers to the total number of impressions delivered for an ad including line item-level dynamic allocation.

Corresponds to "Total CTR" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE, DFP_HISTORICAL_DATA_STUDIO.

TOTAL_INVENTORY_LEVEL_CPM_AND_CPC_REVENUE
The total CPM and CPC revenue generated by the ad servers including inventory-level dynamic allocation.

Corresponds to "Total CPM and CPC revenue" in the DFP UI. Compatible with the HISTORICAL report type.

TOTAL_INVENTORY_LEVEL_ALL_REVENUE
The total CPM, CPC and CPD revenue generated by the ad servers including inventory-level dynamic allocation.
TOTAL_LINE_ITEM_LEVEL_CPM_AND_CPC_REVENUE
The total CPM and CPC revenue generated by the ad servers including line item-level dynamic allocation.

Corresponds to "Total CPM and CPC revenue" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE, DFP_HISTORICAL_DATA_STUDIO.

TOTAL_LINE_ITEM_LEVEL_ALL_REVENUE
The total CPM, CPC and CPD revenue generated by the ad servers including line item-level dynamic allocation.

Can correspond to any of the following in the DFP UI: Total CPM, CPC, CPD, and vCPM revenue, Total CPM, CPC and CPD revenue. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE, DFP_HISTORICAL_DATA_STUDIO.

TOTAL_INVENTORY_LEVEL_WITHOUT_CPD_AVERAGE_ECPM
Estimated cost-per-thousand-impressions (eCPM) of CPM and CPC ads delivered by the ad servers including inventory-level dynamic allocation.

Corresponds to "Total average eCPM" in the DFP UI. Compatible with the HISTORICAL report type.

TOTAL_INVENTORY_LEVEL_WITH_CPD_AVERAGE_ECPM
Estimated cost-per-thousand-impressions (eCPM) of CPM, CPC and CPD ads delivered by the ad servers including inventory-level dynamic allocation.
TOTAL_LINE_ITEM_LEVEL_WITHOUT_CPD_AVERAGE_ECPM
Estimated cost-per-thousand-impressions (eCPM) of CPM and CPC ads delivered by the ad servers including line item-level dynamic allocation.

Corresponds to "Total average eCPM" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE, DFP_HISTORICAL_DATA_STUDIO.

TOTAL_LINE_ITEM_LEVEL_WITH_CPD_AVERAGE_ECPM
Estimated cost-per-thousand-impressions (eCPM) of CPM, CPC and CPD ads delivered by the ad servers including line item-level dynamic allocation.
TOTAL_CODE_SERVED_COUNT
The total number of times that the code for an ad is served by the ad server including inventory-level dynamic allocation.

Corresponds to "Total code served count" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE, DFP_HISTORICAL_DATA_STUDIO.

TOTAL_INVENTORY_LEVEL_UNFILLED_IMPRESSIONS
The total number of missed impressions due to the ad servers' inability to find ads to serve, including inventory-level dynamic allocation.

Corresponds to "Unfilled impressions" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE, DFP_HISTORICAL_DATA_STUDIO, SAMPLED_HISTORICAL.

OPTIMIZATION_CONTROL_IMPRESSIONS
The number of control (unoptimized) impressions delivered for an ad for which the optimization feature has been enabled.

Corresponds to "Control impressions" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

OPTIMIZATION_CONTROL_CLICKS
Number of clicks resulting from the delivery of control (unoptimized) impressions for an ad for which the optimization feature has been enabled.

Corresponds to "Control clicks" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

OPTIMIZATION_CONTROL_CTR
The CTR for control (unoptimized) impressions for an order for which the optimization feature has been enabled.

Corresponds to "Control CTR" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

OPTIMIZATION_OPTIMIZED_IMPRESSIONS
Number of optimized impressions delivered for an ad for which the optimization feature has been enabled.

Corresponds to "Optimized impressions" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

OPTIMIZATION_OPTIMIZED_CLICKS
Number of clicks resulting from the delivery of optimized impressions for an ad for which the optimization feature has been enabled.

Corresponds to "Optimized clicks" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

OPTIMIZATION_NON_OPTIMIZED_IMPRESSIONS
Number of non-optimized impressions delivered for an ad for which the optimization feature has been enabled.

Corresponds to "Non-optimized impressions" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

OPTIMIZATION_NON_OPTIMIZED_CLICKS
Number of clicks resulting from the delivery of non-optimized impressions for an ad for which the optimization feature has been enabled.

Corresponds to "Non-optimized clicks" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

OPTIMIZATION_EXTRA_CLICKS
Number of extra clicks resulting from the delivery of optimized impressions for an ad for which the optimization feature has been enabled.

Corresponds to "Extra clicks" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

OPTIMIZATION_OPTIMIZED_CTR
The CTR for optimized impressions for an ad for which the optimization feature has been enabled.

Corresponds to "Optimized CTR" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

OPTIMIZATION_LIFT
The percentage by which optimized CTRs are greater than the unoptimized CTRs. This is calculated as ((Column.OPTIMIZATION_OPTIMIZED_CTR/ Column.OPTIMIZATION_CONTROL_CTR) - 1) * 100 for an ad for which the optimization feature has been enabled.

Corresponds to "Lift" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

OPTIMIZATION_COVERAGE
The line item coverage measures how often the traffic was sent for optimization.

Corresponds to "Percent optimized" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

OPTIMIZATION_BEHIND_SCHEDULE_IMPRESSIONS
The number of impressions that were behind schedule at the time of their delivery.

Corresponds to "Impressions that are behind schedule" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

OPTIMIZATION_NO_CLICKS_RECORDED_IMPRESSIONS
The number of impressions that did not have any clicks recorded in the recent past.

Corresponds to "Impressions with no clicks recorded" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

OPTIMIZATION_SPONSORSHIP_IMPRESSIONS
The number of impressions that were delivered as sponsorship items.

Corresponds to "Sponsorship impressions" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

OPTIMIZATION_AS_FAST_AS_POSSIBLE_IMPRESSIONS
The number of impressions that were set to deliver as fast as possible.

Corresponds to "Impressions serving as fast as possible" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

OPTIMIZATION_NO_ABSOLUTE_LIFETIME_GOAL_IMPRESSIONS
The number of impressions that have no absolute lifetime delivery goals.

Corresponds to "Impressions with no lifetime goal" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

OPTIMIZATION_CONTROL_REVENUE
Total revenue resulting from the delivery of control (unoptimized) impressions for an ad for which the optimization feature has been enabled.

Corresponds to "Control revenue" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

OPTIMIZATION_OPTIMIZED_REVENUE
Total revenue resulting from the delivery of optimized impressions for an ad for which the optimization feature has been enabled.

Corresponds to "Optimized revenue" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

OPTIMIZATION_CONTROL_ECPM
Estimated cost-per-thousand-impressions (eCPM) of control (unoptimized) impressions for an ad for which the optimization feature has been enabled.

Corresponds to "Control eCPM" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

OPTIMIZATION_OPTIMIZED_ECPM
Estimated cost-per-thousand-impressions (eCPM) of optimized impressions for an ad for which the optimization feature has been enabled.

Corresponds to "Optimized eCPM" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

OPTIMIZATION_FREED_UP_IMPRESSIONS
Freed-up impressions as a result of optimization.

Corresponds to "Freed-up impressions" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

OPTIMIZATION_ECPM_LIFT
Relative change in eCPM as a result of optimization.

Corresponds to "eCPM lift" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

REACH_FREQUENCY
The average number of ads displayed to each unique visitor.

Corresponds to "Average impressions / visitor" in the DFP UI. Compatible with the REACH report type.

REACH_AVERAGE_REVENUE
The average revenue earned per unique visitor.

Corresponds to "Average revenue / visitor" in the DFP UI. Compatible with the REACH report type.

REACH
The number of unique visitors.

Corresponds to "Unique visitors" in the DFP UI. Compatible with the REACH report type.

GRP_POPULATION
The number of people in the given demographic bucket.

Corresponds to "Population" in the DFP UI. Compatible with the REACH report type.

GRP_UNIQUE_AUDIENCE
The number of unique users reached in the given demographic bucket.

Corresponds to "Unique viewers" in the DFP UI. Compatible with the REACH report type.

GRP_UNIQUE_AUDIENCE_SHARE
Percentage of the number of unique users reached in the given demographic bucket (out of the number of unique users reached in all demographics).

Corresponds to "% Composition unique viewers" in the DFP UI. Compatible with the REACH report type.

GRP_AUDIENCE_IMPRESSIONS
The number of impressions in the given demographic bucket.

Corresponds to "Impressions" in the DFP UI. Compatible with the REACH report type.

GRP_AUDIENCE_IMPRESSIONS_SHARE
Percentage of the number of impressions in the given demographic bucket (out of the number of impressions in all demographics).

Corresponds to "% Composition impressions" in the DFP UI. Compatible with the REACH report type.

GRP_AUDIENCE_REACH
The audience reach calculated as GRP_UNIQUE_AUDIENCE / GRP_POPULATION.

Corresponds to "% Population reach" in the DFP UI. Compatible with the REACH report type.

GRP_AUDIENCE_AVERAGE_FREQUENCY
The audience average frequency calculated as GRP_AUDIENCE_IMPRESSIONS / GRP_UNIQUE_AUDIENCE.

Corresponds to "Average frequency" in the DFP UI. Compatible with the REACH report type.

GRP_GROSS_RATING_POINTS
The gross rating points (GRP) calculated as GRP_AUDIENCE_REACH * GRP_AUDIENCE_AVERAGE_FREQUENCY * 100.

Corresponds to "Target rating points" in the DFP UI. Compatible with the REACH report type.

SDK_MEDIATION_CREATIVE_IMPRESSIONS
The number of impressions for a particular SDK mediation creative.

Corresponds to "SDK mediation creative impressions" in the DFP UI. Compatible with the HISTORICAL report type.

SDK_MEDIATION_CREATIVE_CLICKS
The number of clicks for a particular SDK mediation creative.

Corresponds to "SDK mediation creative clicks" in the DFP UI. Compatible with the HISTORICAL report type.

SELL_THROUGH_FORECASTED_IMPRESSIONS
The number of forecasted impressions for future sell-through reports.

This metric is available for the next 90 days with a daily break down and for the next 12 months with a monthly break down.

Corresponds to "Forecasted impressions" in the DFP UI. Compatible with the SELL_THROUGH report type.

SELL_THROUGH_AVAILABLE_IMPRESSIONS
The number of available impressions for future sell-through reports.

This metric is available for the next 90 days with a daily break down and for the next 12 months with a monthly break down.

Corresponds to "Available impressions" in the DFP UI. Compatible with the SELL_THROUGH report type.

SELL_THROUGH_RESERVED_IMPRESSIONS
The number of reserved impressions for future sell-through reports.

This metric is available for the next 90 days with a daily break down and for the next 12 months with a monthly break down.

Corresponds to "Reserved impressions" in the DFP UI. Compatible with the SELL_THROUGH report type.

SELL_THROUGH_SELL_THROUGH_RATE
The sell-through rate for impressions for future sell-through reports.

This metric is available for the next 90 days with a daily break down and for the next 12 months with a monthly break down.

Corresponds to "Sell-through rate" in the DFP UI. Compatible with the SELL_THROUGH report type.

RICH_MEDIA_BACKUP_IMAGES
The total number of times a backup image is served in place of a rich media ad.

Corresponds to "Backup image impressions" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

RICH_MEDIA_DISPLAY_TIME
The amount of time(seconds) that each rich media ad is displayed to users.

Corresponds to "Total display time" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

RICH_MEDIA_AVERAGE_DISPLAY_TIME
The average amount of time(seconds) that each rich media ad is displayed to users.

Corresponds to "Average display time" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

RICH_MEDIA_EXPANSIONS
The number of times an expanding ad was expanded.

Corresponds to "Total expansions" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

RICH_MEDIA_EXPANDING_TIME
The average amount of time(seconds) that an expanding ad is viewed in an expanded state.

Corresponds to "Average expanding time" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

RICH_MEDIA_INTERACTION_TIME
The average amount of time(seconds) that a user interacts with a rich media ad.

Corresponds to "Interaction time" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

RICH_MEDIA_INTERACTION_COUNT
The number of times that a user interacts with a rich media ad.

Corresponds to "Total interactions" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

RICH_MEDIA_INTERACTION_RATE
The ratio of rich media ad interactions to the number of times the ad was displayed. Represented as a percentage.

Corresponds to "Interaction rate" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

RICH_MEDIA_AVERAGE_INTERACTION_TIME
The average amount of time(seconds) that a user interacts with a rich media ad.

Corresponds to "Average interaction time" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

RICH_MEDIA_INTERACTION_IMPRESSIONS
The number of impressions where a user interacted with a rich media ad.

Corresponds to "Interactive impressions" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

RICH_MEDIA_MANUAL_CLOSES
The number of times that a user manually closes a floating, expanding, in-page with overlay, or in-page with floating ad.

Corresponds to "Manual closes" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

RICH_MEDIA_FULL_SCREEN_IMPRESSIONS
A metric that measures an impression only once when a user opens an ad in full screen mode.

Corresponds to "Full-screen impressions" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

RICH_MEDIA_VIDEO_INTERACTIONS
The number of times a user clicked on the graphical controls of a video player.

Corresponds to "Total video interactions" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

RICH_MEDIA_VIDEO_INTERACTION_RATE
The ratio of video interactions to video plays. Represented as a percentage.

Corresponds to "Video interaction rate" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

RICH_MEDIA_VIDEO_MUTES
The number of times a rich media video was muted.

Corresponds to "Mute" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

RICH_MEDIA_VIDEO_PAUSES
The number of times a rich media video was paused.

Corresponds to "Pause" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

RICH_MEDIA_VIDEO_PLAYES
The number of times a rich media video was played.

Corresponds to "Plays" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

RICH_MEDIA_VIDEO_MIDPOINTS
The number of times a rich media video was played upto midpoint.

Corresponds to "Midpoint" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

RICH_MEDIA_VIDEO_COMPLETES
The number of times a rich media video was fully played.

Corresponds to "Complete" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

RICH_MEDIA_VIDEO_REPLAYS
The number of times a rich media video was restarted.

Corresponds to "Replays" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

RICH_MEDIA_VIDEO_STOPS
The number of times a rich media video was stopped.

Corresponds to "Stops" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

RICH_MEDIA_VIDEO_UNMUTES
The number of times a rich media video was unmuted.

Corresponds to "Unmute" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

RICH_MEDIA_VIDEO_VIEW_TIME
The average amount of time(seconds) that a rich media video was viewed per view.

Corresponds to "Average view time" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

RICH_MEDIA_VIDEO_VIEW_RATE
The percentage of a video watched by a user.

Corresponds to "View rate" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

RICH_MEDIA_CUSTOM_EVENT_TIME
The amount of time (seconds) that a user interacts with a rich media ad.

Corresponds to "Custom event - time" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE, SAMPLED_HISTORICAL.

RICH_MEDIA_CUSTOM_EVENT_COUNT
The number of times a user views and interacts with a specified part of a rich media ad.

Corresponds to "Custom event - count" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE, SAMPLED_HISTORICAL.

VIDEO_VIEWERSHIP_START
The number of impressions where the video was played.

Corresponds to "Start" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE, DFP_HISTORICAL_DATA_STUDIO, SAMPLED_HISTORICAL.

VIDEO_VIEWERSHIP_FIRST_QUARTILE
The number of times the video played to 25% of its length.

Corresponds to "First quartile" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE, DFP_HISTORICAL_DATA_STUDIO, SAMPLED_HISTORICAL.

VIDEO_VIEWERSHIP_MIDPOINT
The number of times the video reached its midpoint during play.

Corresponds to "Midpoint" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE, DFP_HISTORICAL_DATA_STUDIO, SAMPLED_HISTORICAL.

VIDEO_VIEWERSHIP_THIRD_QUARTILE
The number of times the video played to 75% of its length.

Corresponds to "Third quartile" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE, DFP_HISTORICAL_DATA_STUDIO, SAMPLED_HISTORICAL.

VIDEO_VIEWERSHIP_COMPLETE
The number of times the video played to completion.

Corresponds to "Complete" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE, DFP_HISTORICAL_DATA_STUDIO, SAMPLED_HISTORICAL.

VIDEO_VIEWERSHIP_AVERAGE_VIEW_RATE
Average percentage of the video watched by users.

Corresponds to "Average view rate" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE, DFP_HISTORICAL_DATA_STUDIO, SAMPLED_HISTORICAL.

VIDEO_VIEWERSHIP_AVERAGE_VIEW_TIME
Average time(seconds) users watched the video.

Corresponds to "Average view time" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE, DFP_HISTORICAL_DATA_STUDIO, SAMPLED_HISTORICAL.

VIDEO_VIEWERSHIP_COMPLETION_RATE
Percentage of times the video played to the end.

Corresponds to "Completion rate" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE, DFP_HISTORICAL_DATA_STUDIO, SAMPLED_HISTORICAL.

VIDEO_VIEWERSHIP_TOTAL_ERROR_COUNT
The number of times an error occurred, such as a VAST redirect error, a video playback error, or an invalid response error.

Corresponds to "Total error count" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE, DFP_HISTORICAL_DATA_STUDIO, SAMPLED_HISTORICAL.

VIDEO_VIEWERSHIP_VIDEO_LENGTH
Duration of the video creative.

Corresponds to "Video length" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE, DFP_HISTORICAL_DATA_STUDIO, SAMPLED_HISTORICAL.

VIDEO_VIEWERSHIP_SKIP_BUTTON_SHOWN
The number of times a skip button is shown in video.

Corresponds to "Skip button shown" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE, SAMPLED_HISTORICAL.

VIDEO_VIEWERSHIP_ENGAGED_VIEW
The number of engaged views i.e. ad is viewed to completion or for 30s, whichever comes first.

Corresponds to "Engaged view" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE, SAMPLED_HISTORICAL.

VIDEO_VIEWERSHIP_VIEW_THROUGH_RATE
View-through rate represented as a percentage.

Corresponds to "View-through rate" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE, SAMPLED_HISTORICAL.

VIDEO_VIEWERSHIP_AUTO_PLAYS
Number of times that the publisher specified a video ad played automatically.

Corresponds to "Auto-plays" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SAMPLED_HISTORICAL.

VIDEO_VIEWERSHIP_CLICK_TO_PLAYS
Number of times that the publisher specified a video ad was clicked to play.

Corresponds to "Click-to-plays" in the DFP UI. Compatible with any of the following report types: HISTORICAL, DFP_HISTORICAL_DATA_STUDIO, SAMPLED_HISTORICAL.

VIDEO_VIEWERSHIP_TOTAL_ERROR_RATE
Error rate is the percentage of video error count from (error count + total impressions).

Corresponds to "Total error rate" in the DFP UI. Compatible with any of the following report types: HISTORICAL, DFP_HISTORICAL_DATA_STUDIO, SAMPLED_HISTORICAL.

VIDEO_ERRORS_VAST_ERROR_100_COUNT
Number of VAST video errors of type 100.

Corresponds to "VAST error 100 count" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SAMPLED_HISTORICAL.

VIDEO_ERRORS_VAST_ERROR_101_COUNT
Number of VAST video errors of type 101.

Corresponds to "VAST error 101 count" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SAMPLED_HISTORICAL.

VIDEO_ERRORS_VAST_ERROR_102_COUNT
Number of VAST video errors of type 102.

Corresponds to "VAST error 102 count" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SAMPLED_HISTORICAL.

VIDEO_ERRORS_VAST_ERROR_200_COUNT
Number of VAST video errors of type 200.

Corresponds to "VAST error 200 count" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SAMPLED_HISTORICAL.

VIDEO_ERRORS_VAST_ERROR_201_COUNT
Number of VAST video errors of type 201.

Corresponds to "VAST error 201 count" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SAMPLED_HISTORICAL.

VIDEO_ERRORS_VAST_ERROR_202_COUNT
Number of VAST video errors of type 202.

Corresponds to "VAST error 202 count" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SAMPLED_HISTORICAL.

VIDEO_ERRORS_VAST_ERROR_203_COUNT
Number of VAST video errors of type 203.

Corresponds to "VAST error 203 count" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SAMPLED_HISTORICAL.

VIDEO_ERRORS_VAST_ERROR_300_COUNT
Number of VAST video errors of type 300.

Corresponds to "VAST error 300 count" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SAMPLED_HISTORICAL.

VIDEO_ERRORS_VAST_ERROR_301_COUNT
Number of VAST video errors of type 301.

Corresponds to "VAST error 301 count" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SAMPLED_HISTORICAL.

VIDEO_ERRORS_VAST_ERROR_302_COUNT
Number of VAST video errors of type 302.

Corresponds to "VAST error 302 count" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SAMPLED_HISTORICAL.

VIDEO_ERRORS_VAST_ERROR_303_COUNT
Number of VAST video errors of type 303.

Corresponds to "VAST error 303 count" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SAMPLED_HISTORICAL.

VIDEO_ERRORS_VAST_ERROR_400_COUNT
Number of VAST video errors of type 400.

Corresponds to "VAST error 400 count" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SAMPLED_HISTORICAL.

VIDEO_ERRORS_VAST_ERROR_401_COUNT
Number of VAST video errors of type 401.

Corresponds to "VAST error 401 count" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SAMPLED_HISTORICAL.

VIDEO_ERRORS_VAST_ERROR_402_COUNT
Number of VAST video errors of type 402.

Corresponds to "VAST error 402 count" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SAMPLED_HISTORICAL.

VIDEO_ERRORS_VAST_ERROR_403_COUNT
Number of VAST video errors of type 403.

Corresponds to "VAST error 403 count" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SAMPLED_HISTORICAL.

VIDEO_ERRORS_VAST_ERROR_405_COUNT
Number of VAST video errors of type 405.

Corresponds to "VAST error 405 count" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SAMPLED_HISTORICAL.

VIDEO_ERRORS_VAST_ERROR_500_COUNT
Number of VAST video errors of type 500.

Corresponds to "VAST error 500 count" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SAMPLED_HISTORICAL.

VIDEO_ERRORS_VAST_ERROR_501_COUNT
Number of VAST video errors of type 501.

Corresponds to "VAST error 501 count" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SAMPLED_HISTORICAL.

VIDEO_ERRORS_VAST_ERROR_502_COUNT
Number of VAST video errors of type 502.

Corresponds to "VAST error 502 count" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SAMPLED_HISTORICAL.

VIDEO_ERRORS_VAST_ERROR_503_COUNT
Number of VAST video errors of type 503.

Corresponds to "VAST error 503 count" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SAMPLED_HISTORICAL.

VIDEO_ERRORS_VAST_ERROR_600_COUNT
Number of VAST video errors of type 600.

Corresponds to "VAST error 600 count" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SAMPLED_HISTORICAL.

VIDEO_ERRORS_VAST_ERROR_601_COUNT
Number of VAST video errors of type 601.

Corresponds to "VAST error 601 count" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SAMPLED_HISTORICAL.

VIDEO_ERRORS_VAST_ERROR_602_COUNT
Number of VAST video errors of type 602.

Corresponds to "VAST error 602 count" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SAMPLED_HISTORICAL.

VIDEO_ERRORS_VAST_ERROR_603_COUNT
Number of VAST video errors of type 603.

Corresponds to "VAST error 603 count" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SAMPLED_HISTORICAL.

VIDEO_ERRORS_VAST_ERROR_604_COUNT
Number of VAST video errors of type 604.

Corresponds to "VAST error 604 count" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SAMPLED_HISTORICAL.

VIDEO_ERRORS_VAST_ERROR_900_COUNT
Number of VAST video errors of type 900.

Corresponds to "VAST error 900 count" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SAMPLED_HISTORICAL.

VIDEO_ERRORS_VAST_ERROR_901_COUNT
Number of VAST video errors of type 901.

Corresponds to "VAST error 901 count" in the DFP UI. Compatible with any of the following report types: HISTORICAL, SAMPLED_HISTORICAL.

VIDEO_INTERACTION_PAUSE
Video interaction event: The number of times user paused ad clip.

Corresponds to "Pause" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE, SAMPLED_HISTORICAL.

VIDEO_INTERACTION_RESUME
Video interaction event: The number of times the user unpaused the video.

Corresponds to "Resume" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE, SAMPLED_HISTORICAL.

VIDEO_INTERACTION_REWIND
Video interaction event: The number of times a user rewinds the video.

Corresponds to "Rewind" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE, SAMPLED_HISTORICAL.

VIDEO_INTERACTION_MUTE
Video interaction event: The number of times video player was in mute state during play of ad clip.

Corresponds to "Mute" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE, SAMPLED_HISTORICAL.

VIDEO_INTERACTION_UNMUTE
Video interaction event: The number of times a user unmutes the video.

Corresponds to "Unmute" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE, SAMPLED_HISTORICAL.

VIDEO_INTERACTION_COLLAPSE
Video interaction event: The number of times a user collapses a video, either to its original size or to a different size.

Corresponds to "Collapse" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE, SAMPLED_HISTORICAL.

VIDEO_INTERACTION_EXPAND
Video interaction event: The number of times a user expands a video.

Corresponds to "Expand" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE, SAMPLED_HISTORICAL.

VIDEO_INTERACTION_FULL_SCREEN
Video interaction event: The number of times ad clip played in full screen mode.

Corresponds to "Full screen" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE, SAMPLED_HISTORICAL.

VIDEO_INTERACTION_AVERAGE_INTERACTION_RATE
Video interaction event: The number of user interactions with a video, on average, such as pause, full screen, mute, etc.

Corresponds to "Average interaction rate" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE, SAMPLED_HISTORICAL.

VIDEO_INTERACTION_VIDEO_SKIPS
Video interaction event: The number of times a skippable video is skipped.

Corresponds to "Video skipped" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE, DFP_HISTORICAL_DATA_STUDIO, SAMPLED_HISTORICAL.

VIDEO_OPTIMIZATION_CONTROL_STARTS
The number of control starts.

Corresponds to "Control starts" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

VIDEO_OPTIMIZATION_OPTIMIZED_STARTS
The number of optimized starts.

Corresponds to "Optimized starts" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

VIDEO_OPTIMIZATION_CONTROL_COMPLETES
The number of control completes.

Corresponds to "Control completes" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

VIDEO_OPTIMIZATION_OPTIMIZED_COMPLETES
The number of optimized completes.

Corresponds to "Optimized completes" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

VIDEO_OPTIMIZATION_CONTROL_COMPLETION_RATE
The rate of control completions.

Corresponds to "Control completion rate" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

VIDEO_OPTIMIZATION_OPTIMIZED_COMPLETION_RATE
The rate of optimized completions.

Corresponds to "Optimized completion rate" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

VIDEO_OPTIMIZATION_COMPLETION_RATE_LIFT
The percentage by which optimized completion rate is greater than the unoptimized completion rate. This is calculated as (( Column.VIDEO_OPTIMIZATION_OPTIMIZED_COMPLETION_RATE/ Column.VIDEO_OPTIMIZATION_CONTROL_COMPLETION_RATE) - 1) * 100 for an ad for which the optimization feature has been enabled.

Corresponds to "Completion rate lift" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

VIDEO_OPTIMIZATION_CONTROL_SKIP_BUTTON_SHOWN
The number of control skip buttons shown.

Corresponds to "Control skip button shown" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

VIDEO_OPTIMIZATION_OPTIMIZED_SKIP_BUTTON_SHOWN
The number of optimized skip buttons shown.

Corresponds to "Optimized skip button shown" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

VIDEO_OPTIMIZATION_CONTROL_ENGAGED_VIEW
The number of control engaged views.

Corresponds to "Control engaged view" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

VIDEO_OPTIMIZATION_OPTIMIZED_ENGAGED_VIEW
The number of optimized engaged views.

Corresponds to "Optimized engaged view" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

VIDEO_OPTIMIZATION_CONTROL_VIEW_THROUGH_RATE
The control view-through rate.

Corresponds to "Control view-through rate" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

VIDEO_OPTIMIZATION_OPTIMIZED_VIEW_THROUGH_RATE
The optimized view-through rate.

Corresponds to "Optimized view-through rate" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

VIDEO_OPTIMIZATION_VIEW_THROUGH_RATE_LIFT
The percentage by which optimized view-through rate is greater than the unoptimized view-through rate. This is calculated as (( Column.VIDEO_OPTIMIZATION_OPTIMIZED_VIEW_THROUGH_RATE/ Column.VIDEO_OPTIMIZATION_CONTROL_VIEW_THROUGH_RATE) - 1) * 100 for an ad for which the optimization feature has been enabled.

Corresponds to "View-through rate lift" in the DFP UI. Compatible with any of the following report types: HISTORICAL, BUSINESS_INTELLIGENCE.

TOTAL_ACTIVE_VIEW_VIEWABLE_IMPRESSIONS
The total number of impressions viewed on the user's screen.

Corresponds to "Total Active View viewable impressions" in the DFP UI. Compatible with any of the following report types: HISTORICAL, DFP_HISTORICAL_DATA_STUDIO.

TOTAL_ACTIVE_VIEW_MEASURABLE_IMPRESSIONS
The total number of impressions that were sampled and measured by active view.

Corresponds to "Total Active View measurable impressions" in the DFP UI. Compatible with any of the following report types: HISTORICAL, DFP_HISTORICAL_DATA_STUDIO.

TOTAL_ACTIVE_VIEW_VIEWABLE_IMPRESSIONS_RATE
The percentage of total impressions viewed on the user's screen (out of the total impressions measurable by active view).
TOTAL_ACTIVE_VIEW_ELIGIBLE_IMPRESSIONS
Total number of impressions that were eligible to measure viewability.

Corresponds to "Total Active View eligible impressions" in the DFP UI. Compatible with any of the following report types: HISTORICAL, DFP_HISTOR