modeling-product-usage-metrics
Installation
SKILL.md
Modeling product-usage metrics
Retention, stickiness, and lifecycle answer three different questions about the same event stream. Model them
together. Read modeling-warehouse-foundations first. Definitions:
references/usage-metric-definitions.md; recipes in
references/posthog/ and references/dbt/.
Pick the lens
| Lens | Question | Output | Model when |
|---|---|---|---|
| Retention | Do users come back? | Cohort matrix: entry period × intervals-later × % retained | Measuring churn / stickiness of the core action over time. |
| Stickiness | How often do they engage? | Distribution: users by # of active intervals | Finding power users, feature stickiness, DAU/WAU/MAU shape. |
| Lifecycle | Is growth healthy? | Per interval: new / returning / resurrecting / dormant | Judging growth quality, spotting a leaky bucket. |
All three key off one chosen event/action, an interval (day/week/month), and an aggregation unit (person or group). Fix those three, then pick the lens.