modeling-activation-metrics
Build reusable activation models — an activation-rate metric and a per-user/per-account activated flag — on either PostHog data-warehouse views (HogQL) or an external dbt project. Use when the user wants to define, model, or measure activation, the "aha moment", onboarding success, or which early actions predict a user sticking around. The core idea this skill enforces: activation is NOT a single assumed event — it is a retention-validated combination of early actions, chosen by balancing reach (enough users hit it) against predictive power (those who hit it retain much better). Covers finding candidate actions, validating them against retention lift, count thresholds and action combinations, per-product and B2B group-level activation, and modeling the winning definition as a durable activated-flag + activation-rate model. Read modeling-warehouse-foundations first; composes modeling-product-usage-metrics for the retention validation.
Pinned to revision 4e8964e24a5a, so it is the text this page describes rather than whatever the author pushed since.
Files
- skills/modeling-activation-metrics/SKILL.md
- skills/modeling-activation-metrics/references/activation-method.md
- skills/modeling-activation-metrics/references/dbt/dim_activation_criteria.sql
- skills/modeling-activation-metrics/references/dbt/fct_user_activation.sql
- skills/modeling-activation-metrics/references/dbt/schema.yml
- skills/modeling-activation-metrics/references/posthog/activation_flag.sql
- skills/modeling-activation-metrics/references/posthog/activation_retention_lift.sql
Every link opens the file at its source, pinned to the revision this page describes.