Menu

  1. Jul 19, 2026

    How Broker Analytics Turn a Deal Pipeline Into a Forecast

Most acquisitions teams treat the deal pipeline as a record: what came in, what died, what closed. That is bookkeeping. The same data, measured properly, is a forecast. Broker analytics, meaning the conversion rates, stage durations, and source-level flow statistics computable from deals a firm has already seen, turn pipeline history into a forward estimate of acquisitions volume: how many deals will close, when they will close, and which broker relationships will produce them. A firm that knows its conversion rates does not have a pipeline. It has a production function.

Key Takeaways

  • A pipeline describes the past. A forecast prices the future. The difference between them is measurement, not more deal flow.

  • Conversion rates by stage are the most predictive numbers an acquisitions team owns, and most teams have never calculated them.

  • CBRE reports US commercial real estate investment volume rose 19% year over year in Q1 2026 to $117 billion, and projects 18% growth for the full year. Rising flow makes screening capacity, not deal supply, the binding constraint.

  • Time in stage converts a deal count into a schedule. Knowing how many deals will close is half a forecast. Knowing when is the other half.

  • Broker-level attribution separates the relationships that produce closings from the ones that merely fill the inbox.

What Is the Difference Between a Deal Pipeline and a Forecast?

A deal pipeline is a record of opportunities that have already arrived: deals screened, underwritten, bid, closed, or killed. A forecast is a statement about deals that have not closed yet. Broker analytics are the bridge between them: measured conversion rates, stage durations, and source-level flow that map the pipeline's history onto its future.

The distinction matters because almost every firm has the first and almost none has the second. The pipeline exists somewhere, often scattered across inboxes and spreadsheets, a problem with costs of its own. But a list of deals is not a model of deal flow. A model requires rates: what fraction of screened deals get underwritten, what fraction of underwritten deals reach a letter of intent, what fraction of LOIs close, and how long each step takes. Those rates are computable from any pipeline with a few quarters of history. Once computed, they answer questions a record cannot: how many closings the current pipeline implies, how much inbound flow next quarter's target requires, and whether the team is staffed for it.

The macro backdrop makes this arithmetic urgent rather than academic. CBRE's Q1 2026 US Capital Markets Figures put quarterly investment volume at $117 billion, up 19% year over year, and MSCI Real Capital Analytics measured $110.7 billion, up 18%, with CBRE projecting 18% full-year growth in transaction volume. When market volume expands, inbound deal flow expands with it. The firms that convert that surge into closings are the ones that know their own funnel math before the flow arrives.

Which Broker Analytics Predict Future Deal Flow?

The broker analytics that predict future deal flow are conversion rate by stage, time in stage, flow volume by source, fit rate against the buy box, and close rate by broker relationship. Each one is computable from records the firm already holds, and each maps a specific piece of history onto a specific piece of the future.

Metric

What it measures

What it forecasts

Flow volume by source

OMs received per broker per month

Top-of-funnel inbound next quarter

Screen-to-underwrite rate

Share of screened deals worth modeling

Analyst workload per unit of flow

Underwrite-to-LOI rate

Share of modeled deals worth bidding

Bid volume and pursuit cost

LOI-to-close rate

Share of bids that convert

Closings per unit of flow

Time in stage

Days a deal spends at each step

When closings land, not just how many

Fit rate by broker

Share of a broker's flow matching the buy box

Which relationships compound

Two of these deserve emphasis. Fit rate requires that the firm's acquisition criteria be explicit enough to score against, which is an argument for making buy box fit defensible rather than intuitive. And every metric on the list requires structured capture at the moment a deal arrives: asset type, market, size, price guidance, source broker, date received. A pipeline that exists as a folder of PDFs has the raw material for all six metrics and the usable form of none of them.

How Do You Turn Conversion Rates Into a Volume Forecast?

You turn conversion rates into a volume forecast by measuring how deals historically moved between stages, then running the current pipeline and expected inbound flow through those rates. The output is an expected number of closings, and, once time in stage is added, an estimate of when each closing lands.

A worked example with stated inputs. Suppose a firm's trailing four quarters show 520 deals screened, 104 advanced to full underwriting, 26 reached a letter of intent, and 13 closed. The rates fall out directly: 20% screen-to-underwrite, 25% underwrite-to-LOI, 50% LOI-to-close, for a blended 2.5% screen-to-close rate, or one closing per 40 deals screened.

Those four numbers now answer forward-looking questions. First, capacity: if the firm targets 16 closings next year, it needs roughly 640 screened deals, about 53 per month against a current run rate of 43. The forecast says the target fails on inbound flow, not on execution, and it says so a year early. Second, the embedded pipeline: 30 deals currently in underwriting imply about 3.8 expected closings (30 x 0.25 x 0.50), and 6 outstanding LOIs imply 3 more. Third, timing: if the median deal spends 30 days in underwriting and 45 days from LOI to close, the deals in underwriting today are, in expectation, closings landing about 75 days out. None of this required new data. It required treating the pipeline as a dataset instead of a diary.

The rates themselves are firm-specific. A development shop screening land parcels and a core-plus buyer screening stabilized multifamily will run materially different funnels, which is exactly why published benchmarks are less useful than a firm's own measured history.

Why Does Broker-Level Attribution Change How You Source Deals?

Broker-level attribution changes sourcing because deal flow is not a commodity. Two brokers sending equal volume can differ sharply in fit rate, pricing accuracy, and close rate. Measuring outcomes by source shows which relationships actually produce closings, and converts relationship management from a courtesy into an allocation decision.

Aggregate conversion rates hide this. A 20% screen-to-underwrite rate might decompose into one broker whose deals advance 45% of the time and a long tail advancing under 10%. The first broker has learned the firm's buy box; the tail is broadcasting. The implication is not to ignore the tail, since coverage has option value, but to invest asymmetrically: faster responses, earlier looks, and more candid feedback flow to the sources whose deals convert. Over time, attribution also feeds back into the forecast itself. If the two highest-fit brokers in the book are ramping their industrial listings, next quarter's expected flow shifts before a single OM arrives.

Most firms already possess the evidence to run this analysis, because the raw broker analytics are sitting in their inbox: years of OMs, each carrying a sender, a date, an asset profile, and an outcome. What is missing is not history. It is the discipline of extracting that history into fields that can be counted.

Frequently Asked Questions

What are broker analytics in commercial real estate?

Broker analytics are the measurable statistics of a firm's deal flow: volume by source, fit against acquisition criteria, conversion rates by stage, stage durations, and close rates by broker relationship. They are computed from the deals a firm has already received and used to predict the volume, timing, and sourcing of future closings.

How much pipeline history do you need before forecasting is credible?

Enough closed outcomes for the rates to stabilize, which for most acquisitions teams means at least four quarters and a few hundred screened deals. With thinner history, treat computed rates as clearly labeled estimates and widen the ranges. A forecast built on twelve data points is a guess wearing a spreadsheet.

Why not just forecast from market transaction volume?

Market data describes the tide, not your boat. CBRE's projected 18% growth in 2026 transaction volume says more deals will trade. Only your own conversion rates say how many of them your team can screen, underwrite, and close. The market forecast sets the ceiling. The funnel forecast sets the number.

Does building a pipeline forecast require new software?

It requires structured capture, not any particular tool. Every deal that arrives needs a recorded source, date, asset profile, and stage outcome. A disciplined spreadsheet can carry the math. What breaks the forecast is not modest tooling but unstructured history, deals living as PDFs and email threads that cannot be counted.

Conclusion

The deal pipeline is the most underused dataset in an acquisitions shop. Firms spend heavily on market data describing transactions they will never touch, while the record of every deal they actually saw, screened, bid, and won or lost sits unmeasured. That record contains the firm's own conversion rates, and those rates are the difference between a pipeline that reports history and one that forecasts volume, timing, staffing, and sourcing.

The work is not exotic. Capture every inbound deal as structured fields, compute four rates and a handful of durations, attribute outcomes to sources, and rerun the numbers quarterly. Operators who do this stop asking how the pipeline looks and start asking what it implies. In a market CBRE expects to grow 18% this year, the teams that know their production function will be the ones that turn rising flow into closings instead of backlog.

Sources

  • CBRE, "Q1 2026 US Capital Markets Figures," reporting investment volume of $117 billion in Q1 2026, up 19% year over year, and a projected 18% increase in 2026 US transaction volume.

  • MSCI Real Capital Analytics, "US Capital Trends," measuring Q1 2026 US investment volume at $110.7 billion, up 18% year over year.

Get Started

See how Rets brings clarity, accuracy, and trust to deal documents.

Get Started

See how Rets brings clarity, accuracy, and trust to deal documents.