HOME GUIDES
A free competitor analysis template, filled with real numbers instead of screenshots.
This competitor analysis template is a free CSV with one row per competitor and eight columns that cover what clients ask about.
If you check pricing pages by hand and paste screenshots into a deck every month, this gives the work a fixed shape. Download it, learn what goes in each column, then see ChatGPT or Claude fill a row with real keyword and backlink numbers for a few cents.
The competitor analysis template
Put three competitors in the rows, and your own business or your client last, so every gap is easy to see. Keep it in a spreadsheet and refresh it once a quarter, or before every pitch.
| Competitor | Positioning | Pricing | Top keywords | Traffic sources | Reviews and complaints | Ads they run | Content gaps |
|---|---|---|---|---|---|---|---|
| Competitor 1 | |||||||
| Competitor 2 | |||||||
| Competitor 3 | |||||||
| Your business |
Download the CSV Opens in Google Sheets, Excel or Numbers. No signup.
What goes in each column
Write short, checkable facts, not opinions. Add the date and the source next to every number, because prices and rankings change.
| Column | What to write | Where to find it | With tapinall |
|---|---|---|---|
| Competitor | Name and website | Your client, and page one of Google for your main keyword | One Google results page, $0.0003 |
| Positioning | Their one-line promise and who it is for | The homepage headline and subheading | Read their homepage, $0.0003 |
| Pricing | Cheapest plan, main plan, monthly or annual billing, date checked | Their pricing page | Read their pricing page, $0.0003 |
| Top keywords | Their 5 to 10 best keywords, with monthly searches and position | Keyword research data | 100 keywords, $0.125 |
| Traffic sources | How many keywords they rank for, and how many sites link to them | Keyword and backlink data | Backlink summary, $0.0062 |
| Reviews and complaints | The top 3 praises and complaints, in customers’ own words | Google reviews, app stores, Reddit | Priced per search, shown before it runs |
| Ads they run | The headlines and offers in their current ads | Public ad libraries from Google and Meta | Priced per search, shown before it runs |
| Content gaps | Topics they rank for that you do not | Compare their keywords with yours | Priced per search, shown before it runs |
One row, filled by ChatGPT or Claude
Here is the brevo.com row, an email marketing tool, filled from two searches run on 8 November 2026 for Google in the US. Together they cost $0.1312.
Data sources differ. SpyFu’s data put “mailchimp” at 540,000 searches a month with brevo.com at position 13. Write down which source you used, and compare like with like.
| Column | What came back | Search | Cost |
|---|---|---|---|
| Top keywords | Ranks for 16,168 Google keywords in the US. Top three by traffic: “mailchimp”, 368,000 searches a month, position 3. “crm”, 165,000, position 5. “brevo”, 40,500, position 1. | Top 100 keywords by traffic | $0.125 |
| Traffic sources | 44,252 sites link to it, with 1,182,098 backlinks in total. | Backlink summary | $0.0062 |
| Content gaps | 94% of the traffic from its top 100 keywords lands on blog guides: what is Mailchimp, best email marketing services, what is a CRM, newsletter ideas. | Same 100 keywords | $0 |
Ask for the whole sheet in one message
Connect tapinall to ChatGPT or Claude once. Then paste the template and ask in plain words. It runs each search, shows you the price first, and writes the answers into the rows.
- “Fill this competitor analysis template for these three competitors and my site. Use real keyword and backlink numbers for US Google, and add the source and date to each.”
- “Read each competitor’s pricing page and fill the Pricing column with the cheapest plan, main plan and billing.”
- “Find the keywords they rank for on page one that my site does not rank for, and put the best 5 in Content gaps.”
Good questions,
short answers.
What should a competitor analysis template include?
At least each competitor’s positioning, pricing, top keywords, traffic sources, reviews and complaints, the ads they run, and the content gaps between them and you. This template has one column for each, plus your own business as the last row.
Is this competitor analysis template free?
Yes. Download the CSV and open it in Google Sheets, Excel or Numbers. No signup needed.
How many competitors should I include?
Three is enough for most clients. Pick the ones that show up on page one of Google for your main keyword, plus the one your client names first.
Can ChatGPT or Claude do a competitor analysis?
On their own they guess from old training data. Connected to tapinall, they pull real keyword volumes, rankings, backlinks and reviews, and you pay per search. The brevo.com row above cost $0.1312.
How often should I update a competitor analysis?
Once a quarter for most businesses, and before every pitch or client report. Prices and rankings move, so date every number.
Related guides.
- USE CASE Run an AI competitor analysis
- USE CASE Run a content gap analysis
- USE CASE Keyword research in Claude
- USE CASE Reddit market research
- USE CASE Read the reviews behind the rating
- USE CASE Analyze a competitor's App Store reviews
- USE CASE Check if ChatGPT recommends your brand
- GUIDE What Semrush costs for the 5 jobs a freelancer does
- GUIDE What SpyFu costs, and the pay-per-search way
Pay per search.
Cancel nothing. ✳
Real research data in ChatGPT or Claude.
No monthly plan. Credits never expire.