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