Xandr: Most-used fields

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

The name of the advertiser.

dimension

Bidder

Bidder

The Bidder object, which is typically a Demand-Side Platform (DSP).

dimension

RTB

RTB

dimension

ad_serving_fees

ad_serving_fees

Fees related to serving advertisements. These fees are added to the media cost.

metric

ad_serving_fees_buying_currency

ad_serving_fees_buying_currency

Fees related to serving advertisements in the buying currency.

metric

ad_type.id

ad_type.id

metric

ad_type.name

ad_type.name

dimension

advertiser.id

advertiser.id

The unique identifier for the advertiser.

metric

advertiser.name

advertiser.name

The name of the advertiser.

dimension

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

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 minimum price a seller will accept for an ad impression in a 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 unique identifier for the individual auction that resulted in an impression.

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 at which bids are submitted for a deal.

metric

bid_requests

bid_requests

The total number of bid requests made for inventory.

metric

bid_sent_no_responses

bid_sent_no_responses

The count of bid responses from Xandr where the creative did not ultimately render.

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 Bidder object, which is typically a Demand-Side Platform (DSP).

dimension

bidder_id

bidder_id

The ID of the Xandr Bidder object, typically a Demand-Side Platform (DSP).

dimension

bidder_seat_id

bidder_seat_id

The unique identifier for the bidder seat, used by external bidders.

dimension

bids

bids

The total number of completed bids.

metric

billable_buyer_imps

billable_buyer_imps

Impressions that are eligible for billing from the buyer’s perspective.

metric

billing_currency

billing_currency

dimension

billing_period.booked_impressions_budget_daily

billing_period.booked_impressions_budget_daily

The daily budget in impressions allocated for this billing period.

dimension

billing_period.booked_impressions_budget_lifetime

billing_period.booked_impressions_budget_lifetime

The total budget in impressions allocated for the lifetime of this billing period.

dimension

billing_period.booked_revenue_budget_daily

billing_period.booked_revenue_budget_daily

The daily revenue budget allocated for this billing period.

dimension

billing_period.booked_revenue_budget_daily_buying_currency

billing_period.booked_revenue_budget_daily_buying_currency

The daily booked revenue budget of the insertion order’s billing period, in the buying currency.

dimension

billing_period.booked_revenue_budget_lifetime

billing_period.booked_revenue_budget_lifetime

The total revenue budget allocated for the lifetime of this billing period.

dimension

billing_period.booked_revenue_budget_lifetime_buying_currency

billing_period.booked_revenue_budget_lifetime_buying_currency

The lifetime booked revenue budget of the insertion order’s billing period, in the buying currency.

metric

billing_period.end_date

billing_period.end_date

The last date of the insertion order’s billing period.

dimension

billing_period.id

billing_period.id

The unique identifier for the billing period.

metric

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_id

billing_period_id

The ID of the 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

booked_revenue_dollars_buying_currency

booked_revenue_dollars_buying_currency

Network revenue booked through direct advertisers, expressed in the buyer’s transaction currency.

metric

booked_revenue_ecpa

booked_revenue_ecpa

The effective cost per acquisition (conversion) based on booked revenue.

metric

booked_revenue_ecpa_buying_currency

booked_revenue_ecpa_buying_currency

The effective cost per acquisition (conversion) based on booked revenue, in the buying currency.

metric

booked_revenue_ecpc

booked_revenue_ecpc

The effective cost per click based on booked revenue.

metric

booked_revenue_ecpc_buying_currency

booked_revenue_ecpc_buying_currency

The effective cost per click based on booked revenue, in the buying currency.

metric

booked_revenue_ecpm

booked_revenue_ecpm

The effective cost per thousand impressions (CPM) based on booked revenue.

metric

booked_revenue_ecpm_buying_currency

booked_revenue_ecpm_buying_currency

The effective cost per thousand impressions (CPM) based on booked revenue, in the buying currency.

metric

booked_revenue_selling_currency

booked_revenue_selling_currency

The booked revenue, expressed in the selling currency.

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

The unique identifier for the brand.

metric

brand.name

brand.name

The name of the brand.

dimension

brand_id

brand_id

The ID for the brand as determined by the Xandr creative audit or self-assigned for managed traffic.

dimension

brand_name

brand_name

The name for the brand as determined by the Xandr creative audit or self-assigned for managed traffic.

dimension

buyer.id

buyer.id

The unique identification number for the buyer member.

metric

buyer.name

buyer.name

The name of the buying member.

dimension

buyer_ad_serving_fees

buyer_ad_serving_fees

The buyer ad serving fees

metric

buyer_cost_ecpm

buyer_cost_ecpm

The effective cost per thousand impressions (eCPM) incurred by the buyer for the deal.

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 media cost incurred by the buyer.

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_media_cost_ecpm

buyer_media_cost_ecpm

The effective cost per thousand impressions (CPM) based on buyer media cost.

metric

buyer_member_id

buyer_member_id

The ID of the buying member.

dimension

buyer_member_name

buyer_member_name

The name of the buying member. If the name is ‘Default’ or ‘Default Error’, it indicates no buyer for the impression and a default creative was served.

dimension

buyer_seat_id

buyer_seat_id

A unique identifier for a buyer’s seat, allowing external DSPs to use their own proprietary buyer IDs.

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

The identifier for the transaction type in buying billing, often related to impression types.

dimension

buying_currency

buying_currency

The transaction currency used by the buyer to purchase the 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

call_type

call_type

The Impression Bus (Impbus) handler from which the impression originated.

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

campaign_type

campaign_type

The classification of an advertising campaign, such as App, Audience, Search, or Shopping.

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

Booked revenue per clearing event in the 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

Buyer media cost per clearing event in the 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

The percentage of impressions that resulted in a click, calculated as Clicks / Impressions.

metric

click_thru_pct

click_thru_pct

The rate of clicks to impressions, expressed as a percentage.

metric

click_to_conversion_rate

click_to_conversion_rate

The rate of conversions that resulted from clicks.

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

clicks_and_hits_count

clicks_and_hits_count

metric

clicks_bought

clicks_bought

The total number of clicks purchased or recorded across all impressions.

metric

commissions

commissions

Fees deducted from booked revenue for brokering a relationship with an advertiser, typically applicable to line items and insertion orders.

metric

commissions_buying_currency

commissions_buying_currency

Commissions charged for transactions, expressed in the buyer’s (advertiser’s) preferred currency.

metric

completed_video_views_count

completed_video_views_count

metric

completes

completes

The total count of completed actions, often referring to video 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 ratio of 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 percentage of visitors who completed a desired action, calculated as Conversions / Impressions or Conversions / Clicks.

metric

conversions

conversions

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

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_advertiser_currency

cost_ecpc_advertiser_currency

The effective cost per click (eCPC) of advertising, expressed in the advertiser’s currency.

metric

cost_ecpc_buying_currency

cost_ecpc_buying_currency

The effective cost per click in the buyer’s currency.

metric

cost_ecpm_advertiser_currency

cost_ecpm_advertiser_currency

The effective cost per thousand impressions (eCPM) of advertising, expressed in the advertiser’s currency.

metric

cost_per_video_complete

cost_per_video_complete

The cost per video completion.

metric

cost_selling_currency

cost_selling_currency

The total cost of the inventory, expressed in the selling currency.

metric

cost_type

cost_type

dimension

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

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

The unique identifier for the creative served in an impression.

metric

creative.name

creative.name

The name of the creative served in an impression.

dimension

creative_asset_identifier

creative_asset_identifier

dimension

creative_code

creative_code

The custom code of the creative.

dimension

creative_hosting_deductions

creative_hosting_deductions

metric

creative_id

creative_id

The unique identification number of the creative. For impressions older than 100 days, creatives may be aggregated into one row with 0 as the creative_id.

dimension

creative_name

creative_name

The display name of the creative.

dimension

creative_overage_fees

creative_overage_fees

Fees charged for hosted creatives that exceed specified size limits.

metric

creative_overage_fees_buying_currency

creative_overage_fees_buying_currency

Fees charged for hosted creatives exceeding size limits, expressed in the buyer’s currency.

metric

cross_device_incremental_imps

cross_device_incremental_imps

metric

ctr

ctr

Click-through rate. Calculated as Clicks / Impressions.

metric

curated_deal

curated_deal

Indicates whether the deal is a curated deal, representing a negotiated agreement between a buyer and a curator.

dimension

curated_deal_advertiser_id

curated_deal_advertiser_id

The unique identifier for the advertiser associated with a curated deal.

dimension

curated_deal_advertiser_name

curated_deal_advertiser_name

The name of the advertiser associated with a curated deal.

dimension

curated_deal_id

curated_deal_id

The unique identifier for a curated deal.

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

Unique identifier for a curated deal line item, which represents a negotiated agreement between a buyer and a curator for specific inventory.

dimension

curated_deal_line_item_name

curated_deal_line_item_name

The name of a curated deal line item, representing a negotiated agreement between a buyer and a curator.

dimension

curated_deal_name

curated_deal_name

The name of a curated deal.

dimension

curated_line_item_name

curated_line_item_name

The name of a curated line item, typically representing a specific advertising campaign or strategy.

dimension

curator_margin

curator_margin

The profit a curator earns on a transaction, typically a percentage of the buyer’s bid (Curator Revenue) or a fixed CPM.

dimension

curator_margin_type

curator_margin_type

The type of margin applied by a curator in a curated deal.

dimension

curator_margin_type_filterable

curator_margin_type_filterable

Indicates if the curator margin type can be used as a filter in reports.

metric

curator_member

curator_member

Refers to the member account acting as a curator in a curated deal, packaging supply and assets for buyers.

dimension

curator_member_id

curator_member_id

The unique identifier for the curator member.

dimension

curator_net_media_cost

curator_net_media_cost

The amount of spend a curator sends to exchange sellers, net of curator fees and margins.

dimension

curator_revenue

curator_revenue

The amount of spend a buyer sends to the curator, net of buyer fees.

dimension

curator_tech_fees

curator_tech_fees

Fees charged by Xandr to a curator on a transaction.

dimension

curator_total_cost

curator_total_cost

The total amount of spend a curator sends to the exchange and exchange sellers, net of curator margin but gross of curator fees.

dimension

data_costs

data_costs

Costs related to the usage of data, such as third-party data segments.

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

data_provider_id

data_provider_id

The unique identifier for the third-party data provider.

dimension

data_provider_name

data_provider_name

The name of the third-party data provider.

dimension

data_type

data_type

The data type

dimension

date

date

dimension

datetime

datetime

The date and time of the event.

dimension

day

day

The day of the auction.

dimension

deal_auction_type_name

deal_auction_type_name

The type of auction for a deal, such as first-price, second-price, or fixed-price.

dimension

deal_code

deal_code

The custom code for the deal. For deals with external supply partners, this string typically identifies the deal.

metric

deal_id

deal_id

The ID of the deal.

dimension

deal_name

deal_name

The name of the deal.

dimension

deal_type

deal_type

The type of deal. Possible values include Open Auction, Private Auction, First Look, Programmatic Guaranteed, and Curated.

dimension

deal_type_id

deal_type_id

The ID of the deal type.

dimension

deal_type_name

deal_type_name

The descriptive name for the category of a deal, such as Open Auction, Private Auction, Curated, First Look, or Programmatic Guaranteed.

dimension

default_no_responses

default_no_responses

The count of ad requests where a default creative was sent but no response was received from the ad server.

metric

device_category

device_category

The general category of the device on which the ad impression was served (e.g., Desktops & Laptops, Mobile Phones, Tablets).

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 from which the impression originated (e.g., PC, Phone, Tablet, TV, Game Console).

dimension

device_type_id

device_type_id

The device type id

dimension

ecpa

ecpa

The effective cost per acquisition (conversion).

metric

ecpa_adv_curr

ecpa_adv_curr

The effective cost per acquisition (conversion) 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 in the advertiser’s currency.

metric

ecpm

ecpm

The effective cost per thousand impressions.

metric

ecpm_adv_curr

ecpm_adv_curr

The effective cost per thousand impressions in the advertiser’s currency.

metric

end_date

end_date

The end date for the data included in a report.

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

Clicks recorded by an external click tracker.

metric

external_imps

external_imps

Impressions recorded by an external impression tracker.

metric

filtered_requests

filtered_requests

The number of ad requests that were filtered out by Xandr prior to bidding due to inventory quality controls.

metric

flight.booked_impressions_budget_lifetime

flight.booked_impressions_budget_lifetime

The total number of impressions budgeted for the lifetime of the line item’s flight.

dimension

flight.booked_revenue_budget_daily_advertiser_currency

flight.booked_revenue_budget_daily_advertiser_currency

The daily booked revenue budget for the line item’s flight, in the advertiser’s currency.

metric

flight.booked_revenue_budget_lifetime_advertiser_currency

flight.booked_revenue_budget_lifetime_advertiser_currency

The lifetime booked revenue budget for the line item’s flight, in the advertiser’s currency.

metric

flight.end_date

flight.end_date

The end date of the campaign flight.

dimension

flight.start_date

flight.start_date

The start date of the campaign flight.

dimension

flight_id

flight_id

The ID of the line item flight under which the impression was purchased.

dimension

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_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

gross_seller_revenue

gross_seller_revenue

metric

gross_win_rate

gross_win_rate

The gross rate at which bids on a deal result in a win.

metric

hour

hour

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

dimension

identified_imps

identified_imps

The number of impressions where a user could be identified, typically via a user ID or cookie.

metric

imp_time

imp_time

The timestamp of when the impression occurred.

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

impressions

impressions

The total number of ad impressions that were served or resold.

metric

impressions_total

impressions_total

The total number of impressions served.

metric

imps

imps

The total number of impressions recorded (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 an impression request was filtered out by Xandr’s inventory quality controls and the auction was not held.

dimension

imps_matched

imps_matched

The total number of impressions that matched the seller’s deal settings.

metric

imps_resold

imps_resold

The total number of impressions sold to a third-party buyer.

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 according to the IAB Viewability definition.

metric

imps_won

imps_won

The total number of impressions won in an auction.

metric

ineligible_bid_rate

ineligible_bid_rate

The rate at which bids on a deal were considered ineligible.

metric

insertion_order.booked_impressions_budget_daily

insertion_order.booked_impressions_budget_daily

The daily number of impressions budgeted for the insertion order.

dimension

insertion_order.booked_impressions_budget_lifetime

insertion_order.booked_impressions_budget_lifetime

The total number of impressions budgeted for the lifetime of the insertion order.

dimension

insertion_order.booked_revenue_budget_daily

insertion_order.booked_revenue_budget_daily

The daily revenue budget set for the insertion order.

dimension

insertion_order.booked_revenue_budget_lifetime

insertion_order.booked_revenue_budget_lifetime

The total revenue budgeted for the lifetime of the insertion order.

dimension

insertion_order.end_date

insertion_order.end_date

The end date of the insertion order.

dimension

insertion_order.id

insertion_order.id

The unique identifier for the insertion order under which ad impressions were purchased.

metric

insertion_order.name

insertion_order.name

The name of the insertion order under which ad impressions were purchased.

dimension

insertion_order.start_date

insertion_order.start_date

The start date of the insertion order.

dimension

insertion_order.state

insertion_order.state

The current operational status of the insertion order (e.g., active or inactive).

dimension

insertion_order_code

insertion_order_code

The custom code associated with 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 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 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

A boolean indicator specifying if a deal or line item is curated.

dimension

line_id

line_id

The unique identifier for the line item.

dimension

line_item.booked_impressions_budget_daily

line_item.booked_impressions_budget_daily

The daily number of impressions budgeted for the line item.

dimension

line_item.booked_impressions_budget_lifetime

line_item.booked_impressions_budget_lifetime

The total number of impressions budgeted for the lifetime of the line item.

metric

line_item.booked_revenue_budget_daily_adv_curr

line_item.booked_revenue_budget_daily_adv_curr

The daily revenue budget for the line item, expressed in the advertiser’s currency.

metric

line_item.booked_revenue_budget_lifetime_adv_curr

line_item.booked_revenue_budget_lifetime_adv_curr

The total revenue budgeted for the lifetime of the line item, expressed in the advertiser’s currency.

metric

line_item.end_date

line_item.end_date

The end date of the line item.

dimension

line_item.id

line_item.id

The unique identifier for the line item under which ad impressions were purchased.

metric

line_item.name

line_item.name

The name of the line item under which ad impressions were purchased.

dimension

line_item.start_date

line_item.start_date

The start date of the line item.

dimension

line_item.status

line_item.status

The current operational status of the line item.

dimension

line_item.subtype

line_item.subtype

A more granular classification of the line item type (e.g., standard_curated).

dimension

line_item.type

line_item.type

The type of the line item.

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

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 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_cost_buying_currency

media_cost_buying_currency

The total cost of purchased inventory in the buyer’s 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 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_currency

member_currency

The default currency set for a member account, which can be overridden at more granular levels.

dimension

member_id

member_id

The unique identification number of the member.

dimension

member_name

member_name

The display name of the member (e.g., buyer, seller, publisher, curator).

dimension

metric_type

metric_type

metric

mobile_application_id

mobile_application_id

The unique identifier for the mobile application where the ad request originated.

dimension

mobile_application_name

mobile_application_name

The name of the mobile application where the ad request originated.

dimension

month

month

The month of the auction.

dimension

month_date

month_date

The month in which the auction for the ad impression occurred.

dimension

net_win_rate

net_win_rate

The net rate at which bids on a deal result in a win.

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 name of the operating system of the device.

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 unique identifier for a package, often associated with a deal, such as an Apple App Store ID or Google Play package name.

dimension

partner_fees

partner_fees

The total amount of third-party costs, budgeted using the Partner Fee Service, that have accrued on an augmented line item over the reported period.

metric

partner_fees_buying_currency

partner_fees_buying_currency

Partner fees, expressed in the buying currency.

metric

payment_type

payment_type

The type of payment model used for bidding and billing, such as CPM (cost-per-mille), CPC (cost-per-click), or CPA (cost-per-acquisition).

dimension

payment_type_id

payment_type_id

The identifier for the payment type used for bidding and billing.

dimension

placement.code

placement.code

The code of the Xandr Placement for the impression.

dimension

placement_code

placement_code

The custom code for the placement.

dimension

placement_group_id

placement_group_id

Unique identifier for a placement group, which organizes placements for management and applies default criteria to child placements.

dimension

placement_group_name

placement_group_name

The name of the placement group.

dimension

placement_id

placement_id

The unique identification number of the placement. For impressions older than 100 days, placements may be aggregated into one row with -1 as the placement_id.

dimension

placement_name

placement_name

The name of the placement. For impressions older than 100 days, placements may be aggregated into one row with ‘All placement data older than 100 days’ as the placement_name.

dimension

platform

platform

dimension

post_auction_discount

post_auction_discount

A discount applied to the winning bid price after an auction is completed.

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 total revenue attributed to either post-click or post-view conversions.

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

The identifier for the media type classification used for billing purposes, especially for video-specific pricing.

dimension

pricing_media_type_name

pricing_media_type_name

The name of the media type classification used for billing purposes, especially for video-specific pricing.

dimension

priority

priority

A numerical value indicating the prioritization of a deal or campaign in the auction process.

metric

profit_advertiser_currency

profit_advertiser_currency

The profit generated from advertising, expressed in the advertiser’s currency.

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

profit_selling_currency

profit_selling_currency

The profit generated from advertising, expressed in the seller’s currency.

metric

psas_or_blanks

psas_or_blanks

The count of public service announcements (PSAs) or blank creatives served when no other ad was available.

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

The unique identifier for the publisher on whose inventory the ad impression occurred.

metric

publisher.name

publisher.name

The name of the publisher on whose inventory the ad impression occurred.

dimension

publisher_code

publisher_code

The custom code to identify 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 unique identification number 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

The region ID of the user’s location.

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 total net revenue.

metric

revenue_buying_currency

revenue_buying_currency

The total revenue 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

revenue_selling_currency

revenue_selling_currency

The total revenue in the selling currency.

metric

revenue_type

revenue_type

For managed line items, this is the basis on which the booked revenue gets recorded for the Seller. Possible values include CPA, CPM, CPC, etc.

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

Applicable sales, value-added, goods and services, or similar transaction taxes.

metric

second_level_category_id

second_level_category_id

The unique identifier for a sub-category or second-level content category.

dimension

second_level_category_name

second_level_category_name

The name of a sub-category or second-level content category.

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

Refers to a deal negotiated and offered by a seller on the Xandr platform.

dimension

seller_deal_id

seller_deal_id

The unique identifier for the seller deal included within a curated deal.

dimension

seller_deal_name

seller_deal_name

The name of the seller deal included within a curated deal.

dimension

seller_deal_type_id

seller_deal_type_id

The identifier for the type of deal offered by the seller, such as Open Auction or Private Auction.

dimension

seller_deal_type_name

seller_deal_type_name

The descriptive name of the deal type offered by the seller, such as Open Auction, Private Auction, Curated, First Look, or Programmatic Guaranteed.

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 related to serving impressions. These fees are added to the media cost.

metric

serving_fees_buying_currency

serving_fees_buying_currency

Serving fees, expressed in the buying currency.

metric

serving_fees_selling_currency

serving_fees_selling_currency

Serving fees, expressed in the selling currency.

metric

site_domain

site_domain

The domain where the impression occurred. For mobile applications, this can be the URL of the app’s location in the app store.

dimension

site_id

site_id

The ID of the site. For impressions older than 100 days, the site_id may be 0.

dimension

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

start_date

start_date

The start date for the data included in a report.

dimension

submitted_bids

submitted_bids

The total number of bids submitted.

metric

supply_strategy

supply_strategy

dimension

supply_type

supply_type

The type of inventory (e.g., web, mobile_web, mobile_app).

dimension

supply_type_name

supply_type_name

The classification of the ad inventory channel, such as web, mobile app, or mobile web.

dimension

targeted_curator_media_cost

targeted_curator_media_cost

The cost of media associated with impressions targeted through a curator, net of buyer fees.

metric

targeted_curator_media_cost_ecpm

targeted_curator_media_cost_ecpm

The effective cost per thousand impressions (eCPM) of media associated with impressions targeted through a curator, net of buyer fees.

metric

targeted_curator_revenue

targeted_curator_revenue

The amount of revenue (spend) a buyer sent to the curator for impressions targeted by a segment, net of buyer fees.

metric

targeted_curator_revenue_ecpm

targeted_curator_revenue_ecpm

The effective cost per thousand impressions (eCPM) representing the revenue a buyer sent to the curator for impressions targeted by a segment, net of buyer fees.

metric

targeted_impressions

targeted_impressions

The total number of transacted impressions that were targeted by a specific segment or criteria.

metric

targeted_segment_ids

targeted_segment_ids

The unique identifiers of segments used for targeting in advertising campaigns.

dimension

targeted_view_measured_impressions

targeted_view_measured_impressions

The number of transacted impressions for which Xandr measured viewability, and which were targeted by a segment.

metric

targeted_viewable_impressions

targeted_viewable_impressions

The number of viewed impressions that were targeted by a specific segment.

metric

targeting_type

targeting_type

dimension

top_level_category_id

top_level_category_id

The unique identifier for the primary content category.

dimension

top_level_category_name

top_level_category_name

The name of the primary content category.

dimension

total_ad_requests

total_ad_requests

The total count of ad requests sent to Xandr for an auction.

metric

total_ad_responses

total_ad_responses

The total count of ad responses registered within the Xandr platform.

metric

total_convs

total_convs

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

dimension

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_cost_selling_currency

total_cost_selling_currency

The total costs, expressed in the selling currency.

metric

total_feature_costs

total_feature_costs

The aggregate costs incurred from using platform features (e.g., Nielsen Digital Ad Ratings, Cross Device).

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 net revenue.

dimension

total_segment_data_costs

total_segment_data_costs

The total costs associated with the usage of third-party data segments.

metric

total_segment_data_costs_buying_currency

total_segment_data_costs_buying_currency

The total costs related to third-party data segment usage, expressed in the buyer’s transaction currency.

metric

trading_costs

trading_costs

metric

trafficType

trafficType

dimension

unidentified_imps

unidentified_imps

The number of impressions where a user could not be identified.

metric

unique_users

unique_users

metric

uniques

uniques

metric

universal_pixel

universal_pixel

A unified pixel code for easy segmentation and measurement of user interactions on a website.

dimension

user_id

user_id

The unique identifier (64-bit character string) representing the user for the impression.

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

The total costs associated with third-party vendors, including segment data costs and feature costs.

metric

vendor_costs_buying_currency

vendor_costs_buying_currency

The total costs from third-party vendors, expressed in the transaction currency used by the buyer.

metric

vendor_id

vendor_id

The unique identifier for a third-party vendor.

dimension

vendor_name

vendor_name

The descriptive name of the third-party vendor.

dimension

vendor_type

vendor_type

The classification of a vendor based on the type of third-party data or services they provide.

dimension

venue

venue

The name of the cluster of domain, site, tag, and user country/region that Xandr’s optimization system uses 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_content_genre

video_content_genre

dimension

video_content_network

video_content_network

dimension

video_default_errors

video_default_errors

Errors reported by the video player when a default creative was expected to serve.

metric

video_delivery_type

video_delivery_type

dimension

video_errors

video_errors

The total number of times a video error occurred.

metric

video_player_errors

video_player_errors

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

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

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

viewed_imps

viewed_imps

The number of measured impressions that were considered viewable based on IAB Viewability definition.

metric