Deal Reporting

• Overview
• Using the Deal Reporting page
  • Filter
  • Key Metric
  • Visualization
  • View Deal Column
• Prerequisite
• Accessing the Reporting page
• Deal Reporting Workflow

Overview

The Reporting Dashboard allows you to view detailed metrics related to deal performance. It keeps track of key performance indicators (KPIs), such as Spend/Revenue, eCPM, Impressions, and Win Rate. It includes filter options to generate customized reports based on specific criteria such as the Advertiser, DSP, Deal Name or Deal ID, Trafficker/Ad ops, Sales Person, and Date Range.

Using the Deal Reporting Page

The Reporting Dashboard provides the following key functions:

Filter

This section enables you to customize your reports by applying various filters. 

• Advertiser: Choose the advertiser whose data you want to view.

• DSP: Select the Demand-Side Platform (DSP) associated with your deal.

• Deal Name/ID: Filter reports by deal name or deal ID.

• Trafficker/Ad Ops: Filter based on the person or team managing the deals.

• Sales Person: Filter the report based on the sales personnel responsible.

• Date Range: Select the desired time period for which you want to run the report, such as custom dates, last 1 day, last 7 days, last 14 days or last 30 days.

📘

Note:

Deal ID filtering supports both Marketplace Deal ID and External Deal ID.

📘

Note:

If Custom Dates is selected, a calendar view will appear allowing you to define specific start and end dates.

Key Metric

The below key performance indicators provide a snapshot of your deal performance.

• Spend/Revenue: Displays the total amount spent or revenue generated over the selected period.
• eCPM: Displays the eCPM value based on the selected data.
• Impressions: Shows the number of impressions served during the specified timeframe.
• Win Rate: Indicates the percentage of wins in relation to the total bids.

📘

Note:

When you first land on the Reporting page, no filters are applied. You’ll see metrics for all deals under your buyer account.

Visualization

This graph displays the Spend/Revenue over the chosen date range. It helps you to visualize the trend and changes over time.

• Hover over the graph to see specific values for Spend/Revenue on different days.
• The graph is updated dynamically based on the filters applied.

View Deal Column

The data table below the graph presents a detailed breakdown of the filtered report. The key columns include:

You can scroll through the table to view more data. The pagination controls allow you to navigate through multiple pages if there are many records.

📘

Example:

If you show 50 rows per page and want to view or export row 52, navigate to page 2 to view it.

Prerequisite

Before running a deal report, ensure the following requirements are met:

1. You are logged into the Deal Portal.
   👉 See Logging into the Portal
2. Deal must be in Running or Active state.
   👉 See Running a Deal

Accessing the Reporting page

• In the left-hand menu of the Dashboard page, click the icon.

Deal Reporting Workflow

To generate report for the deal, follow these steps:

1. When you first land on the Reporting page, no filters are applied. The page will display aggregated metrics for all deals under your buyer account by default.

2. Apply Filters

   • Begin by selecting the desired filters at the top of the page:

     • Advertiser:  From the Advertiser  dropdown,  select the advertiser name you want to view the data or use the search box to set your filter.

     • DSP: From the DSP dropdown, select the Demand-Side Platform (DSP) associated with your report or use the search box to set your filter.

     • Deal Name/ID: From the Deal name/ID dropdown, select the deal name or deal ID to focus on a specific deal or use the search box to set your filter. You can enter either a Marketplace Deal ID or an External Deal ID - both are supported. The system will automatically match and return deals based on the ID you provide.

     • Trafficker/Ad ops:  From the Trafficker/Ad ops dropdown, select the relevant traffic or ad operations team or use the search box to set your filter.

     • Sales Person: From the Sales Person dropdown , select the sales person or use the search boxes to set your filter.

     • Date Range: Use the Date Range dropdown to select from preset options (e.g., Last 7 Days), or choose Custom Dates.

       

       • If you choose the Custom Dates, a calendar picker allows you to choose a custom start and end date

         

3. Your selected filters will appear as tags below the filter bar.

4. To remove a single filter, click the x icon next to the selected tag.

5. To clear all selected filters, click Reset Filters.

6. Click the Run Report button to generate the deal performance metrics based on applied filters.

7. The top section displays key metrics. see the Figure: Showing Filtered Total

   • Spend/Revenue: Total spend or revenue.
   • eCPM: Effective Cost Per Mille (cost per 1,000 impressions).
   • Impressions: Total number of ad impressions.
   • Win Rate: Percentage of successful ad bids.

8. The Spend/Revenue graph visualizes day-wise revenue trends. Hover over bars for daily values, see the Figure: Graph Spend Revenue

9. Click Select Columns to view and choose which columns to display in the deal table. For column description, see the View Deal Column.

10. Scroll down to view detailed deal metrics. Use pagination to move between pages. See Figure View Deal Details

11. Click the Export Deal Report button to download the data in csv format for offline analysis.

12. The preview of deal report in csv format appears as below:

📘

Note:

The export includes all filtered deals - not just those on the current page.