Track running totals for cohorts using a cumulative rollup calculation

Alfons was asking about how the cumulative cohort option in Repeat Customer Insights works.

When you enable Include Previous Months (cumulative), each column adds the ones from the left so there's a running total.

Example cohort analysis

For example, lets use the regular cohort analysis. If you look on the row 2022-01, when Include Previous Months is off you'll see:

Turning on Include Previous Months the values change to:

Each view of the data gives you different analyses depending on what you're looking for. Looking at both, you can also spot some things that neither view would tell you directly.

The cumulative view let's you see how many customers ordered at least a second time since the first month they ordered.

(There's also a Revenue-based cohort view in the app that works similarly except it tracks the total revenue spent for each cohort in each month)

Eric Davis

Retain the best customers and leave the worst for your competitors to steal

If you're having problems with customers not coming back or defecting to competitors, Repeat Customer Insights might help uncover why that's happening.
Using its analyses you can figure out how to better target the good customers and let the bad ones go elsewhere.

Learn more

Topics: Cohort analysis

Would you like a daily tip about Shopify?

Each tip includes a way to improve your store: customer analysis, analytics, customer acquisition, CRO... plus plenty of puns and amazing alliterations.