
Store margin dashboard
Which stores keep their margin, and which lose it to discounts?
- Gross profit
- Gross margin
- Markdown rate
- Basket size
Retail dashboards
Six retail dashboards: store performance, store margin, sell-through, retail stock, promotions, and fulfilment and returns. Open any of them to see it in full, then use it as a template for your own data.



Three of the six examples. All figures are sample data.
The examples
Click a board to see all of it. Click Use template to start your own copy in Mammoth. All figures are sample data.

Which stores keep their margin, and which lose it to discounts?

Which stores are improving, not counting new space?

Is the season selling at the rate the buying plan expected?

What is about to run out, and what has stopped selling?

Did the promotion make money, or just move it?

Are orders arriving on time, and how much is coming back?
Your data
Want this on your own numbers?
Pick where your data is. Mammoth turns it into a dashboard like these.
Definition
A retail dashboard is one screen that shows how stores and products are selling: sales, margin, like-for-like growth and sell-through. It is also called a retail analytics, retail KPI or store performance dashboard.
New stores left out, so growth is real.
A chain total hides the stores that differ.
Markdowns charged to the product, not taken off at the end.
The metrics
Eight numbers that show where sales and margin come from. Each can be made to look better by choosing the comparison badly. Open each one to see the data it needs.
Is the chain selling better, or just bigger?
Only stores open in both periods, with new stores, closures and refit weeks left out. Leave them in and changes to the store estate look like growth.
How much of what we took in has sold?
Units sold divided by units received for the same season or delivery. Measured against current stock instead, it rises as stock runs out and looks best when there is nothing left to sell.
Which categories make money?
Sales and cost per product, with markdowns and staff discounts applied to the product rather than taken off at the end. Taken off at the end, discounted categories look as profitable as full-price ones.
Which stores earn their space?
Trading area for each store, kept up to date after refits and changes. Store files go out of date quietly, and this metric goes wrong with them.
Are people buying more, or are more people buying?
Transaction data with returns handled separately rather than as negative baskets, which drag the average down without showing where.
Did the promotion sell more, or sell the same stock cheaper?
A normal baseline for each store and product, the promotion calendar, and the products next to the promoted ones. Comparing against a chain average hides cannibalisation: the promoted product rises and the one beside it falls.
Of the people who came in, how many bought?
Transactions and footfall per store for the same hours. A footfall counter that misses an entrance makes that store look like it converts brilliantly.
Are customers spending more per visit, or just visiting more?
Sales value and number of transactions per store and week, with returns handled the same way everywhere. A store that books returns as negative sales has a basket that shrinks for no reason.
How to build one
From one of the examples above to a live dashboard on your own data.
Start from any of the six boards above.
Upload a spreadsheet, or connect one of 100+ tested connectors.
Fix and combine your data once. Mammoth repeats those steps for you.
The dashboard updates on a schedule and flags data that fails a check.
Public, password-protected or sign-in only, on every plan.
14-day Pro trial · No credit card
Customers
Published customer stories, not dashboards from this page. They are mostly about the hard part: combining retailer data, matching products and getting numbers that hold up.
FAQ
Last reviewed against the template catalogue.
Start from one of these templates or your own spreadsheet. Share it with as many people as you like, free.
More dashboard examples