---
agentTools:
  projectIndex: https://deal-portal-user-man.readme.io/llms.txt
---

# Deal Reporting

# Prerequisite

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

* You are logged into the Deal Portal.\
  See <a href="https://developers.smaato.com/getting-started/logging-into-the-deal-portal/" target="_self" rel="noopener">Logging into the Portal</a>
* Deal must be in Running or Active state.\
  See <a href="https://developers.smaato.com/getting-started/accessing-your-deal-portal-dashboard/#running-a-deal" target="_self" rel="noopener">Running a Deal</a>

# Accessing the Reporting page

* To access the <strong>Reporting</strong> page, click the  [<img src="https://i.imgur.com/L1ptoIJ.png" alt= "Reporting Icon" style="width:84px; height:14px; vertical-align:middle;" />]() on the left navigation menu of the main <strong>Deal Dashboard</strong> page.

# Overview

<p>The<strong> Reporting Dashboard</strong> allows you to view detailed metrics related to advertising performance. It helps track key performance indicators (KPIs) such as <strong>Spend/Revenue</strong>,<strong> eCPM</strong> , <strong>Impressions</strong>, and <strong>Win Rate</strong>. It includes filter options to generate customized reports based on specific criteria, such as the A<strong>dvertiser</strong>, <strong>DSP</strong> , <strong>Deal Name</strong> or <strong>Deal ID</strong>, <strong>Trafficker/Ad ops</strong>, <strong>Sales Person</strong>, and <strong>Day Range</strong>.</p>

# Deal Reporting Function

The Reporting Dashboard provides the following key functions:

## Filter

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

* <strong>Advertiser</strong>: Choose the advertiser whose data you wish to view.
* <strong>DSP</strong>: Select the Demand-Side Platform (DSP) associated with your data.
* <strong>Deal Name/ID</strong>: Filter reports by deal name or deal ID.</li>
* <strong>Trafficker/Ad Ops</strong>: Choose the trafficker or ad operations team managing the deals.
* <strong>Sales Person</strong>: Filter the report based on the sales personnel responsible.</li>
* <strong>Day Range</strong>: Select the desired period for which you want to run the report, such as the last 1 day, last 7 days, or last 30 days.

[block:image]
{
  "images": [
    {
      "image": [
        "https://files.readme.io/11c53aa966433c970ce688422dac67bdef0fe1e78a2d3356abff3de6fc578fbb-Filter_dropdown_menu.png",
        "",
        "**Filter your deal report**"
      ],
      "align": "center",
      "border": true,
      "caption": "**Filter Report**"
    }
  ]
}
[/block]

## Key Metric

These key performance indicators provide a snapshot of your deal performance.

* <strong>Spend/Revenue</strong>: Displays the total amount spent or revenue generated over the selected period
* <strong>eCPM</strong>: The effective Cost per Thousand Impressions (eCPM) based on the selected data.\</li
* <strong>Impressions</strong>: Shows the number of impressions served during the specified timeframe
* <strong>Win Rate</strong>: Indicates the percentage of wins in relation to the total bids.

[block:image]
{
  "images": [
    {
      "image": [
        "https://files.readme.io/f56d3cac5859afc70dc4dad813f0479b9fecfacfd35a77adfd259c21a23f1b03-Show_Filtered_Total.png",
        "",
        "**Showing Filtered Total**"
      ],
      "align": "center",
      "border": true,
      "caption": "**Showing Filtered Total**"
    }
  ]
}
[/block]

## Visualization

This graph displays the <strong>Spend</strong>/<strong>Revenue</strong> over the chosen date range. It helps 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.

[block:image]
{
  "images": [
    {
      "image": [
        "https://files.readme.io/337be5afe21d2dffc6f270423a70426a227846d401d300e795676544d7073d0f-Graph_Spend_Revenue.png",
        "",
        "**Graph Spend Revenue**"
      ],
      "align": "center",
      "border": true,
      "caption": "**Graph Spend Revenue**"
    }
  ]
}
[/block]

## View Deal Column

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

<table style="border-collapse: collapse;width: 60%;height: 336px;margin: 0 auto">
<tbody>
<tr style="height: 24px">
<td style="width: 50%;height: 24px"><strong>Column</strong></td>
<td style="width: 50%;height: 24px"><strong>Description</strong></td>
</tr>
<tr style="height: 24px">
<td style="width: 50%;height: 24px">Buyer Name</td>
<td style="width: 50%;height: 24px">The name of the buyer</td>
</tr>
<tr style="height: 24px">
<td style="width: 50%;height: 24px">Buyer ID</td>
<td style="width: 50%;height: 24px">The identifier associated with the buyer</td>
</tr>
<tr style="height: 24px">
<td style="width: 25%;height: 24px">Deal Name</td>
<td style="width: 25%;height: 24px">The name of the deal.</td>
</tr>
<tr style="height: 24px">
<td style="width: 25%;height: 24px">Deal ID</td>
<td style="width: 25%;height: 24px">The unique identifier of the deal</td>
</tr>
<tr style="height: 24px">
<td style="width: 25%;height: 24px">Deal Type</td>
<td style="width: 25%;height: 24px">Specifies the type of the deal (for example Open Deal).</td>
</tr>
<tr style="height: 24px">
<td style="width: 25%;height: 24px">DSP</td>
<td style="width: 25%;height: 24px">Displays the DSP associated with the deal.</td>
</tr>
<tr style="height: 24px">
<td style="width: 25%;height: 24px">Advertiser</td>
<td style="width: 25%;height: 24px">Displays the name of the advertiser associated with the campaign</td>
</tr>
<tr style="height: 24px">
<td style="width: 25%;height: 24px">Seat Name</td>
<td style="width: 25%;height: 24px">Indicates the seat ID (for example 3103) for the campaign, representing the specific account or seat within the platform</td>
</tr>
<tr style="height: 24px">
<td style="width: 25%;height: 24px">Start Date</td>
<td style="width: 25%;height: 24px">The starting date of the deal.</td>
</tr>
<tr style="height: 24px">
<td style="width: 25%;height: 24px">End Date</td>
<td style="width: 25%;height: 24px">The ending date of the deal.</td>
</tr>
<tr style="height: 24px">
<td style="width: 25%;height: 24px">Status</td>
<td style="width: 25%;height: 24px">Shows the current status of the deal.</td>
</tr>
<tr style="height: 24px">
<td style="width: 25%;height: 24px">Impressions</td>
<td style="width: 25%;height: 24px">This column shows the total number of impressions served during the deal.</td>
</tr>
<tr style="height: 24px">
<td style="width: 25%;height: 24px">Bid Requests</td>
<td style="width: 25%;height: 24px">Indicates the number of bid requests made during the deal.</td>
</tr>
<tr style="height: 24px">
<td style="width: 25%;height: 24px">Bids</td>
<td style="width: 25%;height: 24px">Displays the total number of bids made in the deal.</td>
</tr>
<tr style="height: 24px">
<td style="width: 25%;height: 24px">Bid Rate</td>
<td style="width: 25%;height: 24px">Shows the rate at which bids were made during the deal.</td>
</tr>
<tr style="height: 24px">
<td style="width: 25%;height: 24px">Win Rate</td>
<td style="width: 25%;height: 24px">Represents the percentage of successful bids to the total bids.</td>
</tr>
<tr style="height: 24px">
<td style="width: 25%;height: 24px">eCPM</td>
<td style="width: 25%;height: 24px">Represents the effective cost per mille.</td>
</tr>
<tr style="height: 24px">
<td style="width: 25%;height: 24px">Spend</td>
<td style="width: 25%;height: 24px">The amount spent in the deal.</td>
</tr>
<tr style="height: 24px">
<td style="width: 25%;height: 24px">Trafficker/ad ops</td>
<td style="width: 25%;height: 24px">The personnel or team responsible for managing the traffic or operations for the campaign.</td>
</tr>
<tr style="height: 24px">
<td style="width: 25%;height: 24px">Salesperson</td>
<td style="width: 25%;height: 24px">Indicates the salesperson associated with the deal.</td>
</tr>
<tr style="height: 24px">
<td style="width: 25%;height: 24px">Created By</td>
<td style="width: 25%;height: 24px">Displays who created or initiated the deal.</td>
</tr>
</tbody>
</table>
<p>&nbsp;</p>
<p id="view-deal-details">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.</p>

[block:image]
{
  "images": [
    {
      "image": [
        "https://files.readme.io/b18b4d04cf325d4df0907e60cb7f9adab8757df8cbb19fdbfe7aa4642a88ec24-View_Deal_Column.gif",
        "",
        "**View Deal Column**"
      ],
      "align": "center",
      "border": true,
      "caption": "**View Deal Detail**"
    }
  ]
}
[/block]

# Deal Reporting Workflow

To generate the report for the deal, follow these steps:<li><strong>Apply Filters</strong></li><ul>

<ul style="list-style-type: circle">
	<li>Begin by selecting the desired <strong>filters</strong> at the top of the page:

<ul style="list-style-type: square">
	<li><strong>Advertiser</strong>:  From the <strong>Advertiser</strong>  dropdown,  select the advertiser name you want to view the data or use the search box to set your filter.</li>
	<li><strong>DSP</strong>: From the<strong> DSP</strong> dropdown, select the Demand-Side Platform (DSP) associated with your report or use the search box to set your filter.</li>
	<li><strong>Deal Name/ID</strong>: From the <strong>Deal name/ID</strong> dropdown, select the deal name or ID to search on a specific deal or use the search box to set your filter.</li>
	<li><strong>Trafficker/Ad ops</strong>:  From the <strong>Trafficker/Ad ops</strong> dropdown, select the relevant traffic or ad operations team or use the search box to set your filter.</li>
	<li><strong>Sales Person</strong>: From the <strong>Sales Person</strong> dropdown , select the sales person or use the search boxes to set your filter.</li>
	<li><strong>Day Range</strong>: Use the <strong>Day Range</strong> dropdown to select a day range for the report (for example, Last 7 Days).</li>
</ul>
</li>
</ul>
</li>
</ul>

</ol>

[block:image]
{
  "images": [
    {
      "image": [
        "https://files.readme.io/68c8a47d750b9c7bba102cd1bd7b169178ed9a28c30f11a053711290fd415dcf-Filter_Deal_Report.png",
        "",
        "**Filter Deal Report**"
      ],
      "align": "center",
      "border": true,
      "caption": "**Filter Deal Report**"
    }
  ]
}
[/block]

<ol start="2">
	<li>The <strong>Selected Filters</strong> appear as tags below the filter bar. </li>
</ol>

[block:image]
{
  "images": [
    {
      "image": [
        "https://files.readme.io/6f6d0c4cbbc64a91b99f9221a0cfc8a0907ede5eee11cb4a9f87e2302e505e9e-Selected_Filter.png",
        "",
        "**Selected Filters**"
      ],
      "align": "center",
      "border": true,
      "caption": "**Selected Filters**"
    }
  ]
}
[/block]

<ol start="3">
	<li>To remove any filter, click the <strong> x</strong> icon next to the selected tag.</li>
</ol>

[block:image]
{
  "images": [
    {
      "image": [
        "https://files.readme.io/cbc43b73bcc78ab3bae626c52193031299bc252006b8b7b6f8ee88b52b70cbd6-Remove_any_selected_filter.png",
        "",
        "**Remove any Selected Filter**"
      ],
      "align": "center",
      "border": true,
      "caption": "**Remove Selected Filter**"
    }
  ]
}
[/block]

<ol start="4">
	<li>To reset all selected filters, click <strong>Reset Filters</strong>.</li>
</ol>

[block:image]
{
  "images": [
    {
      "image": [
        "https://files.readme.io/0e2b7cfe026b7bb6f00f757086793f780f4df5810ceeb156275e06ada8a2ecba-Remove_all_filters.png",
        "",
        "**Remove or Reset All Selected Filters**"
      ],
      "align": "center",
      "border": true,
      "caption": "**Reset All Selected Filters**"
    }
  ]
}
[/block]

<ol start="5">
	<li>Once filters are selected, click the <strong>Run Report</strong> button to generate the report.</li>
</ol>

[block:image]
{
  "images": [
    {
      "image": [
        "https://files.readme.io/299d06ca175c1dd176d29202282a978851586ffb049a3ce1f2b1781bfcf0881c-Run_Button.png",
        "",
        "**Run Report**"
      ],
      "align": "center",
      "border": true,
      "caption": "**Run Report**"
    }
  ]
}
[/block]

<ol start="6">
	<li>The top section displays key metrics. see the <strong>Figure</strong>:<a href="#key-metric"> Showing Filtered Total</a>
<ul style="list-style-type: circle">
	<li><strong>Spend/Revenue</strong>: Total spend or revenue.</li>
	<li><strong>eCPM</strong>: Effective Cost Per Mille (cost per 1,000 impressions).</li>
	<li><strong>Impressions</strong>: Total number of ad impressions.</li>
	<li><strong>Win Rate</strong>: Percentage of successful ad bids.</li>
</ul>
</li>
	<li>Below the Showing Filtered Totals, the <strong>Spend/Revenue</strong> graph provides a visual representation of the spend and revenue over time. see the <strong>Figure</strong>:<a href="https://deal-portal-user-man.readme.io/reference/untitled#visualization"> Graph Spend Revenue</a></li>
	<li> Use the <strong>Select Columns to view</strong> dropdown to customize the columns that will be visible.  For column description, see the <a href="https://deal-portal-user-man.readme.io/reference/untitled#view-deal-column"> View Deal Column</a></li>
</ol>

[block:image]
{
  "images": [
    {
      "image": [
        "https://files.readme.io/8700fe3067e1dd713914ca6952c5479de33ecd27cea6854fd5608da44056eb08-Select_Columns_to_view_Deal_detail.gif",
        "",
        "**Select Columns to view**"
      ],
      "align": "center",
      "sizing": "250px",
      "border": true,
      "caption": "**Select Columns to view**"
    }
  ]
}
[/block]

<ol start="9">
	<li>Scroll to the table under the graph to view detailed deal information. See Figure <a href="#view-deal-details">Viewing Deal Detail</a></li>
</ol>
<ol start="10">
	<li>Click the <strong>Export Deal Report</strong> button to download the deal report in csv format for offline analysis.</li>
</ol>
<ol start="11">
	<li>The view of deal report in csv format appears as below:</li>
</ol>

[block:image]
{
  "images": [
    {
      "image": [
        "https://files.readme.io/a41fa175a7bc60ef2149f03ae1e2fdee221f7eb994f1c0cf7e4e106ca3c9c3ff-Excel_View.gif",
        "",
        "**View Deal Report in CSV format**"
      ],
      "align": "center",
      "border": true,
      "caption": "**View Deal Report in CSV format**"
    }
  ]
}
[/block]