Overview calculation logic
The overview value summarizes retention over a period of time and helps you quickly understand how the data performs. This section explains how overview values are calculated. You can look up the calculation logic that matches the definition of your metric.
Logic of preset metrics
Whether or not Also Show is turned on, the Retention Analysis model calculates the following preset metrics. Their overview values are calculated as follows:
| Analysis metrics | Default calculation logic | Optional calculation logic |
|---|---|---|
| Initial users | Sum, that is, the simple sum of each date's data | Average, that is, the arithmetic mean: Sum / time range |
| Retained users | Sum, that is, the simple sum of each date's data | Average, that is, the arithmetic mean: Sum / time range |
| Retention rate | Weighted average, that is, the simple sum of retained users / the simple sum of initial users | - |
| Churned users | Sum, that is, the simple sum of each date's data | Average, that is, the arithmetic mean: Sum / time range |
| Churn rate | Weighted average, that is, the simple sum of churned users / the simple sum of initial users | - |
Logic of Also Show metrics
For Also Show metrics with different definitions, the overview uses different default calculation logic to fit actual business scenarios.
- Also Show metrics with return user metrics only
| How the return metric is set | Default calculation logic | Optional calculation logic |
|---|---|---|
| A formula, or not a formula and not using a per-user calculation method | Average of the return user metric across dates |
|
Per-user calculation methods
| Weighted average
|
|
- Metric on Initial date
The overview value of a metric on the initial date uses Average by default, and Sum is optional.
- Also Show metrics that include metrics on the initial date
| How the metric calculation is set | Default calculation logic | Optional calculation logic |
|---|---|---|
| The arithmetic operation between the return user metric and the metric on the initial date is addition, subtraction, or multiplication | Average |
|
The arithmetic operation is division | Weighted average
|
|
Impact of incomplete data on overview values
Incomplete data is excluded when overview values are calculated, and only complete data is used. To avoid misunderstanding, you can select Exclude partial dates.
For example, if you view the overview value of the next-day retention rate for February 1~5 on February 6, the next day of February 5 (February 6) hasn't ended yet, so the overview value equals the weighted average of the retention rates for February 1~February 4, and neither the initial users nor the next-day retained users of February 5 are counted in the overview value.

