How Top Producers Track Lead Source ROI (Without Becoming a Data Analyst)

Real estate lead source tracking is the difference between an agent who knows Zillow pays their mortgage and an agent who just hopes it does. Most agents are in the second group. They spend $2,000 a month on portal leads, another $800 on Facebook ads, and a few hundred on a farm postcard mailer, and at the end of the year they genuinely cannot tell you which one made them money.

That’s not a discipline problem. It’s a system problem. Tracking lead source ROI sounds like it requires a spreadsheet habit and a data background, so agents skip it and run on gut feel. Gut feel is almost always wrong about lead sources — it over-credits the loud channel and under-credits the quiet one.

This article gives you the five fields that turn gut feel into a budget decision, the attribution window that keeps you from reading noise as signal, and a worked example of an agent who moved $24,000 in spend after running this for one quarter.

Key Takeaways

• Track five fields per lead — source, channel, cost per lead, touchpoints to close, and GCI outcome. Four of them are easy. The fifth is the only one that matters.
• Use a 90-day attribution window. Real estate deal cycles run 30 to 120 days, so anything shorter under-counts your slow-but-profitable sources.
• Spreadsheets die in about two weeks. Not because they don’t work, but because nobody maintains them past the second busy week.
• In a CRM, attribution is a side effect of normal pipeline work, which is why it actually survives for 12 months.
• The goal is reallocation, not reporting. The point of tracking isn’t a pretty dashboard. It’s the decision to move money from a source that doesn’t convert to one that does.

The Lead-Source Visibility Black Hole (Why Most Agents Over-Pay Zillow)

Ask an agent which lead source converts best and you’ll usually get a confident answer. Ask them to prove it and the confidence evaporates. That gap — between what agents believe and what they can show — is where marketing money goes to die.

The “Zillow feels expensive” syndrome

Zillow Premier Agent shows up as one big charge every month, so it feels expensive. Sphere-of-influence referrals show up as nothing, so they feel free. Agents react to the feeling: they agonize over the Zillow bill and never think about whether their SOI is under-invested.

But “feels expensive” and “is expensive” are different things. A $200 Zillow lead that closes a $15,000 commission is cheap. A “free” referral that took 40 hours of relationship work to earn isn’t free at all. Without numbers, you’re managing your business by which bill is biggest, and that’s the question of Zillow Premier Agent ROI that every agent paying for portal leads should be able to answer.

Why gut feel is wrong about lead sources

Gut feel weights the dramatic over the frequent. You remember the Zillow lead that ghosted you after three showings. You forget the four quiet referrals that closed without drama. So your gut tells you Zillow is a money pit and referrals are unreliable, when the numbers might say the opposite.

The fix isn’t more discipline. It’s a structure small enough that you’ll actually keep it.

The 5 Fields Every Lead Needs (And Why 4 Won’t Do)

You don’t need a data warehouse. You need five fields attached to every lead.

Source

Where the lead literally came from: Zillow, Realtor.com, OpCity, your website, a specific Facebook campaign, a past client, an agent referral, an open house, a sign call. Be specific. “Online” is not a source. “Zillow Premier Agent — 78704 ZIP” is a source.

Channel

The category above the source: paid portal, paid social, organic, referral, event, sphere. Channel lets you roll up sources to answer the bigger question — is paid lead-gen beating relationship-based lead-gen for me this year?

Cost per lead (CPL)

What you paid to get this specific lead in the door. For a $1,500/month Zillow contract that produced 12 leads, that’s $125 each. For a referral, it might be near zero in cash but real in time.

Touchpoints to close

How many times you contacted the lead before it converted or died. This is the field nobody tracks and everybody needs, because it tells you how much work a source actually costs you — and it’s the direct connection to your follow-up cadence. A source that needs 18 touches to close is more expensive than its CPL suggests.

GCI outcome

The only field that matters in the end: did this lead generate gross commission income, and how much? A source isn’t good because it’s cheap or bad because it’s expensive. It’s good if its leads turn into GCI at a rate that beats the alternatives.

The fields in one table

The last two are exactly the fields that die in a spreadsheet and survive in a CRM. That’s not a coincidence.

How to Set This Up — Spreadsheet vs CRM

You can build this two ways. One of them lasts.

The starter Google Sheet (and why you’ll quit in two weeks)

A spreadsheet with those five columns works for about 14 days. Then a busy week hits. You forget to log three leads. You mis-categorize a source because you were in a hurry. The touchpoint count drifts out of date because you’re not going to open a spreadsheet after every call. By week three the sheet is wrong, and a tracking system you don’t trust is worse than none, because it gives you false confidence.

The six ways a tracking spreadsheet dies: you forget to log a lead, you fat-finger a source name, you stop updating touchpoints, you lose the file in your Drive, you never connect it to actual closings, and you simply stop opening it. One of those will get you in the first month.

The CRM version (and why it just works)

In real estate CRM analytics, attribution isn’t a separate chore — it’s a byproduct of work you’re already doing. The lead comes in tagged with its source automatically because it flowed in through an integration. Touchpoints count themselves, because every call, text, and email you send through the system increments the number. GCI rolls up on its own when you mark the deal closed. You didn’t “do attribution.” You just worked your pipeline, and the attribution fell out of it.

That’s the whole difference. The spreadsheet asks you to do extra work forever. The CRM asks the work you already do to report on itself.

The 90-Day Attribution Window (Why Faster Reporting Is Wrong)

Once you’re tracking, the next mistake is reading the data too soon.

Why 30 days is not enough

Real estate deals don’t close in 30 days from first touch. A buyer lead might take 60 days to tour and another 45 to close. A seller lead might marinate for three months before listing. If you judge a source on 30-day data, you’ll kill the sources with longer cycles — which are often your most profitable ones, because patient leads face less competition.

This is how to track real estate marketing ROI without fooling yourself: give every source a fair window to actually produce a closing before you judge it.

The rolling 90-day view

Use a rolling 90-day window. Every source gets at least 90 days to turn leads into GCI before you make a budget call on it. Look at it quarterly, not weekly. Weekly numbers are noise dressed up as signal, and reacting to them will have you yanking budget from a source right before its deals close.

Worked Example — How One Agent Reallocated $24K in 90 Days

An agent — call her Dana, doing about $11M in volume — was spending roughly $3,200 a month across three sources: $2,000 on Zillow, $800 on Facebook lead ads, and $400 on a quarterly farm mailer. She “knew” Zillow was her best source because it produced the most leads.

After 90 days of tracking all five fields, the numbers told a different story. Zillow produced the most leads, yes — but at 14 touchpoints each and a conversion rate that made her cost-per-closing about $3,100. The Facebook seller-lead campaign produced fewer leads, but they closed at nearly double the rate and needed fewer touches, putting cost-per-closing closer to $900. The farm mailer was quietly her best performer per dollar, just at low volume.

She didn’t cut Zillow. She rebalanced: dropped the Zillow spend by $800, tripled the Facebook seller campaign, and doubled the mailer. Net, she moved about $24,000 in annual spend toward sources that were already proving they converted. Same budget. More closings. The only thing that changed was that she could finally see what was true.

FAQ

What lead sources should real estate agents track? At minimum: Zillow, Realtor.com, and OpCity (paid portals), Facebook and Instagram ads (paid social), Google Ads (search), your sphere of influence, past-client referrals, agent-to-agent referrals, open houses, and sign calls. Give each its own source field — never lump them under “online,” or you lose the ability to make any real decision.

What’s a good cost-per-lead in real estate? It depends entirely on the source, so CPL alone is a trap. Zillow ZIP-coded leads often run $40–$200; Facebook seller leads $15–$50; SOI leads cost almost nothing in cash but real time. The benchmark that actually matters is CPL divided by conversion rate times average commission — your cost per dollar of GCI.

How long until I have enough data to make a budget decision? Ninety days, minimum. Real estate deal cycles run 30 to 120 days from first touch to closing, so anything shorter under-counts conversions from your slower sources. Agents who pull budget after 30 days are almost always reacting to noise.

Can I track lead source ROI in a spreadsheet? For about two weeks. After that you’ll forget to log a lead, mis-tag a source, or just stop opening the file. Spreadsheet attribution survives in theory and dies in practice. The version that runs for a full year is the one where attribution is a side effect of working your pipeline in a CRM.

Conclusion — Know Which Lead Source Pays Your Mortgage

The agents who scale don’t spend more on leads. They spend more on the leads that work and less on the ones that don’t, and they can tell the difference because they tracked five fields for 90 days. That’s the entire skill. It’s not data science. It’s knowing which source pays your mortgage.

Sky Agent’s analytics dashboard captures all five fields automatically — source, channel, cost per lead, touchpoints, GCI — in real time, with no spreadsheet to maintain. See your real lead-source ROI in a 20-minute demo.