Table of Contents
Overview
Deals in programmatic ad-buying allow buyers and sellers to negotiate a price and terms for inventory that could either be directly purchased or available through auctions.
How it Works
The Deal Report simplifies troubleshooting and deal diagnostics to determine whether deals managed through the Deals Page are receiving bids and actively transacting.
By default, the Deal Report aggregates metrics at the Deal level, but can also be split out by Account, Campaign, and Line Item. It provides end-to-end visibility of all metrics for a given Deal such as Auctions, Bids, and Impressions. This also enables forecasting QPS for specific deals.
The Deal Report is aggregated at the deal level and reports on metrics such as spend, vendor fees, impressions, bids, and auctions.
Currently, Deals Report relies on the Deals page to determine eligibility for this report. Only deals that are available on the Deals page can be aggregated. As of now, Deals Report does not include location dimensions of the deal (such as platform, geo, and so on). However, it shows information about the associated:
- Account
- Advertiser
- Campaign
- Line Item
- Creative
Additionally, Deal Report focuses on a few other deal-specific fields that are accessible in the report including:
- Deal Name
- Deal Alternative ID
- Exchange Handle for the Deal
- Deal Format
These are derived from the Deal Object setup on the Deals page.
Deal Report Implications or Nuances
- A deal can be eligible for multiple line items. Therefore, auctions can be duplicated across rows(a given Bid Request can contain multiple deals).
- For Bids/Impressions, only the targeted/matched deal gets reported.
- The Deal Report also shows deals with zero auctions.
- Based on the grouping in the report, auctions get de-duplicated.
- Auction data is based on an approximate 1% sample extrapolated to 100%.
Dimensions
Lookback range is limited to 6 months.
| Alternative ID: Customer Alternative Deal ID |
| Deal Format: Format of the deal (e.g. video) |
| Exchange Handle: Name of the Ad Exchange |
| Name: Name of the deal |
Measures
| Auctions: | Number of auctions received |
| Bids: | Number of bids submitted to exchange(s) |
| Impressions: | Number of impressions counted |
| Media Spend: | Billable Spend on Media: Inventory Cost + Discrepancy allowance + Beeswax Media Seat Fee in local currency |
| Media Spend USD: | Billable Spend on Media: Inventory Cost + Discrepancy allowance + Beeswax Media Seat Fee in USD$ |
| Spend: | Media Spend + Vendor Fees in local currency (when 'Spend with Vendor Fees' is selected as the 'Budget Type' on the Line Item. If 'Spend' is selected, this will equal 'Media Spend') |
| Spend USD: | Media Spend + Vendor Fees in USD$ (when 'Spend with Vendor Fees' is selected as the 'Budget Type' on the Line Item. If 'Spend' is selected, this will equal 'Media Spend') |
| CPM: | Cost per 1000 impressions |
| CPM USD: | Cost per 1000 impressions - in USD |
FAQ
Q: Is Deal Report available via the API?
A: Yes, v2 Reporting API supports Deal Report. See here for more on Deal APIs.
Q: Can we get Non-Deal Library Deals in the Deal Report?
A: Only deals that are created on the Deals page will be in the Deal Report. Deals that are created in a deal list are not supported in the Deals Report.
Q: What is the first day of Data in the Deal Report?
A: Deal report data was filled starting January 23rd, 2022.