The CRM Audit you need to do
Most agents have thousands of contacts sitting in their CRM.
Past clients. Old leads. Sphere connections. Referral sources. People they met at an open house three years ago.
Somewhere in there is a gold mine. But most agents will never find it because they’ve never actually audited what they have.
They’re too busy chasing new leads to work the database they already paid for.
Where Money Actually Hides
Here’s the math everyone ignores.
A new lead costs money. Whether you’re buying from Zillow, running Facebook ads, or paying for sphere marketing, lead gen is expensive.
A past client costs nothing. Already in your database. Already trust you. Already converted once.
Lifetime value of a past client is 5-10x higher than a cold lead.
Yet most agents spend 90% of their time chasing cold leads and 10% nurturing their database.
This isn’t just inefficient. It’s backwards.
The Four-Question Audit
Most CRM audits are overcomplicated. You don’t need a consultant. You need four questions.
How many contacts do I actually have?
Not the number your CRM shows. The real number after you remove duplicates, bad emails, people who moved out of market, leads that were never real to begin with.
Most agents think they have 2,000 contacts. After cleaning, it’s closer to 800.
When did I last contact each person?
Sort your database by last contact date. What you’ll find is brutal.
40% haven’t been contacted in over a year. 20% haven’t been contacted in two years. 10% you literally don’t remember.
That’s not a database. That’s a graveyard.
Who’s most likely to transact in the next 12 months?
Not gut feel. Actual signals.
Past clients who bought 5-7 years ago are statistically likely to move again. People who inquired about buying but didn’t convert might be ready now. Sphere contacts who just had a life event—marriage, baby, job change—are high probability.
Most agents can’t answer this because they’re not tracking signals.
What’s my actual re-engagement plan?
Not the plan you wish you had. The one that exists right now.
For most agents, the answer is “I send a newsletter sometimes” or “I post on social.”
That’s not a plan. That’s hope.
The Three-Tier System
Once you audit, you need a system. Not complicated. Just real.
Tier 1: High-probability contacts. Past clients, hot leads from the past year, sphere showing buying signals. These get personal touchpoints. Calls, texts, handwritten notes. You’re deliberately staying top of mind.
How many people in Tier 1? If you’re honest, probably 50-100.
That’s manageable. One touch per quarter means 4-6 people per week. Less than an hour.
Tier 2: Medium-probability contacts. People you’ve done business with but not recently. Warm leads that didn’t convert. Sphere you haven’t talked to in a while.
These get systematized touchpoints. Email campaigns, market updates, value content. You’re staying visible without personal effort.
Tier 2 might be 200-400 people. Your CRM handles this if you set it up right.
Tier 3: Low-probability contacts. Everyone else. People you met once, cold leads that never engaged, contacts you’re not even sure why you have.
Generic marketing. Monthly newsletter maybe. Or archive them.
Most agents resist this because they think everyone’s valuable. They’re not. Treating everyone the same means nobody gets the attention they deserve.
The 90-Day Reactivation Plan
Here’s what works:
Week 1-2: Clean the data. Remove duplicates, fix contact info, archive dead leads. Not fun. Necessary. Can’t execute on bad data.
Week 3-4: Segment by tier. Go through every contact, decide which tier. High, medium, or low.
Week 5-6: Build the touch plan. What does Tier 1 get? Tier 2? Set up campaigns, draft templates, create the calendar.
Week 7-12: Execute and track. Start reaching out. Track responses. Adjust.
Takes 90 days of consistent effort. Most agents won’t do it because it’s not sexy. Not a new lead source. Not a shiny tool.
But it’s the highest-ROI activity most agents could do.
Why This Fails (And The Fix)
Biggest reason database work doesn’t happen: it’s not urgent.
Lead comes in from Zillow, you respond today. Database can wait.
Except it can’t. While you’re chasing new leads, your past clients are hiring other agents.
The fix: make it systematic. Block two hours every Monday morning. Database time. No exceptions.
Not waiting for inspiration. Not doing it when you feel like it. It’s on the calendar. You execute whether you want to or not.
Two hours a week, consistently, transforms your business in six months.
The Only Metric That Matters
Most agents track new leads. Smart agents track database reactivation rate.
What percentage of your business comes from existing database versus new sources?
Below 40%? You’re leaving money on the table.
The goal is flipping that ratio. 60-70% should come from people already in your database. Rest comes from new sources.
That’s sustainable. That’s a business that doesn’t break when lead costs spike or algorithms change.
Your database is already paid for. You just have to use it.
