Missed Opportunity

The Missed Opportunity metric quantifies revenue that a store could have generated but didn't, based on underperformance across the three core levers of retail sales: Traffic, Conversion Rate (CVR), and Average Order Value (AOV).

It is expressed as a single revenue figure — how many dollars were left on the table — and is designed to surface missed potential even on days where total sales appear healthy.

The three levers

Retail sales can be expressed as:

Sales = Traffic × Conversion Rate × AOV

When sales underperform versus a baseline period, the gap is driven by one or more of these three levers. The Missed Opportunity calculation quantifies the combined revenue impact of any gaps across all three.

Comparison modes

Avia offers three baselines for calculating missed opportunity:

Mode

Baseline period

Best used for

Day over Day (DoD)

Previous day

Spotting immediate short-term changes

Week over Week (WoW)

Same day of the prior week (e.g., this Sunday vs. last Sunday)

Day-to-day operations — compares like-for-like days

Year over Year (YoY)

Equivalent weekday from the prior year

Long-term trend analysis and seasonality (requires 1+ year of data)

WoW is the most commonly used mode — it eliminates the natural variation between weekdays and weekends by comparing the same day type.

Interpreting the number

The same missed opportunity figure can have very different root causes depending on which lever drove the gap:

Traffic-driven gap

Fewer visitors than the baseline. CVR and AOV may be strong, but there were fewer people to convert. Often an external factor: weather, marketing spend, local events.

CVR-driven gap

Traffic was there but fewer visitors purchased. Points to in-store execution — staffing levels, product placement, service quality, or stock availability.

AOV-driven gap

Transactions happened but at lower value. Upsell, cross-sell, and basket-building opportunities were not realised. Pricing, promotions, or product mix may also be a factor.

Combined gap

All three metrics down relative to baseline. The total missed opportunity reflects the compounded shortfall across traffic, conversion, and basket size.

Example

On a given Wednesday, the dashboard shows a $4,200 missed opportunity vs. the same Wednesday last week. Drilling into the three levers reveals:

  • Traffic: up 8% (more people came in)

  • CVR: down 12% (fewer of them bought)

  • AOV: flat

The root cause is conversion — not traffic. The right response is to investigate in-store execution: were there enough staff on the floor? Was a key product out of stock?

Without this breakdown, the instinct might have been to blame foot traffic — which would lead to the wrong diagnosis and the wrong fix.

Where to find it

The Missed Opportunity view is accessible from the main dashboard. Select a store and date range, then choose a comparison mode (DoD, WoW, or YoY) from the selector above the metric.

Need help?

If Missed Opportunity does not look correct after checking the selected store, date range, and traffic data, contact Avia support at support@retailogists.com.

When contacting support, include:

  • Store name

  • Selected date range

  • A screenshot of the Missed Opportunity section

  • Which number or comparison looks incorrect