
Sales pipeline dashboard
Is the pipeline worth what the total says?
- Deal amount
- Weighted amount
- Win probability (by value)
- Days to close
Sales dashboards
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.



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

Is the pipeline worth what the total says?

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

Are we closing bigger deals, or just closing slower?

Which stores are selling more, not counting new stores?
Your data
Want this on your own numbers?
Pick where your data is. Mammoth turns it into a dashboard like these.
Definition
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.
Deal size, time to close and win rate together.
The pipeline review and the Monday meeting need different views.
One rule for what counts as closed.
The metrics
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.
Is there enough open pipeline to hit target, at our normal win rate?
Open deal value by stage, the target for the period, and your past win rate.
What are open deals worth once the odds are applied?
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.
What share of the deals that reached a decision were won?
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.
Are we closing bigger or smaller than we were?
Won deal amounts, deal count and close dates, so the average is per period, not for all time.
How long does a deal take from created to closed?
A created date and a close date on won deals. Use the median, not the average, because one twelve-month deal skews the average.
Who is on track, and is the team carried by two people?
Won deals by rep against each rep's own target. A team total cannot answer this.
Which open deals have stopped moving?
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.
Where do deals drop out?
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.
How much revenue is the pipeline producing per day?
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.
Is a store selling more, or just bigger?
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
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
From one of the examples above to a live dashboard on your own data.
Start from any of the four boards above.
Upload a spreadsheet, or connect one of 100+ tested connectors.
Fix and combine your data once. Mammoth repeats those steps for you.
The dashboard updates on a schedule and flags data that fails a check.
Public, password-protected or sign-in only, on every plan.
14-day Pro trial · No credit card
FAQ
Last reviewed against the template catalogue.
Start from one of these templates or your own spreadsheet. Share it with as many people as you like, free.
More dashboard examples