KPI Dashboard Template

Structure: one row per week, not one row per order

A KPI dashboard works best as a weekly (or, at higher volume, daily) rollup rather than raw order-level data — order-level detail belongs in your order management or accounting system, not your KPI tracker, which exists to show trend direction at a glance.

The core tabs

Sales & Revenue: units sold, gross revenue, revenue by channel, week-over-week and year-over-year change. Profitability: contribution margin per unit (see the Unit Economics Calculator), total contribution margin, advertising spend and ACOS/TACOS. Operations: return rate, cancellation rate, late shipment rate, and any account health flags — pulling operational health into the same view as financial performance surfaces the connection between the two (see Account Health Metrics Compared). Channel breakdown: the same core metrics split by marketplace/channel for a multichannel seller, since a blended total can hide a struggling channel behind a strong one.

Columns worth including in every tab

The current week's value, the prior week's value, percent change, and a rolling 4-week average — the rolling average smooths out normal week-to-week noise so you can tell a real trend from ordinary variance.

A worked example of the Sales & Revenue tab

Reading week-over-week alone, week 3 looks alarming (-12%) and week 4 looks like an overcorrection (+17.5%) — but the rolling 4-week average shows the underlying trend is a healthy, roughly stable ~$11,300/week with normal variance, not a real decline followed by a real spike. This is exactly the pattern the rolling-average column exists to reveal — week-over-week percent change alone frequently overreacts to ordinary noise.

Adding a simple status-flag system

Many sellers find it useful to add a green/yellow/red flag column next to each core metric, based on a rule you set once (e.g., red if a metric moves more than a defined percentage against its rolling average, or breaches an account-health threshold from the Account Health Metrics Compared reference). This turns a dense table of numbers into something scannable in seconds — you look for red and yellow flags first, rather than re-reading every number each week.

Building the channel breakdown tab well

For a multichannel seller, replicate the core Sales, Profitability, and Operations rows once per channel, plus one blended row. Reviewing the blended row alongside the per-channel rows — not instead of them — is what actually surfaces a struggling channel hidden behind a strong one; see Contribution Margin Reporting by Channel and SKU for a deeper version of this same idea applied specifically to margin.

Keep it manually maintainable at first

A dashboard that requires an hour of manual data pulling every week tends to get abandoned within a month or two. Start with whatever metrics you can pull in 10-15 minutes weekly from your existing seller dashboards, and only add a metric once you've confirmed you'll actually act on it.

When to graduate to dedicated analytics tooling

Once manual weekly updates become a genuine time burden, or once you're managing enough SKUs/channels that a spreadsheet can't reasonably show the detail you need, it's worth evaluating a dedicated multichannel analytics platform rather than continuing to expand the spreadsheet indefinitely.

Best practices

• Use a rolling average column on every tab to separate real trend from ordinary week-to-week noise.
• Add a simple status-flag system so you can scan for problems in seconds rather than re-reading every number.
• Keep a blended row and per-channel rows together on the channel breakdown tab, reviewed side by side.
• Only add a new metric once you've confirmed you'll actually check and act on it weekly.

Checklist

• Set up Sales & Revenue, Profitability, Operations, and Channel Breakdown tabs
• Add current, prior-period, percent-change, and rolling-4-week-average columns to each tab
• Define a simple status-flag rule for each core metric
• Confirm weekly update time is realistically under 15 minutes; trim scope if not
• Revisit quarterly whether it's time to graduate to dedicated analytics tooling

FAQs

Should the dashboard be daily, weekly, or monthly? Weekly is the right default for most sellers below high volume — daily is noisier than useful, and monthly is often too slow to catch a developing problem in time to act.

How many weeks of history should the sheet retain? Enough for at least one full year for year-over-year comparison, ideally more — seasonal categories especially benefit from multi-year history once available.

Is a spreadsheet still fine once I'm running several marketplaces? Yes, up to a point — many sellers running three or four channels manage fine on a well-structured spreadsheet; the graduation point is really about time cost and required granularity, not channel count alone.