Retail Performance Dashboard
Sunday, 2:40 in the afternoon. One person on the floor, one on the register, and a man at the knife case who wants to know why two chef's knives are $40 apart. He waits four minutes, then leaves. Nobody writes that down, because the day's sales still beat last year and the labor line came in under budget.
Most American retail still happens in a building. The Census Bureau puts e-commerce at 17.1% of total US retail sales in the second quarter of 2026, seasonally adjusted, so roughly five dollars in six still change hands somewhere other than a website. Retail sales overall are still growing, too. Census's advance estimate of US retail trade sales for August 2026 was $646.3 billion, up 5.4% on August 2025.
The pressure is on the cost of serving those shoppers. The Bureau of Labor Statistics puts average hourly earnings in retail trade at $26.38 in August 2026, up 3.1% in a year. Shrink is the other leak. The National Retail Federation's 2023 security survey put average shrink at 1.6% of sales in fiscal 2022, up from 1.4%, or $112.1 billion. Trim hours to protect the wage line and you get fewer people helping customers buy, and fewer eyes on stock walking out.
We invented the chain in this example: a small US kitchenware retailer with a dozen stores. Every monthly figure below is modeled for this example. One target below has a published benchmark behind it, and the table says which. The rest are starting points. For the peak season itself, see the retail holiday dashboard example, and for web sales, the e-commerce example. This page is about the stores, all year.
What is a Retail KPI Dashboard?
Overview
A retail KPI dashboard shows whether the people who walk into your stores are buying, how much they buy, and whether the stock, space and staff hours behind each sale are paying their way.
It starts at the door. Conversion rate is the share of visitors who buy anything. Average transaction value and units per transaction describe what they buy: one item or three, the peeler on its own or the peeler and the knife. Visitors times conversion times average transaction value is the store's sales, broken into parts a store team can actually change on a given afternoon. Units per transaction is the part of that average a good salesperson moves most.
The results come next. Gross sales is the dollar total for the month. Same-store sales growth strips out new and closed stores and compares like with like against last year. It's the number a lender, or a buyer for the business, asks about first. Sales per square foot ranks stores by how hard their selling floor works.
Then the cost of getting there. Gross margin shows what's left after the cost of goods, markdowns and shrink. GMROI shows what the inventory earns for the money tied up in it. Shrink rate is stock you paid for and can't find. Sales per labor hour divides sales by paid store hours, and it's the number most likely to be pushed too hard.
Who benefits from this dashboard?
- Owner or CEO: Same-store sales growth and gross margin, read against the same month last year, answer whether the chain is getting better or just getting bigger.
- Store Managers: Conversion, units per transaction and sales per labor hour are the three numbers they can move this week, by changing who's on the floor and when.
- Buyers and Merchandise Planners: GMROI and gross margin show which categories earn their open-to-buy. A department with a fat margin and a GMROI under 2 is usually holding too much stock.
- District or Operations Manager: Conversion and shrink store by store show which managers run the floor well, which stores are short of staff at the wrong hours, and where the next cycle count should go.
Don't give stores a flat monthly sales-per-labor-hour target. January can't hit the same number as December, so managers chase it by cutting floor hours in the slow months, and the hours they cut first are usually the second person on a busy afternoon. Judge it against the same month last year, and always read it next to conversion.
Dashboard Example Overview
The example chain sells cookware, knives, small appliances and kitchen tools from 12 stores in the Great Lakes states, each with about 3,100 square feet of selling space in lifestyle centers and downtown streets. It brings in about $16.5 million a year from home cooks, wedding registries and gift buyers, and opened a 13th store in May 2026. It reports monthly against ten KPIs:
- Gross Sales: Everything rung through the registers before returns and discounts, all stores including new ones. December runs at roughly twice an average month, so it's only useful against the same month last year.
- Same-Store Sales Growth: Net sales of stores open at least 13 months, against the same stores in the same month last year. Public retailers draw the line in different places; Caleres' 2025 quarterly filing uses 13 months and treats a relocated store as new.
- Sales per Square Foot: Trailing 12 months of net sales from comparable stores, divided by their selling square feet. Stockrooms and offices are left out.
- Conversion Rate: Transactions divided by door-counter visitors, with entries and exits halved and returns-only transactions taken out.
- Average Transaction Value: Net sales divided by transactions. It rises with prices, so watch it next to units.
- Units per Transaction: Units sold divided by transactions. The honing steel that goes home with the knife lives here.
- Gross Margin: Net sales minus cost of goods sold, with shrink and inbound freight in the cost, divided by net sales.
- GMROI: Trailing 12 months of gross margin dollars divided by average inventory at cost over the last 13 month-ends.
- Shrink Rate: Book inventory minus counted inventory, at cost, divided by net sales. Monthly from rolling cycle counts, trued up at the full counts.
- Sales per Labor Hour: Net sales divided by all paid store hours, managers included.
The chain's problem started before the dashboard did. In spring 2024, with wages climbing, the owner gave every store a target of $160 in sales per labor hour. Store managers chased it the way store managers do: a shift trimmed on Tuesday morning, then the second person on Saturday afternoon. Nobody decided to understaff the stores.
In October 2024 conversion was 24.4%, same-store sales were up 5.4% and sales per labor hour was $155.40. Through 2025, conversion eased: 24.3% in February, 23.9% in May, 23.3% in July, 23.4% in September. From February to October 2025 no month fell more than half a point from the one before, two of them went up and three didn't move. The monthly review compared each month with the last one and with budget, and saw noise.
Same-store sales cooled with it, from +5.4% in October 2024 to −1.6% in June 2025 and −0.3% in July. Each month came with its own explanation: a wet weekend, a competitor's anniversary sale, roadworks outside one store. Meanwhile Census had national retail trade sales up 3.5% in both June and September 2025. And the labor number looked great. October 2025 came in at $165.80 a labor hour, against $155.40 a year earlier.
Two smaller numbers drifted the same way. Units per transaction slipped from 2.08 to 2.00 by July 2025, as fewer people had time to suggest the sharpener with the knife. Shrink rate rose from 1.41% to 1.59% in June 2025 and was still 1.58% in September. Fewer staff on the floor means fewer people noticing what leaves it.
What caught it was a line. In October 2025 the operations manager put conversion on a chart covering every month since October 2024 and added a trend line. It fell about 0.08 points a month, close to a point a year, and showed no sign of flattening. On roughly 1.17 million visitors a year at about $59 a sale, a point of conversion is around $690,000 in sales. Set against the schedules, the slide was steepest in the stores that had cut the most Saturday hours.
The fix was dull. From November 2025 the flat labor target went, replaced by comparison with the same month last year. Each store scheduled from its own hourly door counts, putting a second person on the floor for its busiest dozen or so hours a week. About 7% of the hours came back, roughly 7,500 a year. Conversion went onto the store managers' weekly sheet. There was no new system and no consultant.
The recovery was as slow as the slide. December 2025 conversion was 22.7%, below the 23.1% of December 2024, because holiday schedules were already set. January 2026 was 24.4%, still under January 2025's 24.8%. May 2026, at 24.3% against 23.9%, was the first month to beat the year before, and by September 2026 it was 24.2% against 23.4%. Units per transaction reached 2.15 in June 2026, against 2.06 the June before, and shrink fell to 1.36% in August. Same-store sales were +4.7% in January 2026 and +7.0% in September. Some of that is lapping weak months: June 2026's +8.6% sits on June 2025's −1.6%, so over two years June grew about 7%.
Sales per labor hour is the number that went the wrong way, and the owner accepted it. September 2026 came in at $155.20, against $159.60 a year earlier, and every month from May to September 2026 was below the same month of 2025. The hours came back before the sales did, and the new store ran heavy on hours while its staff learned the floor. At BLS's $26.38 average hourly wage, the returned hours cost about $200,000 a year. The conversion they won back is worth roughly $260,000 of gross margin, and it's still climbing.
The rest is mixed. Gross sales in September 2026 were $1,461,287, up 14.3% on September 2025, while same-store sales grew 7.0%; the gap is mostly the new store. Sales per square foot reached its $450 target in February 2026 and $468 by September. GMROI recovered from 2.07 in November 2025 to 2.16 in August 2026 but never reached 2.2, partly because the new store's opening stock landed in April, a month before its first sale. Shrink at 1.48% in September is still above the 1.3% target after the new store's first full count.
Creating a Retail Dashboard in SimpleKPI
-
Step 1 Settle what counts as a visitor and a comparable store
Does your door counter log entries and exits, and does it filter out staff? Does a new store join the comp base in month 13 or its first full fiscal year? Is a relocated store new? Does an online order picked up in store count as a store sale? Each answer can move conversion or comps by a point, and two stores counting differently can't be compared.
If you're still settling which measures belong on the board, the guide to choosing KPIs walks through it.
-
Step 2 Give store managers the floor numbers and buyers the stock numbers
Store managers can change conversion, units per transaction and sales per labor hour this week, so those are theirs, weekly, by store. Buyers own gross margin and GMROI by category, because they set the open-to-buy and the markdowns. Shrink belongs to whoever runs the counts. Same-store sales and sales per square foot are finance's monthly numbers. Name the source next to each one: point of sale, door counter, inventory system, payroll.
-
Step 3 Chart conversion over 12 months or more, with a trend line
A drift of a tenth of a point a month is invisible in a month-on-month review and obvious on a two-year chart. Keep the weekly store view short and current, but give the monthly review a long line graph of conversion, units per transaction and shrink, so a slow slide has somewhere to show up.
-
Step 4 Check conversion before you cut a labor hour
Before any schedule change, look at the store's hourly traffic and its conversion in those hours. Cutting hours when the store is empty lifts sales per labor hour for free. Cutting them when the floor is busy lifts it for a few months and then takes it back through lost sales. Promotions need the same check against gross margin.
List of Retail KPIs
Only shrink rate has a published US average to compare against, from NRF. Every target marked starting point comes from this example chain, so swap in your own once you have a year of counts.
| KPI Name | Typical Target | Description / Calculation |
|---|---|---|
| Gross Sales | $1.3 million a month (starting point) | All store sales before returns and discounts. Set a target per month from the same month last year. |
| Same-Store Sales Growth | ≥ 4% (starting point) | Net sales of stores open 13 months or more divided by the same stores' net sales in the same month last year, minus one. |
| Sales per Square Foot | ≥ $450 a year (starting point) | Trailing 12 months of comparable-store net sales divided by selling square feet. |
| Conversion Rate | ≥ 24.5% (starting point) | Transactions divided by door-counter visitors. Count each visitor once. |
| Average Transaction Value | ≥ $60 (starting point) | Net sales divided by transactions. |
| Units per Transaction | ≥ 2.15 (starting point) | Units sold divided by transactions. |
| Gross Margin | ≥ 46% (starting point) | Net sales minus cost of goods sold, including shrink and inbound freight, divided by net sales. |
| GMROI | ≥ 2.2 (starting point) | Trailing 12 months of gross margin dollars divided by average inventory at cost. |
| Shrink Rate | ≤ 1.3% (NRF average 1.6%, FY2022) | Book inventory minus counted inventory, at cost, divided by net sales. Lower is better. |
| Sales per Labor Hour | ≥ $160 (starting point) | Net sales divided by paid store hours. Judge against the same month last year, and next to conversion. |
Want a longer list to pick from? The retail KPI template covers 16 retail measures, including shop visitors, transaction counts, returns and allowances, and net sales. To draft KPIs for a different format, from a garden center to a bike shop, try the KPI generator.
Why Retail Dashboards Matter
In a store, the number that looks best on its own is often paid for by one nobody checks. Sales sit in the register report, hours in payroll, and visitors in the door counter's own app, which is the one nobody opens.
Sales per labor hour and conversion are the pair that pull hardest. Cut a Saturday shift and the labor number improves the same month, while the conversion cost arrives slowly, half a point at a time, and gets blamed on the weather. Shrink follows the same hours, because stock leaves when nobody's watching the floor. Average transaction value can rise on price alone while units per transaction falls, which looks like healthy trading and is really fewer things in each bag.
The buyer's side has its own tug of war. A deeper assortment can lift conversion and units, then drag GMROI down because the extra stock sits for months. A clearance event empties the shelves and props up GMROI, at the cost of gross margin in the month it runs.
None of that is a reason to stop managing labor. It's a reason to read the hours, the conversion and the shrink on one screen, over enough months to see a slope. A chain that loses a point of conversion over a year rarely notices in any one month. It notices when someone draws the line.
Building it in SimpleKPI
Build this dashboard yourself with SimpleKPI's KPI dashboards, or start from the Retail KPIs template. The mechanics are the same whatever you track:
- KPIs: each one gets a target, an entry frequency and tags, so you can report by team, site, product or whatever you split the numbers by.
- Data: type numbers in, import a spreadsheet, or use an integration or the API. The dashboard updates as each number lands, so daily and monthly KPIs sit side by side.
- Reports: scheduled KPI reports email the numbers to people who never log in.
- AI: Kip, the built-in AI, suggests targets and flags indicative benchmarks (AI estimates, not peer data) once some history builds up.
- Price: $79 a month for unlimited users and KPIs, as one flat price, with a 14-day free trial and no card needed.