Subscription Churn & Revenue Retention: methods and data limits

Reconcile customer MRR movements, churn and expansion.

Use the guide alongside the working tool.

Open Subscription Churn & Revenue Retention →

Explicit working sample

customer,month,mrr
A,2026-01,100
B,2026-01,50
A,2026-02,130
B,2026-02,0
C,2026-02,40
A,2026-03,110
B,2026-03,60
C,2026-03,40

Reconcile customer MRR movements, churn and expansion. Input is complete month-end customer MRR snapshots, one row per customer/month, in one currency. Missing customer in a supplied month means zero. Absent whole months are rejected. Active means MRR > 0. New/reactivated/expanded/contracted/churned reconcile closing MRR; GRR excludes expansion, NRR includes it. Baseline has no movement metrics.

Prepare the input

Reconcile customer MRR movements, churn and expansion.

CSV, TSV and arrays of scalar JSON objects are supported. Identifiers stay text. Empty cells are missing by default; add special missing tokens only if their meaning is certain. Use the sample to inspect the exact workflow.

Review the method

Input is complete month-end customer MRR snapshots, one row per customer/month, in one currency. Missing customer in a supplied month means zero. Absent whole months are rejected. Active means MRR > 0. New/reactivated/expanded/contracted/churned reconcile closing MRR; GRR excludes expansion, NRR includes it. Baseline has no movement metrics.

Keep the useful output

Review the summary and result records. Transformation tools retain separate change, rejected-record or diagnostics datasets where relevant. Choose the dataset before exporting; a report and a cleaned dataset serve different purposes.

CSV exports protect formula-like text. JSON keeps data portable without making an Excel workbook. Reports and editable backups may contain private source values; download only what you intend to share. No automatic account storage or server processing is used.

Ready to apply this workflow?

Try Subscription Churn & Revenue Retention →

Explore a related workflow

RFM Customer Segmentation: methods and data limits
Score recency, distinct orders and historical customer spend.
Market Basket Analyzer: methods and data limits
Find product pairs with support, confidence and lift.
Customer Lifetime Value Analyzer: methods and data limits
Measure observed customer value, repeat orders and acquisition cohorts.
Revenue Concentration & Pareto Analyzer: methods and data limits
Find revenue concentration and cumulative contribution thresholds.

All practical guides →

Keep your original files and review the result. Found unclear instructions? Contact Team Hypomnema.