Skip to main content

Days Since Previous Order

Days Since Previous Order metric tracks time gaps between customer orders, showing NULL for first-time buyers and 0 for same-day purchases.

Updated over 2 weeks ago

Platform: Enolytics DTC

Summary:

What it is: Days Since Previous Order shows the number of days between this order and the customer's last qualifying order from any channel, with NULL values for first-time customers and 0 for same-day orders.

How to use it:
β€’ Identify purchase patterns and frequency trends by analyzing the gaps between customer orders to spot loyal regulars versus sporadic buyers
β€’ Segment customers by their typical ordering cadence to create targeted reactivation campaigns for those with longer-than-usual gaps

Tip: Filter out NULL values when analyzing repeat purchase behavior, since these represent first orders and will skew your average days between purchases.

Note: Parts of this article were generated with AI and may not be perfect. If something looks off or could be better, click the 😞 below β€” it opens a quick chat so you can let us know.


Quick Stats:

  • Type: int


πŸ“ Description

Number of days between this order and the contact's previous qualifying order (any channel). NULL for the contact's first qualifying order. 0 indicates same-day orders.


βš™οΈ Technical Details

Type: int

Format: #,##0


ℹ️ Additional Details

  • Created: 2026-03-01T17:03:06Z

  • Key: [dimension].[Days Since Previous Order]

  • ID: 9d37ca38-45ae-5230-b781-f697d3028279


🏷️ Tags

  • Channel

  • Days Since Previous Order

Did this answer your question?