An SEO competitor analysis template where every column has a source
Twelve columns, the seogeoaeo.ai tool that fills each one, and what a full row costs in credits.
By ClaudeGPT Si Newsroom, Editorial team··4 min read
An SEO competitor analysis template is only as good as the numbers in it, and most go wrong in the same place: each cell comes from a different tool, so the rows can't be compared. This version fixes the source for every column before you type a single number. Your own domain goes in the top row, followed by three to five rivals, and each column draws on one named tool for every row.
The twelve columns and their sources
| Column | What goes in the cell | Source | Credits |
|---|---|---|---|
| Site | The domain | You | 0 |
| Role | Search, sales or both | Competitor Finder plus your sales team | 38, once |
| Organic visits/mo | Estimated monthly Google visits | Domain Overview | 50 |
| Keywords (top 10) | Ranking keywords, and how many sit in the top 10 | Domain Overview | same run |
| Referring domains | Linking sites and link rank | Domain Overview | same run |
| Top pages | The two or three pages that bring the most visits | Competitor Keywords | 35 |
| Shared keywords | Keywords you both rank for | Competitor Finder | same run |
| Gap keywords | Keywords they hold in the top 20 that you lack | Keyword Gap | 85 |
| Content types | Format of each top page | By hand | 0 |
| Google Ads | Ads running and the oldest one's promise | Competitor Google Ads | 15 |
| Social ads | Meta and LinkedIn ads running | Meta Ad Finder, LinkedIn Ad Finder | 5 each |
| AI citations | Share of AI answers on the topic citing the site | AI Citation Finder, topic mode | 160, once |
Every tool listed is on seogeoaeo.ai, priced in credits and shown before each run.
Picking the rows
Competitor Finder returns the 30 sites that share the most Google keywords with your domain in the country you pick. It labels a site a close competitor when at least 5% of the keywords that site ranks for are also yours, which separates real rivals from giants like Wikipedia that rank for everything. Drop the giants, keep the close ones, then ask sales which one or two companies beat you in deals. Those may not rank at all, and that is fine: mark them "sales" in the Role column. A rival marked "both" is the one to study hardest.
Small sites sometimes get back few close competitors. In that case, run Competitor Keywords on a rival you already know.
Filling one competitor row
One Domain Overview run fills three columns. For the market you choose it gives the domain's ranking keywords split by position, estimated monthly visits, what those visits would cost as ads, the keywords it buys in Google Ads, the sites and pages linking in, a link rank from 0 to 1,000, average spam score and nofollow share. Rankings are per country; links count worldwide. If the run finds neither rankings nor links, the 50 credits come back.
Competitor Keywords supplies the top pages, and Keyword Gap compares your site with that rival. It starts from the 300 most searched keywords you are missing and keeps the ones where the rival sits on Google's first two pages, then names the rival pages that win the most of them. It does not list keywords you share but rank lower for.
The three ad tools fill the last paid columns. Competitor Google Ads samples the 100 most recently shown ads and reads the copy of up to 10 text ads, with how long each has run. Meta Ad Finder lists up to 30 active Facebook and Instagram ads per search; LinkedIn Ad Finder lists up to 24. None of them shows spend, so record how long an ad has run instead.
What a full sheet costs
Per competitor row: Domain Overview 50, Competitor Keywords 35, Keyword Gap 85, Competitor Google Ads 15, Meta Ad Finder 5 and LinkedIn Ad Finder 5, which totals 195 credits. Add Competitor Finder (38) and one AI Citation Finder topic run (160) once for the whole sheet. Four rivals plus your own Domain Overview land at roughly 1,030 credits, inside the 2,000 credits of the $29 Indie plan.
Two rules that keep the sheet honest
Take each column from the same source for every row, your own included. Provider numbers are estimates; they compare with each other but not with Search Console, so park your real Search Console clicks in the notes.
Turn what you see into decisions written as "We will X because row Y, column Z shows it", each with an owner and the column you will recheck. Refresh every quarter and judge a decision over two refreshes, since providers revise their estimates.
Where another tool fits better
seogeoaeo.ai runs one-off lookups and has no rank tracker. If you need daily positions for hundreds of keywords between refreshes, a suite such as Semrush, whose SEO plan tracks 500 keywords daily, does that job. For filling the template once a quarter, the per-run tools are enough. Start with a Domain Overview of your own site to fill row one.