E-commerce sales dashboard template for E-commerce
A e-commerce sales dashboard tailored for a online store. 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 biggest recoverable revenue leak in online retail
normalizes sales against traffic swings
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_datereturnedskudiscount_code
Benchmark
Typical e-commerce conversion sits at 2-3%; average return rates run 15-30% for apparel.
What to look for
For a e-commerce e-commerce sales view, the metrics that move decisions are revenue and units by product and average order value. Typical e-commerce conversion sits at 2-3%; average return rates run 15-30% for apparel.
FAQ
At minimum: order_id, product, quantity, order_value, order_date, returned, sku, discount_code. 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).
Typical e-commerce conversion sits at 2-3%; average return rates run 15-30% for apparel.
Paste a few rows of CSV (with a header row). Runs entirely in your browser — nothing is uploaded.