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)