π 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:
Order As Gift is one of: likely
Buyer Profile is one of: 3 Month Buyer, 6 Month Buyer, 9 Month Buyer, 12 Month Buyer
π 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
