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.
ad_serving_fees Metric
Fees charged for the technical delivery and serving of advertisements.
ad_serving_fees_buying_currency Metric
Fees charged for ad serving, expressed in the buyer's local currency.
advertiser_code Dimension
The custom code assigned to the advertiser.
advertiser_currency Dimension
The currency used by the advertiser.
advertiser_id Dimension
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.
advertiser_name Dimension
The name of the advertiser.
approx_users_count Metric
The estimated number of unique individuals or devices that have been exposed to advertisements.
approximate_consumer_count Metric
The approximate number of unique consumers who viewed an impression due to cross-device audience extension.
approximate_incremental_devices Metric
The total number of unique cookies, mobile devices, or other device types reached by the impressions.
ask_price Metric
The minimum price that a seller will accept for a given impression or deal.
auction_service_fees Metric
Total fees charged for impressions bought from third parties, in addition to the buyer's media cost. This field matches 'Buyer Auction Service Charge' if the contract includes a BASC rate greater than 0%.
auction_service_fees_buying_currency Metric
Auction service fees denominated in the buyer's transaction currency.
bid_rate Metric
The percentage of auctions in which a buyer submitted a bid, representing their participation rate in a deal.
bid_requests Metric
The total number of requests sent to potential buyers (bidders) for an impression opportunity.
bid_sent_no_responses Metric
The count of bid responses returned by Xandr where the creative ultimately did not render, often due to an external system selecting a different bid, a user leaving the page, lazy loading, or a video not playing.
bid_type Dimension
The type of bid or optimization phase the system was in when bidding for an impression.
bid_type_id Dimension
Unique identifier for the type of bid used in the auction (e.g., optimized, learn).
bidder_id Dimension
A unique identifier for a bidder participating in the ad exchange.
bids Metric
The total number of bids submitted by buyers in response to bid requests for impression opportunities.
billable_buyer_imps Metric
The number of impressions for which the buyer is financially responsible.
billing_currency Dimension
The currency used for invoicing and financial reconciliation on the Xandr platform.
billing_exchange_rate Metric
The currency exchange rate used for billing and reconciliation purposes on the Xandr platform. These rates are sourced daily from Refinitiv and applied consistently across the platform for converting transactions between different currencies.
billing_period_id Dimension
The unique identifier for a specific billing period.
booked_revenue Metric
The net revenue applied on the Line Item that won the impression.
booked_revenue_adv_curr Metric
The total revenue booked through a direct advertiser, expressed in the currency of that advertiser.
booked_revenue_buying_currency Metric
The revenue booked by the buyer to purchase this impression, in the buying currency.
brand_id Dimension
The unique identifier for a specific brand. This is used in reports like 'Seller Brand Review Report' and 'Publisher Brand Review Report'.
brand_name Dimension
The name of the brand. This is used in reports like 'Seller Brand Review Report' and 'Publisher Brand Review Report'.
buyer_ad_serving_fees Metric
Fees incurred by the buyer for ad serving services.
buyer_cost_ecpm Metric
The effective cost per mille (eCPM) from the buyer's perspective.
buyer_cpm Metric
The cost per thousand impressions incurred by the buyer.
buyer_media_cost Metric
The total media cost incurred by the buyer.
buyer_media_cost_buying_currency Metric
The total cost of the inventory purchased by the buyer, expressed in the buyer's transaction currency.
buyer_member_id Dimension
The ID of the buying member.
buyer_member_name Dimension
The display name of the buyer member.
buyer_seat_id Dimension
The unique identifier for a buyer's seat, often corresponding to an advertiser ID from their Demand-Side Platform (DSP), used when bidding on impressions.
buying_billing_trx_type_id Dimension
The identifier for the type of transaction or impression within the buying billing report.
buying_currency Dimension
The transaction currency used by the buyer to purchase the impression.
buying_imp_type Dimension
The classification or type of impression from a buying perspective (e.g., Blank, PSA, Default, Kept, Resold, RTB).
buying_imp_type_id Dimension
The unique identifier for the type of impression from a buying perspective.
call_type Dimension
This field indicates the type of ad request or bid call, such as OpenRTB2 or Prebid, which influences how impressions are recorded and processed.
campaign_code Dimension
The custom code assigned to the campaign.
campaign_id Dimension
The unique identification number of the campaign.
campaign_name Dimension
The name of the campaign.
click_thru_pct Metric
The rate of clicks to impressions, expressed as a percentage.
clicks Metric
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.
commissions_buying_currency Metric
Commissions incurred, expressed in the currency used by the buyer for the transaction.
completion_rate Metric
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.
convs_rate Metric
The rate of conversions to impressions.
cost Metric
The total cost to purchase third-party inventory via a Line Item.
cost_buying_currency Metric
The total media cost for direct publisher and purchased real-time inventory in the currency the buyer used to purchase the inventory.
cost_ecpa Metric
The effective cost per acquisition.
cost_ecpa_buying_currency Metric
The effective cost per acquisition in the buyer's currency.
cost_ecpc Metric
The effective cost per click.
cost_ecpc_buying_currency Metric
The effective cost per click in the buyer's currency.
cost_per_video_complete Metric
The cost per video completion.
cost_type Dimension
Defines the method by which advertising costs are calculated, such as Cost Per Acquisition (CPA), Cost Per Click (CPC), or Cost Per Mille (CPM - cost per 1000 impressions).
cpm Metric
Cost per 1000 impressions. Calculated as Cost / Impressions * 1000.
cpm_buying_currency Metric
The cost per 1000 impressions (CPM) in the buyer's currency.
creative_code Dimension
A custom code assigned to the creative for identification.
creative_hosting_fees Metric
Total fees charged for hosted creatives that exceed the creative size limit.
creative_id Dimension
The unique identifier for the creative.
creative_name Dimension
The display name of the creative.
creative_overage_fees Metric
Fees charged when creative usage exceeds specified limits, such as creative size.
creative_overage_fees_buying_currency Metric
Total fees charged for hosted creatives that exceed the creative size limit, expressed in the currency the buyer used to purchase the impression.
cross_device_incremental_imps Metric
The number of impressions delivered on devices outside of the targeted segments, attributed to cross-device audience extension through a cross-device graph.
curated_advertiser Dimension
An advertiser who participates in or benefits from curated deals on the Xandr platform. Curated deals represent a negotiated agreement between a buyer and a curator, combining proprietary assets with Xandr Marketplace supply for enhanced campaign performance.
curated_deal Dimension
Curated deals represent a negotiated agreement between a buyer and a curator, combining proprietary assets like audience data or preferred inventory access with Xandr Marketplace supply to create unique offerings.
curated_deal_advertiser Dimension
The advertiser associated with a specific curated deal on the Xandr platform. Curated deals integrate a curator's proprietary assets with Xandr Marketplace supply to deliver specialized advertising solutions for the involved advertiser.
curated_deal_advertiser_id Metric
The unique identifier of the advertiser associated with a curated deal.
curated_deal_advertiser_name Dimension
The name of the advertiser associated with a curated deal.
curated_deal_id Dimension
This field represents the unique identifier assigned to a specific curated deal, used for targeting and reporting purposes within the Xandr platform.
curated_deal_insertion_order_id Metric
The unique identifier of the insertion order within a curated deal.
curated_deal_insertion_order_name Dimension
The name of the insertion order within a curated deal.
curated_deal_line_item_id Metric
The unique identifier of the line item within a curated deal.
curated_deal_line_item_name Dimension
The name of the line item within a curated deal.
curated_deal_name Dimension
The name of a deal that has been curated within the Xandr marketplace.
curator_margin Metric
The profit margin retained by the curator in a curated marketplace.
curator_member_id Dimension
The internal ID of the member who is curating deals or marketplaces.
curator_net_media_cost Metric
The net cost of media after any curator-specific adjustments within a curated deal.
curator_net_media_cost_EUR Metric
The total cost in Euros that a curator pays to exchange sellers, after deducting any curator fees and margins.
curator_revenue Metric
The revenue generated by the curator through their curated deals.
curator_total_cost Metric
The total cost incurred by the curator for their activities and deals.
data_costs Metric
This field represents the aggregated monetary value of costs associated with using third-party data segments and services in ad campaigns. These costs are incurred when third-party data is used to target users and win an impression.
data_costs_buying_currency Metric
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.
data_provider_id Dimension
This field represents the unique identifier for a third-party data provider whose data segments are utilized in advertising campaigns.
data_provider_name Dimension
This field provides the display name of the third-party data provider whose data segments are used in advertising campaigns.
data_type Dimension
This field indicates the category or classification of the data being used, with common types including 'Segment' for user segments and 'Cross Device' for cross-device targeting.
day Dimension
The day of the auction.
deal_auction_type_name Dimension
The name of the auction type for a specific deal, such as 'First Price' or 'Second Price'. This is relevant for 'Buyer Deal Metrics' and 'Seller Deal Metrics' reports.
deal_id Dimension
The ID of the deal.
deal_name Dimension
The name of the deal.
deal_type Dimension
The classification of the deal, such as Open Auction, Private Auction, Curated, First Look, or Programmatic Guaranteed.
deal_type_id Metric
Unique identifier for the type of deal under which inventory was transacted.
deal_type_name Dimension
The name of the deal type, such as 'Programmatic Guaranteed' or 'Private Auction'. This is relevant for 'Buyer Deal Metrics' and 'Seller Deal Metrics' reports.
default_no_responses Metric
Ad requests where a default creative was sent but no response was received from the end ad server.
device_type Dimension
The type of device on which an ad impression was served, such as "pc & other devices", "phone", or "tablet".
end_date Dimension
The non-inclusive end date for the report data. For hourly data, format is 'YYYY-MM-DD HH:MM:SS'; for daily, monthly, or yearly data, format is 'YYYY-MM-DD'.
estimated_people_reach Metric
The estimated number of people reached, deduplicated across user-specified dimensions. This metric is currently available in the US only.
exchange Dimension
Refers to the ad exchange platform where inventory is bought and sold.
exchange_cost Metric
The cost associated with transactions on the ad exchange.
external_clicks Metric
Clicks recorded by an external click tracker.
external_imps Metric
Impressions recorded by an external impression tracker.
filtered_requests Metric
Ad requests filtered pre-bid by Xandr for inventory quality.
geo_city_id Dimension
The ID of the user's city location.
geo_city_name Dimension
The name of the user's city location.
geo_country Dimension
The geographic country/region code in which the impression took place.
geo_country_code Dimension
The country code of the user's location.
geo_country_id Dimension
The country ID of the user's location. 250 is shown when the country is unknown or doesn't map correctly.
geo_country_name Dimension
The name of the geographic country/region.
geo_dma Dimension
The Designated Market Area (DMA) associated with the impression's user, based on IP geolocation.
geo_dma_id Dimension
The ID of the user's Designated Market Area (DMA) location.
geo_dma_name Dimension
The name of the user's Designated Market Area (DMA) location.
geo_postal_code Dimension
The postal code of the user's geographical location.
geo_region Dimension
The region of the user's location.
geo_region_code Dimension
The region code of the user's location.
geo_region_id Dimension
The region ID of the user's location. 4291 is shown when the region is unknown or doesn't map correctly.
geo_region_name Dimension
The name of the region of the user's location.
gross_win_rate Metric
The ratio of impressions won to the total number of impressions that matched targeting settings, expressed as a percentage.
hour Dimension
The hour of the auction. For impressions older than 100 days, the day will be returned instead of the hour.
imp_type Dimension
The type of impression (e.g., Blank, PSA, Default Error, Kept, Resold, RTB).
imp_type_id Dimension
The unique identifier for the type of impression, classifying how the impression was served (e.g., Blank, PSA, Default, Kept, Resold, RTB, External Impression, External Click).
imps Metric
The total number of impressions recorded (served and resold).
imps_matched Metric
The total count of available impressions that successfully matched the deal's targeting settings and buyer's acceptance status.
imps_resold Metric
The number of impressions that were resold through direct publishers.
imps_viewed Metric
The number of measured impressions that were viewable according to the IAB Viewability definition.
imps_won Metric
The total number of impressions for which a bid successfully won the auction.
ineligible_bid_rate Metric
The percentage of bids that were rejected or deemed ineligible for a deal, calculated as the count of rejected bids divided by the total bids.
insertion_order_code Dimension
The custom code associated with the insertion order.
insertion_order_id Dimension
The unique identification number of the insertion order.
insertion_order_name Dimension
The name of the insertion order.
inventory_source Dimension
The origin or platform providing the ad inventory.
inventory_source_id Dimension
Unique identifier for the source of the ad inventory.
inventory_source_name Dimension
Name of the inventory source where the ad was served.
line_item_code Dimension
The custom code for the line item.
line_item_id Dimension
The unique identification number of the line item.
line_item_name Dimension
The name of the line item.
media_cost Metric
The total cost incurred for the advertising media or inventory.
media_cost_advertiser_currency Metric
The media cost for the buyer in the advertiser's preferred currency.
media_cost_buying_currency Metric
This field represents the currency used by the buyer (advertiser) for media costs within the Xandr platform.
media_type Dimension
The general display style of the creative (e.g., Banner, Pop, Interstitial, Video, Text).
media_type_id Metric
The unique identifier for the media type, which defines the general display style of the creative (e.g., banner, video).
mediatype Dimension
The general display style of the creative.
mediatype_id Dimension
The ID of the media type to which the subtype belongs.
member_currency Dimension
The default currency associated with a member account on the Xandr platform.
member_id Metric
The unique identification number of the member.
metric_type Metric
The classification of a metric used to measure the performance of campaigns or deals.
mobile_application_id Dimension
The unique identifier for a mobile application to which an ad request's bundle was mapped.
mobile_application_name Dimension
The name of the mobile application where the impression occurred.
month Dimension
The month of the auction.
net_win_rate Metric
The rate of impressions won compared to the total number of bids made by the buyer for a deal.
package_id Dimension
The unique identifier for a package from which a deal was created. This value is 0 if the deal was not associated with a package.
partner_fees Metric
Fees charged by third-party partners involved in the ad transaction.
partner_fees_buying_currency Metric
Partner fees expressed in the currency used by the buyer for the transaction.
placement_code Dimension
A custom code assigned to the placement for identification.
placement_group Dimension
A logical grouping of placements used by publishers to organize and manage inventory, apply default settings, and categorize for targeting.
placement_group_id Dimension
The unique identifier assigned by the Xandr API to a placement group.
placement_group_name Dimension
The user-defined name for the placement group, used for identification.
placement_id Dimension
The unique identifier for the placement where the ad was served.
placement_name Dimension
The name of the placement where the ad was served.
post_click_convs Metric
The total number of recorded post-click conversions.
post_view_convs Metric
The total number of recorded post-view conversions.
pricing_media_type_id Dimension
Unique identifier for the type of media used for pricing (e.g., display, video).
pricing_media_type_name Dimension
Name of the media type used for pricing (e.g., display, video).
priority Dimension
Determines the order in which an order line consumes ad capacity, as configured in the ad server. This field can be used to filter data based on priority levels (e.g., PRIORITY>=5).
profit_buying_currency Metric
The buyer's profit, expressed in the buying currency.
profit_ecpa Metric
The effective profit per acquisition.
profit_ecpc Metric
The effective profit per click.
profit_ecpm Metric
The profit per 1000 impressions (eCPM), calculated as booked revenue minus total cost per 1000 impressions.
profit_ecpm_buying_currency Metric
The effective profit per 1000 impressions in the buying currency.
profit_margin Metric
The buyer's profit margin, calculated as (booked revenue - total cost) / booked revenue.
psas_or_blanks Metric
The count of Public Service Announcements (PSAs) or blank creatives served when no other eligible ad was available.
publisher_code Dimension
A custom code assigned to the publisher for identification.
publisher_currency Dimension
The currency used by the publisher for reporting and transactions.
publisher_id Dimension
The unique identification number of the publisher.
publisher_name Dimension
The name of the publisher.
revenue Metric
The total net revenue.
revenue_buying_currency Metric
Revenue generated, expressed in the buying currency.
revenue_ecpa Metric
The effective revenue per acquisition.
revenue_ecpa_buying_currency Metric
The effective revenue per acquisition in the buying currency.
revenue_ecpc Metric
The effective revenue per click.
revenue_ecpc_buying_currency Metric
The effective revenue per click in the buying currency.
revenue_ecpm Metric
The effective revenue per 1000 impressions (eCPM).
revenue_ecpm_buying_currency Metric
The effective revenue per 1000 impressions in the buying currency.
revenue_per_video_complete Metric
The revenue per video completion.
sales_tax Dimension
This field represents any applicable sales, value-added, goods and services, or similar transaction taxes that are applied to transactions within the Xandr platform.
segment_code Dimension
A user-defined unique identifier for a segment, allowing data providers to use their own identifiers within the Xandr backend for segment management.
segment_id Dimension
The unique numerical identifier assigned by the Xandr API to reference a specific segment.
segment_name Dimension
The descriptive name assigned to a segment, used for identification and display.
seller_deal Dimension
Refers to a negotiated deal associated with a seller. The 'deal_id' and 'deal_name' dimensions are available in reports like Publisher Analytics and Seller Bid Error Report, providing details on specific deals.
seller_deal_id Dimension
The internal ID of a deal as viewed or offered by a seller.
seller_deal_name Dimension
The display name of a deal as viewed or offered by a seller.
seller_member_id Dimension
The ID of the selling member.
seller_member_name Dimension
The name of the selling member.
seller_revenue Metric
The revenue earned by the seller. Revenue is a standard metric available across various report types.
seller_type Dimension
The classification of the seller, indicating the type of inventory sold (e.g., "Real Time" or "Direct").
service_fees Metric
General fees charged for services, such as impressions bought from third parties, which may be in addition to the media cost.
service_fees_buying_currency Metric
General service fees charged for impressions bought from third parties, expressed in the transaction currency used by the buyer.
serving_fees_buying_currency Metric
Total ad serving fees, expressed in the currency used by the buyer for the impression.
site_domain Dimension
The domain of the website where the ad was served. This is available in reports such as 'Network Site Domain Performance' and 'Site Domain Performance Report'.
site_id Dimension
The unique identifier for a specific website (site) where ads are served. This is a common dimension in many reports.
site_name Dimension
The name of the site.
split_id Dimension
The ID of the split that purchased the impressions in this data set. Splits are only applicable to augmented line items.
split_name Dimension
The name of the split that purchased the impressions in this data set. Splits are only applicable to augmented line items.
start_date Dimension
The start date for the report data. For hourly data, format is 'YYYY-MM-DD HH:MM:SS'; for daily, monthly, or yearly data, format is 'YYYY-MM-DD'.
submitted_bids Metric
The total count of bids submitted by buyers in an auction.
supply_type Dimension
The type of inventory (e.g., web, mobile_web, mobile_app).
targeted_segment_ids Dimension
A list of unique identifiers for segments that were targeted. This is relevant for reports like 'Buyer Segment Performance Report' and 'Curator Segment Performance Report'.
total_ad_requests Metric
The aggregate number of ad requests sent to Xandr for auction opportunities.
total_ad_responses Metric
The aggregate number of ad responses recorded within the Xandr platform.
total_convs Metric
The total number of post-view and post-click conversions.
total_cost Metric
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.
total_cost_buying_currency Metric
The total sum of media costs, data costs, and partner fees in the buying (advertiser) currency.
total_cost_ecpa Metric
The total effective cost per acquisition.
total_cost_ecpc Metric
The total effective cost per click.
total_cost_ecpm Metric
The total effective cost per 1000 impressions (eCPM).
total_feature_costs Metric
The aggregate cost associated with the usage of specific features or functionalities within the platform.
total_revenue Metric
The overall revenue generated from advertising activities.
total_segment_data_costs Metric
The total monetary value of data segments purchased from third-party data providers for targeting users.
total_segment_data_costs_buying_currency Metric
The total costs associated with using segment data, calculated in the buyer's currency. This is relevant for the 'Buyer Data Usage Report'.
unidentified_imps Metric
The total number of impressions where a cookie, device ID, or other identifying information was not included in the ad request.
vendor Dimension
The name or identifier of a third-party vendor providing data or services. This is relevant for the 'Vendor Usage Report'.
vendor_costs Dimension
The costs associated with services or data from a third-party vendor. This is relevant for the 'Vendor Usage Report'.
vendor_costs_buying_currency Dimension
The costs associated with services or data from a third-party vendor, calculated in the buyer's currency. This is relevant for the 'Vendor Usage Report'.
vendor_id Dimension
The unique identifier for a third-party vendor. This is relevant for the 'Vendor Usage Report'.
vendor_name Dimension
The name of a third-party vendor. This is relevant for the 'Vendor Usage Report'.
vendor_type Dimension
The classification of a third-party vendor based on the type of data or services it provides.
video_25_pcts Dimension
The total number of times the video creatives completed 25% of the entire duration.
video_50_pcts Dimension
The total number of times the video creatives completed 50% of the entire duration.
video_75_pcts Dimension
The total number of times the video creatives completed 75% of the entire duration.
video_completions Metric
The total number of times the video creatives played for the entire duration.
video_default_errors Metric
Errors encountered when a video ad defaults, often due to technical issues. This is relevant for 'Video Analytics' reports.
video_errors Metric
The total number of times a video error occurred.
video_player_errors Metric
Errors originating from the video player during ad playback. This is relevant for 'Video Analytics' reports.
video_served Dimension
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.
video_skips Metric
The total number of times a user skipped the video.
video_starts Metric
The total number of times the first segment of the video creative was downloaded and started.
view_measured_imps Metric
The total number of impressions that were measured for viewability.
view_measurement_rate Metric
The rate at which impressions were successfully measured for viewability.