Xandr

The table below gives information about all the data fields that you can import from Xandr.

To see the fields you can collect from another data source, go back to the Available fields in Adverity overview.

Field UI name

Field API name

Data Type

Description

Use in Adverity

Docs

25_pcts

int

The total number of times the video creatives completed 25% of the entire duration.

metric

50_pcts

int

The total number of times the video completed 50% of the entire duration of time.

metric

75_pcts

int

The total number of times the video completed 75% of the entire duration of time.

metric

Bidder

string

The bidding platform (Adform, DM, Xandr Console)

dimension

Call Type

string

The bid-call-type (prebid, ptv, ttj)

dimension

Companion Ad Clicks

int

Companion Ad Clicks

metric

Companion Ad Impressions

int

Companion Ad Impressions

metric

Creative Duration

int

The duration of the creative

metric

account_manager_for_advertiser

string

The account manager for the advertiser. See the "labels" field in the Advertiser Service for more details.

dimension

account_manager_for_publisher

string

The account manager for the publisher. See the "labels" field in the Publisher Service for more details.

dimension

ad_profile_id

string

The Ad Profile ID of the Seller Member affected by the error.

dimension

ad_requests

int

The number of ad requests associated with the placement.

metric

ad_responses

int

The number of responses delivered to the user's browser (or mediating server). A response can result in an impression, an error in player, or an auction with no impression event. An imp refers to when the video player loads the video and starts the first frame. Videos Served refers to the VAST document being served in response to a request from the video player.

metric

ad_serving_fees

float

The ad serving fees

metric

ad_serving_fees_buying_currency

float

The ad serving fees buying currency

metric

ad_serving_fees_selling_currency

float

The ad serving fees selling currency

metric

adjustment_day

date

The day of the adjustment.

dimension

adjustment_hour

date

The hour of the adjustment.

dimension

adjustment_id

string

The ID of the adjustment used to make changes to booked revenue and media cost values.

dimension

advertiser_code

string

The custom code for the advertiser.

dimension

advertiser_currency

string

The currency of the advertiser.

dimension

advertiser_id

string

The ID of the advertiser. If the value is 0, either the impression was purchased by an external buyer, or a default or PSA was shown.

dimension

advertiser_name

string

The name of the advertiser.

dimension

advertiser_ppm

currency

Advertiser profit per Mille (1000 imps)

metric

advertiser_profit

currency

Advertiser profit

metric

advertiser_revenue

currency

The revenue recorded for the advertiser. For more information, see Conversion Pixels: Advanced

metric

advertiser_roi

currency

Advertiser return on investment

metric

advertiser_rpm

currency

Advertiser revenue per Mille (1000 imps)

metric

advertiser_type

string

The type of advertiser. See the "labels" field in the Advertiser Service for more details.

dimension

age_bucket

string

The age bucket in which the user is contained. See Age Bucket below for more information.

dimension

age_bucket_id

string

The ID of the age bucket. See Age Bucket below for more information.

dimension

ask_price

float

The ask price for the deal.

metric

attributed_pc_revenue

currency

The amount of revenue from all recorded post views.

metric

attributed_pv_revenue

currency

The amount of revenue from all recorded post clicks.

metric

attributed_revenue

currency

The amount of revenue from all recorded post views and post clicks.

metric

auction_id

string

The ID of the impression event. Clients who subscribe to log-level data feedscan use this ID to request additional information about the impression, such as geography and browser.

dimension

auction_service_deduction

currency

The total deductions charged for impressions bought from third parties . These deductions are included in the buyer's media cost and deducted when calculating the seller's payment. For more information, see the Buyer Auction Service Chargedocumentation (Customer login required).

metric

auction_service_deduction_adv_curr

currency

The total deductions charged for impressions bought from third parties, in the currency of the advertiser. These deductions are included in the buyer's media cost and deducted when calculating the seller's payment. For more information, see the Buyer Auction Service Chargedocumentation (Customer login required). Note: If you are not tracking revenue through Xandr, this will be 0 .

metric

auction_service_deduction_buying_currency

currency

The total deductions charged for impressions bought from third parties, in the transaction currency the buyer used to buy the impression. These deductions are included in the buyer's media cost and deducted when calculating the seller's payment. For more information, see the Buyer Auction Service Charge documentation(customer login required).

metric

auction_service_fees

currency

Total fees charged for impressions bought from third parties. These fees are charged in addition to the buyer's media cost. For more information, see the Buyer Auction Service Chargedocumentation (Customer login required).

metric

auction_service_fees_adv_curr

currency

Total fees charged for impressions bought from third parties, in the currency of the advertiser. These fees are charged in addition to the buyer's media cost. For more information, see the Buyer Auction Service Chargedocumentation (Customer login required). Note: If you are not tracking revenue through Xandr, this will be 0 .

metric

auction_service_fees_buying_currency

currency

Total fees charged for impressions bought from third parties, in the transaction currency the buyer used to buy the impression. These fees are charged in addition to the buyer's media cost. For more information, see the Buyer Auction Service Charge documentation(customer login required).

metric

audit_completion_date

date

The day on which the audits were completed.

dimension

audit_reason

string

The type of audit. This will be either "Initial" or "Reaudit".

dimension

audit_reason_id

string

The integer code for the type of audit. There are two allowed values: 1: Initial audit 2: Reaudit

dimension

audit_type_id

string

The ID of the type of audit performed on the domain where the impression occurred.

dimension

audit_type_name

string

The name of the type of audit performed on the domain where the impression occurred. Allowed values: "By Seller": The domain was self-audited. "By Xandr": The domain was audited by Xandr. "By Seller & Xandr": The domain was audited by both the seller and Xandr. "Unknown Audit Type": This usually means that the domain is unaudited. In some cases, this means that the domain was not auditable for technical reasons.

dimension

average_biased_bid

currency

The average biased bid for the deal. This is the bid price used for ranking purposes in the auction.

metric

average_floor_price

currency

The average floor price for the deal.

metric

average_net_bid

currency

The average net bid on the deal. This is the bid price that is net of all fees and used in determining seller revenue (prior to any bid price reduction that may take place).

metric

avg_bid_reduction

float

The average bid reduction you gained on the line item or campaign. This value represents the difference (as a percentage) between your bid and the actual media cost you paid for the impression you won (e.g., due to bid reduction). This value is only valid for RTB bidding (i.e., not Managed). Currently, this value is not accurately calculated for line items for which the payment_auction_event_type field has been set to 2 .

metric

avg_daily_uniques

int

The average number of users added to a segment per day for a specific month. To view this metric, you must include the month dimension.

metric

bid_rate

int

The rate of bidding on the deal.

metric

bid_requests

int

The number of bid requests.

metric

bid_sent_no_responses

int

Bid responses returned by Xandr where ultimately the creative does not render. The most common scenario in which this occurs is when Xandr receives an ad request from an external system - such as a publisher ad server utilizing prebid or a traditional waterfall - and returns a response, but the external system selects a different bid. Other examples of reasons this can occur include: The end user leaves the page before the impression tracker fires. An ad is requested but never loads due to lazy loading. A video player requests an ad but never plays the ad.

metric

bid_type

string

The optimization phase the node was in when it bid for this impression. Note that the term "give up" is appended to the bid types below if the valuation for that impression falls below the venue's "give up price". For more information, see Venues and Give Up (Customer login required). Allowed values: "Manual": Applies when you are bidding with a CPM goal, whether it's Base, EAP, or ECP. "Learn": Applies when you are bidding with optimization (CPA, CPC, or margin) and we do not yet have enough data to bid optimized. "Optimized": Applies when you are bidding with optimization (CPA, CPC, or margin) and we have enough data to bid optimized. "Unknown": The node was in an unknown optimization phase. "Optimized give up" "Learn give up" "Manual give up"

dimension

bid_type_id

string

The bid type id

dimension

bidder

string

The bidding platform (Adform, DM, Xandr Console)

dimension

bidder_id

string

The ID of the bidder or DSP (demand side platform) that the buyer used to purchase this impression.

dimension

bidder_name

string

The name of the bidder or DSP (demand side platform) that the buyer used to purchase this impression.

dimension

bidder_name

string

The name of the bidder or DSP (demand side platform) that the buyer used to purchase this impression.

dimension

bidder_name_from_member_id

string

The bidder name from member id

dimension

bids

int

The number of completed bids.

metric

billing_period.booked_imps_budget_daily

int

The daily impression budget of the insertion order's billing period.

metric

billing_period.booked_imps_budget_lifetime

int

The lifetime impression budget of the insertion order's billing period.

metric

billing_period.booked_revenue_budget_daily_buying_currency

int

the billing period booked revenue budget daily buying currency

metric

billing_period.booked_revenue_budget_lifetime_buying_currency

int

the billing period booked revenue budget lifetime buying currency

metric

billing_period.end_date

date

The last date of the insertion order's billing period. Alpha-Beta Notice This field or feature is part of functionality currently in either Alpha or Beta phase. It is therefore subject to change.

dimension

billing_period.external_code

string

The custom code for the billing period (budget_interval).

dimension

billing_period.start_date

date

The earliest date of the insertion order's billing period. Alpha-Beta Notice This field or feature is part of functionality currently in either Alpha or Beta phase. It is therefore subject to change.

dimension

billing_period_end_date

date

The last date of the insertion order's billing period. Alpha-Beta Notice This field or feature is part of functionality currently in either Alpha or Beta phase. It is therefore subject to change.

dimension

billing_period_external_code

string

The custom code for the billing period (budget_interval).

dimension

billing_period_id

string

The billing period id

dimension

billing_period_start_date

date

The earliest date of the insertion order's billing period. Alpha-Beta Notice This field or feature is part of functionality currently in either Alpha or Beta phase. It is therefore subject to change.

dimension

billing_transaction_type_id

string

The billing transaction type id

dimension

booked_revenue

currency

The total revenue booked through direct advertisers (line item).

metric

booked_revenue_adv_curr

currency

The total revenue booked through a direct advertiser, in the currency of the advertiser.

metric

booked_revenue_advertiser_currency

currency

The booked revenue advertiser currency

metric

booked_revenue_buying_currency

currency

The total revenue booked through direct advertisers (line item) in the currency the buyer used to purchase the inventory. Note: exchange rates are not yet available in reporting.

metric

booked_revenue_dollars

currency

The dollar amount earned by this network on the impression.

metric

booked_revenue_dollars_buying_currency

currency

Network revenue booked through direct advertisers, in the transaction currency the buyer used to buy the impression.

metric

booked_revenue_ecpa

float

The booked revenue ecpa

metric

booked_revenue_ecpa_buying_currency

currency

The booked revenue ecpa buying currency

metric

booked_revenue_ecpc

float

The booked revenue ecpc

metric

booked_revenue_ecpc_buying_currency

currency

The booked revenue ecpc buying currency

metric

booked_revenue_ecpm

float

The booked revenue ecpm

metric

booked_revenue_ecpm_buying_currency

currency

The booked revenue ecpm buying currency

metric

booked_revenue_publisher_currency

currency

The booked revenue publisher currency

metric

booked_revenue_selling_currency

currency

The total revenue booked through direct advertisers (line item) in the currency the seller used to sell the impression. Note: exchange rates are not yet available in reporting.

metric

booked_revenue_vcpm

float

The booked revenue vcpm

metric

booked_revenue_vcpm_adv_currency

float

Thebooked revenue vcpm adv curr

metric

brand_category_id

string

The brand category id

dimension

brand_category_name

string

The brand category name

dimension

brand_id

string

The ID of the brand associated with a creative. For imp_type_id = 6, no information is available in the brand_id field for this report. See the Seller Brand Review Report instead.

dimension

brand_name

string

The name of the brand associated with a creative. For imp_type_id = 6, no information is available in the brand_name field for this report. See the Seller Brand Review Report instead.

dimension

brand_offer_category_id

string

The ID of the brand offer category associated with the impression. See category_id in the Brand Servicepage.

dimension

brand_offer_category_name

string

The name of the brand offer category associated with the impression. See category_id in the Brand Servicepage.

dimension

browser_id

string

The ID of the browser in which the impression was served. To retrieve a complete list of browser IDs and names, use the Browser Service.

dimension

browser_name

string

The ID of the browser in which the impression was served.

dimension

buyer_ad_serving_fees

float

The buyer ad serving fees

metric

buyer_cost_ecpm

int

The cost of the deal to the buyer in eCPM.

metric

buyer_currency

string

The currency of the buyer.

dimension

buyer_ecpm

float

The buyer ecpm

metric

buyer_ecpm_buyer_curr

float

The buyer ecpm buyer curr

metric

buyer_media_cost

currency

The total cost of the inventory purchased.

metric

buyer_media_cost_buying_currency

currency

The total cost of the inventory purchased, in the transaction currency the buyer used to buy the impression.

metric

buyer_media_cost_ecpa

float

The buyer_media_cost_ecpa

metric

buyer_media_cost_ecpc

float

buyer_media_cost_ecpc

metric

buyer_media_cost_ecpm

float

buyer_media_cost_ecpm

metric

buyer_member_id

string

The ID of the buying member. If the impression was not purchased, this field shows one of the following values: 229 = PSA, 0 = Blank, or 319 = Default.

dimension

buyer_member_name

string

The name of the buying member. Note: The name might be "Default" or "Default Error", which means that there was no buyer for the impression, and a default creative was served.

dimension

buyer_payment_event_type

string

buyer_payment_event_type

dimension

buyer_payment_event_type_id

string

buyer_payment_event_type_id

dimension

buyer_payment_event_type_name

string

buyer_payment_event_type_name

dimension

buyer_payment_event_units

string

buyer_payment_event_units

dimension

buyer_spend

currency

The amount the buyer pays for the cost of media.

metric

buyer_spend_appnexus_cleared

currency

The buyer spend Xandr cleared

metric

buyer_spend_appnexus_cleared_buyer_curr

currency

The buyer spend Xandr cleared buyer curr

metric

buyer_spend_buyer_curr

currency

buyer_spend, expressed in the buyer's currency.

metric

buyer_spend_direct_cleared

currency

The buyer spend direct cleared

metric

buyer_spend_direct_cleared_buyer_curr

currency

buyer_spend_direct_cleared_buyer_curr

metric

buyer_spend_direct_cleared_seller_curr

currency

buyer_spend_direct_cleared_seller_curr

metric

buyer_type

string

The type of impression purchased by the buyer member. Possible values: "Real Time" or "Direct".

dimension

buying_currency

string

The transaction currency used by the buyer to purchase this impression.

dimension

buying_imp_type

string

The buying imp type

dimension

buying_imp_type_id

string

The buying imp type id

dimension

call type

string

The call type

dimension

call_type

string

The type of handler that was used to send the impression to Xandr (e.g., ttj, ut, mob, ptv, openrtb)

dimension

campaign_code

string

The custom code for the campaign.

dimension

campaign_group_id

string

The unique identification number of the campaign group.

dimension

campaign_group_name

string

The name of the campaign group.

dimension

campaign_id

string

The ID of the campaign.

dimension

campaign_name

string

The name of the campaign.

dimension

campaign_priority

int

The bidding priority for a campaign that targets direct inventory. (Customer login required) Possible values: 1 - 10, where 10 is the highest priority.

metric

campaign_type

string

The type of campaigns under the line item. See the labels field in the Line Item Service for more information.

dimension

carrier_id

string

The ID of the carrier for the device on which the impression was served. To retrieve a complete list of carrier IDs and names, use the Carrier Service.

dimension

carrier_name

string

The name of the carrier for the device on which the impression was served.

dimension

clear_fees

currency

The fee specified in the buyer member's contract charged on impressions bought from an external or partner seller.

metric

cleared_direct

int

Whether or not the buyer pays the seller directly for the cost of media. If 0, Xandr collects the cost of media from the buyer and pays the seller. If 1, the buyer pays the seller directly for the cost of media. Tip: Buyers can match the cost of media on their invoice by filtering out "cleared direct" transactions.

metric

clearing_event_booked_revenue_ecpm

float

The clearing event booked revenue ecpm

metric

clearing_event_booked_revenue_ecpm_buying_currency

float

The clearing event booked revenue ecpm buying currency

metric

clearing_event_booked_revenue_per_event

float

The clearing event booked revenue per event

metric

clearing_event_booked_revenue_per_event_buying_currency

float

The clearing event booked revenue per event buying currency

metric

clearing_event_buyer_media_cost_ecpm

float

The clearing event buyer media cost ecpm

metric

clearing_event_buyer_media_cost_ecpm_buying_currency

float

The clearing event buyer media cost ecpm buying currency

metric

clearing_event_buyer_media_cost_per_event

float

The clearing event buyer media coss per event

metric

clearing_event_buyer_media_cost_per_event_buying_currency

float

The clearing event buyer media cost per event buying currency

metric

click_conv_rate

float

The rate of conversions to clicks. Note: This field is identical to click_convs_rate.

metric

click_convs_rate

float

The rate of conversions to clicks.

metric

click_thru_pct

float

The rate of clicks to impressions as a percentage.

metric

clicks

int

The total number of clicks across all impressions.

metric

commission_cpm

currency

The cpm that the member pays a broker. This is set at the line item.

metric

commission_revshare

currency

The revshare that the member pays a broker. This is set at the line item.

metric

commissions

currency

Fees that come out of the booked revenue.

metric

commissions_buying_currency

currency

Fees that come out of the booked revenue in the currency the buyer used to purchase the inventory. Note: exchange rates are not yet available in reporting.

metric

commissions_selling_currency

currency

Fees that come out of the booked revenue in the currency the seller used to sell the impression. Note: exchange rates are not yet available in reporting.

metric

completion_rate

float

The number of video completions divided by the number of impressions.

metric

completions

int

The total number of times the video played for the entire duration of time.

metric

connection_type

string

The type of internet connection at the time of the impression. Possible values: "Carrier-based" or "Wifi or Static".

dimension

content_category_id

string

The ID of the universal content category associated with this site or placement.

dimension

content_category_name

string

The name of the universal content category associated with this site or placement.

dimension

conv_rate

float

The rate of post click and post view conversions to impressions.

metric

conversion_rate

float

The conversion rate

metric

conversions_per_million

int

Conversions per million

metric

convs

int

Total number of conversions across all impressions

metric

convs_per_mm

float

The number of conversions per million impressions.

metric

convs_rate

float

The rate of conversions to impressions.

metric

cost

currency

The total amount of media cost for direct publisher and purchased real-time inventory.

metric

cost_buying_currency

currency

The total amount of media cost for direct publisher and purchased real-time inventory in the currency the buyer used to purchase the inventory. Note:exchange rates are not yet available in reporting.

metric

cost_ecpa

currency

The cost per acquisition/conversion.

metric

cost_ecpa_advertiser_currency

currency

The cost ecpa advertiser currency

metric

cost_ecpa_buying_currency

currency

The cost ecpa buying currency

metric

cost_ecpa_including_fees

currency

Cost per conversion including serving fees.

metric

cost_ecpa_including_fees_buying_currency

currency

The cost ecpa including fees buying currency

metric

cost_ecpc

currency

The cost per click.

metric

cost_ecpc_advertiser_currency

currency

The cost ecpc advertiser currency

metric

cost_ecpc_buying_currency

currency

The cost ecpc buying currency

metric

cost_ecpc_including_fees

currency

Cost per click including serving fees.

metric

cost_ecpc_including_fees_buying_currency

currency

The cost ecpc including fees buying currency

metric

cost_ecpm

currency

The cost per 1000 impressions.

metric

cost_ecpm_advertiser_currency

currency

The cost ecpm advertiser currency

metric

cost_ecpm_buying_currency

currency

The cost ecpm buying currency

metric

cost_ecpm_including_fees

currency

Gross serving fees per thousand impressions.

metric

cost_ecpm_including_fees_buying_currency

currency

The cost ecpm including fees buying currency

metric

cost_ecpvm

currency

The cost per 1000 viewable impressions.

metric

cost_including_fees

currency

The total amount of media cost for direct publisher and purchased real-time inventory plus additional fees.

metric

cost_per_video_complete

float

The cost per video completion.

metric

cost_selling_currency

currency

The total amount of media cost for direct publisher and purchased real-time inventory in the currency the seller used to sell the impression. Note: exchange rates are not yet available in reporting.

metric

cpa

currency

The cost per acquisition.

metric

cpc

currency

The cost per click.

metric

cpm

currency

The cost per 1000 impressions.

metric

cpm_buying_currency

currency

The cost per 1000 impressions in the currency the buyer used to purchase the inventory. Note: exchange rates are not yet available in reporting.

metric

cpm_including_fees

currency

The cost including ad serving fees per 1000 impressions.

metric

cpm_selling_currency

currency

The cost per 1000 impressions in the currency the seller used to sell the impression. Note: exchange rates are not yet available in reporting.

metric

cpm_usd

currency

Cpm in USD

metric

cpvm

currency

The cost per 1000 viewable impressions.

metric

creative_audit_status

string

The audit status of the creative associated with the impression: "Unaudited" "Self Audit Only" "Xandr Audited"

dimension

creative_audit_status_id

string

The ID of the audit status of the creative associated with the impression: 0 = unaudited 1 = seller audited only 2 = Xandr audited

dimension

creative_category_id

string

The ID of the creative category.

dimension

creative_category_name

string

A classification assigned to both brands and creatives affected by the error.

dimension

creative_code

string

The code for the creative. Note:For impressions older than 100 days, creatives will be aggregated into one row with "All creative data older than 100 days" as the creative_name. For external click or impression trackers, creative_code will be "External Clicks" or "External Imps".

dimension

creative_hosting_fees

float

The creative hosting fees

metric

creative_hosting_fees_buying_currency

float

The creative hosting fees buying currency

metric

creative_id

string

The ID of the creative. Note: For impressions older than 100 days, creatives will be aggregated into one row with 0 as the creative_id. For external click or impression trackers, creative_id will be "External Clicks" or "External Imps".

dimension

creative_name

string

The name of the creative. Note: For impressions older than 100 days, creatives will be aggregated into one row with "All creative data older than 100 days" as the creative_name. For external click or impression trackers, creative_name will be "External Clicks" or "External Imps".

dimension

creative_overage_fees

currency

Total fees charged for hosted creatives that exceed the creative size limit.

metric

creative_overage_fees_adv_curr

currency

Total fees charged for hosted creatives that exceed the creative size limit, in the currency of the advertiser. Note: If you are not tracking revenue through Xandr, this will be 0 .

metric

creative_overage_fees_buying_currency

currency

Total fees charged for hosted creatives that exceed the creative size limit, in the transaction currency the buyer used to buy the impression.

metric

creative_size

string

The size of the creative affected by the error.

dimension

ctr

float

The rate of clicks to impressions.

metric

curator_member_id

string

The curator member id

dimension

daily_uniques

int

The number of unique user IDs added to the segment on a specific day. To view this metric, you must include the day dimension.

metric

data_clearing_fee_usd

float

The data clearing fee usd

metric

data_costs

currency

The total cost of 3rd party data used on the campaign.

metric

data_costs_buying_currency

currency

The total cost of 3rd party data used on the campaign in the currency the buyer used to purchase the inventory. Note: exchange rates are not yet available in reporting.

metric

data_costs_buying_currency_duplicate_DEPRECATED

currency

The total cost of 3rd party data used on the campaign in the currency the buyer used to purchase the inventory. Note: exchange rates are not yet available in reporting.

metric

data_costs_selling_currency

currency

The total cost of 3rd party data used on the campaign the seller used to sell the impression. Note: exchange rates are not yet available in reporting.

metric

data_provider_id

string

The ID of the third-party that provided the targeting data.

dimension

data_provider_name

string

The name and ID of the third-party that provided the targeting data.

dimension

data_provider_payout_usd

float

The data provider payout usd

metric

data_type

string

The data type

dimension

datetime

date

The date and time when the conversion pixel fired.

dimension

day

date

The day of the auction.

dimension

deal_auction_type_name

string

The deal auction type name

dimension

deal_code

string

The custom code for the deal. For deals with external supply partners, this is generally the string that you use to identify the deal.

dimension

deal_id

string

The ID of the deal. For more information about negotiated deals between buyers and sellers, see Deal Service and Deal Buyer Access Service.

dimension

deal_name

string

The name of the deal.

dimension

deal_type

string

The deal type

dimension

deal_type_id

string

The deal type id

dimension

deal_type_name

string

Whether the deal is a public deal or a private deal.

dimension

default_no_responses

int

Ad requests where a default creative was sent but no response was received from the end ad server. This could be the result of an error or an alternate default tag was chosen by the final ad server.

metric

defaults

int

Ad requests where a default creative served because there were no valid bids.

metric

delivery_rate

float

The delivery rate

metric

device_make_id

string

The ID of the device make on which the impression was served. The make is generally the manufacturer of the device (i.e., Apple). To retrieve a complete list of device make IDs and names, use the Device Make Service.

dimension

device_make_name

string

The name of the device make on which the impression was served. The make is generally the manufacturer of the device (i.e., Apple).

dimension

device_model_id

string

The ID of the device model on which the impression was served. The model is generally the specific product (i.e., iPhone). To retrieve a complete list of device model IDs and names, use the Device Model Service.

dimension

device_model_name

string

The name of the device model on which the impression was served. The model is generally the specific product (i.e., IPhone).

dimension

device_type

string

The type of device on which the impression was served. Possible values are: "desktops & laptops" "tablets" "mobile phones" "tv" "game consoles" "set top box" "media players" "other devices"

dimension

device_type_id

string

The device type id

dimension

discrepancy_allowance

float

The discrepancy allowance

metric

domains_exposed

string

Whether this inventory's domains are exposed for targeting by buyers. Allowed values: "Exposed" "Not exposed"

dimension

domains_exposed_id

string

An integer that denotes whether this inventory's domains are exposed for targeting by buyers. Allowed values: 0 (False) 1 (True)

dimension

ecpa

currency

The effective advertiser spend per conversion/acquisition.

metric

ecpa_adv_curr

currency

The cost per acquisition in the advertiser currency type.

metric

ecpc

currency

The effective advertiser spend per click.

metric

ecpc_adv_curr

currency

The cost per click in the advertiser currency type.

metric

ecpm

currency

Amount of currency spent per 1000 impressions.

metric

ecpm_adv_curr

currency

The cost per 1,000 impressions in the advertiser currency type.

metric

ecpm_pub_curr

currency

Amount of currency spent per 1000 impressions, in the currency of the publisher.

metric

end_date

date

The day and time when the deal stops being available to the buyer.

dimension

entity_member_id

string

If imp_type is 1, 2, 3, 4, 6, or 8, the ID of the buying member; otherwise, the ID of the selling member.

dimension

error_count

int

The amount of errors logged on the Xandr platform over the timeframe selected (a randomly selected set of 1% of the errors multiplied by 100 to account for the sampling).

metric

error_id

string

The specific error that occurred and was logged in ImpBus (ties to Error Message)

dimension

error_message

string

A generic Error Message that describes the error that occurred (ties to Error ID)

dimension

errors

int

The total number of times an error occurred.

metric

estimated_number_of_users

float

The estimated number of users

metric

estimated_number_of_users_adjusted

float

The estimated number of users adjusted

metric

estimated_number_of_users_adjusted_new

float

The estimated number of users adjusted new

metric

exposed_for_resale

string

Whether this inventory is exposed for resale. Allowed values: "Exposed" "Not Exposed"

dimension

exposed_for_resale_id

string

An integer that denotes whether this inventory is exposed for resale. Allowed values: 0 (False) 1 (True)

dimension

external_click

int

The number of external clicks.

metric

external_clicks

int

The number of external (non-network) clicks.

metric

external_data

string

Additional data optionally passed in the conversion pixel, for example, the conversion geography, an affiliate code, or other information related to the sale or user. For information about dynamically passing external data in a conversion pixel, see Conversion Pixels Advanced (customer login required).

dimension

external_impression

int

The number of impressions from an impression tracker.

metric

external_imps

int

The number of external (non-network) impressions.

metric

external_inv_id

string

An optional code passed in the query string to further break out inventory. Read more here. Note: For impressions older than 100 days, the external_inv_id will be 0.

dimension

external_inv_name

string

An optional name assigned to the external inventory ID. Read more here.

dimension

fill_rate

float

The percentage of ad requests that were filled with demand. (Kept Impressions and Resold Impressions / total number of impressions).

metric

fill_rate

float

The percentage of ad requests that were filled with demand. (Kept Impressions and Resold Impressions / total number of impressions).

metric

filtered_requests

int

Ad requests filtered pre-bid by Xandr for inventory quality.

metric

flight.booked_impressions_budget_daily

int

The daily impression budget for the line item's flight.

metric

flight.booked_impressions_budget_lifetime

int

The lifetime impression budget for the line item's flight.

metric

flight.booked_revenue_budget_daily_advertiser_currency

float

flight booked revenue budget daily advertiser currency

metric

flight.booked_revenue_budget_lifetime_advertiser_currency

float

flight booked revenue budget lifetime advertiser currency

metric

flight.end_date

date

The end date of the line item's flight.

dimension

flight.start_date

date

The start date of the line item's flight.

dimension

flight_id

string

The flight id

dimension

fold_position

string

The fold position, i.e. where on the page the placement is located. For allowed values, see fold_position_id.

dimension

fold_position_id

string

The ID of the fold position, i.e. where on the page the placement is located. Possible values for impressions: 0 = "unknown" 1 = "above" 2 = "below"

dimension

forex_allowance

string

The forex allowance

dimension

fx_margin_deductions

float

The fx margin deductions

metric

fx_margin_deductions_buying_currency

float

The fx margin deductions buying currency

metric

fx_margin_fees

float

The fx margin fees

metric

fx_margin_fees_buying_currency

float

The fx margin fees buying currency

metric

gender

string

The gender of the user. Note: For impressions older than 100 days, the gender will be "u".

dimension

geo_city_id

string

The ID of the user's city location. For city IDs, see City Service.

dimension

geo_city_name

string

The name of the user's city location. For city names, see City Service.

dimension

geo_country

string

The code for the geographic country. For impression requests for which we received no indication that the ad was rendered (i.e., non-transacted), country information is not provided.

dimension

geo_country_code

string

The country code of the user's location as defined by the Country Service.

dimension

geo_country_id

string

The country ID of the user's location as defined by the Country Service. 250 is shown in cases where we don't know the country or if the country doesn't map correctly to a location in our database.

dimension

geo_country_name

string

The name of the geographic country. For impression requests for which we received no indication that the ad was rendered (i.e., non-transacted), country information may not be provided.

dimension

geo_dma_id

string

The ID of the user's designated market area location as defined by the Designated Market Area Service. Why am I seeing a DMA ID of 1? Our reporting derives DMA from the city logged for the auction. However, our geo provider is sometimes unable to determine a city from the IP address associated with the impression, even when DMA is determined. Therefore, there are cases where a campaign targeting a specific DMA has impressions in reporting showing a DMA of 1.

dimension

geo_dma_name

string

The name of the user's designated market area location as defined by the Designated Market Area Service.

dimension

geo_postal_code

string

The postal code of the user's location. For postal codes, see Postal Code Service.

dimension

geo_region_code

string

The region code of the user's location as defined by the Region Service.

dimension

geo_region_id

string

The region ID of the user's location as defined by the Region Service. 4291 is shown in cases where we don't know the region or if the region doesn't map correctly to a location in our database.

dimension

geo_region_name

string

The name of the region of the user's location as defined by the Region Service.

dimension

gross_win_rate

int

The gross win rate for the deal.

metric

header_bidding_demand_partner

string

The name and ID of the demand partner associated with the placement.

dimension

header_bidding_demand_partner_id

string

The ID of the demand partner associated with the placement.

dimension

header_bidding_demand_partner_name

string

The demand partner associated with the placement.

dimension

height

int

The height of the creative.

metric

hour

date

The hour of the auction. Note: For impressions older than 100 days, the day will be returned rather than the hour.

dimension

imp_requests

int

The total number of ad calls (impression requests).

metric

imp_time

date

The date and time of the impression (when the creative was served).

dimension

imp_type_id

string

The ID for the type of impression. Possible values (associated types in parentheses):1 ("Blank"): No creative served. 2 ("PSA"): A public service announcement served because there were no valid bids and no default creative was available. 3 ("Default Error"): A default creative served due to a timeout issue. 4 ("Default"): A default creative served because there were no valid bids. 5 ("Kept"): Your advertiser's creative served on your publisher's site. 6 ("Resold"): Your publisher's impression was sold to a third-party buyer. 7 ("RTB"): Your advertiser's creative served on third-party inventory. 8 ("PSA Error"): A public service announcement served due to a timeout issue or lack of a default creative. 9 ("External Impression"): An impression from an impression tracker. 10 ("External Click"): A click from a click tracker.

dimension

imp_type_name

string

The name of the type of impression that occurred. For possible values and more information about each type, see imp_type_id.

dimension

imps

int

The total number of impressions (served and resold).

metric

imps_appnexus_cleared

string

If this is set to 1, then the impression was successfully served on direct inventory. Possible values: 0 = not direct inventory 1 = direct inventory

dimension

imps_blacklisted

int

The number of impressions that didn't serve because a site was blacklisted.

metric

imps_blank

int

The number of impressions served with a blank.

metric

imps_default

int

The number of impressions that defaulted.

metric

imps_default_bidder

int

The number of impressions that defaulted because there were no valid bids.

metric

imps_default_error

int

The number of impressions that defaulted due to a timeout issue.

metric

imps_delivered

string

The total number of impressions served successfully.

dimension

imps_direct_cleared

string

If this is set to 1, then the impression was successfully served on direct inventory. Possible values: 0 = not direct inventory 1 = direct inventory

dimension

imps_filled

int

The number of blank, PSA, default, kept, resold, and external impressions.

metric

imps_filtered

int

The total number of bid requests for which Xandr did not hold an auction due to inventory quality concerns. See imps_filtered_reason_id and imps_filtered_reason (under Dimensions) for a list of the possible reasons.

metric

imps_filtered_reason

string

The reason why the impression request was filtered out by Xandr inventory quality controls and the auction was not held. Possible reasons are: "Invalid Domain" (1) "Invalid IP" (2) "Suspected Domain Detection Tampering" (3, 4, 5) "Unknown" (6, 7)"Valid Impression" (0) is also a valid filtered request reason, but in that case, an auction was held and it was not filtered.

dimension

imps_filtered_reason_id

string

The numeric ID associated with the reason why the impression request was filtered out by Xandr inventory quality controls and the auction was not held. Possible values are integers between 0 and 7. See imps_filtered_reason below for more information.

dimension

imps_insertion

float

imps insertion

metric

imps_kept

int

The number of impressions your advertiser purchased from your publisher.

metric

imps_master_creative

int

The total number of impressions from the master creative in page-level roadblocking. Note: This metric is in alpha testing and not available to all customers.

metric

imps_matched

int

The total number of impressions that match the seller's settings (not the buyer's) on the deal.

metric

imps_not_delivered

string

The total number of impressions where someone other than Xandr served the impression.

dimension

imps_psa

int

The number of impressions served a PSA.

metric

imps_psa_error

int

The number of impressions served a PSA due to a timeout issue or lack of a default creative.

metric

imps_resold

int

The number of impressions your publisher sold to a third party.

metric

imps_rtb

int

The number of impressions your advertiser bought from a third party.

metric

imps_sold

int

The number of impressions you sold to other members.

metric

imps_total

int

The total number of impressions (served and resold).

metric

imps_viewed

int

The number of measured impressions that were viewable, per the IAB Viewability definition, which states that an impression is viewable if 50% of the pixels are in-view during 1 consecutive second.

metric

imps_won

int

The total number of impressions won.

metric

included_header_bidding_demand

int

The included demand from non-Xandr demand partners.

metric

ineligible_bid_rate

int

The rate of ineligible bids on the deal.

metric

insertion_order.billing_code

string

The billing code associated with the insertion order.

dimension

insertion_order.booked_impressions_budget_daily

int

The daily impression budget for the insertion order.

metric

insertion_order.booked_impressions_budget_lifetime

int

The lifetime impression budget for the insertion order.

metric

insertion_order.booked_revenue_budget_daily

currency

The daily budget in revenue for the insertion order.

metric

insertion_order.booked_revenue_budget_lifetime

currency

The lifetime budget in revenu for the insertion order.

metric

insertion_order.end_date

date

The end date of the non-seamless insertion order associated with the impression. For seamless orders, see billing_period.end_date .

dimension

insertion_order.lifetime_pacing

float

The insertion order lifetime pacing

metric

insertion_order.sales_rep_label

float

The insertion order sales rep label

metric

insertion_order.start_date

date

The start date of the non-seamless insertion order associated with the impression. For seamless orders, see billing_period.start_date .

dimension

insertion_order.state

string

The state of the insertion order (e.g., active, inactive).

dimension

insertion_order.trafficker_label

string

The insertion order trafficker label

dimension

insertion_order.type

string

The type of insertion order associated with the impression (e.g. Legacy, Seamless).

dimension

insertion_order.type_label

string

The insertion order type label

dimension

insertion_order_code

string

The custom code for the insertion order.

dimension

insertion_order_frequency_bucket

string

The bucket for how frequently the insertion order's creatives were displayed. See Insertion Order Frequency Buckets.

dimension

insertion_order_frequency_bucket_id

string

The ID of the insertion order frequency bucket. See Insertion Order Frequency Buckets below for possible values.

dimension

insertion_order_id

string

The ID of the insertion order.

dimension

insertion_order_name

string

The name of the insertion order.

dimension

insertion_order_type

string

A field describing the insertion order, provided by the user. See Insertion Order Service for more information.

dimension

inventory_class

string

The class of the inventory.

dimension

inventory_source

string

The inventory source

dimension

inventory_source_id

string

The inventory source id

dimension

inventory_source_name

string

The inventory source name

dimension

is_buy_side_billing_trx_type

string

The is buy side billing trx type

dimension

is_cross_seat_activity

string

The cross seat activity

dimension

is_curated

string

Is curated

dimension

is_deal

string

Is deal

dimension

is_delivered

string

If true, the impression was served successfully.

dimension

is_delivered

string

Is delivered

dimension

is_dw

string

If true, the impression was served by Xandr.

dimension

is_remarketing

int

If 1, the campaign is remarketing. If 0, the campaign is not remarketing.

metric

is_remarketing

int

If 1, the campaign is remarketing. If 0, the campaign is not remarketing.

metric

is_sell_side_billing_trx_type

string

Is sell side billig trx type

dimension

is_valid_buyer

string

Is valid buyer

dimension

is_valid_buying_imp_type

string

Is valid buying imp type

dimension

is_valid_seller

string

Is valid seller

dimension

key_name

string

The name of the targeting key.

dimension

key_name_label

string

The label for the key. The label can be a more descriptive version of the key name.

dimension

key_value

string

The value associated with the targeting key.

dimension

key_value_label

string

The label for the value. The label can be a more descriptive version of the key value.

dimension

language_id

string

The ID of the language.

dimension

language_name

string

The name of the language.

dimension

last_fired

date

The date on which the conversion pixel last fired. If the pixel has never fired, this will be 1900-01-01 00:00:00.

dimension

line_item.booked_impressions_budget_daily

int

The daily impression budget for the line item.

metric

line_item.booked_impressions_budget_lifetime

int

The lifetime impression budget for the line item.

metric

line_item.booked_revenue_budget_daily_adv_curr

currency

The daily budget in revenue for the line item.

metric

line_item.booked_revenue_budget_lifetime_adv_curr

currency

The lifetime budget in revenue for the line item.

metric

line_item.comments

string

Any comments related to this line item.

dimension

line_item.end_date

date

The end date of the non-augmented line item. For augmented line Items (ALIs), see flight.end_date .

dimension

line_item.lifetime_pacing

string

The line item lifetime pacing

dimension

line_item.salesrep_label

string

The line item salesrep label

dimension

line_item.start_date

date

The start date of the non-augmented line item. For augmented line Items (ALIs), see flight.start_date .

dimension

line_item.status

string

The state of the line item (e.g., active, inactive).

dimension

line_item.trafficker_label

string

The line item trafficker label

dimension

line_item.true_line_item_type

string

The line item true line item type

dimension

line_item.type

string

The line item type (e.g., standard, augmented).

dimension

line_item.type_label

string

The line item type label

dimension

line_item_code

string

The custom code for the line item.

dimension

line_item_frequency_bucket

string

The bucket for how frequently the line item's creatives were displayed. See Line Item Frequency Buckets.

dimension

line_item_frequency_bucket_id

string

The ID of the line item frequency bucket. See Line Item Frequency Buckets below for possible values

dimension

line_item_id

string

The ID of the line item.

dimension

line_item_name

string

The name of the line item.

dimension

line_item_type

string

A field describing the line item, provided by the user. See Line Item Service for more information.

dimension

logged_error_message

string

Logged error message

dimension

marginal_unique_users

float

Marginal unique users

metric

marketplace_clearing_event

string

The concatenated value of the name and ID of the underlying auction event that was transacted (e.g., impression, viewable impression, completed video). For more information, see Exchange Traded Views. For a list of Clearing Events and their IDs, see Supported Viewability Standards .

dimension

marketplace_clearing_event_buyer_media_cost_ecpm

float

The total media cost per 1000 events (for the associated Clearing Event).

metric

marketplace_clearing_event_id

string

The ID of the underlying auction event that was transacted (e.g., impression, viewable impression, completed video). For more information, see Exchange Traded Views. For a list of Clearing Events and their IDs, seeSupported Viewability Standards .

dimension

marketplace_clearing_event_name

string

The name of the underlying auction event that was transacted (e.g., impression, viewable impression, completed video). For more information, see Exchange Traded Views. For a list of Clearing Events and their IDs, seeSupported Viewability Standards .

dimension

marketplace_clearing_event_name

string

The name of the underlying auction event that was transacted (e.g., impression, viewable impression, completed video). For more information, see Exchange Traded Views. For a list of Clearing Events and their IDs, seeSupported Viewability Standards .

dimension

marketplace_clearing_event_units

int

The total number of events purchased (for the associated Clearing Event). When buying a Clearing Event other than impression (e.g., viewable impressions), the number of billed events will be less than the number of impressions. For more information, see Exchange Traded Views.

metric

marketplace_clearing_event_units_cpm

float

marketplace clearing event units cpm

metric

marketplace_clearing_events_booked_revenue_cpm

float

The total revenue per 1000 events (for the associated Clearing Event).

metric

media_buy_cost

currency

The amount paid for the external click. The third-party ad server passes this in the "ancost" parameter of the click tracker's query string.

metric

media_buy_rev_share_pct

float

The percentage of revenue that the member pays the publisher.

metric

media_cost

currency

The total cost of the inventory purchased.

metric

media_cost_adv_curr

currency

The total cost of the inventory purchased, in the currency of the advertiser. Note: If you are not tracking revenue through Xandr, this will be 0.

metric

media_cost_advertiser_currency

float

The media cost advertiser currency

metric

media_cost_buying_currency

currency

The media cost buying currency

metric

media_cost_pub_curr

currency

The media cost, expressed in the currency of the publisher. You must group by publisher or publisher_currency when pulling this report if you are reporting across publishers who use different currencies.

metric

media_cost_vcpm

float

The media cost vcpm

metric

media_cost_vcpm_advertiser_currency

currency

The media cost vcpm advertiser currency

metric

media_subtype

string

The display style of creatives that can use this template. Each media subtype belongs to a superordinate media type, for example, the "Standard Banner" media subtype belongs to the "Banner" media type. See Media Subtype Service for more details.

dimension

media_subtype_id

string

The ID of media subtype. See Media Subtype Service for more details.

dimension

media_type

string

The specific display style of a creative. You can use the Media Subtype Service to view all possible media subtypes.

dimension

media_type_id

string

The media type id

dimension

mediatype

string

The mediatype

dimension

mediatype_id

string

The ID of the specific display style of a creative. You can use the Media Subtype Service to view all possible media subtypes.

dimension

member_id

string

The ID of the member.

dimension

member_id_filter

string

The member id filter

dimension

member_id_str

string

The member id str

dimension

member_name

string

The name of the member whose creative was audited.

dimension

mobile_application_id

string

A targetable Apple App Store ID, Google Play package name, or Windows application ID.

dimension

mobile_application_name

string

The name of the mobile application as it appears in the Apple App and Google Play Stores.

dimension

month

date

The month of the auction.

dimension

monthly_uniques

int

The number of unique user IDs added to the segment in a specific month. To view this metric, you must include the month dimension.

metric

net_media_cost

currency

The total cost of inventory purchased, less the buyer's auction service charge deductions.

metric

net_media_cost_adv_curr

currency

The total cost of inventory purchased, less the buyer's auction service charge deductions, in the currency of the advertiser. Note: If you are not tracking revenue through Xandr, this will be 0 .

metric

net_media_cost_buying_currency

currency

The total amount to be paid for media purchases, less the Auction Service Deduction, in the transaction currency the buyer used to buy the impression.

metric

net_win_rate

int

The net win rate for the deal.

metric

network_advertiser_rpm

currency

The network advertiser rpm

metric

network_advertiser_rpm_adv_curr

currency

The network advertiser rpm adv curr

metric

network_ppm

currency

Network profit per Mille (1000 imps)

metric

network_ppm_net_commissions

currency

The network ppm net comissions

metric

network_ppm_selling_currency

currency

The network ppm selling currency

metric

network_profit

currency

Network profit booked through direct advertisers and resold to real-time buyers.

metric

network_profit_net_commissions

currency

The network profit net commissions

metric

network_profit_selling_currency

currency

The network profit selling currency

metric

network_resold_rpm

float

The network resold rpm

metric

network_revenue

currency

Network revenue booked through direct advertisers and resold to real-time buyers

metric

network_revenue_net_commissions

currency

The network revenue net commissions

metric

network_revenue_selling_currency

currency

The network revenue selling currency

metric

network_roi

float

Network return on investment. Returned as a percentage, e.g., 0.94 = 94%

metric

network_roi

float

Network return on investment. Returned as a percentage, e.g., 0.94 = 94%

metric

network_roi_net_commissions

float

The network roi net comissions

metric

network_rpm

currency

Network revenue per Mille (1000 imps)

metric

network_rpm

currency

Network revenue per Mille (1000 imps)

metric

network_rpm_net_commissions

currency

Network revenue per Mille (1000 imps) comissions

metric

non_hosted_video_ad_serving_fees

currency

The non hosted video ad serving fees

metric

non_hosted_video_ad_serving_fees_selling_currency

currency

The non hosted video ad serving fees selling currency

metric

num_audits_completed

int

The number of audits completed in the grouping specified.

metric

operating_system_family

string

The operating system of the device. Use Operating System Family service to obtain a list of operating system families. Use the Operating System Extended service to look up which operating system versions are within a given operating system family.

dimension

operating_system_family_id

string

The ID of the operating system of the device. Use Operating System Family service to obtain a list of operating system families. Use the Operating System Extended service to look up which operating system versions are within a given operating system family.

dimension

operating_system_family_name

string

The ID of the operating system of the device. Use Operating System Family service to obtain a list of operating system families. Use the Operating System Extended service to look up which operating system versions are within a given operating system family.

dimension

operating_system_id

string

The ID of the operating system of the device. Use Operating System Family service to obtain a list of operating system families. Use the Operating System Extended service to look up which operating system versions are within a given operating system family.

dimension

operating_system_name

string

The ID of the operating system of the device. Use Operating System Family service to obtain a list of operating system families. Use the Operating System Extended service to look up which operating system versions are within a given operating system family.

dimension

order_id

string

The order ID or SKU optionally passed in the conversion pixel. For information about dynamically passing an order ID in a conversion pixel, see Conversion Pixels Advanced(customer login required).

dimension

package_id

string

The ID of the package, if the deal is associated with a package. The integer value of the package that the deal was created from. This value will be 0 if the deal was not created from a package.

dimension

payment_type

string

The type of payment to a broker. Possible values: "cpm", "revshare", "cpvm".

dimension

payment_type_id

string

The payment type id

dimension

pixel_id

string

The ID of the pixel used to track the conversion. For more information, see the Conversion Pixel Service.

dimension

pixel_name

string

The name of the conversion pixel.

dimension

placement_code

string

The custom code for the placement.

dimension

placement_id

string

The ID of the placement. Note:For impressions older than 14 months, placements will be aggregated into one row with -1 as the placement_id.

dimension

placement_name

string

The name of the placement. Note:For impressions older than 14 months, placements will be aggregated into one row with "All placement data older than 14 months" as the placement_name.

dimension

post_click_conversion_pixel

int

The number of post click conversions for a specific pixel.

metric

post_click_conversion_rate

float

The post click conversion rate

metric

post_click_conversions

int

The post click conversions

metric

post_click_convs

int

The total number of recorded post-click conversions.

metric

post_click_convs_pixel

string

The post click conversion pixel

dimension

post_click_convs_rate

float

The rate of post-click conversions to impressions.

metric

post_click_or_post_view_conv

string

The type of conversion. If "Post Click", the conversion is attributed to a user clicking a creative. If "Post View", the conversion is attributed to a user viewing a creative. The conversion type is defined when the conversion pixel is assigned to a line item.

dimension

post_click_or_post_view_revenue

currency

The revenue optionally passed in the conversion pixel using the "value" parameter.

metric

post_click_revenue

currency

The revenue from post-click conversions.

metric

post_click_revenue_pixel

currency

The amount of revenue earned for a specific pixel.

metric

post_view_conversion_pixel

int

The number of post view conversions for a specific pixel.

metric

post_view_conversion_rate

float

The post view conversion rate

metric

post_view_conversions

int

The post view conversions

metric

post_view_convs

int

The total number of recorded post-view conversions.

metric

post_view_convs_pixel

int

Post view conversions for the pixel.

metric

post_view_convs_rate

float

The rate of post-view conversions to impressions.

metric

post_view_revenue

currency

The revenue from post-view conversions.

metric

post_view_revenue_pixel

currency

The amount of revenue earned for a specific pixel.

metric

ppm

currency

The profit per 1000 impressions.

metric

ppm_buying_currency

currency

The profit per 1000 impressions in the currency the buyer used to purchase the inventory. Note: exchange rates are not yet available in reporting.

metric

ppm_including_fees

currency

The profit including additional fees per 1000 impressions.

metric

ppm_selling_currency

currency

The profit per 1000 impressions in the currency the seller used to sell the impression. Note: exchange rates are not yet available in reporting.

metric

predict_rev_type

int

The optimization phase of a campaign that served on the publisher's inventory. Possible values: -2 = No predict phase -1 = Base predict phase 0 = Learn giveup 1 = Learn 2 = Throttled 3 = Optimized 4 = Biased 5 = Optimized 1 8 = Optimized giveup 9 = Base bid below giveup

metric

predict_type_rev

int

The optimization phase of the campaign. Possible values: -2 = No predict phase -1 = Base predict phase 0 = Learn giveup 1 = Learn 2 = Throttled 3 = Optimized 4 = Biased 5 = Optimized 1 8 = Optimized giveup 9 = Base bid below giveup

metric

pricing_media_type_id

string

ID of the video-specific media type classification (for billing only). If you don't have video-specific pricing, this field is irrelevant. Possible values are 0, 1, 2, 3.

dimension

pricing_media_type_name

string

Name of the video-specific media type classification (for billing only). If you don't have video-specific pricing, this field is irrelevant. Possible values are "--", "Non-Video", "Video (Hosted)", "Video (Non-Hosted)".

dimension

pricing_type

string

The way the member is paid by the advertiser. Possible values: "none", "cpm', "cpc", "cpa", "cost_plus_cpm", or "cost_plus_margin".

dimension

priority

string

For a private auction only, the priority the seller assigned to the deal.

dimension

profit

currency

The total network revenue minus network cost.

metric

profit_advertiser_buying_currency

currency

The profit advertiser buying currency

metric

profit_advertiser_currency

currency

The profit advertiser currency

metric

profit_buying_currency

currency

The total network revenue minus network cost in the currency the buyer used to purchase the inventory. Note: exchange rates are not yet available in reporting.

metric

profit_ecpm

float

The profit per 1000 impressions.

metric

profit_ecpm_buying_currency

currency

The profit ecpm buying currency

metric

profit_ecpm_including_fees

currency

Profit per thousand impressions after commissions and serving fees.

metric

profit_ecpm_including_fees_buying_currency

currency

The profit ecpm including fees buying currency

metric

profit_including_fees

currency

The total network revenue minus network cost and additional fees.

metric

profit_including_fees_buying_currency

currency

The profit including fees buying currency

metric

profit_margin

currency

The profit as a percentage of revenue.

metric

profit_margin_including_fees

currency

Profit margin after commissions and serving fees.

metric

profit_net_including_fees

currency

Net profit after commissions and serving fees.

metric

profit_selling_currency

currency

The total network revenue minus network cost in the currency the seller used to sell the impression. Note: exchange rates are not yet available in reporting.

metric

psas_or_blanks

int

The number of blanks or PSAs served.

metric

pub_default_imps_total_revenue

float

The pub default imps total revenue

metric

pub_default_imps_total_revenue_ecpm

float

The pub default imps total revenue ecpm

metric

pub_default_imps_total_revenue_ecpm_publisher_curr

currency

The pub default imps total revenue ecpm publisher currency

metric

pub_default_imps_total_revenue_publisher_currency

currency

The pub default imps total revenue publisher currency

metric

pub_rule_code

string

The custom code for the publisher rule.

dimension

pub_rule_id

string

The ID of the publisher rule.

dimension

pub_rule_name

string

The name of the publisher rule.

dimension

publisher_code

string

The custom code for the publisher.

dimension

publisher_currency

string

The currency of the publisher.

dimension

publisher_currency

string

The currency of the publisher.

dimension

publisher_default_revenue

currency

The revenue paid out to the publisher (based on revshare or CPM) for default impressions.

metric

publisher_default_revenue_publisher_currency

currency

The publisher default revenue publisher currency

metric

publisher_default_rpm

currency

The publisher revenue per 1000 default impressions.

metric

publisher_default_rpm_publisher_currency

currency

The publisher default rpm publisher currency

metric

publisher_filled_revenue

currency

The revenue paid out to the publisher (based on revshare or CPM) for filled impressions.

metric

publisher_filled_revenue_publisher_currency

currency

The publisher filled revenue publisher currency

metric

publisher_filled_rpm

currency

The publisher revenue per 1000 filled impressions.

metric

publisher_filled_rpm_publisher_currency

currency

The publisher revenue per 1000 filled impressions, in the publisher's currency.

metric

publisher_id

string

The ID of the publisher.

dimension

publisher_name

string

The name of the publisher.

dimension

publisher_revenue

currency

The revenue paid out to the publisher (based on revshare or cpm).

metric

publisher_revenue_pub_curr

currency

The revenue paid out to the publisher (based on revshare or cpm), in the currency of the publisher.

metric

publisher_rpm

currency

The publisher revenue per 1000 impressions.

metric

publisher_rpm

currency

The publisher revenue per 1000 impressions.

metric

publisher_rpm_pub_curr

currency

The publisher revenue per 1000 impressions, in the currency of the publisher.

metric

publisher_rpm_publisher_currency

currency

The publisher rpm publisher currency

metric

quality_cpm

float

The quality cpm

metric

quality_imps

float

The quality imps

metric

reach_expansion_factor

float

The reach expansion factor

metric

reject_below_floor_count

int

The number of bids rejected because they are below the reserve price set on the auction.

metric

reject_below_floor_ym_count

int

The number of bids rejected because they are below the yield management floor set for the deal.

metric

reject_bidder_error_count

int

The number of bids rejected due to bidder errors.

metric

reject_bidder_error_deal_not_available_count

int

The number of bids rejected because the deal was no longer available.

metric

reject_blocked_by_ad_profile_adserver_count

int

The number of bids rejected because an ad server associated to the creative that the buyer bid with is blocked.

metric

reject_blocked_by_ad_profile_audit_status_count

int

The number of bids blocked by the Ad Profile due to their audit status. This typically happens when the buyer is bidding with an unaudited creative and the seller has blocked unaudited creatives in ad quality.

metric

reject_blocked_by_ad_profile_brand_count

int

The number of bids blocked by the ad profile due to brand exclusions.

metric

reject_blocked_by_ad_profile_category_count

int

The number of bids rejected because the ad profile does not allow the category of the creative.

metric

reject_blocked_by_ad_profile_count

int

The sum of all bids rejected by the Ad Profile.

metric

reject_blocked_by_ad_profile_creative_count

int

The number of bids rejected because the creative ad server was blocked by the ad profile.

metric

reject_blocked_by_ad_profile_language_count

int

The number of bids rejected because the language of the ad was blocked by the ad profile.

metric

reject_blocked_by_ad_profile_member_count

int

The number of bids rejected because the member was blocked by the ad profile.

metric

reject_blocked_by_ad_profile_tech_attribute_count

int

The number of bids rejected because a technical attribute of the ad was blocked by the ad profile.

metric

reject_blocked_by_deal_adserver_count

int

The number of bids blocked due to adserver constraints on the deal.

metric

reject_blocked_by_deal_below_floor_count

int

The number of bids rejected because they are below the deal's floor price.

metric

reject_blocked_by_deal_brand_count

int

The number of bids rejected because their brand was blocked by the deal.

metric

reject_blocked_by_deal_category_count

int

The number of bids rejected because the deal does not allow the category of the creative.

metric

reject_blocked_by_deal_count

int

The sum of all bids rejected due to constraints of the deal.

metric

reject_blocked_by_deal_creative_count

int

The number of bids blocked by the deal due to their language settings.

metric

reject_blocked_by_deal_language_count

int

The number of bids blocked by the deal due to their language settings.

metric

reject_blocked_by_deal_media_subtype_count

int

The number of bids rejected due to their media subtypes.

metric

reject_blocked_by_deal_payment_type_count

int

The number of bids rejected because their payment type was not allowed by the deal.

metric

reject_blocked_by_deal_size_count

int

The number of bids rejected because they did not match the size requirements for the deal.

metric

reject_blocked_by_deal_tech_attribute_count

int

The number of bids rejected because a technical attribute was blocked by the deal.

metric

reject_blocked_by_dynamic_adserver_count

int

The number of bids rejected due to adserver constraints dynamically passed in by the seller at the time of the impression request.

metric

reject_blocked_by_dynamic_brand_count

int

The number of bids rejected because the brand is blocked dynamically by the bid request passed in by the seller.

metric

reject_blocked_by_dynamic_category_count

int

The number of bids rejected because the creative category is blocked dynamically by the bid request passed in by the seller.

metric

reject_blocked_by_dynamic_language_count

int

The number of bids rejected because the language is blocked dynamically by the bid request passed in by the seller.

metric

reject_blocked_by_dynamic_tech_attribute_count

int

The number of bids rejected because their techincal attributes are blocked dynamically by the bid request passed in by the seller.

metric

reject_count

int

The total number of rejected bids.

metric

reject_invalid_creative_count

int

The number of bids rejected due to invalid creatives that the buyer bid with.

metric

reject_invalid_creative_not_ssl_count

int

The number of bids rejected due to the creative not being SSL approved for a secure auction.

metric

reject_other_advertiser_exclusion_count

int

The total number of bids rejected due to advertiser exclusions not listed above.

metric

reject_other_count

int

The number of bids rejected for reasons not listed here.

metric

reject_other_data_protection_count

int

The total number of bids rejected for data security reasons not listed here.

metric

reseller_revenue

currency

The total revenue on resold impressions through direct publishers.

metric

reseller_revenue_advertiser_currency

currency

The reseller revenue advertiser currency

metric

reseller_revenue_buying_currency

currency

The total revenue on resold impressions through direct publishers in the currency the buyer used to purchase the inventory. Note: exchange rates are not yet available in reporting.

metric

reseller_revenue_pub_curr

currency

The revenue generated through sales to external (RTB) buyers, in the currency of the publisher.

metric

reseller_revenue_publisher_currency

currency

The reseller revenue publisher currency

metric

reseller_revenue_selling_currency

currency

The total revenue on resold impressions through direct publishers in the currency the seller used to sell the impression. Note: exchange rates are not yet available in reporting.

metric

response_rate

float

The response rate

metric

revenue

currency

The sum of booked revenue and reseller revenue.

metric

revenue_adv_curr

currency

The sum of booked revenue and reseller revenue, in the currency of the advertiser.

metric

revenue_advertiser_currency

currency

The revenue advertiser currency

metric

revenue_buying_currency

currency

The sum of booked revenue and reseller revenue in the currency the buyer used to purchase the inventory. Note: exchange rates are not yet available in reporting.

metric

revenue_ecpa

currency

The total revenue per conversion.

metric

revenue_ecpa_adv_curr

currency

The total revenue per conversion in the advertiser's currency.

metric

revenue_ecpa_buying_currency

currency

The revenue ecpa buying currency

metric

revenue_ecpa_including_fees

currency

Revenue per conversion after commissions.

metric

revenue_ecpa_including_fees_adv_currency

currency

Revenue per conversion after commissions, in the advertiser's currency.

metric

revenue_ecpc

currency

The total revenue per click.

metric

revenue_ecpc_adv_curr

currency

The total revenue per click in the advertiser's currency.

metric

revenue_ecpc_buying_currency

currency

The revenue ecpc buying currency

metric

revenue_ecpc_including_fees

currency

Revenue per click after commissions.

metric

revenue_ecpc_including_fees_adv_currency

currency

Revenue per click after commissions, in the advertiser's currency.

metric

revenue_ecpm

currency

The total revenue per 1000 impressions.

metric

revenue_ecpm_adv_curr

currency

The total revenue per 1000 impressions in the advertiser's currency.

metric

revenue_ecpm_buying_currency

currency

The revenue ecpm buying currency

metric

revenue_ecpm_including_fees

currency

Revenue per thousand impressions after commissions.

metric

revenue_ecpm_including_fees_adv_currency

currency

Revenue per thousand impressions after commissions, in the advertiser's currency.

metric

revenue_including_fees

currency

The sum of booked revenue and reseller revenue minus commissions.

metric

revenue_per_video_complete

float

The revenue per video completion.

metric

revenue_publisher_currency

currency

The revenue publisher currency

metric

revenue_selling_currency

currency

The sum of booked revenue and reseller revenue in the currency the seller used to sell the impression. Note: exchange rates are not yet available in reporting.

metric

revenue_type

string

The basis on which the member gets paid.

dimension

revenue_type_id

string

Possible values: -1 = No Payment, 0 = Flat CPM, 1 = Cost Plus CPM, 2 = Cost Plus Margin, 3 = CPC, 4 = CPA, 5 = Revshare, or 6 = Flat Fee, 7 = Variable CPM, 8 = Estimated CPM, or 9 = CPVM.

dimension

revenue_value

currency

The amount that the advertiser pays the member. This is set at the line item.

metric

rpm

currency

The revenue per 1000 impressions.

metric

rpm

currency

The revenue per 1000 impressions.

metric

rpm_adv_curr

float

The revenue per thousand impressions, in the currency of the advertiser.

metric

rpm_buying_currency

currency

The revenue per 1000 impressions in the currency the buyer used to purchase the inventory. Note: exchange rates are not yet available in reporting.

metric

rpm_including_fees

currency

The revenue minus commissions per 1000 impressions.

metric

rpm_selling_currency

currency

The revenue per 1000 impressions in the currency the seller used to sell the impression. Note: exchange rates are not yet available in reporting.

metric

sales_tax

currency

The amount of sales tax collected. This field is only populated when the Buyer's billing address is located in one of the following U.S. states: NY, TX or NJ. Xandr is required (by the relevant local state regulator) to collect this tax.

metric

salesperson_for_advertiser

string

The salesperson for the advertiser. See the "labels" field in the Advertiser Service for more details.

dimension

salesperson_for_publisher

string

The salesperson for the publisher. See the "labels" field in the Publisher Service for more details.

dimension

salesrep_for_insertion_order

string

A custom reporting field containing the sales representative for the insertion order. See the labels field in the Insertion Order Service for more information. You may only select one reporting label per report.

dimension

salesrep_for_line_item

string

A custom reporting field containing the sales representative for the line item. See the labels field in the Line Item Service for more information. You may only select one reporting label per report.

dimension

second_level_category_id

string

The ID of the second-level content category assigned to the domain. Note: If the domain is an a top-level category, you should not request this dimension.

dimension

second_level_category_name

string

The name of the second-level content category assigned to the domain. Note: If the domain is an a top-level category, you should not request this dimension.

dimension

segment_code

string

The (optional) custom code associated with the user segment present for this impression.

dimension

segment_id

string

The ID of the segment pixel.

dimension

segment_name

string

The name of the segment.

dimension

seller_currency

string

The seller member's selected currency. For a list of supported currencies, see Supported Currencies.

dimension

seller_ecpm

currency

The seller revenue on the deal, represented in eCPM.

metric

seller_media_cost

currency

The amount owed to the publisher, in USD.

metric

seller_media_cost_selling_currency

currency

The amount owed to the publisher, in the transaction currency the seller used to sell the impression.

metric

seller_member_group

string

The seller member group

dimension

seller_member_id

string

The ID of the selling member.

dimension

seller_member_name

string

The name of the selling member.

dimension

seller_payment

string

The seller payment

dimension

seller_payment_pct

string

The seller payment pct

dimension

seller_revenue

currency

Revenue earned by the Seller.

metric

seller_revenue_ecpm

currency

The seller revenue on the deal, represented in eCPM.

metric

seller_revenue_event_type

string

The seller revenue event type

dimension

seller_revenue_event_type_id

string

The seller revenue event type id

dimension

seller_revenue_event_type_name

string

The seller revenue event type name

dimension

seller_revenue_event_units

string

The seller revenue event units

dimension

seller_revenue_seller_currency

string

The seller revenue seller currency

dimension

seller_type

string

The type of impression sold by the seller member. Possible values: "Real Time" or "Direct".

dimension

selling_currency

string

The transaction currency used by the seller to sell this impression.

dimension

selling_currency

string

The transaction currency used by the seller to sell this impression.

dimension

selling_imp_type

string

The type of impression. For possible values, see imp_type_id.

dimension

service_deductions

float

The service deductions

metric

service_deductions_buying_currency

float

The service deductions buying currency

metric

service_fees

float

The service fees

metric

service_fees_buying_currency

float

The service fees buying currency

metric

serving_fees

currency

Fees that are added to the media cost.

metric

serving_fees_buying_currency

currency

Fees that are added to the media cost in the currency the buyer used to purchase the inventory. Note: exchange rates are not yet available in reporting.

metric

serving_fees_selling_currency

currency

Fees that are added to the media cost in the currency the seller used to sell the impression. Note: exchange rates are not yet available in reporting.

metric

site_code

string

The custom code for the site.

dimension

site_domain

string

The site domain of an impression.

dimension

site_id

string

The ID of the site. Note: For impressions older than 14 months, the site_id will be 0.

dimension

site_name

string

The name of the site.

dimension

size

string

The size of the placement/creative served.

dimension

skip_rate

float

The number of video skips divided by the number of impressions.

metric

skips

int

The total number of times a user skipped the video.

metric

sold_network_rpm

float

The revenue per 1000 impressions that were not defaults or errors.

metric

sold_network_rpm_buying_currency

currency

The revenue per 1000 impressions that were not defaults or errors in the currency the buyer used to purchase the inventory. Note: exchange rates are not yet available in reporting.

metric

sold_network_rpm_selling_currency

currency

The revenue per 1000 impressions that were not defaults or errors in the currency the seller used to sell the impression. Note: exchange rates are not yet available in reporting.

metric

sold_publisher_rpm

float

The cost per 1000 impressions that were not defaults or errors.

metric

sold_publisher_rpm_selling_currency

float

The sold publisher rpm selling currency

metric

spend

currency

The amount spend

metric

spend_adv_curr

currency

The total amount spent by the advertiser in the advertiser's preferred currency.

metric

start_date

date

The day and time when the deal starts being available to the buyer.

dimension

start_rate

float

The number of video starts divided by the number of impressions.

metric

starts

int

The total number of times the first segment of the video creative was downloaded and started.

metric

submitted_bids

int

The number of submitted bids.

metric

supply_type

string

The type of inventory. Possible values: "web", "mobile_web", or "mobile_app", or "facebook_sidebar".

dimension

tag_id

string

The ID of the placement to which the click tracker is associated. If 0, the click tracker is not associated to a placement.

dimension

tag_name

string

The name of the tag associated with the impression.

dimension

targeted_segment_ids

string

The comma-separated list of IDs for each of the segments used when targeting.

dimension

technical_attribute_id

string

The technical attribute id

dimension

technical_attribute_name

string

The feature of the creative, such as whether it is an image, flash, video, is expandable, etc., that is affected by the error.

dimension

third_party_costs

string

The third party costs

dimension

top_level_category_id

string

The ID of the top content category assigned to the domain.

dimension

top_level_category_name

string

The name of the top content category assigned to the domain.

dimension

total_ad_requests

int

The total number of ad requests sent to Xandr for auction.

metric

total_ad_responses

int

The total number of ad responses counted within AppNex

metric

total_audit_fee

float

The total fees for audits in the grouping specified.

metric

total_conversions

int

The total number of post-view and post-click conversions.

metric

total_convs

int

The total number of post-view and post-click conversions.

metric

total_imps

int

The total number of impressions

metric

total_loads

int

The total number of times the segment pixel loaded.

metric

total_network_rpm

currency

The revenue per 1000 impressions.

metric

total_network_rpm_buying_currency

currency

The revenue per 1000 impressions in the currency the buyer used to purchase the inventory. Note: exchange rates are not yet available in reporting.

metric

total_network_rpm_selling_currency

currency

The revenue per 1000 impressions in the currency the seller used to sell the impression. Note: exchange rates are not yet available in reporting.

metric

total_publisher_rpm

currency

The cost per 1000 impressions.

metric

total_publisher_rpm

currency

The cost per 1000 impressions.

metric

total_publisher_rpm_selling_currency

currency

The total publisher rpm selling currency

metric

total_revenue

currency

The total revenue.

metric

total_revenue_adv_curr

currency

The total revenue in the advertiser's currency

metric

total_revenue_including_fees

currency

Total revenue after commissions.

metric

total_revenue_including_fees_adv_currency

currency

Total revenue after commissions, in the advertiser's currency.

metric

total_revenue_including_fees_pixel

currency

Total revenue for the pixel after commissions

metric

total_revenue_pixel

currency

Total revenue for the pixel.

metric

tracker_id

string

The ID of the click tracker.

dimension

trafficker_for_insertion_order

string

A custom reporting field containing the trafficker for the insertion order. See the labels field in the Insertion Order Service for more information. You may only select one reporting label per report.

dimension

trafficker_for_line_item

string

A custom reporting field containing the trafficker for the line item. See the labels field in the Line Item Service for more information. You may only select one reporting label per report.

dimension

type_for_insertion_order

string

A custom reporting field describing the type of insertion order. See the labels field in the Insertion Order Service for more information. You may only select one reporting label per report.

dimension

type_for_line_item

string

A custom reporting field describing the type of line item. See the labels field in the Line Item Service for more information. You may only select one reporting label per report.

dimension

user_group_for_campaign

string

The test/control user group for the campaign. See the "labels" field in the Campaign Service for more details.

dimension

user_id

string

The ID of the user that clicked or viewed the creative. This field has been deprecated from the API Log Level Data service (in compliance with GDPR) and that service has been deprecated. However the field is still available via Cloud Export. For details, see Changes to Log-Level Data and Console Reporting.

dimension

vast_error_rate

float

The vast error rate

metric

venue

string

The name of the cluster of domain, site, tag, and user country that Xandr' optimization system uses to determine bid valuations.

dimension

venue_id

string

The ID of the cluster of domain, site, tag, and user country that Xandr' optimization system uses to determine bid valuations.

dimension

video_analytics_media_subtype

int

The video analytics media subtype

metric

video_context

string

The type of the video creative. See Video Contextbelow for possible values.

dimension

video_default_errors

int

Errors reported from the video player when a default creative should have served.

metric

video_fill

float

The video fill

metric

video_playback_method

string

The playback method for the creative. See Playback Methodbelow for possible values.

dimension

video_player_errors

int

Errors reported from the video player after the VAST XML has been delivered.

metric

video_player_size

string

Size of the video player (small,medium,large,..)

dimension

view_measured_imps

int

The total number of impressions that were measured for viewability.

metric

view_measurement_rate

float

The percentage of impressions measured for viewability out of the total number of impressions. (View Measured Imps / Imps)

metric

view_rate

float

The percentage of impressions that were viewable out of the total number of impressions measured for viewability. (Viewed Imps / View Measured Imps)

metric

viewdef_definition_id

string

The viewdef definition id

dimension

viewdef_view_rate

float

The viewdef view rate

metric

viewdef_viewed_imps

float

The viewdef viewed impressions

metric

width

int

The width of the creative.

metric

year

date

Year

dimension