Two owners. Same neighbourhood. Same product. One has a spreadsheet with eleven competitor rows, each with a 1-to-5 score and a column for "threat level." The other has three sentences taped to the wall behind the till: what we do that nobody else does, what we cost more for, and who we will never try to beat on price. The second one sleeps better. I know because I built the eleven-row spreadsheet first, and it took me about four months to realise it was decoration.
What follows is the framework I actually use now when a small business asks for a competitive analysis — not the enterprise version with market-share models and analyst decks, but a stripped-down one you can run in an afternoon and update in fifteen minutes a month. It fits in one page. It has four columns. And the hard part isn't filling it in.
Key Takeaways
- A competitive analysis framework earns its keep only if it changes a decision within 30 days. Otherwise it's a document, not a tool.
- Four columns are enough: who they are, who they serve, what they charge, and the one customer complaint you keep hearing about them.
- Track 3 to 6 competitors, never more. Beyond that you're collecting, not deciding.
- Your best data source is your own lost-deal log — asking "who else did you consider?" on every quote you don't win.
- Refresh quarterly. A competitor's price move or a new entrant matters; a website redesign does not.
- The output should be one sentence you can say out loud to a customer, not a 20-slide deck.
What a competitive analysis actually is for
Most small businesses do this backwards. They start by mapping the market, then look for insights. I did exactly that on my first proper attempt: two weekends of research, a colour-coded matrix of nine local competitors, a summary I was quietly proud of. Then I went back to work and changed nothing. Not one pricing decision, not one service line, not a single word of my website.
The diagnostic is simple. A competitive analysis is a decision-making instrument, not a research deliverable. If it hasn't produced a change in what you sell, how you price it, or who you talk to within a month, it was theatre.
What is a competitive analysis?
It's a structured comparison of the businesses your customers would realistically consider instead of you — focused on the two or three dimensions where a customer actually chooses. Price. Speed. Specialisation. Convenience. Trust. That's roughly the whole menu for most small firms.
Note what's missing from that definition: total addressable market, growth rates, funding rounds. If you're a five-person business, those numbers describe a game you're not playing.
Where small businesses go wrong
The most common failure I see isn't laziness. It's ambition in the wrong place. Owners try to replicate what big-company frameworks ask for — segment sizing, positioning maps, five-force diagrams — and burn out on step one. Here's what actually breaks:
- Tracking too many competitors. Twelve rows means twelve half-filled rows.
- Analysing the wrong axis. Comparing website designs when the customer is choosing on turnaround time.
- No owner for updates. The file dies the week after it's created.
- Treating it as a one-off. Then being surprised when a competitor's price change catches you flat.
The four-column framework that fits on one page
Spoiler alert: the framework is not the interesting part. The discipline of keeping it short is. Here's the version I've used across a services business, a small retail operation and two client projects.
| Column | What goes in it | Where you get it | How often it changes |
|---|---|---|---|
| Who they are | Name, location/URL, how long they've been around | Public info, a five-minute look | Rarely |
| Who they serve | The specific customer segment they're built for | Their site copy, their reviews, their pricing page | Every few months |
| What they charge | Listed price, or the range if it's quote-based | Their site, a mystery-shop call, a customer who got a quote | Quarterly |
| The recurring complaint | One sentence: the thing their customers keep mentioning negatively | Public reviews, your own lost-deal conversations | Quarterly |
That fourth column is the one nobody fills in, and it's the one that pays. Reviews are the most under-read free dataset in small business. When I read the last two years of reviews for a direct competitor, roughly a third of the critical ones mentioned the same thing — slow replies to enquiries. I tested their contact form on a Tuesday morning. The reply came back on Friday. That became a headline on our own site, and enquiry-to-quote time went from "whenever" to a stated four hours.
How to pick which competitors to track
Three to six. Pick them by asking a single question: who does a customer consider instead of me? Not who is biggest. Not who is loudest. Who comes up in the conversation when the customer says "I'm also looking at…".
You already have this data and you're probably throwing it away. Every time you lose a quote, you know who won. I started logging that in a plain note on my phone — date, what we quoted, who else they mentioned, any reason given. Eight months of that gave me a clearer picture of my real competitive set than all my earlier research combined. Two of the names I'd been obsessing over never appeared once.
How to build yours in an afternoon
Here's the sequence I follow now. It takes about three hours for a first pass, and it deliberately front-loads the part where you learn something uncomfortable.
- List your last 20 lost deals or 20 enquiries you didn't convert. Where you have no data, note that honestly — it tells you where to start paying attention.
- Circle the names that appear more than once. Those are your competitors. The rest are background noise.
- Open each one's website and pricing page. Ten minutes each, maximum. Write down the four columns and move on.
- Read their 20 most recent public reviews. Copy the recurring complaint verbatim into column four.
- Send one enquiry as a customer would. Note how long the reply takes and what it says. This single data point beats an hour of desk research.
Honestly, step five is the one I resisted for the longest — it felt slightly sneaky. It isn't. You're just experiencing the same buying process your customers do, and the answer to "how fast do they respond?" is a real competitive fact, not a trick.
What to write in the final row
Underneath the table, write one sentence. Not a positioning statement, not a mission. Something like: "We cost about 15% more than the two closest shops and we answer enquiries the same day; customers who need it urgently pay it, customers who don't go elsewhere, and that's fine."
If you can't write that sentence, the analysis isn't finished. That sentence is the deliverable.
The template, and how to keep it alive
A free spreadsheet is fine. I use a plain document with a four-row table, one section per competitor, and a short "what changed this quarter" note at the top. No colour coding. No scoring system — I tried a 1-to-5 threat rating once and it produced false precision that I then argued with myself about.
Keeping it alive is the part everyone fails. Here's the minimum rhythm that has actually stuck for me:
- Monthly, five minutes: add any new lost-deal names. Nothing else.
- Quarterly, one hour: re-check prices and re-read recent reviews for your top three.
- Annually, half a day: redo step one from scratch, because your business has probably changed shape.
The catch? You have to actually do the quarterly pass. I've missed it twice and both times I found out about a relevant competitor move from a customer, which is the worst possible channel.
Common questions
Do I need paid tools?
For a small business, no. Public pricing pages, public reviews and your own lost-deal log cover most of what you need. Paid tools are useful when you're tracking a lot of online visibility metrics at scale, which is a different job from deciding what to charge and who to sell to. Start free, and only pay when a specific question can't be answered any other way.
What if my competitors don't publish prices?
Then get the range from customers. "Roughly what did they quote you?" is a normal question in a sales conversation and people answer it. Three data points give you a range; you don't need precision, you need the gap or the absence of one.
How many competitors is too many?
More than six is almost always too many for a small business. The quality of your fourth column collapses before you finish, and you end up with a wide, shallow document you never revisit. Narrow it and go deeper.
The part that matters
The most useful thing my competitive analysis ever told me wasn't about a competitor at all. It was that two-thirds of my lost deals came down to a single thing — response speed — and that I had been blaming price for years. Fixing the response time changed more than any pricing test I ran.
That's the real output. Not a map of the market. One uncomfortable fact about your own business, sitting in a column you'd otherwise never have filled in. If your framework doesn't produce one of those, it's still just a spreadsheet.
