> For the complete documentation index, see [llms.txt](https://docs.roivenue.com/roivenue-resources/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.roivenue.com/roivenue-resources/roivenue-training/roivenue-app/data/connectors-overview/list-of-connectors/xandr/xandr-supported-columns.md). # 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](/roivenue-resources/roivenue-training/roivenue-app/data/connectors-overview/list-of-connectors/xandr.md) page. The rest can be added to a connector through the Advanced Editor, which stops that connector receiving template updates. ## Dimensions | Column | Type | Description | | ------------------------------ | -------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | `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 | Column | Type | Description | | ----------------------------- | ------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | `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 | Column | Type | Description | | --------------------- | ------ | ----------------------------------------- | | `advertiser_currency` | String | The type of money used by the advertiser. |