Every broker believes they're “pretty responsive.” Almost none have measured it — and the measurement is routinely a shock, because the leads that arrive while you're in appointments, at dinner, or asleep don't feel like slow responses. They feel like nothing at all, which is exactly the problem.
This worksheet is the measurement. It takes about an hour with your inbox and CRM open, produces four numbers you'll never unsee, and ends with a concrete automation map. Grab your last twenty leads and work the passes in order.
Pass 1. Pull the last twenty leads, no cherry-picking
List your last twenty enquiries across every channel — website forms, ad leads, social DMs, referral texts, missed calls with voicemail. For each, record: source, date and time it arrived, date and time of your first substantive response (an auto-acknowledgement email doesn't count), and the current status: booked, in conversation, went quiet, or lost.
- 01Include the embarrassing ones — the DM you found four days later is exactly the data point that matters.
- 02Note which leads arrived outside business hours (evenings, weekends): flag them.
- 03If you can't reconstruct a lead's timeline at all, record it as its own finding — untrackable leads are a systems gap in themselves.
Pass 2. Compute the four numbers
From the twenty rows, calculate: (1) Median first-response time — the honest middle, not your proudest save. (2) After-hours share — what fraction arrived evenings and weekends. (3) Five-minute rate — how many of twenty got a substantive reply inside five minutes. (4) Quiet rate — how many went silent before any real conversation happened.
Typical findings for a busy solo broker: median response in hours; a third to half of leads after-hours; a five-minute rate near zero; and a quiet rate of 30–50%. If that's roughly your sheet, you're normal — and you're leaking. The reason those numbers matter this much is the decay curve covered in the speed-to-lead article: contact and conversion odds collapse within the first hour.
Reality check: cross-reference your fastest five responses against outcomes. For most brokers, the pattern is uncomfortable and unmistakable — the deals cluster where the speed was.
Pass 3. Map where leads actually go cold
Now locate the leaks by pattern, not anecdote. Group your quiet-rate leads and ask: did they arrive after-hours? From one particular channel (DMs are the classic blind spot — forms get checked, social doesn't)? Did they get a first response but no follow-up after going quiet once? Each cluster is a different leak with a different fix.
- →After-hours cluster: a coverage gap — no human fix exists; this is automation's home turf.
- →Channel cluster: a routing gap — every lead source needs to land in one queue, not five apps.
- →One-touch-then-nothing cluster: a persistence gap — most leads need multiple touches, and manual persistence dies on busy weeks.
- →Slow-even-in-office cluster: a triage gap — you're seeing leads but can't break from files to answer; the enquiry needs an instant holder while you finish.
Pass 4. Price the leak in funded-deal terms
Estimate conservatively: of your quiet-rate leads, assume even a modest fraction — say one in four — would have converted with five-minute response and persistent follow-up. Multiply by your average revenue per funded file, then annualize from your monthly lead volume. For a broker seeing thirty leads a month with a 40% quiet rate, even cautious assumptions put the leak at several funded deals a year — often the difference between a flat year and a growth year, lost entirely in response gaps.
Write the number down. It's the budget line every automation decision gets compared against — and it's almost always a multiple of what closing the gap costs.
Pass 5. Map what automation takes first
Match fixes to your clusters, in payback order. First: instant first response on every channel — an AI assistant that acknowledges, asks one qualifying question, and offers booking within about a minute, 24/7. It erases the after-hours cluster and the triage cluster simultaneously, which is why it's always first — the anatomy is in the Engage walkthrough. Second: unified routing — forms, DMs, and missed calls into one queue with one status view. Third: persistence sequences — spaced, polite follow-ups for quiet leads, with human escalation rules.
Equally important, mark what stays yours: the booked conversations, the advice, anything emotional. The map should read like the boundary in the AI-or-Human guide — machines on the clock work, you on the judgment work.
Re-run it quarterly (the numbers drift)
Response systems decay like everything else: a new lead source launches unrouted, a sequence gets paused and forgotten, volume grows past the setup. Re-run passes one and two quarterly — twenty minutes once the tracking exists — and hold the line at a five-minute median, around the clock. The worksheet's job is done when the four numbers stop being scary and start being boring.