Sales Performance Dashboard Mockup Template

The Sales Performance dashboard template is a one-page layout for sales leaders and sales operations analysts, built to decide whether the team is on track against quota and which reps, regions or stages need attention. It shows bookings versus quota, win rate, pipeline coverage, a rep leaderboard, bookings by region and monthly bookings against quota.

Sales Performance dashboard template mockup with header and filters, kpi row, rep and region row, funnel and monthly trend row

Click the mockup to open it full size

About this template

Sales

A single-page view of how the sales org is tracking against target: headline revenue and win-rate KPIs up top, a trend line for bookings, and a rep- or region-level breakdown below. It's the layout most teams reach for when they need one screen for the weekly pipeline review.

Metrics this dashboard tracks

  • Revenue vs. target
  • Win rate
  • Pipeline value & coverage
  • Average deal size
  • Bookings trend
  • Performance by rep / region

What's on the Sales Performance dashboard?

Section What it shows Why it's here
Header and filters Title card, three dropdown filters The report title ("Weekly Pipeline Review"), the subtitle "Bookings, win rate and coverage vs quota", a data last updated timestamp, and filters for reporting period (last 12 weeks), region and sales segment. Lets one page serve every region and segment, so the reader confirms the period and data freshness before trusting any number.
KPI row Five KPI cards with a progress bar, a sparkline, mini columns and comparison bars Bookings vs quota (92.4%, with a bar at 92% of target), win rate (24.8%, with a sparkline), pipeline coverage (3.4x against a 3.0x target), average deal size ($48.5K, with mini columns) and sales cycle (62 days against 68 last quarter, shown as two bars). Answers whether the team is on track before any chart is read, and each card carries its own comparison, so the reader sees which of the five is off plan.
Rep and region row Table with shaded cells, horizontal bar chart A rep leaderboard with bookings, quota attainment (shaded), win rate and pipeline for four reps plus a total, beside a bar chart of bookings by region (West, East, Central, South, International). Shows who and where the headline number comes from, so a manager can see which rep to coach and which region is carrying or lagging the total.
Funnel and monthly trend row Funnel chart, combo chart (columns and a line) A pipeline funnel from leads to closed won with counts, share of leads and step-to-step conversion, beside monthly bookings as columns against a quota line from January to December. Pairs where deals are lost along the funnel with whether monthly results are keeping up with quota, so the reader links a shortfall to a stage and a month.

What each metric means

Bookings vs quota

  • Definition: Bookings in the period as a percentage of the quota for the same period. What counts as a booking (signed contract, annual contract value, first-year value) is defined by each company, so state which one you use.
  • Formula: Bookings vs quota = bookings / quota x 100
  • Why it matters: It is the main measure of whether the team is delivering its number.
  • Why a KPI card with progress bar: The bar against 100% shows how far short or over target the team sits, which the percentage alone does not.

Win rate

  • Definition: The share of closed opportunities that were won in the period. Some companies count by number of deals and others by value, so label which one the card uses.
  • Formula: Win rate = won deals / (won deals + lost deals)
  • Why it matters: It shows how much pipeline is needed to hit quota and whether deal quality is changing.
  • Why a KPI card with sparkline: The sparkline under the number shows the direction of a rate that moves slowly, without needing a separate chart.

Pipeline coverage

  • Definition: How many times the open pipeline covers the quota still to be closed. Teams set their own target ratio, and about 3x is a common rule of thumb, but the right ratio depends on win rate.
  • Formula: Pipeline coverage = open pipeline / remaining quota
  • Why it matters: It shows early whether there is enough pipeline to reach quota, while there is still time to add more.
  • Why a KPI card with progress bar: The bar against the 3.0x target shows how much headroom coverage has, which the number alone does not.

Average deal size

  • Definition: The average value of won deals in the period. Companies differ on whether they use contract value, annual value or first-year value.
  • Formula: Average deal size = total value of won deals / number of won deals
  • Why it matters: It explains whether bookings are changing because of more deals or bigger deals.
  • Why a KPI card with mini column chart: Small columns for each period show the recent pattern next to the current figure, with the latest period highlighted.

Sales cycle

  • Definition: The average number of days from deal creation to close for won deals. Some teams start the clock at first meeting or qualification instead of creation.
  • Formula: Sales cycle = average of (close date - created date) for won deals
  • Why it matters: It shows whether deals started now can still close inside the quarter.
  • Why a KPI card with comparison bars: Two bars for the previous and current period make the change in days visible at a glance.

Rep leaderboard and quota attainment

  • Definition: Each rep's bookings, quota attainment, win rate and open pipeline in the period. Quota attainment is a rep's bookings as a percentage of that rep's own quota.
  • Formula: Quota attainment = rep bookings / rep quota x 100
  • Why it matters: It shows how performance is spread across the team, which one total cannot.
  • Why a table: A table keeps exact values for several measures per rep in one row, and shading on the attainment column draws the eye to the strongest and weakest results.

Bookings by region

  • Definition: Bookings in the period split by sales region, in the same currency and period as the headline cards.
  • Formula: Region bookings = sum of bookings where region = the region
  • Why it matters: It shows which regions carry the total and which are small or behind.
  • Why a bar chart: Horizontal bars sorted by value make five labelled categories easy to rank and read, with the amount at the end of each bar.

Pipeline funnel by stage

  • Definition: The number of leads or opportunities that reach each stage from leads to closed won, with the percentage that moves from one stage to the next. Stage names are specific to each company.
  • Formula: Stage conversion = records reaching the next stage / records that entered the stage
  • Why it matters: It shows where deals are lost, so the team can see which stage needs the most attention.
  • Why a funnel chart: Narrowing bars show the drop between stages, and the percentages beside them mark the weakest step.

Monthly bookings vs quota

  • Definition: Bookings for each month shown against that month's quota, so the reader can see which months met the number.
  • Formula: Monthly gap = monthly bookings - monthly quota
  • Why it matters: It shows whether a shortfall is one bad month or a steady trend.
  • Why a combo chart: Columns show the amount booked each month and a line shows the quota on the same scale, so the gap is visible month by month.

Data you need to build this

  • CRM (Salesforce, HubSpot or similar), opportunity or deal object Deal ID, Owner (rep), Amount, Stage, Status (open, won, lost), Created date, Close date, Region, Segment
  • CRM stage history or field history Deal ID, Stage, Entered date, Exited date
  • Lead or opportunity records for the funnel Record ID, Stage reached, Date reached, Owner, Region
  • Quota or planning sheet Rep, Region, Month, Quota, Target coverage ratio

Why it's laid out this way

  • The five KPI cards come first, directly under the filters, so the question of whether the team is on plan is answered before any chart is read. Each card carries its own comparison: a bar to quota or target, a sparkline, mini columns or previous-period bars.
  • The middle row splits the total by people and place: the leaderboard table ranks reps with shaded attainment, and the bar chart ranks regions. Both use the same bookings period as the cards, so a manager can go from a weak total to the rep or region behind it.
  • The bottom row explains why. The funnel shows where deals drop out, and the combo chart shows monthly bookings against the quota line, so the reader ties a shortfall to a stage and to a month.

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, regions and amounts in the leaderboard and region chart with your own, and add or remove rows to match your team.
  2. 2. Rename the funnel stages to match the stages in your CRM, and set the quota line in the monthly chart and the coverage target in the card to your own values.
  3. 3. Change the filter labels and the reporting period to the periods, regions and segments you report on.
  4. 4. Edit the card comparisons (target, previous quarter) and decide which one each KPI shows, 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 KPIs should a sales performance dashboard include?
A sales performance dashboard should include bookings versus quota, win rate, pipeline coverage, average deal size and sales cycle. Add a rep leaderboard with quota attainment, bookings by region, a pipeline funnel and a monthly bookings-versus-quota trend to explain what drives those numbers. Each KPI should show a comparison, such as a target or the previous period.
How do you calculate bookings vs quota?
Bookings versus quota is bookings in the period divided by quota for the same period, shown as a percentage. Illustrative example: $462K of bookings against a $500K quota is 92.4%. Companies define bookings differently (total contract value, annual value or first-year value), so state the definition on the page and apply it the same way to quota.
What data do I need to build a sales performance dashboard?
You need deal-level data from your CRM: amount, stage, status, owner, region, segment, created date and close date. Add quota by rep, region and month. The funnel needs the date each lead or opportunity reached each stage, and coverage needs open pipeline. A stage history table is needed for conversion rates between stages.
Who should use a sales performance dashboard and how often should it be reviewed?
Sales leaders, regional managers and sales operations analysts use it to track results against quota, and managers use the leaderboard for coaching. Review it weekly in the sales meeting. Bookings versus quota and the leaderboard suit weekly review, while win rate, deal size and sales cycle move slowly and are often read monthly or quarterly.
What decisions does a sales performance dashboard help you make?
It helps you decide whether the team is on track to hit quota, which reps need coaching, and where to move resources. Bookings versus quota and the monthly bookings chart show whether to adjust the plan. The rep leaderboard with quota attainment points to who to coach or recognise. Bookings by region show where to invest, and the funnel shows which stage loses the most opportunities.
What are common mistakes when building a sales performance dashboard?
A common mistake is defining bookings one way in the KPI card and another way in the quota comparison, so the percentage cannot be trusted. Showing win rate on the leaderboard without the deal count behind it misleads, because a small count swings the rate. Leaving the period unlabelled mixes weekly and monthly figures. Too many cards also bury the key number, bookings against quota.
How do I customize this sales performance 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 rep names and amounts with your own mock data, swap the regions, and set the quota line on the monthly chart. Try asking the chat: "Change the regions to Americas, EMEA and APAC." Export to PNG, PDF, PPTX or JSON, then build the real report in Power BI, Tableau or similar.
Can I build this sales performance dashboard in Power BI or Tableau?
Yes. In Power BI, use card visuals for the five KPIs, a table with conditional formatting for the leaderboard, a bar chart for regions, the funnel visual for stages and a line and clustered column chart for bookings against quota, with slicers for filters. Tableau covers the same with text tiles, a text table, bars, a funnel built from bars and a dual-axis chart. The progress bars and mini charts inside the cards need custom work.

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 Performance template

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

Use this template
Sales Performance Use this template