Skip to main content

Wine Club Membership Data and Reporting

How to find and export wine club membership data including status, start and cancellation dates, members by state, and first allotment history.

Corksy offers wine club reporting in two places: the Reports → Club area (pre-built club reports, including signups) and the Wine Clubs → Memberships list and its export (for member-level lookups such as who's active, who cancelled, when they joined, and what state they're in). This article covers the most frequently needed lookups.


Wine club signups report (by sales associate and club type)

To see new wine club signups — including which sales associate created each membership and the club / membership type — use the built-in Club signups report:

  1. Go to Reports → Club.

  2. Open the Club signups report.

This report shows wine club signups and can be reviewed by sales associate and club type, which makes it useful for monthly staff reporting or bonus tracking.

Note: This is a pre-built report — you do not need to build it from the Memberships export. If you need member-level detail (start/cancel dates, state), use the Memberships export described below.


Viewing Members by Status

By default, the Memberships list shows only Active members. To see members with other statuses:

  1. Go to Wine Clubs → Memberships.

  2. Click the Status filter and change it to All.

  3. The list will now show members with any status: Active, Paused, or Cancelled.

You can also filter to show only cancelled or only paused members using the same dropdown.


Membership Start Date and Cancellation Date

Both dates are available in the Memberships export:

  1. Go to Wine Clubs → Memberships.

  2. Filter by status as needed, then click Export.

  3. In the exported file:

    • Membership Start Date = the date the member joined the wine club.

    • Membership End Date = the date the membership was cancelled (only populated for cancelled members).

Note: These date fields are not visible in the Memberships list view — they only appear in the exported file.


Listing Members by State

There's no built-in "members by state" report, but the Memberships export includes state data:

  1. Go to Wine Clubs → Memberships and filter by club and/or status as needed.

  2. Click Export.

  3. In the exported file, sort or filter by the State or State Code column to group members by shipping state.

This is especially useful for compliance planning — knowing how many members ship to each state before running a club release.


Tracking First Allotment Recipients

There's no native "first allotment received" report in Corksy. The most reliable workaround is to use your Wine Club order history:

  1. Go to Reports → Sales → Sales by Order.

  2. Export the report and open it in Excel or Google Sheets.

  3. Filter the Order Type column to show only Wine Club orders.

  4. Sort by member and then by order date (ascending).

  5. Each member's earliest order in this filtered list is their first allotment.

Tip: If you want to tag new members for email marketing, you can import this list into Klaviyo or Mailchimp and create a "First Allotment Received" segment for targeted messaging.


Related Articles

Did this answer your question?