- Home
- Skills
- Data & Databases
- Cohort Analysis Playbook
Cohort Analysis Playbook
Build retention matrices and cohort curves from event data, then turn them into a clear retention report.
$13
Works with the AI tools you already use
Cohort Analysis Playbook
Example session with this skill installed
Using events.csv (user_id, signup_date, activity_date), build monthly signup cohorts for Jan–Apr 2026. Active = any login. Show retention for months 1–3 and tell me if newer cohorts retain better.
- Read your context and instructions
- Compiled the cohort analysis playbook
- Generated the document
Illustrative example on synthetic data. It follows this skill's cohort_report_template.md.
Cohort Analysis Report: App logins, Jan–Apr 2026 cohorts
Summary
Newer cohorts retain better. Month-1 retention rose from
38% (Jan) to 46% (Apr). The biggest drop-off for every cohort is between month 0 and month 1.
Retention Matrix
| Cohort | Users | M1 | M2 | M3 |
|---|---|---|---|---|
| 2026-01 | 2,140 | 38% | 29% | 25% |
| 2026-02 | 1,980 | 40% | 31% | 27% |
| 2026-03 | 2,310 | 44% | 34% | – |
| 2026-04 | 2,450 | 46% | – | – |
Key Findings
Finding 1: Month-1 retention improved by 8 pp
The improvement starts with the March cohort, which lines up with the new onboarding checklist launched on 2026-03-02.
Finding 2: Curves flatten after month 2
Between M2 and M3, each cohort loses only 2–4 pp. Users who survive month 2 tend to stay.
Finding 3: Cohort sizes are healthy
All cohorts have more than 1,900 users, so the rates are not noisy.
Caveats & Limitations
Cohorts from March onward have fewer observed periods. The onboarding link is a correlation, not a proven cause; confirm it with an A/B test.
Recommended Next Steps
- Split the March and April cohorts by users who did and did not complete the checklist.
- Track M3 for the March cohort next month.
- Share the heatmap (
retention_matrix.html) with the growth team.
cohort-analysis-playbook.pdf
PDF · document
Example file from a real run - the skill writes it into your workspace.
Connects securely to your tools. The creator never sees your data.
What you get
About this skill
Cohort Analysis Playbook takes your agent from raw event data to a retention story. It defines the cohort and the retention event, builds a cohort-by-period table (with a starter SQL query and Python scripts), computes the retention matrix, and renders a heatmap and retention curves. It then interprets the patterns using a bundled glossary and a guide to common cohort patterns. The deliverables are a written report and a colour-coded HTML retention heatmap.
Use it when
- Someone asks "are we retaining users better than last quarter?"
- You need N-day, weekly or monthly retention for a product or feature
- You want to compare acquisition cohorts by channel, plan or signup date
- You are looking for the period when users typically churn
What's inside (installs as one folder, cohort-analysis/):
cohort-analysis/LICENSEcohort-analysis/SKILL.mdcohort-analysis/assets/cohort_report_template.mdcohort-analysis/assets/retention_matrix.htmlcohort-analysis/references/cohort_definition_patterns.mdcohort-analysis/references/retention_metrics_glossary.mdcohort-analysis/scripts/cohort_builder.pycohort-analysis/scripts/cohort_query.sqlcohort-analysis/scripts/cohort_visualizer.pycohort-analysis/scripts/retention_matrix.py
Please read before buying: this is packaged from my free, MIT-licensed open-source library (https://github.com/nimrodfisher/data-analytics-skills). The same content is available there for free. You are paying for a ready-to-install package. It is a one-time purchase, sold as-is, with no support, updates or maintenance included. The MIT license is included.
How to install
Works the same in every agent - Claude, Cursor, Codex, Copilot and 20+ more.
- 1
Download the ZIP
Free skills download straight away. Paid skills unlock right after purchase.
- 2
Unzip into your skills folder
Every agent reads skills from one folder on your machine. Drop the unzipped folder in there.
- 3
Ask your agent to use it
Restart the agent if it was already running. It picks the skill up automatically - no config needed.
Skills folder by agent
Click the path to copy it. Create the folder if it does not exist yet.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill passes our trust checks below.
Security scanned
Passed our 8-point scan before listing
Fresh listing
Recently published to Agensi
30-day refund
Not a fit? Get your money back
Trust & safety
Security scanned
Verified clean 1 day ago
- Passed all security checks, Safe to install