A startup SEO competitor analysis template should fit into one working document and one weekly meeting. It needs enough structure to preserve evidence, but not the enterprise overhead of a large research program. The output is a reusable analysis record with evidence and decisions, not a checklist of tasks and not a performance dashboard.
The template below is designed for a founder, growth lead, or small SEO team managing a focused competitor set. It pairs well with a lightweight SEO competitor monitoring workflow and can begin in a spreadsheet before the process needs dedicated tooling.
Copy the startup SEO competitor-analysis template
Create a spreadsheet with three tabs named Competitors and sources, Pages and evidence, and Decisions. For each tab below, copy the header row into row 1, or select the dictionary table and paste it into Google Sheets or Excel as a reference. Columns marked External are filled from SEO tools you already use. Leave them blank until a row survives triage.
Tab 1: competitors and sources
This tab holds the active competitor list, why each company is tracked, and the sources that feed Tab 2. Header row to copy: Competitor, Competitor type, Why tracked, Source URL, Source type, Source health, Last checked
| Column | What to enter | Example | Filled from |
|---|---|---|---|
| Competitor | Company name | Acme Analytics | You |
| Competitor type | Direct, adjacent, or search-only competitor | Direct product rival | You |
| Why tracked | The decision this competitor informs | Competes for agency reporting buyers | You |
| Source URL | Feed, sitemap, or site section URL | acme.example/resources/sitemap.xml | You, or Content Radar for supported sources |
| Source type | RSS, Atom, sitemap, Google Alerts RSS, or manual | Sitemap | You, or Content Radar for supported sources |
| Source health | Working, quiet, or failing | Working | Content Radar source health, or a manual check |
| Last checked | Date of the last successful check | June 10 | Content Radar, or a manual check |
Tab 2: pages and external SEO evidence
Add only relevant new or updated URLs. The first columns describe the page; the External columns hold the SEO evidence for rows worth investigating. Header row to copy: Date found, Competitor, Source, URL, Page type, Topic and audience, Likely intent, Target query, Search volume, Keyword difficulty, Competitor position, Referring domains, Our coverage
| Column | What to enter | Example | Filled from |
|---|---|---|---|
| Date found | When the URL was detected or found | June 9 | Content Radar, or manual research |
| Competitor | Name from Tab 1 | Acme Analytics | You |
| Source | Where the URL came from | Resources sitemap | Content Radar, or manual research |
| URL | The exact public URL | /guides/automated-reporting | Content Radar, or manual research |
| Page type | Guide, comparison, use case, integration, or glossary | Bottom-funnel guide | You |
| Topic and audience | Subject and intended reader | Reporting automation for agencies | You |
| Likely intent | Informational, commercial investigation, or transactional | Commercial investigation | You |
| Target query | The query the page appears to target, as a hypothesis | automated client reporting | You |
| Search volume | Monthly estimate, with tool name and date | Estimate from your keyword tool | External SEO tool; blank is fine |
| Keyword difficulty | The tool's score, with tool name | Score from the same tool | External SEO tool; blank is fine |
| Competitor position | Position for the target query, with date | Not ranking yet, June 12 | External rank tracker or manual SERP check; blank is fine |
| Referring domains | Linking domains to the competitor page | Count from your backlink tool | External backlink tool; blank is fine |
| Our coverage | Your closest page and its state | One general reporting post | You, with Search Console for your own site |
Content Radar does not populate keyword volume, difficulty, rankings, backlinks, or traffic. Record those from the tools that supply them, note the tool and date so the numbers can be compared later, and accept blank cells for rows that did not need the check.
Tab 3: decisions and owners
Record create, update, watch, or ignore decisions with an owner and due date. This tab prevents recurring discussion of the same finding. Header row to copy: URL or cluster, Decision, Rationale, Owner, Due date, Revisit date, Outcome
| Column | What to enter | Example | Filled from |
|---|---|---|---|
| URL or cluster | The Tab 2 row or group of rows | /guides/automated-reporting | You |
| Decision | Create, update, watch, or ignore | Update | You |
| Rationale | One sentence tying the decision to evidence | Commercial intent and thin existing coverage | You |
| Owner | One named person | Maya | You |
| Due date | When the action should ship | June 14 | You |
| Revisit date | When to check the evidence again | July 12 | You |
| Outcome | What happened after the action | Refresh shipped; impressions rising | You, from Search Console and analytics |
Worked example
One week of findings for a startup selling reporting software to agencies, condensed across Tabs 2 and 3.
| URL | Page type and intent | External evidence | Our coverage | Decision | Owner and date |
|---|---|---|---|---|---|
| Acme: /guides/automated-reporting | Bottom-funnel guide, commercial investigation | Keyword tool shows steady demand; the page is not ranking yet | One general reporting post | Update the agency reporting guide | Maya, due June 14 |
| Beta: /compare/beta-vs-spreadsheets | Comparison page, commercial investigation | Low demand; review sites dominate the SERP | None | Watch | Omar, revisit July 1 |
| Acme: /blog/team-offsite-recap | Company news, not search-driven | Not checked | Not relevant | Ignore | None |
The third row shows the triage rule at work. It was logged, classified, and ignored without spending any external tool lookups, because nothing about it could change the plan.
Twenty-minute weekly review
- Spend five minutes checking source health and removing obvious duplicate or irrelevant URLs.
- Spend five minutes grouping the remaining pages by topic, audience, and page type.
- Spend five minutes comparing the movement with your current roadmap and existing coverage.
- Spend five minutes assigning no more than three actions.
- New guides, comparisons, alternatives, integration pages, and use-case pages.
- Meaningful updates to pages that compete with your priority content.
- Clusters of new pages aimed at one audience or problem.
- Changes in publishing frequency or page mix.
- Broken or stale sources that could create a monitoring blind spot.
- The one or two findings most likely to affect this month's plan.
Do not log every backlink, ranking fluctuation, social post, or minor copy change. Fill the External columns only for rows that survive triage; everything else makes a small team less likely to maintain the sheet.
When to move beyond the sheet
When source checks and duplicate handling take longer than the review itself, move the collection and review layer into a system that preserves source status and candidate history. The Content Radar product is built around that transition, while this template can remain the decision record.
The template is one of three formats with different jobs. For the recurring task list, use the SEO competitor monitoring checklist. For charts and stakeholder reporting built on top of this record, see the SEO competitor dashboard guide.
Template rule for lean teams If a field does not help someone choose, prioritize, assign, or revisit an action, remove it. Lightweight templates survive because every column earns its maintenance cost.
Keep the template fed with publishing evidence
Start with the sheet, then use Content Radar when source checks, candidate review, and publishing movement need a shared home.