Kpiloom

Google Sheets Sales Dashboard Templates

A sales dashboard shows how much you are selling, which deals are closing and whether the team will hit target. Pick your industry below to see a live preview of the Google Sheets version.

Choose your industry

KPIs in every sales dashboard

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