Business systems

Real Estate Lead Source ROI: A Cost-per-Closing Worksheet for Better Budget Decisions

Calculate what a lead source actually costs, keep immature leads out of false comparisons and choose a specific keep, test, repair or pause decision.

QUICK ANSWER

Evaluate a lead source with consistent attribution, a comparable observation window and the money actually retained after relevant costs. Track agent time separately, show uncertainty when cohorts are young and tie each budget change to a specific measurement.

In this guide
  1. 1. Define the question before collecting numbers
  2. 2. Make attribution consistent before measuring ROI
  3. 3. Use explicit formulas with matching denominators
  4. 4. Compare two invented source cohorts
  5. 5. Keep time and unfinished pipeline visible
  6. 6. Turn the worksheet into one budget decision

One lead source produces inexpensive inquiries. Another produces fewer inquiries and costs more per month. Which deserves the next budget dollar? You cannot answer from cost per lead alone. You need to know which contacts became legitimate opportunities, which closed, what your business retained and how much work the source required.

This is an original management worksheet, not an industry benchmark or a forecast. Every figure in the example is invented. It helps agents evaluate their own records; it does not promise a return or replace an accountant’s advice about financial reporting.

1. Define the question before collecting numbers

Choose a source, a cohort and an observation date. A cohort is a group of leads acquired during the same defined period. Reviewing what happened to that group helps avoid comparing this month’s spending with closings from contacts acquired long before it. Use a similar time-to-observe when comparing channels.

Example review question: “For contacts acquired from Source A during this three-month period, what outcomes and retained contribution can we verify as of the review date? How does that compare with a similarly observed group from Source B?”

Keep an additional cash-flow view for money spent and received during the month. The cash-flow view and acquisition-cohort view answer different questions. Neither should quietly borrow the other’s totals when calculating return. Label the date range and observation date at the top of the worksheet.

2. Make attribution consistent before measuring ROI

Record the original source when the inquiry arrives, then retain meaningful later touchpoints separately. An introduction that later visits your website should not automatically become a website-generated lead. Decide the attribution rule and document exceptions, including duplicate records and contacts whose original source is unknown.

  • Original source: the verifiable path that first brought the opportunity to the business.
  • Acquisition date: when that contact entered the defined cohort.
  • Assisting touchpoints: later events that supported the relationship.
  • Status and dates: conversation, held consultation, active representation and closed transaction as applicable.
  • Financial record: source costs and actual retained transaction income, with reconciliation notes.

A simple first-known-source rule can be a practical starting point. It is a management convention, not proof that one touch caused a sale. Keep unknown entries visible and improve the intake question rather than assigning them to whichever source looks strongest.

3. Use explicit formulas with matching denominators

MetricWorksheet calculationWhat it helps you assess
Cost per inquiryAllocated source cost ÷ unique inquiries in the cohortAcquisition cost before considering quality
Cost per held consultationAllocated source cost ÷ consultations actually heldCost of reaching a meaningful meeting
Cost per closingAllocated source cost ÷ closed transactions attributed to the cohortObserved acquisition cost per completed outcome
Source contributionRetained income minus allocated source cost and specified direct costsWhat remains before other overhead and taxes
Worksheet ROISource contribution ÷ allocated source costA limited management return using the stated cost definition

Define retained income here as your actual share after brokerage or team allocations, before the costs separately deducted in the contribution calculation. If a referral fee or direct expense has already been deducted, do not subtract it again. Reconcile the convention to actual statements with your accountant when needed.

If there are no closings, do not write zero as the cost per closing; there is no finite observed value to calculate yet. If source cost is zero, the ROI formula is undefined. Record the actual outcome counts and discuss time and direct costs instead. A formula error should not make a channel appear free or ineffective.

4. Compare two invented source cohorts

Assume two equally observed cohorts have the following completed outcomes. Source costs include the stated channel spending; direct transaction costs are tracked separately. The amounts do not represent typical agent income, conversion rates or recommended budgets.

Illustrative measureSource ASource B
Allocated source cost$3,000$1,200
Unique inquiries6012
Held consultations85
Closed transactions22
Retained income before separately listed costs$10,000$8,000
Separately listed direct transaction costs$1,000$800
Cost per inquiry$50$100
Cost per held consultation$375$240
Cost per closing$1,500$600
Source contribution before other overhead and taxes$6,000$6,000
Worksheet ROI200%500%
Agent hours spent on this cohort5030

For A, contribution is $10,000 − $3,000 − $1,000 = $6,000. For B, it is $8,000 − $1,200 − $800 = $6,000. The ROI calculations divide each contribution by its source cost. These figures do not establish net business profit, and they do not predict that increasing B’s budget will reproduce its observed results.

The cheaper inquiry came from A, but B had lower observed costs per held consultation and closing in this small example. Review individual files before concluding why. With only two closings per cohort, a single transaction materially changes the comparison. Show that sensitivity rather than presenting the percentages as settled performance.

5. Keep time and unfinished pipeline visible

Agent hours help explain capacity, but they are not automatically a cash expense. Record them separately. If you create an internal time-cost estimate, state the assumed hourly value and avoid mixing it with the cash calculation without changing the label. Rework and unproductive appointment travel belong in the time record too.

List active opportunities separately from completed income. A signed representation agreement, pending sale or hopeful conversation is not a closed commission. Note the stage and unresolved dependency; do not fill the income column with an optimistic projected amount to make a weak channel appear profitable.

  • Cohort age: has each source had a comparable chance to produce an outcome?
  • Data completeness: are source and cost records reconciled?
  • Execution: were inquiries handled as promised and consultations prepared?
  • Capacity: can you service additional opportunities without reducing quality?
  • Concentration: how much would one transaction or a few contacts change the result?

6. Turn the worksheet into one budget decision

DecisionEvidence that supports considering itNext measurement
KeepThe source serves a useful role within current capacityReconcile the next cohort at the same observation age
Test a limited increaseObserved contribution and service capacity justify an experimentTrack the added spending as a distinct test
Repair executionThe source generates relevant conversations but a specific handoff failsObserve the changed step before changing the whole budget
Pause or renegotiateCosts, terms or workload no longer fit the businessConfirm commitments and monitor remaining cohort outcomes

Example decision note: “Keep the current spend for one defined review period. Correct the missing consultation confirmations, reconcile retained income and compare the cohort again on [date]. We are testing execution quality, not assuming more spending will create more closings.”

Your first action is to reconcile one source for a single acquisition cohort. Trace the original source on each closed file, confirm the actual retained income and complete the cost definitions. Leave unknown values marked unknown and assign someone to resolve them.

The Lead Generation and Business Growth pillars in the Elite Agent Operating System provide a broader diagnostic for your business. If you want help deciding whether the problem is acquisition, conversion or capacity, explore Elite Agent Accelerator on Skool. Bring a reconciled, anonymized worksheet and one decision you need to make.

TURN INSIGHT INTO IMPLEMENTATION

Build this system with a coach
and a community behind you.

Join the agent community free. The $150 per month Education Membership adds the complete business training library, weekly group coaching, and implementation tools.

Join the Community FreeStart with the Elite Agent Operating System