Platform: Enolytics DTC

Summary:

What it is: Reverse Club Order Sequence shows the order count for each contact's club shipments, numbered backwards from their most recent shipment (1 = latest, 2 = second most recent, etc.). Only club orders get numbered; all other order types show as NULL.

How to use it:
• Quickly identify your most engaged club members by filtering for contacts with a "1" value (received their most recent club shipment)
• Analyze club member purchase patterns by looking at the sequence gaps - a member with orders numbered 1, 2, 4, 7 might have skipped some shipments

Tip: Filter out NULL values to focus exclusively on club member behavior, since only club shipment orders receive sequence numbers.

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 club shipments by this contact, numbered in reverse chronological order where 1 represents the most recent club shipment. Enables analysis of club member purchase recency and helps identify lapsed or active members based on their latest shipment. Only populated for club shipment orders; all other order types show as NULL.

Order General

Type: int

Format: #,##0