At a glance: View user acquisition metrics—LTV, activity, Protect360, and retention. Download results to CSV files for ingestion by your BI systems. Pivot supports multiple apps in a single query. Use to generate Master API calls.
Pivot reports page
Using Pivot, you generate customized reports containing user acquisition metrics. Pivot comes with a number of pre-defined reports to use as a base from which you create your customized reports. Reports created by a given account user are available to all users.
The pre-defined pivot reports available are:
- Media source by date
- Full hierarchy
- Cost analysis
Create and modify existing pivots in the user interface. To do so, use the procedures in the sections that follow.
To use Pivot:
- In AppsFlyer, go to Reports > Pivot.
The list of currently defined reports displays.
Pivot page—controls and options
|Name||Select a report name to view the associated pivot.|
Some columns, as indicated in the interface, are sorted by clicking on the column name.
|Last modified||Last time the report structure was modified.|
|Modified by||Name of the user who modified the pivot.|
Add a pivot report
To add a pivot report:
- Click Add pivot.
The New pivot window opens.
- Enter the pivot name.
- Click Submit.
The Add pivot table window opens.
- Select apps, dimensions, and metrics. Set filters and value display settings.
Section Description Apps
Select 1 or more apps to include in the pivot.
Use dimensions to group, structure, and sort your pivot reports.
To select dimensions:
- Click Dimensions.
Select a dimension, then drag it to a section. Dimensions have the following impact on the Pivot:
- Rows: Dimensions placed in rows determine the group-by hierarchy.
- Columns: Dimensions placed in columns multiply the entire table result according to the dimension values.
KPIs are grouped according to type as follows:
- Retention: Retention day, Retention rate. Note: Scroll-down in the retention section to select Retention rates and Protect360 (for accounts that have Protect360 enabled.)
- About the metrics.
Most times, place KPIs in the value section. If needed, KPIs can be used as a dimension.
Drag and drop the KPI to the relevant section.
For each KPI, set the calculation method by selecting an operator:
Place the required filters in the filters section. Configure how filters are set:
View a pivot report
To view a pivot report:
- Select a report in the Pivot page to display it.
- Report display options:
|(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 ending with the install date.
|(2) Metrics||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.|
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 selected||Use the Date Selector to refine your search to specific dates. Select your own custom date range or use one of the preset date range buttons.|
|(5) Actions||You can access the same actions per pivot report as available in the pivot reports list.|
Traits and limitations
Traits and limitations
Pivot report traits:
|Ad network access to report||No|
|App-specific time zone||
Exception: In all of the following cases, AppsFlyer ignores the app-specific time zone and uses the default time zone UTC +0:
|App-specific currency||Results always return in USD.|
|Data freshness||Data freshness: Daily. The data freshness is equivalent to that of Master API.|
|Account user access||Yes|
Pivot report limitations:
|Campaign name changes||Pivot doesn't align the campaign name cost to the most recent campaign name reported. This means that each campaign name used will have a cost associated with it.|
|Retargeting data||Use Cohort to view retargeting data.|
AppsFlyer gets cost data primarily via cost API. Data is provided by the integrated partners. List of dimensions per integrated partner.
To get retention rate, include installs in the report.
|Maximum rows per report||