tapinall

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.

ONE ROW FILLED · 8 NOVEMBER 2026 $0.1312 2 SEARCHES · REAL NUMBERS
01 / THE TEMPLATE

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 analysis template: one row per competitor, your business last
CompetitorPositioningPricingTop keywordsTraffic sourcesReviews and complaintsAds they runContent gaps
Competitor 1
Competitor 2
Competitor 3
Your business

Download the CSV Opens in Google Sheets, Excel or Numbers. No signup.

02 / HOW TO FILL IT

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.

How to fill each column, and what ChatGPT or Claude can look up for you
ColumnWhat to writeWhere to find itWith tapinall
CompetitorName and websiteYour client, and page one of Google for your main keywordOne Google results page, $0.0003
PositioningTheir one-line promise and who it is forThe homepage headline and subheadingRead their homepage, $0.0003
PricingCheapest plan, main plan, monthly or annual billing, date checkedTheir pricing pageRead their pricing page, $0.0003
Top keywordsTheir 5 to 10 best keywords, with monthly searches and positionKeyword research data100 keywords, $0.125
Traffic sourcesHow many keywords they rank for, and how many sites link to themKeyword and backlink dataBacklink summary, $0.0062
Reviews and complaintsThe top 3 praises and complaints, in customers’ own wordsGoogle reviews, app stores, RedditPriced per search, shown before it runs
Ads they runThe headlines and offers in their current adsPublic ad libraries from Google and MetaPriced per search, shown before it runs
Content gapsTopics they rank for that you do notCompare their keywords with yoursPriced per search, shown before it runs
03 / REAL NUMBERS

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.

brevo.com, US Google, 8 November 2026
ColumnWhat came backSearchCost
Top keywordsRanks 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 sources44,252 sites link to it, with 1,182,098 backlinks in total.Backlink summary$0.0062
Content gaps94% 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
04 / DO IT YOURSELF

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.”
05 / GOOD QUESTIONS

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.

06 / KEEP READING SAME BALANCE. ANOTHER JOB.

Related guides.

THE NEXT MOVE IS YOURS.

Pay per search.
Cancel nothing. ✳

Real research data in ChatGPT or Claude.
No monthly plan. Credits never expire.

Create your account