Most competitive analysis templates are empty spreadsheets with nice formatting and no instructions. You download one from HubSpot or Asana, stare at 40 blank cells, and realize you have no idea where to find half the data they're asking for.
We built this competitive analysis template differently. Every section includes specific data sources you can use to fill it in. The scoring matrix lets you compare competitors using consistent weights.
In Crayon's 2025 State of Competitive Intelligence survey, respondents whose competitive deals increased put the share at 68%, and companies rated their ability to sell competitively 3.8 out of 10. A good competitive analysis won't close that gap by itself, but it's where the work starts.
Download the template
No email required. Eight sections with scoring rubrics, data source instructions, and a weighted scoring matrix. Import into Google Sheets or Excel.
What does this competitive analysis template include?
A competitive analysis template is a structured document for evaluating competitors across consistent dimensions: products, pricing, marketing, customer perception, and strategic direction. This one has eight sections, each with a specific job.
Company overview grid
Founding date, headcount, funding, revenue estimates, HQ location, and key executives for each competitor. Data sources: LinkedIn, Crunchbase (free tier), state business registrations.
Product and service comparison matrix
Feature-by-feature comparison with a 1-5 scoring rubric. Includes columns for pricing model, free trial availability, and target customer segment. Sources: competitor websites, G2 reviews, product demos.
Pricing breakdown
Published tiers, estimated discounts, contract terms, and per-seat economics. Sources: pricing pages, G2 reviews mentioning cost, sales conversations.
Marketing and content strategy
Website traffic estimates, organic keyword rankings, content publishing frequency, social media following and engagement, ad spend estimates. Sources: Google Trends, free traffic-estimate tools, social platforms.
Customer perception
G2/Capterra ratings, common praise themes, common complaint themes, NPS indicators where available. Sources: review platforms, Reddit discussions, customer forums.
SWOT per competitor
Strengths, weaknesses, opportunities, threats. Filled in after you complete the other sections, not before. A SWOT based on guesses is worse than no SWOT at all.
Weighted competitive scoring matrix
Score product quality, pricing, visibility, customer perception, innovation and market position with weights you can adjust. The weighted totals are already filled in as formulas.
Strategic recommendations
The "so what" section. Three columns: what you learned, what it means for your business, what to do about it. This is where the analysis turns into action.
What separates this from the HubSpot or Asana templates? Every section tells you exactly where to get the data. Most templates just give you empty cells and wish you luck. And the scoring rubric forces you to quantify your comparisons. Writing "good UI" in a cell tells you nothing in six months. Scoring it 4 out of 5 with a note about why lets you track changes over time.
How do you write a competitive analysis?
A competitive analysis starts with identifying three to five direct competitors, then systematically gathering data on their products, pricing, marketing, and customer perception. Use both free sources (Google Alerts, G2, SEC filings) and paid tools (SEMrush, Ahrefs) where the budget allows. Score competitors on a consistent rubric, run a SWOT for each one, and finish with specific action items you can execute this quarter.
That's the summary. Below is the process we use when building competitive intelligence reports for clients, adapted into six steps you can follow with the template.
Step 1: Map your competitive field
List every company a prospect might consider instead of yours, including the less obvious ones. They fall into three groups:
- Direct competitors sell the same thing to the same buyers. If someone Googles your product category, these are the other results.
- Indirect competitors solve the same problem differently. A spreadsheet is an indirect competitor to project management software.
- Then there are emerging competitors: startups or adjacent companies moving into your space. Recent funding rounds on Crunchbase and job postings on LinkedIn are the signals to watch.
Pick three to five for detailed analysis. Beyond that, you spread too thin and the analysis loses depth. If you have twenty competitors, group the smaller ones into a "long tail" summary and focus your detailed work on whoever shows up in your sales deals.
Step 2: Gather data (and know where to look)
This is where most templates fail you. They ask for "competitor revenue" without mentioning that public company financials are free on SEC EDGAR, or that job posting velocity on LinkedIn signals whether a company is growing or retrenching.
| Data point | Free sources | Paid sources |
|---|---|---|
| Company basics | LinkedIn, Crunchbase free, state business filings | ZoomInfo, PitchBook |
| Revenue and financials | SEC EDGAR (10-K, 10-Q), state annual reports | Bloomberg and other financial-data terminals |
| Product features | Competitor website, G2 feature lists, free trials | Analyst reports (Gartner, Forrester) |
| Pricing | Pricing pages, G2/Capterra reviews mentioning cost | Vendr (negotiated prices), sales conversations |
| Website traffic | Google Trends, free traffic-estimate tools | Semrush (from $139/mo), Ahrefs paid plans |
| Customer sentiment | G2, Capterra, Reddit, Trustpilot | Review-analytics and social-listening tools |
| Strategic direction | Job postings, press releases, patent filings (USPTO) | News and media-monitoring databases |
| Ad strategy | Google Ads Transparency Center, Meta Ad Library | SpyFu ($39/mo), Adbeat |
One source people overlook: Reddit. Search "site:reddit.com [competitor name]" and you get unfiltered customer opinions that never appear on review sites. The same goes for Google review threads on competitor profiles. Patterns of complaints there often surface positioning gaps that everyone in the category is missing.
Step 3: Score the product and service comparison
Fill in the product comparison tab with a 1 to 5 rating for each feature that matters to your buyers. Not every feature deserves a row. Focus on the ten to fifteen capabilities your sales team hears about in deals. If prospects never ask about a feature, leave it out.
Resist the urge to rate yourself a 5 on everything. Honest self-assessment is the whole point. Internal teams routinely overestimate their own product strengths because they know what the product is supposed to do, not how it actually feels to a buyer who has never seen it. Your template becomes useless the moment you stop being honest with it.
Step 4: Analyze marketing and content strategy
This section answers: where are your competitors showing up, what are they saying, and how much are they spending to say it?
Check their website traffic with a free traffic-estimate tool. It won't be precise, but it gives you relative scale. Look at their blog publishing cadence: how often, what topics, which posts get shared. Pull their organic keywords from Ahrefs or SEMrush and see which terms they rank for that you don't. Check the Google Ads Transparency Center to see every ad they're running right now. It's free and most people don't know it exists.
Social media followers are vanity metrics. Engagement rate matters more. A competitor with 2,000 LinkedIn followers and 8% engagement is reaching more people than one with 50,000 followers and 0.3% engagement.
Step 5: Run a SWOT for each competitor
SWOT (Strengths, Weaknesses, Opportunities, Threats) gets a bad rap from business school overexposure, but it's still useful when done right. The mistake most people make is filling in the SWOT first, before collecting data. That gives you a SWOT based on gut feelings and assumptions.
Do it last. Once you've completed the product comparison, pricing analysis, marketing audit, and customer sentiment review, the SWOT practically fills itself.
A weakness backed by fifteen negative G2 reviews about slow onboarding is worth something. A weakness based on "I think their UI is ugly" is not. Map each weakness directly to an opportunity for your business. If their onboarding is slow, how fast is yours? Can you quantify the difference? That's a sales talking point. (If your team has been losing deals you thought you'd win, pair this with structured win/loss analysis. Buyers tell you reasons sellers never see.)
Step 6: Turn the analysis into action items
A competitive analysis that sits in a Google Drive folder helps nobody. Crayon's 2025 survey found fewer than a third of CI teams engage sales daily or weekly, and the teams that shared daily reported 84% higher competitive sales effectiveness.
The template's last tab forces you to list specific actions: messaging changes for your sales team, product gaps to address, markets where competitors are weak. Every row needs an owner and a deadline. If nobody owns it, it won't happen.
Route the messaging-change findings straight into your social media automation pipeline so the new positioning hits LinkedIn, X, and the rest of your owned channels within the same week the analysis is finalized, not a quarter later when sales finally sees the deck.
What are the 4 P's of competitive analysis?
The 4 P's are Product, Price, Place, and Promotion. E. Jerome McCarthy introduced the framework in Basic Marketing: A Managerial Approach (1960), simplifying an earlier 12-ingredient "marketing mix" concept from Neil Borden. Applied to competitive analysis, you evaluate each competitor's product features and quality, pricing strategy and tiers, distribution channels and geographic reach, and marketing tactics including ad spend and messaging.
In the template, the 4 P's map to specific tabs:
- Product maps to the feature comparison matrix. How do their capabilities stack up against yours? Where are they ahead, and where are they behind?
- Price gets its own breakdown tab. Don't just list published numbers. Look for patterns: are they discounting to win deals? Do G2 reviews mention pricing as a pain point? (Our competitive pricing analysis guide goes deeper on price intelligence tools and frameworks.)
- For Place, look at distribution. Are they selling direct, through channels, through marketplaces? What geographies do they serve? Job postings for new offices signal expansion plans.
- Promotion pulls from the marketing and content strategy tab. Ad spend, content topics, SEO keyword rankings, social media presence.
The 4 P's give you a starting framework. They won't cover everything. Depending on your industry, you might need to add customer perception data, technology stack analysis, or financial health indicators. The template includes those sections too.
What are the 5 steps of a competitive analysis?
The five steps are: (1) identify your competitors, (2) gather data on their products, pricing, marketing, and financials, (3) analyze strengths and weaknesses using a structured framework, (4) determine your competitive position and identify gaps, and (5) create an action plan and set up ongoing monitoring. There is no single canonical source for these five steps, but the pattern is consistent across Porter's Competitive Strategy (1980), the SCIP intelligence cycle, and every practical CI guide published since.
The six-step walkthrough above follows this sequence in more detail. If you want the quick version for a presentation or business plan, those five bullets are all you need. The critical step people skip is number five. They do the analysis once and never update it. In fast-moving markets, a competitive analysis can go stale within weeks.
Can an AI chat assistant do a competitor analysis?
A basic AI chat assistant can generate a rough competitive analysis framework and summarize public information about competitors. It doesn't pull live records, query proprietary databases, verify its own claims, or conduct primary research like customer interviews. Use it as a starting point for structure, but verify every data point it gives you. Fabrication is a real risk: in a 2024 JMIR study, 28.6% to 91.4% of references that the AI chat models it tested generated for medical systematic reviews were made up.
Honest answer: a chat assistant is useful for the early structuring and a liability for the facts.
It does a decent job generating template structures and summarizing competitor website copy. Andy Crestodina of Orbit Media recommends feeding a competitor's sitemap into an AI assistant for a broad structural comparison. CI practitioner Aisling Conroy uses one to summarize SEC filings during earnings season.
Where it falls apart: pricing data and citations. Chat assistants routinely invent pricing structures for vendors that do not publish pricing at all, and it fabricates news articles with convincing URLs, dates, and formatting. None of the fabricated articles exist when you actually try to load the URL.
How CI teams use AI
Crayon's 2025 report shows the share of CI pros using AI rose from 25% to 44% in a year, and 60% of those AI users use it daily. The professionals using it well treat it as a summarization and first-draft tool, then verify everything against primary sources. And if every competitor runs the same AI on the same public data, nobody gets an edge from it.
A better approach is what CI professionals call the "analyst panel" method: run the same research prompt through several AI assistants, compare what they return, and use the conflicts between them to flag areas that need human verification. Where they all agree, the data is probably right. Where they disagree, someone needs to check the primary source.
Our intelligence reports go further by cross-referencing against SEC filings, patent databases, and real consumer discussions to verify every claim.
When is a template not enough?
A competitive analysis template works well for initial market assessments, business plan sections, and quarterly reviews when you have fewer than five direct competitors. It breaks down when you need continuous monitoring across a dozen rivals, when a 5% improvement in win rate would mean millions in revenue, or when you're making high-stakes decisions like entering a new market or acquiring a company.
Templates have a shelf life. In SaaS, a pricing page can change weekly. A spreadsheet you filled in three months ago might be telling you things that are no longer true. The Competitive Intelligence Alliance describes how many experienced analysts work: they don't follow a rigid process. Instead, they monitor data constantly and analyze on the fly, developing "an intuitive sense for what's important" through daily exposure to signals.
You've probably outgrown a template if:
- Deals keep going to competitors and nobody can explain why
- Your sales team asks about competitors and you don't have current answers
- The spreadsheet has grown past ten competitors and become unmanageable
- You need intelligence on things templates don't cover: patent filings, hiring patterns, consumer sentiment at scale
At that point, you have three options. CI software platforms like Crayon and Klue (a median of about $30,000 a year each in Vendr's purchase data) automate monitoring and generate sales battlecards. You still need someone on your team to manage the platform and interpret the data.
Or you can skip the DIY route entirely. Companies like ours build the analysis from scratch using data sources you can't easily access on your own: government databases, SEC filing cross-references, patent registries, and archived consumer discussions across social platforms, all stitched together with multi-source verification. You get a finished report with recommendations, not a dashboard you need to interpret. Reports typically run $500 to $15,000 depending on depth and scope.
You can also hire an in-house CI analyst. The BLS median wage for market research analysts is $78,760 (May 2025), before benefits, tooling and training. Makes sense when competitive intelligence is a daily function at your company. Crayon's 2022 survey found teams that share CI daily were twice as likely to report revenue impact as ad-hoc sharers.
For a full breakdown of consulting costs and when each option makes sense, see our guide to BI consulting costs. And if you want to go deeper than a template into quantitative competitor benchmarking, we have a guide for that too.
Does competitive analysis actually work? The numbers.
Some of the numbers you'll see in CI marketing are vendor-reported and should be taken with appropriate skepticism. But do the consistent patterns across multiple sources point to a real effect? Yes.
| Metric | Value | Source |
|---|---|---|
| Competitive share among respondents reporting more competitive opportunities | 68% | Crayon 2025 State of CI |
| CI pros using AI (2024 to 2025) | 25% to 44% | Crayon 2025 |
| Win rate improvement from battlecards | 71% report improvement | Crayon 2021 |
| Likelihood of reporting revenue impact, daily vs. ad-hoc sharing | 2x | Crayon 2022 |
| Respondents entering competitor data in the CRM late, not at all, or unsure whether it is entered | 44% | Crayon 2025 |
| CI tools market CAGR (2025-2030) | 19.96% | Mordor Intelligence |
Note that Crayon is a CI software company, so their survey data skews toward organizations already invested in competitive intelligence. Treat those percentages as directional.
One more data point: in Crayon and SCIP's 2020 survey, 90% of businesses said their market had become more competitive over the previous three years.
Which competitive analysis framework should you use?
A SWOT analysis (see Wikipedia for the formal framework) works best for quick internal assessments. Porter's Five Forces is the right pick when evaluating whether to enter a market. Feature comparison matrices give you deal-level competitive positioning. And a Strategy Canvas (from Blue Ocean Strategy) helps when the goal is to differentiate rather than compete head-on. Most companies need a combination, not a single framework.
How do you pick the right one?
| Framework | Best for | Limitations |
|---|---|---|
| SWOT | Quick assessment, team workshops | Too subjective without data backing |
| Porter's Five Forces | Market entry decisions, investor presentations | Static; doesn't capture ecosystem dynamics |
| Feature matrix | Product-level comparisons, sales enablement | Checkmarks don't indicate quality or usability |
| Strategy Canvas | Differentiation, category creation | Requires real customer data for the axes |
| Battlecards | Sales team enablement, deal support | Goes stale within weeks without updates |
| Win/loss analysis | Understanding why you win or lose deals | Only 35% of product teams did it (Pragmatic Institute survey, reported 2022) |
Porter's Five Forces first appeared in Harvard Business Review in 1979. The Blue Ocean Strategy Canvas was popularized in Blue Ocean Strategy (2005) by INSEAD professors Kim and Mauborgne. SWOT's origins are murkier than most people think. A 2023 peer-reviewed study in Long Range Planning credits Robert Franklin Stewart at Stanford Research Institute in the 1960s as its originator, rather than the Harvard textbook or Albert Humphrey that many accounts cite.
Ready to fill in the template?
Grab the free version below. No email required, no strings. Import the CSV into Google Sheets or Excel.