Setting the file. One moment.
Skill 98 · Modeling Product Usage Metrics
Subchapter 98.8
references/usage-metric-definitions.mdMarkdown2 KBView on GitHub
All three lenses share: a chosen event/action, an interval (day/week/month), and an aggregation unit (person or group).
For a cohort defined by the interval of their start event (often first-ever occurrence), the share who performed the return event in each subsequent interval.
signed_up → ran_query).For the chosen event over a fixed span (e.g. last 7 days / 4 weeks), bucket each unit by how many distinct intervals they were active, then count units per bucket.
Classify each unit’s activity in each interval relative to the previous one and its first-ever activity:
| Bucket | Meaning |
|---|---|
| New | Active this interval, first-ever activity is this interval. |
| Returning | Active this interval and the immediately previous interval. |
| Resurrecting | Active this interval, inactive the previous interval, but active at some point before. |
| Dormant | Not active this interval, but active the previous interval (plotted negative). |