Lead Source ROI Audit for Real Estate Teams: Starting With 42 Lead Sources

A real estate team can pay for leads all year and still not know which source paid back. That was the position of a team leader at a residential brokerage team: the CRM held leads from 42 different sources, and there was no way to say which of them earned their keep.

This story covers the first step we took with that team leader, a year-to-date audit of every lead source. If you lead a team and cannot answer the cost-per-deal question, our page for real estate agents and teams shows how we approach reporting. The short version is that you cannot calculate return on a source until the source list, the spend data and the follow-up standard are all in order.

The situation

The team leader wanted two views: return on investment by lead source, and cost per deal. Both depend on knowing what was spent on each source each month, and that spend data had not been supplied yet.

A second gap sat next to it. The team had no standard for judging how hard an agent worked a lead. Without one, a source that looked weak could be a weak source or a lead that nobody followed up well, and the data could not tell the two apart.

We were also trying to set up three AI workflows for the team leader: a finder for emails that never got a reply, calendar prep, and a way to capture questions asked in Slack so they become a reusable answer list. All three were waiting on administrator access that had not been granted.

What was broken

Three things stood between the team and a clear answer.

• Overlapping source names. Duplicate and overlapping labels in the CRM make counts per source unreliable, because one real source can be split across several entries.
• No monthly spend by source. Without it, return and cost per deal cannot be worked out, no matter how clean the lead data is.
• No follow-up standard. Nobody had written down what a properly worked lead looks like, so agent effort could not be compared.

What we built

We started with the data that already existed instead of waiting for the spend numbers.

• A year-to-date audit across all 42 lead sources in the CRM.
• A list of source merges that fold duplicate and overlapping names into one label each, so every real source gets one row.
• A follow-up standard of 10 touches within 12 days for a new lead. It gives the team leader a plain yardstick for agent effort.
• A set of items for the next media planning session: Meta ad templates, lead form drafts and video formats in the UGC style. Selfie-style UGC was the format we cited as the highest performer across the accounts we run.

What changed

No result is stated for this call, and we will not invent one. The return and cost-per-deal views are not finished, because they wait on monthly spend for each source.

What changed is the foundation. Every source has been reviewed, the merges have been identified, and the team has a written follow-up standard. The three AI workflows stay blocked until the team grants the admin access they need.

Run your own lead source audit

This is advice for any team leader, and you can start this week with no new software. Do the steps in this order.

• Export every lead from the past year with its source field.
• Read down the list of source names and mark the duplicates and near-duplicates.
• Write down what you spent on each source, month by month.
• Decide in writing how many contact attempts, in how many days, count as real follow-up.
• Only then work out cost per deal for each source.

Frequently asked questions

What is a lead source ROI audit for a real estate team?

It is a review of every source that feeds your CRM, matched to what you spend on each one and the deals each one produced. In this case the first pass counted the sources and found overlapping names. Return comes after the spend per source is added.

Is 10 touches in 12 days the right follow-up standard?

It is the standard this team leader set, not a rule for every team. The point is to write down a number so effort can be judged the same way for every agent. Adjust it to your market and lead type, then hold to it.

Why do I need monthly spend by source before I can calculate ROI?

Return compares what a source earned with what it cost. Without the monthly cost of each source you can count leads and deals, but you cannot compare sources, so cost per deal stays unknown until the spend data arrives.

Why merge duplicate lead source names?

If one source appears under several labels, no single label shows its true results. Merging gives each real source one name, so counts, spend and deals line up in the same row and the comparison means something.

If you cannot say which of your lead sources pays back, book a 30-minute AI follow-up and reporting audit. We look at how your sources are named, what spend data exists and how follow-up is judged, then show you the gaps.