Platform: Enolytics DTC

Summary:

What it is: Reverse Allocation Order Sequence numbers allocation purchases by each customer in reverse chronological order, where 1 is their most recent allocation order, 2 is their second most recent, and so on. Only orders containing allocation wines receive a sequence number; all other orders show as NULL.

How to use it:
• Identify customers who haven't participated in recent allocations by filtering for contacts missing sequence 1 or 2, helping you understand allocation engagement patterns
• Analyze allocation purchase consistency by looking at the distribution of sequence numbers per customer — frequent allocation buyers will have higher sequence numbers

Tip: Since non-allocation orders show as NULL, this dimension acts as a natural filter for allocation-only analysis while simultaneously showing purchase recency within that channel.

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 allocation purchases by this contact, numbered in reverse chronological order where 1 represents the most recent allocation order. Allows wineries to identify customers' latest allocation purchases and analyze buying recency. Only populated for orders containing allocation wines; all other order types show as NULL.

Order General

Type: int

Format: #,##0