KPI Dashboard Template Checklist
A starter KPI dashboard layout for online-store operators — six core tiles covering revenue, conversion rate, AOV, CAC, blended ROAS, and channel performance, ready to clone into Looker, Mode, Metabase, or a spreadsheet.
KPI Dashboard Template
A starter dashboard layout for online-store operators covering revenue, conversion rate, AOV, CAC, blended ROAS, and channel mix.
A KPI dashboard template is a pre-built layout you clone into your reporting tool of choice — Looker Studio, Mode, Metabase, Power BI, or even a spreadsheet — so you stop rebuilding the same six charts every quarter. For a Shopify or WooCommerce operator, the right template surfaces the handful of numbers that actually move the business: daily revenue, sessions, conversion rate, average order value, blended customer acquisition cost, and ROAS by channel.
This page gives you that layout as a checklist. Each tile below specifies what to plot, what time window to use, and the common trap that makes the tile lie to you. Copy the structure, wire it to your data sources, and you have a working operator dashboard in an afternoon.
Most operator dashboards fail the same way: they show 40 metrics, refresh once a week, and nobody can tell at a glance whether yesterday was good or bad. The fix is not more charts — it is fewer, with sharper definitions and a tighter refresh cadence.
The template below is opinionated on purpose. Six tiles, one screen, daily refresh. If a number is not in here, it belongs in a deeper analysis view — not on the morning dashboard the team opens with coffee.
Define each metric once, in writing
The single biggest reason dashboards drift is undefined metrics. Is 'revenue' gross or net of refunds? Does AOV include shipping? Does CAC count organic? Write the definitions next to each tile in your dashboard tool's description field. Future-you and every new hire will thank you.
The six tiles, in order
Tile 1 — Daily revenue, last 30 days vs prior 30 days. A simple line chart with two series. Annotate launches, promos, and outages directly on the chart so a dip in week 3 does not turn into a fire drill. Use net revenue (after refunds and discounts) so the number matches your P&L.
Tile 2 — Conversion rate, sessions vs orders. Plot sessions and orders as two lines on the same axis, then show CR as a single big number with a 7-day trailing average. The trailing average matters: daily CR is noisy enough that you will chase ghosts without it. Segment by device if mobile CR is materially different from desktop, which on most apparel and beauty stores it is.
Tile 3 — AOV and units per order. AOV alone hides the mechanism. If AOV rose because you raised prices, that is different from AOV rising because bundles started working. Show AOV next to units-per-order so you can read both at once. Strip shipping revenue out unless free-shipping thresholds are a core part of your merchandising lever.
Tile 4 — Blended CAC and ROAS by channel. The headline number is blended (total ad spend across all paid channels divided by new customers), with a small breakdown table showing spend, revenue, and ROAS per channel — Meta, Google, TikTok, applicable affiliates. Blended is what your bank account sees; per-channel is what you optimise. Both belong on the dashboard.
Tile 5 — Funnel drop-off: sessions → product view → add to cart → checkout → purchase. A horizontal bar chart with conversion rate between each step. This is the tile that tells you whether the problem is traffic quality, PDP, or checkout — and where to point your next experiment. Tile 6 — Customer mix: new vs returning revenue and orders, with new-customer share as a percentage. A swing here is usually the earliest signal that paid acquisition economics are changing.
KPI dashboard template — FAQ
For most stores in the €1M-€15M range, Looker Studio (free, connects to GA4 and Shopify via community connectors) or Metabase (open source, self-hosted) cover 90% of the need. Mode and Power BI start to make sense once you have a data warehouse like BigQuery or Snowflake. Spreadsheets work fine as a starting point if your data volume is small.
Daily is the right cadence for an operator dashboard. Real-time is rarely useful — it just makes the team react to noise. Set the refresh to run overnight so the dashboard is current when the morning standup happens.
No. LTV is a cohort metric that moves slowly and is easy to misread on a daily view. Put it on a separate weekly or monthly cohort dashboard alongside repeat purchase rate and 90-day revenue per customer.
Pick one source of truth per metric. Revenue: Shopify (it matches what you bank). Sessions and on-site funnel: GA4. Ad spend: pulled directly from each ad platform's API. Do not try to reconcile them on the dashboard — document the source under each tile and move on.
For Shopify stores, sitewide CR typically lands between 1.5% and 3.5%, with apparel and beauty on the higher end and considered-purchase categories (furniture, electronics) on the lower. Mobile CR is usually 30-50% lower than desktop. Use your own trailing 90-day baseline rather than industry numbers when judging whether a day is good or bad.
No. Looker Studio plus a Shopify connector plus the GA4 connector gets you five of the six tiles in a few hours. The only piece that usually needs scripting is pulling ad spend from each platform, and tools like Supermetrics or Funnel.io handle that without code.
Shopify's analytics shows revenue and orders well but has no spend or ROAS view. GA4 shows sessions and funnels but reports revenue differently from your bank. A KPI dashboard template stitches the two together so blended CAC, ROAS, and net revenue live in one place — which neither tool does natively.
Yes, with per-client variants. A standardised six-tile layout makes onboarding faster and lets account managers compare account health at a glance. Vary the channel breakdown and customer-mix tile based on each client's stack, but keep the structure identical.
Limit each tile to a 90-day window by default, cache query results overnight rather than running them on page load, and avoid more than 6-8 tiles per screen. Looker Studio and Metabase both support cached extracts — use them.
Anything that does not change a decision in the next 24 hours. Email open rates, Instagram followers, NPS — all useful, all belong on dedicated channel or brand-health dashboards. The operator dashboard is for revenue, acquisition economics, and funnel health. Keep it ruthless.
Start tracking the metric that matters
Free for 30 days. No credit card. Connect your site in 4 minutes and see the one metric driving revenue.