cohort-retention

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

1. List subscriptions (all statuses) with created and canceled_at/ended_at
2. Bucket by signup month (created)
3. For each cohort, compute % still active at month 1, 2, 3...
4. 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).