Fields listing for Xandr

Day of the year

Week of the year

Hour of the day

Month of the year

Month and day

Quarter of the year

Week of the year

Week of the year

Year such as 2017.

Year and month.

Year, month, and day.

Year, month, day, and hour.

Year and quarter.

Year and week.

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.

The custom code for the advertiser.

The type of money used by the advertiser.

The unique identification number for each advertiser.

The amount of revenue from all recorded post views.

The amount of revenue from all recorded post clicks.

The amount of revenue from all recorded post views and post clicks.

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.

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"

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.

The custom code for the billing period (budget_interval).

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.

The unique identification number for the buyer member.

The custom code for the campaign.

The unique identification number of the campaign.

The name of the campaign.

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.

The rate of conversions to clicks. Note: This field is identical to click_convs_rate.

The rate of conversions to clicks.

The percentage of users viewing a creative that clicked on it.

The total number of clicks across all impressions.

The rate of post click and post view conversions to impressions.

The number of conversions per million impressions.

The rate of conversions to impressions.

The cost per video completion.

The cost per acquisition.

The cost per click.

The cost per 1,000 impressions.

Deprecated (as of October 17, 2016).

Deprecated. If you request this dimension, only a default value will be returned. Use the Advertiser Creative Frequency & Recency report to view creative frequency data.

Deprecated. If you request this dimension, only a default value will be returned. Use the Advertiser Creative Frequency & Recency report to view creative frequency data.

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

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

Deprecated. If you request this dimension, only a default value will be returned. Use the Advertiser Creative Frequency & Recency report to view creative recency data.

Deprecated. If you request this dimension, only a default value will be returned. Use the Advertiser Creative Frequency & Recency report to view creative recency data.

The rate of clicks to impressions.

Deprecated (as of October 17, 2016).

The custom code for the deal. For deals with external supply partners, this is generally the string that you use to identify the deal.

The ID of the deal. For more information about deals you have negotiated with sellers, see Deal Buyer Access Service.

The name of the deal.

The effective advertiser spend per conversion/acquisition.

The cost per acquisition in the advertiser currency type.

The effective advertiser spend per click.

The cost per click in the advertiser currency type.

The effective advertiser spend per 1000 impressions.

The cost per 1,000 impressions in the advertiser currency type.

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.

The code for the geographic country or region.

The name of the geographic country or region.

The type of impression. For possible values, see imp_type_id.

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.

The total number of impressions served.

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.

Deprecated (as of October 17, 2016).

The custom code for the insertion order.

The unique identification number of the insertion order.

The name of the insertion order.

Deprecated (as of October 17, 2016).

The custom code for the line item.

The unique identification number of the line item.

The name of the line item.

The total amount spent to purchase all impressions.

The general display style of the creative. You can use the Media Type Service to view the complete list of media types.

The unique identification number of the media type to which the subtype belongs.

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.

Deprecated (as of October 17, 2016).

The custom code for the placement.

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.

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.

The number of post click conversions for a specific pixel. For more information on how we attribute post-view (and other) conversions, Conversion Attribution (Monetize) or Conversion Attribution (Invest).

The total number of recorded post click conversions.

The rate of post click conversions to impressions.

The total amount of recorded post click revenue.

The amount of revenue earned for a specific pixel.

The number of post view conversions for a specific pixel. For more information on how we attribute post-view (and other) conversions, see Conversion Attribution (Monetize) or Conversion Attribution (Invest).

The total number of recorded post view conversions.

The rate of post view conversions to impressions.

The total amount of recorded post view revenue.

The amount of revenue earned for a specific pixel.

The profit per 1000 impressions.

Deprecated (as of October 17, 2016).

The custom code for the publisher.

The unique identification number of the publisher.

The name of the publisher.

The revenue per video completion.

The revenue per 1000 impressions.

Deprecated (as of October 17, 2016).

The unique identification number of the selling member.

The name of the selling member.

The seller type.

The size of the placement/creative served.

The total marketer spend across both direct and real time media buys.

The total amount spent by the advertiser in the advertiser's preferred currency.

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.

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.

The type of inventory. Possible values: - "web" - "mobile_web" - "mobile_app".

The total number of post view and post click conversions.

The total amount of post view and post click revenue.

The total revenue earned for a specific pixel.

The test/control user group for the campaign. See the "labels" field in the Campaign Service for more details.

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.

The total number of times the video creatives completed 25% of the entire duration.

The total number of times the video creatives completed 50% of the entire duration.

The total number of times the video creatives completed 75% of the entire duration.

The ratio of video completions to impressions, expressed as a percentage.

The total number of times the video creatives played for the entire duration.

The total number of times a video error occurred.

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.

The percentage of times the user opted to skip the video.

The total number of times a user skipped the video. Use this metric for reporting when buying skippable inventory.

The percentage of times the first segment of the video creative was downloaded and started.

The total number of times the first segment of the video creative was downloaded and started.

The total number of impressions that were measured for viewability.

The percentage of impressions measured for viewability out of the total number of impressions. (View Measured Imps / Imps)

The percentage of impressions that were viewable out of the total number of impressions measured for viewability. (Viewed Imps / View Measured Imps)