Most PI firm marketing reports answer one question: how many leads did we get? A finance-ready revenue intelligence report answers a different set of questions — the ones that actually drive budget decisions, vendor negotiations, and partner conversations.
A standard marketing report shows inputs (spend, leads, calls). A revenue intelligence report connects those inputs to outputs (signed cases, case value, settlement revenue) — and presents marketing spend as a capital investment with a specific, calculated return that any managing partner can evaluate and use to make budget decisions.
This is what that report looks like, section by section.
Section 1: Executive Summary
The executive summary exists for one reader: the managing partner. It should fit on one page or one screen, with no more than five numbers. The goal is not to impress — it's to answer the questions a managing partner will ask before anyone explains anything.
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
This section establishes the total capital deployed in lead generation for the period, broken out by category — including costs most marketing reports omit.
What It Includes
- Direct marketing spend: Total paid to lead vendors and advertising channels, broken out by vendor name and channel type. 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 + 28% overhead allocation).
- Total case acquisition investment: Direct spend + intake labor. Example: $243,000 total for the period.
Most marketing reports show only direct spend. Including intake labor reflects the true cost of case acquisition — because without intake, no lead becomes a signed case. A managing partner reviewing only the $218,400 number is understating acquisition cost by $24,600 per month, or roughly $295,000 per year.
$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 against every metric that matters for budget decisions — and makes visible what a blended average hides.
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 cost against a $4,800 break-even. Every case from Vendor D is 18% above sustainable acquisition cost. 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 just depend on the quality of leads — it depends on what intake does with them. The intake funnel section shows where leads are converting and where they're leaking.
This section is critical for understanding whether a vendor performance problem is really a vendor problem or an intake problem. If a vendor's conversion rate is low because intake is only reaching 40% of their leads — not because the leads are bad — the fix is in intake speed, not vendor selection.
Best-in-class PI intake teams reach 70%+ of leads and convert 25–40% of qualified leads to signed cases. If your numbers are below that, intake efficiency is costing you as much as bad vendors.
Section 5: Budget vs. Actuals
This section answers the basic financial accountability question: did we spend what we planned to spend, and where did we deviate? Track this cumulatively year-to-date as well — a firm that consistently underspends in Q1 and overspends in Q3 has a budget discipline problem that affects the reliability of ROI calculations downstream.
Track committed vs. variable spend separately. Fixed monthly retainers are committed regardless of performance. Variable spend (pay-per-lead, pay-per-call) can be adjusted in response to ROI data — and that distinction matters when you're making reallocation decisions.
| 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.
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%
ROI of 2% for Vendor D is the number that should dominate the next budget conversation. Not the lead volume, not the cost per lead, not the rejection rate — the ROI. That is the language of a managing partner's meeting, not a marketing meeting.
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 in the current month, this section connects them back to their marketing origin. This is the proof layer — when a managing partner asks which vendor produced the highest-value cases, this section answers the question with actual settlement data, not projections.
Section 8: Cohort Performance Tracker
The cohort tracker is the section most firms don't have — and it's the one that produces the most valuable long-term data. It shows a rolling table of monthly cohorts, each representing the cases signed in that month, tracking projected vs. actual ROI as cases settle over time.
Because settlement revenue lags spend by 6–18 months, the cohort tracker lets you compare projected ROI (calculated when cases were signed) against actual ROI (calculated as cases settle). Over time, this reveals which case types or vendor sources consistently over- or under-perform their projections.
Section 9: Recommended Actions
A finance-ready report does not end with data. It ends with recommendations that have a financial rationale.
- 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
A full revenue intelligence ROI report does not need to go to everyone in the same form. Consider tailoring delivery:
- Managing partners get Sections 1 and 8 — the executive summary and cohort performance. They want the financial picture without operational detail.
- Marketing directors get Sections 3 and 5 — the vendor scorecard and budget tracking. These are the decision-making sections.
- Intake managers get Section 4 — the funnel analysis. This is where intake accountability lives.
- Finance gets Sections 5 and 7 — budget actuals and settlement attribution. This is how marketing expenses reconcile 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 fine. Start with what you have:
- If you have spend data and case data: build Sections 1, 2, and 3.
- If you also have intake disposition data: add Section 4.
- If you have budget tracking: add Section 5.
- Add Sections 6–9 as cohort data matures and settlement attribution is implemented.
Building this report manually — pulling vendor invoices, matching signed cases to lead sources, calculating expected revenue by case type — takes 10 to 15 hours per month in a well-organized firm with good CRM hygiene. When source attribution is built into the intake workflow, every lead tagged at entry and every signed case retaining that tag, the downstream reporting becomes a query, not a project. That shift takes the report from a 15-hour monthly exercise to a 15-minute automated output.
Every step toward a complete revenue intelligence ROI report is a step toward budget decisions 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, without the monthly manual assembly.
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.
