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 |
|
||||||||||||
Actions |
|
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.
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
Traits and limitations
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:
|
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 |
제한 사항 | 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.
|