Template · Customers · Opening soon

Repeat purchase rate, month by month

See what share of each month's new customers came back for a second order, from your Shopify, Stripe or spreadsheet orders. It updates as new orders arrive.

Book a demo

You bring

Orders or payments991 rows

CustomerDateAmount

Mammoth does the work

You get

One table12 rows

Each month's new customers and the share who ordered again within 90 days.

MonthNew customersBought againRepeat rate %

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.

Repeat purchase rate: the resultSample data12 rows

Month	New customers	Bought again	Repeat rate %
2025-08-01	50	4	8
2025-09-01	48	8	16.7
2025-10-01	65	11	16.9
2025-11-01	54	10	18.5
2025-12-01	40	11	27.5
2026-01-01	52	16	30.8
2026-02-01	51	8	15.7
2026-03-01	44	8	18.2

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

How is repeat purchase rate calculated?

Repeat purchase rate is the share of customers who order again. Counting it per month of first order, within a fixed window such as 90 days, makes months comparable and shows whether newer customers come back more often than older ones.

How it works

How to use the repeat purchase 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: customer, date, amount

Orders or payments

Customer
Date
Amount

The steps it runs

1Match columns
2New customers who bought again

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

Repeat purchase rate: questions

Why is the latest month missing?

A month appears once the window has passed for all its new customers. Until then its rate would be too low, because some of them have not had the full 90 days to come back.

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.