Proving marketing's contribution to a $40M pipeline
Vantage's marketing team was funding a growing share of the deal pipeline but had no defensible way to prove it. Meridian's revenue reporting layer changed the budget conversation entirely.
- Client
- Vantage Capital Partners
- Duration
- 3 months
- Team
- 4 Meridian specialists, 2 Vantage finance & marketing stakeholders
- Role
- Revenue reporting architecture, board dashboard design
$40M
Marketing-sourced pipeline proven
+22%
Budget approved next cycle
3 days → 2 hrs
Board reporting prep time
12 → 0
Metrics disputed by finance
Overview
Vantage Capital Partners' marketing team had scaled its budget 3x over two years on the strength of anecdotal wins, but every quarterly board meeting turned into a dispute between marketing and finance over whose numbers were correct. Meridian was engaged to build a reporting layer both teams would actually trust.
The Problem
Marketing counted a deal as 'sourced' the moment any tracked touchpoint appeared in a contact's history. Finance, reconciling against NetSuite booked revenue, routinely found deals marketing claimed credit for that had, in finance's view, originated from an existing account relationship with no real marketing influence.
Research
We conducted a joint audit with finance and marketing across 40 closed deals from the prior two quarters, tracing each one's actual touchpoint history against booking records to establish, empirically, where the two teams' definitions of 'marketing-sourced' actually diverged.
Discovery
The audit revealed the dispute wasn't really about attribution methodology — it was about deal recency and account tenure. Finance wanted any account with a prior closed deal excluded from 'new pipeline sourced' claims. This became a formal, board-approved rule embedded directly into the reporting logic.
Competitive Analysis
Vantage's existing BI tool (a generic dashboarding product layered over Salesforce exports) had no concept of marketing-specific attribution rules and required a data analyst to manually rebuild the board deck each quarter — a single point of failure that made the report itself part of the trust problem.
Goals
Success criteria: a board-ready revenue dashboard finance would sign off on without dispute, board deck preparation time under 4 hours per quarter, and a documented, jointly-owned definition of 'marketing-sourced pipeline' that would not need re-litigating each quarter.
Wireframes
Wireframes were reviewed jointly by Vantage's CMO and CFO before any development began — an unusual but deliberate step to ensure finance had design input, not just final sign-off, on a tool meant to end an interdepartmental dispute.
User Flow
The board dashboard opens on a single reconciled number — total marketing-influenced pipeline, net of the account-tenure exclusion rule — with a drill-down path into methodology documentation available inline, so any board member questioning a number could self-serve the explanation.
Visual Design
Design intentionally avoided marketing's usual vibrant chart palette in favor of a restrained, financial-report aesthetic — muted blues and grays — reinforcing to the board that this was a finance-grade number, not a marketing self-assessment.
Design System
A dedicated 'boardroom' theme was added to Meridian's reporting module, now offered as a standard configuration option to any customer needing finance-facing rather than marketing-facing dashboard styling.
Development
The account-tenure exclusion rule was implemented as a configurable, auditable filter in the attribution pipeline — every excluded deal remains queryable with a stated reason, so the rule's effect is fully transparent rather than a silent adjustment.
Architecture
Nightly reconciliation jobs join Salesforce opportunity data with NetSuite booked-revenue records, applying the jointly-approved attribution rules before the board dashboard's single source-of-truth table is refreshed each morning.
Performance
The reconciliation pipeline processes the full multi-year deal history in under 4 minutes nightly, with the board dashboard itself loading in under a second thanks to pre-computed quarterly rollups.
Accessibility
Given board members occasionally review the dashboard on shared conference-room displays, all typography and chart contrast ratios were tested at a distance and against ambient lighting conditions, not just against WCAG's on-screen minimums.
SEO
Not applicable — an internal, authenticated finance and board reporting tool.
Testing
The reconciled numbers were run in parallel with finance's manual quarterly close process for one full quarter before the board relied on the dashboard exclusively, giving both teams a real audit trail to compare against.
Deployment
The dashboard launched quietly one full quarter ahead of its first live board presentation, giving the CMO and CFO time to jointly rehearse the new reporting narrative before presenting it externally.
Results
The board accepted $40M in marketing-sourced pipeline without dispute for the first time in company history. Marketing's budget was subsequently approved for a 22% increase the following cycle. Board deck preparation time dropped from roughly three days of analyst work to under two hours.
Lessons Learned
Involving finance in the design phase — not just as a final approver — was the single decision that made the resulting numbers trusted rather than merely accurate. Attribution disputes are as often organizational as they are technical.