Template · Customers · Opening soon

Monthly churn rate from your orders

A customer active last month who did nothing this month counts as lost. The template works out churn for every month from your orders or payments.

Book a demo

You bring

Orders or payments540 rows

CustomerDateAmount

Mammoth does the work

You get

One table14 rows

Each month: customers at the start, how many were lost, and the churn rate.

MonthCustomers at startLostChurn %Active customers

Not a spreadsheet to fill inIt is a ready-made workflow in Mammoth. You bring the files, and it does the work.
Your files, as they areUpload a file or connect a source. Your column names do not have to match.
Runs again by itselfWhen new data arrives, every step runs again and the result updates.

What you get back

The real result of this template, run on sample data.

Churn rate: the resultSample data14 rows

Month	Customers at start	Lost	Churn %	Active customers
2025-09-01	16	7	43.8	16
2025-10-01	16	8	50	19
2025-11-01	19	5	26.3	35
2025-12-01	35	7	20	40
2026-01-01	40	14	35	35
2026-02-01	35	10	28.6	39
2026-03-01	39	10	25.6	42
2026-04-01	42	10	23.8	41

14 rows in the result · made from 540 input rows · first 8 shown. Sample data: illustrative figures, not business results.

How is churn rate calculated?

Churn rate is the customers lost in a period divided by the customers you had at its start. Monthly churn of 3% loses about a third of customers in a year.

How it works

How to use the churn rate template

1Bring your dataConnect a source, or upload a file.
2Check the columnsMammoth matches each column the template needs and asks only when it is unsure.
3Choose where it goesA table, a sheet, or a dashboard. It rebuilds on every refresh.

See the exact columns and steps ›

What it needs

Orders or payments: customer, date, amount

Orders or payments

Customer
Date
Amount

The steps it runs

1Match columns
2Customers kept and lost each month

Every step is an ordinary Mammoth step you can open and change.

Churn rate: questions

Does it update by itself?

Yes. The template becomes an ordinary workflow in Mammoth. When your data refreshes, from a connector, a scheduled pull or a new file, every step runs again and the result table updates.

Can I change the steps?

Every step is an ordinary Mammoth step you can open and edit. Mammoth remembers which steps came from the template, so an update never overwrites your changes.

Do my column names have to match?

No. You point the template at your columns once. Mammoth suggests a match for each one and asks only when it is unsure.