Cohort retention

Skill appeeky/stripe-skills/skills/cohort-retention

Builds subscriber cohort retention and revenue-retention tables grouped by signup month from Stripe data. Use when the user mentions "cohort", "retention curve", "LTV curve", "how long do subscribers stay", or "retention by signup month". For overall churn, see churn-analysis.From its SKILL.md

Install

npx -y skills add appeeky/stripe-skills --skill cohort-retention

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

One thing to look at

5 stars5 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.

SKILL.md

1.2 KB, as published. Nobody here has run it

Cohort Retention

Stripe MCP Setup

Requires Stripe MCP (https://docs.stripe.com/mcp). GetMcpTools before CallMcpTool. Paginate all lists (limit: 100, starting_after while has_more). Amounts in cents. Read-only for audits; confirm before writes.

Workflow

List subscriptions (all statuses) with created and canceled_at/ended_at
Bucket by signup month (created)
For each cohort, compute % still active at month 1, 2, 3...
Optionally weight by MRR for revenue retention

Output Template

Cohort Retention (logo)

| Cohort | Size | M1 | M2 | M3 | M6 |
|--------|------|----|----|----|----|
| 2026-01 | | | | | |

Revenue retention (NRR) latest cohort: [X]%
Insight: [where the biggest drop occurs]

Flag the month with steepest drop -- that's the retention leak to fix (route to churn-analysis or onboarding).