type ReportQuery (v201411)

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'.

WEEK

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

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'".

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).

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).

LINE_ITEM_ID

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

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.

LINE_ITEM_TYPE

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

ORDER_ID

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

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.

ADVERTISER_ID

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

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.

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.

AD_NETWORK_NAME

The name of the network defined in AD_NETWORK_ID.

SALESPERSON_ID

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

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.

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.

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.

CREATIVE_TYPE

Breaks down reporting data by creative type.

CUSTOM_EVENT_ID

Breaks down reporting data by custom event ID.

CUSTOM_EVENT_NAME

Breaks down reporting data by custom event name.

CUSTOM_EVENT_TYPE

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

CREATIVE_SIZE

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

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.

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.

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.

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.

PLACEMENT_ID

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

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.

TARGETING

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

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.

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.

COUNTRY_CRITERIA_ID

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

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.

REGION_CRITERIA_ID

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

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.

CITY_CRITERIA_ID

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

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.

METRO_CRITERIA_ID

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

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.

POSTAL_CODE_CRITERIA_ID

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

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.

CUSTOM_TARGETING_VALUE_ID

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

CUSTOM_CRITERIA

Breaks down reporting data by custom criteria. The CustomTargetingValue is displayed in the form:

• car=honda when value match type is CustomTargetingValue.MatchType.EXACT
• car~honda when value match type is CustomTargetingValue.MatchType.BROAD
• car=*honda when value match type is CustomTargetingValue.MatchType.PREFIX
• car~*honda when value match type is CustomTargetingValue.MatchType.BROAD_PREFIX

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.

ACTIVITY_ID

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

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.

ACTIVITY_GROUP_ID

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

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.

CONTENT_ID

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

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.

CONTENT_BUNDLE_ID

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

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.

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.

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.

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.

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.

AD_REQUEST_SIZE

Size of the creative requested for an ad.

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.

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.

BUYER_ID

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

BUYER_NAME

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

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.

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.

MASTER_COMPANION_CREATIVE_ID

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

MASTER_COMPANION_CREATIVE_NAME

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

DISTRIBUTION_PARTNER_ID

Breaks down reporting data by ID of the distribution partner.

DISTRIBUTION_PARTNER_NAME

Breaks down reporting data by name of the distribution partner.

CONTENT_PARTNER_ID

Breaks down reporting data by ID of the content partner.

CONTENT_PARTNER_NAME

Breaks down reporting data by name of the content partner.

RIGHTS_HOLDER_ID

Breaks down reporting data by ID of the rights holder.

RIGHTS_HOLDER_NAME

Breaks down reporting data by name of the rights holder.

PROPOSAL_LINE_ITEM_ID

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

PROPOSAL_LINE_ITEM_NAME

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

PROPOSAL_ID

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

PROPOSAL_NAME

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

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.

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.

PROPOSAL_AGENCY_ID

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

PROPOSAL_AGENCY_NAME

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

PRODUCT_ID

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

PRODUCT_NAME

Breaks down reporting data by Product.name.

PRODUCT_TEMPLATE_ID

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

PRODUCT_TEMPLATE_NAME

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

RATE_CARD_ID

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

RATE_CARD_NAME

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

WORKFLOW_ID

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

WORKFLOW_NAME

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

AUDIENCE_SEGMENT_ID

Breaks down reporting data by billable audience segment ID.

AUDIENCE_SEGMENT_NAME

Breaks down reporting data by billable audience segment name.

AUDIENCE_SEGMENT_DATA_PROVIDER_NAME

Breaks down reporting data by audience segment data provider name.

NIELSEN_OCR_SEGMENT

Campaign date segment of Nielsen OCR reporting.

This column is deprecated and replaced with NIELSEN_SEGMENT beginning in V201508.

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.

AD_SERVER_IMPRESSIONS

The number of impressions delivered by the ad server.

AD_SERVER_TARGETED_IMPRESSIONS

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

AD_SERVER_CLICKS

The number of clicks delivered by the ad server.

AD_SERVER_TARGETED_CLICKS

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

AD_SERVER_CTR

The CTR for an ad delivered by the ad server.

AD_SERVER_CPM_AND_CPC_REVENUE

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

AD_SERVER_CPD_REVENUE

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

AD_SERVER_CPA_REVENUE

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

AD_SERVER_ALL_REVENUE

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

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.

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.

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.

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.

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.

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.

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.

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_DELIVERY_INDICATOR

Indicates the progress made for the delivery of the LineItem.

Progress	Definition
100%	The LineItem is on track to deliver in full as per LineItem.unitsBought.
> 100%	The LineItem is on track to overdeliver.
< 100%	The LineItem is on track to underdeliver.
N/A	The LineItem does not have any quantity goals, or there is insufficient information about the LineItem.

AD_SERVER_CODE_SERVED_COUNT

The number of times that the code for an ad is served by the ad server.

AD_SERVER_IMPRESSIONS_OUT_OF_NETWORK

The number of impressions delivered by the ad server on shared inventory unit in a partner's network.

AD_SERVER_CLICKS_OUT_OF_NETWORK

The number of clicks delivered by the ad server on shared inventory unit in a partner's network.

AD_SERVER_CTR_OUT_OF_NETWORK

The CTR for an ad delivered by the ad server on shared inventory unit in a partner's network.

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.

TOTAL_DYNAMIC_ALLOCATION_IMPRESSIONS_OUT_OF_NETWORK

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

ADSENSE_LINE_ITEM_LEVEL_IMPRESSIONS

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

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.

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.

ADSENSE_LINE_ITEM_LEVEL_CLICKS

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

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.

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.

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.

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.

ADSENSE_LINE_ITEM_LEVEL_REVENUE

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

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

AD_EXCHANGE_LINE_ITEM_LEVEL_CLICKS

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

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.

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.

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.

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.

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.

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.

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.

TOTAL_INVENTORY_LEVEL_IMPRESSIONS

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

TOTAL_LINE_ITEM_LEVEL_IMPRESSIONS

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

TOTAL_LINE_ITEM_LEVEL_TARGETED_IMPRESSIONS

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

TOTAL_LINE_ITEM_LEVEL_IMPRESSIONS_INCLUDING_OUT_OF_NETWORK_DELIVERY

The total number of impressions delivered by the ad server on a shared inventory unit in a partner's network and through line item-level dynamic allocation.

TOTAL_INVENTORY_LEVEL_CLICKS

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

TOTAL_LINE_ITEM_LEVEL_CLICKS

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

TOTAL_LINE_ITEM_LEVEL_TARGETED_CLICKS

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

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.

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.

TOTAL_INVENTORY_LEVEL_CPM_AND_CPC_REVENUE

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

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.

TOTAL_LINE_ITEM_LEVEL_ALL_REVENUE

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

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.

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.

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.

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.

TOTAL_UNFILLED_IMPRESSIONS_INCLUDING_OUT_OF_NETWORK_DELIVERY

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

MERGED_AD_SERVER_DELIVERY_INDICATOR

Indicates the progress made for the delivery of the LineItem based on the units delivered by both DART and DoubleClick For Publishers ad servers. This is only available for networks that have been upgraded from the old to the new system.

Progress	Definition
100%	The LineItem is on track to deliver in full as per LineItem.unitsBought.
> 100%	The LineItem is on track to overdeliver.
< 100%	The LineItem is on track to underdeliver.
N/A	The LineItem does not have any quantity goals, or there is insufficient information about the LineItem.

This column is deprecated use AD_SERVER_DELIVERY_INDICATOR instead.

MERGED_AD_SERVER_IMPRESSIONS

The total number of impressions delivered by both DART and DoubleClick For Publishers ad servers. This is only available for networks that have been upgraded from the old to the new system.

DART data is available for the following timeframes:

• 6 months before upgrade date for daily reports.
• 16 months before upgrade date for monthly reports.

• This column is deprecated use AD_SERVER_IMPRESSIONS instead.

MERGED_AD_SERVER_CLICKS

The total number of clicks delivered by both DART and DoubleClick For Publishers ad servers. This is only available for networks that have been upgraded from the old to the new system.

DART data is available for the following timeframes:

• 6 months before upgrade date for daily reports.
• 16 months before upgrade date for monthly reports.

• This column is deprecated use AD_SERVER_CLICKS instead.

MERGED_AD_SERVER_CTR

The sum of the CTR achieved from both DART and DoubleClick For Publishers ad servers. This is only available for networks that have been upgraded from the old to the new system.

DART data is available for the following timeframes:

• 6 months before upgrade date for daily reports.
• 16 months before upgrade date for monthly reports.

• This column is deprecated use AD_SERVER_CTR instead.

MERGED_AD_SERVER_CPM_AND_CPC_REVENUE

The sum of the CPM and CPC revenue generated from both DART and DoubleClick For Publishers ad servers. This is only available for networks that have been upgraded from the old to the new system.

DART data is available for the following timeframes:

• 6 months before upgrade date for daily reports.
• 16 months before upgrade date for monthly reports.

• This column is deprecated use AD_SERVER_CPM_AND_CPC_REVENUE instead.

MERGED_AD_SERVER_ALL_REVENUE

The sum of the CPM, CPC and CPD revenue generated from both DART and DoubleClick For Publishers ad servers. This is only available for networks that have been upgraded from the old to the new system.

DART data is available for the following timeframes:

• 6 months before upgrade date for daily reports.
• 16 months before upgrade date for monthly reports.

• This column is deprecated use AD_SERVER_ALL_REVENUE instead.

MERGED_AD_SERVER_WITHOUT_CPD_AVERAGE_ECPM

The average estimated cost-per-thousand-impressions earned from the CPM and CPC ads delivered by both DART and DoubleClick For Publishers ad servers. This is only available for networks that have been upgraded from the old to the new system.

DART data is available for the following timeframes:

• 6 months before upgrade date for daily reports.
• 16 months before upgrade date for monthly reports.

• This column is deprecated use AD_SERVER_WITHOUT_CPD_AVERAGE_ECPM instead.

MERGED_AD_SERVER_WITH_CPD_AVERAGE_ECPM

The average estimated cost-per-thousand-impressions earned from the CPM, CPC and CPD ads delivered by both DART and DoubleClick For Publishers ad servers. This is only available for networks that have been upgraded from the old to the new system.

DART data is available for the following timeframes:

• 6 months before upgrade date for daily reports.
• 16 months before upgrade date for monthly reports.

• This column is deprecated use AD_SERVER_WITH_CPD_AVERAGE_ECPM instead.

OPTIMIZATION_CONTROL_IMPRESSIONS

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

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.

OPTIMIZATION_CONTROL_CTR

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

OPTIMIZATION_OPTIMIZED_IMPRESSIONS

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

OPTIMIZATION_OPTIMIZED_CLICKS

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

OPTIMIZATION_NON_OPTIMIZED_IMPRESSIONS

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

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.

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.

OPTIMIZATION_OPTIMIZED_CTR

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

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.

OPTIMIZATION_COVERAGE

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

OPTIMIZATION_BEHIND_SCHEDULE_IMPRESSIONS

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

OPTIMIZATION_NO_CLICKS_RECORDED_IMPRESSIONS

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

OPTIMIZATION_SPONSORSHIP_IMPRESSIONS

The number of impressions that were delivered as sponsorship items.

OPTIMIZATION_AS_FAST_AS_POSSIBLE_IMPRESSIONS

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

OPTIMIZATION_NO_ABSOLUTE_LIFETIME_GOAL_IMPRESSIONS

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

OPTIMIZATION_CONTROL_REVENUE

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

OPTIMIZATION_OPTIMIZED_REVENUE

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

OPTIMIZATION_CONTROL_ECPM

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

OPTIMIZATION_OPTIMIZED_ECPM

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

OPTIMIZATION_FREED_UP_IMPRESSIONS

Freed-up impressions as a result of optimization.

OPTIMIZATION_ECPM_LIFT

Relative change in eCPM as a result of optimization.

REACH_FREQUENCY

The average number of ads displayed to each unique visitor.

REACH_AVERAGE_REVENUE

The average revenue earned per unique visitor.

REACH

The number of unique visitors.

GRP_POPULATION

The number of people in the given demographic bucket.

GRP_UNIQUE_AUDIENCE

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

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).

GRP_AUDIENCE_IMPRESSIONS

The number of impressions in the given demographic bucket.

GRP_AUDIENCE_IMPRESSIONS_SHARE

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

GRP_AUDIENCE_REACH

The audience reach calculated as GRP_UNIQUE_AUDIENCE / GRP_POPULATION.

GRP_AUDIENCE_AVERAGE_FREQUENCY

The audience average frequency calculated as GRP_AUDIENCE_IMPRESSIONS / GRP_UNIQUE_AUDIENCE.

GRP_GROSS_RATING_POINTS

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

SDK_MEDIATION_CREATIVE_IMPRESSIONS

The number of impressions for a particular SDK mediation creative.

SDK_MEDIATION_CREATIVE_CLICKS

The number of clicks for a particular SDK mediation creative.

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.

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.

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.

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.

RICH_MEDIA_BACKUP_IMAGES

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

RICH_MEDIA_DISPLAY_TIME

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

RICH_MEDIA_AVERAGE_DISPLAY_TIME

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

RICH_MEDIA_EXPANSIONS

The number of times an expanding ad was expanded.

RICH_MEDIA_EXPANDING_TIME

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

RICH_MEDIA_INTERACTION_TIME

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

RICH_MEDIA_INTERACTION_COUNT

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

RICH_MEDIA_INTERACTION_RATE

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

RICH_MEDIA_AVERAGE_INTERACTION_TIME

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

RICH_MEDIA_INTERACTION_IMPRESSIONS

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

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.

RICH_MEDIA_FULL_SCREEN_IMPRESSIONS

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

RICH_MEDIA_VIDEO_INTERACTIONS

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

RICH_MEDIA_VIDEO_INTERACTION_RATE

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

RICH_MEDIA_VIDEO_MUTES

The number of times a rich media video was muted.

RICH_MEDIA_VIDEO_PAUSES

The number of times a rich media video was paused.

RICH_MEDIA_VIDEO_PLAYES

The number of times a rich media video was played.

RICH_MEDIA_VIDEO_MIDPOINTS

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

RICH_MEDIA_VIDEO_COMPLETES

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

RICH_MEDIA_VIDEO_REPLAYS

The number of times a rich media video was restarted.

RICH_MEDIA_VIDEO_STOPS

The number of times a rich media video was stopped.

RICH_MEDIA_VIDEO_UNMUTES

The number of times a rich media video was unmuted.

RICH_MEDIA_VIDEO_VIEW_TIME

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

RICH_MEDIA_VIDEO_VIEW_RATE

The percentage of a video watched by a user.

RICH_MEDIA_CUSTOM_EVENT_TIME

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

RICH_MEDIA_CUSTOM_EVENT_COUNT

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

VIDEO_VIEWERSHIP_START

The number of impressions where the video was played.

VIDEO_VIEWERSHIP_FIRST_QUARTILE

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

VIDEO_VIEWERSHIP_MIDPOINT

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

VIDEO_VIEWERSHIP_THIRD_QUARTILE

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

VIDEO_VIEWERSHIP_COMPLETE

The number of times the video played to completion.

VIDEO_VIEWERSHIP_AVERAGE_VIEW_RATE

Average percentage of the video watched by users.

VIDEO_VIEWERSHIP_AVERAGE_VIEW_TIME

Average time(seconds) users watched the video.

VIDEO_VIEWERSHIP_COMPLETION_RATE

Percentage of times the video played to the end.

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.

VIDEO_VIEWERSHIP_VIDEO_LENGTH

Duration of the video creative.

VIDEO_VIEWERSHIP_SKIP_BUTTON_SHOWN

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

VIDEO_VIEWERSHIP_ENGAGED_VIEW

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

VIDEO_VIEWERSHIP_VIEW_THROUGH_RATE

View-through rate represented as a percentage.

VIDEO_VIEWERSHIP_TOTAL_ERROR_RATE

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

VIDEO_ERRORS_VAST_2_ERROR_COUNT

Number of VAST2 video errors.

VIDEO_ERRORS_VAST_3_ERROR_100_COUNT

Number of VAST3 video errors of type 100.

VIDEO_ERRORS_VAST_3_ERROR_101_COUNT

Number of VAST3 video errors of type 101.

VIDEO_ERRORS_VAST_3_ERROR_102_COUNT

Number of VAST3 video errors of type 102.

VIDEO_ERRORS_VAST_3_ERROR_200_COUNT

Number of VAST3 video errors of type 200.

VIDEO_ERRORS_VAST_3_ERROR_201_COUNT

Number of VAST3 video errors of type 201.

VIDEO_ERRORS_VAST_3_ERROR_202_COUNT

Number of VAST3 video errors of type 202.

VIDEO_ERRORS_VAST_3_ERROR_203_COUNT

Number of VAST3 video errors of type 203.

VIDEO_ERRORS_VAST_3_ERROR_300_COUNT

Number of VAST3 video errors of type 300.

VIDEO_ERRORS_VAST_3_ERROR_301_COUNT

Number of VAST3 video errors of type 301.

VIDEO_ERRORS_VAST_3_ERROR_302_COUNT

Number of VAST3 video errors of type 302.

VIDEO_ERRORS_VAST_3_ERROR_303_COUNT

Number of VAST3 video errors of type 303.

VIDEO_ERRORS_VAST_3_ERROR_400_COUNT

Number of VAST3 video errors of type 400.

VIDEO_ERRORS_VAST_3_ERROR_401_COUNT

Number of VAST3 video errors of type 401.

VIDEO_ERRORS_VAST_3_ERROR_402_COUNT

Number of VAST3 video errors of type 402.

VIDEO_ERRORS_VAST_3_ERROR_403_COUNT

Number of VAST3 video errors of type 403.

VIDEO_ERRORS_VAST_3_ERROR_405_COUNT

Number of VAST3 video errors of type 405.

VIDEO_ERRORS_VAST_3_ERROR_500_COUNT

Number of VAST3 video errors of type 500.

VIDEO_ERRORS_VAST_3_ERROR_501_COUNT

Number of VAST3 video errors of type 501.

VIDEO_ERRORS_VAST_3_ERROR_502_COUNT

Number of VAST3 video errors of type 502.

VIDEO_ERRORS_VAST_3_ERROR_503_COUNT

Number of VAST3 video errors of type 503.

VIDEO_ERRORS_VAST_3_ERROR_600_COUNT

Number of VAST3 video errors of type 600.

VIDEO_ERRORS_VAST_3_ERROR_601_COUNT

Number of VAST3 video errors of type 601.

VIDEO_ERRORS_VAST_3_ERROR_602_COUNT

Number of VAST3 video errors of type 602.

VIDEO_ERRORS_VAST_3_ERROR_603_COUNT

Number of VAST3 video errors of type 603.

VIDEO_ERRORS_VAST_3_ERROR_604_COUNT

Number of VAST3 video errors of type 604.

VIDEO_ERRORS_VAST_3_ERROR_900_COUNT

Number of VAST3 video errors of type 900.

VIDEO_ERRORS_VAST_3_ERROR_901_COUNT

Number of VAST3 video errors of type 901.

VIDEO_INTERACTION_PAUSE

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

VIDEO_INTERACTION_RESUME

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

VIDEO_INTERACTION_REWIND

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

VIDEO_INTERACTION_MUTE

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

VIDEO_INTERACTION_UNMUTE

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

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.

VIDEO_INTERACTION_EXPAND

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

VIDEO_INTERACTION_FULL_SCREEN

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

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.

VIDEO_INTERACTION_VIDEO_SKIPS

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

VIDEO_OPTIMIZATION_CONTROL_STARTS

The number of control starts.

VIDEO_OPTIMIZATION_OPTIMIZED_STARTS

The number of optimized starts.

VIDEO_OPTIMIZATION_CONTROL_COMPLETES

The number of control completes.

VIDEO_OPTIMIZATION_OPTIMIZED_COMPLETES

The number of optimized completes.

VIDEO_OPTIMIZATION_CONTROL_COMPLETION_RATE

The rate of control completions.

VIDEO_OPTIMIZATION_OPTIMIZED_COMPLETION_RATE

The rate of optimized completions.

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.

VIDEO_OPTIMIZATION_CONTROL_SKIP_BUTTON_SHOWN

The number of control skip buttons shown.

VIDEO_OPTIMIZATION_OPTIMIZED_SKIP_BUTTON_SHOWN

The number of optimized skip buttons shown.

VIDEO_OPTIMIZATION_CONTROL_ENGAGED_VIEW

The number of control engaged views.

VIDEO_OPTIMIZATION_OPTIMIZED_ENGAGED_VIEW

The number of optimized engaged views.

VIDEO_OPTIMIZATION_CONTROL_VIEW_THROUGH_RATE

The control view-through rate.

VIDEO_OPTIMIZATION_OPTIMIZED_VIEW_THROUGH_RATE

The optimized view-through rate.

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.

TOTAL_ACTIVE_VIEW_VIEWABLE_IMPRESSIONS

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

TOTAL_ACTIVE_VIEW_MEASURABLE_IMPRESSIONS

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

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.

TOTAL_ACTIVE_VIEW_MEASURABLE_IMPRESSIONS_RATE

The percentage of total impressions that were measurable by active view (out of all the total impressions sampled for active view).

AD_SERVER_ACTIVE_VIEW_VIEWABLE_IMPRESSIONS

The number of impressions delivered by the ad server viewed on the user's screen.

AD_SERVER_ACTIVE_VIEW_MEASURABLE_IMPRESSIONS

The number of impressions delivered by the ad server that were sampled, and measurable by active view.

AD_SERVER_ACTIVE_VIEW_VIEWABLE_IMPRESSIONS_RATE

The percentage of impressions delivered by the ad server viewed on the user's screen (out of the ad server impressions measurable by active view).

AD_SERVER_ACTIVE_VIEW_ELIGIBLE_IMPRESSIONS

Total number of impressions delivered by the ad server that were eligible to measure viewability.

AD_SERVER_ACTIVE_VIEW_MEASURABLE_IMPRESSIONS_RATE

The percentage of impressions delivered by the ad server that were measurable by active view ( out of all the ad server impressions sampled for active view).

ADSENSE_ACTIVE_VIEW_VIEWABLE_IMPRESSIONS

The number of impressions delivered by AdSense viewed on the user's screen,

ADSENSE_ACTIVE_VIEW_MEASURABLE_IMPRESSIONS

The number of impressions delivered by AdSense that were sampled, and measurable by active view.

ADSENSE_ACTIVE_VIEW_VIEWABLE_IMPRESSIONS_RATE

The percentage of impressions delivered by AdSense viewed on the user's screen (out of AdSense impressions measurable by active view).

ADSENSE_ACTIVE_VIEW_ELIGIBLE_IMPRESSIONS

Total number of impressions delivered by AdSense that were eligible to measure viewability.

ADSENSE_ACTIVE_VIEW_MEASURABLE_IMPRESSIONS_RATE

The percentage of impressions delivered by AdSense that were measurable by active view ( out of all AdSense impressions sampled for active view).

AD_EXCHANGE_ACTIVE_VIEW_VIEWABLE_IMPRESSIONS

The number of impressions delivered by Ad Exchange viewed on the user's screen,

AD_EXCHANGE_ACTIVE_VIEW_MEASURABLE_IMPRESSIONS

The number of impressions delivered by Ad Exchange that were sampled, and measurable by active view.

AD_EXCHANGE_ACTIVE_VIEW_VIEWABLE_IMPRESSIONS_RATE

The percentage of impressions delivered by Ad Exchange viewed on the user's screen (out of Ad Exchange impressions measurable by active view).

AD_EXCHANGE_ACTIVE_VIEW_ELIGIBLE_IMPRESSIONS

Total number of impressions delivered by Ad Exchange that were eligible to measure viewability.

AD_EXCHANGE_ACTIVE_VIEW_MEASURABLE_IMPRESSIONS_RATE

The percentage of impressions delivered by Ad Exchange that were measurable by active view ( out of all Ad Exchange impressions sampled for active view).

DISTRIBUTION_PARTNER_IMPRESSIONS

The total number of impressions delivered by the network to the distribution partner.

DISTRIBUTION_PARTNER_CLICKS

The total number of clicks delivered by the network to the distribution partner.

DISTRIBUTION_PARTNER_CTR

The ratio of clicks to the total number of impressions delivered by the network to the distribution partner.

DISTRIBUTION_PARTNER_GROSS_REVENUE

The total revenue generated by the network to the distribution partner. It could be estimated or reconiled revenue according to current stage.

DISTRIBUTION_PARTNER_HOST_REVENUE

The host revenue generated by the network host through the distribution partner inventory units. It could be estimated or reconiled revenue according to current stage.

DISTRIBUTION_PARTNER_HOST_ECPM

Cost-per-thousand-impressions (eCPM) generated by the network host through the distribution partner inventory units. It could be estimated or reconiled eCPM according to current stage.

DISTRIBUTION_PARTNER_PARTNER_REVENUE

The revenue generated by the network distribution partner. It could be estimated or reconiled revenue according to current stage.

DISTRIBUTION_PARTNER_PARTNER_ECPM

Cost-per-thousand-impressions (eCPM) generated by the distribution partner. It could be estimated or reconiled eCPM according to current stage.

CONTENT_PARTNER_IMPRESSIONS

The total number of impressions delivered by the network to the content partner.

CONTENT_PARTNER_CLICKS

The total number of clicks delivered by the network to the content partner.

CONTENT_PARTNER_CTR

The ratio of clicks to the total number of impressions delivered by the network to the content partner.

CONTENT_PARTNER_GROSS_REVENUE

The total revenue generated by the network to the content partner. It could be estimated or reconiled revenue according to current stage.

CONTENT_PARTNER_HOST_REVENUE

The host revenue generated by the network host through the content partner's contents. It could be estimated or reconiled revenue according to current stage.

CONTENT_PARTNER_HOST_ECPM

Cost-per-thousand-impressions (eCPM) generated by the network host to the content partner's contents. It could be estimated or reconiled eCPM according to current stage.

CONTENT_PARTNER_PARTNER_REVENUE

The revenue generated by the network content partner. It could be estimated or reconiled revenue according to current stage.

CONTENT_PARTNER_PARTNER_ECPM

Cost-per-thousand-impressions (eCPM) generated by the content partner. It could be estimated or reconiled eCPM according to current stage.

RIGHTS_HOLDER_IMPRESSIONS

The total number of impressions delivered by the network to the rights holder.

RIGHTS_HOLDER_CLICKS

The total number of clicks delivered by the network to the rights holder.

RIGHTS_HOLDER_CTR

The ratio of clicks to the total number of impressions delivered by the network to the rights holder.

RIGHTS_HOLDER_GROSS_REVENUE

The total revenue generated by the network to the rights holder. It could be estimated or reconiled revenue according to current stage.

RIGHTS_HOLDER_HOST_REVENUE

The host revenue generated by the network host through the rights holder's contents. It could be estimated or reconiled revenue according to current stage.

RIGHTS_HOLDER_HOST_ECPM

Cost-per-thousand-impressions (eCPM) generated by the network host through the rights holder's contents. It could be estimated or reconiled eCPM according to current stage.

RIGHTS_HOLDER_PARTNER_REVENUE

The revenue generated by the network rights holder. It could be estimated or reconiled revenue according to current stage.

RIGHTS_HOLDER_PARTNER_ECPM

Cost-per-thousand-impressions (eCPM) generated by the rights holder. It could be estimated or reconiled eCPM according to current stage.

VIEW_THROUGH_CONVERSIONS

Number of view-through conversions.

CONVERSIONS_PER_THOUSAND_IMPRESSIONS

Number of view-through conversions per thousand impressions.

CLICK_THROUGH_CONVERSIONS

Number of click-through conversions.

CONVERSIONS_PER_CLICK

Number of click-through conversions per click.

VIEW_THROUGH_REVENUE

Revenue for view-through conversions.

CLICK_THROUGH_REVENUE

Revenue for click-through conversions.

TOTAL_CONVERSIONS

Total number of conversions.

TOTAL_CONVERSION_REVENUE

Total revenue for conversions.

DYNAMIC_ALLOCATION_OPPORTUNITY_IMPRESSIONS_COMPETING_TOTAL

The number of impressions sent to Ad Exchange / AdSense, regardless of whether they won or lost (total number of dynamic allocation impressions).

DYNAMIC_ALLOCATION_OPPORTUNITY_UNFILLED_IMPRESSIONS_COMPETING

The number of unfilled queries that attempted dynamic allocation by Ad Exchange / AdSense.

DYNAMIC_ALLOCATION_OPPORTUNITY_ELIGIBLE_IMPRESSIONS_TOTAL

The number of Ad Exchange / AdSense and DFP impressions.

DYNAMIC_ALLOCATION_OPPORTUNITY_IMPRESSIONS_NOT_COMPETING_TOTAL

The difference between eligible impressions and competing impressions in dynamic allocation.

DYNAMIC_ALLOCATION_OPPORTUNITY_IMPRESSIONS_NOT_COMPETING_PERCENT_TOTAL

The percentage of eligible impressions that are not competing in dynamic allocation.

DYNAMIC_ALLOCATION_OPPORTUNITY_SATURATION_RATE_TOTAL

The percent of eligible impressions participating in dynamic allocation.

DYNAMIC_ALLOCATION_OPPORTUNITY_MATCH_RATE_TOTAL

The percent of total dynamic allocation queries that won.

CONTRACTED_REVENUE_CONTRACTED_NET_REVENUE

The contracted net revenue of the ProposalLineItem.

CONTRACTED_REVENUE_LOCAL_CONTRACTED_NET_REVENUE

The contracted net revenue in the local currency of the ProposalLineItem. See CONTRACTED_REVENUE_CONTRACTED_NET_REVENUE

CONTRACTED_REVENUE_CONTRACTED_GROSS_REVENUE

The contracted gross revenue of the ProposalLineItem, including agency commission.

CONTRACTED_REVENUE_LOCAL_CONTRACTED_GROSS_REVENUE

The contracted gross revenue in the local currency of the ProposalLineItem, including agency commission. See CONTRACTED_REVENUE_CONTRACTED_GROSS_REVENUE

CONTRACTED_REVENUE_CONTRACTED_PLACEMENT_NET_REVENUE

The contracted net revenue of the ProposalLineItem. This revenue is the raw revenue without a Proposal level additional adjustment applied.

CONTRACTED_REVENUE_CONTRACTED_PLACEMENT_GROSS_REVENUE

The contracted gross revenue of the ProposalLineItem. This revenue is the raw revenue without a Proposal level additional adjustment applied, and including agency commission.

CONTRACTED_REVENUE_CONTRACTED_VAT

The value added tax on contracted net revenue of the ProposalLineItem or Proposal.

CONTRACTED_REVENUE_LOCAL_CONTRACTED_VAT

The value added tax on contracted net revenue in the local currency of the ProposalLineItem or Proposal. See CONTRACTED_REVENUE_CONTRACTED_VAT

CONTRACTED_REVENUE_CONTRACTED_AGENCY_COMMISSION

The contracted agency commission of the ProposalLineItem or Proposal.

CONTRACTED_REVENUE_LOCAL_CONTRACTED_AGENCY_COMMISSION

The contracted agency commission in the local currency of the ProposalLineItem or Proposal. See CONTRACTED_REVENUE_CONTRACTED_AGENCY_COMMISSION

SALES_CONTRACT_CONTRACTED_IMPRESSIONS

The contracted impressions of the ProposalLineItem.

SALES_CONTRACT_CONTRACTED_CLICKS

The contracted clicks of the ProposalLineItem.

SALES_CONTRACT_CONTRACTED_VOLUME

The contracted volume of the ProposalLineItem. Volume represents impressions for rate type CPM, clicks for CPC, and days for CPD.

SALES_CONTRACT_BUDGET

The budget of the Proposal.

SALES_CONTRACT_REMAINING_BUDGET

The remaining budget of the Proposal. It is calculated by subtracting the contracted net revenue from the budget.

SALES_CONTRACT_BUFFERED_IMPRESSIONS

The buffered impressions of the ProposalLineItem.

SALES_CONTRACT_BUFFERED_CLICKS

The buffered clicks of the ProposalLineItem.

SCHEDULED_SCHEDULED_IMPRESSIONS

The scheduled impressions of a ProposalLineItem. It is the sum of SALES_CONTRACT_CONTRACTED_IMPRESSIONS and SALES_CONTRACT_BUFFERED_IMPRESSIONS.

SCHEDULED_SCHEDULED_CLICKS

The scheduled clicks of a ProposalLineItem. It is the sum of SALES_CONTRACT_CONTRACTED_CLICKS and SALES_CONTRACT_BUFFERED_CLICKS.

SCHEDULED_SCHEDULED_VOLUME

The scheduled volume of a ProposalLineItem. It is the sum of SALES_CONTRACT_CONTRACTED_VOLUME and buffered volume.

SCHEDULED_SCHEDULED_NET_REVENUE

The scheduled net revenue of a ProposalLineItem.

SCHEDULED_LOCAL_SCHEDULED_NET_REVENUE

The scheduled net revenue in the local currency of a ProposalLineItem.

SCHEDULED_SCHEDULED_GROSS_REVENUE

The scheduled gross revenue of a ProposalLineItem.

SCHEDULED_LOCAL_SCHEDULED_GROSS_REVENUE

The scheduled gross revenue in the local currency of a ProposalLineItem.

SALES_TOTAL_TOTAL_BUDGET

The total budget of the Proposal. It differs from SALES_CONTRACT_BUDGET since it always contains the total budget, not the prorated budget.

SALES_TOTAL_TOTAL_REMAINING_BUDGET

The total remaining budget of the Proposal. It differs from SALES_CONTRACT_REMAINING_BUDGET since it always contains the total remaining budget, not the prorated remaining budget.

SALES_TOTAL_TOTAL_CONTRACTED_VOLUME

The total contracted volume of the ProposalLineItem. It differs from SALES_CONTRACT_CONTRACTED_VOLUME that the volume is not prorated with regard to the date range.

SALES_TOTAL_TOTAL_CONTRACTED_NET_REVENUE

The total contracted net revenue of the ProposalLineItem. It differs from CONTRACTED_REVENUE_CONTRACTED_NET_REVENUE that the revenue is not prorated with regard to the date range.

SALES_TOTAL_LOCAL_TOTAL_CONTRACTED_NET_REVENUE

The total contracted net revenue in the local currency of the ProposalLineItem. It differs from CONTRACTED_REVENUE_LOCAL_CONTRACTED_NET_REVENUE that the revenue is not prorated with regard to the date range. See SALES_TOTAL_TOTAL_CONTRACTED_NET_REVENUE

SALES_TOTAL_TOTAL_CONTRACTED_GROSS_REVENUE

The total contracted gross revenue of the ProposalLineItem. It differs from CONTRACTED_REVENUE_CONTRACTED_GROSS_REVENUE that the revenue is not prorated with regard to the date range.

SALES_TOTAL_LOCAL_TOTAL_CONTRACTED_GROSS_REVENUE

The total contracted gross revenue in the local currency of the ProposalLineItem. It differs from CONTRACTED_REVENUE_LOCAL_CONTRACTED_GROSS_REVENUE that the revenue is not prorated with regard to the date range. See SALES_TOTAL_TOTAL_CONTRACTED_GROSS_REVENUE

SALES_TOTAL_TOTAL_CONTRACTED_AGENCY_COMMISSION

The total contracted agency commission of the ProposalLineItem. It differs from CONTRACTED_REVENUE_CONTRACTED_AGENCY_COMMISSION that the revenue is not prorated with regard to the date range.

SALES_TOTAL_LOCAL_TOTAL_CONTRACTED_AGENCY_COMMISSION

The total contracted agency commission in the local currency of the ProposalLineItem. It differs from CONTRACTED_REVENUE_LOCAL_CONTRACTED_AGENCY_COMMISSION that the revenue is not prorated with regard to the date range. See SALES_TOTAL_TOTAL_CONTRACTED_AGENCY_COMMISSION

SALES_TOTAL_TOTAL_CONTRACTED_NET_REVENUE_WITH_VAT

The total net revenue plus its value added tax of the ProposalLineItem. The revenue is not prorated with regard to the date range.

SALES_TOTAL_LOCAL_TOTAL_CONTRACTED_NET_REVENUE_WITH_VAT

The total net revenue plus its value added tax in the local currency of the ProposalLineItem. The revenue is not prorated with regard to the date range. See SALES_TOTAL_TOTAL_CONTRACTED_WITH_VAT

SALES_TOTAL_TOTAL_SCHEDULED_VOLUME

The total scheduled volume of the ProposalLineItem. It differs from SCHEDULED_SCHEDULED_VOLUME that the volume is not prorated with regard to the date range.

SALES_TOTAL_TOTAL_SCHEDULED_NET_REVENUE

The total scheduled net revenue of the ProposalLineItem. It differs from SCHEDULED_SCHEDULED_NET_REVENUE that the revenue is not prorated with regard to the date range.

SALES_TOTAL_LOCAL_TOTAL_SCHEDULED_NET_REVENUE

The total scheduled net revenue in the local currency of the ProposalLineItem. It differs from SCHEDULED_LOCAL_SCHEDULED_NET_REVENUE that the revenue is not prorated with regard to the date range. See SALES_TOTAL_TOTAL_SCHEDULED_NET_REVENUE

SALES_TOTAL_TOTAL_SCHEDULED_GROSS_REVENUE

The total scheduled gross revenue of the ProposalLineItem. It differs from SCHEDULED_SCHEDULED_GROSS_REVENUE that the revenue is not prorated with regard to the date range.

SALES_TOTAL_LOCAL_TOTAL_SCHEDULED_GROSS_REVENUE

The total scheduled gross revenue in the local currency of the ProposalLineItem. It differs from SCHEDULED_LOCAL_SCHEDULED_GROSS_REVENUE that the revenue is not prorated with regard to the date range. See SALES_TOTAL_TOTAL_SCHEDULED_GROSS_REVENUE

UNIFIED_REVENUE_UNRECONCILED_NET_REVENUE

The unreconciled net revenue of the ProposalLineItem. It is the portion of UNIFIED_REVENUE_UNIFIED_NET_REVENUE coming from unreconciled DFP volume.

UNIFIED_REVENUE_LOCAL_UNRECONCILED_NET_REVENUE

The unreconciled net revenue of the ProposalLineItem in local currency. It is the portion of UNIFIED_REVENUE_LOCAL_UNIFIED_NET_REVENUE coming from unreconciled DFP volume. See UNIFIED_REVENUE_UNRECONCILED_NET_REVENUE

UNIFIED_REVENUE_UNRECONCILED_GROSS_REVENUE

The unreconciled gross revenue of the ProposalLineItem. It is the portion of UNIFIED_REVENUE_UNIFIED_GROSS_REVENUE coming from unreconciled DFP volume.

UNIFIED_REVENUE_LOCAL_UNRECONCILED_GROSS_REVENUE

The unreconciled gross revenue of the ProposalLineItem in local currency. It is the portion of UNIFIED_REVENUE_LOCAL_UNIFIED_GROSS_REVENUE coming from unreconciled DFP volume. See UNIFIED_REVENUE_UNRECONCILED_GROSS_REVENUE

UNIFIED_REVENUE_FORECASTED_NET_REVENUE

The forecasted net revenue of the ProposalLineItem. It is the portion of UNIFIED_REVENUE_UNIFIED_NET_REVENUE coming from forecasted DFP volume.

UNIFIED_REVENUE_LOCAL_FORECASTED_NET_REVENUE

The forecasted net revenue of the ProposalLineItem in local currency. It is the portion of UNIFIED_REVENUE_LOCAL_UNIFIED_NET_REVENUE coming from forecasted DFP volume. See UNIFIED_REVENUE_FORECASTED_NET_REVENUE

UNIFIED_REVENUE_FORECASTED_GROSS_REVENUE

The forecasted gross revenue of the ProposalLineItem. It is the portion of UNIFIED_REVENUE_UNIFIED_GROSS_REVENUE coming from forecasted DFP volume.

UNIFIED_REVENUE_LOCAL_FORECASTED_GROSS_REVENUE

The forecasted gross revenue of the ProposalLineItem in local currency. It is the portion of UNIFIED_REVENUE_LOCAL_UNIFIED_GROSS_REVENUE coming from forecasted DFP volume. See UNIFIED_REVENUE_FORECASTED_GROSS_REVENUE

UNIFIED_REVENUE_UNIFIED_NET_REVENUE

The unified net revenue of the ProposalLineItem. It is a combination of UNIFIED_REVENUE_UNRECONCILED_NET_REVENUE, BILLING_BILLABLE_NET_REVENUE, and UNIFIED_REVENUE_FORECASTED_NET_REVENUE when query date range spans historical delivery and forecasted delivery.

UNIFIED_REVENUE_LOCAL_UNIFIED_NET_REVENUE

The unified net revenue of the ProposalLineItem in local currency. It is a combination of UNIFIED_REVENUE_LOCAL_UNRECONCILED_NET_REVENUE, BILLING_LOCAL_BILLABLE_NET_REVENUE, and UNIFIED_REVENUE_LOCAL_FORECASTED_NET_REVENUE when query date range spans historical delivery and forecasted delivery. See UNIFIED_REVENUE_UNIFIED_NET_REVENUE

UNIFIED_REVENUE_UNIFIED_GROSS_REVENUE

The unified net revenue of the ProposalLineItem. It is a combination of UNIFIED_REVENUE_UNRECONCILED_GROSS_REVENUE, BILLING_BILLABLE_GROSS_REVENUE, and UNIFIED_REVENUE_FORECASTED_GROSS_REVENUE when query date range spans historical delivery and forecasted delivery.

UNIFIED_REVENUE_LOCAL_UNIFIED_GROSS_REVENUE

The unified gross revenue of the ProposalLineItem in local currency. It is a combination of UNIFIED_REVENUE_LOCAL_UNRECONCILED_GROSS_REVENUE, BILLING_LOCAL_BILLABLE_GROSS_REVENUE, and UNIFIED_REVENUE_LOCAL_FORECASTED_GROSS_REVENUE when query date range spans historical delivery and forecasted delivery. See UNIFIED_REVENUE_UNIFIED_GROSS_REVENUE

UNIFIED_REVENUE_UNIFIED_AGENCY_COMMISSION

The unified agency commission of the ProposalLineItem. It is a combination of the unreconciled agency commission, the BILLING_BILLABLE_AGENCY_COMMISSION, and the forecasted agency commission when query date range spans historical delivery and forecasted delivery.

UNIFIED_REVENUE_LOCAL_UNIFIED_AGENCY_COMMISSION

The unified agency commission of the ProposalLineItem in local currency. It is a combination of the unreconciled agency commission, the BILLING_BILLABLE_AGENCY_COMMISSION, and the forecasted agency commission when query date range spans historical delivery and forecasted delivery. See UNIFIED_REVENUE_UNIFIED_AGENCY_COMMISSION

EXPECTED_REVENUE_EXPECTED_NET_REVENUE

The expected revenue of the ProposalLineItem. It is equivalent to UNIFIED_REVENUE_UNIFIED_NET_REVENUE when the ProposalLineItem is sold and SALES_PIPELINE_PIPELINE_NET_REVENUE otherwise.

EXPECTED_REVENUE_LOCAL_EXPECTED_NET_REVENUE

The expected revenue of the ProposalLineItem in local currency. It is equivalent to UNIFIED_REVENUE_LOCAL_UNIFIED_NET_REVENUE when the ProposalLineItem is sold and SALES_PIPELINE_LOCAL_PIPELINE_NET_REVENUE otherwise. See EXPECTED_REVENUE_EXPECTED_NET_REVENUE

EXPECTED_REVENUE_EXPECTED_GROSS_REVENUE

The expected gross revenue of the ProposalLineItem. It is equivalent to UNIFIED_REVENUE_UNIFIED_GROSS_REVENUE when the ProposalLineItem is sold and SALES_PIPELINE_PIPELINE_GROSS_REVENUE otherwise.

EXPECTED_REVENUE_LOCAL_EXPECTED_GROSS_REVENUE

The expected gross revenue of the ProposalLineItem in local currency. It is equivalent to UNIFIED_REVENUE_LOCAL_UNIFIED_GROSS_REVENUE when the ProposalLineItem is sold and SALES_PIPELINE_LOCAL_PIPELINE_GROSS_REVENUE otherwise. See EXPECTED_REVENUE_EXPECTED_GROSS_REVENUE

SALES_PIPELINE_PIPELINE_NET_REVENUE

The pipeline net revenue of the ProposalLineItem. It is calculated by multiplying probability to close by the contracted revenue for those unsold ProposalLineItems. There is no revenue for those sold ProposalLineItems.

SALES_PIPELINE_LOCAL_PIPELINE_NET_REVENUE

The pipeline net revenue in the local currency of the ProposalLineItem. It is calculated by multiplying probability to close by the contracted revenue for those unsold ProposalLineItems. There is no revenue for those sold ProposalLineItems. See SALES_PIPELINE_PIPELINE_NET_REVENUE

SALES_PIPELINE_PIPELINE_GROSS_REVENUE

The pipeline gross revenue of the ProposalLineItem. It is calculated by multiplying probability to close by the contracted revenue including agency commission for those unsold ProposalLineItems. There is no revenue for those sold ProposalLineItems.

SALES_PIPELINE_LOCAL_PIPELINE_GROSS_REVENUE

The pipeline gross revenue in the local currency of the ProposalLineItem. It is calculated by multiplying probability to close by the contracted revenue including agency commission for those unsold ProposalLineItems. There is no revenue for those sold ProposalLineItems. See SALES_PIPELINE_PIPELINE_GROSS_REVENUE

SALES_PIPELINE_PIPELINE_AGENCY_COMMISSION

The pipeline agency commission of the ProposalLineItem. It is calculated by multiplying probability to close by the contracted agency commission for those unsold ProposalLineItems. There is no revenue for those sold ProposalLineItems.

SALES_PIPELINE_LOCAL_PIPELINE_AGENCY_COMMISSION

The pipeline agency commission in the local currency of the ProposalLineItem. It is calculated by multiplying probability to close by the contracted agency commission for those unsold ProposalLineItems. There is no revenue for those sold ProposalLineItems. See SALES_PIPELINE_PIPELINE_AGENCY_COMMISSION

RECONCILIATION_LAST_DATE_TIME

The last reconciliation date of the ProposalLineItem.

Replaced with attribute PROPOSAL_LINE_ITEM_LAST_RECONCILIATION_DATE_TIME beginning in V201508.

RECONCILIATION_RECONCILIATION_STATUS

The reconciliation status of the ProposalLineItem.

Replaced with attribute PROPOSAL_LINE_ITEM_RECONCILIATION_STATUS beginning in V201508.

RECONCILIATION_DFP_VOLUME

The DFP volume of the ProposalLineItem, which is used for reconciliation. Volume represents impressions for rate type CPM, clicks for CPC and days for CPD.

RECONCILIATION_THIRD_PARTY_VOLUME

The third party volume of the ProposalLineItem, which is used for reconciliation. Volume represents impressions for rate type CPM, clicks for CPC and days for CPD.

RECONCILIATION_RECONCILED_VOLUME

The reconciled volume of the ProposalLineItem, which is used for reconciliation. Volume represents impressions for rate type CPM, clicks for CPC and days for CPD.

RECONCILIATION_DISCREPANCY

The discrepancy between DFP volume and third party volume.

RECONCILIATION_RECONCILED_REVENUE

The reconciled revenue of the LineItem.

RECONCILIATION_IMPRESSION_DISCREPANCY

The discrepancy between DFP impressions and third party impressions.

RECONCILIATION_CLICK_DISCREPANCY

The discrepancy between DFP clicks and third party clicks.

RECONCILIATION_REVENUE_DISCREPANCY

The discrepancy between DFP revenue and third party revenue.

BILLING_BILLABLE_NET_REVENUE

The billable net revenue of the ProposalLineItem. It is calculated from reconciled volume and rate, with cap applied.

BILLING_LOCAL_BILLABLE_NET_REVENUE

The billable net revenue in the local currency of the ProposalLineItem. It is calculated from reconciled volume and rate, with cap applied. See BILLING_BILLABLE_NET_REVENUE

BILLING_BILLABLE_GROSS_REVENUE

The billable gross revenue of the ProposalLineItem. It is calculated from reconciled volume and rate, with cap applied, and including agency commission.

BILLING_LOCAL_BILLABLE_GROSS_REVENUE

The billable gross revenue in the local currency of the ProposalLineItem. It is calculated from reconciled volume and rate, with cap applied, and including agency commission. See BILLING_BILLABLE_GROSS_REVENUE

BILLING_BILLABLE_NET_REVENUE_BEFORE_MANUAL_ADJUSTMENT

The billable net revenue of the ProposalLineItem before manual adjustment. It is calculated from reconciled volume and rate, with cap applied, before manual adjustment.

BILLING_LOCAL_BILLABLE_NET_REVENUE_BEFORE_MANUAL_ADJUSTMENT

The billable net revenue in local currency of the ProposalLineItem before manual adjustment. It is calculated from reconciled volume and rate, with cap applied, before manual adjustment. See BILLING_BILLABLE_NET_REVENUE_BEFORE_MANUAL_ADJUSTMENT

BILLING_BILLABLE_GROSS_REVENUE_BEFORE_MANUAL_ADJUSTMENT

The billable gross revenue of the ProposalLineItem before manual adjustment. It is calculated from reconciled volume and rate, with cap applied, before manual adjustment.

BILLING_LOCAL_BILLABLE_GROSS_REVENUE_BEFORE_MANUAL_ADJUSTMENT

The billable net revenue in local currency of the ProposalLineItem before manual adjustment. It is calculated from reconciled volume and rate, with cap applied, before manual adjustment. See BILLING_BILLABLE_GROSS_REVENUE_BEFORE_MANUAL_ADJUSTMENT

BILLING_BILLABLE_VAT

The value added tax on billable net revenue of the ProposalLineItem or Proposal.

BILLING_LOCAL_BILLABLE_VAT

The value added tax on billable net revenue in the local currency of the ProposalLineItem or Proposal. See BILLING_BILLABLE_VAT

BILLING_BILLABLE_AGENCY_COMMISSION

The billable agency commission of the ProposalLineItem or Proposal.

BILLING_LOCAL_BILLABLE_AGENCY_COMMISSION

The billable agency commission in the local currency of the ProposalLineItem or Proposal. See BILLING_BILLABLE_AGENCY_COMMISSION

BILLING_CAP_QUANTITY

The cap quantity of the ProposalLineItem for each cycle. Quantity represents impressions for rate type CPM, clicks for CPC and days for CPD.

BILLING_BILLABLE_VOLUME

The billable volume of the ProposalLineItem for each cycle. Billable volumes are calculated by applying cap quantity to reconciled volumes. Volume represents impressions for rate type CPM, clicks for CPC and days for CPD.

BILLING_DELIVERY_ROLLOVER_FROM_PREVIOUS

The delivery rollover volume of the ProposalLineItem from previous cycle. Volume represents impressions for rate type CPM, clicks for CPC and days for CPD.

BILLING_REALIZED_CPM

The CPM calcuated by BILLING_BILLABLE_NET_REVENUE and AD_SERVER_IMPRESSIONS.

BILLING_REALIZED_RATE

The rate calcuated by BILLING_BILLABLE_NET_REVENUE and DFP volume.

DISCOUNTS_BREAKDOWN_ADDITIONAL_ADJUSTMENT

The additional adjustment of the Proposal.

DISCOUNTS_BREAKDOWN_CONTRACTED_NET_OVERALL_DISCOUNT

The contracted net overall discount of the ProposalLineItem.

DISCOUNTS_BREAKDOWN_BILLABLE_NET_OVERALL_DISCOUNT

The billable net overall discount of the ProposalLineItem.

DISCOUNTS_BREAKDOWN_BILLABLE_NET_EXCLUDED_PREMIUMS

The billable net excluded premiums of the ProposalLineItem.

DISCOUNTS_BREAKDOWN_BILLABLE_NET_ADVERTISER_DISCOUNT

The billable net advertiser discount of the ProposalLineItem.

DISCOUNTS_BREAKDOWN_BILLABLE_NET_PRODUCT_ADJUSTMENT

The billable net product adjustment of the ProposalLineItem.

DISCOUNTS_BREAKDOWN_BILLABLE_NET_PROPOSAL_DISCOUNT

The billable net proposal discount of the ProposalLineItem.

DISCOUNTS_BREAKDOWN_CONTRACTED_NET_EXCLUDED_PREMIUMS

The contracted net excluded premiums of the ProposalLineItem.

DISCOUNTS_BREAKDOWN_CONTRACTED_NET_ADVERTISER_DISCOUNT

The contracted net advertiser discount of the ProposalLineItem.

DISCOUNTS_BREAKDOWN_CONTRACTED_NET_PRODUCT_ADJUSTMENT

The contracted net product adjustment of the ProposalLineItem.

DISCOUNTS_BREAKDOWN_CONTRACTED_NET_PROPOSAL_DISCOUNT

The contracted net proposal discount of the ProposalLineItem.

DISCOUNTS_BREAKDOWN_CONTRACTED_NET_NON_BILLABLE

The contracted non-billable (net) of the ProposalLineItem. The non-billable means revenue that marked as make good, added value or barter.

SALESPERSON_PERFORMANCE_SHARED_PIPELINE_NET_REVENUE

The shared pipeline net revenue of the ProposalLineItem. It is calculated by multiplying salesperson credit by the pipeline net revenue.

SALESPERSON_PERFORMANCE_SHARED_PIPELINE_GROSS_REVENUE

The shared pipeline gross revenue of the ProposalLineItem. It is calculated by multiplying salesperson credit by the pipeline gross revenue.

SALESPERSON_PERFORMANCE_SHARED_UNIFIED_NET_REVENUE

The shared unified net revenue of the ProposalLineItem. It is calculated by multiplying salesperson credit by the unified net revenue.

SALESPERSON_PERFORMANCE_SHARED_UNIFIED_GROSS_REVENUE

The shared unified gross revenue of the ProposalLineItem. It is calculated by multiplying salesperson credit by the unified gross revenue.

INVOICED_IMPRESSIONS

The number of invoiced impressions.

INVOICED_UNFILLED_IMPRESSIONS

The number of invoiced unfilled impressions.

NIELSEN_OCR_IMPRESSIONS

The total number of impressions tracked for Nielsen OCR measurement.

This column is deprecated and replaced with NIELSEN_IMPRESSIONS beginning in V201508.

NIELSEN_OCR_POPULATION_BASE

The population in the demographic.

This column is deprecated and replaced with NIELSEN_POPULATION_BASE beginning in V201508.

NIELSEN_OCR_UNIQUE_AUDIENCE

The total number of different people within the selected demographic who were reached.

This column is deprecated and replaced with NIELSEN_OCR_UNIQUE_AUDIENCE beginning in V201508.

NIELSEN_OCR_PERCENT_AUDIENCE_REACH

The unique audience reached as a percentage of the population base.

This column is deprecated and replaced with NIELSEN_PERCENT_AUDIENCE_REACH beginning in V201508.

NIELSEN_OCR_AVERAGE_FREQUENCY

The average number of times that a person within the target audience sees an advertisement.

This column is deprecated and replaced with NIELSEN_AVERAGE_FREQUENCY beginning in V201508.

NIELSEN_OCR_GROSS_RATING_POINTS

The unit of audience volume, which is based on the percentage of the reached target audience population multiplied by the average frequency.

This column is deprecated and replaced with NIELSEN_GROSS_RATING_POINTS beginning in V201508.

NIELSEN_OCR_PERCENT_IMPRESSIONS_SHARE

The share of impressions that reached the target demographic.

This column is deprecated and replaced with NIELSEN_PERCENT_IMPRESSIONS_SHARE beginning in V201508.

NIELSEN_OCR_PERCENT_POPULATION_SHARE

The share of the total population represented by the population base.

This column is deprecated and replaced with NIELSEN_PERCENT_POPULATION_SHARE beginning in V201508.

NIELSEN_OCR_PERCENT_AUDIENCE_SHARE

The share of the unique audience in the demographic.

This column is deprecated and replaced with NIELSEN_PERCENT_AUDIENCE_SHARE beginning in V201508.

NIELSEN_OCR_AUDIENCE_INDEX

The relative unique audience in the demographic compared with its share of the overall population.

This column is deprecated and replaced with NIELSEN_AUDIENCE_INDEX beginning in V201508.

NIELSEN_OCR_IMPRESSIONS_INDEX

The relative impressions per person in the demographic compared with the impressions per person for the overall population.

This column is deprecated and replaced with NIELSEN_IMPRESSIONS_INDEX beginning in V201508.

LINE_ITEM_LABELS

Represents LineItem.effectiveAppliedLabels as a comma separated list of Label.name for Dimension.LINE_ITEM_NAME.

LINE_ITEM_LABEL_IDS

Represents LineItem.effectiveAppliedLabels as a comma separated list of Label.id for Dimension.LINE_ITEM_NAME.

LINE_ITEM_OPTIMIZABLE

Generated as true for Dimension.LINE_ITEM_NAME which is eligible for optimization, false otherwise. Can be used for filtering.

LINE_ITEM_DELIVERY_PACING

Represents LineItem.deliveryRateType for Dimension.LINE_ITEM_NAME.

LINE_ITEM_FREQUENCY_CAP

Represents LineItem.frequencyCaps as a comma separated list of "FrequencyCap.maxImpressions impressions per/every FrequencyCap.numTimeUnits FrequencyCap.timeUnit" (e.g. "10 impressions every day,500 impressions per lifetime") for Dimension.LINE_ITEM_NAME.

LINE_ITEM_RECONCILED_RATE

Represents the monthly reconciled rate of the line item for Dimension.LINE_ITEM_NAME and Dimension.MONTH_AND_YEAR.

ADVERTISER_EXTERNAL_ID

Represents Company.externalId for Dimension.ADVERTISER_NAME.

ADVERTISER_PRIMARY_CONTACT

Represents name and email address in the form of name(email) of primary contact for Dimension.ADVERTISER_NAME.

ORDER_START_DATE_TIME

Represents Order.startDateTime for Dimension.ORDER_NAME. Can be used for filtering.

ORDER_END_DATE_TIME

Represents Order.endDateTime for Dimension.ORDER_NAME. Can be used for filtering.

ORDER_EXTERNAL_ID

Represents Order.externalOrderId for Dimension.ORDER_NAME.

ORDER_PO_NUMBER

Represents Order.poNumber for Dimension.ORDER_NAME. Can be used for filtering.

ORDER_IS_PROGRAMMATIC

Represents Order.orderIsProgrammatic for Dimension.ORDER_NAME. Can be used for filtering.

ORDER_AGENCY

Represents the name of Order.agencyId for Dimension.ORDER_NAME.

ORDER_AGENCY_ID

Represents Order.agencyId for Dimension.ORDER_NAME. Can be used for filtering.

ORDER_LABELS

Represents Order.effectiveAppliedLabels as a comma separated list of Label.name for Dimension.ORDER_NAME.

ORDER_LABEL_IDS

Represents Order.effectiveAppliedLabels as a comma separated list of Label.id for Dimension.ORDER_NAME.

ORDER_TRAFFICKER

The name and email address in the form of name(email) of the trafficker for Dimension.ORDER_NAME

ORDER_TRAFFICKER_ID

Represents Order.traffickerId for Dimension.ORDER_NAME. Can be used for filtering.

ORDER_SECONDARY_TRAFFICKERS

The names and email addresses as a comma separated list of name(email) of the Order.secondaryTraffickerIds for Dimension.ORDER_NAME.

ORDER_SALESPERSON

The name and email address in the form of name(email) of the Order.salespersonId for Dimension.ORDER_NAME.

ORDER_SECONDARY_SALESPEOPLE

The names and email addresses as a comma separated list of name(email) of the Order.secondarySalespersonIds for Dimension.ORDER_NAME.

ORDER_LIFETIME_IMPRESSIONS

The total number of impressions delivered over the lifetime of an Dimension.ORDER_NAME.

ORDER_LIFETIME_CLICKS

The total number of clicks delivered over the lifetime of an Dimension.ORDER_NAME.

ORDER_LIFETIME_MERGED_IMPRESSIONS

The lifetime impressions for Dimension.ORDER_NAME delivered by both DART and DoubleClick for Publishers ad servers. This is only available for networks that have been upgraded from the old to the new system.

This dimension attribute is deprecated use ORDER_LIFETIME_IMPRESSIONS instead.

ORDER_LIFETIME_MERGED_CLICKS

The lifetime clicks for Dimension.ORDER_NAME delivered by both DART and DoubleClick for Publishers ad servers. This is only available for networks that have been upgraded from the old to the new system.

This dimension attribute is deprecated use ORDER_LIFETIME_CLICKS instead.

ORDER_BOOKED_CPM

The cost of booking all the CPM ads for Dimension.ORDER_NAME.

ORDER_BOOKED_CPC

The cost of booking all the CPC ads for Dimension.ORDER_NAME.

LINE_ITEM_START_DATE_TIME

Represents LineItem.startDateTime for Dimension.LINE_ITEM_NAME. Can be used for filtering.

LINE_ITEM_END_DATE_TIME

Represents LineItem.endDateTime for Dimension.LINE_ITEM_NAME. Can be used for filtering.

LINE_ITEM_EXTERNAL_ID

Represents LineItem.externalId for Dimension.LINE_ITEM_NAME. Can be used for filtering.

LINE_ITEM_COST_TYPE

Represents LineItem.costType for Dimension.LINE_ITEM_NAME. Can be used for filtering.

LINE_ITEM_COST_PER_UNIT

Represents LineItem.costPerUnit for Dimension.LINE_ITEM_NAME.

LINE_ITEM_CURRENCY_CODE

Represents the 3 letter currency code for Dimension.LINE_ITEM_NAME.

LINE_ITEM_GOAL_QUANTITY

The total number of impressions, clicks or days that is reserved for Dimension.LINE_ITEM_NAME.

LINE_ITEM_SPONSORSHIP_GOAL_PERCENTAGE

The ratio between the goal quantity for Dimension.LINE_ITEM_NAME of LineItemType.SPONSORSHIP and the LINE_ITEM_GOAL_QUANTITY. Represented as a number between 0..100.

LINE_ITEM_LIFETIME_IMPRESSIONS

The total number of impressions delivered over the lifetime of a Dimension.LINE_ITEM_NAME.

LINE_ITEM_LIFETIME_CLICKS

The total number of clicks delivered over the lifetime of a Dimension.LINE_ITEM_NAME.

LINE_ITEM_LIFETIME_MERGED_IMPRESSIONS

The lifetime impressions for Dimension.LINE_ITEM_NAME delivered by both DART and DoubleClick for Publishers ad servers. This is only available for networks that have been upgraded from the old to the new system.

This dimension attribute is deprecated use LINE_ITEM_LIFETIME_IMPRESSIONS instead.

LINE_ITEM_LIFETIME_MERGED_CLICKS

The lifetime clicks for Dimension.LINE_ITEM_NAME delivered by both DART and DoubleClick for Publishers ad servers. This is only available for networks that have been upgraded from the old to the new system.

This dimension attribute is deprecated use LINE_ITEM_LIFETIME_CLICKS instead.

LINE_ITEM_PRIORITY

Represents LineItem.priority for Dimension.LINE_ITEM_NAME as a value between 1 and 16. Can be used for filtering.

CREATIVE_OR_CREATIVE_SET

Indicates if a creative is a regular creative or creative set. Values will be 'Creative' or 'Creative set'

MASTER_COMPANION_TYPE

The type of creative in a creative set - master or companion.

LINE_ITEM_CONTRACTED_QUANTITY

Represents the LineItem.contractedUnitsBought quantity for Dimension.LINE_ITEM_NAME.

LINE_ITEM_DISCOUNT

Represents the LineItem.discount for Dimension.LINE_ITEM_NAME. The number is either a percentage or an absolute value depending on LineItem.discountType.

LINE_ITEM_NON_CPD_BOOKED_REVENUE

The cost of booking for a non-CPD Dimension.LINE_ITEM_NAME.

ADVERTISER_LABELS

Represents Company.appliedLabels as a comma separated list of Label.name for Dimension.ADVERTISER_NAME.

ADVERTISER_LABEL_IDS

Represents Company.appliedLabels as a comma separated list of Label.id for Dimension.ADVERTISER_NAME.

CREATIVE_CLICK_THROUGH_URL

Represents the click-through URL for Dimension.CREATIVE_NAME.

CREATIVE_SSL_SCAN_RESULT

Represents whether a creative is SSL-compliant.

CREATIVE_SSL_COMPLIANCE_OVERRIDE

Represents whether a creative's SSL status was overridden.

LINE_ITEM_CREATIVE_START_DATE

Represents a LineItemCreativeAssociation.startDateTime for a Dimension.LINE_ITEM_NAME and a Dimension.CREATIVE_NAME. Includes the date without the time.

LINE_ITEM_CREATIVE_END_DATE

Represents a LineItemCreativeAssociation.endDateTime for a Dimension.LINE_ITEM_NAME and a Dimension.CREATIVE_NAME. Includes the date without the time.

PROPOSAL_START_DATE_TIME

Represents Proposal.startDateTime for Dimension.PROPOSAL_NAME.

PROPOSAL_END_DATE_TIME

Represents Proposal.endDateTime for Dimension.PROPOSAL_NAME.

PROPOSAL_CREATION_DATE_TIME

Represents Proposal.creationDateTime for Dimension.PROPOSAL_NAME. Can be used for filtering.

PROPOSAL_SOLD_DATE_TIME

Represents the sold time for Dimension.PROPOSAL_NAME.

PROPOSAL_IS_SOLD

Represents Proposal.isSold for Dimension.PROPOSAL_NAME. Can be used for filtering.

PROPOSAL_PROBABILITY_TO_CLOSE

Represents Proposal.probabilityToClose for Dimension.PROPOSAL_NAME.

PROPOSAL_STATUS

Represents Proposal.status for Dimension.PROPOSAL_NAME, including those post-sold status, e.g. DRAFT(SOLD). Can be used for filtering.

PROPOSAL_ARCHIVAL_STATUS

Represents Proposal.isArchived for Dimension.PROPOSAL_NAME. Can be used for filtering.

PROPOSAL_CURRENCY

Represents Proposal.currency for Dimension.PROPOSAL_NAME.

PROPOSAL_EXCHANGE_RATE

Represents Proposal.exchangeRate for Dimension.PROPOSAL_NAME.

PROPOSAL_AGENCY_COMMISSION_RATE

Represents Proposal.agencyCommission for Dimension.PROPOSAL_NAME.

PROPOSAL_VAT_RATE

Represents Proposal.valueAddedTax for Dimension.PROPOSAL_NAME.

PROPOSAL_DISCOUNT

Represents Proposal.proposalDiscount for Dimension.PROPOSAL_NAME.

PROPOSAL_ADVERTISER_DISCOUNT

Represents Proposal.advertiserDiscount for Dimension.PROPOSAL_NAME.

PROPOSAL_ADVERTISER

Represents the advertiser name of Dimension.PROPOSAL_NAME.

PROPOSAL_ADVERTISER_ID

Represents the advertiser id of Dimension.PROPOSAL_NAME.

PROPOSAL_AGENCIES

Represents the agency names as a comma separated string for Dimension.PROPOSAL_NAME.

PROPOSAL_AGENCY_IDS

Represents the agency ids as a comma separated string for Dimension.PROPOSAL_NAME.

PROPOSAL_PO_NUMBER

Represents Proposal.poNumber for Dimension.PROPOSAL_NAME.

PROPOSAL_PRIMARY_SALESPERSON

Represents name and email address in the form of name(email) of primary salesperson for Dimension.PROPOSAL_NAME.

PROPOSAL_SECONDARY_SALESPEOPLE

Represents name and email addresses in the form of name(email) of secondary salespeople as a comma separated string for Dimension.PROPOSAL_NAME.

PROPOSAL_CREATOR

Represents name and email address in the form of name(email) of creator for Dimension.PROPOSAL_NAME.

PROPOSAL_SALES_PLANNERS

Represents name and email addresses in the form of name(email) of Proposal.salesPlannerIds as a comma separated list string for Dimension.PROPOSAL_NAME.

PROPOSAL_PRICING_MODEL

Represents Proposal.pricingModel for Dimension.PROPOSAL_NAME.

PROPOSAL_BILLING_SOURCE

Represents Proposal.billingSource for Dimension.PROPOSAL_NAME.

PROPOSAL_BILLING_CAP

Represents Proposal.billingCap for Dimension.PROPOSAL_NAME.

PROPOSAL_BILLING_SCHEDULE

Represents Proposal.billingSchedule for Dimension.PROPOSAL_NAME.

PROPOSAL_APPLIED_TEAM_NAMES

Represents Proposal.appliedTeamIds as a comma separated list of Team.names for Dimension.PROPOSAL_NAME.

PROPOSAL_APPROVAL_STAGE

Represents the approval stage for Dimension.PROPOSAL_NAME.

PROPOSAL_INVENTORY_RELEASE_DATE_TIME

Represents the inventory release date time for Dimension.PROPOSAL_NAME.

PROPOSAL_LOCAL_BUDGET

Represents Proposal.budget in local currency for Dimension.PROPOSAL_NAME.

PROPOSAL_LOCAL_REMAINING_BUDGET

Represents the remaining budget in local currency for Dimension.PROPOSAL_NAME.

PROPOSAL_LINE_ITEM_START_DATE_TIME

Represents ProposalLineItem.startDateTime for Dimension.PROPOSAL_LINE_ITEM_NAME.

PROPOSAL_LINE_ITEM_END_DATE_TIME

Represents ProposalLineItem.endDateTime for Dimension.PROPOSAL_LINE_ITEM_NAME.

PROPOSAL_LINE_ITEM_RATE_TYPE

Represents ProposalLineItem.rateType for Dimension.PROPOSAL_LINE_ITEM_NAME. Can be used for filtering.

PROPOSAL_LINE_ITEM_COST_PER_UNIT

Represents ProposalLineItem.costPerUnit for Dimension.PROPOSAL_LINE_ITEM_NAME.

PROPOSAL_LINE_ITEM_LOCAL_COST_PER_UNIT

Represents ProposalLineItem.costPerUnit in local currency for Dimension.PROPOSAL_LINE_ITEM_NAME. See PROPOSAL_LINE_ITEM_COST_PER_UNIT

PROPOSAL_LINE_ITEM_COST_PER_UNIT_GROSS

Represents gross cost per unit for Dimension.PROPOSAL_LINE_ITEM_NAME.

PROPOSAL_LINE_ITEM_LOCAL_COST_PER_UNIT_GROSS

Represents gross cost per unit in local currency for Dimension.PROPOSAL_LINE_ITEM_NAME. See PROPOSAL_LINE_ITEM_COST_PER_UNIT_GROSS

PROPOSAL_LINE_ITEM_TYPE_AND_PRIORITY

Represents line item type (if applicable) and line item priority (if applicable) for Dimension.PROPOSAL_LINE_ITEM_NAME.

PROPOSAL_LINE_ITEM_SIZE

Represents the size of ProposalLineItem.creativePlaceholders for Dimension.PROPOSAL_LINE_ITEM_NAME.

PROPOSAL_LINE_ITEM_ARCHIVAL_STATUS

Represents ProposalLineItem.isArchived for Dimension.PROPOSAL_LINE_ITEM_NAME. Can be used for filtering.

PROPOSAL_LINE_ITEM_PRODUCT_ADJUSTMENT

Represents the product adjustment of Dimension.PROPOSAL_LINE_ITEM_NAME.

PROPOSAL_LINE_ITEM_BUFFER

Represents ProposalLineItem.unitsBoughtBuffer for Dimension.PROPOSAL_LINE_ITEM_NAME.

PROPOSAL_LINE_ITEM_TARGET_RATE_NET

Represents the target rate (net) of Dimension.PROPOSAL_LINE_ITEM_NAME.

PROPOSAL_LINE_ITEM_BILLING_SOURCE

Represents ProposalLineItem.billingSource for Dimension.PROPOSAL_LINE_ITEM_NAME.

PROPOSAL_LINE_ITEM_BILLING_CAP

Represents ProposalLineItem.billingCap for Dimension.PROPOSAL_LINE_ITEM_NAME.

PROPOSAL_LINE_ITEM_BILLING_SCHEDULE

Represents ProposalLineItem.billingSchedule for Dimension.PROPOSAL_LINE_ITEM_NAME.

PROPOSAL_LINE_ITEM_GOAL_PERCENTAGE

Represents ProposalLineItem.unitsBought for Dimension.PROPOSAL_LINE_ITEM_NAME The attribute is available only if ProposalLineItem.lineItemType is of type LineItemType.SPONSORSHIP, LineItemType.HOUSE, LineItemType.NETWORK, or LineItemType.BUMPER.

PROPOSAL_LINE_ITEM_COST_ADJUSTMENT

Represents ProposalLineItem.costAdjustment for Dimension.PROPOSAL_LINE_ITEM_NAME.

PROPOSAL_LINE_ITEM_COMMENTS

Represents the comments for Dimension.PROPOSAL_LINE_ITEM_NAME.

PRODUCT_TEMPLATE_RATE_TYPE

Represents ProductTemplate.rateType for Dimension.PRODUCT_TEMPLATE_NAME.

PRODUCT_TEMPLATE_STATUS

Represents ProductTemplate.status for Dimension.PRODUCT_TEMPLATE_NAME.

PRODUCT_TEMPLATE_TYPE_AND_PRIORITY

Represents the line item type (if applicable) and line item priority (if applicable) of Dimension.PRODUCT_TEMPLATE_NAME.

PRODUCT_TEMPLATE_PRODUCT_TYPE

Represents ProductTemplate.productType for Dimension.PRODUCT_TEMPLATE_NAME.

PRODUCT_TEMPLATE_DESCRIPTION

Represents ProductTemplate.description for Dimension.PRODUCT_TEMPLATE_NAME.

PRODUCT_PRODUCT_TEMPLATE_NAME

Represents the product template's name of Dimension.PRODUCT_NAME.

PRODUCT_RATE_TYPE

Represents Product.rateType for Dimension.PRODUCT_NAME.

PRODUCT_STATUS

Represents Product.status for Dimension.PRODUCT_NAME.

PRODUCT_TYPE_AND_PRIORITY

Represents the line item type (if applicable) and line item priority (if applicable) of Dimension.PRODUCT_NAME.

PRODUCT_PRODUCT_TYPE

Represents the product type of Dimension.PRODUCT_NAME.

PRODUCT_NOTES

Represents Product.notes for .

PROPOSAL_AGENCY_TYPE

Represents the Company.type of Dimension.PROPOSAL_AGENCY_NAME.

PROPOSAL_AGENCY_CREDIT_STATUS

Represents the Company.creditStatus of Dimension.PROPOSAL_AGENCY_NAME.

PROPOSAL_AGENCY_EXTERNAL_ID

Represents Company.externalId for Dimension.PROPOSAL_AGENCY_NAME.

PROPOSAL_AGENCY_COMMENT

Represents Company.comment for Dimension.PROPOSAL_AGENCY_NAME.

SALESPEOPLE_PROPOSAL_CONTRIBUTION

Represents the Dimension.ALL_SALESPEOPLE_NAME's contribution to a Dimension.PROPOSAL_NAME. This is different from SALESPERSON_PROPOSAL_CONTRIBUTION as this will include both primary and secondary salespeople.

SALESPERSON_PROPOSAL_CONTRIBUTION

Represents the Dimension.SALESPERSON_NAME's contribution to a Dimension.PROPOSAL_NAME. See SALESPERSON_PROPOSAL_CONTRIBUTION.

CONTENT_CMS_NAME

Represents the CmsContent.displayName within the first element of Content.cmsContent for Dimension.CONTENT_NAME.

CONTENT_CMS_VIDEO_ID

Represents the CmsContent.cmsContentId within the first element of Content.cmsContent for Dimension.CONTENT_NAME.

AD_UNIT_CODE

Represents AdUnit.adUnitCode for Dimension.AD_UNIT_NAME.

To add IDs, you must include Dimension.CONTENT_HIERARCHY in dimensions, and specify a non-empty list of custom targeting key IDs. The order of content hierarchy columns in the report correspond to the place of Dimension.CONTENT_HIERARCHY in dimensions. For example, if dimensions contains the following dimensions in the order: Dimension.ADVERTISER_NAME, Dimension.CONTENT_HIERARCHY and Dimension.COUNTRY_NAME, and contentMetadataKeyHierarchyCustomTargetingKeyIds contains the following IDs in the order: 1001 and 1002. The order of dimensions in the report will be: Dimension.ADVERTISER_NAME, Dimension.CONTENT_HIERARCHY_CUSTOM_TARGETING_KEY[1001]_VALUE, Dimension.CONTENT_HIERARCHY_CUSTOM_TARGETING_KEY[1002]_VALUE, Dimension.COUNTRY_NAME, Dimension.ADVERTISER_ID, Dimension.CONTENT_HIERARCHY_CUSTOM_TARGETING_KEY[1001]_ID, Dimension.CONTENT_HIERARCHY_CUSTOM_TARGETING_KEY[1002]_ID, Dimension.COUNTRY_CRITERIA_ID

TODAY

The current day.

YESTERDAY

The previous day.

LAST_WEEK

The last week, from monday to sunday.

LAST_MONTH

The previous month.

REACH_LIFETIME

The last 5 months and the current month to date. This date range is only usable for the columns Column.REACH_FREQUENCY, Column.REACH_AVERAGE_REVENUE and Column.REACH.

CUSTOM_DATE

Specifying this value will enable the user to specify ReportQuery.startDate and ReportQuery.endDate.

NEXT_DAY

The next day.

NEXT_90_DAYS

The next ninety days.

NEXT_WEEK

The next week, from monday to sunday.

NEXT_MONTH

The next month.

CURRENT_AND_NEXT_MONTH

Beginning of the next day until the end of the next month.

NEXT_QUARTER

The next quarter.

NEXT_3_MONTHS

The next three months.

NEXT_12_MONTHS

The next twelve months.

ADVERTISERS

Filters the results to include only advertisers. That is, Company.type is either Company.Type.HOUSE_ADVERTISER or Company.Type.ADVERTISER.

ACTIVE_ADVERTISERS

Filters the results to include only active advertisers. That is, Company.type is either Company.Type.HOUSE_ADVERTISER or Company.Type.ADVERTISER and the Company is active. This filter is applied by default when Dimension.ADVERTISER is chosen.

HOUSE_ADVERTISERS

Filters the results to include only the publisher's own advertiser. That is, Company.Type is Company.Type.HOUSE_ADVERTISER.

NON_HOUSE_ADVERTISERS

Filters the results to include only advertisers that do not belong to the publisher. That is Company.Type is Company.Type.ADVERTISER or Company.Type.AD_NETWORK.

ALL_SALESPEOPLE

Filters the results to include only salespeople. This filter is applied by default when Dimension.SALESPERSON is chosen.

WHOLE_NETWORK

Results for the entire network are returned. This is the default filter if none are specified.

CURRENT_USER_ORDERS

Filters the results to include only Order objects that are visible to the User.

STARTED_ORDERS

Filters the results to include only Order objects that have their Order.startDateTime in the past and their Order.endDateTime in the future.

COMPLETED_ORDERS

Filters the results to include only Order objects that have their Order.endDateTime in the past.

MOBILE_LINE_ITEMS

Filters the results to include only LineItem objects delivered on the platform TargetPlatform.MOBILE.

WEB_LINE_ITEMS

Filters the results to include only LineItem objects delivered on the platform TargetPlatform.WEB.

ACTIVE_AD_UNITS

Filters the results to include only AdUnit objects whose status is InventoryStatus.ACTIVE.

INACTIVE_AD_UNITS

Filters the results to include only AdUnit objects whose status is InventoryStatus.INACTIVE.

MOBILE_INVENTORY_UNITS

Filters the results to include only AdUnit objects delivered on the platform TargetPlatform.MOBILE.

WEB_INVENTORY_UNITS

Filters the results to include only AdUnit objects delivered on the platform TargetPlatform.WEB.

ARCHIVED_AD_UNITS

Filters the results to include only AdUnit objects whose status is InventoryStatus.ARCHIVED.

ACTIVE_PLACEMENTS

Filters the results to include only Placement objects whose status is InventoryStatus.ACTIVE.

INACTIVE_PLACEMENTS

Filters the results to include only Placement objects whose status is InventoryStatus.INACTIVE.

ARCHIVED_PLACEMENTS

Filters the results to include only Placement objects whose status is InventoryStatus.ARCHIVED.

OPTIMIZABLE_ORDERS

Filters the results to include only Order objects for which the optimization feature has been turned on.

PARTNER_STATS_TYPE_ESTIMATED

Filters the results to include only estimated partner stats.

PARTNER_STATS_TYPE_RECONCILED

Filters the results to include only reconciled partner stats.

<condition>
     := <property> = <value>
<condition>
     := <property> = <bind variable>
<condition> := <property> IN <list>
<bind variable> := :<name>
where property is the enumeration name of a Dimension that can be filtered.

For example, the statement "WHERE LINE_ITEM_ID IN (34344, 23235)" can be used to generate a report for a specific set of line items

Filtering on IDs is highly recommended over filtering on names, especially for geographical entities. When filtering on names, matching is case sensitive.