Revenue operations
RevOps and reporting. One source of truth, tiered by audience.
The short answer. Reporting is a cadence and a single source, not a stack of dashboards.
I'm Lauren Pearson, and the request I get most often is not "we need better reports." It is "nobody believes the reports we already have." Those are different problems with different fixes. A team with no reporting at all needs dashboards built. A team with reports nobody trusts usually has three or four of them already, built at different times by different people, quietly disagreeing with each other on the same quarter's number.
RevOps reporting is the practice of fixing that at the source: one data model, one set of stage and category definitions, feeding every report, with the differences between a board deck and a team standup being presentation and depth, not different underlying numbers. Our wider RevOps framework guide covers that single data model at the structural level; this piece is specifically about what gets built on top of it and how often it gets looked at.
How it works in practice. Three tiers, one source, different cadences.
Reporting that holds up tends to split into three tiers, each with a different audience, depth and refresh cadence, all pulling from the same underlying pipeline data rather than separate exports.
- Board tier. A small number of headline figures (revenue against plan, pipeline coverage, net new logos or expansion, churn) reviewed monthly or quarterly, with enough historical trend to show direction, not just a single period's snapshot.
- Leadership tier. The operating view a CRO or VP of sales reviews weekly: forecast by category, stage-by-stage pipeline health, and the two or three deals or segments that are moving the number most. Detailed enough to drive a decision in the meeting it is used in, not just to inform one.
- Team tier. The working view reps and managers use daily or before each one-to-one: individual pipeline, activity, and deal-level risk flags. This is the dashboard doing the most hands-on work, and it is covered in more depth in our guide to building a sales manager dashboard.
The tiering matters because a single report trying to serve all three audiences usually serves none of them well. A board-level summary with team-level deal detail buries the headline number; a team-level dashboard padded with board-level commentary slows down the daily check a rep actually needs. Separate tiers, same source data, solves both without triple the maintenance.
The "same source data" part is the piece teams skip under time pressure, and it is the part that matters most. Building three tiers from three separate exports, each pulled and filtered by a different person, reproduces the exact trust problem reporting exists to fix, just with better-looking charts. The three tiers should be three views generated from one pipeline, ideally by one reporting layer or tool, so that a number questioned in the board meeting can be traced back to the same underlying deals a rep sees in their own working view, rather than to a spreadsheet nobody else can open.
What good looks like. One definition, confirmed before it is trusted, not after.
The single biggest determinant of whether a report gets trusted is not its design. It is whether "qualified," "commit" and "closed-won" mean the same thing in every report a reader has ever seen, including the one from eighteen months ago that a VP still half-remembers. A reporting function that changes a stage definition without re-explaining it to everyone who reads the output has, in practice, broken every comparison anyone makes against history, even though the new definition might genuinely be better.
Forecast accuracy is the sharpest, most visible test of whether reporting is actually working, and the industry's own numbers are a useful reality check against overconfidence. Gartner's 2024 research into sales forecasting found only 7% of sales organisations achieve 90% or higher forecast accuracy, and Xactly's 2024 benchmark report found that roughly four in five sales and finance leaders missed at least one quarterly forecast in the prior year. Those figures are a reason to build honest confidence ranges into a forecast report rather than a single over-precise number, not a reason to give up on forecasting rigour altogether; a report that says "likely between X and Y, high confidence on Z deals" survives contact with reality far better than one that states a single number as fact and is wrong by double digits a quarter later.
Good RevOps reporting also makes the data's own limits visible rather than hiding them behind a clean-looking chart. A pipeline coverage number built on stale deals looks identical to one built on genuinely live pipeline until someone checks; flagging data freshness, last activity date, percentage of deals with a dated next step, next to the headline number is a small addition that does a great deal to keep leadership's trust in what they are looking at.
Trust in the underlying CRM data is worth naming directly rather than assuming. Industry research on this is thin and mostly vendor-adjacent, but the figure that recurs, roughly a third of sales professionals saying they trust their CRM data, is low enough that it should change how a reporting function talks about its own numbers. A report that states a single figure with total confidence, built on data a meaningful share of the organisation does not fully trust, is setting itself up to be quietly ignored the first time it is wrong. Naming the confidence level alongside the number, and showing the work behind it, closes that gap faster than insisting the number is right.
A worked scenario. Three decks, three different numbers, one root cause.
A growing B2B team I worked with had a forecast problem that looked, at first, like a sales execution issue: the number presented in the Monday leadership meeting rarely matched the number in the board deck two weeks later, and neither matched what individual reps said in their own one-to-ones. Three different people were building three different exports from the same CRM, each applying a slightly different, undocumented filter, one excluded a product line being sunset, one included a since-closed region, one used a forecast category definition from before a process change six months earlier that nobody had gone back and corrected.
None of the three numbers were fraudulent or careless in isolation; each had made a reasonable judgement call that had simply never been written down or shared. The fix was not a new dashboard tool. It was a one-page definitions document, agreed once by the people building all three reports, naming exactly what counted and what did not, with a named owner for updating it the next time a process changed. The three decks converged within a single reporting cycle once they were pulling from the same, written definition rather than three people's separate memories of what used to be true. This is an illustrative pattern drawn from several engagements, not a single named client result, but the fix, one written definition, one owner, applies regardless of which CRM or reporting tool sits underneath it.
Pitfalls to avoid. Where reporting quietly loses its audience.
Building a new report for every stakeholder request is the most common failure. Each one feels reasonable on its own and the pile becomes unmanageable within a year, with nobody able to say which version is current. The better response to "I need my own view of this" is usually a filter or a saved segment on the existing tiered report, not a fourth export.
Automating the output without automating a sense check is the second. A dashboard that refreshes itself every morning but has nobody glancing at it before the leadership meeting will, sooner or later, present a broken data pull as fact in front of the people making decisions on it. The fix costs five minutes of a named person's time each cycle, not a new tool.
Over-indexing on precision instead of confidence is the third. A forecast report that states "we will close 1.47 million dollars this quarter" sounds more rigorous than one that states a range, but it is usually less honest about what the underlying pipeline actually supports. A report built around ranges and named confidence levels per deal, rather than a single decimal-precise figure, tends to survive a miss with its credibility intact; a single precise number that turns out wrong teaches a leadership team to stop believing the next one, however carefully it was built.
Treating reporting as a one-off build is the third. A reporting structure that was correct a year ago drifts as the business adds a product line, changes territories or restructures a team, and nobody revisits the definitions until a number stops making sense in a meeting. Our RevOps consulting engagements build a quarterly review of the reporting definitions into the operating cadence for exactly this reason, alongside the data quality work covered in our guide to RevOps data management. Where the need is closer to standing up the reporting layer from nothing, that scope sits inside our revenue operations work instead, and our guide to the RevOps metrics worth tracking covers which numbers belong in each tier once the structure above is in place.
Common questions.
What does RevOps own in revenue reporting?
The definitions and the pipeline, not the narrative. RevOps owns what counts as a stage, a qualified lead and a forecast category, and the system that produces the numbers consistently. Sales, marketing and finance leaders still interpret and present those numbers to their own audiences; RevOps' job is making sure they are all reading from the same underlying figures.
How many revenue reports does a RevOps team actually need?
Fewer than most teams think, built on tiers rather than one report per stakeholder. A board-level view, a leadership operating view and a team-level working view, all pulling from the same underlying data model, covers most organisations. Each new one-off report requested outside that structure is usually a sign the existing tier is missing something specific, worth fixing at the source rather than patching with another export.
Why do sales teams build shadow spreadsheets instead of trusting the CRM report?
Because the CRM report has let them down before, usually from a stage definition that drifted, a forecast category nobody re-explained after a process change, or a number that did not match what a VP said in a meeting. The spreadsheet is a symptom of lost trust, not the actual problem, and replacing it only works once the underlying report is demonstrably reliable again.
Should RevOps reporting be fully automated?
The pulling and formatting of numbers should be automated end to end; the sense-check before it reaches a leadership audience should not be. A dashboard that updates itself but nobody reviews for an obviously broken data pull before the Monday leadership meeting has automated the wrong half of the job.
Got three decks that quietly disagree with each other?
Send me the numbers that do not match and I'll help find the one undocumented definition causing it.
Let's talk ↑