Kpiloom

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.

The 8 KPIs every sales dashboard should track

KPIWhat it tells youFormula
RevenueTotal value of sales booked in the period.SUM of invoice or order value
Deals wonNumber of deals or orders closed as won.COUNT of deals with stage = Won
Win rateShare of closed deals that you won.Deals won ÷ (Deals won + Deals lost)
Avg deal sizeAverage value of a won deal.Revenue ÷ Deals won
Pipeline valueValue of all open deals that could still close.SUM of open deal value (optionally × probability)
Sales cycleAverage days from first contact to a won deal.AVERAGE of (Close date − Created date)
Quota attainmentHow much of the sales target has been achieved.Revenue ÷ Target
New customersCustomers who bought for the first time in the period.COUNT of customers with first order in period

Sales dashboards by industry

IndustryExcelGoogle SheetsPower BILooker Studio
RetailExcelGoogle SheetsPower BILooker Studio
E-commerceExcelGoogle SheetsPower BILooker Studio
SaaSExcelGoogle SheetsPower BILooker Studio
RestaurantExcelGoogle SheetsPower BILooker Studio
Café & BakeryExcelGoogle SheetsPower BILooker Studio
HotelExcelGoogle SheetsPower BILooker Studio
Real EstateExcelGoogle SheetsPower BILooker Studio
ConstructionExcelGoogle SheetsPower BILooker Studio
ManufacturingExcelGoogle SheetsPower BILooker Studio
LogisticsExcelGoogle SheetsPower BILooker Studio
ClinicExcelGoogle SheetsPower BILooker Studio
HospitalExcelGoogle SheetsPower BILooker Studio
Dental PracticeExcelGoogle SheetsPower BILooker Studio
PharmacyExcelGoogle SheetsPower BILooker Studio
Gym & FitnessExcelGoogle SheetsPower BILooker Studio
Salon & SpaExcelGoogle SheetsPower BILooker Studio
Coaching InstituteExcelGoogle SheetsPower BILooker Studio
SchoolExcelGoogle SheetsPower BILooker Studio
UniversityExcelGoogle SheetsPower BILooker Studio
Marketing AgencyExcelGoogle SheetsPower BILooker Studio
ConsultingExcelGoogle SheetsPower BILooker Studio
Law FirmExcelGoogle SheetsPower BILooker Studio
Accounting FirmExcelGoogle SheetsPower BILooker Studio
InsuranceExcelGoogle SheetsPower BILooker Studio
BankingExcelGoogle SheetsPower BILooker Studio
FintechExcelGoogle SheetsPower BILooker Studio
AutomotiveExcelGoogle SheetsPower BILooker Studio
Car DealershipExcelGoogle SheetsPower BILooker Studio
AgricultureExcelGoogle SheetsPower BILooker Studio
Food ProcessingExcelGoogle SheetsPower BILooker Studio
FMCG DistributionExcelGoogle SheetsPower BILooker Studio
WholesaleExcelGoogle SheetsPower BILooker Studio
Kirana StoreExcelGoogle SheetsPower BILooker Studio
Fashion & ApparelExcelGoogle SheetsPower BILooker Studio
JewelleryExcelGoogle SheetsPower BILooker Studio
Electronics StoreExcelGoogle SheetsPower BILooker Studio
FurnitureExcelGoogle SheetsPower BILooker Studio
PharmaExcelGoogle SheetsPower BILooker Studio
TelecomExcelGoogle SheetsPower BILooker Studio
Solar & EnergyExcelGoogle SheetsPower BILooker Studio
Non-profitExcelGoogle SheetsPower BILooker Studio
EventsExcelGoogle SheetsPower BILooker Studio
Travel AgencyExcelGoogle SheetsPower BILooker Studio
Media & PublishingExcelGoogle SheetsPower BILooker Studio
GamingExcelGoogle SheetsPower BILooker Studio
Creator BusinessExcelGoogle SheetsPower BILooker Studio
FreelancerExcelGoogle SheetsPower BILooker Studio
StartupExcelGoogle SheetsPower BILooker Studio
IT ServicesExcelGoogle SheetsPower BILooker Studio
Security ServicesExcelGoogle SheetsPower BILooker Studio
Cleaning ServicesExcelGoogle SheetsPower BILooker Studio
Printing & PackagingExcelGoogle SheetsPower BILooker Studio
Pet CareExcelGoogle SheetsPower BILooker Studio

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.