Platform: Enolytics DTC

Summary:

What it is: Reverse Website Order Sequence shows the sequence number of each eCommerce order for a customer, counting backwards from their most recent website purchase (which gets a "1"). Only website orders receive sequence numbers; tasting room and club orders show as NULL.

How to use it:
• Filter for sequence "1" to find each customer's most recent website purchase, perfect for analyzing current online shopping behavior or targeting recent digital buyers
• Compare early sequences (1-3) versus later ones (10+) to see how customer preferences, order values, or wine choices evolve over their online buying journey

Tip: Since this only tracks website orders, pair it with total order data to understand what portion of a customer's purchases happen online versus in your tasting room.

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:

The order count for eCommerce purchases by this contact, numbered in reverse chronological order where 1 represents the most recent website order. Useful for understanding online shopping recency and identifying customers who may benefit from digital engagement campaigns. Only populated for website orders; all other order types show as NULL.

Order General

Type: int

Format: #,##0