Workflow · Stock and products · Opening soon

Repeat customer rate

See how many customers bought each month, and how many of them had bought in an earlier month. Then calculate repeat customer rate as repeat customers divided by all customers.

Book a demo

Someone typed

“for the shopify orders export, show each month’s total customers, repeat customers, and repeat customer rate = repeat customers divided by all customers”

The agent read it as

For the Shopify orders export, show each month’s total customers, repeat customers, and repeat customer rate = repeat customers divided by all customers, with repeat customers meaning customers who bought in an earlier month.

What the agent built

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

File

Shopify orders export

CSV export · 24 rows

Step

Count monthly repeat customers

Step 1

Result

Monthly Repeat Customers

5 rows

Schedule

Runs when you say

Proposed

File
Shopify orders export
CSV export · 24 rows
Step
Count monthly repeat customers
Step 1
Result
Monthly Repeat Customers
5 rows
Schedule
Runs when you say
Proposed

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

Download Shopify orders export sample (24 rows)Shopify Admin: Orders > Export > Current search export

What you get back

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

Monthly Repeat CustomersSample data5 rows

Month	Total customers	Repeat customers	Repeat customer rate
2026-07-01	5	0	0
2026-08-01	5	1	0.2
2026-09-01	5	1	0.2
2026-10-01	5	4	0.8
2026-11-01	4	4	1

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

How do you calculate repeat customer rate by month?

Use your Shopify orders export. Group orders by month, count all customers in each month, then count the customers who also bought in an earlier month. Divide repeat customers by all customers to get the repeat customer rate.

How it works

How to use the Monthly Repeat Customers 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 Repeat Customers: questions

What export do I need?

Use an orders export that includes customer and order date fields. That lets the workflow group orders by month and compare each customer across months.

What happens to rows that do not match the rule?

Rows that do not match the rule are left out of that step’s result. The workflow only counts rows that meet the conditions you set for the month or customer rule.

How do I change the rules?

Change the rules in plain words, such as which date field to group by, what counts as a repeat customer, and whether you want monthly or other time periods.