Retail KPIs: 12 Metrics Every Store Owner Should Track

Most store owners have a feeling for how the business is doing. Retail KPIs (key performance indicators) replace that feeling with a small set of numbers that show what is improving, what is slipping, and where to act first.

This guide explains twelve KPIs every store owner should track, with the formula for each, a single worked example using one hypothetical store month, what to watch for, and how to build a simple weekly KPI report.

How retail KPIs fit together

Revenue is the result of a few drivers you can influence separately: how many people come in, how many buy, and how much each buyer spends. Looking at the drivers tells you why sales moved.

Throughout this article we use one hypothetical store month: $84,000 net sales, 2,800 transactions, 7,000 units sold, $50,400 cost of goods sold, $42,000 average inventory at cost, 9,000 visitors and 1,200 staff hours. All figures exclude sales tax.

Sales KPIs

1. Net sales (revenue)

Formula: gross sales − returns − discounts (excluding tax). Example: $84,000. Compare with the same period last year and the same weekday last week, not just last month, to remove seasonal effects.

2. Average transaction value (ATV)

Formula: net sales ÷ number of transactions. Example: 84,000 ÷ 2,800 = $30.00. Raise it with bundles, better product placement near the till and well-trained staff.

3. Units per transaction (UPT)

Formula: units sold ÷ number of transactions. Example: 7,000 ÷ 2,800 = 2.5. Together with average unit price ($84,000 ÷ 7,000 = $12.00), it explains ATV: 2.5 × $12.00 = $30.00.

4. Conversion rate

Formula: transactions ÷ visitors × 100. Example: 2,800 ÷ 9,000 × 100 ≈ 31.1%. Requires a door counter or another reliable traffic count; without one, track transactions per hour instead.

Profitability KPIs

5. Gross margin %

Formula: (net sales − cost of goods sold) ÷ net sales × 100. Example: (84,000 − 50,400) ÷ 84,000 = 33,600 ÷ 84,000 = 40%. Track it by category; a mix shift towards low-margin products can hide behind growing sales. See margin vs markup for the formulas in detail.

6. GMROI (gross margin return on inventory investment)

Formula: gross margin ÷ average inventory at cost. Example (monthly): 33,600 ÷ 42,000 = 0.8 — each dollar of stock earned $0.80 of gross margin this month. If every month were similar, the annual figure would be 33,600 × 12 ÷ 42,000 = 9.6. GMROI is usually reported on an annual basis; above 1 means stock earns more than it costs.

7. Sales per labour hour

Formula: net sales ÷ staff hours worked. Example: 84,000 ÷ 1,200 = $70 per hour. Use it with hourly sales data to schedule staff for peaks rather than for habit.

Inventory KPIs

8. Inventory turnover

Formula: cost of goods sold ÷ average inventory at cost. Example (monthly): 50,400 ÷ 42,000 = 1.2 turns, or about 14.4 a year at the same pace. Higher turnover generally means less cash tied up in stock — see the retail inventory management guide.

9. Sell-through rate

Formula: units sold ÷ units received × 100 for a product, delivery or season. (Some retailers divide by beginning inventory instead — be consistent.) Example: 1,200 units of a seasonal line received, 780 sold by the end of the season: 780 ÷ 1,200 = 65%. Low sell-through flags products to discount early or stop reordering.

10. Stockout rate

Formula: SKUs at zero stock ÷ SKUs checked × 100 (or the share of days a key product was unavailable). Example: 37 of 1,000 active SKUs at zero during a weekly check = 3.7%. Focus on stockouts of class A items — see ABC analysis and the reorder point formula.

Returns and loss KPIs

11. Return rate

Formula: value of returns ÷ sales × 100 (or units returned ÷ units sold). Use either gross or net sales as the base, and state which. Example: $2,100 of returns on $84,000 of net sales = 2.5%. Break it down by product and reason: a single product with high returns usually signals a quality, sizing or description problem.

12. Shrinkage rate

Formula: (book inventory value − counted inventory value) ÷ net sales × 100 for the period. For context, the U.S. National Retail Federation’s 2023 survey reported an average of 1.6% of sales for fiscal 2022. Measure your own trend with regular cycle counts and act on it with the shrinkage prevention guide.

All 12 KPIs at a glance

#	KPI	Formula	Example	Review
1	Net sales	Gross sales − returns − discounts	$84,000	Daily / weekly
2	ATV	Net sales ÷ transactions	$30.00	Weekly
3	UPT	Units ÷ transactions	2.5	Weekly
4	Conversion rate	Transactions ÷ visitors	31.1%	Weekly
5	Gross margin %	(Sales − COGS) ÷ sales	40%	Monthly
6	GMROI	Gross margin ÷ avg inventory at cost	0.8 / month	Monthly / yearly
7	Sales per labour hour	Sales ÷ staff hours	$70	Weekly
8	Inventory turnover	COGS ÷ avg inventory at cost	1.2 / month	Monthly
9	Sell-through	Units sold ÷ units received	65%	Per season / delivery
10	Stockout rate	SKUs at zero ÷ SKUs checked	3.7%	Weekly
11	Return rate	Returns ÷ sales	2.5%	Monthly
12	Shrinkage rate	(Book − counted) ÷ sales	Your trend	Monthly / quarterly

Building a weekly KPI report

A useful KPI report fits on one page and compares each number with something meaningful.

KPI	This week	Same week last year	Last 4 weeks avg	Target	Comment
Net sales
Transactions
ATV
UPT
Gross margin %
Stockouts (class A)
Cash over/short

1. Pull sales, transactions and units from your POS sales reports.
2. Add cost data from recorded purchases for margin.
3. Add the week’s cash differences from your daily reconciliations.
4. Write one comment per number that moved significantly — and one action.

See which dashboards, exports and automated reports are available on the reports and analytics page.

Setting realistic targets

1. Start from your own baseline: the last 12 weeks and the same period last year.
2. Set targets for drivers, not only results: “raise UPT from 2.5 to 2.7” is something staff can influence directly; “raise sales 10%” is not.
3. Make targets specific to the period: December and February are not comparable.
4. Limit targets to two or three KPIs at a time so the team can focus.
5. Review monthly and adjust when conditions change (a new competitor, roadworks, a supplier shortage).

Leading vs. lagging indicators

Some KPIs tell you what already happened (lagging); others warn you about what is likely to happen (leading). A balanced report contains both.

Lagging (results)	Leading (early warning)
Net sales	Visitors and conversion rate
Gross margin %	Discount rate; supplier cost increases
Inventory turnover	Sell-through of new deliveries
Shrinkage rate	Cycle count accuracy; unexplained adjustments
Lost sales	Stockouts of class A products

From KPI to action

If this happens…	Look at…	Possible actions
Sales down, traffic stable	Conversion rate, stockouts	Fix availability of best sellers; staff coverage at peaks
ATV down	UPT and average unit price	Bundles, add-on displays near the till, staff suggestions
Margin down	Category mix, discounts, supplier costs	Reprice, renegotiate, reduce blanket discounts — see margin vs markup
Turnover down	Slow movers, over-ordering	Markdown old stock; adjust reorder points
Shrink up	Count variances by category	Receiving checks, permissions, counts — see shrinkage prevention

Where the data comes from

Most of these KPIs come straight from your POS, provided the basics are recorded consistently. Sales, transactions, units, returns and payment methods come from the sales history. Cost of goods sold and margin need purchase prices recorded on deliveries. Turnover, sell-through and stockouts need reliable stock quantities, which depend on recording deliveries promptly and on regular cycle counts. Visitor numbers need a door counter, and staff hours come from your rota or payroll.

If one of these inputs is weak, fix it before relying on the KPI that uses it. A turnover figure built on inaccurate stock, for example, can send you in exactly the wrong direction.

Example: a 20-minute weekly review

Here is how a store owner might use the KPIs in practice, using the hypothetical store from this article. On Monday morning, the owner opens last week’s report. Net sales are slightly up on the same week last year, but ATV has dropped, while transactions are higher. UPT is down from 2.5 to 2.3, which explains most of the ATV change: customers are buying, but buying fewer items each.

The owner checks the stockout list and finds that two popular add-on products — the kind customers pick up at the counter — have been out of stock for five days. Gross margin by category is stable, so pricing is not the issue. The actions are clear: reorder the two add-ons with a higher reorder point, move them back to the counter display, and remind staff to suggest them. Next week’s report will show whether UPT recovers. The whole review took twenty minutes because the numbers pointed directly to a cause.

Common KPI mistakes

• Tracking too many numbers. Start with five or six and add more only when you act on them.
• Comparing with the wrong period. Compare with the same period last year, not just last week.
• Mixing tax-inclusive and tax-exclusive figures. Use net-of-tax sales everywhere.
• Ignoring data quality. Margin and turnover are only as reliable as your recorded costs and stock counts.
• Chasing generic benchmarks. Industry averages vary widely; your own trend is the most useful comparison.

Embedding KPI reviews in your weekly routine is covered in the retail store operations guide.

Frequently asked questions

Related guides

• Margin vs markup
• Retail store operations guide
• Retail inventory management guide
• Retail shrinkage prevention

Sources and further reading

• TGG Accounting — Retail KPIs (PDF)
• Martech Zone — GMROI
• Square — Retail metrics for smarter planning
• National Retail Federation — National Retail Security Survey 2023