Skip to content
competitive-price-monitoring logo

Competitive Price Monitoring

competitive-price-monitoring

Systematically tracks, compares, and analyzes competitor pricing across products, channels, and time periods to identify competitive positioning gaps, pricing threats, and opportunities. Use when the user wants to benchmark prices against competitors, monitor price changes, assess price image, or...

writer/skills0installs8stars

SKILL.md

Full skill instructions

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

InputRequiredDescription
Own product pricesYesCurrent regular and promoted prices by SKU
Competitor pricesYesMatched competitor prices (scraped, syndicated, or manually collected)
Product matchingYesUPC-level or attribute-level matching between own and competitor items
Time seriesRecommendedPrice history for trend analysis (minimum 12 weeks, ideally 52)
Category hierarchyRecommendedCategory, subcategory, segment for rolled-up analysis
Sales volume dataOptionalTo weight price indices by revenue importance
Cost dataOptionalTo assess margin implications of competitive pricing

Methodology

Step 1: Product Matching and Basket Construction

  1. Exact match: Match identical UPCs/​GTINs across retailers
  2. Equivalent match: Match products by brand + size + variant where UPCs differ (e.g., retailer-specific packaging)
  3. Attribute match: For private label, match by category + size + key attributes (organic, etc.)
  4. 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 CheaperPrice Parity (±2%)Own Cheaper
KVI ItemsCRITICAL — fix immediatelyMaintainEvaluate margin opportunity
Secondary ItemsMonitor trendAcceptablePossible price increase
Long TailLow priorityLow priorityIncrease price if margin-negative

Step 4: Competitive Price Movement Detection

Track price changes over time to detect competitive strategies:

  1. Change frequency: How often does each competitor adjust prices? (Weekly, monthly, seasonal)
  2. Change magnitude: Average size of price moves (benchmark: 2–5% in CPG)
  3. Directional trend: Net price movement direction over trailing 12 weeks
  4. Promotional patterns: Promo depth, frequency, and duration by competitor
  5. 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:

ActionCriteriaTypical Volume
Price DecreaseKVI items > 5% above competitor, high elasticity5–10% of items
Price IncreaseItems > 10% below competitor, low elasticity, no strategic role5–15% of items
MaintainWithin ±3% of competitor, appropriate positioning60–70% of items
InvestigateLarge gaps with unclear strategic rationale10–15% of items
Promotional ResponseCompetitor running deep promos in key categoriesVariable

Output Specification

1. Executive Price Index Summary

Metricvs. Competitor Avs. Competitor Bvs. 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 StrategyTarget PI vs. MarketKVI PI TargetPromo Intensity
EDLP (Walmart model)95–9893–96Low (< 15% of volume)
Hi-Lo (traditional grocery)100–105 regular95–100 promoHigh (30–45% of volume)
Premium (Whole Foods model)110–125105–115Low-Medium
Value/​Discount (Aldi model)80–9080–85Very 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:

  1. Overall Dairy PI: vs. Walmart 104.2 (4.2% more expensive), vs. Kroger 99.1 (at parity)
  2. 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)
  3. Biggest gaps vs. Walmart: Gallon milk (+$0.42, PI 112), Large eggs (+$0.35, PI 109), Butter 1lb (+$0.28, PI 107) — all KVIs
  4. 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.
  5. 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

Validation Checklist

  • Product matching is verified (exact UPC or validated equivalent match)
  • Price indices are revenue-weighted (not simple averages)
  • KVI basket is explicitly defined and KVI-specific PI is calculated
  • Both regular and promotional prices are analyzed separately
  • Time trends are included (not just a point-in-time snapshot)
  • Price indices are calculated vs. at least 2 competitors
  • Recommendations are prioritized by strategic impact (KVIs first)
  • Margin impact of pricing actions is estimated
  • Data recency is verified (stale competitive data misleads)
  • Channel-specific considerations are noted (online vs. in-store)

More skills from writer

Identifies, quantifies, and forecasts seasonal demand patterns for CPG and retail products to optimize inventory, promotions, and assortment timing. Use when the user wants to understand seasonal trends, build seasonal demand forecasts, plan seasonal inventory, or optimize the timing of product l...

8 0
View

Validate informed consent documentation for completeness, regulatory compliance, and clinical appropriateness by assessing required elements against CMS Conditions of Participation, Joint Commission standards, and state-specific consent laws. Use when auditing consent records, preparing for accre...

8 0
View

Conduct M&A financial due diligence analysis for bank acquisitions including accretion/dilution modeling, fair value marks, cost synergy validation, and pro-forma capital impact. Use when evaluating bank acquisition targets, preparing deal committee materials, analyzing merger economics, or asses...

8 0
View

Interpret and explain fraud detection signals, model outputs, and suspicious patterns across payment, identity, and account fraud typologies. Use when analyzing fraud alerts, explaining model scores, investigating fraud rings, or documenting fraud case findings for consumer and commercial banking.

8 0
View

Analyze policy exceptions for risk patterns, concentration risks, and control gaps in financial institutions. Use when reviewing policy exception requests, analyzing exception trends, assessing exception backlogs, or evaluating whether exceptions indicate systemic control weaknesses under COSO, O...

8 0
View

Explain portfolio drift from target allocations in client-friendly language with actionable rebalancing guidance. Use when preparing client review presentations, explaining allocation changes caused by market movements, justifying rebalancing trades, or helping clients understand why their portfo...

8 0
View

Decompose and explain healthcare cost growth into contributing factors including utilization changes, unit price shifts, case mix evolution, and population changes. Use when analyzing PMPM cost trends, explaining cost variance to leadership, preparing actuarial summaries, or identifying cost redu...

8 0
View

Analyze operational risk events and produce structured loss event narratives, root cause analyses, and OpRisk reports. Use when documenting operational loss events, conducting RCSA analysis, preparing OpRisk committee reports, or supporting Basel III operational risk capital calculations under th...

8 0
View

Predict provider capacity shortages and surpluses using demand modeling, wRVU productivity analysis, panel-size optimization, and workforce pipeline analytics to inform strategic recruitment and scheduling decisions.

8 0
View

Assess internal control testing effectiveness for financial institutions using COSO 2013 framework and SOX 302/404 requirements. Use when evaluating control test results, assessing control design and operating effectiveness, analyzing control deficiencies, or preparing management's assessment of ...

8 0
View

Diagnose supply delays by decomposing lead time into constituent stages, identifying variance sources, quantifying downstream impact on inventory and service levels, and recommending corrective actions.

8 0
View

Attribute AUM growth to its component drivers — market performance, net new assets, client acquisition, attrition, and fee impact. Use when analyzing practice growth, preparing management reporting, evaluating advisor productivity, forecasting AUM trajectory, benchmarking organic growth rates, or...

8 0
View

Popular AI tools

Kaiber logo
Video

Kaiber

Generate, edit, and beat-sync AI video with leading models in one workspace.

Paid
View
Vimcal logo
Productivity

Vimcal

The world's fastest calendar for remote work

Free
View

Transform Your Design with AI Designer by ImgCreator.ai

Freemium
View
Akool AI logo
Content & writing

Akool AI

Revolutionizing Video Production with AI-Powered Creativity

Paid
View

Extend an image past the frame and let AI fill the new aspect ratio.

Freemium
View
StarByFace logo
Security

StarByFace

Discover your celebrity doppelgänger with StarByFace!

Free
View
C

ChainClarity explains 700+ crypto whitepapers in plain English, with layered summaries, comparisons, research tools, alerts, and a $4.99 Pro plan.

Freemium
View
Opus Clip logo
Coding & apps

Opus Clip

Opus.ai: Revolutionize Your Web Experience

Free
View