Trade area analysis: which markets are growing and which are slipping
The short answer
Revenue can hold steady in a trade area that is quietly losing customers, so trade area analysis should track both. For each state and trade area, compare active customers and revenue with a year earlier, then flag areas where customer counts fall while revenue holds. Those markets depend on fewer, bigger spenders.
Why it matters
A trade area that relies on a shrinking pool of loyal customers looks healthy until those customers slow down. Spotting the decline a year early gives you time to adjust marketing, staffing or store plans while revenue still holds.
The question to ask
Copy this into Lexi as written.
How to work it out
1. Assign customers to trade areas. Map each customer to a trade area using their ZIP code and the store they use most, including online customers.
2. Compare two years. Count active customers, new customers and revenue per trade area for this year and last.
3. Split growth by source. Separate revenue growth into more customers, more spend per customer and price, so areas that grow only on price stand out.
What the answer looks like
Illustrative output on sample data
Illustrative example: how Lexi answers this for a sporting goods retailer. It compares active customers and revenue for three trade areas, year on year.
- Denver metro: customers up 9% to 48,000, revenue up 11% to $14.2 million
- Phoenix metro: customers down 7% to 31,000, revenue up 2% to $9.8 million
- Salt Lake City metro: customers up 4% to 22,000, revenue down 1% to $6.1 million
What the data shows
Phoenix looks stable on revenue but has lost about 2,300 customers. The ones who remain are spending more, about $316 each against $288.
What it means
New customer acquisition in Phoenix fell by a third while existing customers held steady. The decline starts at the top of the funnel, which points to marketing reach or a new competitor.
What to do
Review Phoenix paid media and local events first. Service changes are unlikely to fix an acquisition gap.
Want me to split each trade area into new, returning and lapsed customers?
Frequently asked questions
What is a trade area in retail?
A trade area is the geography a store draws most of its customers from, often defined by ZIP codes or drive time. Some markets call it a catchment. For a customer-based view, build trade areas from where your customers actually live, using their ZIP codes, which is more accurate than a fixed radius around the store.
Should I judge a trade area on revenue per store?
Revenue per store mixes how many customers you reach with how much each one spends. Track active customers and revenue per customer separately for each trade area. A market can lift revenue per store while its customer base shrinks, and that pattern usually shows up first in falling new customer counts.
How should online customers count in a trade area analysis?
Include them by home ZIP code. Online customers living near a store are part of that market, and many of them also visit, return items or collect orders there. Leaving them out understates the trade area and makes stores near strong ecommerce markets look weaker than they are.