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. We added a scoring system so your analysis produces actual rankings, not just a wall of text. And there's a filled-in example because nobody learns from empty cells.
Crayon's 2025 State of Competitive Intelligence report found that 68% of sales deals involve a head-to-head competitor. The average sales team rates itself 3.8 out of 10 for competitive preparedness. That gap costs companies $2 million to $10 million a year in winnable deals. A good competitive analysis won't close that gap by itself, but it's where the work starts.
Download the template
No email required. 147 rows across 8 sections with scoring rubrics, data source instructions, and a weighted scoring matrix. Import into Google Sheets or Excel. Or skip the DIY route and let us fill it in with real intelligence from 10,000+ data sources.
What does this competitive analysis template include?
A competitive analysis template is a structured document used to evaluate your competitors across consistent dimensions: their 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: SimilarWeb (free), Google Trends, 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.
Competitive positioning map
A 2x2 grid with axes you choose (price vs. features is common; pick dimensions that matter to your buyers). Plot each competitor and identify white space.
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? Two things. First, every section tells you exactly where to get the data. Most templates just give you empty cells and wish you luck. Second, 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. Here's 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
Start by listing every company a prospect might consider instead of yours. Not just the obvious names. Three categories matter:
- 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.
- Emerging competitors are startups or adjacent companies moving into your space. Check recent funding rounds on Crunchbase and job postings on LinkedIn for signals.
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 you can pull public company financials from SEC EDGAR for free, or that job posting velocity on LinkedIn signals whether a company is growing or retrenching.
Here's what to collect and where to find it:
| 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, AlphaSense ($10K-$100K/yr) |
| 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 | SimilarWeb free, Google Trends | SEMrush ($165/mo), Ahrefs ($29/mo starter) |
| Customer sentiment | G2, Capterra, Reddit, Trustpilot | Crayon ($15K-$45K/yr), Klue ($12K-$36K/yr) |
| Strategic direction | Job postings, press releases, patent filings (USPTO) | AlphaSense, Meltwater |
| 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. A B2B marketing exec shared a case where his team analyzed 900 Google reviews of a primary competitor, found a feature gap nobody was talking about, and repositioned their entire homepage around it. Their pipeline doubled in six weeks.
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. When Klue analyzed hundreds of win/loss interviews, they found that companies routinely overestimate their own product strengths by one to two points on a five-point scale. 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 SimilarWeb's free tier. 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. By the time 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.
Step 6: Turn the analysis into action items
A competitive analysis that sits in a Google Drive folder helps nobody. Crayon's data shows that less than a third of CI programs share intel with sales on a daily or weekly basis. The teams that do? They report 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.
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 is covered in 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 pricing breakdown tab. Don't just list their published prices. Look for patterns: are they discounting to win deals? Do G2 reviews mention pricing as a pain point?
- Place covers distribution. Are they selling direct, through channels, through marketplaces? What geographies do they serve? Job postings for new offices signal expansion plans.
- Promotion is 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 in 30 days.
Can ChatGPT do a competitor analysis?
ChatGPT can generate a rough competitive analysis framework and summarize publicly available information about competitors. It cannot access real-time data, 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. Hallucination rates for specific company data are significant: a 2024 JMIR study found AI-generated references exceeding 25% fabrication rates.
Honest answer: ChatGPT is useful for the first 20% of a competitive analysis and a liability for the other 80%.
It's good at generating a template structure if you don't have one. It can summarize a competitor's website copy. Andy Crestodina of Orbit Media recommends feeding a competitor's sitemap into ChatGPT for a broad structural comparison. CI practitioner Aisling Conroy uses it to summarize SEC filings during earnings season.
Where it falls apart: pricing data. Klue's VP of Product caught ChatGPT inventing an entire pricing structure for a competitor that doesn't publish pricing at all. The same person caught it fabricating TechCrunch articles with convincing URLs, dates, and formatting. None of those articles existed.
AI and competitive analysis: the bottom line
Crayon's 2025 report shows 76% year-over-year growth in AI adoption among CI teams, with 60% using AI tools daily. But the professionals using it well are using it for summarization and initial drafts, then verifying everything against primary sources. The CI Alliance puts it plainly: "If all your competitors are using AI, you gain no competitive advantage over them by using it yourself. Only competitive parity."
The smarter approach is what CI professionals call the "analyst panel" method: run the same research prompt through multiple AI tools (ChatGPT, Claude, Gemini, Perplexity), compare what they return, and use the conflicts between them to flag areas that need human verification. Where all four agree, the data is probably right. Where they disagree, someone needs to check the primary source. We use a version of this process in our intelligence reports, with the added step of cross-referencing against SEC filings, patent databases, and consumer discussions.
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:
- You're losing deals to competitors and can't explain why
- Your sales team asks about competitors and you don't have current answers
- You're tracking more than ten competitors and the spreadsheet is becoming unmanageable
- You need intelligence on things templates don't cover, like patent filings, hiring patterns, or consumer sentiment at scale
At that point, you have three options. CI software platforms like Crayon ($15,000-$45,000/year) and Klue ($12,000-$36,000/year) automate monitoring and generate sales battlecards. You still need someone on your team to manage the platform and interpret the data, which typically runs 5 to 10 hours per week.
The second option is done-for-you intelligence. Companies like ours build the analysis from scratch using data sources you can't easily access on your own: 30+ billion consumer data points, SEC filing cross-references, patent velocity tracking, and 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.
Third option: hire an in-house CI analyst. Average salary is around $85,000 plus benefits, tools, and training. Makes sense when competitive intelligence is a daily function at your company. Crayon found that teams sharing CI daily report 2x the revenue impact compared to ad-hoc sharing. 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 thrown around in CI marketing are vendor-reported and should be taken with appropriate skepticism. That said, the consistent patterns across multiple sources paint a clear picture.
| Metric | Value | Source |
|---|---|---|
| Deals involving a competitor | 68% | Crayon 2025 State of CI |
| Fortune 500 companies using CI | 90% | Emerald/Evalueserve |
| CI teams using AI daily | 60% | Crayon 2025 |
| Win rate improvement from battlecards | 71% report improvement | Crayon 2025 |
| Revenue impact when CI shared daily | 2x vs. ad-hoc | Crayon 2022 |
| Companies lacking CRM competitor data | 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. The 90% Fortune 500 figure comes from an older Emerald study (2011). These numbers tell you competitive analysis matters, but the specific percentages are directional, not gospel. What's harder to argue with: 90% of businesses surveyed by Crayon and SCIP said their market had become more competitive over three years, and the share of competitive deals has climbed from 65% (2024) to 68% (2025).
Which competitive analysis framework should you use?
Use a SWOT analysis for quick internal assessments. Use Porter's Five Forces when evaluating whether to enter a market. Use a feature comparison matrix when you need deal-level competitive positioning. Use a Strategy Canvas (from Blue Ocean Strategy) when you're trying to differentiate rather than compete head-on. Most companies need a combination, not a single framework.
A quick guide to picking 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 | Stale within 30 days without updates |
| Win/loss analysis | Understanding why you win or lose deals | Only 35% of product teams do it (Pragmatic Institute) |
Porter's Five Forces first appeared in Harvard Business Review in 1979. The Blue Ocean Strategy Canvas was introduced by Kim and Mauborgne at INSEAD in 2005. SWOT's origins are murkier than most people think. A 2023 peer-reviewed study in Long Range Planning traced it to Robert Franklin Stewart at Stanford Research Institute in the 1960s, not Albert Humphrey as commonly cited. The Humphrey origin story appears to be what the paper calls "an academic urban legend."
Ready to fill in the template?
Grab the free version below. No email required, no strings. If you want the enhanced version with pre-populated data sources, a weighted scoring rubric, and quarterly update tracking, enter your email and we'll send it over.