Competitive Analysis Template: Copy, Paste, Keep It Current
, 8 min, By Ahmet Nuri Ozcelik
Copy a competitive analysis template where every cell has a source and a last-checked date, so stale answers show. Paste-ready text included.
Quick answer: A competitive analysis template is a set of questions about each rival plus a rule for keeping the answers current. The sections that earn their place are who they sell to, positioning, product and packaging, published pricing, where they are strong, where you win, and what changed since last time, with a source and a last-checked date on every cell. Without that rule, the same template becomes a snapshot that quietly goes stale.
A competitive analysis template looks finished the day you fill it in, and that is the problem. Six months on, the grid looks just as confident, and nothing shows which cells have aged. Layout is the easy part. The rule that makes old answers visible is the hard part.
What is a competitive analysis template (and why do they go stale)?
A competitive analysis template is a structured way to collect, compare and evaluate how rivals sell, position, package and price. "Competitor analysis template" means the same thing, so this one guide covers both.
It helps to separate three artifacts:
- The template is the questions.
- The analysis is the filled-in answers for each rival.
- The report is the output the analysis feeds, covered below.
Frameworks like Porter's five forces start from the structure of a whole market: new entrants, substitutes, suppliers, buyers and rivalry. This template deliberately narrows that to rival-level questions you can maintain.
My argument is simple. You probably own competitive work next to launches, messaging and enablement, so the template has to be cheap to maintain. A grid that is expensive to recheck gets rechecked once, then it ages in silence.
The sections that earn their place
Seven rows survive. For each, one question and where the evidence comes from.
- Who they sell to. Which segment, buyer role and industries? Evidence: their own site and customer stories.
- Positioning. How do they describe the problem and themselves? Quote the page, in their words. To judge it, start from the competitive alternatives a buyer would otherwise pick, an idea April Dunford puts at the start of her positioning process, rather than from a feature list.
- Product and packaging. What is sold, how is it bundled, and what do they call out as a plan difference? Mark features you haven't checked as unverified.
- Pricing as published. Only what their pricing page shows, with the date you read it. If it is quote-only, write "quote-only", not a guess.
- Where they are strong, and where we win. State their strengths fairly. Draw "where we win" from your own evidence: win/loss analysis from closed deals and customer conversations.
- What changed since last time. This is the one column that is a log, not a snapshot. Every entry is dated.
- So what for sellers. One line per section. It is what lets the analysis become a battlecard later.
The sections to cut
This is my view, not a survey of what other templates do: a row you can't source or won't recheck is worse than no row. It looks as reliable as the rest.
The usual candidates to cut or shrink:
- A generic four-box SWOT per competitor
- Company history
- A long list of every feature the rival has
- Any "market share" or "revenue" row with no retrieved source
Use a keep-or-cut test on every row. Can I name the page this answer came from, and will I recheck it? If either answer is no, cut the row.
A competitive analysis template you can paste
Paste this into a doc or a sheet. It works as a competitive analysis template in Excel, Google Sheets, Word, a slide or a PDF, because the structure is the same in each. I'm not offering a download. Put it where your team already works.
COMPETITOR: [name]
DATE OF ANALYSIS: [YYYY-MM-DD]
OWNER: [name]
NEXT RECHECK: [date, set by your stale window]
ROW | ANSWER | SOURCE | LAST CHECKED | STATUS
Who they sell to | | [page URL] | [date] | verified / unverified / stale
Positioning (their words) | | [page URL] | [date] |
Product and packaging | | [page URL] | [date] |
Pricing as published | | [pricing page URL, or "quote-only"] | [date] |
Where they are strong | | [page URL or note] | [date] |
Where we win | | internal: closed deals | [date] |
What changed since last time | [date: change] | [page URL] | [date] |
So what for sellers | | [row it comes from] | [date] | Here is a filled-in sample. Competitor X is invented, and every entry is illustrative, not a claim about any real company.
COMPETITOR: Competitor X (illustrative)
DATE OF ANALYSIS: 2026-11-02
OWNER: PMM
NEXT RECHECK: per stale window, pricing first
Who they sell to | Mid-size operations teams (invented) | example.com/customers | 2026-11-02 | unverified
Positioning (their words) | "Run every workflow in one place" (invented quote) | example.com/ | 2026-11-02 | verified
Pricing as published | Three tiers listed; top tier quote-only (invented) | example.com/pricing | 2026-11-02 | verified
Where we win | Pattern from our own lost and won deals (invented) | internal: closed deals | 2026-10-20 | stale
What changed since last time | 2026-10-28: plan comparison lists a new tier (invented) | example.com/pricing | 2026-10-28 | verified
So what for sellers | Ask which tier the buyer was quoted (invented) | pricing row | 2026-11-02 | verifiedNote the "Where we win" row. It's marked stale because its date is old relative to the window I chose. That is the whole point.
Make staleness visible: a source and a last-checked date on every cell
The rule is no cell without a source and a date. A cell with neither is marked unverified. It is never left blank-looking-confident.
Then set a stale rule you choose yourself: any cell not rechecked inside a window you pick is marked stale. The window is your decision, not a benchmark.
Rank rows by how fast they can move. My hypothesis, which you should test against your own rivals, is that pricing, packaging and the change log move fastest, positioning moves more slowly, and who they sell to moves slowest. Recheck the fast rows more often.
Be honest about the cost. Rechecking pricing and product pages by hand across several competitors is the part that gets skipped. This is my own framing of the trade-offs, not a survey of tools:
| Way to keep "what changed" current | Strength | Weakness |
|---|---|---|
| Recheck by hand on a calendar reminder | Free, and you read the page | Depends on you remembering, and scales badly with each competitor |
| Page-change alerts you set up yourself | Tells you a page changed | You still decide what it means, whether to record it, and where it goes |
| Competitive intelligence software | Labelled changes, a review step, a dated record | Costs money, and doesn't replace interviews or field intel |
From analysis to a report people will read
A competitive intelligence report template is not a second document to maintain. It is a view of the analysis: one page, built from the template rows.
A structure that works:
- Headline changes since the last report
- A short summary per competitor, pulled from the rows
- Implications for positioning and battlecards
- Open questions and unverified items
Keep the same source-and-date discipline, so a reader can trace any sentence to a cell. And split the audience: the full template is for the owner, and the one-page report is for leadership and sales.
Keeping the "what changed" column current without rechecking by hand
Discera is competitive intelligence software for product marketers. Discera Intel monitors competitors, explains meaningful changes, keeps a dated, searchable history, and helps keep battlecards current. It needs no Gong and no call recorder.
Here is how it runs the template's freshness rule for Competitor X (still illustrative):
- Add the competitor. Discera watches up to 25 key pages on the competitor's own website: pricing, product, changelog, blog, newsroom and customer stories. It captures them daily and checks for meaningful changes each night.
- Read the labelled change. Each one is labelled (pricing change, plan change, product launch, feature added or removed, messaging change) with the changed text as evidence.
- Decide in the review queue. A team member approves, rejects or snoozes it. Only approved changes enter the competitor's dated record.
- Map it to the template. Approved, dated changes become your "what changed" rows, and each points back to the captured page for source and date. Comparing two dates answers "what was their pricing last quarter?"
The feature matrix compares competitor features with your own company's. Extracted features stay labelled unverified until an admin promotes them, which matches the template's status field. Sitemap watch lists a rival's newly published pages in one "New pages" item, and nothing is tracked until an admin chooses a page.
The limits matter. Discera watches competitors' own websites only. It does not watch review sites, third-party news, job pages or social profiles. A change needs two captures, so there is nothing to show on day one. Interviews, field intel and enablement at scale stay manual, or belong to the enterprise CI programs built for them.
On plans, Intel Starter is $99/mo for 5 competitors. Email digests are on every Intel plan, and Slack alerts are on Growth and Scale. The Intel trial runs 7 days and needs a card, you get one trial per payment card, and you aren't charged if you cancel before it ends. More on competitor monitoring, and on tracking changes on competitor websites.
From analysis to a seller card
Your "so what for sellers" rows are the raw material for a battlecard. Competitive battlecards that stay current take the next step. In Discera, battlecards draft from the competitor's record, every claim cites its source, and a nightly check proposes what to retire, recheck or correct, as suggested updates your team approves. It isn't automatic.
For the "where we win" row, the manual route is customer research from sales and customer conversations.
If your team captures those conversations in Gong, Discera Calls works with it, read-only. It is its own plan and can be bought on its own. It adds buyer quotes and win/loss stories to a battlecard, which needs Calls Growth or Scale plus any Intel plan.
FAQ
What should a competitive analysis template include?
Seven rows per rival: who they sell to, positioning in their own words, product and packaging, pricing as published, where they are strong, where you win, and a dated log of what changed. Give every row an answer, a source, a last-checked date and a status (verified, unverified or stale). Add a one-line "so what for sellers" so the analysis can feed a battlecard.
What is the difference between a competitor analysis template and a competitive analysis template?
In practice, nothing that needs a second document. Both collect, compare and evaluate how rivals sell, position, package and price. Use one template, and treat the report as the output it feeds, not a separate thing to maintain.
How often should you update a competitive analysis?
There is no universal interval, so choose your own stale window and write it down. My hypothesis is that pricing, packaging and the change log move fastest and deserve the shortest window, while who they sell to moves slowest. Any cell not rechecked inside its window gets marked stale.
Can I use Excel or Google Sheets for a competitive analysis template?
Yes. The structure is the same in Excel, Google Sheets, a Word or Google doc, a slide deck or a PDF export. One row per question, with columns for answer, source, last checked and status, works anywhere. Paste it where your team already works.
How do you turn a competitive analysis into a report?
Treat the report as a view of the analysis. Write a one-page summary with the headline changes since the last report, a short summary per competitor drawn from the template rows, what it means for sellers and positioning, and the open or unverified items. Keep the source and date on every sentence so a reader can trace it to a cell.
Start a free trial at discera.ai. The Intel trial runs 7 days and needs a card, you get one trial per payment card, and you aren't charged if you cancel before it ends.