At a glance: Pivot table allows you to deep-dive into your data through different views to analyse performance trends.
Using Pivot Table
Sequencing Metrics View
1. Open Columns on the right
2. Click to drag and rearrange the sequence for metrics on display
Hiding of Metrics
Open Columns and uncheck boxes to hide metrics.
Pinning of Metrics
Click on the 3 dots icon to open up menu
Go to Pin Column and select the option to pin your metric
Sort Priorities with Multiple Metrics
In Pivot table, use Shift + Click to select column title to sort by multiple metrics/dimensions.
e.g. Date + Cost + Installs
Generate Custom Charts
Select the required metrics and right click to select Chart Range > Type
Examples:
Key things to note
Black headers: Metrics calculated based on users who FIRST OPENED during the date range
Purple headers: Metrics based on the users who were ACTIVE during the selected date range
Attributed Installs is the number of distinct users Cost Center receives from Attribution service after post-proceeding to eliminate users who were active in Firebase in the last 30 days.
LTV, Retention and ROAS are calculated based on Attributed Installs.
Acc. Ad Revenue is accumulated ad revenue since the users first opened app until now.
Activity Log charts all related actions (bid & budget edits) in Cost Center help to analyse your data better and easier. Releases are recorded automatically.