Skip to main content

Gifters who bought in the last 12 months

Updated over 2 months ago

πŸ“ Public Bookmarks Folder: ENO Preset Campaigns

πŸ“Œ Quick Stats:

  • πŸ”» 2 filter(s) applied

  • πŸ“Š 6 dimension(s) displayed

  • πŸ“ˆ 1 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

LIst of gifters including their email type (personal or corporate)


πŸ”» Filters Applied

The following filters narrow down the data in this bookmark:

πŸ“Š Dimension 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.

  • Email Type β€” Identifies whether the email address is a personal or company email address, or a fake email address (noemail.com,missingemail.com)

πŸ“ˆ Measures:


ℹ️ Additional Details

  • πŸ“ Public Bookmarks Folder: ENO Preset Campaigns

  • πŸ”‘ Bookmark ID: 6241c1be-72f9-4c7d-ba6d-d95a2be48375

Did this answer your question?