Sales KPI Dashboard Example

Sales Performance Dashboard

The board approves the plan in November: double new bookings in two years by doubling the sales team. Twelve account executives become twenty-four. By summer the CRM has never looked healthier, with more opportunities, more quotes and a pipeline report that runs to four pages. Then the win rate starts to slide, a little each month, and nobody is quite sure why.

The US Bureau of Labor Statistics counts 1,571,400 wholesale and manufacturing sales representatives in 2025, at a median pay of $76,460, and projects about 123,400 openings a year with little or no change in total employment to 2035. With total employment flat, a growing team is fishing in the same pool of experienced sellers as everyone else.

And new reps need their manager's time. Salesforce's State of Sales report, published in February 2026, surveyed 4,050 sales professionals in August and September 2025. The average seller spent 40% of their time selling. Among Gen Z reps, 46% said they rarely get feedback on their sales conversations, and they named lack of manager time as the biggest obstacle to their training.

The organization here is fictional: a US maker of LED lighting retrofits that sells to warehouses, factories and school districts through a team of account executives. All 24 months of data are modeled for illustration. Only one target below, the win rate, has a published benchmark behind it. The rest are starting points to replace with your own history.

What is a Sales KPI Dashboard?

Overview

A sales KPI dashboard shows how many deals the team is working, how many it wins and at what price, and whether there are enough productive reps to hit next quarter's number as well as this one's.

It starts with the pipeline: qualified opportunities created, and pipeline coverage against the next three months' quota.

Then conversion and price. Quote-to-close rate covers priced proposals; sales win rate covers every decided opportunity, including the ones that never got a quote. Sales cycle length, average discount off list and average deal size show how long each win took, what it was worth and whether it was bought with price.

Then the result: new bookings from signed contracts, and sales forecast accuracy, the gap between the month's commit and what was signed, which finance plans cash around.

Last, capacity. Quota-carrying reps is the selling headcount. Bookings per rep, quota attainment and reps at or above quota show how productive it is, and rep ramp time how long a hire takes to carry a full number.

Who benefits from this dashboard?

1. VP of Sales: Bookings per rep and ramp time answer the question every hiring plan rests on: what does one more account executive actually add, and how soon?
2. Frontline sales managers: Win rate, quote-to-close rate and discount by rep show who's winning on value and who's winning on price, in time to sit in on their next negotiation.
3. Sales operations: They own the stage definitions behind coverage and win rate. When coverage rises and win rate falls in the same quarter, they go looking for opportunities that should've been closed out.
4. CFO: Forecast accuracy decides how far finance can trust the sales number when it plans cash. Average discount and deal size explain the gap between bookings and the margin finance expected.
5. Account executives: Attainment against their own ramped quota tells a rep where they stand this month without waiting for a commission statement.

Measure discount against the list price in your price book, not against the first quote the customer saw. A rep who opens high and comes down can report a 4% discount on a deal that closed 15% under list.

Dashboard Example Overview

The company sells LED retrofit projects with an average contract of about $40,000, through account executives who each own a territory. In October 2024 it had 12 of them, booking $1,096,500 a month. It reports monthly against 14 KPIs:

• Qualified Opportunities Created: Opportunities opened in the month with a named buyer, a site survey booked and a decision date.
• Pipeline Coverage: Open qualified pipeline with a close date in the next 90 days, divided by quota for the same 90 days. It shows whether there's enough in play, not whether it's real.
• Quote-to-Close Rate: Quotes that became signed contracts, divided by quotes resolved in the month, won or lost. It falls when reps send priced proposals before they've found a budget and a decision-maker.
• Win Rate: Closed-won opportunities divided by all opportunities closed in the month, won or lost. Deals that went quiet are closed as lost 30 days past their close date, so they count.
• Sales Cycle Length: Average days from opportunity created to closed-won. Lower is better.
• Average Discount off List: List price less contract price, divided by list price, averaged across closed-won deals. Lower is better.
• Average Deal Size: New bookings divided by closed-won deals. It falls when reps chase small sites or give away price to close.
• New Bookings: Contract value signed in the month, from countersigned contracts, not CRM stage changes.
• Forecast Accuracy: One minus the gap between the VP's first-day commit to finance and the bookings signed, as a share of bookings. Misses in either direction count.
• Quota-Carrying Reps: Account executives with a quota at month end, ramping hires included, team leads excluded.
• Bookings per Rep: New bookings divided by quota-carrying reps. Hiring pulls it down for months before it pushes bookings up.
• Quota Attainment: New bookings divided by the sum of every rep's quota for the month. New hires carry a ramped quota: nothing in month one, rising 20 points a month to full quota in month six.
• Reps at or Above Quota: Reps who booked at least 100% of their own quota for the month, divided by quota-carrying reps. Team attainment can hit 100% on three heroes; this one can't.
• Rep Ramp Time: Average months from start date to the first month at 100% of full quota, for reps who reached it in the last 12 months. Lower is better.

In November 2024 the board set the target: $2.2 million of bookings a month by September 2026, roughly double. The plan was 24 reps by July 2025, hired in three waves of four.

The pipeline did its part. Qualified opportunities created went from 99 in October 2024 to 239 in October 2025. Coverage climbed from 3.4x to 4.6x by July 2025.

Conversion told a different story. Win rate fell from 28.1% in October 2024 to 19.1% in November 2025, and quote-to-close rate from 50.9% to 27.0%. Over the same months average discount crept from 7.6% to 14.9%, average deal size dropped from $40,611 to $33,823, and the sales cycle stretched from 74 days to 93. New reps quoted everything, discounted to get a yes, and chased smaller sites they could close inside their ramp window.

Capacity was the real strain. By July 2025 all 24 reps were in seat, and bookings per rep had fallen from $91,375 to $50,250. Team attainment was 69.0%, and only 20.8% of reps hit their own quota. The two sales managers each had a dozen reps, half of them new, and spent their time building the forecast instead of sitting in on calls. The forecast got worse anyway: accuracy slid from 93.3% to 75.0% by November 2025, as each commit leaned on deals that slipped. Ramp time went from 5.2 months to 7.6 by December 2025, and two of the new reps left that autumn without ever reaching full quota.

December 2025 looked like a breakthrough: $1,808,700 booked, a record, and well above the commit. But it came at a 15.3% average discount, the deepest of the two years, as customers spent year-end budgets on the best price they'd been offered.

So in January 2026 leadership decided what to give up. Hiring stopped at 22. Two of the strongest reps came off quota in February to become team leads, which cost the team its most reliable bookings and dropped quota-carrying reps to 20. Any discount over 12% now needed the VP's sign-off. Sales operations re-dated every open deal to the buyer's real decision date, and coverage fell from 4.1x to 2.7x in a month. January attainment was 69.4%, nearly as bad as the previous July. And the $2.2 million target for September was quietly dropped.

The quality numbers answered first. Discount fell to 11.4% in February and 10.2% by September 2026. Win rate rose every month, to 25.4%. Average deal size was back to $39,857 and the cycle to 79 days. Quote-to-close rate recovered to 46.9%, and forecast accuracy to 92.1%. With fewer reps, bookings per rep climbed to $96,725 in May 2026, above where it started, and team attainment passed 100% for the first time since December 2024. Two hires in June 2026 refilled the team leads' seats.

September 2026 closed at $2,112,400: 1.93 times October 2024, and $87,600 short of the original target. 59.1% of reps were at or above quota, 13 of 22.

Ramp time is the number that wouldn't budge. It peaked at 8.1 months in February 2026 and was still 7.6 in September, against a 6-month target. The team leads came too late to speed up the 2025 hires, and the June 2026 hires won't count until they reach full quota. Win rate didn't get back to 28% either, and quote-to-close rate is still four points below where it began. The company's rule for its next round of hiring is that no manager takes on a new rep while they already have eight.

List of Sales KPIs

Only sales win rate has a published cross-industry median behind its target. Every target marked (starting point) is this example's own, so swap in figures from a year of your team's history.

Why Sales Dashboards Matter

Most of these numbers can be bought with another one. Coverage goes up if reps open opportunities too early, and win rate goes down. Win rate goes up if reps discount harder, and deal size and margin go down. Bookings go up if you hire, and bookings per rep and ramp time go the wrong way for the best part of a year.

In the example, a pipeline report and a bookings report in separate tabs both looked fine through most of 2025: record coverage, steady growth. It took win rate, discount and bookings per rep on the same screen to show the growth was costing price and productivity faster than it added revenue.

For a VP of Sales, the useful habit is to never read a volume KPI without its pair. Coverage with win rate. Bookings with discount. Headcount with bookings per rep and ramp time. When a pair moves in opposite directions, that's the conversation for the week. Our marketing dashboard example covers the lead flow that feeds the top of this funnel, and the SaaS dashboard example picks up what happens to revenue once a contract renews.

Before the next hiring plan goes to the board, check ramp time. At 7.6 months, a rep who starts in January doesn't carry a full quota until late summer, and the plan has to pay for that gap in salary and in the manager time it takes away from everyone else.