INSIDEA
Playbook · INSIDEA

The RevOps Reporting and Attribution Playbook

Disputed reports are a data-model and definitions problem, not a dashboard problem. This playbook shows revenue leaders how to build one source of truth, choose an attribution model on purpose, and report on pipeline and revenue instead of vanity activity.

FormatLong-form playbookRead12 minutesForRevenue leaders across sales, marketing, and CS
Chapter 01

Why reports get disputed

When two people bring two different numbers for the same thing to the same meeting, you do not have a dashboard problem. You have a definitions problem wearing a dashboard costume.

The scene repeats in almost every revenue org. Marketing says it generated 400 leads and a healthy slice of pipeline. Sales says half of those were junk and the pipeline was already in flight. Finance quietly runs its own spreadsheet because it trusts neither. Everyone is looking at a screen, everyone is technically correct, and nobody agrees. The instinct is to blame the tooling and go shopping for a better BI layer. That instinct is wrong, and it is expensive.

Disputed reports almost always trace back to three root causes, and none of them are visualization. The first is different definitions: marketing counts a lead at form fill, sales counts it when a rep accepts it, and finance counts it when the deal closes. The second is different sources: one number comes from the CRM, another from the ad platform, another from a spreadsheet that lives on someone's desktop. The third, and the quietest killer, is no owner: when nobody is accountable for the canonical definition of a metric, every team is free to invent its own, and they do.

A dashboard built on top of these three problems does not resolve them. It laminates them. A prettier chart of a contested number is still a contested number, now with better fonts. The work of trustworthy reporting happens upstream of any chart, in the data model and the shared vocabulary. Get that right and the dashboards become boring, which is exactly what you want. Boring dashboards are the ones people stop arguing about and start acting on.

!

Definition drift

"Lead" means form fill to marketing, accepted-by-a-rep to sales, and closed-won to finance. Same word, three numbers.

!

Multiple sources of truth

The CRM, the ad platform, and a personal spreadsheet each hold a version of the number, and none of them reconcile.

!

No metric owner

Nobody is accountable for the canonical definition, so every team defines it for themselves, in their own favor.

!

Timing mismatch

One team reports on when the deal was created, another on when it closed, so the same quarter looks different depending on who is talking.

The four ways reporting quietly breaks
Chapter 02

One source of truth before any dashboard

You cannot report your way out of a broken data model. Before a single chart gets built, you need one place where the numbers live and one agreed language for what they mean.

A source of truth is not a dashboard and it is not a BI tool. It is the underlying system, almost always your CRM, where every revenue-relevant object is recorded once, consistently, with agreed definitions. In a HubSpot-centered stack that means contacts, deals, and companies carry the fields, lifecycle stages, and pipeline stages that every team has signed off on. The dashboard is just a window onto that system. If the window shows conflicting things, the problem is behind the glass.

The foundational move is a shared data dictionary. For every metric that shows up in a leadership conversation, write down its exact definition, the object and property it is calculated from, the stage or timestamp that triggers it, and the single person accountable for it. What counts as a Marketing Qualified Lead. What moment a deal is considered sourced. Which timestamp defines pipeline created. This document is unglamorous and it is the highest-leverage artifact in your entire reporting stack. When a number is questioned later, you do not argue; you point at the dictionary.

The second move is lifecycle and pipeline hygiene. Lifecycle stages must be defined so that a contact can only be in one stage at a time and everyone knows what moves it forward. Deal stages must have exit criteria a rep cannot fudge. This is core RevOps plumbing, and it is where most reporting projects should actually start. Our RevOps Blueprint goes deeper on architecting the underlying model. The rule to hold onto: definitions and data model first, dashboards second. Every hour spent on the model saves ten hours of disputed meetings later.

1
Agree the definitions
Write a data dictionary: every leadership metric, its source property, its trigger event, and its accountable owner. One definition per metric, no exceptions.
2
Fix the model
Clean lifecycle stages so a contact sits in exactly one, and deal stages with exit criteria a rep cannot game. This is the source of truth.
3
Then build the view
Only now build dashboards. They are windows onto the model, not the model itself. If a number is questioned, point at the dictionary, not the chart.
Chapter 03

Attribution models, an honest look

There is no correct attribution model. There is only the model you chose on purpose for a specific question, and every model has a blind spot you need to say out loud.

Attribution is the practice of assigning credit for a conversion across the touchpoints that preceded it. The mistake leaders make is treating this as a search for the true model, as if one exists and the rest are wrong. They are all wrong in different, useful ways. A model is a lens. First-touch answers "what brings people into our world." Last-touch answers "what closes them." Multi-touch models try to honor the whole journey. You pick the lens that fits the question you are actually asking, and you accept that it distorts everything else.

The honest way to hold this: single-touch models are opinionated and simple, multi-touch models are fairer and more complex, and none of them are accounting-grade truth. What matters is that you can name why you chose a model and what it hides. A team that runs U-shaped attribution and can articulate that it underweights the messy middle of the funnel is in far better shape than a team running a data-driven model it cannot explain to its own CFO.

Every model is a lens, not the truth
ModelWhat it creditsBest forBlind spot
First-touch100% to the first interactionUnderstanding what creates awareness and fills the top of the funnelIgnores everything that actually moved the deal to close
Last-touch100% to the final interaction before conversionUnderstanding what closes deals already in motionErases the awareness and nurture that made the close possible
LinearEqual credit to every touchpointA fair, simple first pass when you want to honor the whole journeyTreats a trivial email open as equal to a demo; flattens real impact
U-shaped40% first, 40% lead-creation touch, 20% to the middleTeams that care most about acquisition and conversion momentsUndervalues mid-funnel nurture that builds conviction
W-shapedCredit weighted to first touch, lead creation, and opportunity creationB2B journeys where the deal-creation moment matters (needs a deal-stage interaction)Complex to read; still discounts the long tail of touches
Time-decayMore credit to touches closer to the conversionLong, considered sales cycles where recent momentum mattersSystematically underweights the top-of-funnel that started it all
Data-drivenCredit assigned algorithmically from patterns in your dataMature teams with high data volume and the trust to accept a model they cannot hand-traceA black box; hard to defend in a room and needs clean, high-volume data to be meaningful

Notice the pattern. Single-touch models are honest about being opinionated. Multi-touch models are fairer but harder to explain, and a metric a leader cannot explain is a metric a leader will not trust. Sophistication that erodes trust is a bad trade. Start simpler than you think you need to.

Chapter 04

Single-touch, multi-touch, and why attribution is directional

Attribution is a compass, not a ledger. The moment you treat it as accounting, you have set up a fight you cannot win.

Single-touch attribution assigns all the credit to one moment, first or last. It is easy to compute, easy to explain, and easy to game, but it answers a narrow question cleanly. Multi-touch attribution spreads credit across the journey. It is fairer to reality, where a B2B deal might involve a webinar, three blog posts, a sales email, and a demo before anyone signs, but it is heavier to build and harder to defend line by line. The choice between them is not about which is more accurate in the abstract. It is about which question you are answering and how much explanatory burden your organization can carry.

Here is the load-bearing idea for the whole discipline: attribution is directional, not exact. It tells you which channels and assets are probably pulling weight so you can shift budget with more confidence than a coin flip. It does not tell you the precise dollar a given blog post earned, and it never will, because the counterfactual is unknowable. You cannot run the same buyer twice, once with the webinar and once without. Anyone who sells you attribution as revenue accounting is selling you false precision.

This is also why the sourced-versus-influenced distinction matters and why it stops being a fight once you frame it right. Both can be true at the same time. A contact found you through organic search months ago, which is marketing influence, and a rep's outbound call is what created the opportunity, which is sales sourcing. These are not competing claims on the same credit. They are two different lenses on the same journey. Report both, side by side, using the same attribution model for each, and the argument dissolves. The goal is not to win the credit war. It is to end it.

Treat attribution as a compass for where to spend next, not a scoreboard for who deserves the win. The teams that argue least about credit are the ones that agreed, in advance, that attribution is directional.
Chapter 05

The metrics leaders actually read

Leaders read money and momentum. They do not read activity. If your report leads with opens and clicks, it will not survive contact with a CFO.

There is a hard line between metrics that describe the business and metrics that describe your effort. Impressions, opens, clicks, form fills, and MQL counts describe effort. They can be useful diagnostics for the team doing the work, but they are not what a revenue leader steers by, because they can all go up while revenue goes nowhere. The metrics that earn a seat at the leadership table are the ones tied to pipeline and money: how much qualified pipeline you created, whether you have enough of it to hit the number, how fast it moves, and what it costs to acquire a customer against how long it takes to pay that cost back.

Pipeline created is the cleanest shared metric between marketing and sales, because it is denominated in deal value, not lead count. Pipeline coverage is the ratio of open pipeline to your target; it tells a leader whether the quarter is even mathematically reachable before it is too late to act. Velocity is how quickly deals move from stage to stage, and a slowdown is an early warning the activity metrics will never show you. Win rate by source exposes which channels bring deals that actually close versus deals that merely look busy. CAC and payback ground the whole conversation in unit economics. And the sourced-versus-influenced pair, reported side by side, shows marketing's real contribution without picking a fight with sales.

The discipline is to demote vanity metrics to the diagnostic layer where the practitioners live and promote pipeline and revenue metrics to the executive layer where decisions get made. A lead number belongs in a marketing operations review. Pipeline coverage belongs in the leadership meeting. If your growth marketing reporting still leads with volume, that is the first thing to rewire.

Pipeline created

Qualified pipeline value generated in the period, denominated in dollars not lead count. The cleanest shared number between marketing and sales.

should rise

Pipeline coverage

Open pipeline as a multiple of target. Tells a leader whether the quarter is mathematically reachable while there is still time to act.

should rise

Sales cycle length

How long deals take to move from created to closed. A creeping increase is an early warning that activity metrics will never surface.

should fall
The metrics that earn a seat at the leadership table
Chapter 06

Dashboards by audience, leading versus lagging

One dashboard for everyone is a dashboard for no one. Build for the reader, and separate the metrics that predict from the metrics that record.

The most common dashboard failure after bad data is a single sprawling board that tries to serve the CEO, the demand-gen lead, and the sales manager at once. Each of them needs a different altitude. The executive view should be small and ruthless: pipeline coverage, revenue against target, CAC and payback, win rate. A leader should read it in under a minute and know whether to worry. The marketing view goes a layer down into channel and campaign performance, pipeline created by source, and the leading indicators that predict next quarter's pipeline. The sales view is about the current pipeline: stage-by-stage health, velocity, win rate by rep and by source, and where deals are stalling.

Cutting across all three is the distinction between leading and lagging indicators. Lagging indicators record what already happened: closed revenue, win rate, CAC. They are true and they are late. Leading indicators predict what is coming: pipeline created, coverage, velocity, top-of-funnel demand. A dashboard built only on lagging indicators is a rear-view mirror; by the time the number moves, the quarter is decided. The executive board needs both, with leading indicators given the prominence they deserve, because those are the only numbers you can still do something about.

A practical test for any dashboard: can the intended reader look at it and know what decision to make? If the answer is no, it is a data display, not a decision tool. Trim every metric that does not change a decision for that specific audience. The goal is not comprehensiveness. It is that the right person sees the right number and knows what to do next.

Leading indicators (you can still act)

  • Pipeline created this period
  • Pipeline coverage against target
  • Deal velocity and stage progression
  • Top-of-funnel demand and qualified volume

Lagging indicators (already decided)

  • Closed-won revenue
  • Win rate for the period
  • CAC and payback realized
  • Revenue attributed by source, after the fact
Chapter 07

Doing this in HubSpot

HubSpot gives you a real attribution and reporting engine, but the capability you get, and the honesty of the numbers, depends on your tier and your setup discipline.

Start with the campaigns tool. When you group related assets, ads, emails, landing pages, forms, and CTAs, under a single campaign, HubSpot can aggregate their performance and roll influence up to that campaign. This is the connective tissue that lets attribution reporting see a coordinated effort rather than a scatter of disconnected assets. If your assets are not organized into campaigns, your attribution reports will be thin no matter what model you pick.

On attribution models and tiers, be precise, because this is where teams over-promise. Marketing Hub Professional gives you first-touch and last-touch source attribution. The full multi-touch suite, linear, U-shaped, W-shaped, time-decay, and full-path, lives in Marketing Hub Enterprise, and revenue attribution that ties touchpoints to closed-won deals is an Enterprise capability that also depends on you using deals properly. The W-shaped and full-path models require a deal-stage interaction to compute, so your pipeline hygiene from earlier is not optional; it is the precondition for the reports working at all. Full-path, for context, distributes credit across the first touch, lead creation, and opportunity creation milestones, with a slice reserved for the touches in between.

For the reports themselves, the custom report builder and the attribution report builder let you analyze a primary object with related objects and datasets, and let you build contact-create, deal-create, and revenue attribution reports as the top, middle, and bottom of your funnel. The practical build order: get campaigns organized, confirm your tier supports the model you want, keep deal stages clean so revenue attribution can compute, then build audience-specific dashboards on top. As an Elite HubSpot Partner, the pattern INSIDEA sees most often is teams reaching for Enterprise-grade multi-touch reporting before their lifecycle and deal data can support it, then blaming the tool when the numbers look wrong. Fix the data model first and HubSpot's reporting becomes powerful.

What HubSpot gives you, by tier
CapabilityMarketing Hub ProfessionalMarketing Hub Enterprise
Source attributionFirst-touch and last-touchFirst-touch and last-touch
Multi-touch modelsNot availableLinear, U-shaped, W-shaped, time-decay, full-path
Revenue attribution to closed dealsNot availableAvailable (requires deals used properly)
Campaigns tool for asset groupingAvailableAvailable
Custom and attribution report builderAvailable (within model limits)Full attribution report builder across datasets
Chapter 08

Where to start

Do not start with the dashboard. Start with the argument you are tired of having, and work backward to the definition that ends it.

Pick the one metric your teams fight about most. Usually it is what counts as a qualified lead, or when a deal is considered sourced. Write its canonical definition, its source property, its trigger, and its owner. That single entry is the seed of your data dictionary, and it will resolve more disputes than any new tool. Then check your lifecycle and deal stages against that definition and clean up whatever contradicts it. This is unglamorous plumbing and it is where trustworthy reporting is actually built.

With one clean definition and a tidy model behind it, choose your attribution model on purpose. If you are early, first-touch and last-touch reported side by side will teach you more than a multi-touch model you cannot explain. Then build one small executive dashboard: pipeline coverage, revenue against target, win rate, and CAC. Four numbers a leader can read in a minute. Resist the urge to add more. You can always add; you rarely subtract. From that foundation you expand deliberately, one audience and one model at a time, always definitions and data before dashboards.

This is patient work, and it compounds. Every disputed number you retire, every definition you pin down, makes the next report faster to trust. If you want a partner who has built this data model and reporting layer inside HubSpot for companies across more than 25 countries, that is exactly the work INSIDEA does. When you are ready to end the whose-number-is-right fights for good, book a strategy call and we will map it with you.

Chapter 09

Questions people ask

Which attribution model should we use?

There is no single correct model; there is the model you choose on purpose for a specific question. First-touch answers what creates awareness, last-touch answers what closes, and multi-touch models like U-shaped or W-shaped try to honor the whole journey. Start simpler than you think you need, and prefer a model you can explain in a leadership meeting over a sophisticated one you cannot defend. Every model has a blind spot; the discipline is naming it out loud.

Is attribution accurate enough to base budget decisions on?

Attribution is directional, not exact. It tells you which channels and assets are probably pulling weight, which is enough to shift budget with more confidence than guessing. It does not tell you the precise dollar a single touchpoint earned, because the counterfactual is unknowable. Treat it as a compass for where to spend next, not as revenue accounting. Anyone promising line-item precision is selling false precision.

Why do marketing and sales report different numbers for the same thing?

Almost always because of three upstream problems: different definitions of the same term, data pulled from different sources that do not reconcile, and no single owner accountable for the canonical definition. A better dashboard does not fix any of these; it just displays the disagreement more attractively. The fix is a shared data dictionary and a clean data model in your CRM, agreed before any chart is built.

What is the difference between sourced and influenced revenue?

Sourced revenue credits the touchpoint that created the opportunity; influenced revenue credits any marketing touch that appeared along the journey. Both can be true for the same deal at once. A contact found you through organic search, which is influence, and a rep's outbound call created the opportunity, which is sourcing. Report both side by side using the same attribution model, and the credit argument between teams dissolves.

Do we need Marketing Hub Enterprise to do attribution in HubSpot?

It depends on how far you want to go. Marketing Hub Professional includes first-touch and last-touch source attribution, which is enough to start. The full multi-touch suite, linear, U-shaped, W-shaped, time-decay, and full-path, plus revenue attribution tied to closed-won deals, requires Marketing Hub Enterprise and depends on using deals properly with clean stages. Confirm your tier before promising a model your subscription cannot compute.

What should we build first, the dashboard or the data model?

The data model, without exception. Start by writing the canonical definition of the one metric your teams argue about most, then clean the lifecycle and deal stages that feed it. Only then build a small executive dashboard of four or five decision-driving metrics. A dashboard built on contested definitions just laminates the dispute. Definitions and data first, dashboards second, every time.

Want this run as a system, not a side project?

INSIDEA builds and operates HubSpot across CRM, RevOps, growth marketing, and AI automation.

Get Started
With Us

Book a demo and discovery call to get a look at:

How INSIDEA works
The subscription plan that best fits your needs
Pricing, onboarding, and anything else
HubSpotSalesforcePipedriveAircallApolloTrustpilot

Book a Call With Us

By clicking next, you agree to receive communications from INSIDEA in accordance with our Privacy Policy.