Cost per closed transaction by lead source
The number that decides where marketing money goes.
Real estate brokerages · KPI and pipeline dashboards
Know which lead sources, agents and deals are making you money
Brokerage owners make expensive decisions with partial data: which lead sources to keep, which agents to coach or drop from a lead program, whether a team can afford another ISA, how much company dollar is coming in the next 60 days. The numbers live in the CRM, the transaction system and the accounting software, and someone builds a spreadsheet whenever the owner asks.
How it often works today
- Lead source ROI is a guess, because lead costs sit in accounting and closings in the transaction system with no reliable link between them.
- Agent conversion from lead to appointment to closing is unclear, so lead programs reward volume rather than results.
- Pending deals and expected company dollar are tracked in a spreadsheet the office manager updates when there is time.
- Weekly sales meetings spend time arguing about whose numbers are right instead of discussing what to do.
A KPI dashboard project connects those systems and shows a few agreed numbers: leads, appointments, signed agreements, pending and closed deals by source and agent, plus projected company dollar from pendings. It refreshes automatically, and the managing broker uses it in weekly meetings. Definitions come first, because conversion means different things to different people.
The improved workflow
Agree the definitions
With the owner and team leaders, define each metric: what counts as an appointment, a signed agreement, a pending deal and company dollar.
Connect the sources
CRM, transaction management and accounting data are pulled on a schedule into one model, linked by deal and agent, with a refresh date shown on every page.
Build a small set of views
One page for the owner on pipeline, company dollar and source ROI, one for team leaders on agent conversion, and one for each agent's own numbers.
Flag exceptions
Leads uncontacted for 24 hours, pendings with deadlines this week, and sources with no closings in 90 days are highlighted at the top.
Use it weekly
The dashboard anchors the weekly sales meeting, and views nobody uses are removed after 60 days so the focus stays on the numbers that drive decisions.
How we deliver this: AI automation for small business or fractional CTO leadership, scoped in writing and run over 90 days. See pricing or the sample scope.
What we would measure
Agent conversion from lead to appointment to close
Guides coaching and lead distribution.
Projected company dollar from pendings
Supports cash planning and hiring decisions.
Hours spent building reports by hand
The direct cost the dashboard replaces.
Where people stay in control
- The owner or managing broker approves metric definitions, and every change to them is logged.
- Agents see their own numbers and team summaries; individual agent data is shared across the office only if the broker decides to.
- Client personal and financial details stay out of dashboards, which use deal-level summaries only.
Example
Illustrative: a lead source review
For example, a brokerage spends about $9,000 a month across three paid lead sources. After connecting CRM and closing data, the dashboard shows one source produced eight closings in six months, another three, and the third none, despite similar lead counts. The owner moves part of the third source's budget to the first and tightens follow-up rules. Figures are illustrative and not a benchmark.
Tools typically involved
What the first 30 days look like
We would ask the owner for the five questions they most want answered, map where the data for each lives, and test how well records link across systems. The pilot builds the owner view first from the last 12 months of data and checks it against what accounting shows.
Common questions
Doesn't our CRM already have reports?
Most do, and some are good. The gap is usually connecting them to closings and costs held in other systems. If your CRM reports already answer the owner's main questions, we may simply configure them better rather than build something separate.
What about agents who log nothing?
Dashboards expose that quickly, which is useful in itself. Where activity data is weak, we focus on outcomes you can trust, such as closings by source, and work on CRM habits in parallel. Tying lead distribution to logging often improves data quality.
How long before the numbers are useful?
A first version can use historical data, so useful views can exist within the 90 days. Conversion rates by source need several months of closings to settle, so early numbers should be read as directional rather than final.
The business case
Does it pay for itself?
Illustrative defaults for a real estate brokerage. Replace them with your numbers.
What this workflow costs today
a month in staff time, before any lost sales
Monthly fee + assumed tools +
Break-even: new clients a month (at first-year value)
Or: staff hours recovered and redeployed
Break-even additional revenue
Value of +1 point of win rate
First 90 days, service fee
Worth a closer lookTest the assumptions
Illustration only, not a forecast or guarantee. Recovered staff time becomes a cash saving only if spending actually declines or the time goes into paid work. Tool costs are an assumption; we replace every number here with yours before recommending a scope.
KPI and pipeline dashboards in other industries
Architecture firmsAuto repair shopsConstruction and general contractorsDental practicesElectrical contractorsEngineering firmsHVAC companiesIT managed service providers
KPI and pipeline dashboards: full guide
Related guides
Your first 90 days with a fractional tech leadHow to automate invoicing in QuickBooks OnlineA practical guide to CRM data cleanupHow to automate recurring client reports
Terms used here
Next step
Bring one expensive workflow. Leave with a clear next step.
In 30 minutes we look at one recurring workflow, what it costs you today and whether there is a credible case to improve it. If there is not, we will say so.
Book a 30-minute workflow review
Not ready to talk? Take the 3-minute check
30 minutes with Phil or Martin. No technical brief, no pitch deck. Phil or Martin replies personally, usually within one business day.