If you already run an operating store, you don't need another gallery of pretty charts. You need a dashboard that answers one question every morning: did yesterday make money, and where? That means pairing the standard KPI tiles with the margin math that most templates leave out.
What a good KPI dashboard template actually tracks
Most template galleries hand you the same four report blocks — sales, marketing attribution, customer behavior, and geography. That structure is fine as far as it goes, but it stops at revenue. A revenue chart can rise while you lose money on every order, so the template below adds a margin layer under each tile.
Group your metrics into five tiles. Each one answers a different operator question, and each has an exact formula so two people reading the same dashboard get the same number.
Tile 1 — Revenue and orders
Start with the counters: revenue, orders, and average order value. AOV is just Revenue ÷ Orders. These are your volume read, not your health read — keep them, but never stop here.
Say you run 340 orders a month at a $31 AOV. That's 340 × $31 = $10,540 in monthly revenue. On its own that number tells you nothing about whether the store is healthy, which is why the next four tiles exist.
Tile 2 — Acquisition efficiency
This is where the template earns its keep. Track four numbers together, because any one of them alone lies to you.
- ROAS =
Revenue from ads ÷ Ad spend. If your $2,800 in Meta spend drove the whole $10,540, that's a blended ROAS of$10,540 ÷ $2,800 = 3.76. - CAC =
Ad spend ÷ New customers. Say 250 of your orders came from first-time buyers:$2,800 ÷ 250 = $11.20to acquire each one. - MER (marketing efficiency ratio) =
Total revenue ÷ Total marketing spend. This is attribution-free, so it can't be inflated by Meta and Google both claiming the same sale. - POAS (profit on ad spend) =
ROAS × margin ratio. This is the one almost no template shows, and it's the one that matters.
Why POAS matters: a 3.76 ROAS feels healthy, but on a thin margin it can still lose money. Your break-even ROAS is 1 ÷ contribution-margin ratio. On a 36% contribution margin, break-even is 1 ÷ 0.36 = 2.8 — so a 3.76 ROAS clears it, but not by as much as the raw number suggests. Put the break-even line directly on the ROAS tile so you always read the real number against the floor.
Tile 3 — Margin and contribution
This tile is the heart of an operator dashboard and the single thing template galleries omit. Build a per-order waterfall from revenue down to contribution margin after ads.
Say your average order looks like this: $31 revenue, minus $13 product cost, minus $4.50 shipping, minus $1.24 payment fees (about 4%), minus $1 pick-and-pack. That's a contribution margin before ads (CM2) of $31 − $13 − $4.50 − $1.24 − $1 = $11.26, a 36% CM2 ratio. Now subtract ad spend per order ($2,800 ÷ 340 = $8.24) and your contribution margin after ads (CM3) is $11.26 − $8.24 = $3.02 per order.
That $3.02 is the number your revenue chart will never show you. It's also why the acquisition tile and this tile must sit next to each other — a 10% rise in CAC would wipe most of it out.
Tile 4 — On-site funnel
Three metrics, all on a per-session basis so they stay comparable:
- Conversion rate =
Orders ÷ Sessions. The average ecommerce store converts at roughly two-and-a-half to three percent, and the top ten percent of Shopify stores clear well above four percent, according to Nudgify's Shopify benchmark data. Plot your rate against that band, not against last week alone. - Cart abandonment =
1 − (Orders ÷ Carts created). The long-run documented average sits at about seventy percent, per the Baymard Institute's running tally of fifty studies — so a number near there is normal, not a crisis. - Revenue per session =
Revenue ÷ Sessions, which equals conversion rate × AOV. It's the cleanest single read of on-site performance.
The abandonment number has real upside attached: Baymard's checkout testing found the average large store can lift conversion by about thirty-five percent through better checkout design alone, in the same Baymard research. Track the metric so you know whether that project is worth prioritizing.
Tile 5 — Retention and LTV
Acquisition tiles tell you what it costs to get a customer; this tile tells you whether keeping them pays. Track repeat purchase rate (Customers with ≥2 orders ÷ Total customers) and lifetime value on a margin basis: AOV × purchase frequency × lifespan × margin ratio. Pair LTV with CAC — a healthy LTV:CAC ratio is widely cited at around three-to-one, and below one-to-one you're acquiring at a loss.
For a deeper walk through how these metrics reinforce each other, the ecommerce business intelligence hub covers the full stack, and the companion guide on ecommerce analytics and KPI dashboards goes tile by tile.
A worked read-through
Put the five tiles together for the example store and read it the way you would at 8am:
Revenue is $10,540 on 340 orders — fine, flat week over week. ROAS is 3.76 against a 2.8 break-even — clearing the floor. But CM3 is only $3.02 per order, so the whole month's contribution after ads is $3.02 × 340 = $1,027. Subtract fixed costs (software, your own draw, a freelancer) and the store may be near break-even despite a "healthy" ROAS.
That is the entire point of an operator dashboard: the revenue tile said good month, and the margin tile said watch your fixed costs. A template that only shows the first half will quietly let you scale a money-losing store. The ecommerce analytics best-practices guide goes deeper on keeping these denominators consistent so the tiles never disagree with each other.
Where template dashboards fall short
Three gaps show up in nearly every free template, and your version should close them:
- No margin layer. Revenue and ROAS are top-line. Add the CM2/CM3 waterfall or the dashboard can't tell you if you're profitable.
- Double-counted attribution. If Meta and Google each claim the same orders, summing their ROAS overstates both. Lean on MER for the whole-business read and reserve channel ROAS for optimizing a single channel. This matters even more across platforms — see multichannel ecommerce analytics.
- Static snapshots. A dashboard you check once a week is a report. The operators who compound are the ones acting on the deltas daily, which is covered in ecommerce performance analytics.
From dashboard to action
A dashboard is still a thing you have to read, interpret, and then go act on in five other tabs. That last mile is where most of the time goes — and where PodVector AI takes a different approach. Victor is an AI employee that sits on your live store data, computes true per-order profit (the CM3 number above, not a revenue proxy), and can actually do the next step: adjust a Google or Meta campaign, draft a Klaviyo email, or update pricing — every write action approval-gated, so you confirm before anything executes. Victor pulls from Shopify, Meta Ads, Google Ads, Printify, Printful, Gelato, and Klaviyo, and delivers reports straight to your Google Drive. Victor is not a dashboard; it's the employee who reads the dashboard for you and acts.
If you want the profit math computed and the next action queued instead of charted, start with PodVector AI.
FAQs
What metrics belong on an ecommerce KPI dashboard?
At minimum: revenue, orders, and AOV (volume); ROAS, CAC, MER, and POAS (acquisition efficiency); contribution margin before and after ads (profitability); conversion rate, cart abandonment, and revenue per session (funnel); and repeat purchase rate with LTV:CAC (retention). Group them into five tiles so each answers a distinct question rather than listing twenty numbers with no hierarchy.
What's the difference between a KPI dashboard and an analytics dashboard?
In practice the terms overlap, but a KPI dashboard is the curated top layer — the ten-to-fifteen numbers you check daily against a target. An analytics dashboard is the deeper layer you drill into when a KPI moves unexpectedly. A good template gives you the KPI tiles up front with the analytical breakdowns one click away.
Which free ecommerce dashboard template should I start from?
Any of the Shopify-connected ones (Coupler, Porter, or a Looker Studio build) will get the charts on screen quickly. The important move is to add the margin tile yourself — product cost, shipping, fees, and ad allocation per order — because none of the off-the-shelf templates compute contribution margin, and that's the number that tells you whether to scale.
How often should I actually look at it?
Read the revenue, ROAS-versus-break-even, and CM3 tiles daily; they move fast and small drifts compound. Review retention and LTV weekly or monthly, since those are slow-moving cohort metrics where day-to-day noise is just noise. Set a target line on every daily tile so you're reading against a floor, not against yesterday.
Why isn't revenue enough to track?
Because revenue hides your costs. A store can grow revenue while CAC creeps up and contribution margin after ads turns negative — the top line looks like a win while the bank balance shrinks. That's exactly why the margin and acquisition tiles sit next to the revenue tile in this template: the three only tell the truth when you read them together.