Cancelled Memberships Report
  • 24 Jun 2024
  • 1 Minute to read
  • Dark
    Light
  • PDF

Cancelled Memberships Report

  • Dark
    Light
  • PDF

Article summary

This report provides a view of cancelled club memberships based on cancellation date.

Generating Report

Log in to WineDirect > Analytics > Reports > Clubs to generate a Cancelled Memberships Report.

Selecting View Report will open a new window, and clicking Generate Report will generate the report.

IMPORTANT NOTE: If you have already generated a template and wish to reuse it, click the dropdown and select the template.

Creating and Updating Filters

Prior to generating a Cancelled Memberships Report, it is possible to add and/or update filters to identify records that need to be viewed. Here is a breakdown of the currently available filters:

  1. Signup Date - You can select any day/date range.

  2. Cancellation Date - You can select any day/date range.

  3. Last Updated Date - You can select any day/date range.

  4. Credit Card Expiration Date - You can select any day/date range.

  5. Membership Status - Membership Status equals or does not equal Membership Status (can choose multiple).

  6. Club Name - Club Name equals or does not equal Club Name (can choose multiple).

  7. Delivery Preference - Delivery Preference equals or does not equal Delivery Preference (can choose multiple).

  8. Pickup Location - Pickup Location equals or does not equal Pickup Location (can choose multiple).

  9. Shipping Location - Shipping Location equals or does not equal Shipping Location (can choose multiple).

Downloading Report

Once you have generated a Cancelled Memberships Report, you can find your report in the Generated Reports tab under Analytics.

Under the STATUS column, you should see a DOWNLOAD button. Click here to download the report to your local computer.

IMPORTANT NOTE: You may see Queued/Processing (the report is still processing, and you can hit the refresh button to see if it's ready) or Failed if there was an issue generating the report.

Report Columns

For the Cancelled Memberships Report, the following columns will be generated:

id

membership_number

last_name

first_name

email

date_of_birth

phone

club

club_option

created_at

updated_at

cancelled_at

status

delivery_preference

staff_notes

manual_processing_required

manual_processing_instructions

card_brand

card_last4

card_expiry

card_name

billing_first_name

billing_last_name

billing_date_of_birth

billing_business_name

billing_address1

billing_address2

billing_city

billing_subdivision

billing_country_code

billing_postal_code

billing_phone

billing_email

shipping_first_name

shipping_last_name

shipping_date_of_birth

shipping_business_name

shipping_address1

shipping_address2

shipping_city

shipping_subdivision

shipping_country_code

shipping_postal_code

shipping_phone

shipping_email

pickup_location


Was this article helpful?