Purpose
This article provides an overview of Pivots. It explains what a Pivot is, why Pivots matter, how to create and access them, and how to use Pivots to create Graphs and Charts to analyze and filter data and optimize opportunities. It also describes how to review your InnovidXP Pivot Data.
Overview
In InnovidXP, a Pivot table is a set of summary data based on selected dimensions and metrics that lets you visualize results.
Our Pivot tool is one of the most useful and important functions in the platform, as it lets you create graphs or charts for in-depth analysis, measure impact, and identify optimization opportunities across all metrics. Within the Analysis tab, InnovidXP provides several predefined Pivot tables, plus the ability to slice and dice your data in a Pivot table format straight from your browser.
The Pivot area therefore allows you to:
- View predefined Pivot tables
- View and reuse previously created Pivots
- Create new Pivots to visualize and analyze results and make conclusions on those results
- Use your findings to plan optimizations for your TV spend
Pivots let you filter your data to specific metrics within a date range, and you can determine, for example, which channel has the most impact and during which daypart. Or you can compare spots to see which had the most immediate visitors to your website.
Accessing Pivots
The following steps explain how to access Pivots within the InnovidXP platform.
- Select Analysis from the main menu. The list of Pivots page is displayed, for example:
- This page lists previously created Pivots, and depending on your access level, you can search for any Pivots you have saved and want to reuse or build a new Pivot.
Building a Pivot
In InnovidXP, a Pivot table is a set of summary data determined by a selection of available dimensions and metrics that let you visualize results.
- Select Analysis from the main menu.
- Select Create new Pivot. The New Pivot page is displayed:
- Select the date range for your Pivot. You can choose a custom date range, or select the last active week or the last active four weeks.
NOTE: The model will show an aggregation of data based on the date range you select: responses, a choice between your different KPIs, and the number of spots and cost. - Use the dropdown menus to include or exclude specific data:
- Select the Columns or Rows dropdown to view the defining fields you uploaded in your Spot file; Response, Cost, and Cost per Response are displayed in Columns by default.
- Select the Metrics dropdown to view numeric metrics related to your Spots, including OTT audience, cost, Impressions, response attribution, and actions. We recommend including at least two KPIs.
- Select or deselect multiple options in these dropdown menus to display/hide them in the Pivot.
- To save your new Pivot, select the ellipsis button and select Save. The Save pop-up is displayed.
- Enter a title for the new Pivot and optionally enter a description.
- Select a visibility option; Visible to you only is selected by default. You can make the Pivot visible at the platform/partner or admin/partner client level.
- Select Save to save the Pivot and return to the main page.
Reviewing your Pivot data
To compare linear impression-based data only with OTT data (and hide linear spike data from the results) you can apply a filter to your InnovidXP data in the Pivots tool.
InnovidXP derives its data from the following media sources:
- OTT
- Linear, either:
- Spike (probabilistic)
- Impression-based
How to filter
Filtering by media source can be accessed in the Analysis area within the Pivot tool:
- Select Analysis from the main menu.
- Select Create new Pivot.
- Select the Filter icon and select ADD FILTER.
- Select TV2 Media Type:
- Make sure you deselect Linear from the Media Type filter you just added
You can now see your TV media buy broken out by strategy to compare and contrast like-for-like.
Note: You may see linear data across more than one TV2 Media Type, i.e. ‘Advanced Linear’ or ‘None'. When spots have some impression-based attribution, this is labeled 'Advanced Linear'. Spots that get zero impression-based attribution are categorized as 'None'.
Related content