Law Firm Marketing ROI Calculator: Track Lead Costs, Intake Conversion, and Signed-Client Value

Overview

Marketing performance is easier to manage when the full path from inquiry to signed engagement is visible. A channel may generate many inquiries but few qualified matters. Another may produce fewer leads but a higher consultation or signed-client rate. Measuring only traffic, clicks, or raw lead volume can hide those differences.

The basic law firm marketing ROI calculator should be organized by source and reporting period. Useful source labels might include organic search, paid search, a legal directory, Google Business Profile, referral, phone call, website form, live chat, or another clearly defined campaign. Keep the labels consistent so that a lead is not counted differently from one month to the next.

At minimum, track these stages:

• Leads: New inquiries that can be associated with a source.
• Qualified leads: Inquiries that meet the firm’s practice-area, location, timing, conflict, and matter-fit criteria.
• Consultations booked: Qualified prospects who schedule a consultation or agreed next step.
• Consultations held: Appointments that actually take place.
• Signed clients: Prospects who complete the firm’s engagement process.
• Collected value: Revenue received, where the firm has reliable data to use it.

For a practical intake framework, compare this model with the law firm intake checklist and the lead response and follow-up playbook. The calculator is only as useful as the intake definitions and records behind it.

How to estimate

Create one spreadsheet row for each channel and month. Add columns for spend, leads, qualified leads, consultations booked, consultations held, signed clients, and value. Then calculate the following metrics:

• Cost per lead: Marketing spend ÷ total leads.
• Qualified-lead rate: Qualified leads ÷ total leads.
• Consultation booking rate: Consultations booked ÷ qualified leads.
• Consultation show rate: Consultations held ÷ consultations booked.
• Signed-client rate: Signed clients ÷ consultations held, or signed clients ÷ total leads if that is the firm’s chosen view. Label the denominator clearly.
• Cost per qualified lead: Marketing spend ÷ qualified leads.
• Client acquisition cost: Marketing spend ÷ signed clients.
• Average signed-client value: Total attributed value ÷ signed clients.
• Return on marketing spend: Attributed value ÷ marketing spend.

Use zero or “not available” carefully. If a channel has no signed clients yet, its acquisition cost is not zero; it is not yet calculable. A spreadsheet formula should avoid presenting an empty denominator as a favorable result.

Separate marketing spend from other operating costs. A simple return-on-marketing-spend calculation may include advertising, directory fees, campaign-specific software, or landing-page costs. A broader profitability model may also include intake labor, consultation time, payment processing, case expenses, and other delivery costs. State which version you are using rather than calling both “ROI.”

Do not assign every signed matter to the first interaction automatically. If a person discovers the firm through search, returns through a directory, and later calls after a referral, the tracking system should either use a defined attribution rule or mark the source as uncertain. Consistency is more valuable than false precision.

Inputs and assumptions

The calculator needs operational definitions before it needs more formulas. Write a short data dictionary in the first tab of the spreadsheet. For example, define a lead as a new inquiry with contact information, and define a qualified lead as one that passes the firm’s stated screening criteria. Exclude spam, duplicate records, existing clients, and inquiries outside the firm’s service area only if those exclusions are applied consistently.

Track the following inputs:

• Time period: Month, quarter, or another fixed reporting window.
• Source: The original or selected attribution source.
• Spend: Amount paid for the channel during the period.
• Intake status: New, contacted, qualified, booked, held, declined, pending, or signed.
• Response information: Date and time received, first response, and disposition.
• Value assumption: Expected, billed, collected, or another clearly labeled measure.
• Time lag: The period between first inquiry and signed engagement.

Long sales cycles require a cohort view. Leads received in one month may not become signed clients until a later month. For that reason, a monthly dashboard can show both current-period activity and the eventual outcome of earlier lead cohorts. Avoid judging a new channel solely on incomplete leads that have not had reasonable time to progress.

Value assumptions also require care. A hypothetical matter value is not the same as cash collected. If the firm uses expected value, record how that estimate was made and review it against later results. For contingency or variable-fee matters, consider tracking several scenarios rather than one confident number. For hourly or fixed-fee matters, distinguish an initial engagement value from longer-term collected revenue.

Privacy and professional obligations matter as well. Limit spreadsheet access, avoid unnecessary client details, and use matter IDs instead of sensitive facts where possible. The calculator should support responsible intake and reporting, not encourage sharing confidential information with unapproved tools.

Worked examples

Assume a fictional firm spends $2,400 on a search campaign during one month. It records 48 leads, 24 qualified leads, 12 booked consultations, 9 held consultations, and 3 signed clients. The calculations are:

• Cost per lead: $2,400 ÷ 48 = $50.
• Qualified-lead rate: 24 ÷ 48 = 50%.
• Consultation booking rate: 12 ÷ 24 = 50%.
• Consultation show rate: 9 ÷ 12 = 75%.
• Signed-client rate from held consultations: 3 ÷ 9 = 33.3%.
• Client acquisition cost: $2,400 ÷ 3 = $800.

If the firm attributes $7,500 in collected value to those clients, return on marketing spend is $7,500 ÷ $2,400, or 3.125. Expressed as a multiple, that is 3.125x. This is not a complete profit calculation because it does not subtract service delivery or other overhead costs.

Now compare a fictional directory channel that costs $900 and produces 12 leads, 8 qualified leads, 5 held consultations, and 2 signed clients. Its cost per lead is $75, higher than the search campaign’s $50, but its acquisition cost is $450, lower than $800. The example shows why “cheapest lead” and “best channel” are not interchangeable conclusions. The firm should also check matter quality, workload, value, and time to collect before reallocating budget.

For directory-specific attribution questions, see the guide to comparing legal directories. For website-specific improvements, use the law firm landing page checklist alongside the conversion data.

When to recalculate

Update the calculator at a regular interval, such as monthly, and review a longer rolling period before making major budget decisions. Recalculate immediately when channel pricing, intake staffing, consultation fees, targeting, practice-area focus, or attribution rules change. Also revisit the model when the firm changes its definition of a qualified lead or signed client.

Use a monthly review meeting to answer four practical questions:

1. Which channels generated qualified matters rather than merely inquiries?
2. Where did prospects drop out: contact, qualification, booking, attendance, or engagement?
3. Are response times, follow-up steps, or scheduling capacity affecting conversion?
4. Does the value of signed matters justify the acquisition cost after relevant costs are considered?

Keep prior periods unchanged when possible. If a definition or formula changes, add a note and preserve the old view so trends remain interpretable. Reconcile the spreadsheet against the case-management or intake system, investigate duplicate leads, and review a small sample of records for source and status accuracy.

Finally, treat the calculator as a decision aid rather than an automatic budget-setting rule. A channel with limited volume may need more time, while a high-volume channel may strain the firm’s ability to answer calls or conduct consultations. Pair financial results with intake quality, capacity, professional responsibility, and client experience. A repeatable measurement habit will produce more useful insight than a single impressive monthly percentage.