Blog · How-to guides · Legal services
Calculate marketing ROI for lawyers using collected matter fees, refunds, delivery costs and campaign spending. Follow the export-to-spreadsheet method and reconcile collection lag before comparing campaigns.
Marketing ROI for lawyers compares collected fee contribution with the cost of acquiring the associated work. Match the campaign to a defined matter-opening cohort, deduct refunds and included delivery costs, then compare the remaining contribution with marketing spending. Leads, signed engagements and billed fees are useful checkpoints, but none substitutes for collected fees in a realized-return calculation.
Start with the campaign-cost ledger, intake summary, matter-opening register, fee-collection summary and delivery-cost summary. Keep client names, case descriptions and confidential matter details out of the working campaign summary. The analysis needs aggregate financial amounts and consistent matching labels.
Use the intake record to connect a supplied campaign source to the matter-opening record. Then let finance associate eligible collections and delivery costs with that matter cohort before producing the aggregate. Record cases with disputed or missing campaign credit separately rather than assigning a source because it seems likely.
Choose a collection cutoff and retain it in the report. A US regional firm's first-quarter matter cohort, for example, can include collections through September 30, 2026. When later payments arrive, update that same cohort instead of treating them as results of the campaign running when the cash arrived.
The general marketing ROI versus ROAS method explains the margin distinction. Here the additional work is connecting intake to matters and deciding which collections are fees retained by the firm.
Ask the accounting owner to classify collections before calculating return. Client money, settlement proceeds held for others, refundable advances and expense reimbursements should not become fee revenue simply because they appear in a bank export.
For a concrete illustration of why classification matters, California's Rule 1.15 distinguishes funds held for clients, advances and earned fees, with specific provisions for advance flat fees. Apply your firm's approved classifications and applicable rules; the marketing worksheet should consume those classifications rather than decide them.
Also distinguish a management cash-contribution measure from the firm's accounting income. The IRS explanation of cash and accrual methods separates income received from income earned. A collections-based campaign analysis should not silently be presented as an accrual profit statement.
Keep the delivery boundary explicit. The example below includes recorded attorney and paralegal labor at internal cost plus unreimbursed matter expenses. It excludes general firm overhead. It therefore measures contribution before that overhead, not final firm profit.
The illustrative firm has three campaign cohorts. Collections contain eligible fees only, and costs cover the included matters through the cutoff. These are aggregate USD amounts.
| Campaign | Collected fees (USD) | Fee refunds (USD) | Delivery costs (USD) | Marketing costs (USD) |
|---|---|---|---|---|
| Search campaign | 180,000 | 6,000 | 105,000 | 24,000 |
| Local event campaign | 140,000 | 4,000 | 84,000 | 16,000 |
| Client reactivation campaign | 80,000 | 0 | 48,000 | 10,000 |
| Total | 400,000 | 10,000 | 237,000 | 50,000 |
With campaign in A and the input amounts in B through E, enter these Excel formulas in F2 through I2 and fill down:
F2 = B2-C2
G2 = F2-D2
H2 = G2-E2
I2 = IF(E2=0,"",H2/E2)
They produce net collected fees, contribution before marketing, contribution after marketing and ROI, respectively. Format the last column as a percentage.
| Campaign | Net collected fees (USD) | Contribution before marketing (USD) | Contribution after marketing (USD) | ROI |
|---|---|---|---|---|
| Search campaign | 174,000 | 69,000 | 45,000 | 187.5% |
| Local event campaign | 136,000 | 52,000 | 36,000 | 225.0% |
| Client reactivation campaign | 80,000 | 32,000 | 22,000 | 220.0% |
| Total | 390,000 | 153,000 | 103,000 | 206.0% |
Percentages are rounded to one decimal place. Calculate the total directly from summed amounts:
=SUM(H2:H4)/SUM(E2:E4)
That is $103,000 divided by $50,000. Do not average the campaign percentages. Compare acquisition spending separately with customer acquisition cost when the question is the cost of winning a new client; reactivated clients require a separate cohort.
For a longer classified export, Microsoft's SUMIFS function adds values meeting multiple criteria. If A contains campaign, B contains cohort and C contains eligible fee collections, use:
=SUMIFS(C2:C100,A2:A100,K2,B2:B100,L2)
K2 holds the selected campaign and L2 its matter cohort. Covirage is not affiliated with Microsoft.
The finance check is an identity built from the input table:
400,000 - 10,000 - 237,000 - 50,000 = 103,000
103,000 + 237,000 + 50,000 = 390,000 net collected fees
Tie collections and refunds to the finance-approved fee summary. Tie delivery costs to the included time-cost and expense summaries. Tie campaign spending to the ledger, including agency invoices and internal campaign labor. Investigate unmatched matter totals separately.
Collection lag can change the result without any change in the original campaign. Suppose the local event cohort later collects another $30,000 of eligible fees, with no additional refunds or costs in this isolated sensitivity:
| Measure | Original cutoff (USD) | Later collections added (USD) | Updated amount (USD) |
|---|---|---|---|
| Net collected fees | 390,000 | 30,000 | 420,000 |
| Contribution after marketing | 103,000 | 30,000 | 133,000 |
| Marketing costs | 50,000 | 0 | 50,000 |
Updated ROI is 133,000 / 50,000 = 266.0%. A live update must also bring in any later delivery costs or refunds. This sensitivity shows why campaigns need comparable collection maturity before their rankings inform marketing ROI improvements.
Bring anonymous campaign-level summaries of eligible collected fees, refunds, matter delivery costs and marketing spending. Covirage maps the columns, and its tools compute and check the comparisons; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.
See Covirage for law firms for the supporting industry context.
Use collected fees when evaluating realized cash contribution. Billed fees can support a separate earned-revenue view, but outstanding bills should remain visible. Label the basis and use the same basis for each campaign so collection timing does not silently change the comparison.
A receipt described as a retainer is not enough to classify it. Have the firm's accounting owner identify earned fee collections, unearned advances and client funds under its applicable rules. Use only the eligible fee amount in this analysis, without counting the same transfer again.
Use a stated boundary, such as recorded attorney and paralegal labor at internal cost plus unreimbursed matter expenses. Keep campaign labor in marketing spending. If allocated overhead is included, identify it separately and apply the same allocation method across the compared cohorts.