Pipeline by stage
How much is in play, and is the shape healthy?
Watch forA fat top with a pinched middle means you qualify too late. A bulge in one stage is where deals go to die.
The RevOps and sales-ops cheat sheet: the reports to build, the KPIs that matter for your business model, and the meetings that keep pipeline honest. A cheat sheet you can print, wrapped in the stories that show why each part earns its place. Built from the same playbook we run inside client CRMs.
Most sales operations problems get diagnosed as a data problem when the real trouble is attention. The numbers exist somewhere; nobody agrees which ones matter, so nobody looks, and the forecast becomes a wish. When we walk into a CRM, we instrument a handful of reports that cannot lie to you, the two or three KPIs that fit how you sell, and the meetings that make anyone look at either.
It is a cheat sheet, so print it and pin it up. It doubles as a field guide, because every section below is a lesson somebody learned the expensive way in a real portal. The charts are illustrative shapes rather than client data, but the stories all happened.
01 The must-have CRM reports
We were once brought in to audit the HubSpot portal of a maker of specialised agricultural machinery in EMEA. Long cycles, technical buyers, a short list of accounts that mattered more than all the rest put together, which is exactly the kind of business where the forecast is what everyone upstairs plans the year around. On paper the pipeline was healthy. It was not. Deals were being opened off conversations that had never really been meetings, and the one number the team was measured on, meetings booked, rewarded precisely that.
“The CRM said the deals were real. Fireflies said otherwise.”
The tell was an old pattern: everything commits just before quarter-end, and then, somehow, the lead disappears. Seven reports catch that pattern early, and together they answer almost every question a revenue team asks: how much is in play, whether it is enough, where it leaks, and whether you can trust the number at all. The shape each one draws over time tells you more than the total at the bottom.
How much is in play, and is the shape healthy?
Watch forA fat top with a pinched middle means you qualify too late. A bulge in one stage is where deals go to die.
Do we have enough pipeline to hit the number?
Watch forCoverage under the line early in the quarter is the warning. A common rule of thumb is three to four times the gap, but your own win rate sets the real multiple.
Where do deals actually die?
Watch forFind the single worst step. That is where a play changes the number, not a pep talk.
Can we trust the number we commit?
Watch forA forecast that is optimistic by the same margin every month is a bias you can correct, not bad luck.
How long does a deal really take?
Watch forBlended averages hide two populations. Median by segment beats a single mean every time.
How fast do we touch a new lead?
Watch forAnything measured in days is a leak. For inbound, minutes decide who gets the meeting.
Is the top of the funnel refilling?
Watch forA quarter carried entirely by deals that already existed is borrowed time. Created pipeline leads, closed lags.
One honourable mention: a stalled-and-aging view of every deal with no next step or a close date already in the past. It is the graveyard report, and it is usually the fastest cleanup you will ever run. And a warning from another teardown, a CRM with 722 properties, 203 of them never once filled in: a report is worthless if two teams cannot agree what its fields mean. Fix the definitions before you build the dashboard. More on the trust problem in why your forecast is always wrong.
02 KPIs by business type
A wrong KPI is worse than no KPI, because people optimise for it. We saw the extreme version at a global engineering firm of about four hundred people: two CRMs, enrichment tools, data-mining tools, automations, AI agents, and a leadership team that would not open any of it, because no two of them agreed on what a deal or a contact even represented. When the objects mean nothing, the whole system is just expensive furniture.
“They owned every tool. They used none of them.”
The instinct in the room was to buy a seventh tool. They needed fewer tools and one number everyone would stand behind. So before you copy any list below, be honest about how you sell, because the metric that runs a self-serve product would wreck a bespoke-services team. Pick the model that carries most of your revenue and instrument those few well. Choose a model to see its short list.
Pipeline coverage
Open pipeline against the target for the period. Tells you if the quarter is fundable before it is over.
Win rate
Won over all closed. Trend it by segment and source, not as one blended figure.
Average deal size (ACV)
The typical contract value. Rising size usually means longer cycles, so read it next to cycle length.
Sales cycle length
Median days from created to closed, by segment. The planning input everyone forgets.
Stage conversion
The step-by-step drop-off. Your map of where to intervene.
Forecast accuracy
Committed versus landed. The number that earns leadership's trust, or loses it.
Activation rate
Share of signups that reach the first real value moment. The gate everything else sits behind.
PQL to paid
Product-qualified leads that convert to paying. Your equivalent of a win rate.
Time to value
How long until a new user gets the outcome they came for. Shorter compounds into retention.
Free to paid conversion
Trial or free users that upgrade. Small percentage moves swing revenue hard at volume.
Net revenue retention
Expansion minus churn on the existing base. Above one hundred percent means you grow without new logos.
Expansion rate
Revenue added inside existing accounts. Often cheaper than net-new and easy to under-instrument.
Speed to lead
Minutes from inbound to first human touch. The single biggest lever at this tempo.
Activity to opportunity
Touches it takes to create one real opportunity. Your efficiency ratio.
Conversion per rep
Leads to closed, per rep. Surfaces coaching gaps a team average hides.
Deals per rep per month
Throughput. The volume engine you plan capacity around.
Cycle time
Days from first touch to close. Short by design, so drift shows up fast.
New MRR added
Recurring revenue booked in the period. The heartbeat metric.
Proposal win rate
Proposals sent that convert. Low rates usually mean qualifying too late, not pricing.
Average project value
Typical engagement size. Watch the mix of one-off versus retainer.
Utilization
Billable time against capacity. The margin metric hiding inside delivery.
Sales cycle
Days from scoping to signature. Long, relationship-led, and easy to misforecast.
Repeat and referral rate
Revenue from existing and referred clients. The cheapest pipeline you have.
Pipeline coverage
Weighted pipeline against the target. Even bespoke work needs a coverage view.
And know who you are selling to before you measure how well you sell to them. In one classification we ran, 392 of 708 contacts could not be qualified at all: no title or company, and nothing to say what they might buy. You could not even call them bad leads, since there was nothing there to judge. A win rate calculated over a list like that is arithmetic performed on fog. Related: the metrics that actually change behaviour.
03 Rituals & meetings
A report nobody reads on a schedule turns into decoration, and a KPI without a name against it is just trivia; the rhythm of looking is what makes either one matter. We built a system for one client where a sales call turns into structured CRM properties ninety seconds after it ends, precisely because the alternative was the usual one: the qualification lived in a transcript nobody opened and in a rep’s head, and the pipeline was assembled from whatever survived the commute home.
“A rep’s memory is not a database. The pipeline was built from whatever survived the drive home.”
Automation handles the capture, but it does not decide anything. The deciding happens in a small set of recurring meetings, each with a fixed cadence and a single output, so the week has a rhythm instead of a scramble. These are the ones worth defending on the calendar.
Keep the board honest, deal by deal.
Make sure nothing sits unassigned or past its SLA.
Commit a number the whole company can plan on.
Pressure-test large or non-standard deals before they go out.
Learn why deals actually close or die.
Keep the data trustworthy enough to run on.
Step back from the week to the quarter.
Point effort at the right targets.
The point is to run fewer meetings, each with an owner and an output, the same way every time, so a bad month reads as information rather than an emergency. That steadiness is most of what we mean by the RevOps operating cadence, and it is the difference between a BDR team that produces pipeline and one that just produces motion, which is a blueprint of its own.
From cheat sheet to system
We build these reports, wire the KPIs to your model and set the operating rhythm, inside HubSpot or Salesforce. Send us a few lines and we will tell you what to fix first, in writing.
Read more