Churn analysis

Skill appeeky/stripe-skills/skills/churn-analysis

Analyzes Stripe subscription churn — cancellations, ended subs, voluntary vs involuntary signals, and period-over-period trends. Use when the user mentions "churn", "cancellations", "subs leaving", "retention", or "why are we losing subscribers". Pair with past-due-dunning for payment-driven churn.From its SKILL.md

Install

npx -y skills add appeeky/stripe-skills --skill churn-analysis

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

2.0 KB, as published. Nobody here has run it

Churn Analysis

Stripe MCP Setup

Requires Stripe MCP connected via OAuth or restricted key. Docs: https://docs.stripe.com/mcp

GetMcpTools with server: "user-Stripe" (or plugin-stripe-stripe) before any call
Prefer stripe_api_search → stripe_api_details → stripe_api_read for list/retrieve
Always paginate — limit: 100, follow has_more with starting_after
Amounts are in cents unless noted
Never expose secret keys in output

Workflow

Snapshot active + past_due counts (today) via GetSubscriptions
Canceled in period — list subscriptions with status: canceled created or canceled in window
- Use search_stripe_resources: subscriptions:status:"canceled" (note 100 cap — supplement with API list + filter)
Classify churn

Type	Signal
Voluntary	`cancellation_details.reason`, user canceled, feedback
Involuntary	Was `past_due` → `canceled`, `invoice.payment_failed`
Payment method	Debit/prepaid + failed charges

Retrieve sample canceled subs: GetSubscriptionsSubscriptionExposedId with expand cancellation_details

Churn Rate (approximate)

Monthly churn % ≈ canceled_in_30d / (active_start + new_in_30d) × 100

Benchmark: < 5% monthly good for SMB SaaS; < 2% excellent.

Output Template

Churn Report ([period])

Canceled: [N]
Est. monthly churn: [X]%
Voluntary: [N] | Involuntary: [N]

Top cancel reasons (from cancellation_details):
1. [reason] — [n]

Recommendations:
1. [action] → skill: [name]

Cross-check payment-failure-audit if involuntary > 40% of churn.