Retail Lost Sales Analysis: Finding the Missed Sales Opportunity Store by Store

What lost sales analysis measures

The missed sales opportunity in a store is not the walk-ins who did not buy. Some were browsing, some were served badly, some were reconnaissance for a family decision, and some would have bought with one better answer. Lost opportunity analytics separates them, by counting what happened in the conversation: whether there was one, what the customer wanted, why they left, whether a number and a date were taken, and whether the follow-up brought them back.

The result is a number per store that a category head can act on: not "conversion is 30 percent", but "eleven recoverable sales a week are leaving this store at the follow-up stage, and six at the number stage".

The funnel, with worked numbers

Illustrative numbers for one durables store in one week. The stages are the ones a retailer can measure once conversations are captured with consent on the advisor's phone. Each row shows the count, the rate from the previous stage, and what a drop at that stage means.

Reading the funnel store by store

• The 38 unrecovered walk-ins are not equal. Around a third were tagged with a reason the store could have answered on the day, from the taxonomy at /learn/why-customers-dont-buy-in-retail-stores/. Those are the conversation leak, and the fix is coaching on the step that would have answered it.
• 18 non-buyers left without a number. At this store's recovery rate, that is roughly 7 sales a week lost at the number stage. That is the largest single leak in most stores measured for the first time.
• 4 numbers were never followed up. Small here, but it is the cheapest leak to close, because the follow-up is already drafted from the conversation and only needs sending.
• Coverage at 62 percent means 38 walk-ins are invisible. Some were served and not recorded, some were never approached. Until coverage rises, the funnel describes two thirds of the store, and the unattended third is often where the loss is largest.

Comparing stores

1. Group stores by footfall band and category mix. A metro flagship and a tier-two store leak in different places for different reasons.
2. Rank within the band on the rate at each stage, not on total sales. The store with the lowest number-taken rate in its band is the coaching visit; the one with the lowest coverage is the trust conversation.
3. Find the band's best rate at each stage and treat it as the target for the others. If one store in the band recovers 50 percent of numbers, 39 is not the ceiling.
4. Add the reason mix per store. Two stores with the same non-buying rate and different top reasons need different owners: finance desk in one, category team in the other. The per-store cut is described in the walkout guide at /learn/customer-walkout-analytics/.
5. Re-read monthly. The leak moves. Once the number stage is fixed, the follow-up stage becomes the constraint, and the analysis has to follow it.

Pricing the missed opportunity

The number the CFO wants is the recoverable revenue, and the funnel gives it honestly. In the worked store, raising the number-taken rate from 56 to the band's best of 75 percent would add about 8 numbers a week; at the store's 39 percent recovery rate that is 3 more sales a week, at the store's average ticket. Raising coverage from 62 to 80 percent adds 18 conversations a week to the funnel; at the store's overall 48 percent that is roughly 9 sales, though some of those visitors would have bought unattended anyway, so the honest figure is smaller.

Run the arithmetic per store, sum the band, and discount for the conversations that would have converted without any change. The pilot baseline calculator at /tools/pilot-baseline-calculator/ does this with your own walk-in, conversion and ticket numbers, and it is the right starting point for a pilot business case.

What POS and CRM cannot see

A lost sales report built from POS and CRM has a denominator problem and a reason problem. POS sees only buyers. The CRM sees the non-buyers an advisor chose to enter, with the reason the advisor chose, usually price, usually after the customer left. Neither sees the conversation that decided the outcome, and neither can say whether the number was asked for.

Borentis produces the funnel from consented conversations: the reason tagged from the customer's words, the number and date captured in the conversation, the follow-up drafted for a person to send, and the recovery matched to the visit. Customers stay anonymous in every report unless they gave a number to be contacted.