“The volume is too small to matter.”
That is a statement about clicks. Whether it matters depends on what the leads were worth, which is a different measurement.
For Microsoft Ads
Export your Microsoft Ads leads, match them against closed sales, and compare the channel on revenue per lead instead of on impressions.
Microsoft Ads sits on the lead side in CloseRev: export the leads its campaigns produced and match them against closed sales from whichever system holds them. The channel is small enough that most advertisers judge it on volume and stop there, which is the one comparison it is guaranteed to lose. Revenue with no traceable lead is reported as Direct / Unknown.
Page updated September 24, 2026.
The gap
It is five percent of your clicks, so nobody has ever looked at what it was worth per lead.
What was sold, to whom, and for how much.
The click, the keyword, the call, and what each one cost.
The file
Three things carry the match: who, how much, and when. Anything else is optional and only changes how the report can be sliced.
On the lead form export, the call record, or your own landing-page record carrying the campaign.
The decision level. At this channel's volume, anything finer is usually too sparse to read.
When the lead arrived; it decides which of a customer's leads came first.
Not a field of its own: separate owned search from the syndicated partner network in the campaign name so the drill-down shows them apart. They behave differently enough to be worth it.
Step by step
Written for somebody with Microsoft Ads open in the next tab. Report names vary by edition, so each step says what to look for.
Lead form downloads, call records, or your own form records stamped with the campaign.
A contact detail, the amount and the date, from the practice management, field service or CRM system that holds them.
Low volume means small numbers, and small numbers need more time before they mean anything. Six months is a reasonable floor.
A channel with a tenth of the volume will always lose a total. Revenue per lead is the comparison that answers the actual question.
The join runs on the phone and the email, normalized, with unmatched rows kept visible.
What comes back
Revenue by channel, the count of sales behind each figure, and an honest bucket for the ones nobody could trace. Sample figures, from the worked example on the B2B SaaS page — not from a Microsoft Ads account.
| Channel | Share | Sales | Revenue |
|---|---|---|---|
| Google Ads | 18 | $720,000 | |
| LinkedIn Ads | 21 | $930,000 | |
| Email marketing | 12 | $420,000 | |
| Direct / Unknown | 24 | $930,000 |
Unmatched sales stay in Direct / Unknown. They are never spread across the paid channels to make the total look better.
The argument
A channel producing twenty leads a month cannot be judged on a month. One large sale or one bad week moves the number further than any real change in performance would.
That is the honest reason small channels get cut: not that they were bad, but that nobody ever had enough data to say otherwise, and cutting is the default.
Taking six months or a year fixes it without changing anything else, and the report states how many leads each figure rests on so a number built on nine of them is visibly that.
Where the count is genuinely too small to read, treat it that way. A figure built on nine leads is not a small finding; it is not a finding.
Search on the owned properties and search on partner sites are not the same inventory, and in some accounts the difference in lead quality is large.
Because both report inside one campaign structure by default, the blended figure can hide a partner network producing volume that never closes.
Where campaign names distinguish them, the campaign drill-down splits revenue on it. Where they do not, the difference often shows up as a bimodal pattern in the same campaign.
This is the specific check worth running before concluding the channel does not work, because it is the one most likely to be the actual explanation.
Set beside a search channel ten times its size, this one loses every absolute number: fewer impressions, fewer clicks, fewer leads, less revenue.
None of those answer whether the next thousand dollars is better spent here or there, which is the only question a budget meeting is actually asking.
Revenue per lead and revenue per dollar spent do answer it, and this channel can win on both while losing on all the absolute measures.
Nothing about this is a claim that it will. It is a claim that the comparison normally made cannot tell you either way.
It will not assign a sale to a campaign where nothing in the file connects them. Unmatched revenue goes to Direct / Unknown and stays visible.
It will not manufacture significance from a handful of leads: every figure sits beside the count of leads and sales it rests on.
It will not connect to your account or write anything back. Two exported files are the whole mechanism.
What you get is a defensible number, built from rows you can open, for a channel that is usually cut on a number nobody checked.
Fair questions
That is a statement about clicks. Whether it matters depends on what the leads were worth, which is a different measurement.
Then the creative and the keywords are controlled, which makes the comparison unusually clean.
Often true over a month and rarely true over a year. The report shows the count every figure rests on, so you can see which case you are in.
No. It reads files you exported, and nothing is written back to your account.
One file of leads carrying a contact detail and a campaign, and one file of closed sales carrying a contact detail, an amount and a date.
Six months at minimum. Low volume needs more time before a figure means anything.
A smaller channel loses every total by construction. Per lead is the comparison a budget decision actually needs.
Yes, where campaign names distinguish it, and it is the first check worth running on this channel.
The report shows the count of leads and sales each figure rests on, so a ratio built on a handful is visibly that.
Yes, and running both in one file is the point: the same customers, the same window, the same rules.
The caller's number is the lead key, the same as any other lead.
Yes, across channels. The earliest of their leads takes the credit.
No. It answers what happened after the lead, which the platform never sees.
A contact detail, a campaign and a date on one side; a contact detail, an amount and a date on the other. No audiences, no keywords required, no creative. Encrypted in transit and at rest and deleted with the import.
Closed revenue per campaign and per lead, with the underlying counts shown, and everything unmatched kept visible.
By trade
What the report looks like once the export is in, written for each one.
Other systems
Running more than one system, or comparing? The method is the same and the columns are not.
Microsoft Ads and the other product names and logos on this page belong to their owners and are shown to identify the software a file comes from. CloseRev is not affiliated with or endorsed by them, and connects to none of them: it reads a file you export.
From the blog
Microsoft Advertising reaches a smaller audience than Google and converts a more valuable one. It is also the channel most likely to be missing from the lead export entirely — which means its revenue quietly lands in Direct / Unknown and the budget gets cut for underperforming.
Read the articleOffline conversion imports let Google and Meta optimize toward money instead of form fills. They also hand a platform your customer list and let it mark its own homework. Here is how to do it without either mistake.
Read the articleA growing share of the conversions in your ad platform reports were not observed. They were estimated by a model, from the behavior of other people, and reported in the same column as the real ones. That is a defensible thing for a platform to do and an indefensible thing for you not to know.
Read the articleStart today
Nothing to install in Microsoft Ads, no API key, and no need to have been tracking anything until now. Last year works as well as this month.