Workflow · Customers · Opening soon

Customer churn analysis

Use a Stripe subscriptions export to review customer churn by month. See starting customers, customers lost, churn rate, and the MRR they took with them.

Book a demo

Someone typed

“for the stripe subscriptions export, show each month over the last 12 months: customers active at the start, customers lost, churn rate as lost divided by starting customers, and mrr lost from those cancels”

The agent read it as

For the Stripe subscriptions export, show each month over the last 12 months: customers active at the start, customers lost, churn rate as lost divided by starting customers, and MRR lost from those cancels, including the current month.

What the agent built

1 step, each one an ordinary Mammoth step you can open and change.

File

Stripe subscriptions export

CSV export · 45 rows

Step

Calculate monthly churn

Step 1

Result

Monthly Subscription Churn

12 rows

Schedule

Runs when you say

Proposed

File
Stripe subscriptions export
CSV export · 45 rows
Step
Calculate monthly churn
Step 1
Result
Monthly Subscription Churn
12 rows
Schedule
Runs when you say
Proposed

Checked on the sample files: every step ran, 12 rows came out.

Download Stripe subscriptions export sample (45 rows)Stripe: Billing > Subscriptions > Export

What you get back

The result of that run, the rows to look at first.

Monthly Subscription ChurnSample data12 rows

Month	Customers active at start	Customers lost	Churn rate	MRR lost
2025-12-01	3	0	0%	0
2026-01-01	7	3	42.9%	347
2026-02-01	8	3	37.5%	347
2026-03-01	9	2	22.2%	148
2026-04-01	11	2	18.2%	148
2026-05-01	13	2	15.4%	298
2026-06-01	15	1	6.7%	49
2026-07-01	18	2	11.1%	148
2026-08-01	20	1	5%	199
2026-09-01	23	1	4.3%	49
2026-10-01	25	1	4%	99
2026-11-01	27	2	7.4%	148

12 rows in the result. Sample data: illustrative figures, not business results.

How do you analyze customer churn by month?

Export your Stripe subscriptions data as a subscriptions export, then load it into Mammoth. It shows each of the last 12 months, including the current month, with customers active at the start, customers lost, churn rate, and MRR lost from those cancels.

How it works

How to use the Monthly Subscription Churn workflow

1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Monthly Subscription Churn: questions

What export do I need?

Use a Stripe subscriptions export. It should include the subscription records needed to see which customers were active at the start of each month and which ones cancelled during the month.

What happens to rows that do not match the rules?

Rows that do not fit the churn rules are left out of the monthly churn result. The table is built from the rows that match the month, active subscription, and cancel conditions.

Can I change the churn rules in words?

Yes. You can rewrite the instructions in plain words, such as which months to include, how to count starting customers, and how to treat cancels or MRR loss.