BI (Business Intelligence) tab (Pro account)

The BI tab in the analytics module is a full OLAP (Online analytical processing) system where users can view and analyze their account data from different points of view.

The BI tab with its filters & dimensions allows users to build as many cross-sections as required, for better-analyzing data, insights, and better performance. The data is presented in real-time (there could be a delay of five minutes).

1. Go to Analytics module -> BI tab. The default view will be 'Today' (as the date range), 'Time' (dimension), and time granularity 'None'.
   You can choose your filters, and dimensions and press 'Go'.
2. The data is shown for all media types by default. Users can use the ‘Ad Type’ filter, to fine-tune the data per ad type and enhance the available metrics for each filtered type.
3. The time granularity can be added (monthly/daily/hourly), as well as controlling the number of records in the results set, ranging between 500 (=default) to Max.
4. For each query, the user can see the calculated sums, per his chosen date range & filters.
5. You can view data in a single domain/app_bundle scope only:
   1. Press the 'Add Filter' in the quick menu to filter by the entity, then press the GO button.
   2. Press the 'Show graph': The graph shown, displays the results for the current day, yesterday, and the same weekday in the previous week.
      The graph results are updated till the last hour.
6. Users can either download or mail the results set.
   The results set grid's columns can also be customized per the user's preferences.
7. Use the quick menu for all entities, to filter by the entity, copy the entity name or ID, and present a performance comparison graph for the entity (comparing Today, Yesterday, and last week). You can also use the 'Collect Values to Clipboard' to collect ID's/Names values to be copied as a group of values.
   
   
   

Filters & Dimensions:

You can filter the data by the following filters. The data can be presented and organized by chosen dimensions (capsules) you can choose a few dimensions together.

1. Advertiser

2. Inventory

3. Publisher

4. App Bundle

5. Domain

6. App or Site

7. Ad Type

8. Ad Size

9. Browser

10. Device

11. OS

12. Country

Metrics:

You will get the following metrics from the chosen filters and dimensions.

1. Incoming Requests - all the requests that have entered the system.

2. Bids - all the bid responses from advertisers.

3. Win Notices - win notification event called by the upstream exchange (supply partner) if the bid wins.

4. BURL (hidden on default) - Bill event called by the upstream exchange (inventory partner) when a winning bid becomes billable

5. Filtered IVT (%) - filtered IVT /incoming requests * 100

6. Page Imp (hidden on default) - An imp counted on page load

7. Imp - total impressions that were reported whenever an individual ad was displayed.

8. MRAID imp (hidden on default) - An imp that was generated by the MRAID event

9. Video Imp - the number of times the video player was loaded. 

10. Clicks - for standard content ads a click is counted when the user clicks on the ad.

11. Gross Spend - Spend before deducting the tech fee.

12. Spend - the spend for advertisers.

13. Revenue - the revenue for inventory partners.

14. Profit - The margin calculated after deducting the revenue from the spend.
15. Margin (%) - (Profit/Spend)*100