Retail Dashboard: 10 KPIs Every Commercial Team Should Track

Retail Dashboard: 10 KPIs Every Commercial Team Should Track

Commercial teams generate thousands of data points every week. But only a handful of KPIs actually help improve performance. The challenge isn't collecting more data — it's focusing on the metrics that drive better commercial decisions.

This guide covers the 10 essential retail dashboard KPIs, with the formula behind each one, a concrete example, and the mistakes to avoid when reading them.

---

1. Total Sell-Out

Sell-Out remains the most important KPI. It tells you exactly how many units (or how much value) consumers purchased during the selected period.

Formula: Sell-Out = sum of units sold to end consumers across all stores and retailers, over a given week or month.

Example: Your brand sold 12,400 units across all retailers in week 32, versus 10,900 in week 31. Sell-out is up 13.8% week over week — but before celebrating, check whether a promotion drove the spike (see KPI 3).

Tracking Sell-Out over time allows commercial teams to:

• Measure business performance
• Detect growth trends
• Compare against last year
• Monitor retailer execution

---

2. Growth vs Last Year

Growth alone doesn't tell the whole story. Comparing performance against the same period last year reveals whether growth is sustainable or simply seasonal.

Formula: Growth % = (Sell-Out this period − Sell-Out same period last year) ÷ Sell-Out same period last year × 100.

Example: You sold 45,000 units year-to-date versus 41,000 last year: +9.8% growth. But if one retailer went from 8,000 to 12,000 units while another dropped from 9,000 to 6,500, the aggregate number hides a serious account problem.

Questions answered include:

• Are we outperforming last year?
• Which customers contribute most?
• Which brands are accelerating?

Watch out: always compare like-for-like periods. A 53-week year, a shifted Easter, or a promotion that ran in March last year but April this year will distort the comparison.

---

3. Promotion Contribution

Promotions often generate impressive sales numbers. But how much growth actually comes from promotions?

Formula: Promo contribution = units sold on promotion ÷ total units sold over the period.

Example: Your sell-out grew 15% this quarter, but 40% of all units were sold on promotion versus 25% last year. A large share of your "growth" is bought through discounts — and margins are paying for it.

A modern retail dashboard should quantify:

• Units generated by promotions
• Contribution to total growth
• Incremental sales versus baseline
• Promotional dependency

Without this KPI, commercial teams struggle to evaluate promotional ROI.

---

4. SKU Performance

Not every product contributes equally. Your dashboard should immediately highlight:

• Top-performing SKUs
• Underperforming products
• Fast-growing references
• Declining products

Example: Your top SKU represents 22% of total sell-out and grew 18% year over year. Meanwhile, 15 of your 60 active SKUs each represent less than 0.5% of sales. That's a clear signal for assortment rationalization discussions with your retailers.

Watch out: a declining SKU is not always a problem SKU. Check distribution first — if the product was delisted in 200 stores, the sales decline is a distribution issue, not a demand issue.

Commercial discussions become much easier when product performance is visible in seconds.

---

5. Stock-Out Risks

Growth opportunities disappear when products are unavailable. Monitoring future stock coverage helps teams act before sales are lost.

Formula: Weeks of Supply (WoS) = current stock at retailer ÷ average weekly sell-out (typically over the last 4 to 13 weeks).

Example: A SKU sells 300 units per week on average and the retailer holds 600 units: 2 weeks of supply. With a 3-week replenishment lead time, a stock-out is almost certain unless an order is placed immediately.

Important indicators include:

• Weeks of stock per SKU and retailer
• At-risk SKUs
• Upcoming stock-outs
• Expected sales impact (weekly sell-out × weeks of shortage)

Watch out: compute weeks of supply per retailer, not in aggregate. Healthy total stock can hide one major retailer sitting at zero.

---

6. Promotion Effectiveness

Not every promotion creates value. Retail dashboards should measure:

• Promotion uplift: (promo week sales − baseline sales) ÷ baseline sales
• Baseline sales: average weekly sales over the 4 to 8 non-promotional weeks before the event
• Coverage: share of stores where the promoted SKU was actually available
• Stock-outs during promotions
• Missing units: estimated sales lost to unavailability during the event

Example: A promotion delivers +120% uplift on paper. But the SKU was out of stock in 30% of stores by day 3. The real uplift potential was closer to +170% — and the missing units went to a competitor.

These KPIs help improve future promotional planning: which mechanics to repeat, which to drop, and which retailers execute well.

---

7. Top Customers

Commercial teams need to know where growth comes from. A dashboard should identify:

• Fastest-growing retailers
• Largest contributors
• Declining customers
• Customer concentration

Example: Your top 3 retailers represent 68% of total sell-out. One of them is declining 12% year over year. That single account is dragging your entire national performance — and it deserves a dedicated action plan before the next line review.

Watch out: growth contribution matters more than growth rate. A small retailer growing 50% may add fewer units than a large retailer growing 3%. Rank customers by units or value added, not just by percentage.

This allows account managers to prioritize their actions.

---

8. Category Performance

Looking only at total sales hides important trends. Monitoring category performance reveals:

• Winning categories
• Declining segments
• Growth contribution per category
• Market opportunities

Example: Your total sell-out is flat, but the breakdown shows one category up 24% and another down 18%. The commercial strategy for each is completely different — defend distribution and shelf space in the growing one, fix or exit in the declining one.

Category-level analysis is also where cross-retailer gaps become visible: if a category grows at every retailer except one, the issue is local execution, not the market.

---

9. Executive Insights

The best dashboards don't only display numbers. They explain them.

Executive insights summarize:

• Strengths
• Risks
• Growth drivers
• Recommended actions

Example: instead of a table of 40 KPIs, the weekly summary reads: "Sell-out +8% YTD, driven by Retailer A (+22%) and the espresso category (+15%). Risk: 4 SKUs below 3 weeks of supply at Retailer B ahead of the October promotion."

Decision-makers shouldn't spend time interpreting reports. They should immediately understand what matters.

---

10. Action Plan

The best dashboards don't stop at reporting. They recommend actions.

Examples include:

• Increase orders before stock-outs
• Repeat successful promotions
• Reduce inventory on slow movers
• Expand distribution where demand is highest
• Focus sales efforts on growing retailers

Analytics should drive execution — not just reporting. A KPI that never leads to a decision is a vanity metric.

---

Common Retail Dashboard Mistakes to Avoid

Even well-equipped teams fall into the same traps:

• Tracking too many KPIs. Twenty charts nobody reads are worth less than ten KPIs reviewed every Monday.
• Comparing against last year without adjusting for promotions. If last year's growth came from an exceptional promo event, a flat year may actually be a strong performance.
• Mixing sell-in and sell-out. Sell-in measures what you ship to retailers; sell-out measures what consumers actually buy. Confusing the two hides inventory build-up in the channel. See our guide on sell-in vs sell-out for the full distinction.
• Aggregating across retailers. National averages hide account-level problems. Every KPI above should be readable per retailer.
• Ignoring data harmonization. Retailers report different formats, calendars and product codes. Without a clean product and store mapping, dashboard numbers can't be trusted.

---

Frequently Asked Questions

What is the most important retail KPI? Sell-out (units or value sold to end consumers) is the foundation. Every other KPI — growth, promo contribution, weeks of supply — is derived from it.

How often should a retail dashboard be updated? Weekly is the standard for sell-out data, matching retailer data feeds and commercial review rhythms. Daily updates add noise without adding decisions.

How many KPIs should a retail dashboard include? Between 8 and 12. Enough to cover sales, promotions, stock and customers; few enough that the team actually reviews all of them.

What is the difference between a retail dashboard and a sell-out report? A report describes what happened. A dashboard connects what happened to what to do next — growth drivers, risks and recommended actions.

---

Why Modern Retail Dashboards Matter

Retail data becomes valuable only when it helps teams make faster decisions. Instead of building Excel reports every Monday, commercial teams should immediately know:

• What changed
• Why it changed
• What to do next

That's the purpose of a modern retail dashboard. For a step-by-step methodology, read our sell-out analysis guide.

---

How Sell-Out Copilot Helps

Sell-Out Copilot centralizes sell-out, promotions, stock and product performance into one commercial dashboard.

Teams instantly identify:

• Growth opportunities
• Promotion performance
• Stock risks
• Customer contribution
• Product performance
• Executive insights

Instead of producing reports, they spend more time improving commercial performance.

---

Conclusion

Great commercial dashboards don't overwhelm users with data. They surface the KPIs that matter most — each with a clear formula, a concrete example and a decision attached.

When commercial teams understand what drives growth, where risks are building and what actions to take, better decisions happen naturally. That's exactly what modern retail analytics should deliver.