Reporting UI

To access the Reporting UI, click the REPORTING link in the menu of The MediaGrid UI. Analysis is based on key-value pairings, which you can use in combination to get the information you need from the underlying data, e.g.

  • By querying the data using country(key) / impressions(value) you will get the amount of impressions per country

  • By querying the data using two filters SSP(key) + Country{US}(Key) / iOS(value) you will get the Suppliers from which you are buying most iOS inventory in the US

Querying Campaign Data

To get the data for a particular campaign, and break it down by content type and line items, using the following steps.

  1. Select Edit Filters

  2. Define your first key-value, for example, campaign contains campaign_id_123

  3. Define the second key-value, for example Content Type equals Video and select Apply

  4. From the Category field, select Line Item. This will display the performance details of line items using video creatives.

  5. To add more of the available columns to the report, select more and enable additional columns. For more information about each column, see the Adding custom data columns section

Querying Country Data

To get an Supplier’s impression data broken down by country and region, use the following steps:

  1. Select Edit Filters

  2. From the Slices menu, configure your first key, for example: SSP contains example_ssp_name

  3. Configure the second key, for example Country equals US, and select Apply

  4. From the Category field, select Region

  5. Click the arrow_downward arrow beside Impressions

Getting Impressions per Publisher

  1. Select Edit Filters

  2. From the Slices menu, configure your first key, for example: SSP equals Example_Publisher

  3. From the Category field, select Publisher

  4. Click the arrow_downward arrow beside Impressions

Constructing Graphs from Reports

Once you have made a report, such as outlined in the examples above, you can add certain report fields to the graphing area and alter how the information is displayed. This allows you to present the information in a variety of ways.

  • To add fields to the graph, click on a row from the report data. This adds a coloured line beside any selected fields, and the colour corresponds to that value in the graph. By default an orange line representing the total will be show.

  • To alter the display type, select the assessment button to choose between column, line, or area

Adding custom data columns

  1. Select the more button in the upper right corner of the Data Table.

  2. Select +New Custom Column, which will open the custom input fields

  3. Enter your desired Title for the new Custom Data Column.

  4. Enter the formula that will make up the data displayed in the new Custom Data Column. You can do this by selecting the other column names and putting arithmetic operators (+,-*,/) between them to create your desired formula, e.g. (imps * 100)/ ssp_bid_requests

  5. Select whether it should be a private or shared column

  6. Select whether is should be an integer, float, or percentage

    • If you choose a float or percentage, select the number of digits to appear after the decimal point using the precision number

Bookmarking Reports

Bookmarking is how you save graphs or reports in u-Slicer. To do this, select the star_border on the page header to add a chart to your bookmarks:

  • This saves the current chart/report as a bookmark

  • Further changes to the graph need to be saved as a separate bookmark

Creating a Dashboard

A Dashboard is the simplest and most straightforward way to keep your reports at hand for easy access in u-Slicer itself. To add a report to a dashboard, use the following steps.

  1. Open the required report in u-Slicer.

  2. Use the Dashboard dropdown menu to access the list of existing dashboards or create a new dashboard.

  3. Use the Create new dashboard option and enter a name for the new dashboard if necessary.

  4. Use the Put current view into a dashboard option and select a dashboard for the currently opened report. Note: You can add multiple reports to the same dashboard.

Save data locally

In the u-Slicer UI you can export report data to either .xlsx or .csv files and open them on your computer.

To save the currently open report locally, use the Excel option for .xlsx or CSV option for .csv format. Both options can be found on the top of the data table, on the right side.

Export to Google Sheets

Alongside local files, u-Slicer report data can be exported to Google Sheets and shared with multiple people.

To export the selected report data to Google Sheets, use the following steps.

  1. Use the Google Sheets option on the top of the report data table.

  2. Add email addresses of people you’d like to share the data with. You can add up to 20 email addresses, one email in a row.

  3. Press Export when finished. u-Slicer will export the data and send the link to all the email addresses you added.

Schedule regular mailing

If you would like to export the report data on a regular basis, you can set up a scheduled report. To do this, use the following steps:

  1. Create an access token, see the Access Tokens steps. Important: Copy this token, as you will need to paste it into the scheduler configuration.

  2. Select the Export Scheduler option above the report data table.

  3. On the Export Scheduler dialog box, fill in the appropriate report data:

    • Title: Optional field, its content will be shown as the email subject.

    • Email message: Optional field, its content will be shown as the email body text.

    • Export format: Select the preferred data format. The report data will be emailed to you either as an attachment in the selected format or a Google Sheets link, depending on your choice.

    • Rewrite the same document: If this checkbox is active and Google Sheets export is selected on the previous step, the newly exported data will be saved into the same Google Sheets table. The table will be updated every time new data is exported.

    • Export time: Configure the export time. Note: You should account for the 4 hour delay from real-time data, e.g use 4am to export the previous day’s data.

    • Send once per: Configure the export frequency, the options are Day, Week, or Month.

    • Permanent u-Auth Token: Paste in your Authentication token from step 1.

    • Send to: Add the email address to which the report will be sent. You can add more email addresses (up to 20) using the Add email (1/20) button.

    • Create schedule: Save your changes, thus scheduling data export.

  4. Select Create Schedule

Export by u-Slicer API

You can export report data to a file using u-Slicer API. API export can also be used for uploading u-Slicer data to your own analytical systems. Please refer to the Export Endpoint section for detailed information.