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

Segment your customers automatically with RFM

Segmenting your customers has always been touted as a powerful marketing tool but many stores avoid it because it can be time-consuming.
Repeat Customer Insights will automatically segment your entire customer base for you based on the valuable data Shopify has already collected for you. Ranging from 5 to 30 to over 125+ different segments using RFM and other models, you can pick how much power you want to harness.

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.