Ecommerce dashboard template: the cards that matter, and who counts each
An ecommerce dashboard template card by card: revenue, orders, conversion rate and MER first, which tool should count each number, and a worked month.
On this page
An ecommerce dashboard should open with four numbers: revenue, orders, conversion rate and blended ROAS (MER, all sales over all ad spend). Under them go revenue by source, the checkout funnel and ad spend by campaign, with every number labeled by the tool that counted it.
The templates that rank for this phrase are mostly design files and chart galleries: many charts, no word on where each number should come from. That is the part that decides whether the board can be trusted. This page lists each card, the question it answers, its source of truth and the trap in it.
The template, card by card
| Card | The question it answers | Count it with | The trap |
|---|---|---|---|
| Revenue | Are we selling more? | The store or payment system | Ad platform revenue overlaps; never add it up |
| Orders | Is growth from more buyers or bigger baskets? | The store | Test and canceled orders |
| Conversion rate | Is the site turning visits into orders? | Orders ÷ visits, from one tool | Orders from one tool over visits from another |
| Blended ROAS (MER) | Is advertising paying overall? | Store revenue ÷ all ad spend | Read it against your break-even, not a benchmark |
| Revenue and visitors over time | Did sales follow traffic? | Both, on separate axes | One axis makes the smaller line look flat |
| Revenue by source | Which channels bring buyers? | Analytics, joined to orders | Direct and unknown are a real share; show them |
| Checkout funnel | Where do buyers drop? | Analytics events | Steps that fire twice inflate the top |
| Ads by campaign | Which campaigns earn their spend? | Spend from the platform, sales tracked by you | Platform ROAS beside tracked ROAS, labeled |
| Entry pages | Which pages start the visits that buy? | Analytics | Sort by revenue, not by visits |
| Email and texts | Is the list pulling its weight? | Your email tool, plus tracked revenue | Apple Mail opens are inflated; count clicks |
Every card earns its place by answering a question someone acts on. Leave off what nobody acts on: impressions, reach, average time on page and raw pageviews belong in a deeper report.
One source of truth per number
The fastest way to lose trust in a dashboard is two numbers that should match and do not. Pick one counter for each:
- Revenue and orders come from the store. Shopify, Stripe or your checkout counts every paid order once. Meta and Google each count the sales their ads touched, so the platforms together often claim more than the store sold. See why analytics numbers never match.
- Visits come from analytics. The store's own session count and your analytics will differ by bots, consent and ad blockers. Use one for conversion rate, and the same one every month.
- Ad spend comes from the ad platform. It is the one number the platform knows exactly.
- Credit for sales is yours. Revenue by source and ROAS per campaign should come from one attribution rule applied to every channel, not from each platform's own claim. Show the platform's claim beside it, labeled, so nobody has to switch tabs to compare.
A worked month
Example numbers, made up for illustration. A store's October, compared with October last year:
| Card | October 2025 | October 2026 | Change |
|---|---|---|---|
| Revenue | $84,000 | $94,500 | +12.5% |
| Orders | 1,400 | 1,450 | +3.6% |
| Average order value | $60.00 | $65.17 | +8.6% |
| Conversion rate | 2.8% | 2.6% | −0.2 points |
| Ad spend | $19,000 | $25,000 | +31.6% |
| Blended ROAS | 4.42 | 3.78 | −14.5% |
Read top to bottom, the board tells one story: revenue grew, almost all of it from bigger baskets, while spend grew much faster than orders. Visits rose and converted a little worse, which fits colder ad traffic. The next card to open is ads by campaign, to find where the extra $6,000 went and what it brought.
With a 45 percent contribution margin, break-even ROAS is 2.22, so the ads still pay. Whether 3.78 is enough depends on fixed costs and the profit goal: see break-even ROAS and target MER.
The checkout funnel card
A funnel from product page to purchase shows where buyers leave. Baymard's average of 50 studies puts documented cart abandonment at about 70 percent (Baymard Institute), so a big drop between cart and order is normal. What to watch is change: a step that loses 10 more points than last month usually means something broke, such as a payment method, a shipping rate or a discount code.
Count each step once per visit and in order. Funnel analysis covers open and closed funnels and the settings that change the answer.
How the template changes with the store
| Stage | Add | Leave out for now |
|---|---|---|
| No ads yet | Revenue by source, entry pages, email | Blended ROAS, ads by campaign |
| One ad platform | Blended ROAS, ads by campaign | Cross-platform comparisons |
| Several ad platforms | Spend and tracked revenue per platform | Each platform's own ROAS as a headline |
| Repeat buyers matter | New and returning revenue, cohort retention | First-order ROAS as the only test |
| Seasonal peaks | Comparison with the same period last year | Month-over-month headlines |
For seasonal stores, compare with last year, with weekdays lined up for daily charts: see year over year comparison.
Common questions
What should an ecommerce dashboard include?
Revenue, orders, conversion rate and blended ROAS at the top; then revenue and visitors over time, revenue by source, the checkout funnel and ad spend by campaign. Each number should say which tool counted it.
What is the most important ecommerce KPI?
For most stores that advertise, blended ROAS or MER held against break-even: it says whether marketing pays overall and cannot double count. Revenue alone hides how much it cost.
Should my dashboard use Shopify's numbers or Google Analytics?
Shopify's for revenue and orders. Your analytics for visits, sources and the funnel. Do not mix the two in one ratio without saying so.
How often should I look at an ecommerce dashboard?
Daily for a glance at revenue and anything broken, weekly for campaigns, monthly against last year for decisions about budget and prices.
Sources
- Baymard Institute: Cart abandonment rate statistics. Checked October 2026.
- Google for Developers: Measure ecommerce (GA4). Checked October 2026.
- Example numbers are made up for illustration.
Spotted something wrong or out of date? Email hello@sporetag.com and we will fix it.