Blog · Board and management reporting
Measure real estate lead conversion from dated inquiry cohorts in a brokerage CRM export. Compare appointments, signed clients, and closings by source with consistent follow-up windows and spreadsheet checks.
Real estate lead conversion is completed closings divided by eligible inquiries from the same dated cohort. Track appointments and signed clients alongside closings so a brokerage can see where each source advances. Give every inquiry the same time to produce an outcome before comparing sources.
Use a distinct prospect or client journey as the unit. A person asking about several properties should not automatically become several new leads. Preserve the original inquiry rows, choose which record represents the journey, and attach later activity to it.
For this workflow, an appointment means a completed initial consultation, signed client means a signed representation agreement, and closing means a completed transaction. The National Association of REALTORS' guide to written buyer agreements describes an agreement as setting the services and terms of working with a real estate professional. Keep that relationship stage separate from the eventual closing date.
This example follows a buyer journey in which appointments precede signed clients and signed clients precede closings. A brokerage with a different journey should report its actual stages rather than force records into this sequence. The general distinction between stage conversion and final outcomes is covered in win rate, close rate, and conversion rate.
Use these columns, with one retained journey per row:
| Column | Field | Required meaning |
|---|---|---|
| A | Journey ID | Unique retained inquiry identifier |
| B | Original source | Portal, referral, direct, or a named unresolved group |
| C | Inquiry date | First valid inquiry date |
| D | Appointment date | First completed appointment |
| E | Signed-client date | First signed representation agreement |
| F | Closing date | First completed closing for this journey |
| G | Review result | Valid, duplicate, spam, or unresolved |
Keep buyer and seller journeys separate if they follow different stages. Use original source consistently; the agent who eventually handled a referral is not a replacement acquisition source.
For the illustration, select inquiries received during January 2026 and allow 120 days from each inquiry. The report is prepared on May 31, 2026, when even an inquiry received on January 31 has completed that window. This is a chosen comparison window, not a universal real estate benchmark.
The formulas below work in Excel. In H2, mark a valid January inquiry only when its full observation window has elapsed:
=IF(AND(ISNUMBER(C2),G2="Valid",C2>=DATE(2026,1,1),C2<DATE(2026,2,1),C2+120<=DATE(2026,5,31)),1,0)
Microsoft's DATE documentation explains how DATE builds a date from year, month, and day inputs. Confirm that exported dates are real date values before calculating; text that only looks like a date can fail these checks.
In I2, flag a completed appointment within the inquiry's window:
=IF(AND(H2=1,ISNUMBER(D2)),IF(AND(D2>=C2,D2<=C2+120),1,0),0)
Copy that logic to J2 using E2 for the signed-client date and to K2 using F2 for the closing date. Fill the flags down the retained export. Outcomes after the window remain in the CRM history but do not enter this comparison.
Put the source to summarize in M2. Count its eligible inquiries with:
=COUNTIFS($B$2:$B$1000,M2,$H$2:$H$1000,1)
For appointments, add the appointment flag:
=COUNTIFS($B$2:$B$1000,M2,$H$2:$H$1000,1,$I$2:$I$1000,1)
Repeat using J and K for signed clients and closings. Microsoft documents COUNTIFS as counting rows that meet all specified criteria; every criteria range must have matching dimensions. Extend the range if the export contains more rows.
A US brokerage obtains these illustrative results:
| Source | Eligible inquiries | Completed appointments | Signed clients | Closings | Closings / inquiries |
|---|---|---|---|---|---|
| Property portal | 200 | 40 | 24 | 12 | 6.00% |
| Referral | 80 | 32 | 24 | 16 | 20.00% |
| Direct | 120 | 30 | 18 | 9 | 7.50% |
| Total | 400 | 102 | 66 | 37 | 9.25% |
The portal rate is 12 / 200 = 6.00%; referral is 16 / 80 = 20.00%; direct is 9 / 120 = 7.50%. The overall rate divides totals: 37 / 400 = 9.25%. Percentages are rounded to two decimal places.
If the summarized counts occupy N through Q, closing conversion in R2 is:
=IF(N2=0,"",Q2/N2)
Format as a percentage. The appointment rate for the whole cohort is 102 / 400 = 25.50%. Referrals produce fewer inquiries than the portal but more closings; this supports reviewing source quality and follow-up, while acquisition economics belong in real estate cost per lead.
The source counts must sum to the cohort's retained CRM rows. For this sequential journey, classify every inquiry by its furthest completed stage:
| Status at the end of its window | Calculation | Journeys |
|---|---|---|
| No completed appointment | 400 − 102 | 298 |
| Appointment, no signed agreement | 102 − 66 | 36 |
| Signed client, no closing | 66 − 37 | 29 |
| Closed | Closing count | 37 |
| Total | 298 + 36 + 29 + 37 | 400 |
These are mutually exclusive statuses, not additional leads. Check each journey's date order before using this subtraction. The brokerage's sales manager owns follow-up on open journeys; the person maintaining the CRM export owns identity, source, and date quality. Keep the agreed fields consistent in real estate dashboards.
Covirage is not affiliated with Microsoft.
Bring a CRM export with retained inquiry IDs, original sources, dated stages, and a stated observation window to Covirage. Covirage maps the columns; its tools compute and check the cohort counts and source conversion rates, while the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See sales insights for the related work on lead outcomes.
Report both with distinct labels. Appointment conversion measures whether an inquiry reaches a completed appointment. Closing conversion measures whether it eventually produces a completed transaction. Signed representation is another stage, so it should not be counted as a closing.
Choose a follow-up window that fits the brokerage's observed inquiry-to-closing history, then apply it equally. A newly acquired inquiry has had less time to close than an older one. Report immature cohorts separately instead of treating their open inquiries as final failures.
They can, but only when the report explicitly measures inquiries rather than unique prospects. For source comparisons, a brokerage can retain one prospect per defined buying or selling journey and keep repeat property requests as activity attached to that prospect.