How to read a competitive price index report

A competitive price index report is one of the most useful documents in retail pricing - and one of the most misread. Taken at face value, a single number like "CPI: 102" seems to say everything. Read properly, the same report tells you where you're expensive, whether it matters, and what to do about it. Here's how to read one, step by step.

Step 1: Understand what the index number means

A competitive price index compares your prices to a competitor benchmark, usually with 100 as parity:

• CPI = 100 - your prices match the market average.
• CPI above 100 - you're more expensive (a CPI of 105 means roughly 5% above).
• CPI below 100 - you're cheaper.

Simple enough. The mistake is stopping here. A store-wide CPI of 101 can hide a category priced at 115 sitting next to one at 92 - both problems, invisible in the average.

Step 2: Break it down by category, then by KVI status

Always read the index at three levels: total, category, and item tier. The tier view is the one that matters most, because not all products deserve the same index target. Your key value items - the products customers actually remember prices for - should sit at or below 100. Long-tail items can comfortably sit above it. If you're new to this segmentation, start with our guide on what KVIs are and how to price them.

A healthy report often looks "unbalanced" on purpose: KVIs at 98, background items at 106. A uniform 100 across every tier usually means you're overpaying for competitiveness where nobody's looking.

Step 3: Check the weighting method

Ask how the index is weighted before trusting it. An unweighted index treats a €2 accessory and a €900 TV identically. A revenue-weighted or units-weighted index reflects what customers actually experience. The same price data can produce a CPI of 99 or 104 depending on weighting - so any report worth reading states its method upfront.

Step 4: Verify the data underneath

An index is only as good as its inputs. Three questions to ask:

• Match quality. Are you being compared against genuinely identical products, or near-matches? Mismatched comparisons distort the index badly - which is why match accuracy is the first thing to probe in any price monitoring software evaluation.
• Data freshness. An index built on week-old prices describes a market that no longer exists, especially in fast-moving categories.
• Stock status. A competitor's price on an out-of-stock item isn't a live competitive signal and shouldn't drag your index around.

Modern price monitoring platforms handle these three automatically - flagging ambiguous matches, refreshing high-velocity SKUs frequently, and excluding out-of-stock competitor listings.

Step 5: Turn the reading into action

The point of a CPI report isn't the number - it's the exceptions. Products where you're expensive and elastic need competitive response. Products where you're cheap and inelastic are margin sitting on the table; our price elasticity guide explains how to tell the two apart. The best workflow routes these exceptions straight into competitive pricing rules rather than a monthly meeting. The leverage is worth the effort: McKinsey's pricing research puts a 1% price improvement at roughly an 8% lift in operating profit.

Reading the report is a skill. Acting on it within hours is infrastructure - and if yours currently involves a spreadsheet and a four-day cycle, the ROI calculator will show you what that delay costs.