The marketing team puts together a monthly report. It shows leads generated, cases signed, cost per lead, and a handful of conversion rates. The managing partner nods. The marketing director feels good about the numbers. Then the report reaches finance — and it falls apart.
Not because the data is wrong, necessarily. But because it does not meet the standards that finance teams apply to every other financial report in the organization. The attribution is not verifiable. The time periods are inconsistent. The cost categories are incomplete. And the projections lack methodology.
Here are the four reasons finance teams reject marketing reports at PI firms — and how to fix each one.
Problem 1: Unverifiable Attribution
Marketing reports routinely attribute cases to specific lead sources based on vendor-reported data or self-reported client intake responses. “How did you hear about us?” is not a financial control. Vendor-reported lead counts are not independently verified. And when multiple vendors claim credit for the same case, nobody reconciles the conflict.
Finance teams apply a basic standard to every number in a report: can this be verified against an independent data source? If the answer is “we rely on the vendor's report” or “we ask the client,” the attribution fails the audit test. Self-reported data from parties with a financial interest in the outcome is not verifiable data — it is a claim that requires verification.
Typical Marketing Report
- Source attribution from client self-report at intake
- Vendor-provided lead counts accepted at face value
- No reconciliation when two vendors claim the same case
- Attribution methodology changes without documentation
- No audit trail from lead to signed case to revenue
Finance-Ready Report
- Source attribution from tracked channels (UTM, call tracking, unique phone numbers)
- Vendor claims cross-referenced against CMS lead records
- Formal attribution model (first-touch or last-touch) applied consistently
- Attribution methodology documented and unchanged quarter to quarter
- Full audit trail: lead ID to case number to settlement record
The fix is system-based attribution. Every lead should be tagged with its source through a trackable mechanism — UTM parameters, dedicated phone numbers, unique landing pages, or CRM integration with the vendor's platform. The tag must persist from first contact through case signing and into the settlement record. When finance can trace a specific lead to a specific case to a specific settlement, the attribution is verifiable.
Problem 2: Inconsistent Time Periods
Marketing reports often mix time periods in ways that make the numbers unreliable. January spend is compared to January signed cases — but the cases signed in January came from leads generated in November and December. The spend and the outcome are not from the same cohort.
Worse, some reports compare current-month marketing spend to current-month settlement revenue. This is comparing today's investment to the return on an investment made 12 to 18 months ago. It is like measuring your 2025 stock portfolio returns by looking at dividends from stocks you bought in 2023. The numbers are real, but the comparison is meaningless.
Mismatched Reporting
- January spend compared to January cases (different cohorts)
- Current-month revenue compared to current-month spend
- ROI calculated on a monthly calendar basis
- No distinction between mature and immature cohorts
- Trailing 12-month averages mask seasonal variation
Cohort-Based Reporting
- January spend compared to cases generated by January spend
- Revenue attributed to the cohort that produced it
- ROI calculated per cohort at 6, 12, and 18 months
- Mature cohorts reported separately from active cohorts
- Quarterly cohort analysis shows true performance trends
The fix is cohort-based reporting. Group cases by the month they were acquired (the marketing event) and track their outcomes over time. A “Q1 2025 marketing cohort” includes all cases acquired from Q1 2025 spend. That cohort's ROI is measured when its cases reach settlement — whether that is 6 months or 18 months later. This is the only method that correctly matches spend to return.
Problem 3: Missing Cost Categories
Most marketing reports include vendor fees and ad spend. Very few include the full cost of acquiring and processing a case. The costs that are routinely excluded:
- Intake labor: The salary and benefits of intake coordinators who process marketing-sourced leads. At a firm with 3 intake staff earning $55,000 average, that is $165,000 per year in labor directly attributable to marketing-sourced lead processing.
- Technology costs: Call tracking ($500 to $2,000/month), CRM software ($200 to $800/month per user), form and chat tools ($300 to $1,000/month), and reporting platforms. These are marketing infrastructure costs that should be included in CPC calculations.
- Overhead allocation: Office space for intake staff, phone systems, IT support for marketing tools. Standard overhead allocation applies to marketing just as it does to any other department.
- Vendor management time:The marketing director's time spent managing vendor relationships, reviewing performance, and negotiating contracts. If 60% of the director's time is vendor management, 60% of their compensation should be allocated to marketing acquisition cost.
When these costs are excluded, the reported cost per case is artificially low — sometimes by 25% to 40%. Finance teams recognize this immediately. A marketing report that excludes labor and overhead is not a financial report. It is a vendor spend summary.
| Vendor Spend Only | Fully Loaded | |
|---|---|---|
| Vendor fees + ad spend | $150,000/mo | $150,000/mo |
| Intake labor (allocated) | Not included | $13,750/mo |
| Technology / tools | Not included | $4,200/mo |
| Overhead allocation | Not included | $6,800/mo |
| Vendor mgmt labor | Not included | $5,250/mo |
| Total acquisition cost | $150,000/mo | $180,000/mo |
| Cases signed | 50 | 50 |
| Cost per case | $3,000 | $3,600 |
The fix is straightforward: include all costs. Work with accounting to establish an allocation methodology for shared costs (intake labor, overhead, technology) and apply it consistently month over month. The CPC will be higher — but it will be real. And finance will trust the number.
Problem 4: Forward Projections Without Methodology
Marketing reports frequently include projections: “At current rates, we project $X in revenue from this quarter's cases.” Finance teams immediately ask: what are the assumptions? What is the confidence interval? How does this compare to historical accuracy of previous projections?
The typical answer is silence — or a vague reference to “current trends.” That is not a methodology. That is a guess dressed up as a forecast.
Unsubstantiated Projections
- "We expect $2M in revenue from Q1 cases"
- No stated assumptions or methodology
- No historical accuracy tracking for past projections
- Single-point estimate with no range
- No sensitivity analysis for key variables
Methodology-Based Forecasts
- "Based on our 12-month trailing settlement rate of 78% and average settlement of $22K..."
- Assumptions documented: settlement rate, average value, timeline
- Prior quarter projection accuracy: within 8% of actual
- Range estimate: $1.7M to $2.2M at 80% confidence
- Key sensitivity: 5-point change in settlement rate = $180K variance
The fix has three parts. First, document the methodology — what variables feed the projection, what historical data supports the assumptions, and what the margin of error has been on past projections. Second, provide a range, not a point estimate. Third, track projection accuracy over time. If your Q1 projection was $2M and the actual result was $1.6M, that 20% miss needs to inform your Q2 methodology.
The Common Thread
All four problems share a root cause: marketing reports are built for marketing conversations, not financial ones. They are designed to show activity and progress, not to meet the standards of verifiability, completeness, consistency, and rigor that finance requires.
The solution is not more data. It is better data infrastructure. System-based attribution that creates an audit trail. Cohort-based reporting that correctly matches spend to outcome. Fully-loaded cost accounting that captures the true acquisition cost. And methodology-based projections that can withstand scrutiny.
| Standard | Requirement | |
|---|---|---|
| Verifiable Attribution | System-tracked source tags | Audit trail from lead to settlement |
| Consistent Time Periods | Cohort-based reporting | Mature vs. immature cohort separation |
| Complete Cost Categories | Fully-loaded CPC | Labor, tech, and overhead included |
| Substantiated Projections | Documented methodology | Range estimates with accuracy tracking |
When marketing reports meet finance standards, something important happens: the marketing budget stops being a line item that finance approves reluctantly and starts being a capital allocation that finance evaluates on merit. That shift changes the conversation from “Can we afford this?” to “What is the optimal amount to invest?”
RevenueScale's Case Analytics is built to produce marketing reports that pass finance scrutiny — system-based attribution, cohort-based ROI, fully-loaded costs, and methodology-documented forecasts — so the marketing team and finance team can finally work from the same numbers.
