E-commerce sales dashboard template for Restaurant
A e-commerce sales dashboard tailored for a restaurant floor. Which products and cohorts drive margin, and where are refunds eating it? Upload your own CSV or Google Sheet and it charts revenue and units by product, average order value, refund / return rate automatically — free, no signup.
KPIs this dashboard tracks
finds the 20% of SKUs driving 80% of sales
the lever that scales revenue without more traffic
silent margin killer that top-line revenue hides
the difference between a store and a business
the core efficiency metric for a dining room
the line between a profitable and a failing kitchen
Charts it builds
- Revenue by product — bar of
revenuebyproduct - Orders over time — line of
ordersbyorder_date - AOV distribution — histogram of
countbyorder_value
Columns your data needs
Map your spreadsheet to these (messy headers are matched automatically):
order_idproductquantityorder_valueorder_datereturnedmenu_itemcovers
Benchmark
Well-run restaurants hold food cost near 28-35% of revenue and prime cost under 60%.
What to look for
For a restaurant e-commerce sales view, the metrics that move decisions are revenue and units by product and average order value. Well-run restaurants hold food cost near 28-35% of revenue and prime cost under 60%.
FAQ
At minimum: order_id, product, quantity, order_value, order_date, returned, menu_item, covers. Dashboard AI maps messy real-world headers to these automatically.
Revenue and units by product (finds the 20% of SKUs driving 80% of sales); Average order value (the lever that scales revenue without more traffic); Refund / return rate (silent margin killer that top-line revenue hides); Repeat purchase rate (the difference between a store and a business).
Well-run restaurants hold food cost near 28-35% of revenue and prime cost under 60%.
Paste a few rows of CSV (with a header row). Runs entirely in your browser — nothing is uploaded.