Subscription Analytics Tool for SaaS Metrics

You have a CSV of subscription data from Stripe, Chargebee, or your billing system and need a subscription analytics tool to calculate MRR movement, cohort retention, or revenue churn for a board deck or finance review. This tool reads your export and builds the metrics without requiring a data warehouse or BI platform.

Upload your subscription export and get board-ready MRR trends, churn metrics, and cohort analysis in under a minute.

Drop your file in and ask a question — no account needed.

Upload your spreadsheet.xlsx .xls .csv — free to try, no account

Or start with

What is a subscription analytics tool and what does it calculate?How do I calculate MRR from a subscription export?What is the difference between customer churn and revenue churn?How do I build a cohort retention table from billing data?How do I categorize MRR changes into new, expansion, contraction, and churn?

What this export contains

customer_id

subscription_id

plan_name

mrr

start_date

end_date

status

billing_interval

cancellation_date

upgrade_date

currency

cohort_month

What the tool calculates from your subscription export

Upload a CSV with customer IDs, subscription amounts, start dates, and status. The tool calculates MRR, categorizes changes into new, expansion, contraction, and churn, and builds cohort retention tables. It handles annual plans, multi-currency conversions, and partial-month prorating. Results appear as charts and tables you can copy into a slide deck or finance report.

What it costs

DataMimi is free to try without an account, and the free plan includes credits every month. Paid plans add more credits, more files per analysis and more seats; every feature, from dashboards to slide decks, is on every plan. See the pricing page for current prices.

Common questions

What is a subscription analytics tool and what does it calculate?

A subscription analytics tool reads billing data from Stripe, Chargebee, or other subscription platforms and calculates MRR, churn rates, cohort retention, and revenue movement categories. It automates metrics that would otherwise require manual spreadsheet work or a full BI setup.

How do I calculate MRR from a subscription export?

MRR is the monthly recurring revenue from active subscriptions. For annual plans, divide the total contract value by 12. For monthly plans, use the plan amount directly. Sum only subscriptions with a status of active or trialing, and exclude one-time charges or usage fees that are not recurring.

What is the difference between customer churn and revenue churn?

Customer churn counts the percentage of customers who cancel. Revenue churn measures the percentage of MRR lost from cancellations and downgrades. A business can have low customer churn but high revenue churn if the customers who leave were on expensive plans.

How do I build a cohort retention table from billing data?

Group customers by the month they started their first subscription. For each cohort, count how many customers remain active in each subsequent month. Display this as a grid where rows are cohorts and columns are months since signup, with percentages showing retention rate.

What is net revenue retention and how is it calculated?

Net revenue retention measures the percentage of revenue retained from a cohort after accounting for churn, downgrades, and upgrades. Take the MRR from a cohort at the start of a period, add expansion revenue, subtract contraction and churn, then divide by the starting MRR. A result over 100% means expansion outpaced losses.

How does the tool handle annual subscriptions in MRR calculations?

Annual subscriptions are normalized to monthly values by dividing the contract value by 12. The tool recognizes billing_interval values like 'year' or 'annual' and applies the conversion automatically so that MRR totals combine monthly and annual plans on the same basis.

Try it with your own file

DataMimi reads the file you actually have — merged cells, headers below row one, totals pasted at the bottom — and shows which rows and columns every number came from.

Ask about your file

What DataMimi costs

Every plan does everything — slides, written reports, cleaned exports, dashboards. They differ in how much work they cover.

Free

40 credits a month

Starter

$24 /month

1,500 credits a month

Pro

$59 /month

5,000 credits a month

Start free — no card See every plan