Competitive Analysis Template for a New Product Idea
A competitive analysis template for a product idea is one table: a row per competitor and eight columns for the facts that decide whether you can win. Those are the name, the price, proof of sales, the main promise, who it is for, what buyers praise, what buyers complain about, and how long it has been selling. Fill it from public sources with a link in every cell, then read it for three things: the price band, the complaint that repeats, and the buyer nobody serves well.
This guide gives you the template, says where each column comes from, and shows how to turn the table into a decision. If you don’t have a list of competitors yet, start with how to find competitors for a product idea and come back with five to ten names.
Why does a list of competitors not tell you enough?
Most founders stop at the list. They write down six names, see that the market is “busy” or “empty”, and move on. A list answers who exists. It doesn’t answer the questions that decide the idea: what buyers pay, what they are unhappy with, and where a new product could stand.
The cost shows up later. You launch at a price nobody in the market charges, with a promise three competitors already make, to a buyer who is already served. The table is how you see that before you build, not after.
What goes in a competitive analysis template?
Copy this table into a spreadsheet or a doc. One row per competitor, five to ten rows.
| Column | What to write | Where it comes from |
|---|---|---|
| Name and link | The product and its page | Google, marketplaces, app stores |
| Price | The price a buyer pays, and the plan or size | The product page or listing |
| Proof of sales | Review count, units sold, rating count | Amazon, TikTok Shop, Etsy, the App Store |
| Main promise | The headline claim, in their words | The product page, their ads |
| Who it is for | The buyer it speaks to | The product page, their ads |
| What buyers praise | The thing reviews keep repeating as good | Reviews, Reddit threads |
| What buyers complain about | The thing reviews keep repeating as bad | One and two star reviews, Reddit |
| Time selling | How long the ads or listings have run | The Meta Ad Library, listing dates |
Keep a link in every cell you can. A table without sources turns into opinion within a week, and you won’t remember which number came from where.
How do you do a competitor analysis with the template?
- Pick the competitors. Five to ten, including what buyers use today when they don’t buy a product at all (a spreadsheet, a free printable, a notes app).
- Fill price and proof of sales first. These are facts you can copy. They show quickly who is selling and at what level.
- Read reviews for praise and complaints. Ten reviews per competitor is enough to see what repeats. Copy the words, not your summary of them.
- Copy the promise and the buyer. Take them from the product page and from the ads they run now.
- Check how long they have sold. An ad that has run for months is one the seller keeps paying for, which usually means it works.
- Read the table by column, not by row. The patterns are in the columns.
The whole pass takes an afternoon for one idea. Doing the research by hand is fine; the template is the same either way.
How do you read the table once it is full?
Read three columns and write one sentence for each.
- Price. Sort by price. The middle of the band is what buyers already accept. How to price a new product shows how to anchor on it, and willingness to pay covers how to test it.
- Complaints. Find the complaint that shows up across several competitors. That is the opening a new product can take. If every complaint is about something different, there is no shared gap.
- Who it is for. When every competitor speaks to the same buyer, a narrower buyer may be underserved. Where they already cover every buyer, you need a different angle.
Then write the positioning in one line: “For [buyer], unlike [competitor], we [the fix for the repeated complaint].” Brand positioning for a new product takes that line further.
What does a weak competitive analysis look like?
| Weak | Strong |
|---|---|
| Feature checklists with ticks | Buyer complaints in their own words |
| “Pricing: varies” | The exact price and the plan |
| Only direct competitors | Also what buyers use instead |
| No links | A source in every cell |
| A SWOT grid from your head | Columns filled from public evidence |
Feature checklists are the most common trap. Buyers rarely leave a product over a missing feature on a grid; they leave over the thing that annoyed them every week. That shows up in reviews and threads, so read customer pain points before you count features.
Do you need a competitor analysis tool?
No, if you have an afternoon per idea. A tool earns its place when you compare several ideas, because it fills the table the same way each time so the rows are comparable. The guide to idea validation tools sorts the free and paid options by the question each one answers.
FAQ
How many competitors should a competitive analysis include?
Five to ten. Fewer and you may miss the price band; more and the extra rows rarely change the reading.
What if I find no competitors?
Usually the keywords are wrong or the market is very small. Search for the problem, not your product’s name, before you count it as an empty field.
Is a SWOT analysis the same thing?
No. A SWOT is a summary you write. A competitive analysis table is the evidence the summary should come from.
How often should I update it?
Before each big decision: the launch price, a new angle, a new buyer. Prices and ads change, so a table from last quarter can mislead.
Fill the table with Vettoz
Vettoz collects most of this table for you inside Claude, ChatGPT or Cursor. For one idea he reads Google, active Meta ads, Reddit threads and comments, X, TikTok and YouTube, plus TikTok Shop or the App Store depending on the kind of product, and returns up to 25 competitors with the prices, ratings, units sold and ads he found. He scores pain, demand, pay, room and reach from 0 to 100 with a GO, TEST or RETHINK verdict, and your AI writes the report with every source linked. Your first 2 checks are free; packs of 1, 4 or 15 ideas are one-time payments. Create a free account and type “check this idea with Vettoz”, or see how it works first.