Retail store KPIs: ranking stores on revenue and new customers
The short answer
Revenue and new customer acquisition rank stores differently, so retail store KPIs should show both lists side by side. Rank each store in the state on 12-month revenue, then separately on new customers acquired in the same 12 months. Stores high on revenue but low on acquisition rely on existing customers and need attention before that base shrinks.
Why it matters
A revenue ranking rewards established stores with loyal customers and hides those that have stopped attracting new ones. Ranking on acquisition too shows which stores are building their future customer base and which are living off past ones.
The question to ask
Copy this into Lexi as written.
What the answer looks like
Illustrative output on sample data
Illustrative example: how Lexi answers this for a furniture retailer with six stores in Texas. It ranks stores on revenue and on new customers won.
- Houston: 1st on revenue, $14.8 million. 4th on new customers.
- Dallas: 2nd on revenue, 1st on new customers.
- Fort Worth: 5th on revenue, 3rd on new customers.
- El Paso: 6th on both.
What the data shows
Houston leads on revenue but its sales lean on long-standing customers. Fort Worth is building a customer base that has not yet built spend.
What it means
In Houston's trade area, 40% of first purchases now happen online, so new customers there are still arriving through another channel.
What to do
Rank stores on revenue and acquisition together, and credit Houston with the online customers in its area.
Want me to show where each store's new customers first bought?
Frequently asked questions
How do you measure store performance fairly?
Use a few KPIs that cover today's sales and tomorrow's customers: revenue, new customers acquired, the repeat rate of those customers and margin. Compare stores of similar size and format, and rank on each KPI separately so one strong number does not hide a weak one.
Why does a revenue ranking mislead about store health?
Revenue reflects years of customer building, so established stores rank high even when acquisition has slowed. A store can top the revenue list while its customer base quietly shrinks. Pairing revenue with new customer acquisition shows which stores are building for next year.
Which store performance KPIs belong in a monthly review?
Revenue against last year, new customers, the share of those customers who return within 90 days, average order value and gross margin. Add units per transaction for stores with a coaching focus. Keep the list short enough that store managers can act on every number.