Buyer transparency feed

The Buyer Transparency Feed provides advertisers with the most granular insights about transactions that occurred on supply. Those insights include the bid that was submitted, the inventory that was sold, the auction that was run, as well as the tech fees and revenues that ended up with the exchange and the seller. The feed provides 28 datapoints for each impression that was served.

Currently, more than 60% of our direct seller transactions globally—and 85% in the US—are fee transparent.

For most auctions, there will be 1 row with all columns populated (fee columns will not be populated if the seller is not transparent). For Guaranteed Outcomes auctions, where the buyer is buying on an event basis (e.g., such as views or video completion), there can be 1 or 2 rows for the same auction. This will be determined by the following:

  • For Guaranteed Outcomes auctions, where the buyer wins the auction and their creative is rendered, there will be 1 row that contains columns 1-10 (all columns).
  • If the buyer’s required outcome (e.g., a view or complete) occurs, there will be another row that will include columns 1-7 and 10.

The Xandr internal name for this feed is brand_transparency_feed.

Sequence

The columns below are listed in the same order in which they appear in the log-level feed file (top to bottom here, left to right in the file).

Integer key

  • tinyint = 1 byte (8 bit)
  • smallint = 2 byte (16 bit)
  • int = 4 byte (32 bit)
  • bigint = 8 byte (64 bit)

Columns

Note

Microsoft Advertising may need to remove values for certain log level data (LLD) fields in order to comply with current data sharing restrictions.

Column Index Column Name Type Description
1 date_time UNIX Epoch time The date and time of the transaction (e.g., 1526057561 which would need to be translated to Friday, May 11, 2018 4:52:41 PM (UTC)) .
2 partition_time_millis bigint Auction timestamp in milliseconds.
3 auction_id_64 bigint The auction ID (bid.request.imp.id) generated by the Xandr exchange. Value is unique for a given hour (counter is reset each hour).
4 buyer_member_id int The ID of the buyer member within Xandr that bid on this inventory.
5 buyer_member_name string The name of the buyer associated with the buyer member ID.
6 bidder_id int The ID of the DSP that bid on this inventory.
7 bidder_name string The name of the DSP associated with the Bidder ID.
8 inventory message Information about the inventory being purchased. See Inventory for more details.
9 bid message Information about the bid. See Bid for more details.
10 result message Information about the final costs and revenue results. See Result for more details.
11 external_bidrequest_id bigint A unique identifier for the bid request. This ID is often generated by the exchange (or the platform making the request) to distinguish and track individual bid requests. Demand side platforms (DSPs) can use this identifier to associate a response with the corresponding bid request.
12 external_bidrequest_imp_id bigint A unique identifier for the impression within the bid request. Each impression in a bid request has its own ID, allowing advertisers and demand side platforms (DSPs) to reference and submit bids for a specific impression. This field helps identify which impression a bid pertains to.

Inventory

Column Index Column Name Type Description
1 site_domain string The top-level domain of the website.
2 exchange string The name of the exchange selling the inventory.
3 seller_member_id int The ID of the selling member within the Xandr exchange.
4 seller_name string The name associated with the Seller member ID.
5 tag_id int The ID of the tag that was registered with Xandr.
6 supply_type tinyint The type of supply. Possible values are:
- 0 - Web
- 1 - Mobile Web
- 2 - Mobile App
7 device_type tinyint The type of device on which the impression is served. Possible values are
- 0 - Other
- 1 - Desktop/laptop
- 2 - Mobile phone
- 3 - Tablet
- 4 - TV
- 5 - Game console
- 6 - Media player
- 7 - Set top box
8 country string The country where the inventory was sold.
9 auction_type enum The auction type (first price or second price). Possible values are:
- 1 - FIRST_PRICE - The auction is a first price auction
- 2 - SECOND_PRICE - The auction is a second price auction
10 ads_txt_certification enum Whether or not this seller is authorized to sell the inventory according to ads.txt. Possible values are:
- 1 - domain_data_unavailable
- 2 - seller_unauthorized
- 3 - seller_authorized

Bid

Column Index Column Name Type Description
1 bid_amount numeric Gross bid from the buyer (including tech fees).
2 creative_id int Creative ID submitted on the bid response.
3 deal_id int Deal ID submitted on the bid response.
4 clearing_event_id int The commodity being bought; either impressions or one of the Guaranteed Outcomes clearing events. Possible values are:
- 1 - IMPRESSIONS
- 2 - VIEWS - STANDARD DISPLAY
- 6 - VIEWS - CUSTOM DISPLAY - 100pv1s
- 8 - VIEWS - STANDARD VIDEO
- 9 - VIEWS - CUSTOM VIDEO - 100pv50pd
- 10 - COMPLETES - STANDARD COMPLETE
5 media_type tinyint The general display style of the creative, classified by media subtype. To map media subtype IDs to their names and parent media types, use the Media Subtype Service. Two common values are:
- 1 - BANNER
- 64 - VIDEO
6 external_campaign_id string The campaign identifier passed in by external DSPs on their bids.
7 insertion_order_id int32 The ID of the insertion order (in Invest).
8 bidder_seat_id int32 The DSP's identifier for a buyer (including external DSPs).
9 bidder_seat_name string The name of the buyer corresponding to the bidder_seat_id.

Result

Column Index Column Name Type Description
1 gross_media_ cost numeric Cost charged to the buyer inclusive of all tech fees. Total Media Cost plus any tech fees specified in the buyer’s contract applied outside the auction.
2 total_media_cost numeric Final amount that the buyer owes Xandr for the media that was purchased in this auction.
3 exchange_ revenue numeric Amount destined towards the Xandr exchange. Total Media Cost less any tech fees specified in the buyer’s contract applied as a part of the auction.
4 exchange_cost numeric Amount destined towards the seller. Exchange Revenue less any tech fees that the exchange must collect for running this auction.
5 seller_revenue numeric Revenue that the seller will make for selling this media. Exchange Cost less any tech fees specified on the seller’s contract applied as a part of the auction.
6 net_seller_revenue numeric Net revenue paid to the seller. Seller Revenue less any tech fees specified in the seller’s contract applied outside the auction.
7 sasc_cap_savings double Savings from applied SASC cap (e.g., 0.50).