AppsFlyer Pivot

What is AppsFlyer's Pivot Table?

The Pivot table, an AppsFlyer premium feature, provides marketers with unparalleled deep analysis capabilities, speed and ease of use in a familiar format - without the need to download data or rebuild custom pivot tables.

Full_Funnel.gif

With Pivot, marketers can answer their complicated questions right from the AppsFlyer dashboard, collaborate with colleagues and improve their agility, adapting to new and emerging opportunities faster and more easily.  Pivot saves you time and is incredibly simple to use. Pivot consists of an intuitive drag-and-drop mechanism for selecting the data you want to view.

Pivot comes with a number of pre-defined reports, together with the ability to very easily create your own customized reports.

The information displayed in the Pivot is based on the information found in the Master API.  For more information on the Master API, click here.

Pivot Reports Page

1.  From the dashboard menu, select Pivot.

2.  The Pivot Reports Page opens:

This page contains all the pivot reports created by you and your team.

It also has as 3 useful pre-defined pivot reports created by AppsFlyer, to help you get started: Media Source by Date, Full Hierarchy and Cost Analysis. These reports are view only and cannot be altered. However, they can be duplicated to create different reports.

Pivot Reports List

There are several items per each defined pivot report in the list:

  1. Name - name of the pivot report. Click on the name to see the Pivot report for the stated date range
  2. Last Modified - date of the last update to the report's structure
  3. Modified By - User name that last modified the report's structure
  4. App Name - name of the single app in the report, or the number of apps defined in it
  5. Actions - supported actions per pivot report are described in the table below:

    pivot_list_actions.png

Action Notes
Duplicate Copy the pivot report and create a new report based on its configuration
Rename Change the name of the report
View History log See who handled the report's structure, what was done and when.
Copy Master API Link Pull the pivot report's data directly from AppsFlyer's servers into your systems, using its corresponding Master API URL.
Note that only the account owner is able to get the full link. Team members get the link without the API token.
Delete Delete the pivot report from the list

 Note

Columns can be arranged in ascending or descending order by clicking the column title. You can also amend the width of each column.

In the Pivot Reports Page you can also add new pivot reports or click on existing ones to edit.

Adding a New Pivot

1. Click add_pivot.png at the bottom of the drop-down window:

2. The New Pivot window opens:

3. Enter the name of the new Pivot report to be created.

4. Click Submit to open the edit section of the create and edit Pivot process.

Editing the Pivot

1. The following window opens and already contains the name of the new Pivot given by you in the previous window.  Click Edit Pivot.

2.  The Edit Pivot Table window opens.

3.  From the left pane of the window expand the Dimensions option. The dimensions are the groupings, which you can use to structure and sort your pivot reports.

Select the dimensions you want to add and drag them to the appropriate section:

  • Rows - place your dimensions here to determine the group-by hierarchy
  • Filters - set the dimensions and KPIs, that would appear as filters in the result reports
  • Columns - Multiplies the entire results of the table according to all values of the dimension 
  • Values - KPIs only

 Note

You can drag and drop the selection to change the order of them in the table.

4.  Expand the KPI options and again, drag and drop them into the appropriate section. 

 Note

The Pivot KPIs are divided to four distinctive buckets of data:
LTV, Activity, Retention and Protect360 (for accounts that have Protect360 enabled). For more information about these KPIs please go here.

KPIs__1_.png

5.  In the Filters section you can select the filter box type to be either Text or Multi-Select

6.  In the Values section you can change the operation for each KPI to either Sum, Count, Max, Min or Rate.

7.  Once you have completed your selections, click Apply.

Your new Pivot appears in the drop-down menu on the main Pivot page.  Select it to open it.

 Note

If you add too many selections, you may receive a message asking you to reduce the number of selections.

Viewing the Reports

1. Selected Dimensions

The first column holds the dimensions selected for the groupings of the report. The dimensions are grouped according to the order in the pivot edit page. In the example above, the primary dimension is the app name, followed by the media source and concluded by the install date.

2. KPIs

The rest of the columns are the KPIs selected as Values in the pivot edit page. In the example above, the first KPI is impressions, followed by clicks, installs etc.

3. Filters

The filters set for the report in the pivot edit page appear here. You can type your filtering string or select multiple items with the drop-down boxes.

 

4. Date Selector

Use the Date Selector to refine your search to specific dates. You can select your own custom date range or use one of the preset date range buttons. 

date_selector.png

5. Actions

You can access the same actions per pivot report as available in the pivot reports list.

6. Edit Pivot

Click Edit Pivot to open the Edit Pivot window. 

Localization

Timezone Support

For a single app or multiple apps that have the same timezone, Pivot displays the timezone as configured in App Settings if the time range specified is after the latest timezone change in App Settings. Otherwise, Pivot displays the timezone as UTC.

Currency Support

Currently not supported.Pivot displays USD currency regardless of the currency in App Settings.

Limitations

Cost Data

AppsFlyer is able to present cost data for over 80% of tracked app installs. The data, for most of the big media sources, is retrieved via direct APIs between the networks and AppsFlyer. For some of these networks, the cost data is limited to certain dimensions.
Therefore, there are differences in the cost data, that reflect when using the Pivot table(or Master API).
 
If you see missing cost data on the Pivot table please refer to the Supported Dimensions column in this table. If the dimension you use to group your KPIs by is NOT supported by the specific media source, cost data cannot be displayed for it.

 Example

1. Facebook and Snapchat do not provide cost data related to countries. Therefore, cost data is not presented for these networks if a table is grouped by the GEO dimension.
2. Inmobi doesn't provide cost data related to the Channel dimension.

Was this article helpful?
0 out of 0 found this helpful