Free: the GTM BlueprintThe stack by funding stage, the CRM data model written down, and a 90-day plan you can run on Monday.Get the blueprint
RevOpsXL
GTM Diagnostic Ask about the audit
Free resource · field guide

The RevOps & Sales Ops Cheat Sheet

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.

Have us build it for you
ReportsKPIs by business typeThe operating rhythm
On this page ▾

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

Seven reports that cannot lie to you

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.”

From the phantom pipeline: a B2B manufacturer whose HubSpot showed a full pipeline, built from conversations that were never really meetings.

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.

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.

Pipeline coverage vs target

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.

Stage conversion

Where do deals actually die?

Watch forFind the single worst step. That is where a play changes the number, not a pep talk.

Forecast vs actual

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.

Sales cycle by segment

How long does a deal really take?

Watch forBlended averages hide two populations. Median by segment beats a single mean every time.

Speed to lead

How fast do we touch a new lead?

Watch forAnything measured in days is a leak. For inbound, minutes decide who gets the meeting.

Pipeline created vs closed

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

The wrong KPI is worse than none

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.”

A 400-person engineering firm with two CRMs and a leadership team that refused to open either, until we found the one number they would all agree on.

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

Reports only work if someone looks

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.”

From the meeting that files itself: every call carried the qualification, and none of it reached the CRM.

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.

Weekly

Pipeline review

Keep the board honest, deal by deal.

In the room
Reps, sales lead, ops
The one output
Every open deal has an owner, a next step and a date, or it moves back a stage.
Weekly

Lead routing & SLA check

Make sure nothing sits unassigned or past its SLA.

In the room
Ops
The one output
Routing rules corrected, every SLA breach from the week surfaced and owned.
Weekly / monthly

Forecast call

Commit a number the whole company can plan on.

In the room
Sales lead, ops, finance
The one output
Commit, best-case and pipeline, with the change since last week explained.
As needed

Deal desk

Pressure-test large or non-standard deals before they go out.

In the room
Rep, sales lead, ops
The one output
Pricing, terms and a close plan agreed, so nothing bespoke ships by accident.
Monthly

Win / loss review

Learn why deals actually close or die.

In the room
Ops, sales, marketing
The one output
One repeatable pattern to fix or double down on, assigned to a name.
Monthly

CRM hygiene review

Keep the data trustworthy enough to run on.

In the room
Ops
The one output
Duplicates merged, stale deals closed or revived, required fields filled.
Quarterly

Business review (QBR)

Step back from the week to the quarter.

In the room
Leadership, ops
The one output
What to double down on, what to stop, and the two or three bets for next quarter.
Annual

Territory & quota planning

Point effort at the right targets.

In the room
Leadership, ops, finance
The one output
Fair, covered territories and quotas the team actually believes in.

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.

Want this built into your CRM, not just bookmarked?

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

Fractional RevOps, in the field notes