A commercial brokerage pipeline is slower, lumpier and more relationship-driven than a residential one. A mandate can take many months. Volume swings on one or two large transactions. That makes generic sales metrics risky. The measures below are the ones we find most useful for commercial work, defined precisely enough that two people would calculate them the same way.
Each definition follows the same pattern: what it is, what counts, the formula, and the common trap.
Before the metrics: get the stages right
Every pipeline metric depends on stages. If stages are vague, every number built on them is vague. A workable stage set for a commercial brokerage might look like this:
| Stage | Entry criterion |
|---|---|
| Inquiry | A contact or organization has expressed interest, but no requirement is confirmed. |
| Qualified | A requirement is confirmed: use, size range, location, timing and decision-maker are known. |
| Engaged | The client has agreed to work with the firm, by mandate, listing agreement or written confirmation. |
| Touring / marketing | Properties are being shown to a tenant or buyer, or a listing is actively marketed. |
| Negotiating | An offer or letter of intent has been exchanged. |
| Firm | Conditions are waived or the lease is signed. |
| Closed | Title has transferred or the lease term has begun, and commission is earned. |
| Lost | The opportunity ended without a transaction with this firm. |
A stage is defined by an observable event, not by how an agent feels about the deal.
1. Qualified opportunities created
What it is. The number of opportunities that reached the Qualified stage in a period.
What counts. An opportunity counts once, in the period it first entered Qualified. Re-qualifying an old record does not count again.
Formula. Count of opportunities where the first Qualified date falls within the period.
Common trap. Counting inquiries as opportunities. An inquiry is a signal of interest. A qualified opportunity has a confirmed requirement. Mixing them inflates the pipeline and hides the real conversion rate from inquiry to qualified.
2. Open pipeline, by stage
What it is. The opportunities currently open, grouped by stage.
What counts. Every opportunity not in Closed or Lost, as of a stated date.
Formula. Count, and separately sum of estimated commission, of open opportunities in each stage, as of the report date.
Common trap. Reporting only the total. A large total made up mostly of early-stage opportunities is a very different business from the same total weighted towards Negotiating. Always show the stage breakdown. A second trap is summing gross transaction value rather than estimated commission. Transaction value says how big the deals are. Commission says what the firm stands to earn. Keep them apart.
3. Stage conversion rate
What it is. The share of opportunities that move from one stage to the next.
What counts. Opportunities that entered the earlier stage within a defined window, measured on whether they later reached the next stage.
Formula. Opportunities that entered stage A in the window and later reached stage B, divided by all opportunities that entered stage A in the window.
Common trap. Measuring too soon. In commercial work, an opportunity that entered Qualified last month may simply not have had time to progress. Measuring it now understates conversion. Use a cohort window that is old enough for most opportunities to have resolved, and state that window on the report. A second trap is dividing this period’s stage B count by this period’s stage A count. Those are different groups of deals, and the result is not a conversion rate.
4. Win rate
What it is. Of the opportunities that have ended, the share that ended in a transaction.
What counts. Opportunities that reached Closed or Lost, grouped by the date they ended.
Formula. Closed opportunities divided by (Closed plus Lost) opportunities, for opportunities that ended in the period.
Common trap. Leaving dead opportunities open. If agents never mark deals as Lost, the denominator shrinks and the win rate looks better than reality. Pair this metric with a stall rule (below) so that inactive opportunities are forced to a decision.
5. Cycle time
What it is. How long opportunities take to move from qualification to close.
What counts. Closed opportunities only, measured from the first Qualified date to the Closed date.
Formula. Median of (Closed date minus first Qualified date), in days, for opportunities closed in the period.
Common trap. Using the average. A few very long deals pull an average far above the typical experience. The median is a more honest summary. Report cycle time separately for leases and sales, and ideally by size band, because they behave differently. A second trap is starting the clock at record creation. Records are often created long before there is a real requirement.
6. Stage age and stall rate
What it is. How long open opportunities have sat in their current stage, and the share that have sat too long.
What counts. Open opportunities only. Stage age runs from the date the opportunity entered its current stage.
Formula. Stage age is the report date minus the stage entry date. Stall rate is the count of open opportunities whose stage age exceeds the threshold for that stage, divided by all open opportunities.
Common trap. Using one threshold for every stage. An opportunity can reasonably spend longer in Touring than in Negotiating. Set a threshold per stage, based on the firm’s own history once it has enough, and revisit it. A second trap is resetting stage age on any edit. Updating a note is not progress. Stage age should reset only when the stage changes.
7. Next-action coverage
What it is. The share of open opportunities with a scheduled next action that has not passed.
What counts. Open opportunities with at least one next action dated today or later and assigned to a named person.
Formula. Open opportunities with a current next action, divided by all open opportunities.
Common trap. Counting overdue actions as coverage. An action dated three weeks ago that nobody completed is a sign of neglect, not coverage. This measure does not tell you whether deals will close. It tells you whether anyone is working on them.
8. Weighted pipeline
What it is. An estimate of the commission the open pipeline is likely to produce.
What counts. Open opportunities with an estimated commission and a stage.
Formula. Sum of (estimated commission multiplied by the stage probability) across open opportunities.
Common trap. Inventing the probabilities. Stage probabilities should come from the firm’s own historical stage-to-close conversion, not from a default in the software or a guess. Until the firm has enough history, label the weighted figure as indicative and show the unweighted figure next to it. Never let agents set their own probability per deal for this calculation; it turns a measure into a mood.
A hypothetical worked example
The figures below are illustrative only and do not describe any real firm.
A hypothetical commercial team has 40 open opportunities. The report shows:
| Stage | Open | Over stage threshold | With current next action |
|---|---|---|---|
| Qualified | 14 | 5 | 9 |
| Engaged | 10 | 2 | 8 |
| Touring / marketing | 9 | 4 | 6 |
| Negotiating | 7 | 1 | 7 |
| Total | 40 | 12 | 30 |
From this, the stall rate is 12 of 40, or 30 per cent, and next-action coverage is 30 of 40, or 75 per cent. The five stalled Qualified opportunities are a prompt: are these real requirements, or should some be marked Lost? The four stalled Touring opportunities suggest the property options shown may not match the requirement. The Negotiating stage looks well tended.
That is the purpose of these metrics: they point attention at specific records.
A note on activity counts: calls and emails logged are easy to inflate and say little about quality. Next-action coverage is usually the better signal.
Where to start
- Write entry criteria for each stage, based on observable events, and share them with the team.
- Make the stage entry date a recorded field, so stage age and cycle time can be calculated.
- Start with three measures: open pipeline by stage, stall rate, and next-action coverage. Review them weekly.
- Add conversion and cycle time once you have enough closed and lost opportunities to form a meaningful cohort.
- Hold off on weighted pipeline until your stage probabilities come from your own history.
Multiunit builds pipeline reporting for commercial and residential brokerages, on top of a CRM structured around how real estate deals actually work. To talk through your own stage definitions, use the Contact page.
This article is general information, not legal, financial or brokerage advice. Examples and figures are illustrative unless a source is given.