← All posts

Prospect Tracking Best Practices for Real Estate Brokerages

By Phillip Gagnon · October 25, 2026 · 14 min read

Brokerage leader updates prospect tracking spreadsheet

Good prospect tracking comes down to four habits. Define each stage by something the agent has actually done. Keep one record per prospect with a named owner and a dated next step. Follow up on a set schedule. Review the whole pipeline once a week, and make that review a meeting where decisions get made. Everything below shows how to set that up this week, whether you use a spreadsheet or a platform.

This guide is for brokers, owners and team leaders who recruit agents. It is built around one idea: every prospect is an agent with their own goals, and your tracking should record what that agent wants, not just what you want from them.

3 Data Pulse

3datapulse.com

Keep Recruiting Prospects Moving

3 Data Pulse ranks market prospects, tracks them from first touch to signed, and provides personalized outreach to support a steadier recruiting pipeline.

Explore prospect tracking

TL;DR

Define stages by what the agent has done or said (“agreed to a discovery conversation”), never by what you did (“email sent”).
Every prospect gets one record, one owner, one next step and one date. No date, no follow-up.
Record the agent’s goal in their own words. It is the most useful field you will ever write down.
Run a 45-minute weekly review that starts with the prospects closest to a decision.
Treat each recruit as a future retention case: the notes you take now should shape their first week with you.

Why most prospect tracking quietly fails
Define five stages by what the agent has done
What belongs in each prospect record
Set a follow-up cadence and stick to it
Run a 45-minute weekly pipeline review
Measure a few things, and measure them weekly
Treat every prospect as a future retention case
Our perspective: track the agent, not the funnel
Where 3 Data Pulse fits
A seven-day plan to start this week
FAQ
Sources

Why most prospect tracking quietly fails

Most brokerages do not lack a list of agents they would like to recruit. They lack a list that anyone trusts. A name sits in a spreadsheet for four months, nobody remembers who last called, and the agent signs with someone else.

Three patterns cause most of it:

Stages describe your activity, not the agent’s position. When a stage is “contacted,” anyone can move a prospect forward by sending a message. The pipeline fills with prospects who never replied. Pipeline stages work best when they are verifiable states, because stages based on seller tasks let deals advance without real engagement and turn the pipeline into a graveyard with no exit criteria.
Nothing forces a next step. A record with no owner and no date is a note, not a prospect.
The data goes stale. One CRM measurement guide suggests an audit where at least 70% of critical records are updated within 90 days; below that, conversion rates and projections stop being reliable. Apply the same test to your recruiting list. If fewer than seven in ten active prospects have been touched in the last quarter, your list is a wish list.

The timing matters more now. Industry reporting says external agent moves were up 25% quarter-over-quarter in Q1 2026, with roughly 50,000 brokerage changes projected for the year. Agents are weighing their options constantly. A broker who tracks loosely will miss the window when a specific agent is open to a conversation.

Define five stages by what the agent has done

Five stages are enough for a brokerage of almost any size: Identified, Contacted, Engaged, Interviewing and Decided. The names matter less than the exit rule for each. Write the rule down and keep it where everyone can see it.

Stage	Move the prospect here when…	Next step to schedule
Identified	The agent fits your market and has a reason to talk now (an office move, a production change, a life event)	First personal message anchored in their own business
Contacted	You have sent the first message	Follow-up touches on your cadence
Engaged	The agent has replied or accepted a conversation	Book a discovery conversation
Interviewing	The agent has shared their goals and sat down with you	Show how your coaching and support map to those goals
Decided	The agent has said yes or no, in writing	Onboarding plan, or a dated check-in if the answer is “not now”

Notice what is missing: percentages and guesses. A stage should require observable evidence. If you cannot point to the reply, the calendar invite or the note, the prospect has not moved.

Two rules keep the stages honest:

A “no” is a stage, not a deletion. Mark the prospect Decided, record the reason in the agent’s words, and set a check-in date. Agents who say no in March are often listening in September.
Cap the Contacted stage. If a prospect has had your full cadence with no reply, move them to a nurture list with a date to review. Do not let them sit in Contacted forever and inflate the pipeline.

If you want a deeper look at spotting where prospects stall between stages, our guide to recruiting pipeline management walks through a seven-day leak check.

What belongs in each prospect record

A spreadsheet is a perfectly good place to start, and plenty of good brokerages begin there. The columns matter more than the tool. Keep the sheet short enough that people actually fill it in.

Core columns (the minimum)

Agent name, current brokerage and office
Stage (a dropdown, using the five above)
Owner (one person, not “the team”)
Next step and next-step date
Date of last real conversation (not last attempt)

Agent-centered columns (the ones most sheets skip)

The agent’s stated goal. For example: “wants a transaction coordinator” or “wants to build a buyer team in two years.” Use their words.
What is missing where they are now. Training, lead support, a listing process, a mentor.
Timing signal. A recent office move, a production trend, a change in their current company, a conversation at a closing.
Who referred or introduced you, if anyone.

Operating columns

Touch count and date of first touch
Reason for a “no” or “not now”
Review-by date for nurture prospects

Three habits keep a spreadsheet alive. Lock the stage column to a dropdown so no one invents a stage. Add conditional formatting that turns any row red when the next-step date is past. And sort every Monday by next-step date, oldest first.

The spreadsheet’s weakness is not structure, it is upkeep. Someone has to find the prospects, pull the production numbers, and remember to update the sheet after every call. That is where most spreadsheets die, around week six. If you notice yours slipping, that is the signal to let software carry the data gathering. The recruiting software we built searches MLS data, scores agents for fit and keeps the record current, so your team’s time goes to conversations.

Set a follow-up cadence and stick to it

The most common tracking mistake is quitting after one or two attempts. A first message that goes unanswered usually says nothing about the agent’s interest. It says they were busy that Tuesday.

A workable cadence for the Contacted stage looks like this:

Day 1: a short personal message that references something real about the agent’s business.
Day 4: a phone call, with a brief voicemail if there is no answer.
Day 9: a message offering something useful, such as a market observation about their farm area.
Day 14: a second call at a different time of day.
Day 21: a short note asking whether a conversation would be useful at all.
Day 28: a polite closing message that leaves the door open, then move the prospect to nurture with a review date.

Six touches over four weeks is a structure we recommend, not a law. Adjust it to your market, but keep two principles. First, every touch should be about the agent, so build each message on their real production and goals rather than a generic pitch about your company. Second, log every touch in the record the same day. If it is not logged, it did not happen, and the next person will repeat it.

For what to say, see our piece on recruiting scripts that get agents to talk.

Run a 45-minute weekly pipeline review

A weekly review is where tracking turns into recruits. The key is the format. One operator’s weekly deal review system argues that the meeting must be a decision-making meeting, not a status meeting, and that it should start with opportunities closest to a decision, where one missing piece is the only barrier. That advice carries straight over to recruiting.

Here is an agenda you can use on Monday:

Minutes 0 to 5: Data check. Sort by next-step date. Any overdue row gets a new date or gets moved to nurture before you discuss anything else.

Minutes 5 to 20: Closest to a decision. Walk through every prospect in Interviewing and the warmest in Engaged. For each, answer one question: what is the one thing standing between this agent and a decision? A question about the coaching program? A conversation with a current client? A meeting with another agent in your office? Assign the fix, with a date.

Minutes 20 to 32: Stalled prospects. Look at anyone whose stage has not changed in 21 days. Decide: change approach, hand to a different owner, or move to nurture.

Minutes 32 to 40: New Identified agents. Choose the next five to contact this week and who owns each.

Minutes 40 to 45: Commitments. Read back every action, owner and date. Someone writes them in the record before the meeting ends.

Three rules protect the meeting. No research during the meeting; if you need facts, someone gets them by Wednesday. No prospect leaves without a next step. And every name on the list is discussed as a person: what does this agent want, and what would help them?

Our nine weekly steps from outreach to coaching shows how this review fits into a full weekly recruiting rhythm.

Measure a few things, and measure them weekly

Resist a dashboard with thirty numbers. Track these:

Conversations held this week (replies and meetings, not messages sent)
Prospects per stage and the count that moved forward
Days in stage for anyone over 21
Overdue next steps (the target is zero)
Reasons for “no” grouped monthly, because they tell you what to fix in your support, training or onboarding

The last one is underrated. If three agents in a quarter say they did not see enough lead-generation support, you have learned something about your offer, and it may be a coaching gap you can close. Brokerages win agents through coaching and support, so your “no” data should feed straight back into that.

Treat every prospect as a future retention case

Most brokers run recruiting and retention as two workflows. Industry insiders treat them as one cycle: every agent you recruit is already a future retention risk, and the support you build from day one prevents drift later.

Your tracking can carry that forward in practice:

Copy the goal field into the onboarding plan. If the agent told you in discovery they want to build a buyer team, the first week should include a conversation about exactly that.
Show proof of your support early. Reporting from Inman, summarizing industry leaders, describes agents who join regular learning programs showing 92% retention, 16 points higher than those who do not. A recruit who sees coaching working in week one has a reason to stay.
Change the one-on-one question. The same HousingWire piece suggests moving away from “how many calls did you make?” toward “what did you drop this week, and where did it fall?” That finds the gap in an agent’s support system, which is a problem you can solve, rather than a number you can only pressure.

The same Inman reporting notes that internal office-to-office transfers rose 38% year over year, which suggests agents are looking for better support and less friction, not just a different logo. That is why our approach to retention starts with the same data you use to recruit.

Our perspective: track the agent, not the funnel

We built 3 Data Pulse because we kept seeing the same pattern. Brokers know what grows a brokerage: recruit steadily, keep good agents happy, coach everyone up. The problem is not knowing. It is that doing all three well takes a full-time team most brokerages cannot justify.

So our view of prospect tracking is simple. A pipeline is a list of agents with goals, and your job is to find out whether your brokerage can help them reach those goals. If it can, tracking makes sure you say so at the right moment, with the right words, and follow through. If it cannot, a good record tells you that honestly and early.

We also believe a brokerage wins and keeps agents through coaching and support, not through the commission split. Agents are independent businesspeople. They stay where someone helps them build something. That is why we put an interview playbook, personalized outreach based on each agent’s real production, and weekly coaching material in the same place as the tracking: they are one job, not three.

Where 3 Data Pulse fits

If you are tracking by hand today, you do not need to change anything to start the practices above. When the upkeep becomes the bottleneck, 3 Data Pulse does the heavy lifting: it scans the MLS, scores every agent in your market, ranks them by opportunity, and gives you a short weekly call list with personalized outreach already drafted. Each prospect carries a guided five-step interview playbook, and progress is tracked from first contact to decision. It runs from data your brokerage already generates, so there is no new data entry and no agent has to fill anything out.

Pricing is usage-based. Managing an agent costs $1 per month per agent, with a $250 per month minimum. Agents you are actively recruiting cost 25 cents per prospect per month. See the pricing page for the current details. For how recruiting and deal records fit together, see our write-up on brokerage CRM features.

A seven-day plan to start this week

Monday: Write your five stage definitions and exit rules on one page. Share it with everyone who recruits.
Tuesday: Clean your list. Give every prospect an owner and a next-step date, and move anyone with no contact in 90 days to nurture.
Wednesday: Add the goal, missing-support and timing columns. Fill them in for your ten warmest prospects, using what you know from real conversations.
Thursday: Write your six-touch cadence and schedule the first touches for new prospects.
Friday: Book the weekly review, 45 minutes, same time every week, with the agenda above.
Next Monday: Run it. Read back every commitment before anyone leaves.
After two weeks: Look at your “no” reasons and ask what coaching or support gap they point to.

FAQ

What is the best way to track recruiting prospects?

Use one record per prospect with a stage, an owner, a next step and a date. Define stages by what the agent has done, such as replying or completing a discovery conversation. A spreadsheet works to begin with. Move to software when keeping it current takes more time than talking to agents.

What columns should a prospect tracking spreadsheet have?

At minimum: name, current brokerage, stage, owner, next step, next-step date and date of last real conversation. Add the agent’s stated goal, what is missing in their current setup, and a timing signal. Those three fields make your outreach and your onboarding more relevant.

How often should we review the recruiting pipeline?

Weekly, for about 45 minutes. Start with prospects closest to a decision, then look at stalled ones, then choose the next agents to contact. End by reading back every action, owner and date.

How many follow-ups should we make before giving up on a prospect?

More than one or two. We suggest six touches over about four weeks, mixing calls and messages, each tied to something real about the agent. After that, move the prospect to a nurture list with a review date rather than deleting the record.