Pivot report—user acquisition metrics

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.

피봇 리포트 페이지

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 team member are available to all team members.

The pre-defined pivot reports available are:

Media source by date
Full hierarchy
Cost analysis

Pivot procedures

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

Column/option

Description

Name

Select a report name to view the associated pivot.

Column click

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 team member who modified the pivot.

App name

If one app included: the app name
If multiple apps are included: the number of apps

Actions

액션	Remarks
복제	Copy an existing pivot report.
피봇 이름 수정	Change the name of the report.
View history log	See who handled the report structure, what was done, and when.
Copy master API link	Generate a URL to pull the data via Master API. Note: If the Admin copies the URL, it contains the authentication token. In contrast, if a team member copies the URL, the token is not included. In this case, the admin provides the team member the V1 authentication token.
삭제	Delete the selected 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.
Dimensions	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	KPIs are grouped according to type as follows: LTV 액티비티(Activity) 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.
Values	For each KPI, set the calculation method by selecting an operator: Sum Count Max Min
Filters	Place the required filters in the filters section. Configure how filters are set: Text Multi-select

View a pivot report

To view a pivot report:

Select a report in the Pivot page to display it.

Report display options
Section	Description
(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.
(3) Filters	피봇 편집 페이지에서 설정한 필터가 여기 표시됩니다. 필터링 문자열을 타이핑하거나 드롭 다운 상자에서 여러 항목을 선택할 수 있습니다.
(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	피봇 리포트 목록에서와 동일한 피봇 리포트 별 액션을 수행할 수 있습니다.

Traits and limitations

Pivot report traits
Trait	Remarks
Ad network access to report	No
Agency access	No
Agency transparency	Yes
App-specific time zone	Yes Exception: In all of the following cases, AppsFlyer ignores the app-specific time zone and uses the default time zone UTC +0: The report contains data from multiple apps, and the apps have different time zones. The apps all have the same time zone, and the time zone for at least one of the apps changed during the cohort report period. To determine the report period: Start date: The first date in the conversion date range. End date: Calculated by adding the number of days in the display duration to the last date in the conversion date range. Example: Last date: Jan 1, 2019. Report duration: 30 days. End date: Jan 31, 2019.
App-specific currency	Results always return in USD.
Organic data	Included
Non-organic data	Included
데이터 최신성	Data freshness: Daily. The data freshness is equivalent to that of Master API.
Team member access	Yes

Pivot report limitations
제한 사항	Remarks
Retargeting data	Use Cohort to view retargeting data.
Cost data	AppsFlyer gets cost data primarily via cost API. Data is provided by the integrated patterns. List of dimensions per integrated partner.
eCPI	To get eCPI values, include both cost and installs in the report.

피봇 리포트 페이지