Kpiloom

Excel Online Store Dashboard Templates

A online Store dashboard brings orders, conversion, returns and ad performance of your online store together. Pick your industry below to see a live preview of the Excel version.

Choose your industry

KPIs in every online Store dashboard

KPIWhat it tells youFormula
RevenueTotal value of online orders.SUM of order value after discounts
OrdersNumber of orders placed.COUNT of orders
Avg order valueAverage amount spent per order.Revenue ÷ Orders
Conversion rateShare of store sessions that ended in an order.Orders ÷ Sessions
Cart abandonmentShare of carts created but not checked out.1 − (Orders ÷ Carts created)
Return rateShare of orders returned.Returned orders ÷ Orders
Repeat customersShare of customers who ordered more than once.Customers with 2+ orders ÷ All customers
ROASRevenue earned for every 1 spent on ads.Ad-attributed revenue ÷ Ad spend