Xandr - Supported Columns
Every column the Xandr connector can download.
These are the columns available to a Xandr connector. The recommended template uses a small subset, listed on the Xandr page. The rest can be added to a connector through the Advanced Editor, which stops that connector receiving template updates.
Dimensions
hour
DateTime
The hour of the auction. Note: For impressions older than 100 days, the day will be returned rather than the hour.
day
DateTime
The day of the auction.
month
String
The month of the auction.
adjustment_id
Int
The unique identification number of the adjustment used to make changes to the media cost and/or impressions, clicks, and conversions you see in reporting for a publisher.
advertiser_code
String
The custom code for the advertiser.
advertiser_id
Int
The unique identification number for each advertiser.
buyer_member_id
Int
The unique identification number for the buyer member.
seller_member_id
Int
The unique identification number of the selling member.
seller_member_name
String
The name of the selling member.
campaign_id
Int
The unique identification number of the campaign.
campaign_name
String
The name of the campaign.
campaign_code
String
The custom code for the campaign.
campaign_priority
Int
The bid priority of a campaign that is targeting direct inventory. The scale is from 1-10, with 1 being lowest and 10 being highest.
split_id
Int
The ID of the split that purchased the impressions in this data set. Splits are only applicable to augmented line items. For any reports that contain campaigns, the split_id (if included) will be null.
split_name
String
The name of the split that purchased the impressions in this data set. Splits are only applicable to augmented line items. For any reports that contain campaigns, the split_name (if included) will be null.
creative_id
Int
The unique identification number of the creative. Note: For impressions older than 14 months, creatives will be aggregated into one row with 0 as the creative_id. For external click or impression trackers, creative_id will be "External Clicks" or "External Imps".
creative_name
String
The display name of the creative. Note: For impressions older than 14 months, creatives will be aggregated into one row with "All creative data older than 14 months" as the creative_name. For external click or impression trackers, creative_name will be "External Clicks" or "External Imps".
placement_id
Int
The unique identification number of the placement. Note: For impressions older than 14 months, placements will be aggregated into one row with -1 as the placement_id.
placement_name
String
The name of the placement. Note: For impressions older than 14 months, placements will be aggregated into one row with "All placement data older than 100 days" as the placement_name.
deal_id
Int
The ID of the deal. For more information about deals you have negotiated with sellers, see Deal Buyer Access Service.
deal_name
String
The name of the deal.
deal_code
String
The custom code for the deal. For deals with external supply partners, this is generally the string that you use to identify the deal.
placement_code
String
The custom code for the placement.
size
String
The size of the placement/creative served.
geo_country
String
The code for the geographic country or region.
geo_country_name
String
The name of the geographic country or region.
gender
String
The gender of the user. Note: For impressions older than 100 days, the gender will be "u". The value of the gender is defined by the publisher in the bid request. Xandr does not have control over it apart from processing the value.
imp_type_id
Int
The ID for the type of impression. Possible values (associated types in parentheses): 1 ("Blank"): No creative served. 2 ("PSA"): A public service announcement served because there were no valid bids and no default creative was available. 3 ("Default Error"): A default creative served due to a timeout issue. 4 ("Default"): A default creative served because there were no valid bids. 5 ("Kept"): Your advertiser's creative served on your publisher's site. 6 ("Resold"): Your publisher's impression was sold to a third-party buyer. 7 ("RTB"): Your advertiser's creative served on third-party inventory. 8 ("PSA Error"): A public service announcement served due to a timeout issue or lack of a default creative. 9 ("External Impression"): An impression from an impression tracker. 10 ("External Click"): A click from a click tracker.
imp_type
String
The type of impression. For possible values, see imp_type_id.
bid_type
String
The optimization phase the node was in when it bid for this impression. Note: 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". 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"
insertion_order_id
Int
The unique identification number of the insertion order.
insertion_order_name
String
The name of the insertion order.
insertion_order_code
String
The custom code for the insertion order.
line_item_id
Int
The unique identification number of the line item.
line_item_name
String
The name of the line item.
line_item_code
String
The custom code for the line item.
supply_type
String
The type of inventory. Possible values: "web", "mobile_web", "mobile_app".
pixel_id
Int
The unique identification number of the conversion pixel. Note: This dimension will return a maximum of 10 conversion pixels. Also, you can filter by no more than 10 conversion pixels.
publisher_id
Int
The unique identification number of the publisher.
publisher_name
String
The name of the publisher.
publisher_code
String
The custom code for the publisher.
seller_type
String
The seller type.
media_type
String
The general display style of the creative. You can use the Media Type Service to view the complete list of media types.
mediatype_id
Int
The unique identification number of the media type to which the subtype belongs.
user_group_for_campaign
String
The test/control user group for the campaign. See the "labels" field in the Campaign Service for more details.
venue
Int
The name of the cluster of domain, site, tag, and user country/region that Xandr' optimization system uses to determine bid valuations. A campaign cannot target a venue explicitly.
billing_period_start_date
DateTime
The earliest date of the insertion order's billing period. Note: Alpha-Beta Notice: This field or feature is part of functionality currently in either Alpha or Beta phase. It is therefore subject to change.
billing_period_end_date
DateTime
The last date of the insertion order's billing period. Note: Alpha-Beta Notice: This field or feature is part of functionality currently in either Alpha or Beta phase. It is therefore subject to change.
billing_period_external_code
String
The custom code for the billing period (budget_interval).
Metrics
imps
Int
The total number of impressions served.
attributed_revenue
Decimal
The amount of revenue from all recorded post views and post clicks.
attributed_pc_revenue
Decimal
The amount of revenue from all recorded post views.
attributed_pv_revenue
Decimal
The amount of revenue from all recorded post clicks.
clicks
Int
The total number of clicks across all impressions.
click_convs_rate
Double
The rate of conversions to clicks.
click_conv_rate
Double
The rate of conversions to clicks. Note: This field is identical to click_convs_rate.
click_thru_pct
Double
The percentage of users viewing a creative that clicked on it.
cpa
Decimal
The cost per acquisition.
cpc
Decimal
The cost per click.
cpm
Decimal
The cost per 1,000 impressions.
post_view_convs
Int
The total number of recorded post view conversions.
post_view_revenue
Decimal
The total amount of recorded post view revenue.
post_click_convs
Int
The total number of recorded post click conversions.
post_click_revenue
Decimal
The total amount of recorded post click revenue.
total_revenue
Decimal
The total amount of post view and post click revenue.
total_convs
Int
The total number of post view and post click conversions.
conv_rate
Double
The rate of post click and post view conversions to impressions.
convs_rate
Double
The rate of conversions to impressions.
convs_per_mm
Double
The number of conversions per million impressions.
ecpa_adv_curr
Decimal
The cost per acquisition in the advertiser currency type.
ecpc_adv_curr
Decimal
The cost per click in the advertiser currency type.
ecpm_adv_curr
Decimal
The cost per 1,000 impressions in the advertiser currency type.
post_view_convs_rate
Double
The rate of post view conversions to impressions.
post_click_convs_rate
Double
The rate of post click conversions to impressions.
post_click_conversion_pixel
Int
The number of post click conversions for a specific pixel.
post_click_revenue_pixel
Decimal
The amount of revenue earned for a specific pixel (post click).
post_view_conversion_pixel
Int
The number of post view conversions for a specific pixel.
post_view_revenue_pixel
Decimal
The amount of revenue earned for a specific pixel (post view).
ppm
Decimal
The profit per 1000 impressions.
rpm
Decimal
The revenue per 1000 impressions.
spend_adv_curr
Decimal
The total amount spent by the advertiser in the advertiser's preferred currency.
total_revenue_pixel
Decimal
The total revenue earned for a specific pixel.
ctr
Double
The rate of clicks to impressions.
spend
Decimal
The total marketer spend across both direct and real time media buys.
media_cost
Decimal
The total amount spent to purchase all impressions.
ecpm
Decimal
The effective advertiser spend per 1000 impressions.
ecpc
Decimal
The effective advertiser spend per click.
ecpa
Decimal
The effective advertiser spend per conversion/acquisition.
imps_viewed
Int
The number of measured impressions that were viewable, per the IAB Viewability definition, which states that an impression is viewable if 50% of the pixels are in-view during 1 consecutive second.
view_measured_imps
Int
The total number of impressions that were measured for viewability.
view_rate
Double
The percentage of impressions that were viewable out of the total number of impressions measured for viewability. (Viewed Imps / View Measured Imps)
view_measurement_rate
Double
The percentage of impressions measured for viewability out of the total number of impressions. (View Measured Imps / Imps)
avg_bid_reduction
Double
The average bid reduction you gained on the line item or campaign. This value represents the difference (as a percentage) between your bid and the actual media cost you paid for the impression you won (e.g., due to bid reduction). This value is only valid for RTB bidding (i.e., not Managed). Currently, this value is not accurately calculated for line items for which the payment_auction_event_type field has been set to 2.
video_skips
Int
The total number of times a user skipped the video. Use this metric for reporting when buying skippable inventory.
video_starts
Int
The total number of times the first segment of the video creative was downloaded and started.
video_25_pcts
Int
The total number of times the video creatives completed 25% of the entire duration.
video_50_pcts
Int
The total number of times the video creatives completed 50% of the entire duration.
video_75_pcts
Int
The total number of times the video creatives completed 75% of the entire duration.
video_completions
Int
The total number of times the video creatives played for the entire duration.
video_served
Int
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. An ad response doesn't necessarily indicate a successful impression. For an impression, the first frame of the video must be served.
video_errors
Int
The total number of times a video error occurred.
revenue_per_video_complete
Decimal
The revenue per video completion.
cost_per_video_complete
Decimal
The cost per video completion.
video_completion_rate
Double
The ratio of video completions to impressions, expressed as a percentage.
video_start_rate
Double
The percentage of times the first segment of the video creative was downloaded and started.
video_skip_rate
Double
The percentage of times the user opted to skip the video.
Other columns
advertiser_currency
String
The type of money used by the advertiser.
Was this helpful?