Real Estate Referral Conversion Rate Template

To calculate referral conversion, divide the number of referred inquiries that produced a closing within a defined window by all referred inquiries in the same intake group. Include inquiries that never reached an appointment. This real estate referral conversion rate template keeps that measure separate from referral share: the portion of closed business credited to referrals.

Referral share versus conversion: two denominators

A cohort is a group of inquiries received during the same period, such as January. A transaction side is your representation of a buyer or seller; use that unit consistently in the closing ledger.

Hypothetically, five referral sides among 20 closed sides means a 25% referral share. It says nothing about conversion until you know how many referred inquiries produced those sides and how long they had to close. Referral share can also rise simply because other sources deliver fewer closings.

Why NAR's business-source figures are not conversion benchmarks

NAR's August 19, 2026 feature sheet reported 2025 business shares of 28% from repeat clients and 22% from referrals by past clients and customers. Its earlier August 6, 2025 summary reported typical shares of 20% and 21%, respectively, for 2024 activity. Keep the activity year separate from the report year.

The 2026 Member Profile, exhibits 2-17–2-18, presents separate medians. Adding 28% and 22% does not establish a combined median of 50%, and neither percentage measures referred prospects who closed. The published measures provide no matched inquiry denominator or observation window.

NAR is an industry trade association surveying its members. According to the report's methodology, its March 2026 survey received 5,116 responses, had an adjusted response rate of 1.7%, and weighted responses to state membership. Those findings describe members' reported business; they do not establish a conversion target for your pipeline.

Define what enters your real estate lead cohort

For this template, enter an inquiry when you receive a named introduction or direct request concerning a household's possible purchase or sale, with a usable contact route. Do not wait for an appointment, financing approval or signed agreement.

Keep unanswered introductions, postponed searches, financing difficulties and prospects who choose another agent in the denominator. Exclude spam and duplicate records, documenting the reason. A list of names without a specific housing inquiry belongs outside this cohort.

Use one row per household's moving plan. Merge spouses' messages, repeated calls and multiple introductions for that same plan. A household selling and buying counts as one inquiry and converts once at its first closing; its two sides belong separately in the closing ledger. A paused search retains its original ID and date. A later, distinct moving plan receives a new inquiry ID.

Build the agent referral tracking spreadsheet

This is an editorial tracking method for U.S. residential agents, not a NAR reporting standard. Start with your CRM export, introduction records and closing ledger. Create an Inquiries tab with these columns:

Use source labels Referral: past client, Referral: agent, Referral: other, Repeat return, Other and Unknown. Keeping referral types separate lets you evaluate your past-client program without mixing it with agent referrals.

Credit the first documented source that generated the current inquiry. Someone originally referred years ago who now returns independently is Repeat return. If a documented new referral prompted a previous client's current inquiry, record the appropriate referral source and Repeat_client = Yes. Keep other influences in the evidence note.

Source and relationship history can overlap without creating another row. For a combined repeat-or-referral count, count each inquiry ID once if it has a referral source, Repeat_client = Yes, or both. Do not add the two totals.

In a Settings tab, put the reporting date in B1 and the observation window in B2. The example uses August 21, 2026 and 180 days. Enter dates as spreadsheet dates. In row 2 of Inquiries, use:

I2: =IF(C2="","",Settings!$B$1-C2)
J2: =IF(C2="","",--AND(ISNUMBER(H2),H2>=C2,H2<=C2+Settings!$B$2,H2<=Settings!$B$1))

Copy down through your records. The 180-day window is a management choice, not an industry benchmark; choose it before comparing results.

Filter the inquiry dates to your chosen month or quarter, then filter D to the referral categories you want to measure. Leave all statuses visible. Once column I shows at least 180 days of observation for every inquiry in that cohort, put these formulas in a Summary tab:

B2: =SUBTOTAL(103,Inquiries!A2:A10000)
B3: =SUBTOTAL(109,Inquiries!J2:J10000)
B4: =IF(B2=0,"N/A",B3/B2)

B2 counts inquiries, B3 counts conversions and B4 is the rate; format B4 as a percentage. These SUBTOTAL codes exclude filtered and manually hidden rows in Excel and Google Sheets. Unhide rows before applying your cohort filters, save those filters with the report, and extend the ranges if necessary.

For referral share, maintain a separate Closings tab with one row per unique transaction side: side ID, inquiry ID, closing date, primary source and contribution dollars. Count each team side once, even when several agents worked on it. Divide referral-attributed sides by all sides closing in the reporting period, including sides with unknown sources.

Keep late closings in their original cohort

Suppose eight referred households entered in January 2026. By August 21, three had closed within 180 days of their individual inquiry dates. One more closed on day 195. The remaining four had not closed.

The day-195 closing belongs in the original January cohort's cumulative result and in the closing-period production report. It never enters the 180-day numerator. A later 365-day comparison can capture it once the cohort has sufficient observation time.

For a younger cohort, show conversions to date and open, paused and lost counts, labeled provisional. Do not compare that rate with a mature cohort, or remove recent unresolved inquiries while retaining their fast-closing peers.

Use small samples to make limited budget decisions

In the hypothetical eight-inquiry cohort, one additional closing within the window would move conversion from 37.5% to 50%—12.5 percentage points. That sensitivity makes a short-term channel ranking a weak basis for a large spending change.

Report counts beside rates. If needed, combine adjacent mature cohorts with consistent definitions, dividing total conversions by total inquiries rather than averaging percentages. Check whether differences reflect repeat-client mix, buyer versus seller work, price range or one unusually productive referrer. Attribution alone cannot establish that a mailing or event caused additional business.

Track program spending and staff hours alongside results, and connect closed business to contribution margin. A higher conversion rate can still accompany lower contribution after costs or fewer total opportunities.

Add a monthly reconciliation to your agent business operations: match closing-side IDs to the ledger, review unknown sources and duplicate exclusions, and save the cohort dates, observation window and counts. Use that reconciled report to set a limited next-period budget and a specific date to review it.