Platform: Enolytics DTC

Summary:

What it is: Order Sequence Since Club Signup tracks the sequential order number for each customer's paid orders during active club membership periods (1st order, 2nd order, 3rd order, etc.). The sequence resets if a customer cancels and later rejoins the club, continues when members switch between club levels, and shows NULL for orders placed by non-members.

How to use it:
• Track member engagement patterns - identify if new members typically place additional orders beyond their club shipments, and at what point in their membership journey they're most likely to make extra purchases
• Analyze member lifecycle behavior - spot trends like whether 5th-time club buyers tend to upgrade to higher tiers, or if members who place their 3rd order within 6 months have better retention rates

Tip: Since this only counts orders during active membership (not when on hold), use it alongside Membership Status to get the full picture of a member's purchase behavior throughout their entire relationship with your winery.

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:

Sequential order number since the customer's club signup (1st order, 2nd order, etc.). Only counts paid, non-$0 orders placed during an active club membership. Resets when a customer cancels and later signs up for a new club. Continues across club level switches. NULL if the customer is not an active club member at the time of the order.

Order General

Type: int

Format: #,##0