Sales Dashboard Templates
Ready-made sales dashboards that shows how much you are selling, which deals are closing and whether the team will hit target. Choose your platform, then your industry.
Choose your platform
Excel
Works offline, opens on any office computer and keeps every formula visible, so you can audit and change it.
Google Sheets
Lives in the cloud, so your whole team sees the same live numbers and you can share it with one link.
Power BI
Handles large data, refreshes from many sources and lets people drill from a yearly total down to a single week.
Looker Studio
Is free, connects straight to Google Sheets, GA4, Google Ads and BigQuery, and shares as a live web link.
The 8 KPIs every sales dashboard should track
| KPI | What it tells you | Formula |
|---|---|---|
| Revenue | Total value of sales booked in the period. | SUM of invoice or order value |
| Deals won | Number of deals or orders closed as won. | COUNT of deals with stage = Won |
| Win rate | Share of closed deals that you won. | Deals won ÷ (Deals won + Deals lost) |
| Avg deal size | Average value of a won deal. | Revenue ÷ Deals won |
| Pipeline value | Value of all open deals that could still close. | SUM of open deal value (optionally × probability) |
| Sales cycle | Average days from first contact to a won deal. | AVERAGE of (Close date − Created date) |
| Quota attainment | How much of the sales target has been achieved. | Revenue ÷ Target |
| New customers | Customers who bought for the first time in the period. | COUNT of customers with first order in period |
Sales dashboards by industry
Questions
What is a sales dashboard?
A sales dashboard is a single page that shows how much you are selling, which deals are closing and whether the team will hit target. It pulls the key sales KPIs, such as revenue, deals won, win rate and avg deal size, into charts and tables that update when your data changes.
Which tool is best for a sales dashboard?
Excel suits offline work and small teams. Google Sheets is best for sharing and live collaboration. Power BI handles large data and drill-down. Looker Studio is free and great with Google data. Every Kpiloom sales dashboard comes in all four.
Which KPIs should a sales dashboard track?
Start with revenue, deals won, win rate, avg deal size, pipeline value, sales cycle, quota attainment and new customers. The table on this page explains each one and how it is calculated.