Platform: Enolytics DTC
Summary:
What it shows: A ready-made report that identifies customers with incomplete address information in your database. This filtered view shows only customers where part of their address is missing — perfect for data cleanup projects or pre-migration audits. No setup needed; just run and export.
Who should use it:
• Database administrators preparing for system migrations
• Customer service teams cleaning up contact records
When to use it:
• Before migrating to a new system or platform
• During quarterly database maintenance and cleanup
• When preparing for direct mail campaigns that require complete addresses
• After importing customer data from external sources
Questions this report answers:
• "How do I find customers with incomplete addresses in my database?"
• "Can I get a list of all the address records that need to be cleaned up?"
• "Where can I see which customers are missing parts of their contact information?"
• "How do I pull a report showing problematic address data before our system migration?"
• "Which customer records have address gaps that could cause shipping issues?"
Tip: Export this data to Excel to share with your team for systematic cleanup — the Customer Number column makes it easy to locate and update each record in your system.
Note: Parts of this article were generated with AI and may not be perfect. If something looks off or could be better, click the 😞 below — it opens a quick chat so you can let us know.
📂 How to Access This Report
This is a public bookmark — a pre-built report ready for you to use. You don't need to create it from scratch.
To open it:
Click the Bookmarks icon in the left sidebar
Look under Public Bookmarks
Open the folder: WD Customer Sample File
Click Data Migration
Quick Stats:
1 filter(s) applied
11 dimension(s) displayed
0 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
Ready-made report identifies customers with incomplete address information for data cleanup projects and pre-migration audits.
Filters Applied
The following filters narrow down the data in this bookmark:
Dimension Filters:
C7 Address Check is one of: Missing part of Address
📋 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.
Company — Contact's company
Contact Address — Contact's street address**Origin: Original**
Contact Address 2 — Contact's street address 2 (eg. PO Box or Suite)**Origin: Original**
Contact City — Contact's city (residing/billing address)
Contact State — Contact's abbreviated state code (residing/billing address)
Contact Zip Code — Contact's zip code or postal code (residing/billing address)
Contact Country — Contact's abbreviated country code (residing/billing address)
Contact Email — Contact's primary email. If contact has multiple emails, this is will be the primary. This is NOT an array of emails.
ℹ️ Additional Details
Bookmark ID:
f15be4f9-7413-45f2-8ab5-6a725b74c4d5