Guide

Local competitor analysis: template and worked example

A local competitor analysis is a table that puts your business beside three or four competitors on the things customers compare: services, price signals, stated reply time, booking, promises, reviews and what each one says first. You fill it in using only public information, in about an hour, then look for rows where several competitors say nothing and you could be clearly better. The template and a worked example for a fictional business are below.

By Plato Belmont, founder of Magnet Mint, Boston. Updated

What a local competitor analysis is for

A local competitor analysis answers one question: when a customer compares us with the others, what do they see? You are not studying the whole market. You are studying the three or four businesses that appear next to you on Google, in Maps and in a friend’s text message.

The US Small Business Administration describes competitive analysis as a way to find a competitive advantage. It suggests identifying competitors by product or service and by market segment, and including indirect competitors who could affect you. It also suggests asking what successful competitors do, why it works, and whether you can do it better.

This article gives you a template you can fill in during one sitting, a worked example, and a way to read the result. If you would rather have it done for you, our free website demo includes a side-by-side view of 3-4 competitors. It starts with a short call by phone or video, and it is free with no obligation.

Step 1: choose three or four competitors

Search for your main service the way a customer would. Use the words they use, add your town, and look at the Google results and the map results. Write down the businesses that appear in both.

Add them to your list in this order:

  1. Two or three direct competitors. Same service, same area, same kind of customer.
  2. One alternative. A larger company, a franchise, a marketplace or a do-it-yourself option. Customers compare you with this too.
  3. One you admire, if you have one. A business in another town that does the same work well. It shows what good looks like.

Google says local results are based mainly on relevance, distance and prominence. You cannot change how far you are from a customer, but you can compare how complete each profile is and how many reviews each has. That is why those rows are in the template.

Step 2: the template

Copy this table into a spreadsheet. Keep each cell to a few words. Write “not stated” when you cannot find the information. A blank is not the same thing as “no”.

What customers compareUsCompetitor ACompetitor BCompetitor CAlternative
First impression
First sentence on the home page
Main service named in the page title
Offer
Services listed, each with its own page
Who they say they serve
Price shown (exact, from, range, none)
Contact and booking
Phone number tap-able on mobile
Online booking or request form
Steps from landing to booked
Hours, including evenings and weekends
Promises
Reply time stated
Written estimate or price before work
Guarantee, with its limits shown
Proof
Google rating and number of reviews
Most recent review date
Do they reply to reviews?
Photos of real work
Contact path (public)
What the site says happens after you send a request
Ways to reach them after hours (chat, text, booking)

Two rows deserve a note.

Reviews. In BrightLocal’s 2026 survey of 1,002 US adults, 97% of consumers said they read reviews for local businesses, 68% would only use a business rated four stars or higher, and 47% would not use a business with fewer than 20 reviews. If a competitor has a gap here, it is a gap customers notice.

The contact path. Fill these rows from what each competitor publishes: the reply time on the contact page, what the form or booking page says happens next, and whether chat, text or online booking is offered outside business hours. We do not recommend posing as a customer to a competitor. It takes their time under a false pretense, and the public facts are what your customers compare anyway. Save real test calls and forms for your own business, where you can fix what you find.

A worked example (illustrative)

This example is fictional. The business, the competitors and every cell below are made up to show the method. They are not data about any real company.

Imagine a small bathroom remodeler in a mid-sized US town, compared with three nearby remodelers and a national home-improvement chain.

What customers compareUs (fictional)Competitor ACompetitor BCompetitor CChain (alternative)
First sentence on the home page“Bathroom remodels, start to finish”“Quality home improvement”“Family owned since the 1990s”“Kitchens, baths, decks, roofs”“Save on remodeling”
Services with their own pageBathrooms onlyOne page for allOne page for allSeparate pagesMany pages
Price shown“Typical projects, range”NoneNone“From” on one serviceEstimate tool
Online request formYes, 4 fieldsPhone onlyForm, 9 fieldsYesYes
Reply time statedNext business dayNot stated“Within 24 hours”Not statedNot stated
Written estimate before workYesNot statedNot statedYesYes
Guarantee with limits shownOne year, listedNone“Satisfaction” onlyNoneStore policy
Google rating and review count4.8, 31 reviews4.4, 9 reviews4.6, 120 reviews4.7, 64 reviews4.1, many
Replies to reviewsYesNoSometimesYesRarely
What happens after a request (per site)Confirmation with reply timeNot stated“Thank you” onlyConfirmation and booking linkAutomated email

How to read the result

Do not add up the cells to get a score. Read the table in three passes.

Pass 1: gaps nobody fills. Look for rows where most columns say “not stated”. In the example, three of four competitors give no reply time and no written estimate, and only one shows any price. Those are openings where the fictional business can say something true that most customers will not see elsewhere.

Pass 2: rows where you are behind. In the example, Competitor B has far more reviews. That is not fixed by copy. It is fixed by asking every customer for a review right after the job. Fix weak rows before you advertise anything else.

Pass 3: pick one or two to lead with. In the example, the fictional business specializes in bathrooms, states a reply time, shows a typical price range and lists its guarantee. It could say: “Bathroom remodels only. Written estimate, and a reply by the next business day.” A competitor could not copy that sentence tomorrow unless it changed how it works.

Then run the sentence through the tests in our guide to how to differentiate your business: can a customer check it, can a competitor say the same, and can you deliver it every time?

Mistakes to avoid

  • Comparing everything. Twenty rows that matter beat sixty that do not. Cut rows customers do not use to decide.
  • Copying what a competitor says. If you copy their claim, you are not different. Use the table to find what they leave out.
  • Judging by looks. A polished site with no price, no reply time and no booking step is weaker for a customer than a plain site with all three.
  • Guessing. Write “not stated” rather than assuming. If you cannot find a fact, a customer cannot either.
  • Doing it once. Markets move. Schedule a review twice a year.

Next steps

  1. Fill in the “Us” column first, honestly, before you look at anyone else.
  2. Add three or four competitors, using only what they publish.
  3. Mark the rows where you are behind and the rows where nobody is saying anything.
  4. Write one sentence from the best gap, and put it at the top of your home page and your Google Business Profile.
  5. Review the table again in three months.

To see a comparison like this for your own business, ask for a free demo. Our prices for the work that follows are on the pricing page.

Published . Updated .

Frequently asked questions

What is a local competitor analysis?

It is a side-by-side comparison of your business and the few competitors your customers actually consider, built from public information such as their websites, Google Business Profiles, reviews and what they promise about replies and booking. The goal is to find gaps you can fill honestly, not to copy anyone.

How many competitors should I include?

Three or four is enough. More columns make the table harder to read and rarely change the result. Pick the businesses that show up when a customer searches for your service in your area, plus one indirect alternative such as a do-it-yourself option or a larger company.

Where do I find information about my competitors?

Use what any customer can see. Their website, their Google Business Profile and Google Maps listing, the reviews on those profiles, and what their contact and booking pages promise. The US Small Business Administration also lists free government data sources for wider market research.

Is there a free competitor analysis template for Excel or Word?

The table in this article works in any spreadsheet or word processor. Copy it into Excel, Google Sheets or Word, add a column per competitor, and keep one short note per cell. No special tool is needed.

How often should I update a competitor analysis?

Review it twice a year, and again when a new competitor opens, a competitor changes its offer, or your own reviews or rankings shift. It takes less time the second time because the rows are already set up.

What do I do with the results?

Look for rows where most competitors say "not stated" and you could say something true and specific. Pick one or two to lead with and turn them into a single sentence. Our guide to unique selling proposition examples shows how.

Sources

  1. U.S. Small Business Administration: Market research and competitive analysis, October 2026
  2. Google Business Profile Help: Tips to improve your local ranking on Google, October 2026
  3. BrightLocal: Local Consumer Review Survey 2026, October 2026

Related reading

Start with a free demo

See how customers and AI assistants see your business today.

A short call, then a demo for your business: what customers find, what AI answers say, and where you lose leads. No obligation.