Using order sequencing to better understand customer behavior

Recently a Repeat Customer Insights customer was asking what were the order counts in Customer Purchase Latency analysis.

In there the orders are "sequenced" for each customer and then aggregated by that order sequence along with other aggregate metrics.

Simple right?

Just joking...

An example is easier to understand:

Say you had only one customer, John, who placed 4 orders.

Shopify would show that John has 4 orders but that's about it.

With order sequencing Repeat Customer Insights would show 1 order on the 1st order row, 1 order on the 2nd order row, 1 on the 3rd, and 1 on the 4th. Still 4 orders total but spread across 4 rows.

John's order metrics would then be combined with all of your other customers.

[Example Latency Analysis showing the order rows and numbers of orders]

So if your Latency Analysis showed the order metrics above, the 1st order row of 80 means 80 customers placed their first order (John is one). The second row of 57 means of those 80 customers who first ordered, 57 placed a second order (John again), etc.

The rest of the Latency Analysis uses this order sequencing to break down and aggregate other metrics like the AOV, Repeat Purchase Rate, and Latency timing. This makes it comparing new customer behavior to repeat customer behavior easier.

If you haven't ever seen this type of analysis with your Shopify store, try out Repeat Customer Insights. It'll build this and other analyses for you automagically.

Eric Davis

Discover where your best customers come from

Going beyond simple attribution, Repeat Customer Insights lets you analyze and segment your customers by who first sent that customer your way.
This will let you find the best sources of long-term customers, not just anyone who orders.

Learn more

Topics: Customer purchase latency

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.