# Subscription Churn Review Ecommerce

> Diagnoses subscription and replenishment churn from subscriber exports, cancellation reasons, failed payments, and flow settings. Use when a store runs subscribe-and-save, refill, or membership billing and churn is rising, cycle-two drop-off is heavy, or involuntary churn has never been separated from voluntary. Only applies to stores with recurring billing; a one-off purchase store should use LTV and Cohort Read instead.

- Skill: `mardab96/subscription-churn-review-ecommerce` (Agent Skill)
- Install (CLI): `npx skillmds@latest add mardab96/subscription-churn-review-ecommerce`
- Raw SKILL.md: https://api.skillmd.com/api/skills/mardab96/subscription-churn-review-ecommerce/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: mardab96 (https://skillmd.com/u/mardab96)
- Updated: 2026-09-21
- Page: https://skillmd.com/skills/mardab96/subscription-churn-review-ecommerce

---


# Subscription Churn Review - E-commerce

## Use this skill when

The store runs subscriptions, replenishment, or a membership, and retention is worse than it should be.

Common requests:

- "Why do people cancel after the second box?"
- "Our churn is 9% a month. Is that bad?"
- "How much of this is failed payments?"
- "Should we let people skip instead of cancel?"

## Required input

Minimum useful input:

- Subscriber export: start date, cycle number, status, cancellation date.
- Cancellation reasons if captured.
- Billing interval and product.

Recommended additional input:

- Failed payment and dunning logs.
- Skip, pause, swap, and delay usage.
- Cancellation flow screenshots, including which off-ramps the customer portal actually surfaces before the cancel button becomes reachable.
- Support tickets about subscriptions.
- Discount structure on first cycle versus later cycles.
- Delivery timing performance.

## Before analysis

1. Separate voluntary churn from involuntary churn before saying anything about the offer. Failed cards are a billing problem, not a value problem.
2. Confirm the cycle length, because month-based churn on a 60-day cycle is misleading.
3. Confirm whether pauses and skips are counted as churn in the store's own reporting. They usually are, wrongly.
4. Ask whether the first cycle was discounted, and by how much.

## Analysis workflow

0. **Pull the platform's own numbers first.** Recharge, Skio, Stay AI and Shopify's native subscriptions already report cycle survival, cancellation reasons and failed-payment recovery. Start from that baseline and use this skill to interrogate it, not to re-derive it from a raw export. If the two disagree, the disagreement is itself a finding, usually about how pauses are counted.
0b. **Then rebuild survival independently with `../scripts/subscription_survival.py`.** Run `../scripts/subscription_survival.py <file>`. It splits endings into voluntary, involuntary and paused-not-resumed, and it counts each cycle only against the subscribers who actually reached it. When your export has no churn-type column the script infers it from status and reason text and says how many rows it inferred: check that number against the billing platform before acting, because the involuntary share is what the whole analysis turns on.
1. Build survival by cycle: what share of subscribers reach cycle 2, 3, 4, 6, and 12.
2. Split churn into voluntary, involuntary, and pause-not-resumed. Report each separately.
3. For involuntary churn, check the dunning setup: retry count, retry spacing, card updater, pre-dunning notice, and what the customer sees.
4. For voluntary churn, cluster cancellation reasons into: too much product, price, product fit, delivery problems, forgot they subscribed, life change, and unspecified.
5. Check the cancellation flow for missing off-ramps: skip, delay, reduce quantity, swap product, change frequency. Cancellation is often the only visible button.
6. Compare cohorts by first-cycle discount depth, acquisition source, and entry product.
7. Match frequency to real consumption rate. Sending product faster than people use it is the most common cause of "too much product" churn.

## Decision and evidence standard

Tag every finding with evidence: `subscription_export`, `export`, `support_ticket`, `screenshot`, `policy`, `hypothesis`, or `needs_data`. Full vocabulary: `../references/output-standard.md`.

Rank findings by recoverable subscribers rather than by cancellation count. Involuntary churn usually outranks everything else on that measure.

Cancellation reason fields are self-reported. Treat them as signal, not proof, and say so.

## Output format

### Churn verdict

Is the leak billing, frequency, product fit, price, or flow design. State confidence.

### Survival table

| Cycle | Subscribers entering | Retained | Voluntary churn | Involuntary churn | Paused |
|---|---|---|---|---|---|

### Involuntary churn findings

Dunning gaps and the recoverable share, stated as an estimate with its basis.

### Voluntary churn clusters

| Reason cluster | Share | Evidence | Fix | Effort |
|---|---|---|---|---|

### Flow fixes

Off-ramps missing from the cancellation flow, ordered by expected retention effect.

### Missing data

The dunning log is the input most often absent and most often decisive: without retry counts and spacing, involuntary churn can be sized but not explained. Cancellation reasons being unlogged is the second gap, and it is worth fixing before the next analysis rather than during this one.

## Example input and output

Input:

- subscriber export with cycle and status
- cancellation reason export
- dunning log
- cancellation flow screenshots

Good output excerpt:

| Finding | Evidence | Severity | Confidence | Business impact | Effort | Owner decision |
|---|---|---|---|---|---|---|
| A third of cancellations are failed payments with a single retry and no card updater | `subscription_export`, `needs_data` | critical | medium | revenue/retention | S | do_now |
| The cancellation flow offers no skip or frequency change, and "too much product" is the largest stated reason | `screenshot`, `support_ticket` | high | medium | retention | M | test |

What not to do yet: rebuild the offer because churn is high, when a third of it is a card retry setting.

## Guardrails

- Do not report a single churn number without splitting voluntary and involuntary.
- Do not treat pauses as cancellations.
- Do not make retention harder by hiding the cancel option. Fix the reason, not the exit.
- Do not promise a recovery percentage from dunning changes.
- Do not treat a raw export as more authoritative than the billing platform's own reporting. Prepaid terms, plan migrations and bundled subscriptions all export in ways that make naive counts wrong.
- Do not alter a live retry or billing schedule. These changes charge real cards on a new timetable, and the first sign of getting it wrong is a dispute, not a dashboard.