A Repeat Customer Insights customers was asking about how the cumulative orders in the Cohorts Report work:
Why doesn’t the sum of month 1 to n on the cohort customers % match the nth month for the cumulative cohort %?
The percentages are based on how many unique customers have bought out of the whole cohort. It’s like a tallying system. They are great to see how active customers are after their first purchase.
An example can make it easier:
Cohort 2021-03 has Jim, Michael, and Pam who first purchased in that month (March 2021).
- In April 2021, Jim and Michael bought again.
- In May, Jim bought again.
Percentage-wise each month would look like this (non-cumulative):
- April 66% of customers purchased (Jim and Michael)
- May 33% (only Jim)
Cumulative it would be:
- April 66% (so far Jim and Michael)
- May 66% (still only Jim and Michael. Even though Jim has bought again)
Pam has never bought again so that cohort won’t reach 100% until she does. Once she does, it’ll be 100% for the rest of time.
Another way of reading the Cohort percentage data is: “what percentage of customers have reordered in this month?”
The cumulative would then be read as: “what percentage of customers have reordered at least once by this month?”
Strategy-wise, a cohort with a 66% ordering rate means you should copy whatever you did to attract those customers. Re-run those ads, send those emails again, etc, do whatever you did so that new and existing customers get similar messages.
Use cohorts to find out who the best customers are in your Shopify store
Repeat Customer Insights will automatically group your customers into cohorts based on when they first purchased. This will let you see how the date customers bought would impact their behavior.