Building an eCommerce Dashboard That Goes From Macro to Micro Without Drowning

Last week I reviewed the dashboard of a brand we run acquisition for. A solid dashboard in absolute terms, well built, packed with data. And yet, opening it in the morning, it took me ten minutes to figure out what was actually going on with the account.

That was exactly the problem: too much data, not enough order. Too many blocks, badly arranged, with the strategic info buried three screens down while secondary stuff sat proudly at the top. So you drown. You look everywhere and you decide nothing.

Here's how I build an eCommerce dashboard that reads in the same order your brain works, from the most macro down to the most micro. No need for a gas factory. The whole point is that you can decide fast the second you open it.

Arrange Your Dashboard in the Order You Think

A dashboard reads like a newspaper. You start with the headline, the most macro thing, and you work your way down to the detail. If someone opens your dashboard and has to scroll to find revenue, you've messed something up.

What I do is order every block to match the order of my thinking. So much so that I could almost screenshot each panel, line them up one after another, and it would walk through my analysis in the right sequence. Macro first, detail second.

In practice, top line KPIs go at the top. Revenue, number of orders, number of customers, average order value, conversion rate. That's the first thing you should see. Not buried, not at the bottom, first.

And right after that, something a lot of people place too low: the split between new customers and returning customers. On the account I was reviewing, this block was all the way at the bottom. Yet it's one of the most strategic KPIs there is. Knowing whether your growth comes from acquiring new customers or from your base buying again changes everything in your decisions. It moves up top.

If you want to dig into why this ratio matters so much when you change scale, I cover it here: the strategy that takes you from 1M to 3M isn't the one that gets you to 10M.

After the Top Line, Drop Into Detail by Page Type

Once you've got your macro view, you drop down a notch. And here's the classic mistake: staying on a page-level view in top line only. You see sessions per page, overall conversion rate, and you stop there.

Except a collection page and a product page have nothing to do with each other. The behaviors are completely different. A landing page, a homepage, a product page, people do different things on each one and the conversion rates have zero relationship to one another.

What I do is a toggle by page type. You filter collections, you filter product pages, you filter landing pages, you filter homepage. And suddenly you see huge gaps, and above all you understand where things are actually breaking. Comparing your site's average conversion rate means nothing. Comparing the conversion rate of your product pages against each other, now you're onto something.

Cross that with session count, units sold, revenue per page. And just like that you know which product page is pulling its weight and which one is dead.

Device Analysis, Stop Panicking Over Nothing

One thing that makes everyone panic is the conversion gap between mobile, desktop and tablet. People see their mobile conversion rate three times lower than desktop and they freak out.

Honestly, that's normal. It's the case everywhere. No alarm to raise there.

The explanation is simple. On desktop you scroll less but you're already further along in buying mode. You're settled, you've got time, you finalize. On mobile, you see an ad, you click, you look for three seconds, you bounce, and you come back later to buy, often on another device. So mobile absorbs all the discovery traffic and converts less. It's mechanical.

So in your dashboard you show device because it's useful to track the split. You read it as context. That's it. It's not a red flag.

Plug In Your Target and Your Change Log

Two additions I rarely see in place.

The first: your revenue target against your marketing spend. A lot of people fill in their target by hand every week, and of course it slips. Me, I plug in a Google Sheet with a daily target. That way the dashboard calculates your daily pacing on its own. You open it in the morning, you see where you stand against the day's target, without filling in anything. And it cross-references directly with your ad spend to show whether you're paying too much for your growth.

The second: the site change log. You build a line into the dashboard for every technical change or site modification. That way, when your performance moves, you can correlate it with what you changed. A page redesign, a new flow, a price change. Without this log, you spend your life hunting for where a variation came from. With it, you link cause to effect in two seconds.

This is exactly the spirit of an eCommerce audit that starts with your P&L rather than your campaigns. You start from the result and work your way back to what explains it.

Market Share, Show Its Evolution Over Time, Not Just This Month's Share

On the country side, the most common mistake is showing just the revenue percentage per market. France this percent, US that percent, and done.

A frozen percentage tells you nothing. What matters is the evolution of market share. Is a given country's share rising or falling over time. And above all, you cross that with your ad spend per market and your cost per market.

Because that's where you see things. A country where your share climbs without you spending more is gold. A country where you throw budget and the share stalls, you know it's time to stop. Net sales per country, ad spend per country, average order value per country, cost per country. That cross-reference is what tells you where to put your money next month.

Watch Out for Your Metric Definitions

A dumb trap, but one I see all the time. On the dashboard I was reviewing, there were two different web revenue figures. Two blocks, two amounts that didn't match.

The reason: one of them included marketplaces and the other didn't. So you've got two truths in the same dashboard, and the founder no longer knows which one to trust. That's the kind of thing that destroys confidence in the whole tool.

When you aggregate data from Shopify, Meta, Google, Klaviyo, you have to lock down the definition of each metric. Revenue with or without marketplace. Average order value before or after discount. Gross revenue or net of returns. You choose once, you write it down somewhere, and you stick to it everywhere. Otherwise your dashboard looks great but you can't rely on it.

Read a Recommendation Against the Week Before and After

Last point, and this one cuts against what most people do. When you pull a recommendation out of your dashboard, a number on a single day or week, it can be a pure statistical anomaly. A traffic spike, a stockout, a tracking bug, an ad that crushed it for two days. If you decide on that number alone, you're making a decision on noise.

What I do is always look at the week before and the week after. If the trend holds across three weeks, it's real. If it only shows up for one week, I wait.

And a weekly analysis doesn't carry the same weight as a monthly one at all. Weekly is there to react fast on acquisition, monthly gives you the real underlying trend. Both are useful, but you don't decide the same way with one or the other. A small move over a week doesn't justify changing everything. A confirmed move over a month, now yes.

Bottom Line

The best dashboard comes down to one rule: it's arranged in the order you think, from macro to micro.

If a block doesn't trigger any decision, cut it. An overloaded dashboard eventually stops getting opened at all.