Fee earned, not deals counted
Broker fees scale with loan size. Ranking channels on fees collected is a different list from ranking on deals closed.
For Commercial Mortgage Brokers
Match broker fees on funded commercial loans to the campaigns that produced the borrower, weighted by loan size.
No card required Nothing to install Cancel anytime
$3,456,000 64% of $5,400,000 paid
The blind spot
A four million dollar bridge deal and a four hundred thousand dollar loan are one enquiry each and ten times apart in fee.
What you get
Broker fees scale with loan size. Ranking channels on fees collected is a different list from ranking on deals closed.
Term sheet, diligence and close put months between the enquiry and the fee. The match is on the borrower.
Applications and term sheets fall through routinely. Nothing counts as revenue until the fee is collected.
A worked example
Not impressions, not leads, not cost per click. Closed revenue, by the channel that produced it, for a period you choose — with the portion we could not trace shown rather than quietly shared out across your paid channels.
| Channel | Sales | Revenue | Share | % |
|---|---|---|---|---|
| Google Ads | 25 | $1,134,000 | 21% | |
| LinkedIn Ads | 11 | $486,000 | 9% | |
| Broker and banker referrals | 31 | $1,404,000 | 26% | |
| Industry events | 9 | $432,000 | 8% | |
| Direct / Unknown | 42 | $1,944,000 | 36% |
Commercial broker fees typically run one to two per cent of the loan. On a million-dollar loan that is ten to twenty thousand dollars; on five million it is fifty to a hundred thousand. Both arrive as one enquiry.
Any report built on enquiries or even on closed deals therefore misses the only variable that matters. A channel producing half the volume at four times the average loan size is the best channel you have, and every dashboard you own will rank it fourth.
Ranking on collected fees fixes it in one step, and does so using the same closing records the firm already keeps for its own accounting.
Term sheets are issued and withdrawn, appraisals come in short, borrowers go direct to their bank at the last minute. A meaningful share of everything in the pipeline never funds, and the share differs by source.
Counting only funded loans, with the fee actually collected, removes that noise. It also means the report is reconcilable to the firm's revenue, which is the difference between a marketing number and a number the principal will act on.
Commercial debt has a term, and a term has an end date. A five-year fixed loan placed today matures on a date everyone involved already knows, and at some point before it the borrower will need to refinance, sell, or negotiate an extension. That is not a speculative future opportunity to be guessed at; it is a dated event sitting in the brokerage's own files, attached to a borrower whose deal the firm has already done once, whose property it already understands and whose lender it already knows. Very few marketing channels start from that position.
Most brokerages work that list informally and hope for the best. Somebody remembers, or a diary reminder fires eighteen months out, or the borrower rings first because they were happy last time and could not be bothered to shop. Whether the maturity list is being worked properly, and what it produces relative to the money being spent chasing new borrowers who have never heard of the firm, is not something any report in the business answers. The maturity list is not thought of as a marketing channel at all, so it is never in the comparison.
Uploading it as a source file prices it for the first time. Fees collected on refinances are ranked directly against fees collected from paid search, referral relationships and outbound calling, over whatever period the firm chooses to look at. Because the original enquiry also stays in the data, a borrower first won through a campaign four years ago and refinanced twice since keeps crediting that campaign rather than the diary reminder. That is the only honest way to value a channel in a business where the same borrowers return on a predictable cycle.
Brokers in this market compete on the breadth and quality of their lender relationships. Knowing which life company will look at a secondary market, which bank is lending on hospitality this quarter, which debt fund will stretch on leverage and who to ring on a Friday afternoon when a closing is slipping is the genuine expertise, and it is what the borrower is really paying for. Firms therefore spend heavily on conferences, association memberships, sponsorships and the travel that maintains all of it, year after year.
None of that is marketing in the sense a report understands, and it should not be measured as though it were. The lender side produces capacity, optionality and speed; it does not produce deals. What the advertising budget buys is borrowers. The two get discussed interchangeably in partner meetings because both are filed under business development and both are defended by the same people, and the confusion costs the firm real money in both directions: the relationship budget is asked to justify a pipeline it never promised, and the borrower budget escapes scrutiny it deserves.
Keeping them apart is much of the point of ranking on collected fees. A conference that produced three new lender relationships and no borrowers has done something genuinely valuable and should be argued for on exactly those grounds, not defended with a fabricated pipeline figure that will be checked and found wanting. A campaign that produced two funded borrowers can be argued for with a number that ties to the accounts. Both arguments get stronger the moment the report stops pretending they are the same argument.
Commercial mortgage work is co-brokered constantly. A local broker who knows the sponsor brings the relationship, a specialist places the debt with a lender the first broker has no access to, a correspondent takes a share for servicing, and a firm in another market takes a referral cut for the introduction that started it. The fee printed at the top of the term sheet and the money that eventually reaches the brokerage's own account can be very different figures, and the gap between them varies enormously from one file to the next.
That makes deal size a poor proxy for value in a way that compounds the existing problem of ranking on loan amount. A channel producing large co-brokered transactions can look like the strongest source in the business while contributing less than a modest source producing smaller files the firm keeps whole and services itself. No report built from the loan amount column will ever show that, and the loan amount column is the one every origination system puts in front of you first, because it is the one the lender cares about.
The pipeline tracker, which in most firms is a spreadsheet maintained by whoever is most organised rather than a system anybody bought, already holds both figures. It has to, because the principal needs to know what is genuinely coming in rather than what was quoted. Exporting the retained fee instead of the headline fee is therefore a matter of choosing a column that already exists rather than building anything new, and it is what makes the resulting channel ranking reconcile to the firm's own revenue instead of to a deal announcement.
Why it matters
"We generated 400 leads" invites an argument. "This channel closed $186,400 last quarter, here is the reconciliation" ends one. The teams that can show closed revenue by channel are the teams that get the next increase approved, because they are asking with evidence rather than with conviction.
Killing spend is politically harder than adding it, because someone always owns the channel being cut. A number that reconciles to the sales export takes the argument out of the room — you are not overruling a colleague's judgement, you are reading the same ledger they are.
Platform-reported conversions do not reconcile to revenue, and eventually someone in finance notices. Reporting built from your own closed-sales export starts from the number finance already trusts, which is why it holds up when it is checked.
Because this reconciles exports rather than tracking visitors, it works on months that have already closed. You are not instrumenting now to learn something in ninety days — you can answer for last quarter today, which is usually when the question is being asked.
Honest answers
Upload the referral list as a source file. It ranks against paid search on fees collected, which is the comparison that sizes the marketing budget.
That variability is the reason to rank on fees rather than on deal counts. The report handles it directly.
A spreadsheet of funded deals with a borrower contact detail, a fee and a date is enough.
Pricing
The number here is the number on the invoice — no per-call, per-minute or per-form fees. Most commercial and CRE finance brokerages land on Growth — thirteen months of history to compare a month to the same month last year, and a PDF you can put in front of whoever holds the budget.
A business scaling ad spend
$199/mo
billed monthly
Questions
Anything else? Talk to us — a person answers, usually the same day.
Funded loans: a borrower email or phone, the fee collected, and a funding date.
No. Only funded loans with a collected fee count as revenue.
Yes, with a loan-size column — this is usually the most revealing cut in the segment.
Yes, with a product column — bridge, permanent and construction rarely share channels.
Yes, and it is worth doing: leaving referrals out makes the paid channels look more important to your broker fees than they are.
Yes, with a producer column, on Growth and above.
Yes. There was no tag running back then and it makes no difference: the borrower appears in both files either way.
Encrypted in transit and at rest, isolated to your workspace, and deletable in one click. A DPA is available, and borrower details never leave that workspace.
Yes. Upload it as a source file and refinance fees are ranked against paid search and referrals. It is usually the cheapest channel a brokerage owns and the one nobody has ever costed.
What you retained. Co-brokering, correspondent shares and referral cuts vary enough between files that the headline fee ranks channels on deal size rather than on what the firm actually banked.
Yes, provided the first enquiry is in the data you upload. That is why loading several years of history matters more here than adding extra columns to a single year.
Separately. Those budgets buy lender relationships rather than borrowers, and forcing them into a borrower-acquisition ranking produces a number that misrepresents both sides of the business.
Yes. It needs a borrower contact detail, the fee collected and a funding date per row. Most brokerage spreadsheets already carry all three because the principal needs them for cash flow.
Yes, by uploading several years of funded deals. Repeat sponsors are the whole economics of this business, and a single year of data credits each channel with roughly one deal per relationship.
Nearby
Match points, interest and repeat originations to the campaigns that produced the borrower the first time.
See how it worksMatch funded loans and commission to the enquiries and ads that produced them, across a cycle that runs weeks to months.
See how it worksMatch funded commercial relationships to the enquiries and campaigns that produced them, across a cycle that runs months and involves a relationship manager.
See how it worksStart today
Upload two exports and see your real revenue by channel in minutes. Three days free, no card.