🔻 2 filter(s) applied

📊 10 dimension(s) displayed

📈 0 measure(s) displayed

📄 Report Page: Build Beyond Limits | Advanced Reporting

Days Till Next Club Anniversary is between: 0, 30

Club Membership Status is one of: Active, On Hold

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.

Days Until Contact Next Club Anniversary — Number of days until the contact's next club membership anniversary date

Initial Signed Up Date — Timezone adjusted date for initial_signed_up_at

Active Club Membership In Months

Club Membership Status — The current membership status. This will likely be one of the following statuses: Active, On Hold, or Cancelled.

Club 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.

📁 Public Bookmarks Folder: ENO Preset Campaigns/Routine Campaigns

🔑 Bookmark ID: a733c6c8-a6ac-4bc1-b4f6-7efa8b2d4b51