“We ask every caller how they found us.”
Keep doing it, and expect it to disagree with the evidence. Callers say the internet, or a friend, or they do not recall — the error is systematic rather than random.
For MyCase
Export collected fees, upload the inquiries that produced them, and rank your marketing on money rather than on consultations booked.
CloseRev reads a MyCase export of collected fees — the client's phone or email, the amount collected and the payment date — and matches it against the calls and forms that produced the inquiry. For a firm the gap between inquiry and fee runs to months, and one signed matter can be worth more than a year of another practice area's work. Matters it cannot trace are reported as Direct / Unknown rather than shared out across channels.
Page updated September 24, 2026.
The gap
Your intake log says where the inquiry came from, when somebody remembered to ask. Your fees are in MyCase. Nothing in your firm connects the two.
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 client record the matter belongs to. Take both where you have them — a client's mobile is what they rang from and their email is what they filled a form in with.
What was actually received rather than what was billed. In firms with any write-off or fee dispute those are different numbers, and only one of them paid for the marketing.
When the money came in, or when the matter opened. They answer different questions and the gap between them can be very long on contingency work.
Family, personal injury, criminal, estate. It is the most useful optional column in the file, because channels perform completely differently across them.
Step by step
Written for somebody with MyCase open in the next tab. Report names vary by edition, so each step says what to look for.
One row per matter with a client contact detail, the amount collected and a date. Look for the export listing matters with what they collected rather than a specific report name.
Billed fees flatter every channel equally until they do not — a practice area with collection problems will look better than it is, and that is the practice area you would then spend more on.
Call tracking, the website forms, the intake log, any directory or marketplace you pay for — combined into one file, with a contact detail and the source on every row.
Months for most practice areas and considerably longer for contingency work. A short file will attribute the fast, small matters and miss the ones that mattered.
The join is the phone and the email, normalized on both sides. Exact matches count; a phone that agrees only once its country code is set aside waits for a person; nothing else is linked.
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 Law Firms page — not from a MyCase account.
| Channel | Share | Sales | Revenue |
|---|---|---|---|
| Google Ads | 18 | $312,000 | |
| Meta Ads | 6 | $54,000 | |
| Email marketing | 3 | $30,000 | |
| Direct / Unknown | 14 | $204,000 |
Unmatched sales stay in Direct / Unknown. They are never spread across the paid channels to make the total look better.
The argument
A family matter, a criminal defense, an estate plan and a personal injury claim have different fee structures, different cycles, different close rates and completely different economics. A firm doing three of them runs three businesses.
Marketing is bought centrally and reported centrally, so a single cost per inquiry is compared against a single average fee. That number describes no practice area the firm actually has.
Splitting collected fees by practice area and by channel is the report the managing partner needs and cannot get, because the fees are in MyCase and the channels are in an ad account.
A personal injury matter signed today may collect nothing for two years and then collect a great deal at once. There is no partial credit along the way and nothing an ad platform can report on in the meantime.
That produces a specific and expensive error: the channel producing your best contingency matters appears to produce nothing, quarter after quarter, until it suddenly appears to produce everything. Budgets get cut in the meantime.
Matching a fee export that reaches back years is the only way to see it. Where a firm mixes contingency and hourly work, reading them separately is not optional — averaged, each hides the other.
Consultations are countable, close enough to the click for an ad platform to report, and they are what most firms rank channels on for exactly those reasons.
The conversion from consultation to signed matter varies enormously by channel, and it varies in a direction that punishes the obvious optimization: the cheapest consultations are frequently the least likely to sign, and the most expensive channel can produce the highest collected fees per dollar spent.
With consultations in the lead file, the report puts each channel's consultations beside its collected fees, which is consultation-to-fee by channel — a number worth having before the next budget is set.
Three columns and an optional practice area. No matter description, no documents, no notes, no time entries and nothing that touches privilege — none of it is usable by a match on a phone number and none of it is asked for.
That constraint is not a compliance flourish, it is a design property. A system that only ever needs a contact detail, an amount and a date cannot leak a client's business, because it was never given it.
Fair questions
Keep doing it, and expect it to disagree with the evidence. Callers say the internet, or a friend, or they do not recall — the error is systematic rather than random.
That is precisely why period-based ad reporting fails a firm, and why matching fees back to their original inquiry is the only honest reading.
You are not being asked to. A contact detail, an amount and a date — no matter detail, no documents, nothing under privilege.
No. It reads a file you exported; no credential to your firm's account is held.
Collected fees by matter, with a client contact detail, the amount and a date.
Collected. Billed fees make a practice area with collection problems look like your best marketing.
Yes, and you should. Channels perform so differently across practice areas that a blended figure describes none of them.
Beyond your longest cycle. Months for most work, years where contingency matters are involved.
They match on the original inquiry however long ago it was, which is the whole point — the ad platform gave up on that lead two years ago.
Yes, if the lead file holds the consultations: each channel's consultations then sit beside its collected fees.
Yes, once its inquiries are in the lead file under its own name — on the same axis as everything else, rather than judged on its own reporting.
They are reported as Direct / Unknown and never attributed on a name.
If you record them as a source in the lead file, they rank beside paid channels — a comparison worth having.
A contact detail, an amount and a date, plus a practice area if you include one. No matter descriptions, no documents, no time entries, nothing under privilege. Encrypted in transit and at rest, isolated to your firm's workspace, deleted with the import.
Collected fees by channel and by practice area, the share matched, and everything unmatched reported as unmatched.
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.
MyCase 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
Multi-crew home and field services businesses run on phone calls and job management software, not on web forms. Which means the standard marketing dashboard is measuring the smallest part of the business and missing where the money actually is.
Read the articleIt is easy to compute, easy to improve, and it will happily bankrupt you. A defense of the least popular position in performance marketing: that the metric most teams are held to is actively harmful, and that the alternative is available to anyone willing to do one join.
Read the articleThe channel with the cheapest leads is often the one whose leads almost never buy. Lead conversion rate by source divides the new customers each channel produced by the real, deduplicated leads it sent, counted by the month the lead arrived. Here is the formula, what to take out of the denominator, why small counts lie, how revenue per lead and cost per customer follow from it, and a five-channel worked example.
Read the articleStart today
Nothing to install in MyCase, no API key, and no need to have been tracking anything until now. Last year works as well as this month.