Google Sheets 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 Google Sheets version.
Choose your industry
Retail Online Store DashboardGoogle Sheets · $29E-commerce Online Store DashboardGoogle Sheets · $29SaaS Online Store DashboardGoogle Sheets · $29Restaurant Online Store DashboardGoogle Sheets · $29Café & Bakery Online Store DashboardGoogle Sheets · $29Hotel Online Store DashboardGoogle Sheets · $29Real Estate Online Store DashboardGoogle Sheets · $29Construction Online Store DashboardGoogle Sheets · $29Manufacturing Online Store DashboardGoogle Sheets · $29Logistics Online Store DashboardGoogle Sheets · $29Clinic Online Store DashboardGoogle Sheets · $29Hospital Online Store DashboardGoogle Sheets · $29Dental Practice Online Store DashboardGoogle Sheets · $29Pharmacy Online Store DashboardGoogle Sheets · $29Gym & Fitness Online Store DashboardGoogle Sheets · $29Salon & Spa Online Store DashboardGoogle Sheets · $29Coaching Institute Online Store DashboardGoogle Sheets · $29School Online Store DashboardGoogle Sheets · $29University Online Store DashboardGoogle Sheets · $29Marketing Agency Online Store DashboardGoogle Sheets · $29Consulting Online Store DashboardGoogle Sheets · $29Law Firm Online Store DashboardGoogle Sheets · $29Accounting Firm Online Store DashboardGoogle Sheets · $29Insurance Online Store DashboardGoogle Sheets · $29Banking Online Store DashboardGoogle Sheets · $29Fintech Online Store DashboardGoogle Sheets · $29Automotive Online Store DashboardGoogle Sheets · $29Car Dealership Online Store DashboardGoogle Sheets · $29Agriculture Online Store DashboardGoogle Sheets · $29Food Processing Online Store DashboardGoogle Sheets · $29FMCG Distribution Online Store DashboardGoogle Sheets · $29Wholesale Online Store DashboardGoogle Sheets · $29Kirana Store Online Store DashboardGoogle Sheets · $29Fashion & Apparel Online Store DashboardGoogle Sheets · $29Jewellery Online Store DashboardGoogle Sheets · $29Electronics Store Online Store DashboardGoogle Sheets · $29Furniture Online Store DashboardGoogle Sheets · $29Pharma Online Store DashboardGoogle Sheets · $29Telecom Online Store DashboardGoogle Sheets · $29Solar & Energy Online Store DashboardGoogle Sheets · $29Non-profit Online Store DashboardGoogle Sheets · $29Events Online Store DashboardGoogle Sheets · $29Travel Agency Online Store DashboardGoogle Sheets · $29Media & Publishing Online Store DashboardGoogle Sheets · $29Gaming Online Store DashboardGoogle Sheets · $29Creator Business Online Store DashboardGoogle Sheets · $29Freelancer Online Store DashboardGoogle Sheets · $29Startup Online Store DashboardGoogle Sheets · $29IT Services Online Store DashboardGoogle Sheets · $29Security Services Online Store DashboardGoogle Sheets · $29Cleaning Services Online Store DashboardGoogle Sheets · $29Printing & Packaging Online Store DashboardGoogle Sheets · $29Pet Care Online Store DashboardGoogle Sheets · $29
KPIs in every online Store dashboard
| KPI | What it tells you | Formula |
|---|---|---|
| Revenue | Total value of online orders. | SUM of order value after discounts |
| Orders | Number of orders placed. | COUNT of orders |
| Avg order value | Average amount spent per order. | Revenue ÷ Orders |
| Conversion rate | Share of store sessions that ended in an order. | Orders ÷ Sessions |
| Cart abandonment | Share of carts created but not checked out. | 1 − (Orders ÷ Carts created) |
| Return rate | Share of orders returned. | Returned orders ÷ Orders |
| Repeat customers | Share of customers who ordered more than once. | Customers with 2+ orders ÷ All customers |
| ROAS | Revenue earned for every 1 spent on ads. | Ad-attributed revenue ÷ Ad spend |