June 11, 2026 · 13 min read · by Iris Wei
The Competitive Analysis Template I Actually Use (2026, 10 steps + free sheet)
In March 2026, a YC founder I was advising sent me a 47-page competitive analysis their team had spent two weeks producing. Their conclusion: "we're better on 14 of 22 features." Their roadmap after the exercise: unchanged. Here's the 10-step template I send people now — 90 minutes per competitor, designed to actually change what you ship.
Key Stats (Updated June 2026)
- Total time: ~90 minutes per competitor (8-10 hours for a 5-7 competitor sweep)
- Competitor count: 5-7, using the 3-bucket rule (2 direct / 2 adjacent / 1-2 substitutes)
- Refresh cadence: every 90 days + event-driven (raise / launch / reposition)
- Output: 1 wedge decision, 2-3 sprint commitments, 1 compete/avoid matrix — not a feature spreadsheet
The reason most competitive analyses don't change anything
Almost every competitive analysis I see suffers from the same pattern: someone makes a giant feature grid, color-codes who has what, and then… nothing. The roadmap doesn't change. The positioning doesn't change. The pricing doesn't change. Six months later, someone re-does the grid.
The reason is structural — a feature grid describes the current state but doesn't force a decision. And without a forced decision, the work was performative.
The template below inverts that. It starts with the decision you're trying to make, picks the smallest competitor set that informs it, and ends with a 6-week sprint commitment you can write down on a single sticky note. If you can't write that sticky note at the end, the analysis was a waste — and the template tells you so explicitly.
The 10-step template
1Define the strategic question first
Before you open a single competitor's website, write down the one decision this analysis will inform. Pick from a short list: pricing, positioning, primary channel, feature priority, or category framing. If you can name three, you're really doing three analyses — split them.
The litmus test: at the end of this analysis, what specifically will be different in next sprint? If the honest answer is "we'll know more about our competitors," that's not a strategic question, that's homework.
2Pick 5-7 competitors using the 3-bucket rule
The bucket counts matter more than the names:
- 2 direct — same problem, same ICP. These are who your buyer puts you on a side-by-side comparison with.
- 2 adjacent — same problem, different ICP (or vice versa). These tell you whether the category is consolidating or fragmenting.
- 1-2 substitutes — different category, same job-to-be-done. These are who you actually lose to when you "lose to no decision" — the spreadsheet, the manual workflow, the Slack channel.
Above 7 competitors, you add competitors that don't actually compete for your customer's attention or budget. The signal dilutes. Resist.
3Map the strategic question to data sources
Each strategic question has a small, specific data spine. Don't collect what's outside it.
| Strategic question | Primary data sources |
|---|---|
| Pricing | Pricing page (current + Wayback 12 months back), public reviews, sales-call notes |
| Positioning | Homepage hero copy, OG tags, LinkedIn company tagline, founder X bio |
| Primary channel | SimilarWeb / DataForSEO traffic source breakdown, Google Trends, founder X cadence, Product Hunt history |
| Feature priority | Changelog, public roadmap, last 90 days of release notes, X "what's new" threads |
| Category framing | How they describe themselves on G2, Capterra, ProductHunt categories, ICP testimonials |
If you're tempted to collect data outside the spine, ask: "what decision would this datum change?" Usually nothing — skip it.
4Run the 90-minute extraction loop per competitor
This is the timeboxed part. Per competitor:
- 10 min — homepage teardown (hero, social proof, CTAs, primary nav)
- 5 min — traffic / channel snapshot (SimilarWeb preview or multi-source audit)
- 10 min — social proof scan (Twitter founder, Reddit mentions, Product Hunt history)
- 5 min — pricing diff (current page + Wayback 12 months ago)
- 5 min — feature gap quick-list (NOT a full matrix — just the gaps that matter for your question)
- 10 min — synthesis: write 3 sentences answering "what does this competitor tell me about my strategic question?"
The synthesis paragraph is the point of the exercise. If you can't write those 3 sentences, your strategic question wasn't crisp enough — go back to step 1.
5Fill the comparison matrix (not a feature matrix)
This is the most common deviation: people fill a feature matrix at this step and call it strategy. Don't. Build a strategic matrix instead — the dimensions are:
- Positioning — one sentence in their own words
- Primary channel — SEO / social / sales / community / paid
- Pricing model — flat / seat / usage / freemium / sales-led
- ICP — who they obviously sell to (look at testimonials)
- Founder distribution — does the founder personally drive demand, yes/no
5 dimensions × 5-7 competitors = 25-35 cells. Fits on one screen. Forces you to compare strategy, not feature counts.
6Score competitive intensity 1-5 per dimension
For each cell in the matrix, score 1-5: how hard would it be for you to outperform this competitor on this dimension?
- 1 — trivially easy (they're absent or weak on this dimension)
- 3 — would require focused effort but doable in 2 quarters
- 5 — they have a structural moat here you can't realistically overcome
Be brutally honest. Optimism here costs you 6 months. The total per-competitor score tells you who's actually a threat; the per-dimension column sums tell you where the category is hardest to differentiate (high column sum = crowded dimension, low = open dimension).
7Identify the wedge — one dimension you can dominate
You will not beat everyone on everything. Find the one dimension where:
- You have a structural advantage (founder background, distribution channel, unfair access)
- The column sum (step 6) is low — i.e., the dimension is wide open
- Your ICP cares about it (gut-check this against last 5 customer interviews)
The wedge is the answer to "if a buyer can only remember one thing about us, what's that one thing?" If you can't name it after this step, the analysis isn't done — you haven't found a wedge, which is itself an answer (you may be in a saturated category and the move isn't to compete but to reposition).
8Build the compete-vs-avoid decision matrix
For each competitor, pick exactly one stance:
| Stance | When to pick it |
|---|---|
| Compete head-on | Same wedge, you have edge — rare, only 1-2 competitors max |
| Differentiate | Adjacent on most dimensions but your wedge differs — common, usually 2-3 competitors |
| Partner | They solve a layer your customers also need — typical for substitutes |
| Avoid | They've already won their ICP segment; don't waste cycles fighting there |
Most founders default to "compete" for all competitors. That's a tell. Usually "differentiate" or "avoid" is the right call for 60-70% of the list.
9Convert the wedge into a 6-week roadmap commitment
This is the output that justifies the entire exercise. Pick 2-3 concrete actions that operationalize the wedge over the next 6 weeks. Examples:
- "Rewrite homepage hero around the wedge by Friday" (positioning wedge)
- "Ship 3 new comparison pages targeting competitor keywords by sprint end" (channel wedge)
- "Add the one feature competitors lack that closed our last 3 demos" (feature wedge)
Anything that doesn't reinforce the wedge gets cut from the sprint. This is where competitive analysis goes from artifact to behavior change.
10Set a 90-day refresh trigger
Competitive landscapes shift faster in 2026 than they did pre-AI — pricing changes in 6 weeks, positioning pivots in 3 months, channel mix shifts within a quarter. Calendar a 90-day refresh, plus event-driven refreshes when any competitor:
- Raises a round (changes their willingness to spend)
- Ships a major launch (changes the category narrative)
- Repositions publicly (changes the wedge map)
- Starts a paid acquisition push (changes the CAC environment)
If the analysis is older than 90 days, treat it as historical context, not strategic input.
The free Google Sheet template
I put the actual sheet here so you can copy it: → Make a copy of the Competitive Analysis Template (Google Sheets). Sheets included:
- 0. Strategic question — top of every analysis, forces step 1
- 1. Competitor list — with the 3-bucket tags pre-filled as a dropdown
- 2. Data spine — one row per competitor × the 5 strategic dimensions
- 3. Intensity scores — auto-summed columns + rows so you see crowded vs. open dimensions at a glance
- 4. Wedge worksheet — the gut-check questions for step 7
- 5. Stance decisions — compete / differentiate / partner / avoid per competitor
- 6. Sprint commitments — the 2-3 actions that go into the next planning meeting
It looks ugly. It's deliberately ugly — every minute spent making it pretty is a minute not spent shipping the wedge.
When to use a tool instead of the sheet
The sheet handles 95% of founder use cases. Upgrade to a competitive intelligence tool when:
- You have a dedicated CI / product marketing role whose job is competitive monitoring (Crayon, Klue — enterprise category)
- Competitor changes happen faster than your 90-day refresh can catch (a multi-source aggregator like Analook handles the data-collection side in 60 seconds vs. 90 minutes)
- You're enabling a sales team that needs battlecards per competitor (different output shape — feature-and-objection focus, not strategic-wedge focus)
Most pre-Series-A founders don't hit any of those triggers. Use the sheet, refresh quarterly, ship the wedge.
The mistakes that turn this into busywork
In order of damage caused:
- Skipping step 1. Without a strategic question, you produce description, not strategy. The grid will be beautiful and pointless.
- Building a feature matrix instead of a strategic matrix. 22 features × 7 competitors = 154 cells that don't change anything. 5 dimensions × 7 competitors = 35 cells that force a wedge decision.
- Defaulting to "compete head-on" for everyone. A clear signal you haven't done step 7 honestly. If everyone's a head-on threat, no one is.
- No 6-week sprint commitment. If the artifact dies in the doc, the analysis was performative. The sprint commitment is the only real output.
- Skipping the refresh trigger. Analysis dies fast in 2026. Treat anything 90 days old as historical context.
Why this template, not the famous ones
Porter's Five Forces is a macro lens — great for boards, slow for founders. SWOT is a thinking aid, not an analysis framework. The McKinsey-style 3-week competitive deep-dive is overkill for everything short of an M&A decision.
The 10-step template is the smallest thing I've found that consistently produces a wedge decision and a sprint commitment within a single afternoon. It's been refined across roughly 150 audits — AFFiNE-era competitive work, Gingiris client engagements, and now Analook's users. The structure stays the same; only the data sources get faster as tools improve.
If you take one thing from this: the artifact is not the point — the wedge is. Everything in the template is in service of forcing you to pick a wedge and ship against it for 6 weeks. Anything that doesn't do that, cut.
Skip the 90-minute extraction loop
Analook runs steps 3 + 4 (the data-collection part) in 60 seconds per competitor — multi-source: traffic, SEO, social, Product Hunt, Wayback, pricing, GitHub. Every claim sourced + confidence-tagged. You still own steps 1, 7, 8, 9 — the strategy parts that matter.
Run a free audit →