Platform: Enolytics DTC
Summary:
What it shows: A ready-made list of former wine club members who've shown strong buying behavior recently and might be prime candidates for rejoining. This report finds customers who meet specific criteria: (1) were past club members who cancelled more than 10 months ago, (2) have purchased wine in the last 9 months through non-club channels, (3) have placed at least 3 lifetime orders, (4) spend 3x more than your average customer on wine, and (5) weren't buying gifts. No setup needed — just open and go.
Who should use it:
• Wine club managers and retention teams
• Marketing teams running reactivation campaigns
When to use it:
• Planning targeted campaigns to win back high-value former members
• Identifying warm prospects for club re-enrollment outreach
• Quarterly reviews of reactivation opportunities
Questions this report answers:
• "How do I find former club members who are still buying wine but not through the club?"
• "Can I get a list of past members who might be good candidates for rejoining?"
• "Where can I see which cancelled members are still active customers?"
• "How do I pull a report showing high-spending former members who've purchased recently?"
• "Which past club members should I prioritize for reactivation campaigns?"
Tip: Check the Last Cancellation Reason column to tailor your reactivation approach — someone who cancelled due to "too much wine" might respond differently than someone who cited "price concerns."
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.
📂 How to Access This Report
This is a public bookmark — a pre-built report ready for you to use. You don't need to create it from scratch.
To open it:
Click the Bookmarks icon in the left sidebar
Look under Public Bookmarks
Open the folder: ENO Preset Campaigns/Club Processess
Click Past Members still active possible rejoin
Quick Stats:
8 filter(s) applied
13 dimension(s) displayed
3 measure(s) displayed
Report Page: Build Beyond Limits | Advanced Reporting
Filter Behavior: When you select this bookmark, your existing filters will be replaced with the bookmark's saved filters.
📝 Original Description
Shows former wine club members who cancelled 10+ months ago but recently purchased wine, helping identify prime rejoining candidates.
Filters Applied
The following filters narrow down the data in this bookmark:
Dimension Filters:
Detailed Club Status is one of: Past
Buyer Profile is one of: 3 Month Buyer, 6 Month Buyer, 9 Month Buyer
Product Type is one of: Wine
Order As Gift is one of: unlikely
channel_type is not one of: Club
Days Since Last Cancelled is between: 300, 5544
Measure Filters:
📋 Columns Displayed
Dimensions:
Customer Number — The outbound facing unique identifier. This can be different depending on the CRM. WD and VST use a customer_number (that is what prompted the naming), Commerce7's unique identifier is the email address.
First Name — Contact first name as defined in the contacts table
Last Name — The name of the actual club as specified in the respective CRM. (eg. 3 Bottle Pinot Noir Club). A customer can belong to multiple clubs at once but the club itself can only exist once within the winery data.
Contact Email — Contact's primary email. If contact has multiple emails, this is will be the primary. This is NOT an array of emails.
Contact Phone — Contact's primary phone number. If contact has multiple phone numbers, this is will be the primary. This is NOT an array of phone numbers.
RFM Category — Category associated with the RFM score
Contact Last Order Date — Last valid order date for the contact (where the payment status ='Paid' or transaction is completed)
Club Last Order Date — Last Date the contact ordered through the Club Channel Type
POS Last Order Date — Last Date the contact ordered through the Tasting Room Channel Type
Website Last Order Date — Date of most recent web order. **Origin: Calculated**
Last Cancelled Date — If the contact is no longer a club member, what is the last cancelled date for any membership
Contact Last Cancelled Club Name — Name of the club that was most recently cancelled. **Origin: Calculated**
Measures:
ℹ️ Additional Details
Bookmark ID:
94bd4db1-86da-480a-b612-b62bf7640a81