How to Build a Settlement Revenue Attribution Model for a Multi Location PI Firm

Here is a question that derails budget meetings at multi-location PI firms: a lead enters through your Dallas marketing, routes to the Houston office because of incident proximity, and settles 16 months later for $280,000. Which office gets credit? Which budget takes the acquisition cost? When you cannot answer that cleanly, every office-level ROI number is suspect — and partners know it.

This guide walks through how to build a settlement revenue attribution model that holds up across multiple offices. It covers the attribution hierarchy, spend classification, shared cost allocation, and the reconciliation process that makes your numbers defensible when a managing partner pushes back.

Why Multi-Location Attribution Is Different

A single-office firm spends $120,000 per month on marketing. Cases settle. Divide settlement revenue by spend. The math is clean.

A three-office firm spending $350,000 per month is a different problem entirely. Markets have different cost structures, case values, and competitive dynamics. Some vendors serve all locations. Some campaigns run nationally but route leads to specific offices. A lead originates in Dallas, transfers to Houston for geographic proximity, and settles 14 months later.

Which office gets credit for that settlement revenue? Which marketing budget absorbs the acquisition cost? How do you split shared costs — brand campaigns, SEO, website — across offices?

These are not edge cases. They determine how each office's marketing ROI is calculated, which markets get budget increases, and whether the partners at each location trust the numbers at all.

Step 1: Establish Your Attribution Hierarchy

Before you build anything, decide which office gets credit for a settlement. There are three approaches:

• Lead origin attribution.Credit settlement revenue to the market where the lead originated — regardless of which office handled the case. This ties revenue back to the marketing investment that generated the lead.
• Case handling attribution.Credit settlement revenue to the office that worked the case through settlement. This aligns revenue with the office that did the legal work.
• Split attribution.Divide settlement revenue between the originating market (marketing credit) and the handling office (operational credit). More complex, but gives the most complete picture.

For marketing ROI, lead origin attribution wins. Your Dallas marketing spend should be measured against settlement revenue from Dallas-originated leads — even when Houston handled those cases. If you use case handling attribution to evaluate marketing, you are measuring operational performance, not marketing performance. That conflation quietly distorts every budget decision you make.

Step 2: Classify Your Marketing Spend

Most marketing spend does not map cleanly to a single location. Classify every line item into one of three buckets before you build anything else.

Location-Specific Spend

Spend that serves one market directly: local vendor contracts, geo-targeted Google Ads campaigns, market-specific TV buys, local sponsorships. These attribute 100% to the associated office. For a three-office firm, this typically covers 50–65% of total marketing spend.

Shared Direct Spend

Spend that serves multiple markets with trackable lead flow: national paid search, multi-market vendors that tag leads by region, website traffic segmentable by geography. Allocate these costs based on actual lead distribution. A national campaign producing 120 leads — 45 for Dallas, 50 for Houston, 25 for Austin — gets split in that 45/50/25 ratio.

Shared Overhead

Spend that cannot be tied to leads by market: brand campaigns, SEO retainers, website maintenance, marketing salaries, MarTech subscriptions. These require an allocation methodology — one that is defensible, consistent, and written down before anyone questions it.

Step 3: Build Your Allocation Methodology for Shared Costs

Shared overhead allocation is where most multi-location attribution models collapse. The method you choose directly affects each office's reported marketing ROI — so it will face scrutiny from every office-level partner who thinks their number looks wrong.

Three defensible approaches:

• Lead volume allocation.Distribute shared costs proportional to total leads by market. Dallas at 40% of firm leads absorbs 40% of shared costs. Simple, transparent, and tied directly to marketing output.
• Revenue allocation.Distribute shared costs proportional to settlement revenue by market. High-revenue markets carry more overhead. This aligns costs with capacity to pay — but can unfairly penalize your best-performing offices.
• Equal allocation.Split shared costs evenly across all offices. Zero arguments about methodology, but distorts ROI for smaller offices that end up carrying a disproportionate share.

For most firms, lead volume allocation is the right default. It connects shared costs to marketing output, updates automatically as lead mix shifts, and is easy to explain in a five-minute partner conversation.

The allocation method changes each office's reported costs — and therefore their ROI. Austin's overhead burden looks very different under equal allocation ($10,000) versus revenue-based allocation ($5,400). That delta shifts ROI enough to flip a budget decision. Set the methodology at the start of the fiscal year, document it, and hold it for 12 months. Changing it mid-year invites accusations of moving the goalposts.

Step 4: Handle Cross-Market Lead Transfers

Cross-market transfers create the thorniest attribution challenges. A lead enters through Dallas marketing, routes to the Houston office based on incident location, and settles as a Houston case. Simple enough on paper — but the data model needs to handle it correctly every time.

The attribution decision: does Dallas get marketing credit for generating the lead, or does Houston get it for signing and settling the case?

For marketing ROI, lead origin retains the attribution. Dallas marketing spend produced that lead — evaluate it against the revenue that lead generated, regardless of where the case landed. Add a “transfer flag” in your tracking so transferred cases are visible in reports, but the marketing attribution follows the original source and market.

This means your marketing ROI report and your operational P&L will show different numbers for the same office. That is correct — they measure different things. Marketing ROI measures return on marketing investment. Operational P&L measures the revenue the office's legal work produced. Collapsing them into one number makes both metrics useless.

Step 5: Accounting Treatment and Reconciliation

The attribution model has to reconcile with actual financial records. This is where the CFO enters the conversation — and where most marketing-built models fall apart under scrutiny.

• Total attribution must equal total spend.Every dollar of marketing spend gets allocated to a market. The sum of all office-level costs must equal total firm marketing spend exactly. Any gap erodes credibility immediately.
• Settlement revenue must match accounting records. The settlement figures in your model must reconcile with actual cash received or case management system records. Even small discrepancies undermine trust in everything else.
• Pin your cost timing convention.Do you record marketing spend in the month it was incurred, the month the lead arrived, or the month the case was signed? Use the month the lead arrived — it ties the cost to the marketing action that produced the lead and makes cohort analysis possible.
• Document every rule.Write down each allocation rule, exception handler, and timing convention. When a partner questions a number, show them the method — do not recreate it from memory.

Step 6: Build the Reporting Layer

The attribution model produces data. The reporting layer turns it into decisions. Build three views — each for a different audience and cadence:

• Firm-wide view.Total marketing spend, total attributed settlement revenue, blended ROI across all markets. For quarterly board-level conversations.
• Market-level view.Each office's direct spend, allocated shared costs, total attributed marketing cost, and settlement revenue from leads originated in that market. For monthly marketing reviews.
• Vendor-level view by market.Each vendor's performance within each market — cost per case, settlement value, ROI. For vendor evaluation and budget allocation decisions.

Every view needs both the current period and a trailing 12-month trend. Settlement attribution is inherently lagged — a single month's numbers may be incomplete because cases are still working. The 12-month view smooths that lag and gives you a reliable signal rather than noise.

Common Pitfalls in Multi-Location Attribution

These are the failure modes that show up repeatedly across firms with two to eight offices:

• Changing allocation methodology mid-year.This kills year-over-year comparisons and signals to partners that the numbers are being managed. Lock in the method at the start of the fiscal year. Hold it for 12 months, then revisit.
• Double-counting settlement revenue.When a case transfers between offices, it can appear in both revenue figures if the data model has not been carefully designed. Maintain a single source of truth for settlement amounts, with explicit attribution flags to prevent duplication.
• Ignoring the settlement lag on new offices.A new location in its first year will show poor marketing ROI — not because marketing is failing, but because leads have not had time to mature into settlements. Evaluate new markets on leading indicators (lead volume, case signing rate, intake conversion) for the first 18 months. Layer in settlement data after that.
• Over-engineering the model.A model that requires a detailed walk-through to understand will not be trusted or used. Keep allocation rules simple, transparent, and explainable in a five-minute conversation with any partner in the room.

Automating the Process

A two-office firm with clean spend categories can build this attribution model in spreadsheets. Beyond that, the manual effort becomes unsustainable fast. A three-office firm with six vendors and shared overhead requires reconciling 50+ data points every month — and cross-market transfers add complexity that spreadsheets do not handle gracefully.

RevenueScaleautomates multi-location attribution by connecting intake systems, case management platforms, and marketing spend data across offices. Lead origin tagging, cross-market transfer tracking, shared cost allocation, and settlement attribution all run automatically — producing firm-wide, market-level, and vendor-level views without manual assembly each month.

For a CFO evaluating multi-location marketing performance, the value is not just accuracy — it is consistency. The same methodology applied the same way every month, with a full audit trail showing exactly how each number was calculated. That consistency is what earns the model enough trust to actually drive budget decisions across offices.