Platform: Enolytics DTC

Summary:

What it is: Club Shipment Skipped Count tracks the running total of shipments a wine club member has skipped up to each shipment record. The counter increases only when members actively skip or miss scheduled releases (showing values like 1, 2, 3), while successfully shipped orders show NULL, creating a clear pattern of skip behavior over time.

How to use it:
• Identify at-risk members: Filter for members with increasing skip counts to spot those who might be losing interest and need retention outreach before they cancel entirely.
• Analyze skip patterns: Compare skip counts across different member segments, wine styles, or seasonal releases to understand what drives members to opt out and optimize future shipments.

Tip: Since shipped orders show NULL rather than zero, focus on members where this field has actual numbers — those are your skip-prone members who need attention.

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:

Running total of club shipments this member has skipped up to and including the current shipment record. This counter only increments when a member actively opts out or fails to fulfill a scheduled club release, and remains NULL for successfully shipped orders. For instance, a member with shipped, skipped, shipped, skipped would show NULL, 1, NULL, 2, providing clear visibility into skip patterns and potential attrition risk.

Club Shipment General

Type: int

Format: #,##0