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.

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