Deal Report

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. 

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. 

How it Works

You can access the Deal Report from the Reporting tab based on your assigned role in Buzz. 

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. 

Dimensions

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.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.