Tools & Approaches
What Data Do I Need for Competitive Pricing Analysis?
Short answer
The minimum data for competitive pricing analysis: your product prices and 3-5 competitor prices per SKU or product category. You probably already have this from checking Amazon, walking retail shelves, or browsing competitor websites. Optional but valuable additions: cost of goods sold (COGS), your discount and promo structure, bundle pricing tiers, and sales velocity data (units sold over a period).
The full answer
The biggest misconception about competitive pricing analysis is that it requires expensive data subscriptions or retailer portal access. It doesn't. The core data set is small, and most founders have 80% of it already — they just haven't structured it for analysis.
Required data, tier one (minimum viable analysis): your SKU names and current prices, plus 3-5 competitor prices for each product or product category. This alone lets you calculate position ratios (your price / competitor midpoint) and classify each SKU as Value, Parity, or Premium. Where do competitor prices come from? The same places you already check: Amazon product pages, competitor websites, retailer shelf prices, and industry price lists. If you've ever comparison-shopped your own product, you have competitive benchmarks.
Required data, tier two (full pricing audit): everything in tier one, plus your discount structure (what discounts exist, how they stack), bundle tier pricing (single, 3-pack, 6-pack, subscription), and cost of goods sold per SKU. This enables discount stacking analysis (are your promos silently eroding margin?), bundle coherence checks (does per-unit pricing decrease as bundle size increases?), and margin health assessment (is your contribution margin above your floor after all costs?).
Optional data, tier three (assortment analysis): everything in tiers one and two, plus sales velocity per SKU (units sold over a defined period — 30, 60, or 90 days). This unlocks the Position x Velocity matrix: crossing competitive position with sales performance to classify every SKU as STAR, CORE, KEEP, MAINTAIN, FIX, or DELIST. Velocity data is the single most valuable addition beyond the basics because it turns a static pricing analysis into an action-prioritized roadmap.
Data quality matters more than data completeness. Three accurate competitor prices per SKU are more useful than ten prices scraped from unreliable sources. Use prices from the channels your customers actually shop — if your customers buy on Amazon, Amazon prices matter. If they buy from specialty retailers, those shelf prices matter. The benchmark set should reflect the customer's comparison set, not a theoretical competitive landscape.
A common question: do I need historical data? For a point-in-time pricing analysis, no. Current prices are sufficient. Historical data helps you identify trends (are competitors raising or lowering prices over time?) but isn't required for the core position analysis. If you're running quarterly reviews, your accumulated reports become your historical data over time.
Related questions
What if my product doesn't have direct competitors?
Every product has substitutes even if it doesn't have direct competitors. If you sell a unique artisan hot sauce, benchmark against the premium hot sauce category. If you sell a novel supplement, benchmark against the closest functional alternatives. The goal is understanding where the customer sees your price relative to their alternatives — not finding identical products.
How accurate do competitive prices need to be?
Within 5-10% is good enough for position classification. A competitor priced at $28 vs. $30 doesn't change whether you're Value, Parity, or Premium relative to them. Don't let precision anxiety delay the analysis — directionally correct benchmarks lead to good pricing decisions.
PricePilot's Excel template structures exactly the data you need — products, benchmarks, bundles, constraints, and performance proxies. Download the template and get started.