Footfall, conversion, basket value and profit answer different questions
A shop can grow visitor traffic while losing money if fewer visitors purchase or gross margins shrink. Footfall counts entrances or visits rather than necessarily unique people. This tool defines conversion as visits resulting in a purchase divided by store visits. It then translates converted visits into basket revenue, deducts returns, calculates variable contribution and subtracts fixed costs.
Keep the denominator consistent
When using door-counter data, one visitor who enters twice may appear as two visits. When using digital analytics, sessions, users and purchase events are different denominators. Do not compare a GA4 purchaser-rate metric directly with physical entrance conversion without adjustment. If group visits are counted as one transaction, consider the implications for basket value and units per sale.
Revenue and contribution waterfall
Gross billing equals purchasing visits × average gross transaction basket. Net sales reduce this by estimated refunds and returns. Cost of goods sold and other variable selling expenses apply to net sales. The model also subtracts payment or handling charges per converting visit, even if that visit later results in a return. Contribution is therefore net revenue minus its variable costs and transaction costs; operating surplus then subtracts rent, permanent payroll and other fixed expenses.
Worked example — retail outlet
Consider 12,500 counted visits and 700 purchasing visits, a 5.6% conversion rate. An average ₹1,800 basket yields ₹12,60,000 gross billings. After 5% refunds, net sales are ₹11,97,000. At 48% COGS, 8% other variable costs, and ₹12 handling per purchasing visit, store contribution is ₹5,18,280. Deduct ₹4,20,000 fixed costs to obtain ₹98,280 indicative operating surplus.
What happens at a 7% conversion target?
With unchanged 12,500 visits, 7% conversion implies 875 purchasing visits. The same ₹1,800 basket, return and cost assumptions lead to a scenario surplus of ₹2,27,850, or ₹1,29,570 more than the current case. This uplift is not a forecast. It requires observed data showing that the target is feasible without higher sales-associate costs, checkout congestion, markdowns, stockouts or processing charges.
Understand the break-even conversion measure
The model estimates contribution per purchasing visit after returns, variable costs and transaction handling. Break-even purchasing visits are the smallest whole number whose contribution covers fixed store costs. Divide by total visits to obtain a required conversion rate. A result above 100% is mathematically computed but operationally impossible with one purchasing transaction per visit; it signals the need to improve baskets, unit margin, fixed costs or footfall quality.
Do not confuse marketing attribution with physical visits
Online advertising platforms may attribute purchases to clicks or views that occur before the in-store visit. If you merge that data with physical footfall, remove duplicates and reconcile the attribution window. A campaign with high online conversion can have weak incremental store contribution after discounting and payment fees. Compare campaign-specific performance using incremental contribution rather than gross revenue.
What this simplified model excludes
The scenario holds basket size, refund percentage, cost ratios and store capacity constant, and assumes one purchase per converting visit. It does not compute GST, statutory accounting profit, exact inventory depletion, multi-visit attribution, shift staffing step costs, shrinkage, loyalty points or financing. Validate with POS and counter data before using the result for a lease renewal or marketing budget.
Improve the reliability of store traffic measurement
Verify the counter location, hours of operation, counting methodology and treatment of staff entrances or repeated visits. If employees pass through the sensor repeatedly, customer footfall is overstated and the conversion rate appears artificially weak. If the till groups separate parties into one transaction, the relationship between purchasing visits and basket size requires a consistent definition. Compare the visit records with POS bills and refund events for exactly the same dates and store hours. Record promotions, exceptional opening hours, major holidays and out-of-stock days to distinguish an execution problem from an unusual trading period. A small store should prioritise reliable measurement over impressive-looking dashboards.
When a conversion target does not translate into profit
Suppose promotions increase conversion but lower the average paid basket, increase refunds or encourage costly payment methods. The constant-cost scenario would overstate the likely gain. Before budgeting a marketing or merchandising initiative, model the lowest credible basket, an elevated return rate and extra employee-hours at peak traffic. Contribution should be based on net realised sales, not the headline price printed on the ticket. Unit economics may vary between categories and online/in-store collection orders. The result is most useful for testing assumptions and flagging which input should be validated, not for asserting that a 1.4 percentage-point uplift will inevitably materialise.
Operational action plan for store teams
Break the purchasing journey into entry, product discovery, fitting or trial, queueing and payment. Check availability of the best-selling sizes, the percentage of visitors served promptly, customer service capacity and reasons for walkouts. Trial one change at a time where practical; compare similarly timed weeks and similar stores, adjusting for footfall mix. Sales managers can use the calculator in weekly reviews: enter verified traffic, converting visits, average basket, refunds and current cost rates; record whether the implied improvement appeared in actual contribution. Finance should separately analyse shrinkage, landlord charges, utilities, inventory financing and the store cash cycle before treating operating surplus as free cash flow.
Frequently asked questions
Can I use these sample percentages as industry benchmarks?
No. Defaults are hypothetical and must be replaced with your business figures, contracts and recorded performance.
Are results audited financial statements?
No. These are scenario calculations excluding statutory tax determinations and accounting journal entries.
Does a positive modelled surplus mean cash is available?
Not necessarily. Timing of collections, indirect taxes, capex, debt service and deposits can change cash flow separately.
What should I check when the result looks surprising?
Reconcile source denominators, check the gross-versus-net basis, inspect the bridge row by row, and use a conservative scenario before taking action.
Official sources and further reading
Sources explain the calculation conventions and rules referred to above. Notifications and standards change; confirm on the official site before you file, book or advise.
Educational working tool. Results follow the scope and assumptions described on this page and the figures you enter; they are not accounting, audit, tax, legal, investment or financing advice. Treatment depends on facts, contracts and the law or standard in force for the relevant period, so reconcile to your records and consult a qualified professional before you rely on a result.