Skip to content

Sales dashboards

Sales dashboard examples

Four sales dashboards: pipeline, sales performance, sales KPIs and retail sales by store. Open any of them to see it in full, then use it as a template for your own data.

Sales Performance dashboard: Deal Amount, Weighted Amount, Days To Close and Win probability (by value) tiles.
Sales KPI Scorecard dashboard: Win probability (by value), Days To Close, Deal Amount and Weighted Amount tiles.
Sales Pipeline dashboard: Deal Amount, Weighted Amount, Win probability (by value) and Days To Close tiles.

Three of the four examples. All figures are sample data.

Track deals in a CRM?Pick where your data is. Each opens a free template that builds a dashboard like these.

The examples

Four sales dashboard examples and templates

Click a board to see all of it. Click Use template to start your own copy in Mammoth. All figures are sample data.

  1. Sales Pipeline dashboard: Deal Amount, Weighted Amount, Win probability (by value) and Days To Close tiles.
    Sample data

    Sales pipeline dashboard

    Is the pipeline worth what the total says?

    • Deal amount
    • Weighted amount
    • Win probability (by value)
    • Days to close
    Use template
  2. Sales Performance dashboard: Deal Amount, Weighted Amount, Days To Close and Win probability (by value) tiles.
    Sample data

    Sales performance dashboard

    What closed, who closed it, and which way is it trending?

    • Deal amount
    • Weighted amount
    • Days to close
    • Win probability (by value)
    Use template
  3. Sales KPI Scorecard dashboard: Win probability (by value), Days To Close, Deal Amount and Weighted Amount tiles.
    Sample data

    Sales KPI dashboard

    Are we closing bigger deals, or just closing slower?

    • Win probability (by value)
    • Days to close
    • Deal amount
    • Weighted amount
    Use template
  4. Store Comparison & Like-for-Like dashboard: Net Sales, Lfl Growth, Conversion rate and Basket size tiles.
    Sample data

    Retail sales dashboard

    Which stores are selling more, not counting new stores?

    • Net sales
    • Lfl growth
    • Conversion rate
    • Basket size
    Use template
  5. Your data

    Want this on your own numbers?

    Pick where your data is. Mammoth turns it into a dashboard like these.

Definition

What a sales dashboard is

A sales dashboard is one screen that shows the state of the pipeline and what is likely to close. It is also called a sales analytics, sales metrics or sales KPI dashboard.

  • Healthier, not just bigger

    Deal size, time to close and win rate together.

  • One board per meeting

    The pipeline review and the Monday meeting need different views.

  • Agreed definitions

    One rule for what counts as closed.

The metrics

The metrics a sales dashboard is built from

Ten numbers cover most sales dashboards. Open each one to see the data it needs. A metric is only as good as the field behind it, and that is where most go wrong.

  • Pipeline coverage

    Is there enough open pipeline to hit target, at our normal win rate?

    What the data needs

    Open deal value by stage, the target for the period, and your past win rate.

  • Weighted pipeline

    What are open deals worth once the odds are applied?

    What the data needs

    Deal amount plus a probability for each stage. Using the CRM's default probabilities instead of your own win rates makes the total look better than it is.

  • Win rate

    What share of the deals that reached a decision were won?

    What the data needs

    Won and lost deals over the same period, with one definition of closed. Deals that went quiet and were never marked lost make the rate look better than it is.

  • Average deal size

    Are we closing bigger or smaller than we were?

    What the data needs

    Won deal amounts, deal count and close dates, so the average is per period, not for all time.

  • Sales cycle length

    How long does a deal take from created to closed?

    What the data needs

    A created date and a close date on won deals. Use the median, not the average, because one twelve-month deal skews the average.

  • Quota attainment by rep

    Who is on track, and is the team carried by two people?

    What the data needs

    Won deals by rep against each rep's own target. A team total cannot answer this.

  • Stalled deals

    Which open deals have stopped moving?

    What the data needs

    The date each deal entered its current stage, and a time limit per stage. Last-modified dates do not work: adding a note to a dead deal resets them.

  • Stage conversion rate

    Where do deals drop out?

    What the data needs

    The stage history of each deal, not just its current stage. If the CRM overwrites the stage, the history is lost every time a deal moves.

  • Sales velocity

    How much revenue is the pipeline producing per day?

    What the data needs

    Open deal count, win rate, average deal size and cycle length, all from the same period and the same definition of closed. Mixing definitions makes the number move for no reason.

  • Like-for-like sales

    Is a store selling more, or just bigger?

    What the data needs

    Sales by store for this year and last, with an opening date for each store, so stores that were not open for the full period are left out. Otherwise growth is mostly new stores.

Reports and decks

The same numbers as a report and a deck

Sales teams rebuild the written review and the QBR deck by hand every quarter. Both are built here from the same sample data as the dashboards above.

How to build one

How to build your own sales dashboard

From one of the examples above to a live dashboard on your own data.

  1. 1

    Pick a template

    Start from any of the four boards above.

  2. 2

    Add your data

    Upload a spreadsheet, or connect one of 100+ tested connectors.

  3. 3

    Clean it once

    Fix and combine your data once. Mammoth repeats those steps for you.

  4. 4

    Set it to refresh

    The dashboard updates on a schedule and flags data that fails a check.

  5. 5

    Share the link

    Public, password-protected or sign-in only, on every plan.

Start with a template

14-day Pro trial · No credit card

FAQ

Sales dashboard questions

Last reviewed against the template catalogue.

What belongs on a sales dashboard?
Whatever the meeting it serves needs, and nothing else. Open pipeline and its weighted value for the pipeline review. Closed revenue by rep and region for the Monday meeting. Deal size, time to close and forecast confidence for the quarterly review. Like-for-like sales by store for a retailer's weekly trading meeting. The four above are split that way.
What are the three main types of sales dashboards?
Operational, strategic and analytical. An operational dashboard is about this week: open pipeline, stalled deals and who to call today, like the pipeline dashboard above. A strategic one is the short list leadership looks at, like the sales KPI dashboard. An analytical one helps you work out why a number moved, like the sales performance dashboard.
How do I build a sales dashboard?
Start from the meeting it will serve, usually the weekly pipeline review. Then follow five steps.
  1. Connect the CRM, and the finance system too if closed revenue has to match the books.
  2. Agree the definitions once: what counts as closed, which stages count as pipeline and how deals are weighted.
  3. Build the view that meeting needs: weighted against raw pipeline for a pipeline review, closed revenue by rep and region for the Monday meeting.
  4. Add the problems below: deals that have stopped moving, reps behind target, regions slipping.
  5. Set a refresh schedule and share the link with the team, so nobody walks in with last week's export.
Can it read straight from our CRM?
Yes. Salesforce and HubSpot are among the 100+ tested connectors, and Pipedrive connects through its REST API. A dashboard can also combine CRM data with finance or product data.
How current can the numbers be?
It depends on your plan, not the dashboard. A pipeline board is worth refreshing often, because a stalled deal you hear about tomorrow is one you hear about too late. Closed revenue is fine refreshed overnight. See plans and refresh rates
Do the reps need licences to look at it?
No. Viewers are unlimited and free on every Mammoth plan, including the free one. One person can build a dashboard and share it with the whole sales team at no extra cost.
Do I need sales dashboard software, or will a spreadsheet do?
A spreadsheet is fine until exporting becomes the job. The sign is how often someone rebuilds the same view by hand, and how out of date it is by the time anyone reads it. Once the data changes on a schedule and the readers are not the person exporting it, that weekly rebuild is a cost. Any tool that reads the source on a schedule and shares a link fixes it, whether that is Mammoth or something else.

Build the sales dashboard you actually need.

Start from one of these templates or your own spreadsheet. Share it with as many people as you like, free.

  • ✓ 14-day Pro trial
  • ✓ No credit card
  • ✓ Viewers always free