Decision software for grocery chains

How to calculate basket size, conversion and sales per square metre

Last updated: 5 October 20268 min read

Who it is forStore managers, grocery chain operations directors, area managers

When store sales fall, the first question asked is usually the wrong one: "what should we do". The right question is "what fell". Sales are the product of three factors and the fix for each is completely different: if fewer people come, the problem is outside the store; if those who come do not buy, it is inside; if buyers spend less, it is in the product. This guide separates the three factors, adds the space and rent metrics and sets out the order to intervene in.

Splitting sales into three factors

In retail, sales are not one number but the product of three. Without that split, three completely different remedies get proposed for the same revenue decline and nobody knows which one is right.

Footfall is about the outside of the store: location, window, weather, competing stores nearby, weekly specials and campaign communication. Conversion is about the inside: staffing, availability, open checkouts, queues. Basket size is about the product: price level, cross-selling, assortment mix.

Tracking all three together is the highest-return reporting investment in store retail. In a store with no people counter, conversion cannot be calculated and all you are left with is revenue.

Net sales (identity)
Footfall × Conversion rate × Average basket
Average basket
Net sales ÷ Transactions
Conversion rate
Transactions ÷ Footfall × 100
Units per transaction (UPT)
Total units sold ÷ Transactions
Average unit retail
Net sales ÷ Total units sold

How to lift basket size

Basket size itself splits into two factors: units per transaction and average unit retail. Which of them fell determines what the intervention should be.

If units fell, the problem is in cross-selling: the customer buys one item and leaves. The fix is product adjacency, complementary recommendations and the queue-line layout. If average unit retail fell, the problem is in the mix: customers have moved to the cheaper end, or the share of marked-down goods has grown.

Confusing the two is expensive. Responding to a fall in average unit retail with a cross-sell campaign means trying to sell more items to a customer who has already become price-sensitive, and it does not work.

  • Units ↓, unit retail flat → cross-selling and adjacency problem
  • Units flat, unit retail ↓ → the mix has shifted to the cheaper end
  • Both ↓ → the customer profile has changed; this needs a serious diagnosis
  • Units ↑, unit retail ↓ → discounting is working but eating margin; check effective margin

Space and rent: does the store stand up

Sales and margin figures say nothing about a store's cost structure. If one store sells twice as much as another while paying three times the rent, the higher revenue is bad news.

Sales per square metre makes that correction and is the base measure for comparing stores. Only selling area goes in the denominator; stockroom, office and staff areas do not count.

The rent ratio is the sustainability test. There is no single right ratio: the rent ceiling is found by deducting labour, other costs and the target operating profit from gross margin. As the margin structure rises so does the rent that can be carried, so the threshold should be scaled to gross margin.

Sales per square metre
Net sales ÷ Selling area (m²)
Gross profit per square metre
Gross profit ÷ Selling area (m²)
Rent ratio
(Rent + Service charge) ÷ Net sales × 100
Rent ceiling
Gross margin − Labour ratio − Other cost ratio − Target operating profit ratioAll as a percentage of net sales; the same method as the rent-to-sales ratio KPI.
Two stores, same revenue, different reality
Store AStore B
Net sales₺1,000,000₺1,000,000
Selling area250 m²420 m²
Sales per m²₺4,000₺2,381
Annual rent₺120,000₺185,000
Rent ratio12.0%18.5%
Gross margin38%38%
Labour + other costs + target profit27%27%
Rent ceiling (38 − 27)11.0%11.0%
Assessment1 point above the ceiling7.5 points above the ceiling

The order to intervene in

Once the metrics are measured, the intervention follows. The order matters: improvement done in the wrong sequence produces a cost with no visible result.

  1. Check conversion firstConversion is the cheapest factor to improve: the customer is already in the store. Look at availability, staff positioning and queue times.
  2. Then split the basketDid units fall or did average unit retail? The two have different fixes and confusing them wastes the campaign budget.
  3. Work on traffic lastTraffic is the most expensive factor to improve because it requires spend outside the store. Driving traffic while conversion is weak simply means more people leaving without buying.
  4. Review space productivity annuallyIn stores with low sales per square metre, look at the space allocation between departments first, then at renegotiating the rent.

Advertising spend while conversion is low is pouring water into a leaking bucket. The order is always from the inside out.

Frequently asked questions

How is average basket size calculated?
Net sales are divided by the number of transactions. A store with ₺1,000,000 net sales and 12,500 receipts has an average basket of ₺80. Basket itself splits into units per transaction and average unit retail.
Which metric should be checked first when sales fall?
Split traffic, conversion and basket first. If traffic fell the problem is outside the store; if conversion fell it is inside; if basket fell it is in the product. Without that split, whatever you do is guesswork.

Let us build this calculation on your data

Knowing the formula is not enough; the data has to sit at the right grain. Our team does the installation. We will go through your current setup together in 30 minutes.