Real-Time Sales Dashboards for FMCG: What Metrics Your Distribution Dashboard Actually Needs
Last month I sat with a sales ops head in Riyadh who had 43 widgets on his dashboard. Forty-three. He opened it, stared for a second, and closed it again. "I don't know what I'm looking at anymore," he said.
Honestly, that's the story of most FMCG dashboards I've seen. Built by IT, requested by senior management, ignored by everyone who actually needs to act on the data.
So let's talk about what a sales dashboard for FMCG should actually show — and what you can quietly delete without anyone noticing.
Start with the question, not the metric
Here's the thing. A dashboard isn't a report. A report answers "what happened." A dashboard answers "what do I do in the next hour?"
That distinction matters more than any chart type or colour palette. If a widget on your screen doesn't lead to a decision or an action within the same working day, it belongs in a weekly PDF, not on your live view.
I got this wrong at first with Zivni. Our early dashboard had beautiful trend graphs going back 90 days. Customers loved it in demos. Then we watched session recordings and realised nobody scrolled past the first fold. The 90-day trend was decoration.
So we rebuilt around three questions a distribution manager actually asks each morning:
- Is my team out there working right now?
- Are orders coming in on pace with yesterday and last week?
- What's breaking that I need to fix before lunch?
Everything else is secondary.
The metrics that actually earn their spot
After working with distributors from Karachi to Manchester, here's the shortlist I'd defend in any boardroom.
Reps active vs. planned. Not attendance. Active. Somebody can be checked in and still parked outside a cafe. Active means they've visited at least one outlet in the last 90 minutes. If 62% of your team is planned to be in the field by 10am and only 41% are active, that's a call your ASM needs to make right now.
Productive calls percentage. Visits that resulted in an order or a meaningful merchandising action, divided by total visits. Industry benchmarks land somewhere between 55% and 70% for grocery FMCG. If you're at 38%, your beat plan is broken or your reps are ghosting outlets to hit visit counts. Both are common. Both are fixable.
Order value pace vs. same day last week. Not vs. last month. Not vs. target. Same day last week, because FMCG is weirdly weekly. Tuesdays behave like Tuesdays. If you're 23% behind last Tuesday at 2pm, that's a signal, not a panic.
Out-of-stock rate at visited outlets. This one's underrated. Your reps are already in the store — they might as well be your eyes on shelf availability. If OOS on your top 10 SKUs is trending above 8%, you've got a supply chain conversation to have today, not next quarter.
Distributor stock cover in days. How many days of forward sales does each distributor have, based on the last 14 days of depletion? Anything under 5 days on a fast mover means you're about to lose sales. Anything over 45 days means you're going to eat returns.
Range selling. Average number of unique SKUs per productive call. This is the metric that separates real growth from noise. A rep selling 4 SKUs to 100 outlets is more valuable than one selling 1 SKU to 300. Most brands don't track this. They should.
That's six metrics. Six. On one screen. With filters for region, distributor, and brand. That's a real-time sales reporting distribution setup that people actually use.
What to quietly kill
Look, I don't want to name names, but I've seen dashboards with:
- YTD sales as a giant hero number (useful for a shareholder call, useless for a Tuesday)
- Top 10 outlets by revenue (they've been the same 10 for two years)
- A pie chart of category split (a table would do, and nobody's changing category mix based on this)
- Rep leaderboards without context (great for morale posters, bad for decisions)
- Weather widgets (I wish I was joking)
Remove them. Nobody will complain. If someone does, ask when they last acted on that data. You'll get a long pause.
The part most people skip: who's it for?
A field sales dashboard for a regional manager in Muscat should look different from one for the national head sitting in Dubai. Different from one for the merchandising lead in Birmingham. Different again for the IT head who just wants to know the sync is working.
But most tools ship one dashboard for everyone and call it a day. That's why adoption dies in month three.
At Zivni we ended up building role-based default views, then letting each user pin what matters. Sounds obvious. Took us two full product cycles to get right. The regional manager sees their team's live activity. The national head sees pace vs. plan across regions. The merchandiser sees shelf share and planogram compliance photos flagged by our AI. The IT head sees a boring green tick that says "everything synced 4 minutes ago."
Everyone opens the dashboard now. Which honestly was the whole point.
One last thing on "real-time"
Real-time is a word that gets abused. If your reps are in low-connectivity areas (rural Sindh, parts of the Empty Quarter, the M6 outside Preston), "real-time" is actually "synced when the phone last saw signal." That's fine. Just show the sync timestamp on every widget so nobody makes a decision on stale data thinking it's live.
The dashboards that get abandoned are the ones that pretend to be more current than they are. The ones that get trusted are the ones that tell you exactly how fresh the number is.
If your current dashboard can't answer "when was this updated?" in one glance — that's probably the first thing to fix. Everything else comes after.