Method 9 min read

Competitor price analysis: method and table

A useful price survey does not mix unrelated plans or products: it compares like with like, on the same date, and keeps the history.

A competitor price analysis collects genuinely comparable offers on a precise date, then measures their gaps and movement over time. Comparing one competitor's entry plan with another's complete plan produces a tidy figure and a false conclusion.

The method below provides a competitor price survey table for physical products as well as software. It then answers three questions: how the market is split, what it actually sells for, and what customers dislike about existing offers.

The competitor price survey table

Each row must represent one comparable product or plan. Date and source are compulsory: without them, you cannot tell a genuine price change from an old amount still visible in Google.

A ready-to-use tracking sheet CSV format · works with Excel, Google Sheets and LibreOffice
Download the template
Product or plan Your price Competitor Competitor price Gap Date and source
Comparable reference Enter value Name and domain Displayed price (competitor − you) ÷ you YYYY-MM-DD · URL
Second reference Enter value Name and domain Displayed price (competitor − you) ÷ you YYYY-MM-DD · URL

The file also records mandatory fees, billing period and normalised price: three fields needed to compare $29/month with $290/year honestly.

Calculate the percentage gap as follows: (competitor price − your price) ÷ your price × 100. A positive result means the competitor is more expensive. Save a new snapshot of the same table at every collection instead of overwriting previous values.

How do you run a competitive product analysis?

Start by defining the unit that makes the comparison fair: the same reference, quantity, subscription period or service level. For a catalogue analysis, separate strictly identical products from merely similar ones. The first group supports price comparisons; the second explains positioning.

  1. Define what is comparable before looking at amounts.
  2. Collect the price actually payable, including discounts and commitment periods.
  3. Keep the source and date so every value can be checked.
  4. Repeat with the same rule: the history is what reveals movement.

This is the fourth step of a full study. If you have not yet measured demand, start with the six-step method: analysing prices in a market whose size you do not know is not enough to decide whether to enter it.

What is not worth doing

Let us start with what you can stop doing:

  • Counting competitors. "There are forty-seven" says nothing. Forty-seven sellers where three hold most of the market, and forty-seven on equal footing, are opposite situations, and the count is identical.
  • Copying out their "about" pages. That is communication, not data.
  • Following their social accounts. Time-consuming, and follower counts do not tell you what they sell.
  • Filling in a SWOT matrix before collecting evidence. It arranges opinions. The price table, reviews and market distribution must come before interpretation.

Question 1: How is the market split?

One measure only: the top seller's share of the visible offer. It tells you who you are dealing with, which the total count never does.

When one player dominates, they set the reference price, and your positioning is defined relative to them: either you match it and compete on something other than price, or you take a position they cannot occupy: the highly specialised, the premium, the service.

When nobody dominates, the market is open. Good news for entering, less so for staying: nothing will stop the next entrant after you, using the same arguments.

MarketRaccoon draws the line at 30% of the collected offer for the top seller: above it the display reads "concentrated", below it "fragmented". That is our display threshold: it gives a stable reference from one analysis to the next, which is its only purpose.

Do not count single-product sellers

A seller appearing with one listing drifts in and out of the data at random. Tracking them means measuring noise. We only keep one once at least three of their products are found, precisely to avoid announcing movements that never happened.

Question 2: What do they actually sell for?

Not the price advertised on a homepage: the price actually charged on product pages, promotions included.

Three figures are enough (lowest, median, highest), then the distribution: how many products in each price band. It is the distribution that carries the information, not the extremes.

It reveals what no summary table shows: the empty bands. A cluster of products at the entry level, then a gap, then a few very high references. That gap is either a place to take or a graveyard. To find out which, look for someone who occupied it and left.

The trap in price collection

A price collection is not reproducible identically from one day to the next: results vary, sellers appear and disappear. We measured this on our own collections, and it is why our tool forbids itself certain comparisons.

Two precautions apply to you as well. Compare product by product: never two overall averages, which move as soon as the product list changes. And only conclude there is a rise or a fall if the gap clearly exceeds the variation you see between two collections made on the same day. Below that, you are commenting on your measurement method, not on the market.

Question 3: What do buyers complain about?

This is the most profitable of the three questions, and the answer is free: your competitors' customer reviews are a study somebody else already paid for.

Method: take the market's best-selling products and read the 2 and 3-star reviews. The 5-star ones teach you nothing. The 1-star ones are mostly about delivery and after-sales, rarely about the product.

Read until the same complaints recur. From that point you have your selling points: phrased by the market itself, which beats anything you would have invented.

What you do with it

The three answers combine into a single positioning decision:

  • Concentrated market + empty price band + recurring complaint: the best configuration. You enter through the open space, with the flaw fixed.
  • Fragmented market + tight prices + no clear complaint: the worst. You would be one more seller doing the same thing.
  • Concentrated market + no gap + complaints about service: workable, but your difference will be operational rather than product-based. Know that before you launch, not after.

Competition is only one of the five criteria that decide whether a niche is worth it. The other four (demand, trend, margin, seasonality) are covered in finding a profitable niche.

The part everyone forgets: doing it again

A competitive analysis is a photograph. It is accurate on the day you take it, then it goes stale: prices move, sellers arrive, others leave.

What actually helps you decide is not the photograph but the movement. A competitor cutting prices over two months tells you something today's price does not. Which is why a modest measurement, repeated every week under exactly the same rule, beats a very thorough analysis done once.

Read next