Insights/Commerce and operations

The retail KPI stack: eight metrics and one dashboard.

Marketing reports cheap acquisition, the warehouse is full and finance warns about cash. A single KPI stack stops each team from looking successful while the business loses money.

Bespoke ResearchCommerce and operations4 min read

Three goals

  1. One source of truth for the whole organisation.
  2. Early-warning thresholds before margins deteriorate.
  3. KPIs linked to each team's OKRs.

The eight metrics

LevelMetricsBenchmarkFrequency
RevenueGMV, NMV, net salesNMV at least 85% of GMVReal time
ProfitabilityGross margin, EBITDAGross margin at least 55%Weekly
ProductSell-through, stock turn, days of inventoryStock turn 6x a year or moreDaily
MarketingMarketing efficiency ratio, blended ROASMER at most 30%Daily
CustomerAOV, lifetime value, repeat rateRepeat at least 35% a yearMonthly
OperationsFulfilment SLA, COD successCOD success at least 96%Daily
WorkforceSales per staff hourAt least VND 2 million an hourMonthly
FinanceCash conversion cycle60 days or lessMonthly

Dashboard design

  • A dimensional model of date, store, channel and product.
  • Looker Studio or Power BI, fed from point-of-sale, e-commerce and ad platforms.
  • Email and Slack alerts when a metric crosses its threshold.
  • Bullet charts for actual against target, a 12-month line for marketing efficiency and a treemap of revenue by category.

A good KPI stack needs three things: clean data, the right update frequency for each metric and clear visualisation.

Notes

First published on bespokemarketing.asia and updated for this site. Figures are as cited in the original article; tool defaults are examples unless stated.