Real estate database segmentation: the four lists hiding in your CRM

You know the scroll. Late, after the last open, you flick through the CRM looking for someone worth calling tomorrow. Six thousand names go past and somehow the answer is nobody. So you close it and tell yourself you'll prospect properly next week.

Here's the problem. You're reading the database as one list. It isn't one list. Every agent database splits into the same four groups, and each group needs a different first line. Read it as four lists and "who do I even call" turns into a queue.

That's all segmentation is. It's not new software and it's not tags for the sake of tags. It's sorting the people you already know by how they know you, so the first line you send them fits.

Why a blast to everyone is worse than silence

The tempting move is the blast. One email to all six thousand: "Thinking of selling? The market's moving." It feels like prospecting because it touches everyone at once.

Look at who gets it, though. The vendor you sold for in 2019 gets the same line as someone who asked one question about a unit five years ago. She let you into her home. She trusted you with the biggest sale of her life. And your message reads like you've forgotten her name.

A blast treats your warmest people like your coldest ones, and the warm ones notice. Some go quiet for good. Some unsubscribe, and a name that unsubscribes is a door you can't knock on again. Silence keeps the warmth in the tin. A blast tips it out.

The fix isn't more volume, and it isn't going quiet either. It's sending four different first lines to four different relationships. Your own database can feed your listings for years, and the case for working it properly is one we've made before. It starts with the sort.

The four lists and what each one is worth

Every agent database I've looked at splits the same way.

• Group one: the appraisal that never listed. You walked their hallway. You told them a number. They said not yet, and not yet quietly became never, because nobody's diary reminds them. These are the warmest names you own: they invited you into their home once, and most of them still own it. Find them: pull every appraisal and market opinion you've logged, then knock out the ones that listed with anyone. What's left is group one. When you're ready to work it, there's a whole piece on past appraisals that went quiet.
• Group two: the enquiry that went one message deep. A portal enquiry, a price question, a "is it still available". You answered, they went quiet, the record stayed. One reply doesn't end a relationship, it starts one, but almost every CRM treats it as finished business. Find them: search enquiries with exactly one outbound reply and no follow-up task. There are more than you think.
• Group three: the past vendor, drifting. You sold their place years ago. The settlement gift went out, the anniversary card didn't. Life kept moving: kids, downsizing, the block next door selling for a number that made them look up. They liked you once, and the agent they'll use next is whoever's in their world when the thought lands. Find them: past sales, sorted oldest first, minus anyone you've spoken to this year. A group three that's been quiet for years deserves its own plan, and how to wake a dormant database covers it step by step.
• Group four: the walk-in and the underbidder. Signed in at your open, bid at your auction, missed out. They still own a home, and the one they missed tells you exactly what they wanted. Find them: open-home sign-ins and auction records against buyers who never bought through you.

Four saved searches. That's the whole exercise. Run them this week and write four numbers on a sticky note. Most agents have never seen those four numbers. The total is usually a couple of years of listings, sitting in software they already pay for.

Rank by recency and relationship, not alphabet

The sort doesn't stop at four lists. Inside each one, order matters more than size.

An appraisal from eight months ago beats an appraisal from six years ago. A vendor who still sends you a Christmas card beats one you barely knew. So sort each list twice. First by date: when the last real conversation happened, not the last mail-out. Then by warmth: who'd take your call happily, and who'd need a minute to place you.

The alphabet is how the software stores people. It's not how trust fades. The names at the top of each sorted list are this week's calls. The rest aren't lost, they're queued.

One test if you're unsure where someone ranks: could you open with a detail only the two of you would remember? The hallway you walked, the auction they lost, the price they once asked about. If yes, they're warm. If you'd be opening with the market, they've drifted, and they rank lower.

Consent is a segment too

One more column before you start: next to each name, note how they came to you. They hired you, they asked about a home, or they signed in at your open. If a number has no story like that behind it, it doesn't go in the queue, because your name should only land on people who already know it.

What to say to each list first

Different lists, different first lines. Here they are, word for word.

To group one, the appraisal that never listed:

"Last spring I came through your place on Kent Street, and you were weighing up a move. That was a while ago now. Where did that land?"

To group two, the enquiry that went one message deep:

"You asked about the townhouse on Bell Street last year. It sold, but you crossed my mind this week. Still keeping an eye out?"

To group three, the past vendor:

"It's coming up on four years since we sold Milton Street. I still point it out when I drive past. How's the new place treating you?"

To group four, the open-home walk-in or the underbidder:

"You bid on Harper Street and missed out. Something close to it is coming up quietly. Want a look before it goes online?"

Notice what none of them do. They don't pitch an appraisal. They don't quote the market. Each one names a moment you already share, then asks one small question. The first message earns a reply. The reply earns the coffee, and the coffee earns the listing, in its own time.

Swap in the real street and the real season. The shape stays the same every time: the shared moment first, then the question.

Send each one the way you'd naturally reach that person. A past vendor gets a call, because you've earned the phone. A one-message enquiry gets a text, because a text is easy to answer from the couch. If they reply, you're in a conversation. Conversations are the whole point of the sort.

The list to start with this week

Start with group one. Warmth beats volume, and an appraisal you did is the warmest paper trail in real estate. These people have already had you in their home. They've already heard your number. Most of them still own the place.

So here's the week, laid out plain.

• Monday: run the four saved searches and write the four numbers down.
• Tuesday: sort group one by date and warmth.
• Wednesday to Friday: send ten first lines from group one, each built on the moment you share.

Ten notes to past appraisals will do more for your spring than a blast to six thousand ever has. And once group one is moving, the other three lists are sitting there, sorted and ready for the weeks after.

One last habit. The four searches aren't a one-off, so save them and run them again on the first of each month. New appraisals age into group one. Fresh enquiries slip into group two the moment you stop replying. A sorted database drifts back into one big pile unless the sort runs on a rhythm.

The sorting is an hour. The follow-up is the part that slips while you're busy being an agent. If you'd like to see the four lists pulled from your actual database, and a week of quiet contact run on the warmest one in your own name, book a call, because a sorted queue only pays when someone works it every day.