Sales Rep Leaderboard Dashboard Mockup Template

The Sales Rep Leaderboard template is a one-page layout for VPs of Sales and front-line sales managers, built for the weekly sales meeting and monthly commission review to decide who is ahead of quota and who needs coaching. It shows team bookings, quota attainment, reps at or above quota, average deal size and median win rate.

Sales Rep Leaderboard dashboard template mockup with header and filters, kpi row, attainment row, leaderboard and activity row

Click the mockup to open it full size

About this template

Sales

This sales rep dashboard example ranks every rep on quota attainment for the weekly sales meeting and the monthly commission review, so a VP of Sales or front-line manager can see who is ahead, who is behind and why. Five KPIs (team bookings, quota attainment, reps at or above quota, average deal size, median win rate) sit above a ranked bar chart with a 100% target line, an attainment distribution histogram, a 10-rep leaderboard table with rank change versus last month, and a scatter of weekly activity against bookings. Bars and dots are coloured by tier (100% and up, 70-99%, under 70%), so the red reps stand out before anyone reads a number.

Metrics this dashboard tracks

  • Team bookings
  • Team quota attainment vs. expected pace
  • Reps at or above quota
  • Quota attainment by rep
  • Attainment distribution
  • Leaderboard with rank change
  • Activity vs. bookings

What's on the Sales Rep Leaderboard dashboard?

Section What it shows Why it's here
Header and filters Title bar with three filter chips The title "Sales Rep Leaderboard", the period "Q3 FY26 · Jul 1 - Sep 30 · day 62 of 92", and dropdowns for quarter (Q3 FY26), team (All) and role (AE, SDR). Shows how far into the quarter the numbers are, so every attainment figure is read against the right point in time, and lets one page serve any team or role.
KPI row Five KPI cards Team bookings $4.86M (+9% vs last quarter), team quota attainment 81% (vs 67% expected at day 62), reps at or above quota 9 of 24 (38% of the team), average deal size $41.2K (+$3.1K vs last quarter) and median ramped-rep win rate 27% (closed-won / closed). Answers whether the team is ahead of pace before any rep is named. The 81% against 67% expected tells the reader the team is ahead, while 9 of 24 shows that few reps carry it.
Attainment row Ranked bar chart with target line, column chart Quota attainment for 10 of 24 reps, from Priya Nair at 142% down to Jake Morrison at 38%, with a dashed 100% target line and bars coloured green, amber or red. Beside it, a histogram of all 24 reps by band: under 50% 3, 50-74% 5, 75-99% 7, 100-124% 6 and 125% and up 3. The bars show who is where, and the histogram shows the shape of the whole team, so the reader can tell whether a few reps are far behind or many are just short of quota.
Leaderboard and activity row Table with data bars, scatter chart A ranked table of the same 10 reps with team, bookings, attainment bar and percent, deals won, win rate, activities and rank change versus last month (for example Priya Nair, East, $355K, 142%, 9 won, 34%, 148 activities). Beside it, a scatter of calls and meetings per week against bookings, one labelled dot per rep with a trend line. The table is the agenda for the meeting and the rank arrows show who is climbing or sliding. The scatter shows whether low bookings come with low activity or with the same effort and weaker results, which changes the coaching conversation.

What each metric means

Team bookings

  • Definition: The total value of deals closed-won by the team in the quarter to date. Some companies count bookings at contract signature and others at first invoice, so state which one you use.
  • Formula: Team bookings = sum of amount for closed-won deals in the period
  • Why it matters: It is the revenue result that quota attainment is measured against.
  • Why a KPI card: One large number with a change versus last quarter gives the headline result at a glance.

Team quota attainment

  • Definition: Bookings as a share of the quota assigned for the period. Next to it, the share of the period already elapsed is the expected pace: a team that is 62 of 92 days into the quarter would be expected to be about two thirds of the way to quota if quota is spread evenly.
  • Formula: Quota attainment = bookings / quota; expected pace = days elapsed / days in period
  • Why it matters: Comparing attainment with expected pace shows whether the team is ahead or behind, which attainment alone cannot.
  • Why a KPI card: The percentage and the expected-pace caption sit together, so the gap is read in one look.

Reps at or above quota

  • Definition: The number of reps whose attainment is 100% or more, shown against the total number of reps and as a share of the team.
  • Formula: Reps at or above quota = count of reps with attainment >= 100%
  • Why it matters: It shows how widely the result is shared. A team can be ahead on total bookings while only a minority of reps are at quota.
  • Why a KPI card: A count out of a total with a percentage caption is a single figure that suits a card.

Average deal size

  • Definition: The average amount of a closed-won deal in the period.
  • Formula: Average deal size = bookings / number of closed-won deals
  • Why it matters: Together with win rate it shows whether bookings come from bigger deals or from more deals.
  • Why a KPI card: One figure with a change versus last quarter is enough to see whether deals are getting larger.

Median ramped-rep win rate

  • Definition: The middle win rate across reps who have finished onboarding, based on closed deals. Whether it counts deals or value, and how ramped is defined, is set by each company.
  • Formula: Win rate = closed-won deals / (closed-won + closed-lost deals); take the median across ramped reps
  • Why it matters: The median is less affected by one unusually strong or weak rep than the average, and leaving out new hires avoids blaming ramp time on skill.
  • Why a KPI card: A single percentage with a short caption suits a rate that moves slowly.

Quota attainment by rep

  • Definition: Each rep's bookings divided by that rep's own quota, ranked from highest to lowest and coloured by tier against a 100% target line.
  • Formula: Rep attainment = rep bookings / rep quota
  • Why it matters: Quotas differ by rep, so attainment compares people fairly where raw bookings would not.
  • Why a ranked bar chart: Horizontal bars sorted by value make the ranking and the distance from the 100% line easy to read, and long rep names fit on the axis.

Attainment distribution

  • Definition: The number of reps in each attainment band: under 50%, 50-74%, 75-99%, 100-124% and 125% and up.
  • Formula: Reps in band = count of reps whose attainment falls in the band
  • Why it matters: It shows the spread across the whole team, including reps not listed on the ranked chart.
  • Why a column chart: Columns for ordered bands show the shape of the distribution, which a ranked list of names does not.

Leaderboard rank and rank change

  • Definition: Each rep's position by attainment this quarter, with an arrow showing how many places they moved compared with last month, alongside deals won, win rate and activities.
  • Formula: Rank change = last month's rank - current rank
  • Why it matters: A rep who is climbing and a rep who is sliding need different conversations, even if both sit mid-table.
  • Why a table with data bars: A table keeps exact values, and the bar in the attainment column adds a quick visual ranking without a second chart.

Activity vs bookings

  • Definition: Calls and meetings per week for each rep plotted against that rep's bookings, with a trend line. What counts as an activity is set by each company.
  • Formula: Activity level = (calls + meetings) / weeks in period
  • Why it matters: It shows whether activity goes with revenue. Reps far below the trend line work as much as peers but close less, and reps far below on both axes may need a different conversation.
  • Why a scatter chart: Two measures per rep on two axes show the relationship and the outliers, which a table cannot.

Data you need to build this

  • CRM (Salesforce, HubSpot or similar), opportunity object Deal ID, Owner (rep), Amount, Status (won, lost, open), Close date, Team and role
  • Quota or compensation planning sheet Rep, Fiscal period, Quota, Start date (to flag ramping reps), Team
  • CRM activity log or sales engagement tool (Outreach, Salesloft or similar) Rep, Activity type (call, meeting, demo), Activity date
  • HRIS or sales operations roster Rep, Role (AE, SDR), Team, Hire date, Ramp status

Why it's laid out this way

  • The five KPI cards come first so the reader knows whether the team is ahead of pace before any rep is named. Attainment is paired with the expected pace for the point in the quarter, so 81% is read against 67% and not in isolation.
  • The top row pairs the ranked bars with the distribution histogram: one shows individuals against the 100% target line, the other shows the shape of the whole team. Both use the same colour tiers, so red means the same thing in every visual.
  • The bottom row puts the leaderboard table beside the scatter plot. The table is the list to discuss, and the scatter explains it, by showing whether a rep's result follows their activity level.

Last updated:

More like this

Browse all templates

Sales, finance, HR, SaaS, and more — filter by team or search by metric.

How to use this template

  1. 1. Replace the sample rep names, teams, bookings and attainment values with your own reps, then set the 100% target line and the tier thresholds that colour the bars.
  2. 2. Update the expected-pace caption on the quota attainment card to match the day of your quarter, and change the quarter and team labels in the header filters.
  3. 3. Edit the attainment bands in the distribution chart so their edges match the tiers used in the ranked bar chart.
  4. 4. Relabel the activity axis to the activities your team tracks, such as calls, meetings and demos, then export to PNG, PDF, PPTX or JSON.

Every component is a live element in Mockko — resize it, swap the chart type, edit the mock data, or delete it.

Common questions

What should a sales rep leaderboard dashboard include?
A sales rep leaderboard should include team bookings, team quota attainment against expected pace, reps at or above quota, average deal size and median win rate. Below those, add attainment by rep against a 100% line, an attainment distribution, a ranked table with rank change versus last month, and a view of activity against bookings.
How do you calculate quota attainment?
Quota attainment is bookings divided by quota, for each rep and for the team. Compare it with expected pace, which is days elapsed divided by days in the period. Illustrative example: $240K of bookings against a $250K quota is 96%, and a team 62 days into a 92-day quarter is expected to be around 67% of the way there.
What data do I need to build a sales rep leaderboard?
You need closed-won and closed-lost deals by owner from your CRM, with amount and close date. Add each rep's quota and start date from a planning sheet, calls and meetings from the CRM activity log or a sales engagement tool, and team and role from your sales roster. Quota is the field most often missing, so confirm it first.
Who should use a sales rep leaderboard and how often should it be reviewed?
Sales VPs and front-line managers use it to see who is ahead of quota and where to coach, and reps use it to see where they stand. Weekly review in the sales meeting is common, with a monthly pass for commission review and rank change. How often to review is a company choice, and it can be more frequent near quarter end.
What decisions does a sales rep leaderboard help you make?
It helps decide who to coach, who to recognise and whether the team is on pace. Attainment of 81% against 67% expected shows the team is ahead, while 9 of 24 reps at quota shows a few carry it. The red bars, such as Jake Morrison at 38%, mark coaching priorities, and the scatter shows if effort or results are the problem.
What are common mistakes when building a sales rep leaderboard?
A common mistake is ranking raw bookings when quotas differ, which favours reps with larger territories, so rank on attainment instead. Another is showing attainment without the expected pace for the point in the quarter. Averaging win rate across new hires and veterans blurs the picture, and undefined tier thresholds leave readers guessing what amber means.
How do I customize this sales rep leaderboard template in Mockko?
Open the template in Mockko in your browser, then edit it by dragging on the canvas or asking the AI chat. Replace the sample reps, bookings and quotas with your own mock data, rename the teams, and adjust the tier thresholds. Try asking the chat: "Rename the teams to North, South, Enterprise and Partners." Export to PNG, PDF, PPTX or JSON. Mockko produces a mockup, not a live report, so build the real one in Power BI or Tableau afterwards.
Can I build this sales rep leaderboard in Power BI or Tableau?
Yes. In Power BI, use card visuals for the KPIs, a clustered bar chart for attainment by rep, a column chart for the distribution, a table or matrix with conditional formatting for the leaderboard and a scatter chart for activity against bookings, with slicers for the filters. Tableau offers the same visuals as worksheets. Mockko is for designing the layout first.

About Mockko templates

Every Mockko template is free to open on the free plan: 3 projects and watermarked PNG export. Pro removes the watermark and adds PDF, PPTX, and JSON export. You don't need Power BI or Tableau to use a template; build the real, data-connected report there afterwards.

Start from the Sales Rep Leaderboard template

Open it in Mockko, make it yours, and export it. Free to start.

Use this template
Sales Rep Leaderboard Use this template