How do I calculate average days between purchase for orders 1-2, 2-3, 3-4, etc.?

Order Latency (days)

The order latency (days) represents the number of days between consecutive orders.

Order Index

The order index represents customer order number in sequential manner. An order index of 1 means 1st order, a index of 2 means 2nd order, so on and so forth.

Average days between Purchase

  • Go to the "Order - Deep Dive" report.
  • Without setting any filters on the report, the "Order Distribution by Latency (days)" groups the days between customers current and previous orders (all repeat purchases) in the period set by the date picker. The first bar in the chart (screenshot below) indicates that there are 179 orders happen 14 days later after the previous order and all of them are subscription order.
    • image
  • To see days between the 3rd and the 4th order, for example, set the order_index filter to equal 4.
    • image