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
ad_serving_fees_buying_currency	ad_serving_fees_buying_currency	Total ad serving fees, expressed in the currency used by the buyer for the impression.	metric
advertiser_code	advertiser_code	The custom code assigned to the advertiser.	dimension
advertiser_currency	advertiser_currency	The currency used by the advertiser.	dimension
advertiser_id	advertiser_id	The unique identification number for each 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 bucket for the age of the user.	dimension
age_bucket_id	age_bucket_id	The ID of the age bucket.	dimension
attributed_pc_revenue	attributed_pc_revenue	Revenue attributed to conversions that occurred after a user interacted with an advertisement, commonly referred to as post-click revenue. This metric is available in reports related to advertiser attributed conversions.	metric
attributed_pv_revenue	attributed_pv_revenue	Revenue attributed to conversions that occurred after a user viewed an advertisement, commonly referred to as post-view revenue. This metric is available in reports related to advertiser attributed conversions.	metric
attributed_revenue	attributed_revenue	The total amount of post-view and post-click attributed revenue.	metric
auction_service_fees_buying_currency	auction_service_fees_buying_currency	Total fees charged for impressions purchased from third parties, expressed in the currency used by the buyer for the transaction.	metric
bid_type	bid_type	The optimization phase of the bid for an impression.	dimension
billing_period.end_date	billing_period.end_date	The last date of the insertion order’s billing period.	dimension
billing_period.start_date	billing_period.start_date	The earliest date of the insertion order’s billing period.	dimension
billing_period_end_date	billing_period_end_date	The last date of the insertion order’s billing period.	dimension
billing_period_start_date	billing_period_start_date	The earliest date of the insertion order’s billing period.	dimension
booked_revenue	booked_revenue	The net revenue applied on the Line Item that won the impression.	metric
booked_revenue_adv_curr	booked_revenue_adv_curr	The total revenue booked through a direct advertiser, expressed in the currency of that advertiser.	metric
booked_revenue_buying_currency	booked_revenue_buying_currency	The revenue booked by the buyer to purchase this impression, in the buying currency.	metric
buyer_media_cost_buying_currency	buyer_media_cost_buying_currency	The media cost for the buyer in the buyer’s preferred currency.	metric
buyer_member_id	buyer_member_id	The ID of the buying member.	dimension
buyer_member_name	buyer_member_name	The name of the member (organization or entity) on the buy-side that purchased the ad impressions.	dimension
buyer_type	buyer_type	A classification or category assigned to the buyer, indicating the nature or type of the buying entity in the advertising ecosystem.	dimension
buying_currency	buying_currency	The transaction currency used by the buyer to purchase the impression.	dimension
campaign_code	campaign_code	The custom code assigned to the campaign.	dimension
campaign_id	campaign_id	The unique identification number of the campaign.	dimension
campaign_name	campaign_name	The name of the campaign.	dimension
click_conv_rate	click_conv_rate	The rate of conversions to clicks.	metric
click_convs_rate	click_convs_rate	The rate of conversions to clicks.	metric
click_thru_pct	click_thru_pct	The rate of clicks to impressions, expressed as a percentage.	metric
clicks	clicks	The total number of clicks across all impressions. Clicks are deduplicated by auction (maximum 1 click per unique auction) and have a 6-hour TTL.	metric
completion_rate	completion_rate	The percentage of ad impressions or views that are completed from start to finish. This metric is commonly used to evaluate the effectiveness and engagement level of video advertising campaigns.	metric
conv_rate	conv_rate	The ratio of conversions to impressions.	metric
convs_rate	convs_rate	The rate of conversions to impressions.	metric
cost	cost	The total cost to purchase third-party inventory via a Line Item.	metric
cost_buying_currency	cost_buying_currency	The total media cost for direct publisher and purchased real-time inventory in the currency the buyer used to purchase the inventory.	metric
cost_ecpa	cost_ecpa	The effective cost per acquisition.	metric
cost_ecpa_buying_currency	cost_ecpa_buying_currency	The effective cost per acquisition in the buyer’s currency.	metric
cost_ecpc	cost_ecpc	The effective cost per click.	metric
cost_ecpc_buying_currency	cost_ecpc_buying_currency	The effective cost per click in the buyer’s currency.	metric
cost_ecpm	cost_ecpm	The total cost per one thousand impressions (eCPM).	metric
cost_ecpm_buying_currency	cost_ecpm_buying_currency	The effective cost per thousand impressions (eCPM) incurred by the buyer, expressed in the currency used by the buyer for the impression.	metric
cost_per_video_complete	cost_per_video_complete	The cost per video completion.	metric
cpa	cpa	The advertiser spend per conversion/acquisition. Calculated as Media cost / Conversions.	metric
cpc	cpc	Cost per click. Calculated as Cost / Clicks.	metric
cpm	cpm	Cost per 1000 impressions. Calculated as Cost / Impressions * 1000.	metric
cpm_buying_currency	cpm_buying_currency	The cost per 1000 impressions (CPM) in the buyer’s currency.	metric
creative_id	creative_id	The unique identifier for the creative.	dimension
creative_name	creative_name	The display name of the creative.	dimension
ctr	ctr	Click-through rate. Calculated as Clicks / Impressions.	metric
data_costs_buying_currency	data_costs_buying_currency	Costs related to usage of data, in the buying currency. This is applicable when specific segments are applied in line items and associated pricing is displayed in the platform.	metric
day	day	The day of the auction.	dimension
deal_code	deal_code	A custom code or internal ID used to identify a deal.	dimension
deal_id	deal_id	The ID of the deal.	dimension
deal_name	deal_name	The name of the deal.	dimension
device_category	device_category	The general classification of the device on which the ad impression was served, such as ‘desktop,’ ‘mobile,’ or ‘tablet.’	dimension
device_type	device_type	The specific model or type of device (e.g., smartphone model, tablet model) on which the ad impression was delivered.	dimension
ecpa	ecpa	The effective cost per acquisition (conversion).	metric
ecpa_adv_curr	ecpa_adv_curr	The effective cost per acquisition (eCPA) in the advertiser’s currency.	metric
ecpc	ecpc	The effective cost per click.	metric
ecpc_adv_curr	ecpc_adv_curr	The effective cost per click (eCPC) in the advertiser’s currency.	metric
ecpm	ecpm	The effective cost per thousand impressions (eCPM).	metric
ecpm_adv_curr	ecpm_adv_curr	The effective cost per thousand impressions (eCPM) in the advertiser’s currency.	metric
external_clicks	external_clicks	Clicks recorded by an external click tracker.	metric
external_imps	external_imps	Impressions recorded by an external impression tracker.	metric
gender	gender	The gender of the user.	dimension
geo_city_id	geo_city_id	The ID of the user’s city location.	dimension
geo_city_name	geo_city_name	The name of the user’s city location.	dimension
geo_country	geo_country	The geographic country/region code in which the impression took place.	dimension
geo_country_code	geo_country_code	The country code of the user’s location.	dimension
geo_country_id	geo_country_id	The country ID of the user’s location. 250 is shown when the country is unknown or doesn’t map correctly.	dimension
geo_country_name	geo_country_name	The name of the geographic country/region.	dimension
geo_dma	geo_dma	The Designated Market Area (DMA) associated with the impression’s user, based on IP geolocation.	dimension
geo_dma_id	geo_dma_id	The ID of the user’s Designated Market Area (DMA) location.	dimension
geo_dma_name	geo_dma_name	The name of the user’s Designated Market Area (DMA) location.	dimension
geo_postal_code	geo_postal_code	The postal code of the user’s geographical location.	dimension
geo_region	geo_region	The region of the user’s location.	dimension
geo_region_code	geo_region_code	The region code of the user’s location.	dimension
geo_region_id	geo_region_id	The region ID of the user’s location. 4291 is shown when the region is unknown or doesn’t map correctly.	dimension
geo_region_name	geo_region_name	The name of the region of the user’s location.	dimension
hour	hour	The hour of the auction. For impressions older than 100 days, the day will be returned instead of the hour.	dimension
imp_type	imp_type	The type of impression (e.g., Blank, PSA, Default Error, Kept, Resold, RTB).	dimension
imp_type_id	imp_type_id	The ID for the type of impression.	dimension
imps	imps	The total number of impressions recorded (served and resold).	metric
imps_viewed	imps_viewed	The number of measured impressions that were viewable according to the IAB Viewability definition.	metric
insertion_order_code	insertion_order_code	The custom code associated with the insertion order.	dimension
insertion_order_id	insertion_order_id	The unique identification number of the insertion order.	dimension
insertion_order_name	insertion_order_name	The name of the insertion order.	dimension
inventory_source	inventory_source	The source or type of inventory where ads are displayed (e.g., web, mobile web, mobile app).	dimension
inventory_source_id	inventory_source_id	The ID of the external inventory source defined by the publisher.	dimension
inventory_source_name	inventory_source_name	The name of the external inventory source defined by the publisher.	dimension
line_item_code	line_item_code	The custom code for the line item.	dimension
line_item_id	line_item_id	The unique identification number of the line item.	dimension
line_item_name	line_item_name	The name of the line item.	dimension
media_channel	media_channel	The specific medium or vehicle through which an advertising message is delivered to the target audience (e.g., display, video, mobile app).	dimension
media_channel_buying	media_channel_buying		dimension
media_channel_group	media_channel_group		dimension
media_cost	media_cost	The media cost for the buyer.	metric
media_cost_advertiser_currency	media_cost_advertiser_currency	The media cost for the buyer in the advertiser’s preferred currency.	metric
media_type	media_type	The general display style of the creative (e.g., Banner, Pop, Interstitial, Video, Text).	dimension
media_type_id	media_type_id	The ID of the media type.	dimension
mediatype	mediatype	The general display style of the creative.	dimension
mediatype_id	mediatype_id	The ID of the media type to which the subtype belongs.	dimension
member_id	member_id	The unique identification number of the member.	dimension
month	month	The month of the auction.	dimension
placement_code	placement_code	The custom code for the placement.	dimension
placement_id	placement_id	The unique identifier for the placement where the ad was served.	dimension
placement_name	placement_name	The name of the placement where the ad was served.	dimension
platform	platform	The operating system or environment (e.g., iOS, Android, Windows, Web) on which the ad was displayed.	dimension
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 relative to impressions.	metric
post_click_revenue	post_click_revenue	The total revenue generated from post-click conversions.	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 relative to impressions.	metric
post_view_revenue	post_view_revenue	The total revenue generated from post-view conversions.	metric
profit_buying_currency	profit_buying_currency	The buyer’s profit, expressed in the buying currency.	metric
profit_ecpa	profit_ecpa	The effective profit per acquisition.	metric
profit_ecpc	profit_ecpc	The effective profit per click.	metric
profit_ecpm	profit_ecpm	The profit per 1000 impressions (eCPM), calculated as booked revenue minus total cost per 1000 impressions.	metric
profit_ecpm_buying_currency	profit_ecpm_buying_currency	The effective profit per 1000 impressions in the buying currency.	metric
profit_margin	profit_margin	The buyer’s profit margin, calculated as (booked revenue - total cost) / booked revenue.	metric
publisher_code	publisher_code	The custom code to identify the publisher.	dimension
publisher_id	publisher_id	The unique identification number of the publisher.	dimension
publisher_name	publisher_name	The name of the publisher.	dimension
revenue	revenue	The total net revenue.	metric
revenue_buying_currency	revenue_buying_currency	Revenue generated, expressed in the buying currency.	metric
revenue_ecpa	revenue_ecpa	The effective revenue per acquisition.	metric
revenue_ecpa_buying_currency	revenue_ecpa_buying_currency	The effective revenue per acquisition in the buying currency.	metric
revenue_ecpc	revenue_ecpc	The effective revenue per click.	metric
revenue_ecpc_buying_currency	revenue_ecpc_buying_currency	The effective revenue per click in the buying currency.	metric
revenue_ecpm	revenue_ecpm	The effective revenue per 1000 impressions (eCPM).	metric
revenue_ecpm_buying_currency	revenue_ecpm_buying_currency	The effective revenue per 1000 impressions in the buying currency.	metric
revenue_per_video_complete	revenue_per_video_complete	The revenue per video completion.	metric
rpm	rpm	Revenue per mille (RPM), representing the revenue earned per 1,000 impressions or ad requests.	metric
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_type	seller_type	The type of selling relationship between the member and Xandr (e.g., “platform”, “partner”).	dimension
service_fees_buying_currency	service_fees_buying_currency	DSP Service fee charged to buying members, expressed in the currency used by the buyer.	metric
site_name	site_name	The name of the site.	dimension
split_id	split_id	The ID of the split that purchased the impressions in this data set. Splits are only applicable to augmented line items.	dimension
split_name	split_name	The name of the split that purchased the impressions in this data set. Splits are only applicable to augmented line items.	dimension
supply_type	supply_type	The type of inventory (e.g., web, mobile_web, mobile_app).	dimension
total_convs	total_convs	The total number of post-view and post-click conversions.	metric
total_cost	total_cost	The total amount of costs accrued over the reported period of time. This generally includes budgeted costs (media cost, data cost, partner fees, serving fees, commissions) and publisher revenue if tracking publisher payouts.	metric
total_cost_buying_currency	total_cost_buying_currency	The total sum of media costs, data costs, and partner fees in the buying (advertiser) currency.	metric
total_cost_ecpa	total_cost_ecpa	The total effective cost per acquisition.	metric
total_cost_ecpc	total_cost_ecpc	The total effective cost per click.	metric
total_cost_ecpm	total_cost_ecpm	The total effective cost per 1000 impressions (eCPM).	metric
total_revenue	total_revenue	The total net revenue.	metric
venue	venue	A grouping mechanism used by Xandr’s optimization system to categorize inventory at various levels of granularity (e.g., Member, Publisher, Tag, URL, Geo) to determine bid valuations.	dimension
video_25_pcts	video_25_pcts	The total number of times the video creatives completed 25% of the entire duration.	metric
video_50_pcts	video_50_pcts	The total number of times the video creatives completed 50% of the entire duration.	metric
video_75_pcts	video_75_pcts	The total number of times the video creatives completed 75% of the entire duration.	metric
video_completion_rate	video_completion_rate	The ratio of video completions to impressions, expressed as a percentage.	metric
video_completions	video_completions	The total number of times the video creatives played for the entire duration.	metric
video_errors	video_errors	The total number of times a video error occurred.	metric
video_served	video_served	The total number of video responses served to the player. An ad response occurs when the VAST document (XML) is served in response to a request.	metric
video_skip_rate	video_skip_rate	The percentage of times the user opted to skip the video.	metric
video_skips	video_skips	The total number of times a user skipped the video.	metric
video_start_rate	video_start_rate	The percentage of times the first segment of the video creative was downloaded and started.	metric
video_starts	video_starts	The total number of times the first segment of the video creative was downloaded and started.	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. Calculated as (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. Calculated as (Viewed Imps / View Measured Imps).	metric