Right now, one of your lead vendors is generating cases at a loss. Your current marketing report probably can't tell you which one — or by how much.
Standard marketing reports track inputs: spend, leads, calls. A finance-ready revenue intelligence report connects those inputs to outputs — signed cases, settlement revenue, and return on every dollar deployed. It treats marketing spend as a capital investment, not a line item. The result is a report any managing partner can evaluate and act on.
Here is what that report looks like, section by section.
Section 1: Executive Summary
The executive summary has one audience: the managing partner. One page. No more than five numbers. The goal isn't to impress — it's to answer the questions they'll ask before anyone says a word.
Total Marketing Spend
$215,000
Current month actual
Signed Cases
68
From all marketing activity
Blended Cost Per Case
$3,162
Spend ÷ signed cases
Rolling 18-Month ROI
5.8x
Net fees per dollar spent
Section 2: Investment Breakdown
Keep reading
This section establishes the total capital deployed in lead generation for the period — broken out by category, including costs most marketing reports quietly omit.
What It Includes
- Direct marketing spend:Every dollar paid to lead vendors and advertising channels, itemized by vendor. Example: $218,400 total — $72,000 Google/LSA, $45,000 Vendor A, $38,000 Vendor B, $35,000 Vendor C, $28,400 Vendor D.
- Intake labor cost:Fully-loaded monthly cost of the intake team. Example: $24,600 — four intake specialists at $55K base plus 28% overhead.
- Total case acquisition investment:Direct spend plus intake labor. Example: $243,000 for the period.
Most marketing reports stop at direct spend. Without intake labor, acquisition cost is understated by $24,600 per month — roughly $295,000 per year. A managing partner who doesn't see that number is working with incomplete math.
$243K
Total Investment
$243,000 total monthly acquisition cost breakdown
Section 3: Vendor Performance Scorecard
This is the operational core of the report. It grades every active lead vendor on every metric that matters for budget decisions — and surfaces what a blended average buries.
What It Includes
- Monthly spend and leads received
- Rejection rate and signed cases
- Cost per signed case vs. prior period
- Status vs. break-even threshold (Green / Yellow / Red)
- Projected average net fee per case (based on historical data)
- Projected ROI: projected net fees / spend
- Trend: improving, stable, or declining vs. prior 3 months
Sample Scorecard Output
- Google/LSA: $72,000 spend, 180 leads, 14% rejection, 38 cases, $1,895 cost/case — Green (↓ 8% vs. prior)
- Vendor A: $45,000 spend, 92 leads, 22% rejection, 16 cases, $2,813 cost/case — Green (stable)
- Vendor B: $38,000 spend, 108 leads, 31% rejection, 14 cases, $2,714 cost/case — Green (↑ 4%)
- Vendor C: $35,000 spend, 96 leads, 45% rejection, 8 cases, $4,375 cost/case — Yellow (↑ 19%)
- Vendor D: $28,400 spend, 74 leads, 52% rejection, 5 cases, $5,680 cost/case — Red (↑ 34%)
Total: $218,400 direct spend, 550 leads, 81 cases, $2,697 blended cost/case
Vendor D is generating cases at $5,680 — 18% above the $4,800 break-even. Every case from Vendor D is a losing trade. That signal was invisible in last month's blended report. It is the most important number on this page.
Section 4: Intake Funnel Analysis
Marketing ROI doesn't stop at lead quality — it depends on what intake does with those leads. This section shows exactly where leads are converting and where they're leaking.
It's also the diagnostic that separates vendor problems from intake problems. If a vendor's conversion rate looks weak because intake is only reaching 40% of their leads — not because the leads are bad — the fix is intake speed, not vendor selection. Those are very different budget decisions.
Best-in-class PI intake teams reach 70%+ of leads within the first hour and convert 25–40% of qualified leads to signed cases. If your numbers are below that, intake efficiency is draining ROI as fast as any underperforming vendor.
Section 5: Budget vs. Actuals
This section answers a simple accountability question: did we spend what we planned, and where did we drift? Track it year-to-date as well as monthly. A firm that consistently underspends in Q1 and overspends in Q3 has a budget discipline problem — and that pattern quietly distorts ROI calculations over time.
Separate committed spend from variable spend. Fixed retainers run regardless of performance. Pay-per-lead and pay-per-call budgets can be adjusted in real time based on ROI data. That distinction matters when you're deciding where to reallocate.
| Channel | Budgeted | Actual | Variance | |
|---|---|---|---|---|
| Google Ads / LSA | $65,000 | $72,000 | +$7,000 (10.8%) | |
| Vendor A | $45,000 | $45,000 | $0 (0%) | |
| Vendor B | $35,000 | $38,000 | +$3,000 (8.6%) | |
| Vendor C | $35,000 | $35,000 | $0 (0%) | |
| Vendor D | $30,000 | $28,400 | -$1,600 (5.3%) |
Section 6: Revenue Attribution and Marketing P&L
This section converts signed cases into expected revenue, segmented by vendor — not averaged across the portfolio — and builds the full marketing P&L. Each vendor now has a number a managing partner can judge independently.
Revenue by Vendor
- Google/LSA: 38 cases × $7,100 avg expected fee = $275,520 — ROI: 283%
- Vendor A: 16 cases × $7,028 avg = $112,440 — ROI: 150%
- Vendor B: 14 cases × $7,260 avg = $101,640 — ROI: 167%
- Vendor C: 8 cases × $6,150 avg = $49,200 — ROI: 41%
- Vendor D: 5 cases × $5,800 avg = $29,000 — ROI: 2%
Two percent ROI for Vendor D. That's the number that should lead the next budget conversation — not lead volume, not rejection rate, not cost per lead. ROI is the language of a managing partner's meeting. Use it.
Acquisition Investment
$243,000
Direct + intake labor
Expected Case Revenue
$567,800
81 cases × expected fee
Marketing Margin
57.2%
2.8 pts below 60% target
Blended CPC
$2,697
37.5% below $4,800 break-even
Section 7: Settlement Revenue Attribution
For settlements that closed this month, this section traces each one back to its marketing origin. It's the proof layer — when a managing partner asks which vendor produced the highest-value cases, this section answers with actual settlement data, not projections. No estimates. No blending. Source-level accountability.
Section 8: Cohort Performance Tracker
The cohort tracker is the section most PI firms don't have — and the one that generates the most valuable long-term data. It shows a rolling table of monthly cohorts, each representing cases signed in that month, tracking projected vs. actual ROI as settlements come in over time.
Settlement revenue lags spend by 6–18 months. The cohort tracker closes that gap — letting you compare projected ROI at signing against actual ROI at settlement. Over time, it reveals which vendor sources and case types consistently outperform or underperform their projections. That's a calibration data set no single-month report can produce.
Section 9: Recommended Actions
A finance-ready report doesn't end with data. It ends with recommendations — each one tied to a specific financial rationale, not a marketing hunch.
- Vendor actions with cost justification:“Vendor D: Initiate 60-day performance improvement plan. Current ROI of 2% does not clear our 40% minimum threshold. If cost per case does not improve to below $4,800 by Day 60, recommend budget reallocation to Google/LSA, which is generating 283% ROI at scale.”
- Budget reallocation with expected return:“Reallocating Vendor D's $28,400 to Google/LSA at its current $1,895 cost per case would produce approximately 15 additional cases per month. Expected revenue impact: +$109,000 in expected contingency fees.”
- Intake capacity check:“At 81 cases per month, intake is at 88% capacity. A 15-case increase is feasible without additional headcount.”
- Next quarter budget forecast:Based on signed case targets and current cost-per-case benchmarks, projected required spend for next quarter.
Who Gets Which Sections
The full report doesn't need to go to everyone in the same form. Tailor delivery by role:
- Managing partnersget Sections 1 and 8 — executive summary and cohort performance. Financial picture, no operational detail.
- Marketing directorsget Sections 3 and 5 — the vendor scorecard and budget tracking. These are the decision-making sections.
- Intake managersget Section 4 — the funnel analysis. Intake accountability lives here.
- Financegets Sections 5 and 7 — budget actuals and settlement attribution. This is how marketing spend reconciles against revenue.
Standard Marketing Report
- Tracks leads and cost per lead only
- No connection to signed cases or settlements
- Single month snapshot with no cohort data
- Same report goes to everyone
- Backward-looking only — no forward projections
Revenue Intelligence ROI Report
- Tracks cost per case and ROI per vendor
- Connects marketing spend to settlement revenue
- Rolling cohort analysis across 18+ months
- Tailored sections for partners, marketing, intake, and finance
- Forward-looking pipeline value and budget recommendations
How to Produce This Report Without Building It From Scratch
Most firms can't produce all nine sections on day one. That's expected. Start with what you have:
- Spend data and case data: build Sections 1, 2, and 3.
- Intake disposition data: add Section 4.
- Budget tracking: add Section 5.
- Add Sections 6–9 as cohort data matures and settlement attribution is in place.
Building this manually — pulling vendor invoices, matching signed cases to lead sources, calculating expected revenue by case type — runs 10 to 15 hours per month in a firm with good CRM hygiene. When source attribution is built into the intake workflow at the point of entry, the report becomes a query instead of a project. That shift takes the monthly exercise from 15 hours to 15 minutes.
Every section you complete is a budget decision grounded in evidence instead of assumptions.
RevenueScale's Financial Intelligence framework produces this report automatically — populated with your actual vendor mix, case volume, and settlement data. No monthly manual assembly required.
Related guide: See our complete guide to tracking marketing ROI for PI law firms — the PI-specific ROI formula, 5 prerequisite metrics, and how to present results to managing partners.
Related guide:For the full Revenue Intelligence framework behind this piece, read our pillar: Revenue Intelligence for PI Firms — covering Performance, Intake, Source, and Financial Intelligence, plus the maturity assessment every firm should run.
Related guide:For the complete guide to PI marketing budget allocation, read our pillar on Personal Injury Marketing Budget Planning — channel-by-channel allocation benchmarks, monthly spend ranges by firm size, and how to defend every line item.
