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

DATA INTELLIGENCE

How to Compare Sales Across Branches Fairly: Using Visitor Data and Per-Area, Per-Visitor Metrics

Comparing sales across branches is a monthly task for every retail chain manager, yet a table that ranks branches by total sales is rarely fair. A large branch in a shopping centre will always sell more than a small neighbourhood store. A branch in a transport hub sees heavy traffic but small baskets. To know which branch is truly "performing", you need to break sales into its parts, use metrics divided by floor area, visitors or staff hours, and compare only branches that belong together. This article walks through the method step by step, with an example using hypothetical figures.

How to Compare Sales Across Branches Fairly With Footfall

Why Total Sales Cannot Be Compared Directly

Total sales show which branch brings in the most money, but not how well that branch uses the opportunity it has. Two branches can differ in many ways that the store team cannot control.

What differs Example How to adjust for it
Sales floor area One branch is several times larger than another Divide by sales area
Number of people reaching the store A store in a large mall versus one in a neighbourhood Divide by store visitors
Location type Shopping centre, street front, transport hub, airport Group branches by location before comparing
Opening hours and staffing One branch opens longer or has more staff Divide by staff hours
Branch age A newly opened branch versus one open for years Separate new branches, or compare each with its own history
One-off events Refurbishment, temporary closure, a major mall event Exclude that period, or flag it

Ranking on total sales alone makes the managers of large branches look strong every time, while a small branch that performs well goes unnoticed. That affects target setting, rewards and investment decisions.

Break Sales Into Parts Before Comparing

Sales in a physical store can be split into three parts.

Sales = store visitors × conversion rate × average transaction value

  • Store visitors (footfall) depend mainly on location, storefront visibility and marketing
  • Conversion rate depends on products, staff, queues and store layout
  • Average transaction value depends on merchandising, pricing and product recommendations

Once split, you can see that a branch with low sales may have no selling problem at all, just fewer people arriving. Or the opposite: a high-sales branch may be losing many of the customers who walk in. The part you cannot separate without a people-counting system is store visitors, because the point-of-sale (POS) system only knows the number of receipts, not how many people came in and left without buying. See the formulas and meaning of each metric in 8 retail store KPIs and conversion rate for physical stores.

Metrics That Compare Branches More Fairly Than Total Sales

Each metric "adjusts" for a different kind of difference, so look at several together rather than picking one.

Metric Formula What difference it adjusts for Watch out for
Sales per square metre Sales ÷ sales area Store size Every branch must use the same definition of sales area
Sales per visitor Sales ÷ store visitors The number of people the location delivers Visitors must be counted the same way at every branch
Conversion rate Receipts ÷ store visitors × 100 The number of people the location delivers Locations where people browse briefly, such as stations, run lower by nature
Average transaction value Sales ÷ receipts The number of customers who buy Different product ranges across branches make this hard to compare
Visitors per staff hour Store visitors ÷ staff hours Staffing and opening hours Use it to see whether staffing matches customers, not to judge who works harder
Sales per staff hour Sales ÷ staff hours Staffing and opening hours An understaffed branch looks good on paper while losing real customers
Capture rate Store visitors ÷ passers-by × 100 Traffic volume at the location Only usable where passers-by can be counted, such as stores inside malls

"Per visitor" metrics show how well a branch uses the customers who arrive. "Per area" metrics show whether the space you pay rent for is earning its keep. The two groups answer different questions and can rank branches very differently.

Group Branches Before Comparing

Even with per-area and per-visitor metrics, very different branches are still hard to compare. The usual approach is to put branches into similar groups (peer groups) and compare within each group.

  • By location type, such as large shopping centre, community mall, street front, transport hub
  • By store size, for example bands of sales area
  • By store format, such as full-format, small-format or outlet stores
  • By branch age, separating branches open less than a year, because they have no prior-year baseline

The groups do not need to be detailed. Two to four groups are enough to start. What matters is that everyone in the organisation uses the same grouping and changes it only when necessary.

Use One Set of Definitions for Every Branch

Figures can only be compared when they are measured by the same rules. These are the points that often differ without anyone noticing.

  1. The entrance counting line. Stores with several entrances must count all of them and combine them into one figure
  2. Staff exclusion. If one branch removes staff from the count and another does not, the figures differ for reasons unrelated to customers
  3. Group counting. A family entering together usually makes one purchase. If some branches count individuals and others count groups, conversion rates cannot be compared
  4. Sales area. Agree whether stockrooms, fitting rooms or storefront space are included
  5. Sales counted. Agree whether online orders collected in store are included, and how returns are deducted
  6. Opening hours. Use only data from the hours the store is actually open
  7. Counting technology. If branches use different types of devices, their error levels may differ. Validate counting accuracy at every branch with the same method. See how the technologies differ in comparing people-counting technologies

Write these definitions down in one short document and apply it to every branch and every report. If a definition must change mid-year, note it, because figures before and after the change cannot be compared directly.

Compare Each Branch With Itself First, Then With Others

Comparing a branch with itself in the same period last year (like-for-like) removes almost all differences in location and size, because it is the same store in the same place. An easy way to do this is to turn it into an index.

Index = this period's value ÷ same period last year × 100

Example (hypothetical figures): a branch had 22,000 visitors this month and 20,000 in the same period last year. The index is 110, meaning visitor numbers rose by one tenth on last year. Once every branch is converted to an index, they can be ranked side by side within their group, regardless of which branch is larger or smaller.

Watch out for long holidays and festivals that move dates each year. Compare periods with matching holidays, or compare by the same day of the week. For periods when a branch runs a special activity, see how to separate its effect in measuring campaigns and events in shopping centres

Example: Three Branches, Three Answers (Hypothetical Figures)

A retail chain has three branches. One week of data looks like this.

Branch A, large shopping centre Branch B, community mall Branch C, transport hub
Sales (THB) 810,000 432,000 300,000
Sales area (sq m) 250 120 80
Store visitors 6,000 2,400 5,000
Receipts 900 480 500
Staff hours 400 200 250
Sales per sq m (THB) 3,240 3,600 3,750
Conversion rate 15% 20% 10%
Average transaction value (THB) 900 900 600
Sales per visitor (THB) 135 180 60
Visitors per staff hour 15 12 20

On total sales, Branch A is clearly ahead. Look at the other metrics and the story changes.

  • Branch A sells the most but has the lowest sales per square metre. The questions to ask are whether the space is larger than needed, and which parts of it are not earning their keep
  • Branch B has the fewest visitors but converts them into buyers best and has the highest sales per visitor. The thing to look at is getting people to the store, such as storefront visibility and local marketing, not selling inside the store
  • Branch C has the highest sales per square metre, but low conversion and low transaction value, which is normal for a location where people drop in quickly. It also has the highest visitors per staff hour. Check whether there are enough staff at peak times, and compare it with other transport-hub branches rather than with Branch A

No branch is "best" on every metric, and each has a different issue to fix. This is why a total-sales table on its own can lead to the wrong decisions.

What to Do After Reading the Results

What you see What to check Who to talk to
Visitors fall, conversion holds steady Location, storefront visibility, marketing, mall activity Marketing, store development team
Visitors hold steady, conversion falls Out-of-stocks, too few staff at peak, checkout queues, pricing Branch manager, operations
Good conversion but low transaction value Merchandising, product recommendations, range available in the branch Merchandising, branch manager
Consistently low sales per sq m Store size, layout, rent versus return Store development team, management
Very high visitors per staff hour at certain times Shift schedules do not match when customers arrive Branch manager

Data shows where to start asking questions. The people who know the answers are branch managers and their teams. A good branch review therefore starts with the figures, then listens to the branch's explanation, before agreeing on what to try next. For staffing shifts to customer numbers, see scheduling store staff from real customer numbers

Common Mistakes When Comparing Branches

  1. Ranking on a single metric. Every metric has blind spots. Look at at least one per-area and one per-visitor metric
  2. Comparing across location types without grouping. A transport-hub branch will always look weak on conversion next to a mall branch
  3. Visitor counts of uneven quality. A branch with an inaccurate counter shows a conversion rate that is too high or too low. Validate counting at every branch regularly
  4. Using the chain average as every branch's target. The average of a similar peer group, and the branch's own history, are better baselines
  5. Looking only at monthly figures. Problems that occur only in certain hours or on certain days disappear in a monthly figure
  6. Using figures to blame rather than to find causes. If branches fear the numbers, data gets explained defensively instead of helping find solutions

Compare Every Branch on the Same Definitions With IMAS

Fair branch comparison starts with visitor counts measured the same way at every branch, combined with sales in one place.

  • 3D people counting mounts on the ceiling, counts people entering a space in real time and tracks time spent in the space, without identifying individuals. The same counting method can be used at every branch
  • XPERIO dashboard shows passers-by, capture rate, time spent in the space, occupancy and conversion rate when connected to sales data. It compares daily to yearly and across branches, has a portfolio view that ranks branches by change, and includes an AI assistant you can ask in everyday language to explore trends and compare branches
  • Visitor forecasting uses the platform of Retail Insight from Norway to track customers per hour, sales per hour, and planned versus actual staff hours, so branch teams, regional teams and head office see the same figures, with the store manager making the final decision

The system brings figures onto one set of definitions and shows which branches to look at first. Decisions on space, staffing or products remain with executives and branch managers who know the context. See the overview for retail chains on the multi-branch retail solutions page

Frequently asked questions

−Which metrics should I use to compare sales across branches?

Look at several together: at least one per-area metric, such as sales per square metre, and one per-visitor metric, such as conversion rate or sales per visitor. Then compare within groups of branches with similar locations and sizes.

+Can I compare branches without a people-counting system?

Partly. Sales per square metre and average transaction value can be calculated from the POS system, but you will not know whether differences in sales come from the number of people arriving or from selling in the store, and those need different fixes.

+How is sales per square metre different from sales per visitor?

Sales per square metre shows whether the space is worth it. Sales per visitor shows how well the branch uses the customers who arrive. The same branch can be strong on one and weak on the other.

+What is like-for-like?

It compares each existing branch with itself in the same period last year, excluding newly opened branches and branches closed for refurbishment, so you see change that does not come from adding or removing branches.

+Can I compare branches that use different brands of people counters?

Yes, if counting accuracy at each branch is validated with the same method and the same definitions are used, such as staff exclusion and group counting. If error levels differ widely, per-visitor metrics will be skewed.

Want to See Every Branch on the Same Definitions?

The IMAS team helps plan counting points, set metric definitions and configure dashboards so branch teams and head office see the same figures. Details and costs are provided in a quotation.

Book a system demo · See multi-branch retail solutions

References

  • CountMatters AS. XPERIO analytics platform: People Counting, Footfall Analytics and retail use-case pages. Website countmatters.com
  • Retail Insight AS. Retail productivity platform. Website retailinsight.no
  • Xovis AG. Retail solutions. Website xovis.com