Price band analysis

Price band analysis is the practice of dividing a category's products into price ranges, or bands, such as under 20 dollars, 20 to 50 dollars, and above 50 dollars, then examining how many SKUs, how much sales volume, and how much margin fall into each band. It shows whether an assortment is balanced across price tiers or overly concentrated in one range.

How price band analysis works

Analysts start by defining bands that make sense for the category, usually informed by natural breakpoints in customer behavior or competitor assortments. Every SKU is tagged with its band, then sales, units, and margin are rolled up by band alongside SKU count. Comparing the share of SKUs in a band to its share of sales quickly shows over-assortment, where a retailer carries far more items in a band than the sales volume justifies, or gaps, where a band is under-represented relative to demand.

The analysis is often paired with competitor price bands to see whether a retailer is missing an entire price tier that rivals are capturing, particularly at entry-level and premium ends of a category.

Most retailers run price band analysis on a quarterly or seasonal cadence, since assortment and pricing changes take time to show up meaningfully in the sales mix. The analysis is most useful when paired with unit economics by band, since a band can look attractive on sales share alone while actually carrying thinner margin than a smaller, higher-margin band elsewhere in the same category.

Example

A home goods retailer runs a price band analysis on its bath towel category and finds that 60 percent of its 140 SKUs sit in the 25 to 40 dollar band, but that band only generates 38 percent of category sales. Meanwhile, an entry-level band under 15 dollars has just 8 SKUs but drives 22 percent of units sold. The analysis prompts the merchandising team to cut a dozen underperforming mid-band SKUs and expand the entry-level assortment by six new items, rebalancing the category toward where demand actually sits.

Why it matters for retailers

Without band-level visibility, assortment decisions get made SKU by SKU, which can leave a retailer overloaded in price tiers customers do not want and thin in the tiers that drive the most traffic and volume. Price band analysis turns assortment planning into a portfolio decision, helping buyers align SKU count and shelf space with where sales and margin actually concentrate. It also gives buyers a shared, objective reference point for assortment negotiations with vendors, since a band showing weak sales relative to SKU count makes a clear case for trimming an underperforming supplier line rather than relying on anecdotal impressions of what is selling.

How Retailgrid helps

Retailgrid rolls up sales, margin, and SKU count by price band automatically as part of its price monitoring and analysis workspace, so merchandising teams do not need to build the bands manually in a spreadsheet every planning cycle. Combined with competitive pricing data, teams can see their own band mix against competitors, and the price optimization software can recommend where to shift SKU count or pricing to close gaps.