cohort-analysis

# Cohort Analysis Skill This skill produces a structured cohort analysis covering retention curves, LTV estimation, behavioural segmentation, and actionable interventions. Output is ready to present to product leadership or share with growth and data teams. ## Required Inputs Ask the user for these if not provided: - **Analysis goal** (retention improvement / LTV modelling / behavioural segmentation / churn prediction) - **Product or feature being analysed** - **Cohort definition** — what groups users? (acquisition month, signup channel, plan tier, feature adoption) - **Observation window** — how many periods to track? (e.g. 12 months, 8 weeks) - **Key metric** — what are you measuring per cohort? (retention rate, revenue, engagement score, feature usage) - **Available data** — what tables/metrics are available? (paste schema or describe) - **Baseline** — any existing retention benchmarks or goals? ## Output Structure --- # Cohort Analysis: [Product / Feature] **Analysis type:** [Retention / LTV / Behavioural / Churn] **Cohort definition:** [Acquisition month / Signup channel / Plan tier / Feature adoption date] **Observation window:** [X months / weeks] **Primary metric:** [Metric name] **Date prepared:** [Date] --- ## 1. Cohort Definitions | Cohort | Period | Size | Description | |---|---|---|---| | [Cohort 1] | [Jan 2025] | [N users] | [e.g. Users who signed up in Jan 2025 via organic] | | [Cohort 2] | [Feb 2025] | [N users] | [...] | **Cohort logic:** - Cohort ...