---
title: "How to Add IAB Category to your TAP Explore Export"
slug: "how-to-add-iab-category-to-your-tap-explore-export"
updated: 2025-04-10T20:07:05Z
published: 2025-04-10T20:07:05Z
---

> ## 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.

# How to Add IAB Category to your TAP Explore Export

## Why Include IAB Categories in Your Direct IO Reporting?

- Gain clarity on who is investing in your Direct IO revenue channel.
- Compare your top 10 IAB categories with the industry's biggest ad spenders to identify new growth opportunities.
- See if the top-spending industries are aligned with your top 10 categories; if not, it may be time to refocus your strategy.

## TAP Explore Query

Make sure you have the **Advertiser ID** as well as **Advertiser Name** as you will use the Advertiser ID as your lookup value.

In the example used in this article, we will look at the past 365 days delivery and delivered revenue net per industry and stations, broken down per month.

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

## TAP

**Extract IAB Category:**

In TAP’s **Advertiser** tab, download your advertiser list by selecting **Export all data as CSV**.

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

The Export will contain the following fields:

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

The fields you will carry over to your TAP Explore Export are:

- Advertiser ID
- Advertiser name
- Type
- Reseller name
- IAB categories

> [!NOTE]
> **Reseller** type advertisers will not have categories.

## Adding IAB Categories to the TAP Explore Export

- In the **TAP Explore** export file, add a tab and name it **TAP UI Adv**.
- Copy the five fields identified above to this new tab.
- In the REPORT tab:
  - Add a column to the right of the **Advertiser Name** column; name it **IAB Category.**
  - Add a column to the right of **IAB Category**; name it **Advertiser Type** (this lets you quickly identify inventory that your reach extension partner sold, and filter it out of your pivot table later).
- In the **IAB Category** column, insert a **vlookup** formula where:
  - **Lookup_value** is Advertiser ID.
  - **Table_array** is the **TAP UI Adv** tab including columns for **Advertiser ID** and **IAB Categories** inclusively (make sure Advertiser ID is the first column, and make this an absolute reference, so it remains unchanged as you carry the formula down the report).
  - **Col_index_number:** the column number **IAB Categories**is in.
  - **Range_lookup** is **FALSE (Exact Match)**.
  - It will look something like this: ![](https://cdn.document360.io/7124b381-0a94-401a-abbd-9df9c4ea5dff/Images/Documentation/TapEx-add-IAB-insert-formula-1.png)
- In the **Advertiser Type** column insert the same **vlookup** formula, changing **Col_index_number** to `3`.
  - =VLOOKUP(B2; ‘TAP UI Adv’ $A$1:$E$115;**3**;false)
- Your Report tab should now look like this: ![](https://cdn.document360.io/7124b381-0a94-401a-abbd-9df9c4ea5dff/Images/Documentation/TapEx-add-IAB-insert-formula-2.png)
- You can now start pivoting.

## Possible Pivots

1. Sum of Impressions delivered and Revenue Net by category, by station.
2. Average revenue by IAB category.
3. Average Station revenue by IAB category.![](https://cdn.document360.io/7124b381-0a94-401a-abbd-9df9c4ea5dff/Images/Documentation/TapEx-add-IAB-pivots.png)

## Final Recommendations

- Save and schedule monthly (choose “Last Month” in TAP Explore date range).
- Create an excel template so calculation will be automated to the most recent data.
- Create a Master document where you will copy monthly IAB category results (from the template).
- Each month add to Master doc in new tab to see changes month after month.