Competitive Price Monitoring

Overview

Competitive Price Monitoring provides a structured framework for tracking and analyzing competitor prices to inform pricing strategy, protect price image, and identify threats and opportunities. This skill goes beyond simple price comparison to deliver strategic intelligence: trend analysis, price positioning maps, competitive response patterns, and actionable recommendations.

In CPG retail, price perception drives 20–40% of store-choice decisions. A retailer whose price index drifts 3–5% above key competitors risks losing traffic and basket share. Conversely, unnecessarily low prices leave margin on the table. This skill enables precision price positioning.

When to Use

Regular (weekly/monthly) competitive price benchmarking
Before or after own price changes to assess competitive context
When market share shifts suggest competitive pricing pressure
Retailer negotiation prep requiring competitive price data
E-commerce dynamic pricing response strategy
Private label pricing calibration vs. national brand and competitor PL
User asks to compare prices against specific competitors

Required Inputs

Input	Required	Description
Own product prices	Yes	Current regular and promoted prices by SKU
Competitor prices	Yes	Matched competitor prices (scraped, syndicated, or manually collected)
Product matching	Yes	UPC-level or attribute-level matching between own and competitor items
Time series	Recommended	Price history for trend analysis (minimum 12 weeks, ideally 52)
Category hierarchy	Recommended	Category, subcategory, segment for rolled-up analysis
Sales volume data	Optional	To weight price indices by revenue importance
Cost data	Optional	To assess margin implications of competitive pricing

Methodology

Step 1: Product Matching and Basket Construction

Exact match: Match identical UPCs/GTINs across retailers
Equivalent match: Match products by brand + size + variant where UPCs differ (e.g., retailer-specific packaging)
Attribute match: For private label, match by category + size + key attributes (organic, etc.)
Construct Key Value Item (KVI) basket: Identify the 100–300 most price-sensitive items that disproportionately shape consumer price perception. KVIs typically represent 10–15% of SKUs but drive 40–60% of price image.

KVI Identification Criteria:

High purchase frequency (top 20% of basket penetration)
High price awareness (items consumers price-check: milk, eggs, bananas, diapers, cola)
High cross-shop rate (items bought at multiple retailers)
Category traffic drivers

Step 2: Price Index Calculation

Compute price indices at multiple levels:

Item-Level Price Index:

Price Index_item = (Own Price / Competitor Price) × 100

Index 100 = price parity
Index < 100 = cheaper than competitor
Index > 100 = more expensive than competitor

Category-Level Price Index (revenue-weighted):

Category PI = Σ(Price Index_item × Item Revenue Weight) / Σ(Revenue Weights)

Overall Price Index (basket-level):

Basket PI = Σ(Own Price_i × Quantity_i) / Σ(Competitor Price_i × Quantity_i) × 100

KVI Price Index: Same as basket PI but limited to KVI items only — this is the most actionable metric for price image.

Step 3: Price Position Mapping

Create a price-position matrix:

	Competitor Cheaper	Price Parity (±2%)	Own Cheaper
KVI Items	CRITICAL — fix immediately	Maintain	Evaluate margin opportunity
Secondary Items	Monitor trend	Acceptable	Possible price increase
Long Tail	Low priority	Low priority	Increase price if margin-negative

Step 4: Competitive Price Movement Detection

Track price changes over time to detect competitive strategies:

Change frequency: How often does each competitor adjust prices? (Weekly, monthly, seasonal)
Change magnitude: Average size of price moves (benchmark: 2–5% in CPG)
Directional trend: Net price movement direction over trailing 12 weeks
Promotional patterns: Promo depth, frequency, and duration by competitor
Leader-follower dynamics: Which competitor moves first; how quickly do others follow

Price Velocity Score:

PVS = (# Price Changes in Period / # Items Monitored) × (Avg % Change Magnitude)

High PVS indicates an actively managing/aggressive competitor.

Step 5: Price Gap Analysis

For each category, compute the price gap distribution:

Price Gap = Own Price − Competitor Price (in $ and %)

Analyze the distribution:

Mean gap: Overall positioning
Median gap: Central tendency (less sensitive to outliers)
Gap dispersion (std dev): Consistency of positioning
Skewness: Are gaps systematically positive (more expensive) or negative (cheaper)?
% of items within ±3% parity: Measure of overall alignment

Step 6: Strategic Recommendations

Classify items into pricing action buckets:

Action	Criteria	Typical Volume
Price Decrease	KVI items > 5% above competitor, high elasticity	5–10% of items
Price Increase	Items > 10% below competitor, low elasticity, no strategic role	5–15% of items
Maintain	Within ±3% of competitor, appropriate positioning	60–70% of items
Investigate	Large gaps with unclear strategic rationale	10–15% of items
Promotional Response	Competitor running deep promos in key categories	Variable

Output Specification

1. Executive Price Index Summary

Metric	vs. Competitor A	vs. Competitor B	vs. Competitor C
Overall Price Index	—	—	—
KVI Price Index	—	—	—
Private Label PI	—	—	—
Promo Price Index	—	—	—

2. Category-Level Price Index Table

Table showing price index by category for each competitor, color-coded (green < 98, yellow 98–102, red > 102).

3. Price Movement Alert Report

Items with significant competitive price changes in the monitoring period, ranked by strategic importance.

4. Price Position Map

Scatter plot (or table) with own price on Y-axis, competitor price on X-axis, sized by revenue. Items above the diagonal are more expensive; below are cheaper.

5. Action Item List

Specific SKU-level pricing recommendations with expected revenue/margin impact.

Analysis Framework

Key Metrics

Price Index (PI): Core positioning metric (target varies by retailer strategy: EDLP aims for 97–100 vs. market)
KVI Price Index: Most important for price image; should be at or below target PI
Price Image Score: Consumer-perceived pricing derived from KVI PI (correlated r=0.7+ with KVI PI)
Gap Closure Rate: % of identified gaps actioned within one review cycle
Price Change Velocity: Frequency and magnitude of competitive price changes
Promo Price Index: Average promoted price vs. competitor promoted price
Everyday Price Index: Regular (non-promoted) price comparison
Private Label Price Ratio: PL price / national brand price (benchmark: 20–35% discount)

Strategic Pricing Benchmarks

Retailer Strategy	Target PI vs. Market	KVI PI Target	Promo Intensity
EDLP (Walmart model)	95–98	93–96	Low (< 15% of volume)
Hi-Lo (traditional grocery)	100–105 regular	95–100 promo	High (30–45% of volume)
Premium (Whole Foods model)	110–125	105–115	Low-Medium
Value/Discount (Aldi model)	80–90	80–85	Very Low

Examples

Input: "Compare our pricing in the Dairy category against Kroger and Walmart. We have 180 matched items with weekly price data for the last 26 weeks."

Output:

Overall Dairy PI: vs. Walmart 104.2 (4.2% more expensive), vs. Kroger 99.1 (at parity)
KVI PI (top 30 items): vs. Walmart 106.8 (critical — we are 6.8% above Walmart on the most price-sensitive dairy items), vs. Kroger 100.3 (parity)
Biggest gaps vs. Walmart: Gallon milk (+$0.42, PI 112), Large eggs (+$0.35, PI 109), Butter 1lb (+$0.28, PI 107) — all KVIs
Trend: Walmart reduced dairy prices on 14 items in the last 4 weeks (PVS rising), likely a price investment play. Our gap has widened from PI 102 to 104 in 6 weeks.
Recommendations: (a) Invest in 12 KVI items to close gap to PI ≤ 100 vs. Walmart — estimated cost $180K/year in margin, but protects estimated $2.4M in at-risk dairy revenue. (b) Increase prices on 8 specialty dairy items where we are 15%+ below Kroger — margin recovery $95K/year.

Guidelines

Always weight price indices by revenue or volume; unweighted indices are misleading because they treat a $1 spice the same as a $5 milk
Separate everyday and promotional price comparisons — a retailer can be expensive everyday but cheap on promo, creating a different price perception
Match products carefully; incorrect matching invalidates the entire analysis. Verify matching logic with the user.
KVI identification is critical — focus price investments on the items that consumers actually notice and compare
Monitor trends, not just snapshots — a competitor that has made 10 consecutive weekly price decreases is signaling a strategy shift
Consider channel context: online prices may differ from in-store; compare like-for-like
Account for private label substitution effects; national brand price gaps matter less if the consumer's real alternative is the store brand
Don't recommend matching every competitor on every item — that leads to a race to the bottom. Be surgical.
Factor in basket economics: sometimes being 5% higher on commodity items is sustainable if the total basket value proposition is strong

competitive-price-monitoring