Xandr: Most-used fields

The table below gives information about most-used fields that you can import from Xandr. Other fields might also be available in Adverity.

The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.

API name	Adverity UI name	Description	Use in Adverity
Advertiser Name	Advertiser Name		dimension
Bidder	Bidder	The bidding platform (Adform, DM, Xandr Console)	dimension
RTB	RTB		dimension
ad_serving_fees	ad_serving_fees	The ad serving fees	metric
ad_serving_fees_buying_currency	ad_serving_fees_buying_currency	The ad serving fees buying currency	metric
ad_type.id	ad_type.id		metric
ad_type.name	ad_type.name		dimension
advertiser.id	advertiser.id		metric
advertiser.name	advertiser.name		dimension
advertiser_code	advertiser_code	The custom code for the advertiser.	dimension
advertiser_currency	advertiser_currency	The currency of the advertiser.	dimension
advertiser_id	advertiser_id	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	advertiser_name	The name of the advertiser.	dimension
age_bucket	age_bucket	The age bucket in which the user is contained. See Age Bucket below for more information.	dimension
age_bucket_id	age_bucket_id	The ID of the age bucket. See Age Bucket below for more information.	dimension
approx_users_count	approx_users_count		metric
approximate_consumer_count	approximate_consumer_count		metric
approximate_incremental_devices	approximate_incremental_devices		metric
ask_price	ask_price	The ask price for the deal.	metric
attributed_pc_revenue	attributed_pc_revenue	The amount of revenue from all recorded post views.	metric
attributed_pv_revenue	attributed_pv_revenue	The amount of revenue from all recorded post clicks.	metric
attributed_revenue	attributed_revenue	The amount of revenue from all recorded post views and post clicks.	metric
auction_charges_available	auction_charges_available		dimension
auction_id	auction_id	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_fees	auction_service_fees	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_buying_currency	auction_service_fees_buying_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
average_consumer_impression_frequency	average_consumer_impression_frequency		metric
average_identified_impression_frequency	average_identified_impression_frequency		dimension
average_impression_frequency	average_impression_frequency		metric
bad_debt_deductions	bad_debt_deductions		metric
bad_debt_fees	bad_debt_fees		metric
bid_rate	bid_rate	The rate of bidding on the deal.	metric
bid_requests	bid_requests	The number of bid requests.	metric
bid_sent_no_responses	bid_sent_no_responses	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	bid_type	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	bid_type_id	The bid type id	dimension
bidder	bidder	The bidding platform (Adform, DM, Xandr Console)	dimension
bidder_id	bidder_id	The ID of the bidder or DSP (demand side platform) that the buyer used to purchase this impression.	dimension
bidder_seat_id	bidder_seat_id		dimension
bids	bids	The number of completed bids.	metric
billable_buyer_imps	billable_buyer_imps		metric
billing_currency	billing_currency		dimension
billing_period.booked_impressions_budget_daily	billing_period.booked_impressions_budget_daily		dimension
billing_period.booked_impressions_budget_lifetime	billing_period.booked_impressions_budget_lifetime		dimension
billing_period.booked_revenue_budget_daily	billing_period.booked_revenue_budget_daily		dimension
billing_period.booked_revenue_budget_daily_buying_currency	billing_period.booked_revenue_budget_daily_buying_currency	the billing period booked revenue budget daily buying currency	dimension
billing_period.booked_revenue_budget_lifetime	billing_period.booked_revenue_budget_lifetime		dimension
billing_period.booked_revenue_budget_lifetime_buying_currency	billing_period.booked_revenue_budget_lifetime_buying_currency	the billing period booked revenue budget lifetime buying currency	metric
billing_period.end_date	billing_period.end_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.id	billing_period.id		metric
billing_period.start_date	billing_period.start_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	billing_period_end_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_id	billing_period_id	The billing period id	dimension
billing_period_start_date	billing_period_start_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
booked_revenue	booked_revenue	The total revenue booked through direct advertisers (line item).	metric
booked_revenue_adv_curr	booked_revenue_adv_curr	The total revenue booked through a direct advertiser, in the currency of the advertiser.	metric
booked_revenue_buying_currency	booked_revenue_buying_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_buying_currency	booked_revenue_dollars_buying_currency	Network revenue booked through direct advertisers, in the transaction currency the buyer used to buy the impression.	metric
booked_revenue_ecpa	booked_revenue_ecpa	The booked revenue ecpa	metric
booked_revenue_ecpa_buying_currency	booked_revenue_ecpa_buying_currency	The booked revenue ecpa buying currency	metric
booked_revenue_ecpc	booked_revenue_ecpc	The booked revenue ecpc	metric
booked_revenue_ecpc_buying_currency	booked_revenue_ecpc_buying_currency	The booked revenue ecpc buying currency	metric
booked_revenue_ecpm	booked_revenue_ecpm	The booked revenue ecpm	metric
booked_revenue_ecpm_buying_currency	booked_revenue_ecpm_buying_currency	The booked revenue ecpm buying currency	metric
booked_revenue_selling_currency	booked_revenue_selling_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	booked_revenue_vcpm	The booked revenue vcpm	metric
booked_revenue_vcpm_adv_curr	booked_revenue_vcpm_adv_curr		metric
brand.id	brand.id		metric
brand.name	brand.name		dimension
brand_id	brand_id	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	brand_name	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
buyer.id	buyer.id		metric
buyer.name	buyer.name		dimension
buyer_ad_serving_fees	buyer_ad_serving_fees	The buyer ad serving fees	metric
buyer_cost_ecpm	buyer_cost_ecpm	The cost of the deal to the buyer in eCPM.	metric
buyer_cost_per_video_complete	buyer_cost_per_video_complete		metric
buyer_cpc	buyer_cpc		metric
buyer_cpm	buyer_cpm		metric
buyer_media_cost	buyer_media_cost	The total cost of the inventory purchased.	metric
buyer_media_cost_buying_currency	buyer_media_cost_buying_currency	The total cost of the inventory purchased, in the transaction currency the buyer used to buy the impression.	metric
buyer_media_cost_ecpm	buyer_media_cost_ecpm	buyer_media_cost_ecpm	metric
buyer_member_id	buyer_member_id	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	buyer_member_name	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_seat_id	buyer_seat_id		dimension
buyer_type	buyer_type	The type of impression purchased by the buyer member. Possible values: “Real Time” or “Direct”.	dimension
buying_billing_trx_type_id	buying_billing_trx_type_id		dimension
buying_currency	buying_currency	The transaction currency used by the buyer to purchase this impression.	dimension
buying_imp_type	buying_imp_type	The buying imp type	dimension
buying_imp_type_id	buying_imp_type_id	The buying imp type id	dimension
campaign_code	campaign_code	The custom code for the campaign.	dimension
campaign_id	campaign_id	The ID of the campaign.	dimension
campaign_name	campaign_name	The name of the campaign.	dimension
campaign_type	campaign_type	The type of campaigns under the line item. See the labels field in the Line Item Service for more information.	dimension
carrier_id	carrier_id	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	carrier_name	The name of the carrier for the device on which the impression was served.	dimension
cleared_direct	cleared_direct	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.id	clearing_event.id		metric
clearing_event_booked_revenue_ecpm	clearing_event_booked_revenue_ecpm	The clearing event booked revenue ecpm	dimension
clearing_event_booked_revenue_ecpm_buying_currency	clearing_event_booked_revenue_ecpm_buying_currency	The clearing event booked revenue ecpm buying currency	dimension
clearing_event_booked_revenue_per_event	clearing_event_booked_revenue_per_event	The clearing event booked revenue per event	metric
clearing_event_booked_revenue_per_event_buying_currency	clearing_event_booked_revenue_per_event_buying_currency	The clearing event booked revenue per event buying currency	dimension
clearing_event_buyer_media_cost_ecpm	clearing_event_buyer_media_cost_ecpm	The clearing event buyer media cost ecpm	dimension
clearing_event_buyer_media_cost_ecpm_buying_currency	clearing_event_buyer_media_cost_ecpm_buying_currency	The clearing event buyer media cost ecpm buying currency	dimension
clearing_event_buyer_media_cost_per_event	clearing_event_buyer_media_cost_per_event	The clearing event buyer media coss per event	metric
clearing_event_buyer_media_cost_per_event_buying_currency	clearing_event_buyer_media_cost_per_event_buying_currency	The clearing event buyer media cost per event buying currency	dimension
click_conv_rate	click_conv_rate	The rate of conversions to clicks. Note: This field is identical to click_convs_rate.	metric
click_convs_rate	click_convs_rate	The rate of conversions to clicks.	metric
click_through_rate	click_through_rate		metric
click_thru_pct	click_thru_pct	The rate of clicks to impressions as a percentage.	metric
click_to_conversion_rate	click_to_conversion_rate		metric
clicks	clicks	The total number of clicks across all impressions.	metric
clicks_and_hits_count	clicks_and_hits_count		metric
clicks_bought	clicks_bought		metric
commissions	commissions	Fees that come out of the booked revenue.	metric
commissions_buying_currency	commissions_buying_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
completed_video_views_count	completed_video_views_count		metric
completes	completes		metric
connection_type	connection_type	The type of internet connection at the time of the impression. Possible values: “Carrier-based” or “Wifi or Static”.	dimension
contacts_count	contacts_count		metric
content_delivery_type_id	content_delivery_type_id		dimension
content_network_id	content_network_id		dimension
contributions_post_click_count	contributions_post_click_count		metric
contributions_post_view_count	contributions_post_view_count		metric
contributions_value	contributions_value		metric
conv_rate	conv_rate	The rate of post click and post view conversions to impressions.	metric
conversion_device_make	conversion_device_make		dimension
conversion_device_make_id	conversion_device_make_id		dimension
conversion_device_make_name	conversion_device_make_name		dimension
conversion_device_type	conversion_device_type		dimension
conversion_rate	conversion_rate	The conversion rate	metric
conversions	conversions		metric
convs_rate	convs_rate	The rate of conversions to impressions.	metric
cost	cost	The total amount of media cost for direct publisher and purchased real-time inventory.	metric
cost_buying_currency	cost_buying_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	cost_ecpa	The cost per acquisition/conversion.	metric
cost_ecpa_buying_currency	cost_ecpa_buying_currency	The cost ecpa buying currency	metric
cost_ecpc	cost_ecpc	The cost per click.	metric
cost_ecpc_advertiser_currency	cost_ecpc_advertiser_currency	The cost ecpc advertiser currency	metric
cost_ecpc_buying_currency	cost_ecpc_buying_currency	The cost ecpc buying currency	metric
cost_ecpm_advertiser_currency	cost_ecpm_advertiser_currency	The cost ecpm advertiser currency	metric
cost_per_video_complete	cost_per_video_complete	The cost per video completion.	metric
cost_selling_currency	cost_selling_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
cost_type	cost_type		dimension
cpa	cpa	The cost per acquisition.	metric
cpc	cpc	The cost per click.	metric
cpm	cpm	The cost per 1000 impressions.	metric
cpm_buying_currency	cpm_buying_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_selling_currency	cpm_selling_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
creative.id	creative.id		metric
creative.name	creative.name		dimension
creative_asset_identifier	creative_asset_identifier		dimension
creative_code	creative_code	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_deductions	creative_hosting_deductions		metric
creative_id	creative_id	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	creative_name	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	creative_overage_fees	Total fees charged for hosted creatives that exceed the creative size limit.	metric
creative_overage_fees_buying_currency	creative_overage_fees_buying_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
cross_device_incremental_imps	cross_device_incremental_imps		metric
ctr	ctr	The rate of clicks to impressions.	metric
curated_deal	curated_deal		dimension
curated_deal_advertiser_id	curated_deal_advertiser_id		dimension
curated_deal_advertiser_name	curated_deal_advertiser_name		dimension
curated_deal_id	curated_deal_id		dimension
curated_deal_insertion_order_id	curated_deal_insertion_order_id		dimension
curated_deal_insertion_order_name	curated_deal_insertion_order_name		dimension
curated_deal_line_item_id	curated_deal_line_item_id		dimension
curated_deal_line_item_name	curated_deal_line_item_name		dimension
curated_deal_name	curated_deal_name		dimension
curated_line_item_name	curated_line_item_name		dimension
curator_margin	curator_margin		dimension
curator_margin_type	curator_margin_type		dimension
curator_margin_type_filterable	curator_margin_type_filterable		metric
curator_member	curator_member		dimension
curator_member_id	curator_member_id	The curator member id	dimension
curator_net_media_cost	curator_net_media_cost		dimension
curator_revenue	curator_revenue		dimension
curator_tech_fees	curator_tech_fees		dimension
curator_total_cost	curator_total_cost		dimension
data_costs	data_costs	The total cost of 3rd party data used on the campaign.	metric
data_costs_buying_currency	data_costs_buying_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_provider_id	data_provider_id	The ID of the third-party that provided the targeting data.	dimension
data_provider_name	data_provider_name	The name and ID of the third-party that provided the targeting data.	dimension
data_type	data_type	The data type	dimension
date	date		dimension
datetime	datetime	The date and time when the conversion pixel fired.	dimension
day	day	The day of the auction.	dimension
deal_auction_type_name	deal_auction_type_name	The deal auction type name	dimension
deal_code	deal_code	The custom code for the deal. For deals with external supply partners, this is generally the string that you use to identify the deal.	metric
deal_id	deal_id	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	deal_name	The name of the deal.	dimension
deal_type	deal_type	The deal type	dimension
deal_type_id	deal_type_id	The deal type id	dimension
deal_type_name	deal_type_name	Whether the deal is a public deal or a private deal.	dimension
default_no_responses	default_no_responses	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
device_category	device_category		dimension
device_make_id	device_make_id	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	device_make_name	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	device_model_id	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_type	device_type	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	device_type_id	The device type id	dimension
ecpa	ecpa	The effective advertiser spend per conversion/acquisition.	metric
ecpa_adv_curr	ecpa_adv_curr	The cost per acquisition in the advertiser currency type.	metric
ecpc	ecpc	The effective advertiser spend per click.	metric
ecpc_adv_curr	ecpc_adv_curr	The cost per click in the advertiser currency type.	metric
ecpm	ecpm	Amount of currency spent per 1000 impressions.	metric
ecpm_adv_curr	ecpm_adv_curr	The cost per 1,000 impressions in the advertiser currency type.	metric
end_date	end_date	The day and time when the deal stops being available to the buyer.	dimension
estimated_number_of_users	estimated_number_of_users	The estimated number of users	metric
estimated_people_reach	estimated_people_reach		metric
exchange_cost	exchange_cost		metric
external_clicks	external_clicks	The number of external (non-network) clicks.	metric
external_imps	external_imps	The number of external (non-network) impressions.	metric
filtered_requests	filtered_requests	Ad requests filtered pre-bid by Xandr for inventory quality.	metric
flight.booked_impressions_budget_lifetime	flight.booked_impressions_budget_lifetime	The lifetime impression budget for the line item’s flight.	dimension
flight.booked_revenue_budget_daily_advertiser_currency	flight.booked_revenue_budget_daily_advertiser_currency	flight booked revenue budget daily advertiser currency	metric
flight.booked_revenue_budget_lifetime_advertiser_currency	flight.booked_revenue_budget_lifetime_advertiser_currency	flight booked revenue budget lifetime advertiser currency	metric
flight.end_date	flight.end_date	The end date of the line item’s flight.	dimension
flight.start_date	flight.start_date	The start date of the line item’s flight.	dimension
flight_id	flight_id	The flight id	dimension
gender	gender	The gender of the user. Note: For impressions older than 100 days, the gender will be “u”.	dimension
geo_city_id	geo_city_id	The ID of the user’s city location. For city IDs, see City Service.	dimension
geo_city_name	geo_city_name	The name of the user’s city location. For city names, see City Service.	dimension
geo_country	geo_country	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	geo_country_code	The country code of the user’s location as defined by the Country Service.	dimension
geo_country_id	geo_country_id	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	geo_country_name	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	geo_dma		dimension
geo_dma_id	geo_dma_id	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	geo_dma_name	The name of the user’s designated market area location as defined by the Designated Market Area Service.	dimension
geo_region	geo_region		dimension
geo_region_code	geo_region_code	The region code of the user’s location as defined by the Region Service.	dimension
geo_region_id	geo_region_id	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	geo_region_name	The name of the region of the user’s location as defined by the Region Service.	dimension
gross_seller_revenue	gross_seller_revenue		metric
gross_win_rate	gross_win_rate	The gross win rate for the deal.	metric
hour	hour	The hour of the auction. Note: For impressions older than 100 days, the day will be returned rather than the hour.	dimension
identified_imps	identified_imps		metric
imp_time	imp_time	The date and time of the impression (when the creative was served).	dimension
imp_type	imp_type		dimension
imp_type_id	imp_type_id	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
impressions	impressions		metric
impressions_total	impressions_total		metric
imps	imps	The total number of impressions (served and resold).	metric
imps_bought	imps_bought		metric
imps_filled	imps_filled	The number of blank, PSA, default, kept, resold, and external impressions.	dimension
imps_filtered_reason	imps_filtered_reason	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_matched	imps_matched	The total number of impressions that match the seller’s settings (not the buyer’s) on the deal.	metric
imps_resold	imps_resold	The number of impressions your publisher sold to a third party.	metric
imps_total	imps_total	The total number of impressions (served and resold).	metric
imps_viewed	imps_viewed	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	imps_won	The total number of impressions won.	metric
ineligible_bid_rate	ineligible_bid_rate	The rate of ineligible bids on the deal.	metric
insertion_order.booked_impressions_budget_daily	insertion_order.booked_impressions_budget_daily	The daily impression budget for the insertion order.	dimension
insertion_order.booked_impressions_budget_lifetime	insertion_order.booked_impressions_budget_lifetime	The lifetime impression budget for the insertion order.	dimension
insertion_order.booked_revenue_budget_daily	insertion_order.booked_revenue_budget_daily	The daily budget in revenue for the insertion order.	dimension
insertion_order.booked_revenue_budget_lifetime	insertion_order.booked_revenue_budget_lifetime	The lifetime budget in revenu for the insertion order.	dimension
insertion_order.end_date	insertion_order.end_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.id	insertion_order.id		metric
insertion_order.name	insertion_order.name		dimension
insertion_order.start_date	insertion_order.start_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	insertion_order.state	The state of the insertion order (e.g., active, inactive).	dimension
insertion_order_code	insertion_order_code	The custom code for the insertion order.	dimension
insertion_order_frequency_bucket_id	insertion_order_frequency_bucket_id	The ID of the insertion order frequency bucket. See Insertion Order Frequency Buckets below for possible values.	dimension
insertion_order_id	insertion_order_id	The ID of the insertion order.	dimension
insertion_order_name	insertion_order_name	The name of the insertion order.	dimension
inventory_source	inventory_source	The inventory source	dimension
inventory_source_id	inventory_source_id	The inventory source id	dimension
inventory_source_name	inventory_source_name	The inventory source name	dimension
inventory_url_site_domain	inventory_url_site_domain		dimension
is_curated	is_curated	Is curated	dimension
line_id	line_id		dimension
line_item.booked_impressions_budget_daily	line_item.booked_impressions_budget_daily	The daily impression budget for the line item.	dimension
line_item.booked_impressions_budget_lifetime	line_item.booked_impressions_budget_lifetime	The lifetime impression budget for the line item.	metric
line_item.booked_revenue_budget_daily_adv_curr	line_item.booked_revenue_budget_daily_adv_curr	The daily budget in revenue for the line item.	metric
line_item.booked_revenue_budget_lifetime_adv_curr	line_item.booked_revenue_budget_lifetime_adv_curr	The lifetime budget in revenue for the line item.	metric
line_item.end_date	line_item.end_date	The end date of the non-augmented line item. For augmented line Items (ALIs), see flight.end_date .	dimension
line_item.id	line_item.id		metric
line_item.name	line_item.name		dimension
line_item.start_date	line_item.start_date	The start date of the non-augmented line item. For augmented line Items (ALIs), see flight.start_date .	dimension
line_item.status	line_item.status	The state of the line item (e.g., active, inactive).	dimension
line_item.subtype	line_item.subtype		dimension
line_item.type	line_item.type	The line item type (e.g., standard, augmented).	dimension
line_item_code	line_item_code	The custom code for the line item.	dimension
line_item_id	line_item_id	The ID of the line item.	dimension
line_item_name	line_item_name	The name of the line item.	dimension
line_item_type	line_item_type	A field describing the line item, provided by the user. See Line Item Service for more information.	dimension
marginal_unique_users	marginal_unique_users	Marginal unique users	metric
marketplace_clearing_event_name	marketplace_clearing_event_name	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
media_channel	media_channel		dimension
media_channel_buying	media_channel_buying		dimension
media_channel_group	media_channel_group		dimension
media_cost	media_cost	The total cost of the inventory purchased.	metric
media_cost_advertiser_currency	media_cost_advertiser_currency	The media cost advertiser currency	metric
media_cost_buying_currency	media_cost_buying_currency	The media cost buying currency	metric
media_cost_vcpm	media_cost_vcpm	The media cost vcpm	metric
media_cost_vcpm_advertiser_currency	media_cost_vcpm_advertiser_currency	The media cost vcpm advertiser currency	metric
media_type	media_type	The specific display style of a creative. You can use the Media Subtype Service to view all possible media subtypes.	dimension
media_type_id	media_type_id	The media type id	dimension
mediatype	mediatype	The mediatype	dimension
mediatype_id	mediatype_id	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_currency	member_currency		dimension
member_id	member_id	The ID of the member.	dimension
member_name	member_name	The name of the member whose creative was audited.	dimension
metric_type	metric_type		metric
mobile_application_id	mobile_application_id	A targetable Apple App Store ID, Google Play package name, or Windows application ID.	dimension
mobile_application_name	mobile_application_name	The name of the mobile application as it appears in the Apple App and Google Play Stores.	dimension
month	month	The month of the auction.	dimension
month_date	month_date		dimension
net_win_rate	net_win_rate	The net win rate for the deal.	metric
network_profit_buying_currency	network_profit_buying_currency		metric
network_profit_ecpa	network_profit_ecpa		metric
network_profit_ecpm	network_profit_ecpm		metric
network_profit_selling_currency	network_profit_selling_currency	The network profit selling currency	metric
operating_system_family	operating_system_family	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	operating_system_family_name	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	operating_system_name	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	order_id	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	package_id	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
partner_fees	partner_fees		metric
partner_fees_buying_currency	partner_fees_buying_currency		metric
payment_type	payment_type	The type of payment to a broker. Possible values: “cpm”, “revshare”, “cpvm”.	dimension
payment_type_id	payment_type_id	The payment type id	dimension
placement.code	placement.code		dimension
placement_code	placement_code	The custom code for the placement.	dimension
placement_group_id	placement_group_id		dimension
placement_group_name	placement_group_name		dimension
placement_id	placement_id	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	placement_name	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
platform	platform		dimension
post_auction_discount	post_auction_discount		metric
post_click_conv	post_click_conv		metric
post_click_convs	post_click_convs	The total number of recorded post-click conversions.	metric
post_click_convs_rate	post_click_convs_rate	The rate of post-click conversions to impressions.	metric
post_click_or_post_view_cross_device_conv	post_click_or_post_view_cross_device_conv		dimension
post_click_or_post_view_revenue	post_click_or_post_view_revenue	The revenue optionally passed in the conversion pixel using the “value” parameter.	metric
post_click_revenue	post_click_revenue	The revenue from post-click conversions.	metric
post_view_conv	post_view_conv		metric
post_view_convs	post_view_convs	The total number of recorded post-view conversions.	metric
post_view_convs_rate	post_view_convs_rate	The rate of post-view conversions to impressions.	metric
post_view_revenue	post_view_revenue	The revenue from post-view conversions.	metric
pricing_media_type_id	pricing_media_type_id	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	pricing_media_type_name	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
priority	priority	For a private auction only, the priority the seller assigned to the deal.	metric
profit_advertiser_currency	profit_advertiser_currency	The profit advertiser currency	metric
profit_buying_currency	profit_buying_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_ecpa	profit_ecpa		metric
profit_ecpc	profit_ecpc		metric
profit_ecpm	profit_ecpm	The profit per 1000 impressions.	metric
profit_ecpm_buying_currency	profit_ecpm_buying_currency	The profit ecpm buying currency	metric
profit_margin	profit_margin	The profit as a percentage of revenue.	metric
profit_selling_currency	profit_selling_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	psas_or_blanks	The number of blanks or PSAs served.	metric
pub_default_imps_total_revenue	pub_default_imps_total_revenue	The pub default imps total revenue	metric
pub_default_imps_total_revenue_ecpm	pub_default_imps_total_revenue_ecpm	The pub default imps total revenue ecpm	metric
pub_default_imps_total_revenue_ecpm_publisher_currency	pub_default_imps_total_revenue_ecpm_publisher_currency		metric
pub_default_imps_total_revenue_publisher_currency	pub_default_imps_total_revenue_publisher_currency	The pub default imps total revenue publisher currency	metric
publisher.id	publisher.id		metric
publisher.name	publisher.name		dimension
publisher_code	publisher_code	The custom code for the publisher.	dimension
publisher_currency	publisher_currency	The currency of the publisher.	dimension
publisher_default_revenue	publisher_default_revenue	The revenue paid out to the publisher (based on revshare or CPM) for default impressions.	metric
publisher_default_revenue_publisher_currency	publisher_default_revenue_publisher_currency	The publisher default revenue publisher currency	metric
publisher_filled_revenue	publisher_filled_revenue	The revenue paid out to the publisher (based on revshare or CPM) for filled impressions.	metric
publisher_filled_revenue_publisher_currency	publisher_filled_revenue_publisher_currency	The publisher filled revenue publisher currency	metric
publisher_id	publisher_id	The ID of the publisher.	dimension
publisher_name	publisher_name	The name of the publisher.	dimension
publisher_revenue	publisher_revenue	The revenue paid out to the publisher (based on revshare or cpm).	metric
publisher_revenue_pub_curr	publisher_revenue_pub_curr	The revenue paid out to the publisher (based on revshare or cpm), in the currency of the publisher.	metric
q1_video_views_count	q1_video_views_count		metric
q2_video_views_count	q2_video_views_count		metric
q3_video_views_count	q3_video_views_count		metric
region_id	region_id		dimension
reject_bidder_error_count	reject_bidder_error_count	The number of bids rejected due to bidder errors.	metric
reject_count	reject_count	The total number of rejected bids.	metric
revenue	revenue	The sum of booked revenue and reseller revenue.	metric
revenue_buying_currency	revenue_buying_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	revenue_ecpa	The total revenue per conversion.	metric
revenue_ecpa_buying_currency	revenue_ecpa_buying_currency	The revenue ecpa buying currency	metric
revenue_ecpc	revenue_ecpc	The total revenue per click.	metric
revenue_ecpc_buying_currency	revenue_ecpc_buying_currency	The revenue ecpc buying currency	metric
revenue_ecpm	revenue_ecpm	The total revenue per 1000 impressions.	metric
revenue_ecpm_buying_currency	revenue_ecpm_buying_currency	The revenue ecpm buying currency	metric
revenue_per_video_complete	revenue_per_video_complete	The revenue per video completion.	metric
revenue_selling_currency	revenue_selling_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	revenue_type	The basis on which the member gets paid.	dimension
rpm_buying_currency	rpm_buying_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_selling_currency	rpm_selling_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	sales_tax	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
second_level_category_id	second_level_category_id	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	second_level_category_name	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	segment_code	The (optional) custom code associated with the user segment present for this impression.	dimension
segment_id	segment_id	The ID of the segment pixel.	dimension
segment_name	segment_name	The name of the segment.	dimension
seller_deal	seller_deal		dimension
seller_deal_id	seller_deal_id		dimension
seller_deal_name	seller_deal_name		dimension
seller_deal_type_id	seller_deal_type_id		dimension
seller_deal_type_name	seller_deal_type_name		dimension
seller_member_id	seller_member_id	The ID of the selling member.	dimension
seller_member_name	seller_member_name	The name of the selling member.	dimension
seller_revenue	seller_revenue	Revenue earned by the Seller.	dimension
seller_type	seller_type	The type of impression sold by the seller member. Possible values: “Real Time” or “Direct”.	dimension
service_fees	service_fees	The service fees	metric
service_fees_buying_currency	service_fees_buying_currency	The service fees buying currency	metric
serving_fees	serving_fees	Fees that are added to the media cost.	metric
serving_fees_buying_currency	serving_fees_buying_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	serving_fees_selling_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_domain	site_domain	The site domain of an impression.	dimension
site_id	site_id	The ID of the site. Note: For impressions older than 14 months, the site_id will be 0.	dimension
site_name	site_name	The name of the site.	dimension
split_id	split_id		dimension
split_name	split_name		dimension
start_date	start_date	The day and time when the deal starts being available to the buyer.	dimension
submitted_bids	submitted_bids	The number of submitted bids.	metric
supply_strategy	supply_strategy		dimension
supply_type	supply_type	The type of inventory. Possible values: “web”, “mobile_web”, or “mobile_app”, or “facebook_sidebar”.	dimension
supply_type_name	supply_type_name		dimension
targeted_curator_media_cost	targeted_curator_media_cost		metric
targeted_curator_media_cost_ecpm	targeted_curator_media_cost_ecpm		metric
targeted_curator_revenue	targeted_curator_revenue		metric
targeted_curator_revenue_ecpm	targeted_curator_revenue_ecpm		metric
targeted_impressions	targeted_impressions		metric
targeted_segment_ids	targeted_segment_ids	The comma-separated list of IDs for each of the segments used when targeting.	dimension
targeted_view_measured_impressions	targeted_view_measured_impressions		metric
targeted_viewable_impressions	targeted_viewable_impressions		metric
targeting_type	targeting_type		dimension
top_level_category_id	top_level_category_id	The ID of the top content category assigned to the domain.	dimension
top_level_category_name	top_level_category_name	The name of the top content category assigned to the domain.	dimension
total_ad_requests	total_ad_requests	The total number of ad requests sent to Xandr for auction.	metric
total_ad_responses	total_ad_responses	The total number of ad responses counted within AppNex	metric
total_convs	total_convs	The total number of post-view and post-click conversions.	dimension
total_cost	total_cost		metric
total_cost_buying_currency	total_cost_buying_currency		metric
total_cost_ecpa	total_cost_ecpa		metric
total_cost_ecpc	total_cost_ecpc		metric
total_cost_ecpm	total_cost_ecpm		metric
total_cost_selling_currency	total_cost_selling_currency		metric
total_feature_costs	total_feature_costs		metric
total_network_rpm_buying_currency	total_network_rpm_buying_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	total_network_rpm_selling_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_revenue	total_revenue	The total revenue.	dimension
total_segment_data_costs	total_segment_data_costs		metric
total_segment_data_costs_buying_currency	total_segment_data_costs_buying_currency		metric
trading_costs	trading_costs		metric
trafficType	trafficType		dimension
unidentified_imps	unidentified_imps		metric
unique_users	unique_users		metric
uniques	uniques		metric
universal_pixel	universal_pixel		dimension
user_id	user_id	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_100_error_count	vast_100_error_count		metric
vast_101_error_count	vast_101_error_count		metric
vast_102_error_count	vast_102_error_count		metric
vast_200_error_count	vast_200_error_count		metric
vast_201_error_count	vast_201_error_count		metric
vast_202_error_count	vast_202_error_count		metric
vast_203_error_count	vast_203_error_count		metric
vast_300_error_count	vast_300_error_count		metric
vast_301_error_count	vast_301_error_count		metric
vast_302_error_count	vast_302_error_count		metric
vast_303_error_count	vast_303_error_count		metric
vast_400_error_count	vast_400_error_count		metric
vast_401_error_count	vast_401_error_count		metric
vast_402_error_count	vast_402_error_count		metric
vast_403_error_count	vast_403_error_count		metric
vast_405_error_count	vast_405_error_count		metric
vast_500_error_count	vast_500_error_count		metric
vast_501_error_count	vast_501_error_count		metric
vast_502_error_count	vast_502_error_count		metric
vast_503_error_count	vast_503_error_count		metric
vast_600_error_count	vast_600_error_count		metric
vast_601_error_count	vast_601_error_count		metric
vast_602_error_count	vast_602_error_count		metric
vast_603_error_count	vast_603_error_count		metric
vast_604_error_count	vast_604_error_count		metric
vast_900_error_count	vast_900_error_count		metric
vast_901_error_count	vast_901_error_count		metric
vendor	vendor		dimension
vendor_costs	vendor_costs		metric
vendor_costs_buying_currency	vendor_costs_buying_currency		metric
vendor_id	vendor_id		dimension
vendor_name	vendor_name		dimension
vendor_type	vendor_type		dimension
venue	venue	The name of the cluster of domain, site, tag, and user country that Xandr’ optimization system uses to determine bid valuations.	dimension
video_25_pcts	video_25_pcts		metric
video_50_pcts	video_50_pcts		metric
video_75_pcts	video_75_pcts		metric
video_completion_rate	video_completion_rate		metric
video_completions	video_completions		metric
video_content_genre	video_content_genre		dimension
video_content_network	video_content_network		dimension
video_default_errors	video_default_errors	Errors reported from the video player when a default creative should have served.	metric
video_delivery_type	video_delivery_type		dimension
video_errors	video_errors		metric
video_player_errors	video_player_errors	Errors reported from the video player after the VAST XML has been delivered.	metric
video_served	video_served		metric
video_skip_rate	video_skip_rate		metric
video_skips	video_skips		metric
video_start_rate	video_start_rate		metric
video_starts	video_starts		metric
video_starts_count	video_starts_count		metric
view_measured_imps	view_measured_imps	The total number of impressions that were measured for viewability.	metric
view_measurement_rate	view_measurement_rate	The percentage of impressions measured for viewability out of the total number of impressions. (View Measured Imps / Imps)	metric
view_rate	view_rate	The percentage of impressions that were viewable out of the total number of impressions measured for viewability. (Viewed Imps / View Measured Imps)	metric
viewed_imps	viewed_imps		metric