Measuring Visual Merchandising ROI: Formula, Attribution & Worked Example

The ROI formula, and why footfall is not it

ROI = (attributed revenue − campaign cost) ÷ campaign cost. The formula is simple; the discipline is in the attribution, because without a way to trace a sale back to the campaign, the numerator is a guess.

Footfall is the wrong primary metric because it counts people who walked past, not people who engaged — and the two diverge most at exactly the high-traffic venues that cost the most to book.

A retail store can show thousands of contacts on a report and still produce very few leads if nobody trained the team to ask for a number before the conversation ends; a smaller, quieter venue with a disciplined team can out-convert it on leads while showing a far less impressive contacts line. Judging the two venues on contacts alone would rank them backwards.

The funnel, with real shares

Four figures govern how a contact becomes a sale, and all four are planning ranges, not promises.

The table below uses the mid-point of each range so there is one concrete set of numbers to follow through the rest of this page — the section further down shows what changes at the pessimistic end of the same ranges.

Each stage below depends on the one before it rather than on the original contacts figure directly, which is why a shortfall early in the funnel compounds rather than simply subtracting — a 10% miss on leads is not a 10% miss on sales, it is closer to a 10% miss multiplied through two further stages.

Worked example: cost per outcome down the funnel

Using the same 15-day pilot as the pricing and planning pages for this service, here is what each stage costs.

Reporting all three figures together, rather than only the cheapest-looking one, is what makes this table useful in a budget meeting instead of just reassuring.

Completing the formula with your own one missing number

The only input this page cannot supply is average order value, because it depends on your own price list, not on anything in a BTL rate card. With that one number supplied by you, the formula from the top of this page becomes concrete using the figures already computed above.

ROI = (sales × average order value − campaign cost) ÷ campaign cost. Substituting this pilot's own numbers: (24 × average order value − ₹2,16,750) ÷ ₹2,16,750. Whatever average order value turns out to be for your product, that is the entire calculation — nothing else in it is a variable.

What happens at the low end of the range

Every figure above used the mid-point of its range. Real campaigns do not reliably land on the mid-point, so it is worth seeing what the same pilot looks like if venue response, lead rate, qualification and conversion all come in at the low end of their ranges at once — the pessimistic case, not the likely one.

Manpower cost does not move in this comparison, because it is a fixed day rate rather than a band; only the venue fee and the funnel shares shrink.

How to attribute a sale to the campaign

None of the numbers above mean anything in a real report unless a sale can be traced back to the specific venue and day that produced the lead.

Attribution set up after the campaign has already started is attribution that is missing data for every day before it was switched on, so this step belongs in the planning phase, not the first week of execution.

• Give every venue and team a unique QR code or coupon code, never a shared one
• Tag every captured lead with a source field in the CRM before the first follow-up call
• Re-check attribution at both 30 and 60 days — leadToSaleRate assumes a window, not a single-day snapshot
• Keep a geo-tagged, time-stamped photo log so a disputed attribution can be checked against who was actually on site that day
• Agree the attribution window and method with the sales team before go-live, not after the first disputed lead

What a credible report includes

A report built to survive scrutiny looks different from one built to look good on the day it is presented.

None of the items below are difficult to produce if the dashboard and attribution tags above were set up before go-live; all of them are difficult, or impossible, to reconstruct afterwards if they were not.

• A daily dashboard with venue-wise contacts, leads and exceptions
• Geo-tagged, time-stamped photos for every venue-day
• A lead list with verification status, not just a raw count
• Cost per outcome at each funnel stage, compared against the target set before go-live
• A written list of what underperformed and why, not only what beat the target
• The low-end sensitivity shown above, not only the mid-point figure

Reading cost per outcome without borrowing someone else's benchmark

The honest comparison is this campaign's cost per lead against its own history — the same venue type, the same season, the same team — not a published industry average that was never measured against your category, your cities or September to November. A borrowed number flatters or damns a result for reasons that have nothing to do with how the campaign actually ran.

Over two or three pilots, your own history becomes a far better benchmark than any external figure, because it already accounts for your category, your cities and your team — variables a generic industry number was never measured against in the first place.

This is also why the worked example on this page is tied to one named venue and one named team rather than blended into a single site-wide average — a blended number would hide exactly the venue-to-venue variation that a weekly review is supposed to catch.

Reviewing weekly, not just at the end

A campaign reviewed only at close has already spent the budget by the time a weak venue is identified. Reviewing cost per lead weekly, venue by venue, is what turns a 15-day pilot into a decision rather than a retrospective.

A weekly review is also the only point at which the low-end scenario above can be caught early enough to do something about it — reallocating a day from an underperforming venue to one that is beating its target, rather than discovering the shortfall after the budget is spent.

This does not require a new report format — it only requires looking at the same dashboard on a Friday instead of only on the last day of the campaign.

The metric to avoid

If a single number has to be dropped from a weekly report, this is the one, not leads or cost per lead.

Dropping it does not mean refusing to count attendance — it means refusing to let attendance stand in for a result.

Footfall counts people who walked past a visual merchandising setup; conversion counts the ones who stopped — a report with only the first number is measuring the venue, not the campaign.