Template · Customers · Opening soon

Cohort retention analysis from your orders

Group customers by the month they first bought and see how many come back each month after. Built from your orders or payments, updated as they arrive.

Book a demo

You bring

Orders or payments587 rows

CustomerDateAmount

Mammoth does the work

You get

One table14 rows

Each month's new customers, and the share still buying 1, 2, 3… months later.

CohortCustomersMonth 1 %…Month 12 %

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.

Cohort retention: the resultSample data14 rows

Cohort	Customers	Month 1 %	Month 2 %	Month 3 %	Month 4 %	Month 5 %	Month 6 %	Month 7 %	Month 8 %	Month 9 %	Month 10 %	Month 11 %	Month 12 %
2025-08-01	18	55.6	38.9	44.4	33.3	38.9	27.8	22.2	22.2	16.7	11.1	11.1	11.1
2025-09-01	12	50	41.7	33.3	41.7	16.7	25	25	25	25	8.3	0	0
2025-10-01	16	50	56.3	56.3	31.3	12.5	18.8	18.8	12.5	18.8	18.8	6.3	6.3
2025-11-01	10	80	40	20	30	20	20	10	20	10	0	0	0
2025-12-01	8	62.5	62.5	50	25	25	12.5	12.5	12.5	0	12.5	0	0
2026-01-01	12	41.7	58.3	50	41.7	41.7	41.7	41.7	41.7	25	0	0	0
2026-02-01	13	61.5	30.8	23.1	23.1	15.4	7.7	15.4	15.4	0	0	0	0
2026-03-01	13	61.5	69.2	53.8	38.5	38.5	23.1	15.4	0	0	0	0	0

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

What is cohort analysis?

Cohort analysis groups customers by when they started and tracks each group over time, so you can see whether retention is improving for newer customers.

How it works

How to use the cohort retention 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, by first month

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

Cohort retention: 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.