Lead Audit: Money Falling Through the Cracks

Two-agent team (Dana & Ryan) · 20 CRM rows + 11 paper sign-ins · Audited July 23, 2026 · Commissions at 2.5% side

TL;DR

~$650K

Gross commission sitting in neglected leads (overdue, contactless, or on paper)

~$130–140K

Expected commission being left on the table (probability-weighted by stage)

11 leads

July 13 open-house sign-ins still in a paper folder — never entered (~$190K raw pipeline)

7 of 20

Rows with no next follow-up date set — nothing without a date gets called

The headline isn't one lead — it's two habits. Nearly every dollar at risk traces to (1) leads leaving conversations without a next-follow-up date, and (2) open-house sign-ins never making it into the system. The "Hot" leads are getting worse service than the warm ones.

Every Lead at Risk, Ranked by Revenue

Click any column header to sort.

Lead	Agent	Stage	GCI @ 2.5%	Days Overdue	Status (as of Jul 23)
The Hendersons — sell $1.2M + buy $1.6M	Dana	Warm	$70K	9	Double deal. The bridge-strategy conversation they need never happened.
Sarah & David Kim — buy ~$1M + list home	Ryan	Hot	~$50K	2	Hot referral double deal from past clients. No phone number on file.
Robert Chen — $2M+ investor	Dana	Warm	$50K	79	Said "circle back in a few weeks" on Apr 28. It has been 12 weeks. Buys every 12–18 months.
Frank DiStefano — Point Loma listing $1.8M	Dana	Hot	$45K	6	Interviewing 2 other agents this week. No email on file.
Kevin O'Brien — Encinitas $1.5M+	Dana	Cold	$37.5K	158	Lowballed last winter, went quiet. Exactly who re-engages when the market shifts.
Tom Bradley — 4S Ranch relo $1.3–1.6M	Dana	Warm	$36K	22	Wife flies in Aug 8–10 to tour — 16 days away — and no tour is built.
Jennifer Martinez — pre-approved $1.2–1.5M	Both?!	Hot	$34K	41*	Lease ends Sept 1. 41 days since Dana's last touch. Duplicate row, assigned to both agents.
Dan & Rachel Foster — Carlsbad $1.1–1.3M	Ryan	Cold	$30K	75	"Went with another agent? unclear" — nobody found out. Rachel still opens every newsletter.
Steve Yamamoto — Clairemont estate listing $950K	Dana	Warm	$24K	1	Sensitive estate sale — barely overdue, but don't let it drift like the rest.
Carlos & Maria Vega — Chula Vista $700–850K	Ryan	Warm	$19K	14	Baby due November; closing before it means under contract by ~September.
Olivia Nguyen — Little Italy $700–850K	Dana	New	$19K	39*	Signed in at an open house June 14. Zero contact in 39 days.
Priya Patel — UTC condo, cash buyer	Ryan	New	$18K	no date set	Cash buyer, inquired Jul 21. No follow-up scheduled.
Mike Thompson — Downtown condo $600–750K	Dana	New	$17K	51	Open house May 30. Notes literally say "never called back."
Grace Liu — Mission Valley $600–700K	Ryan	Warm	$16K	16	Got 4 listings, went silent. Needs a phone call, not a 5th listing.
Marcus Webb — Santee, VA loan	Ryan	New	$16K	no date set	Deploys in January — hard deadline. No follow-up scheduled.
Ashley Rodriguez — North County townhome	Ryan	New	$15K	no date set	First-time buyer, needs a lender intro — a same-day task, unscheduled.
Bianca Torres — Otay Ranch townhome	Ryan	New	$14K	no date set	Messaged the page yesterday. Speed-to-lead window closes today.
Linda Okafor — La Mesa condo	Dana	Cold	$12.5K	124	Paused in March, said "maybe summer." The notes even say it: IT IS SUMMER.
Old Town open-house batch — 11 sign-ins	nobody	Not entered	~$190K raw	10	11 humans in a paper folder since July 13. No names, no contacts, no owner in the CRM.

* Days since last contact — no follow-up date was ever set.

Duplicates & Data Problems

Jennifer Martinez is in twice (same name and phone, different emails) — assigned to both Dana and Ryan. Each likely assumes the other owns her; net result: a hot, pre-approved buyer went 41 days without a call. Merge the rows, give her one owner (Dana had her first), delete the duplicate.
The hottest leads have the worst data: the Kims (hot double deal) have no phone; DiStefano (competitive $1.8M listing) has no email.
7 of 20 rows have a blank next-follow-up date — every one of Ryan's new leads. Nothing without a date gets called.
The batch row hides 11 leads — no names, no contacts, no agent. Eleven people reduced to one placeholder.
Hygiene: inconsistent price formats ("$1.4M" vs. ranges vs. "sell $1.2M buy $1.6M"), and buyer/seller type crammed into the property-interest field — you can't filter the listing pipeline from the buyer pipeline.

The Three Patterns Behind the Leak

1. Open House is a black hole

Every open-house-sourced lead is either never called (Thompson), gone dark after sign-in (Nguyen), duplicated (Martinez), or still on paper (the batch of 11). The team's best in-person source has a 0% follow-through rate.

2. "Hot" gets worse service than "Warm"

The three hottest opportunities — Martinez (41 days dark), DiStefano (overdue during his interview week), the Kims (missing phone) — are the most neglected rows in the file.

3. Two agents, two different failure modes

Dana holds nearly all the stale inventory (Chen 79d, O'Brien 158d, Okafor 124d, Thompson 51d). Ryan responds fast but never sets a follow-up date, so his new leads quietly become Dana-style stale leads in a month.

The 5 Calls This Team Must Make Today

1. Frank DiStefano $45K could be lost this week

Dana calls. He's interviewing two other agents right now. Don't "check in" — book the listing appointment. Get his email on the call.

"Frank, I want your listing and I came prepared — I've pulled Point Loma comps and drafted a pricing and timeline plan that gets you to Arizona on your schedule. Can I walk you through it tomorrow, before you decide anything?"

2. Sarah & David Kim ~$50K hot referral double deal

Ryan emails today (no phone on file — getting one is ask #1). A blown referral also burns the Nguyens, the past clients who sent them.

"The Nguyens told us great things — here's the game plan for a sell-and-buy: we list your home, run the Poway search in parallel, and I'll show you how the contingency works so you're never homeless in between. When can I walk your current house this week?"

3. Jennifer Martinez $34K lease ends Sept 1

Resolve the duplicate FIRST so both agents don't call. To close by Sept 1 she must be writing offers within ~2 weeks. Bring concrete listings and a date, not "are you still looking?"

"Jennifer, I owe you an apology for the gap. Here's the math: to be in by September 1 we should be writing offers within two weeks. I've pulled three fresh Carmel Valley 4-bedrooms near the schools you wanted — can we tour Saturday?"

4. The Hendersons $70K biggest number in the file

Dana calls with the answer to the exact question stalling them: how to buy at $1.6M before selling at $1.2M.

"I built out your three options — contingent offer, bridge loan, or a HELOC on the Scripps Ranch house — with a net sheet for each. Thirty minutes this week and you'll know exactly which one fits."

5. Tom Bradley $36K wife tours Aug 8–10

Dana calls. If a tour itinerary isn't in his wife's inbox this week, they tour with a Zillow-assigned agent.

"Tom, locking in August 8–10: I'm building a two-day tour of 4S Ranch — send me her must-haves and I'll have the full itinerary plus a local lender intro to you by Friday."

Also today (delegable)

Enter the 11 paper sign-ins and call every one — 10 days cold, ~$190K raw pipeline in a folder.
Reply to Bianca Torres before end of day — she messaged yesterday.
Text Priya Patel — cash buyers close in three weeks.

Process Fixes Worth More Than Any Single Lead

No lead leaves a conversation without a next-follow-up date. Blank date = invisible lead. This one rule addresses 7 of 20 rows.
Open-house sign-ins entered same night, each with an owner and a next-day call scheduled.
One owner per lead — dedupe on phone number weekly; a lead in two names is a lead in no one's name.
Phone AND email required before a lead can be marked Hot.
Weekly stale-lead review: anything 7+ days overdue gets called or consciously closed — not left to rot at 158 days.