Sales and Retention · Oct 12, 2026

Spot Club Members About to Cancel With One Export and Claude Cowork

Saving a handful of club members costs almost nothing and protects revenue you already earned. Most wineries never look at the data because pulling it apart by hand takes a day you do not have.

Most club cancellations show up in the data weeks before they show up in your inbox: a skipped shipment, a declined card nobody chased, a member who stopped opening email after their second box. Do the math with your own numbers. Multiply your average member lifetime value by ten saves, and you will see why this is worth an afternoon.

What to prepare

Export two files from your club platform (Commerce7, WineDirect, Toast, Square, whatever you run) and save them in one folder on your computer called Club Retention:

Member list: name, email, join date, sign-up source (tasting room, online, event), club tier, status, last shipment, skips, declined payments.
Order history: every order with date, amount, and items, going back three years if you have it.

Delete any payment card data before you start. Breweries and distilleries can run the same thing on mug club or bottle club rosters. A retail shop can use loyalty program exports. A distributor can swap members for accounts and shipments for reorders.

The setup

Claude Cowork (now part of Claude) needs a paid plan. Claude Pro runs about $20 a month, or $17 a month billed yearly, and Max starts around $100. Check Anthropic's pricing page before you buy.

Open the Claude desktop app, start a new Cowork prompt, point it at your Club Retention folder, and paste the prompt below. It will read the spreadsheets, group your members by risk, and write the save emails. Give it 10 to 20 minutes on a large file.

When it finishes, spot check five names against your CRM before you send anything, and edit the emails so they sound like you.

Good output: a ranked at-risk list with member names and the specific reason each one is flagged, plus a short, personal email per risk group that offers a fix, not a discount.

More plays on wine clubs and retention

See the whole topic

Sales and RetentionClose the club signup at the bar: five DTC moves for your tasting roomWineries without visibility into club behavior can end up replacing most of their member base every year, according to Commerce7's roundtable with winery owners. These five tactics give you a signup you can finish at the bar, a churn number you can actually see, and a club offer that runs on access instead of discounts.From the Nov 4, 2026 issue Sales and RetentionPay 10 Customers Instead of One Influencer: Four Plays From the Creator DataA Morning Consult survey of 6,283 U.S. adults found small creators drive purchases at the same rate as famous ones, so the fee you pay for reach is largely wasted. These four plays turn club members, staff, and shop clerks into the endorsers buyers actually trust, and name the metric each one moves.From the Oct 30, 2026 issue Sales and RetentionI built you a free tool: see which club members are about to cancelTen saves times your member lifetime value is the return on three minutes with a spreadsheet.From the Oct 15, 2026 issue

What to prepare

The setup

More plays on wine clubs and retention

Get the next play in your inbox.