All posts
Allen
Author, Content Operations Manager·Originally published Nov 10, 2025 · Updated Nov 3, 2026
Competitor analysis template cover listing five templates and a weighted score card comparing Notion, Obsidian and AFFiNE

Competitor Analysis Template: 5 Free Sheets + Example

A competitor analysis template is a reusable set of tables for comparing rivals on the same fields: who they serve, what they offer, what they charge, how they win search traffic, and how they score against your priorities. Below are five free templates you can copy into AFFiNE, Google Sheets or Excel. Each one is filled in with a real example from the note-taking app market: Notion, Obsidian and AFFiNE.

All vendor facts were checked on each vendor's official pages on November 3, 2026. Prices change, so recheck them before you act on them. AFFiNE publishes this blog and is one of the three products in the example. We kept every claim tied to a public source and show a weight set where Notion comes out ahead.

Downloads:

The five templates at a glance

TemplateQuestion it answersUse it when
1. Competitor profile and SWOTWho is this rival and where are they strong or weak?You add a new competitor or brief a team
2. Feature comparison matrixWho supports which capability?You plan a roadmap or prepare a sales battlecard
3. Pricing and packaging comparisonWhat does each plan cost and unlock?You set prices or handle "too expensive" objections
4. SEO and PPC competitor trackerHow does each rival win search traffic?You plan content or a paid search campaign
5. Weighted scoring matrixWho wins for a specific buyer, and why?You need one ranked recommendation

Templates 1 to 4 collect evidence. Template 5 turns that evidence into a decision. Start with the ones that match your objective; you rarely need all five in one pass.

The example: three note-taking apps

The example plays out one realistic decision: a 5-person product team choosing a shared workspace for docs, research notes and visual planning. The three products take very different approaches:

  • Notion is a cloud workspace built around databases and, increasingly, AI agents.
  • Obsidian is a free app that keeps notes as Markdown files on your device, with paid add-ons for sync and publishing.
  • AFFiNE combines docs and a whiteboard in one workspace, works locally first, and can be self-hosted.

That spread is useful. A good template has to compare a per-seat cloud product, a free local app with add-ons and a hybrid without forcing them into the same shape. For a broader buyer's view of this market, see our Notion alternatives comparison and Obsidian vs Notion.

Template 1: Competitor profile and SWOT

A profile is one page per competitor. It records the basics so everyone works from the same facts. The SWOT then interprets those facts from your point of view. Keep both in the same doc: the profile is evidence, the SWOT is opinion, and readers should see the difference.

Profile fields to copy:

FieldNotionObsidianEvidence
Positioning (homepage title)The AI workspace that works for you.Sharpen your thinking.Homepages
Core productCloud docs, databases and AI agentsLocal Markdown notes in a vault on your deviceProduct pages
Who it targetsTeams and companies ("One tool to run your company")Individuals first; teams through shared Sync vaultsPricing pages
Business modelPer-seat plans: Free, Plus, Business, EnterpriseFree app; paid Sync and Publish; optional commercial licensePricing pages
Entry paid pricePlus: $10 per seat/month, billed annuallySync Standard: $4 per user/month, billed annuallyPricing pages
Where data livesNotion cloud; offline pages in desktop and mobile appsFiles on your device; Sync is end-to-end encryptedPricing, Sync and Help pages
ConfidenceHigh: first-party pagesHigh: first-party pagesChecked 2026-11-03

The "Evidence" column carries the most weight. Write down where every cell came from and when you checked it. A profile without sources goes stale quietly, and nobody can tell which parts are still true.

SWOT for Notion, seen from AFFiNE:

QuadrantPoint (Notion, seen from AFFiNE)EvidenceConfidence
StrengthDatabases with subtasks, dependencies and custom properties on every planNotion pricing pageHigh
StrengthLarge template ecosystem: the marketplace lists 30,000+ templatesnotion.com/templatesHigh
WeaknessFree plan caps uploads at 5 MB and page history at 7 daysNotion pricing pageHigh
WeaknessOffline needs the desktop or mobile app; Free users download pages one by oneNotion Help: Use pages offlineHigh
OpportunityNo whiteboard is listed on the pricing page, so teams that sketch add a second toolNotion pricing pageMedium: absence of a listing
ThreatBusiness bundles Notion Agent and AI Meeting Notes at $20 per seatNotion pricing pageHigh
Notion SWOT grid seen from AFFiNE, with two strengths, two weaknesses, one opportunity and one threat, each tagged with its evidence source and confidence level
The SWOT from the example as a four-quadrant grid. Illustrative render built from the published data.

Two rules keep a SWOT honest. First, strengths and weaknesses describe the competitor, while opportunities and threats describe what that means for you. Second, rate confidence for every point. "Not listed on the pricing page" is weaker evidence than a documented limit, so the whiteboard point is marked Medium. For more layouts, see these editable SWOT analysis templates.

Template 2: Feature comparison matrix

The feature matrix puts capabilities in rows and competitors in columns. It answers one question fast: who supports what? Write each cell as a short fact with its limit ("Yes; 3 members on Free"), not as a bare checkmark. Most real differences live in the limits.

CapabilityNotionObsidianAFFiNE
Free planYes; 5 MB uploads, 7-day page historyApp is free with no sign-upUnlimited local workspaces; Cloud Free 10 GB, 3 members
Offline useDesktop and mobile apps, per downloaded pageYes; notes are files on your deviceYes; local workspaces in the desktop app
Databases and tablesYes; subtasks, dependencies, custom propertiesBases core plugin: table views over notesDatabase blocks inside docs
Whiteboard or canvasNot listed on the pricing pageCanvas core pluginEdgeless mode turns any doc into a whiteboard
Shared editingYes, on every planShared vaults through Sync, per userYes; 3 members on Free, 10 on Pro
Self-hostingNot offeredNot needed; vaults are local foldersFree self-host up to 10 seats per workspace
Built-in AITrial on Free and Plus; Notion Agent on BusinessNot listed on the pricing pageAFFiNE AI add-on, $8.90/month billed annually
Import from NotionNot applicableOfficial Importer pluginBuilt-in Notion import
Source codeProprietaryProprietary (free app)Editor MIT; server source-available
Feature comparison matrix for Notion, Obsidian and AFFiNE covering free plan, offline use, databases, whiteboard, shared editing and self-hosting
The first six rows of the feature matrix. Illustrative render built from the published data.

How to read it: no tool wins every row. Notion leads on databases and team features. Obsidian leads on plain local files and privacy. AFFiNE is the only one of the three with a whiteboard built into every doc and a free self-hosted option. That is the point of a matrix: it shows trade-offs, not a winner.

Acceptance rules: decide before you fill the table what counts as "supported". In this example, a capability counts only when it ships in the product or as an official core plugin. Community plugins and third-party embeds go in notes, not in the cell. Sources: Notion pricing, Notion offline help, Obsidian Canvas, Obsidian Bases, Obsidian Importer, AFFiNE pricing and AFFiNE self-host.

Template 3: Pricing and packaging comparison

List prices tell you little until you line up what each plan unlocks and where it stops. This template carries the pricing fields that matter in practice: plan name, list price and billing period, what the plan unlocks, and the limits that force an upgrade.

PlanList priceWhat it unlocksLimits to note
Notion Free$0Pages, databases, basic forms and sites5 MB uploads; 7-day history; block limit for 2+ members
Notion Plus$10 per seat/month, billed annually5 GB uploads, 30-day history, charts, custom sitesNotion AI is a trial only
Notion Business$20 per seat/month, billed annuallyNotion Agent, AI Meeting Notes, SAML SSO, 90-day history1,500 Standard + 500 Select AI credits per seat/month
Obsidian app$0Every core feature, for personal and commercial useCommercial license optional: $50 per user/year
Obsidian Sync Standard$4 per user/month annually ($5 monthly)Sync, end-to-end encryption, shared vaults1 vault, 1 GB, 5 MB files, 1-month history
Obsidian Sync Plus$8 per user/month annually ($10 monthly)10 vaults, 10 GB, 200 MB files12-month history
Obsidian Publish$8 per site/month annually ($10 monthly)Publish notes to the webPriced per site, not per user
AFFiNE Free$0Unlimited local workspaces; Cloud 10 GB10 MB files, 3 members, 7-day history, 3 devices
AFFiNE Pro$6.75/month, billed annually100 GB, 100 MB files, up to 10 members30-day version history
AFFiNE Team$10 per seat/month100 GB + 20 GB per seat, 500 MB files, admin rolesBilled per seat
AFFiNE AI$8.90/month, billed annuallyAI writing, mind maps and slidesAdd-on to any plan

Then translate the list prices into what your buyer would actually pay. This is the step most pricing comparisons skip:

5-person teamNotionObsidianAFFiNE
Cheapest plan with shared editingPlus: $600/yearSync Standard x5: $240/yearPro: $81/year (owner plan, up to 10 members)
Plan with admin controlsBusiness: $1,200/year (SAML SSO)Not listed on the pricing pageTeam: $600/year (multiple admin roles)
Discounts listedPlus free for students and educators (1 member)40% off Sync and Publish for students and nonprofits15% saving on annual billing
Bar chart of annual cost for a 5-person team: Notion Plus $600, Obsidian Sync Standard for five users $240, AFFiNE Pro $81, Notion Business $1,200 and AFFiNE Team $600
Annual list cost for the 5-person team in the example. Illustrative render built from the published data.

Notes on the math. Notion Free is not an option for this team, because blocks are limited once a workspace has two or more members. Obsidian's app is free, but shared vaults need Sync, which is priced per user. AFFiNE Pro is priced per account, and the pricing page lists up to 10 members per workspace on that plan, so check how the owner's plan applies to your workspace before you buy. Sources: Notion pricing, Obsidian pricing, Obsidian Sync and AFFiNE pricing.

Fields to add for your market: trial terms, overage fees, minimum contract length, implementation or onboarding fees, support response times and promotional discounts. Leave a cell empty when the vendor does not publish a number, rather than guessing. If you sell physical products, add a row for how rivals present the offer, because premium packaging can justify a higher price than the plan or product details alone.

Template 4: SEO and PPC competitor tracker

Search is often where buyers first compare you with competitors. This template has two tabs. The SEO tab records how each competitor presents itself to search engines. The PPC tab checks whether the page a searcher lands on matches what they searched for.

SEO signals:

SignalNotionObsidianAFFiNE
Homepage title tagThe AI workspace that works for you. | NotionObsidian - Sharpen your thinkingAFFiNE — Open-Source Knowledge Base Software
Pricing page title tagNotion Pricing Plans: Free, Plus, Business, & Enterprise.Pricing - ObsidianAFFiNE Pricing 2026: Free, Pro, Team Plans from $0
Template or plugin hubNotion Marketplace: 30,000+ templatesCommunity plugin directoryaffine.pro/templates gallery
Help and docs hubnotion.com/helpobsidian.md/helpdocs.affine.pro
Referring domainsAdd from your SEO toolAdd from your SEO toolAdd from your SEO tool
Top non-branded keywordsAdd from your SEO toolAdd from your SEO toolAdd from your SEO tool

The title tags already tell you something. Notion and AFFiNE put "pricing" and plan names in their pricing page titles, so they compete for "pricing" searches. Obsidian's pricing title is simply "Pricing - Obsidian" and relies on its brand. Rows marked "Add from your SEO tool" are left for you to fill in. Pull referring domains and non-branded keywords from Ahrefs, Semrush or Similarweb, and use Google Search Console for your own site. We did not publish third-party traffic estimates, because they vary widely between tools.

PPC and landing page check:

Keyword themeLanding pageAbove-the-fold headlinePrice shown
notion pricingnotion.com/pricingOne tool to run your company.Yes: $0 / $10 / $20 plan grid
notion ainotion.com/product/aiAI that works where your team works. Try for free.Yes: Free and Business tiers
obsidian syncobsidian.md/syncAll your notes, on all your devices.Yes: "$4 per month" button
affine pricingaffine.pro/pricingPricing for the all-in-one workspaceYes: Free, Pro and Team grid
Table checking four search keyword themes against the landing page each one leads to, its above-the-fold headline and whether a price is visible
Landing page message match for four keyword themes. Illustrative render built from the published data.

This table records the landing pages and their headlines as they appeared on November 3, 2026. It does not claim that any vendor is running ads on these terms. To complete the paid side, look up each competitor in the Google Ads Transparency Center and add three columns: ad headline, offer type (free trial, discount or demo) and the date you saw it. Then add estimated cost per click from Google Ads Keyword Planner. One pattern stands out: all four pages show a price above the fold, so a competing ad that hides pricing behind "Contact us" starts at a disadvantage.

Template 5: Weighted scoring matrix

The scoring matrix turns templates 1 to 4 into one ranked answer for one specific buyer. Pick four to six criteria that matter to that buyer, give each a weight that adds up to 100%, score every competitor from 1 to 5, and multiply.

CriterionWeightNotionObsidianAFFiNE
Docs and databases25%534
Whiteboard and visual planning20%245
Offline and local data20%354
Team collaboration and admin20%523
Annual cost for 5 people15%344
Weighted total100%3.703.554.00
CriterionWhy the scores differ
Docs and databasesNotion databases are the deepest; Obsidian Bases is newer
Whiteboard and visual planningNo whiteboard on Notion's pricing page; Obsidian Canvas; AFFiNE Edgeless
Offline and local dataObsidian is files on disk; AFFiNE local workspaces; Notion per-page offline
Team collaboration and adminNotion Business has SSO; Obsidian shares vaults through Sync
Annual cost for 5 people$600 vs $240 vs $81 on the cheapest shared plan

The weights carry as much weight as the scores. Change them and the ranking changes:

Weight setNotionObsidianAFFiNE
Visual planning team (base case) (25/20/20/20/15)3.703.554.00
Database-heavy operations team (35/10/10/30/15)4.203.153.80
Bar chart comparing weighted scores for Notion, Obsidian and AFFiNE under two weight sets: AFFiNE leads for a visual planning team, Notion leads for a database-heavy operations team
The same 1-5 scores under two weight sets. Illustrative render built from the published data.

For the visual planning team in the base case, AFFiNE scores highest. For an operations team that lives in databases and needs admin controls, Notion wins. A solo writer who mainly wants plain files on disk would likely choose Obsidian. Write the weights down before anyone scores, so nobody can tune them to reach a preferred answer. The workbook's scoring tab uses SUMPRODUCT, so totals update as soon as you change a weight. For more scoring layouts, see the decision matrix template.

Close with a recommendation block: the decision, the main reason, the biggest risk, the owner and the next review date. Example: "Pilot AFFiNE with the product team for 30 days. Reason: docs and whiteboard in one place at the lowest cost. Risk: database features are lighter than Notion's. Owner: product ops. Review: in 30 days."

How to use these templates in AFFiNE, Google Sheets or Excel

  • AFFiNE: open the competitor analysis template, or paste any table from this page into a doc. Switch the doc to Edgeless mode to sketch a 2x2 positioning map beside your tables, and keep source links in the same workspace.
  • Google Sheets: download the filled or blank workbook, then go to File > Import > Upload in Google Sheets. Each template becomes its own tab, and the scoring formula keeps working. You can also import any single CSV.
  • Excel: open the workbook directly. Freeze panes and column widths are already set.

How to run a competitor analysis in six steps

  1. Write a one-sentence objective. Name the decision the analysis supports, for example "Choose a workspace for the product team by December 1." Choose the templates that serve that decision.
  2. Pick a framework. Use SWOT to frame strategy, Porter's Five Forces for industry pressure, the 4Ps (product, price, place, promotion) for marketing, and a feature matrix for product parity.
  3. Build the competitor list. Include direct competitors (same product, same buyer), indirect ones (same job, different approach) and substitutes such as a shared drive full of documents. Write down your inclusion rules.
  4. Collect evidence with provenance. Prefer first-party sources: pricing pages, documentation, help centers and release notes. Use reviews and analyst reports for context. Record the source, the date checked and a High, Medium or Low confidence rating for every cell.
  5. Score and normalize. Use one 1-5 scale with written definitions. For raw numbers such as price, rescale with (x - MIN) / (MAX - MIN), and reverse it when lower is better.
  6. Decide and assign owners. End with a recommendation, an owner and a review date. Link the gaps you find to a gap analysis or your go-to-market plan.

Keep the analysis current

Competitor facts expire. In this example, AI packaging and credits are the fields most likely to change, so they need the most frequent checks.

  • Monthly: recheck pricing pages and the PPC landing page table.
  • Quarterly: refresh the feature matrix, SEO signals and scores, and archive the previous version for comparison.
  • On events: update right away after a competitor launch, a price change or a new entrant.

Assign one owner and keep a change log row for every edit: date, field, old value, new value and source. That one habit is what keeps a team trusting the template.

Competitor analysis template FAQs

What should a competitor analysis template include?

At minimum: a profile for each competitor, a feature comparison, a pricing comparison and a scoring matrix that ends in a recommendation. Add an SEO and PPC tab if search is a major channel. Every cell should record its source, the date checked and a confidence rating.

How do you write a competitor analysis?

Write a one-sentence objective, list direct and indirect competitors, and collect evidence from first-party sources such as pricing pages and documentation. Record it in consistent templates, score each competitor against weighted criteria, and finish with a recommendation, an owner and a review date.

What are the 4 Ps of competitor analysis?

Product, price, place and promotion. In a competitor analysis you compare what each rival offers, how it charges, where and through which channels it sells, and how it markets itself. Templates 2, 3 and 4 on this page cover product, price and promotion.

What are Porter's five forces in competitor analysis?

Competitive rivalry, the threat of new entrants, the threat of substitutes, buyer power and supplier power. Use them to judge the pressure across a whole industry, then use a feature matrix and a scoring matrix to compare specific rivals.

Is there a competitor analysis template for Google Sheets?

Yes. Download the filled or blank workbook on this page and import it into Google Sheets with File > Import > Upload. Each template becomes its own tab, and the weighted scoring formula keeps working after import.

How often should you update a competitor analysis?

Check pricing and landing pages monthly, refresh features, SEO signals and scores quarterly, and update right away after a competitor launch or price change. Keep a change log so readers can see what changed and when.