# Reporting interfaces  / BI

{% hint style="info" %}
In reporting interfaces, the visits (unique) stats are updated in minutes, however, registrations and/or financial information are based on the frequency of file imports or data pushed to TAP by the platform.
{% endhint %}

## Registrations Report

Registration report is a granular level report, showing each specific user/player per row.\
You can find the registration report:

* in the **affiliate profile** (report will show only registrations assigned to this affiliate). Results in the list can be filtered out by different criterias<br>

  <figure><img src="https://2789002490-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkbip9hFgRFwIv4mXJPnz%2Fuploads%2F16pb81tABMe77wRM2fnS%2Fimage.png?alt=media&#x26;token=a25f8fae-2a89-4279-b9f4-0ab11314fc18" alt=""><figcaption></figcaption></figure>

* in the **Registrations** menu (report will show all registrations). Results in the list can be filtered out by different criterias

<figure><img src="https://2789002490-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkbip9hFgRFwIv4mXJPnz%2Fuploads%2FFDygnw9OQbGs1t4bZ3oN%2Fimage.png?alt=media&#x26;token=41ee3111-7eb9-4c74-a2e6-fda3273947f0" alt=""><figcaption></figcaption></figure>

\
The **Registrations** report includes the following data:

* External user ID, TAP user ID + Registration Date + Brand + Username (if sent to TAP by the platform) + Affiliate)
* Qualification date&#x20;
* Net deposit amount, FTD amount + date, Deposits count&#x20;
* Withdrawals amount&#x20;
* P\&L (GGR)&#x20;
* Net P\&L (NGR) - This value is a calculated field = (total\_bets)-(total\_wins)-(bonuses)-(deductions)&#x20;
* Volume (total bets, also used as a qualification rule for CPA deals)
* Commission

\
The registration report can be sorted by any of the fields presented as column names.

You can search by user ID (external ID or TAP ID with @1234), by username, email, tracker and country (2 letter code)

#### Adding filters to Registration report:

1. Click on the triangle icon on the top right of the report
2. Choose additional filter:

* Brand
* Link&#x20;
* Commission range - Filter by amounts of commission generated from user/player
* Deal type (CPA, CPA+Revshare Net P\&L, CPA+CPL, etc.)&#x20;
* Has Commission (yes/no)&#x20;
* Blocked for CPL
* Blocked for CPA
* Registration status - If applicable (Duplicate, Fraud, Self-excluded etc). The platform provider should sent the abovementioned statuses&#x20;
* FTD date&#x20;
* AFP/UTM - Search by specific dynamic parameter used when sending the traffic&#x20;
* Campaign/Source ID/ Deal group ID

<figure><img src="https://2789002490-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkbip9hFgRFwIv4mXJPnz%2Fuploads%2F6QV3OexBd4l6mxGjyB2T%2Fimage.png?alt=media&#x26;token=2bbf8c58-38c7-41a7-acdb-2227ff426000" alt=""><figcaption></figcaption></figure>

#### Exporting registration report:

Click on the *Export* button on the top right corner. \
Export process will be started and when completed, email with download link will be sent to your email address.&#x20;

{% hint style="success" %}
The fields available to the affiliate in the registration report are controlled by the “additional permissions” list in the Affiliate Account.\
Check [Additional permissions](https://help.theaffiliateplatform.com/affiliate-platform/affiliate-account#additional-permissions) for more details.
{% endhint %}

<figure><img src="https://2789002490-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkbip9hFgRFwIv4mXJPnz%2Fuploads%2Fxh23hiVHpif3BQfqEY75%2Fimage.png?alt=media&#x26;token=4e348906-8edb-4c9a-9e1d-d0e8b14558e4" alt=""><figcaption></figcaption></figure>

### Player Profile&#x20;

By clicking on a player row in the registration report you will access the Player Profile with all the aggregated information for the player.<br>

<figure><img src="https://2789002490-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkbip9hFgRFwIv4mXJPnz%2Fuploads%2FFh9iUNla1aiT0dvG2ZhP%2Fimage.png?alt=media&#x26;token=8d04c6bb-217f-4af7-8cfb-7f044bd0fab2" alt=""><figcaption></figcaption></figure>

<figure><img src="https://2789002490-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkbip9hFgRFwIv4mXJPnz%2Fuploads%2FzzRqEpT2nxm6FYEm4OTv%2Fimage.png?alt=media&#x26;token=35323f8b-4e79-4085-a9b1-a47643b3d0e9" alt=""><figcaption></figcaption></figure>

## Media Report

Media report is designed to show results by different channels and affiliates, with the ability of *grouping* or *filtering* by different dimensions.

<figure><img src="https://2789002490-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkbip9hFgRFwIv4mXJPnz%2Fuploads%2FYK0AVwxgXRgyUmbJ9O5f%2Fimage2.png?alt=media&#x26;token=80d3b1c4-8734-4deb-abb2-04bac0597f9b" alt=""><figcaption></figcaption></figure>

The media report is similar to a Pivot table in Excel. **Drag & Drop** the dimensions you want to filter, or group by into the report. \
\&#xNAN;*Filter by* when you want to individualize your report. *Group by* when you want to generalize your report

\
***For example:***&#x20;

\
Filter by a **time period**

<figure><img src="https://2789002490-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkbip9hFgRFwIv4mXJPnz%2Fuploads%2F6y1tavdpIel6KCKPtLhL%2Fimage1.png?alt=media&#x26;token=951f6c64-acc7-43ce-9500-dfcdfbe2e364" alt="" width="274"><figcaption></figcaption></figure>

&#x20;Group by **Period, Country, Affiliate** etc

<figure><img src="https://2789002490-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkbip9hFgRFwIv4mXJPnz%2Fuploads%2FBJ4Uen5gBj0IgAudBM7w%2Fimage33.png?alt=media&#x26;token=a0a23d8b-4f9a-450e-8313-e27284361510" alt="" width="563"><figcaption></figcaption></figure>

In the example below you can see a report for the current year (January - Today's Date), grouped by Month, and by Affiliate username:

<figure><img src="https://2789002490-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkbip9hFgRFwIv4mXJPnz%2Fuploads%2F8T4VZj1nSUaCCmFxLhkx%2Fimage47.png?alt=media&#x26;token=3d6cd208-6cd4-4554-9219-fede5ff3e8ae" alt=""><figcaption></figcaption></figure>

{% hint style="warning" %}
When you use Dimensions in *Group*, only 5 records will be shown per group by default.\
You can increase the limit of records shown by clicking on the dimension and selecting a higher limit.\
\
![](https://2789002490-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkbip9hFgRFwIv4mXJPnz%2Fuploads%2FyHYiNBgd43t0PDj4bSXD%2Fimage.png?alt=media\&token=bd559ff8-d535-4cc3-8521-5f2a317ec76c)
{% endhint %}

With the media report you can see results, for example:

* By specific landing pages (see [Destination Links](https://help.theaffiliateplatform.com/affiliate-platform/destination-links) and how to create landing pages)&#x20;
* By specific media banners, emails&#x20;
* By countries, languages&#x20;
* By AFP and/UTM Campaigns (see [Destination Links](https://help.theaffiliateplatform.com/affiliate-platform/destination-links) and how to grab a tracking link)&#x20;
* By specific promo codes (see [Promo codes](https://help.theaffiliateplatform.com/affiliate-platform/promo-codes) and how to create unique promo codes for affiliates&#x20;

-> **Add/remove** columns (measures) that you don't want to see in the report

***For example:*** \
Build a report only showing Net PnL/RevShare<br>

<figure><img src="https://2789002490-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkbip9hFgRFwIv4mXJPnz%2Fuploads%2FZ0QWhNc2QWblIZVcgvuE%2Fimage.png?alt=media&#x26;token=eb4bf03b-b205-47f0-bb50-d4b3a50f14b2" alt=""><figcaption></figcaption></figure>

Build a report only for Visits/Registrations/FTD to Lead, %/Deposits amount/Net P\&L

<figure><img src="https://2789002490-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkbip9hFgRFwIv4mXJPnz%2Fuploads%2Fmck1rlJkIatbSOmsf7dS%2Fimage.png?alt=media&#x26;token=ba375ae5-2270-476b-8bf4-83075c1bedb2" alt=""><figcaption></figcaption></figure>

#### Exporting Media Report&#x20;

To export Media Report in a .csv file, follow these steps:

1. Build your report
2. Tick "Collapse rows" to ensure tha all grouping columns will be exported
3. Click on the .csv icon&#x20;
4. Export will be downloaded on your device

<figure><img src="https://2789002490-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkbip9hFgRFwIv4mXJPnz%2Fuploads%2Fc6c58YdORphzBB9cB5YG%2Fimage.png?alt=media&#x26;token=6c681fd6-2064-4baf-87db-a6828e4d3b83" alt=""><figcaption></figcaption></figure>

#### Saving Reporting Views

Building a report can involve applying filters, add/remove measures, customizing the view to fit your specific needs. Instead of rebuilding the report every time, you can save the view for future use. \
This ensures you have a quick access to the data you need.\
\
To save Reporting Views, follow these steps:

1. Build the report you want&#x20;
2. Click on "Settings" icon on the top right corner&#x20;
3. Choose to save the view as *personal* (visible only to you) or *label* (visible to all team members of the operation who have access to the affiliate panel)
4. A modal will open for you to confirm the view name, click OK after
5. Saved view can be later found in "**Views**"

<figure><img src="https://2789002490-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkbip9hFgRFwIv4mXJPnz%2Fuploads%2Fkkx6OEMVYjcCugHjjmTm%2Fimage.png?alt=media&#x26;token=06098ebd-5bcb-4a6d-bae7-3b8843ec9c05" alt=""><figcaption></figcaption></figure>

## Pixel Log

The Pixel Log will show the operator all the history of the pixels fired back to the affiliates\
Pixel Log includes the following data:

* ID of player + Affiliate to whom pixel was fired
* Action on which pixel was fired (Lead, FTD etc.)
* Type of pixel
* Status (New, Failed, Delivered, Expired etc.)
* Date

Click on the triangle icon for more filtering options.

<figure><img src="https://2789002490-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkbip9hFgRFwIv4mXJPnz%2Fuploads%2FYMaTVQvIRN9iyyTNn2kc%2Fimage.png?alt=media&#x26;token=23df807e-4bb1-4062-9716-e1252de5c738" alt=""><figcaption></figcaption></figure>

Click on the small arrow to view the server response for the pixel:

<figure><img src="https://2789002490-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fkbip9hFgRFwIv4mXJPnz%2Fuploads%2FzvvsVCQ59568kpNPdRDq%2Fimage.png?alt=media&#x26;token=16056d89-7a8e-4865-8d1b-cfc6ec315dfc" alt=""><figcaption></figcaption></figure>
