Platform: Enolytics DTC

Summary:

What it is: Club Order Sequence numbers each club shipment chronologically for individual customers, starting from 1 for their first paid club order and incrementing with each subsequent shipment. Non-club orders show as NULL, making it easy to isolate club shipment data.

How to use it:
• Track club member retention by analyzing how many shipments customers typically receive before churning (look for drop-off patterns at shipments 2, 3, 6, etc.)
• Segment club members by shipment history to create targeted campaigns — maybe members with 10+ shipments get different offers than those with only 2-3 shipments

Tip: Since non-club orders are NULL, this dimension naturally filters your analysis to club shipments only, perfect for studying member lifecycle patterns.

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 sequential count of club shipment orders for this customer, numbering each paid club shipment chronologically from their first to most recent. Only includes club shipment orders with order value greater than $0 and paid status, excluding non-club purchases. NULL for all non-club orders, making it easy to identify and analyze club shipment frequency and retention.

Order General

Type: int

Format: #,##0