How to Track Lead Source ROI Across Your Whole Team

Ask a team leader which lead source is working and you'll usually get a confident answer. Ask them to show you the math and things get quiet. Most teams can tell you what they spent last month. Very few can tell you what that spend turned into, by source, six months later. That gap is the whole problem with lead source ROI in real estate, and it gets worse the more agents you add.

On a solo business you can keep it in your head. You remember the seller who came from the postcard and the buyer who came from your cousin. Once you have eight agents working leads from five or six places, memory stops being a system. You need every lead tagged at the door, every closing tied back to that tag, and a cost number that's honest.

Here's how we'd set it up.

Start with the question you're actually asking

"What's our ROI by lead source?" sounds like one question. It's really three.

Which sources produce closed revenue? Which sources produce it at a cost that makes sense? And which sources only work when a certain agent is handling them? That last one is where team leaders get burned. A source can look great on the team total because one strong agent is carrying it, while everyone else converts it at close to zero. If you cut that source, you might be cutting your best agent's pipeline. If you scale it and spread the leads around, the numbers might fall apart.

So you want lead source ROI on two axes: source and agent. Keep that in mind for everything below.

Tag every lead once, at the door

None of this works if the source field is optional or gets filled in later. "Later" means "never" for about half your team, and "Other" becomes your biggest lead source.

A few rules that save a lot of cleanup:

  1. The source gets set when the lead is created, ideally automatically from wherever it came in (the form, the call tracking number, the portal integration).
  2. Keep the list short. Ten sources you actually use beats forty that overlap. "Facebook," "FB Ads," and "Meta" are one source.
  3. Separate the channel from the campaign if you need to. "Direct mail" is the source. "Expired listings, October drop" is the campaign. Mixing them makes the report unreadable.
  4. Decide now how you'll handle repeat leads. If a past client comes back through a portal, is that portal or sphere? Pick a rule, write it down, and apply it the same way every time.

That fourth one starts arguments. We'd lean toward crediting the original source for the relationship and noting the new touch, but the honest answer is that consistency matters more than which rule you choose.

Count the real cost, including what never shows up on an invoice

This is where most spreadsheets fall short. The cost of a lead source isn't only what you paid the vendor.

For a paid ad source, the cost is the ad spend plus whatever you pay someone to run the ads. For a direct mail campaign, it's printing, postage, list cost and design. For a referral-fee portal program, you may pay nothing up front and a percentage at closing, so the cost shows up on the settlement statement instead of your credit card. For sphere and past clients, the cash cost is low, but you might be paying for a CRM drip, pop-bys or a client event.

Then there's time. If your ISA spends most of her week calling one source because it needs heavy follow-up, that source is more expensive than its invoice says. You don't have to put an exact dollar figure on that, but you should know it's there when you compare two sources that look similar on paper.

Write down what goes into the cost for each source, then stick with it. Changing the definition every quarter makes your trend lines meaningless.

Give it enough time to close

Real estate has a long tail. A buyer who registers on your site today might close in four months or two years. If you judge a source on 30 days of results, you'll kill the slow ones that eventually pay well and keep the fast ones that look busy.

We'd look at lead source ROI in cohorts. Take every lead that came in during a given month, by source, and watch what that group produces over the following 6, 12 and 18 months. It's slower, and it's a lot more honest than "revenue closed this month divided by spend this month," which compares this month's closings to leads that mostly came in long ago.

A simple worked example

Here's what the report might look like for one quarter of leads. These are example numbers to show the method, not results from any real team.

Source Cost for the quarter Leads Closings so far GCI so far GCI per dollar spent
Paid social ads $6,000 240 3 $27,000 4.5
Direct mail (absentee owners) $4,500 60 2 $21,000 4.7
Sphere and past clients $1,500 35 4 $38,000 25.3
Open houses $800 50 1 $8,500 10.6

On the team total, paid social and direct mail look about the same. Now split it by agent and suppose you find that two of the three paid social closings came from one agent who calls new leads within minutes, while three other agents together closed one. So what you've actually learned is about speed and follow-up, and that changes what you do next. You might keep the source and route more of it to the agent who converts it, or you might fix the follow-up process before spending another dollar.

Notice too that sphere wins by a mile per dollar and almost never gets a budget conversation. Most teams under-invest in the source that's already working because it doesn't feel like marketing.

Where the team version gets tricky

A few things that only show up once you have more than a handful of agents.

Lead routing changes the result. If your best closer gets first pick, every source she touches looks better. Look at conversion by source and agent together before you decide a source is good or bad.

Splits change your actual return. GCI is the top line. What the team keeps after the agent split, any referral fee and transaction costs is what pays for the next round of leads. A source that mostly goes to agents on a high split may look better in GCI than it does in company dollar. If you're working through your split structure, our piece on real estate team KPIs covers which numbers to watch alongside it.

Agents who leave take context with them. If source data lives in someone's notebook or personal CRM, it walks out the door when they do. It has to live in the team system.

Make the report build itself

The biggest reason teams don't track lead source ROI is that it's tedious. Someone has to export leads, match them to closings, pull costs from three places and update a spreadsheet. It gets done in January and then never again.

The fix is to stop treating it as a reporting project. If every lead is tagged at creation, every agreement and closing is attached to that lead, and commission is recorded on the deal, the report is just a view of data you already have. Nobody should be typing numbers into it.

That's how we built BILLIONS, our real estate CRM for teams. It tracks a lead from the moment it comes in, by source and by team member, through appointments, agreements and closings, and it includes reports for revenue by lead source and team member, conversion by lead source and team member, and commission and revenue tracking. Reports update in real time as your team works, with no manual data entry. If you want the bigger picture of what a leader should be looking at weekly, we wrote about building a team dashboard people actually read, and about what accountability software should track.

What to do this week

You don't need a perfect system to start. Clean up your source list so it's short and doesn't overlap. Make the source field required on every new lead. Write down what counts as cost for each source. Then pull one cohort, say every lead from three months ago, and see where those people are now, split by agent.

That one cohort will probably tell you more about your marketing than the last year of monthly spend reports. And if the hardest part turns out to be getting the data in one place, that's worth fixing before you spend another dollar on leads.

Questions people ask about lead source ROI

How long should I wait before judging a new lead source? Longer than feels comfortable. Watch early signs like contact rate and appointments set in the first 60 to 90 days, but don't call it a failure on closings until you've given that cohort time to close.

Should I count GCI or company dollar? Track both. GCI tells you what the source produced. Company dollar tells you what the team kept to reinvest.

What if a lead touched three sources before they called? Pick one attribution rule and apply it every time. First touch is the simplest for most teams. You can note the other touches without splitting the credit.

Is "Other" ever an okay source? Only if it stays tiny. If it's in your top three, your source list or your intake process is broken.

See BILLIONS in action

The all-in-one CRM for real estate teams, built on Salesforce. Zero build-out required.

Schedule a Demo →

One short demo

See BILLIONS in action

Real results. Real speed. One short demo.

Schedule a Demo →