---
title: "Specific Reports and Calculations"
slug: "specific-reports-and-calculations"
updated: 2025-04-10T20:17:38Z
published: 2025-04-10T20:17:38Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://help.tritondigital.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Specific Reports and Calculations

> [!NOTE]
> Also see in the Triton Digital measurement and analytics knowledge base:
> 
> - [How to Add Podcast Categories to Measurement and Forecasting Reports](/user/docs/how-to-add-podcast-categories-to-measurement-and-forecasting-reports)
> - [Calculate monthly eCPM when you have both CPM and CPS flights](/user/docs/calculate-monthly-ecpm)
> - [How to Calculate Current Month STR](/user/docs/how-to-calculate-current-month-str)
> - [How to Add IAB Category to your TAP Explore Export](/user/docs/how-to-add-iab-category-to-your-tap-explore-export)

Below are a few examples of the types of reports you can create with TAP Explore. The real power of TAP Explore is evident when you export the data and apply formulas and calculations in Excel.

- [Example: Campaign Report](/v1/docs/specific-reports-and-calculations#example-campaign-report)
- [Example: Advertiser Ranking on Your Network, per Month](/v1/docs/specific-reports-and-calculations#example-advertiser-ranking-on-your-network-per-month)
- [Calculate monthly eCPM when you have both CPM and CPS flights](/v1/docs/specific-reports-and-calculations#calculate-monthly-ecpm-when-you-have-both-cpm-and-cps-flights)

## Example: Campaign Report

This report shows all campaigns for a specific advertiser. Use this when the advertiser wants to see everything they have booked on your network for a specific time range. The report is useful directly from export, but you can create pivots and rankings if you prefer.

**Query:**

- Select the **Impressions** setting.
- Select all relevant **stations,** the **date range**, and the **Advertiser Name** filter with the relevant advertiser selected in the filter.
- Select the following dimension: **Campaign**.
- **Run** the query to generate the report, then **export** the report to an Excel file.

![](https://cdn.document360.io/7124b381-0a94-401a-abbd-9df9c4ea5dff/Images/Documentation/Explore-CampRep-setup.png)

**Resulting exported report:**

**![](https://cdn.document360.io/7124b381-0a94-401a-abbd-9df9c4ea5dff/Images/Documentation/Explore-CampRep-export.png)**

## Example: Advertiser Ranking on Your Network, per Month

This report ranks the advertisers on your network.

**Query:**

- Select the **Impressions** setting.
- Select all relevant **stations,** and a **date range**.
- Select the following dimensions: **Month**, **Advertiser**.
- **Run** the query to generate the report, then **export** the report to an Excel file.

![](https://cdn.document360.io/7124b381-0a94-401a-abbd-9df9c4ea5dff/Images/Documentation/Explore-AdvRanking-setup.png)

**Resulting exported report:**

![](https://cdn.document360.io/7124b381-0a94-401a-abbd-9df9c4ea5dff/Images/Documentation/Explore-AdvRanking-export.png)

**Create the following pivot in Excel:**

- Add a new column ("<month> RANK") for each month included in your export, and apply the ranking formula to each column.

![](https://cdn.document360.io/7124b381-0a94-401a-abbd-9df9c4ea5dff/Images/Documentation/Explore-AdvRanking-pivot.png)
- From here, you can create various charts and graphs in Excel.

![](https://cdn.document360.io/7124b381-0a94-401a-abbd-9df9c4ea5dff/Images/Documentation/Explore-AdvRanking-chart.png)

## Calculate monthly eCPM when you have both CPM and CPS flights

This item has moved to the [Triton Help Center knowledge base](/user/docs/calculate-monthly-ecpm).