Resource 02 · Database
Database Opportunity Audit
A practical way to see what is in your existing contacts, and what must be true before you message any of them.
Watch
- The problem: you know far more people than you are actively talking to
- What goes wrong: treating the database as one list and blasting the same message
- The fix: four groups, and a twenty-name sort as a quick test
- What we would show: the structure in your actual CRM before any new advertising
The problem
Years in the business leave you with more relationships than you actively talk to, scattered across your phone, an old CRM, email and past files.
The common mistake is treating that as one giant list and sending everyone the same message. Most are not ready to move, and some should not be contacted at all.
What to look at
- Back it up firstExport the full database before changing anything. If a cleanup goes wrong, you can restore it.
- Use four segmentsActive conversations; past clients and referral partners; longer-term nurture; and do not contact. Every contact belongs in exactly one.
- Sort twenty by handPick twenty contacts at random and sort them yourself. It takes ten minutes and tells you roughly what the whole list looks like.
- Build the do-not-contact segment firstOpt-outs, do-not-call results, bounced emails, wrong numbers and anyone you cannot show permission for. This protects you and your license.
- Decide before you sendNo campaign yet. The first goal is a structure that makes the next step for each relationship obvious.
Do the exercise
Count your twenty-contact sample into the four segments, then answer five consent and data checks. No list upload and no names.
Database opportunity audit
Sort a sample of 20 contacts by hand. No list upload, no names entered.
Sorted so far: 0 of a suggested 20.
5 consent checks still open. Do not text, call or email this database until every check is a yes. Do-not-call and texting rules apply to old lists too.
Your first 30 days
- Week 1: export a full backup of the database before you change a single record.
- Week 1: build the do-not-contact segment first. Collect every opt-out, do-not-call result and unknown-permission contact into it.
- Week 2: flag bounced emails and bad numbers so they never enter a campaign.
- Week 2: add the four segments as tags or lists in your CRM and sort the next 100 contacts.
- Week 4: decide whether a small, permission-checked pilot to the nurture segment is worth running. Measure replies and appointments, not sends.
How to read your result
- Shares from a twenty-contact sample are rough. The plausible range shown next to each share is wide on purpose: it is the honest uncertainty of a small sample.
- If any consent check is open, the plan starts with cleanup, not outreach. Texting and calling rules apply to old contacts too.
- A large nurture segment is normal. It is a reason for a slow, value-first plan, not a blast.
What Anu would build
The four segments as tags or smart lists in your CRM, a do-not-contact list the whole team uses, and a small, permission-checked pilot measured by replies and appointments.
We do not text old lists without verifying permission and do-not-call status first.
Go deeper in the Playbook
- Playbook 04.01Export and back up your database before you touch itMake a restorable backup before any cleanup.
- Playbook 04.03Audit opt-outs and consent before anyone gets a messageBuild the do-not-contact segment properly.
- Playbook 04.04Build Smart Lists for past clients, sphere and dormant leadsTurn the four segments into lists in your CRM.
- Playbook 04.07Run a 100-contact reactivation pilot with stop rulesTest a small, permission-checked pilot.
Next step
Map the first 30 days of database cleanup.
Ready to see how this applies to your business? A conversation with Nick is free and is not the paid program.
Talk through your businessRelated resources
This page uses no client data. Projections come only from the sample you sort and are labeled as rough ranges. Educational content, not legal, tax or compliance advice. See the privacy policy.