Retail Analytics: 10 Metrics Every Store Should Track Weekly

Retail analytics is not about having more data — it is about acting on the right data weekly. The best store operators we work with track ten metrics every Monday morning, in a 30-minute review, and adjust the week’s plan accordingly. That short, disciplined cadence is what separates great stores from average ones. This guide lists the ten metrics, explains why each matters, and shows the action each one is meant to drive.

1. Store traffic

The number of people who enter the store. Captured by door counters, cameras, or Wi-Fi sensors. Traffic is the top of the conversion funnel — without it, no other metric matters. Track week-over-week and year-over-year. Falling traffic is almost always a marketing, location, or category issue, not a store-execution issue.

2. Conversion rate

Transactions divided by traffic. The single most leveraged store-execution KPI. Specialty retail typically runs 20 to 30 percent; mass retail 50 percent or higher. A two-point conversion improvement is often worth 10 percent revenue lift without any additional traffic. Coach staff on greeting, fitting room behavior, and closing techniques.

3. Average transaction value (ATV)

Revenue divided by number of transactions. Driven by units per transaction (UPT) and average unit retail (AUR). A weekly ATV review should always include the underlying UPT and AUR — they help diagnose whether ATV moved because of price or because of basket size.

4. Units per transaction (UPT)

Units divided by transactions. The cleanest single measure of attach and upsell discipline. UPT is highly coachable — store managers who target UPT improvements with their teams typically see lift within two to four weeks.

5. Average unit retail (AUR)

Net sales divided by total units. Captures pricing and mix. A falling AUR with stable UPT signals heavy markdowns or trade-down to lower-priced SKUs.

6. Sell-through rate

Units sold divided by units received in a defined window — usually 4 to 8 weeks for fashion, longer for non-seasonal categories. Sell-through is the merchandiser’s primary signal of assortment performance. Below 50 percent at week 8 in apparel typically signals a buy that needs aggressive markdown action.

7. Gross margin

See our gross margin guide for the full breakdown. At the store level, gross margin should be tracked weekly because markdown and shrinkage move it in short windows.

8. Labor cost percent

Total labor cost divided by net sales. Most retailers target 8 to 12 percent. Spikes typically reflect overscheduling during low-traffic windows. Use labor cost percent together with sales per labor hour for a complete view.

9. Basket attach rate

Percent of transactions that include an attached add-on (a charger with a phone, socks with shoes, a warranty with electronics). Attach rate is one of the easiest ways to raise both UPT and gross margin simultaneously.

10. Inventory position

Weeks of supply by category. Tracks the balance between safety, freshness, and capital. Falling weeks of supply in best-sellers signals impending stockout; rising weeks of supply in laggards signals impending markdown. Both require action.

How the Monday review works

Every Monday morning the store manager (or district manager) reviews the previous week’s ten metrics in a single 30-minute meeting with the lead team. The format is consistent: green/yellow/red status on each metric, root cause discussion on any red, and two to three specific actions for the week. No more than three actions — the goal is execution, not analysis.

Common analytics mistakes

1. Drowning in metrics

Stores tracking 30+ KPIs end up acting on none. Ten is the sweet spot for weekly operating cadence.

2. Lagging vs. leading

Sales is a lagging indicator. Traffic, conversion, attach are leading indicators. Spend more time on the leading indicators.

3. Comparing the wrong things

Week-over-week comparisons are misleading during holidays or promotions. Year-over-year, with calendar alignment, is the right reference frame for most metrics.

4. Acting too slowly

A weekly cadence is the slowest cadence that still allows mid-quarter correction. Stores that wait for monthly reviews miss the chance to act.

The bottom line

Great retail analytics is not about complexity — it is about cadence. Ten metrics, every Monday, with clear ownership and two to three actions per week. That simple discipline outperforms any sophisticated analytics platform that no-one opens. Use our free retail calculators to support the math behind these metrics and start your Monday review next week.