IMAS Analytics.AI
HomeSolutionsPeople counting & visitor analyticsXPERIO dashboardVisitor forecastingAI building energy managementIndustriesShopping mallsRetail chainsAirports & transport hubsOffice & commercial buildingsTry itProjectsInsightsAbout usPartnersContact us

DATA INTELLIGENCE

8 Retail Store KPIs to Review Every Week: Formulas, Meaning and Examples

Good retail store KPIs explain why sales went up or down this week. Sales are the end result, but they do not show the cause. A physical store therefore needs the figures that sit before sales: people passing the store, people entering, and the share who buy. This article brings together eight key performance indicators (KPIs) that store managers and area managers should review every week. Each one comes with a formula, what it tells you and a hypothetical example. It ends with a summary table and a weekly review routine.

Shoppers walking past a retail store in a shopping mall, with some turning in to enter

How the Eight KPIs Connect

Most of the KPIs in this article form a single chain.

Sales = passers-by × capture rate × conversion rate × average transaction value

When sales change, walk along this chain one step at a time. You will see whether the issue lies with the location, the store front, selling in the store or basket size. Dwell time, visitors per staff hour and sales per square metre then help explain why the chain looks the way it does.

Every example in this article uses hypothetical figures for the same store over one week. They are not data from any real store.

Starting data (hypothetical, per week) Value
Passers-by in front of the store 40,000 people
Store visitors 4,000 people
Sales transactions 600 receipts
Sales THB 540,000
Sales-floor staff hours 280 hours
Sales area 200 square metres

1. Store Visitors (Footfall)

Formula: inbound count at the store entrance from the people-counting system, with staff removed

What it tells you: the demand that actually reaches the store, whether or not those people buy. It is the denominator of several other KPIs. If this figure is off, the others will be off too.

Example (hypothetical figures): this week 4,000 people entered the store. The same week last year saw 4,400, a drop of about 9%. Before concluding that the store is doing worse, check whether the whole mall fell too. If the mall dropped by a similar amount, the problem may not be the store.

For how footfall figures are used at shopping-mall level, see What Is Footfall?

2. Passers-by and Capture Rate

Formula: capture rate (%) = store visitors ÷ passers-by in front of the store × 100

Capture rate is the share of people walking past the store who turn in. The passer-by count shows the potential of the location. Capture rate shows how well the store front, displays and products visible from the walkway are working.

Example (hypothetical figures): 40,000 passers-by and 4,000 visitors give a capture rate of 4,000 ÷ 40,000 × 100 = 10%. If the window display changes the next week and the figure rises to 12% while passers-by stay about the same, the new store front is drawing people in better.

Worth knowing: passers-by must be measured on the walkway in front of the store, not at the mall entrance, and with the same method every week.

3. Conversion Rate

Formula: conversion rate (%) = sales transactions ÷ store visitors × 100

What it tells you: how well the store turns people who walk in into buyers. It reflects selling inside the store, such as whether there are enough staff, whether products are in stock and whether the checkout queue is long.

Example (hypothetical figures): 600 receipts ÷ 4,000 visitors × 100 = 15%

The full formula, the mistakes that distort it and how to read it by hour are covered in How to Calculate Conversion Rate for Physical Stores

4. Average Transaction Value

Formula: average transaction value = sales ÷ sales transactions

What it tells you: how much each buyer spends on average, also called average basket or average receipt value. It moves with add-on sales, product bundles and recommending higher-value items.

Example (hypothetical figures): THB 540,000 ÷ 600 receipts = THB 900 per receipt

Worth knowing: price promotions often raise the number of receipts but lower the average transaction value. Always read the two together.

5. Sales per Visitor

Formula: sales per visitor = sales ÷ store visitors, which equals conversion rate × average transaction value

What it tells you: the average value of each person who walks into the store. It combines conversion rate and average transaction value in one figure, which makes it well suited to comparing stores of the same type.

Example (hypothetical figures): THB 540,000 ÷ 4,000 visitors = THB 135 per visitor. You can check this with 15% × THB 900 = THB 135.

If sales per visitor falls, check whether conversion rate or average transaction value caused it. The two call for different fixes.

6. Dwell Time in Store

Formula: the time from when a customer enters the store until they leave, reported as an average and a median from a people-counting system that tracks movement anonymously

What it tells you: how long customers spend with the store. Read it alongside conversion rate, because a long stay can mean interest in the products, or it can mean waiting for staff or queuing.

Example (hypothetical figures): this week's median is 9 minutes, against an average of 7 minutes over the previous four weeks, while conversion rate is flat. The team then looks at the hourly data to see whether the longer stays happen at busy times.

How to measure it, and a four-box table for reading it, are in What Is Dwell Time in Malls and Stores?

7. Visitors per Staff Hour

Formula: visitors per staff hour = store visitors ÷ sales-floor staff hours in the same period

What it tells you: the workload per staff hour. A figure that is too high means staff cannot keep up with customers. A figure that is too low means hours are scheduled when the store is quiet.

Example (hypothetical figures): 4,000 visitors ÷ 280 hours ≈ 14 visitors per staff hour. A weekly average often hides very different periods. If the hourly breakdown shows 30 on Saturday afternoon but only 6 on Tuesday morning, that is a signal to move hours, not necessarily to add hours overall.

Some chains also track sales per staff hour alongside it. How to turn visitor counts into a shift plan is covered in Retail Staff Scheduling Based on Real Customer Numbers

8. Sales per Square Metre

Formula: sales per square metre = sales ÷ sales area (square metres) in the same period

What it tells you: how productive the store's floor space is. Use it to compare stores of different sizes, to decide whether to expand or shrink space, and in rent discussions with the mall, which usually prices rent per square metre already.

Example (hypothetical figures): THB 540,000 ÷ 200 square metres = THB 2,700 per square metre per week

Worth knowing: use the same definition of sales area for every store, for example whether stockrooms and fitting rooms are included. If definitions differ, the figures cannot be compared.

Summary Table of the 8 Retail Store KPIs

KPI Formula Data needed Example (hypothetical) Question it answers
1. Store visitors (footfall) Inbound count at the store entrance, minus staff People-counting system 4,000 people How many people reach the store?
2. Passers-by and capture rate Visitors ÷ passers-by × 100 People counting on the walkway and entrance 10% How well does the store front draw people in?
3. Conversion rate Receipts ÷ visitors × 100 People counting + point-of-sale (POS) system 15% How well are visitors turned into buyers?
4. Average transaction value Sales ÷ receipts POS system THB 900 How much does a buyer spend on average?
5. Sales per visitor Sales ÷ visitors People counting + POS system THB 135 What is one visitor worth?
6. Dwell time in store Entry to exit time (median) Movement-tracking sensors 9 minutes How long do customers spend with the store?
7. Visitors per staff hour Visitors ÷ staff hours People counting + shift roster 14 people Is staffing in line with customers?
8. Sales per square metre Sales ÷ sales area POS system + floor plan THB 2,700 How productive is the space?

Check consistency with the main chain: 40,000 × 10% × 15% × THB 900 = THB 540,000

A Weekly KPI Review Routine

KPIs are useful when you review them regularly and in the same order every time. The routine below works for a single store or a multi-store chain.

1. Check data quality first Look for hours where the visitor count is zero or unusually high, for example a sensor fault or restocking work that inflates staff counts. Also check that the clocks of the people-counting system and the POS system still match. If there is a data problem, note it before reading any other figure.

2. Compare against a fair baseline Compare with the average of the previous four weeks and with the same week last year. Check whether long weekends, payday or major promotions fell in different weeks.

3. Walk the main chain from start to end Start with passers-by → capture rate → conversion rate → average transaction value. Find the first figure that changed the most. That is where to look next.

4. Drill into days and hours only where something looks unusual There is no need to open every hour of every day. Pick only the periods where figures moved, then check dwell time and visitors per staff hour for those periods.

5. Talk to the store team The figures show what happened, where and when, but not why. The store team often knows the reason, such as stock-outs, staff on leave or a promotion at the store next door.

6. Choose one or two actions, each with an owner For example, move staff hours to Saturday afternoon or change the window display. Write down which KPI will show whether it worked.

7. Follow up last week's actions Open what was agreed last week and check whether the chosen KPI moved as expected. If it did not, go back to step 3.

Example table for the weekly meeting (hypothetical figures)

KPI This week Average of previous 4 weeks Change
Passers-by 40,000 41,000 Slightly down
Capture rate 10% 10% Flat
Conversion rate 15% 17% Down
Average transaction value THB 900 THB 880 Flat
Dwell time in store (median) 9 minutes 7 minutes Up
Visitors per staff hour 14 13 Flat

In this table, the first figure in the main chain that clearly changed is conversion rate, while dwell time got longer. The team's working hypothesis is that customers are waiting longer at certain times, so they check the hourly data next.

Common Mistakes When Using Retail KPIs

  1. Looking at sales alone Flat sales can hide falling visitor numbers and an improving conversion rate, which need different responses.
  2. Setting targets from figures read elsewhere Every KPI varies widely by product category, store size and location. The best baseline is the store's own history and stores of the same type.
  3. Changing definitions midway For example, changing how staff are removed or which sales area is used makes comparisons with the past impossible.
  4. Looking only at weekly averages Averages hide the periods where the store loses sales. Drill down by hour when something looks unusual.
  5. Having KPIs but no actions A meeting that ends without something to try next week turns the figures into just a report.

How IMAS Helps Measure Retail Store KPIs

Shopper carrying a basket of items while browsing aisles in a retail store

Six of the eight KPIs need data from a people-counting system, so a store first needs accurate, continuous visitor counts.

  • 3D people counting Ceiling-mounted sensors count entries and exits by direction in real time, track dwell time, and are designed to count without identifying individuals.
  • XPERIO dashboard Shows passers-by, capture rate, dwell time, occupancy and conversion rate when connected to sales data. It compares daily to yearly and across stores, and has an AI assistant you can ask in everyday language to explore trends and compare stores.
  • Visitor forecasting Uses the platform of Retail Insight from Norway to forecast customer numbers up to 8 weeks ahead from historical visitor counts, sales, seasonality and weather. It helps plan staff hours so that KPI 7 stays in the right range.

The systems pull the figures together and point to where to look first. Decisions on shifts, store fronts or products stay with the store managers who know the local context. For chains with many stores, see Solutions for Retail Chains

Frequently asked questions

−Which retail KPI matters most?

No single KPI is enough. If you need to start with a few, begin with store visitors, conversion rate and average transaction value, because multiplying them gives sales. Add the others when the data is ready.

+What is capture rate?

It is the share of passers-by who enter the store, calculated as store visitors divided by passers-by, times 100. It measures how well the store front and displays draw people in from the walkway.

+How is average transaction value different from sales per visitor?

Average transaction value divides by the number of receipts, so it shows what a buyer spends on average. Sales per visitor divides by the number of store visitors, so it includes people who did not buy and shows the average value of each person who walks in.

+Should KPIs be reviewed daily or weekly?

Review weekly to see trends and make decisions, then drill into daily or hourly data only where something looks unusual. Reviewing every KPI daily often leads to overreacting to normal fluctuations.

+How many KPIs can a store track without a people-counting system?

Only those that come from the POS system: average transaction value and sales per square metre. The other KPIs need visitor or passer-by counts, which require a people-counting system.

Want to see every store's KPIs on one screen?

The IMAS team helps set up people counting, connect sales data and configure dashboards that store and area managers can use for their weekly review. Details and costs are provided in a quotation.

Book a system demo · See the XPERIO dashboard

References

  • CountMatters AS. Use cases: Capture rate, Conversion rate, Dwell time. countmatters.com
  • Retail Insight AS (Norway). 3 metrics every store manager should keep an eye on, and forecasting platform information. retailinsight.no