Ecommerce Dashboard

B2What it looks like

A preview of the dashboard tab, KPI row and all. The real thing lives in Google Sheets with two years of order-level sample data behind it.

B3What this dashboard does

I built this for a fictional DTC ecommerce brand ("Northwind Home Goods", a made-up kitchenware brand for this demo) that was drowning in manual reporting. It tracks:

• Revenue: daily, monthly, and trailing 12-month trends
• Orders: volume, average order value, channel mix (Shopify, wholesale, Amazon)
• Inventory: turnover by SKU, low-stock flags
• Marketing spend: cost per channel, rough margin impact

It's the kind of dashboard a founder or ops lead pulls up every Monday morning instead of digging through five different exports.

B4How it works

• Google Sheets as the front end. No new tool to learn, everyone already has it open.
• Apps Script backend pulls in raw order/inventory data (in the real version, this hooks into Shopify's API, a wholesale CSV drop, or whatever system the client already uses)
• Conditional formatting flags things that need attention (low inventory, thin margins, revenue dips) in red/yellow/green without anyone having to build a chart
• Sparklines give a 12-month trend at a glance right inside the KPI cells, so you don't need to click into a separate chart to see if things are trending up or down
• Everything recalculates automatically when new data lands. No copy-pasting, no manual pivot table refresh.

B5Why it matters

The brand this is modeled on was spending about 4 hours every week manually pulling data from Shopify, their 3PL, and a marketing spend spreadsheet, then stitching it together into a report for leadership. That's 4 hours of someone's time, every week, on work that has zero strategic value. It's just plumbing.

This dashboard replaces that entire process. Data flows in, the summary tab updates itself, and the person who used to spend their Monday morning building a report instead spends five minutes reading one.

That's the whole pitch: I'm not building you a prettier spreadsheet, I'm buying back your time.