Find out how much of your market your small business has already reached with Claude

← All use cases / Small business

ToolClaude

A small business owner used Claude's help with the analysis to work out that, over about nine years of trading, they'd worked with three-quarters of all universities in the UK. It gave them a rare chance to step back and see what they'd built.

Prompt to copy
I run a small business that sells to [TYPE OF CUSTOMER, E.G. UNIVERSITIES, SCHOOLS, CAFES] in [COUNTRY OR AREA]. Attached is my client list from [YEARS]. Please: 1) match each client to a single organisation, merging duplicates and different spellings; 2) compare them with this full list of [ORGANISATIONS IN MY MARKET]: [PASTE OR ATTACH]; 3) tell me how many and what percentage I've worked with, broken down by [REGION / TYPE / YEAR]; 4) list the ones I've never worked with. Flag any matches you're unsure about.

Replace the [PLACEHOLDERS] with your own details before you send it.

How to try it

  1. Export your past clients or invoices into a spreadsheet, with names, dates and amounts if you have them.
  2. Find a full list of the organisations in your market, such as an official register or a public directory.
  3. Give both lists to Claude with the prompt above and ask it to match them carefully.
  4. Check the uncertain matches yourself, especially organisations that have merged or changed name.
  5. Use the result: celebrate the reach, and look at the ‘never worked with’ list for new leads.

Why this works

When you’re busy running a business month to month, it’s hard to see the bigger picture. Client lists build up in invoices, emails and spreadsheets with inconsistent names, and matching them against a whole market by hand is slow. An AI can do the tidying and matching in minutes, leaving you to check the edge cases. For the owner who shared this, the answer was a genuine morale boost after years of hard work. The same analysis also shows where the gaps are, which feeds straight into a simple marketing plan with AI.

Tips to get a better result

  • Ask it to show its matching table, so you can check every pairing it made.
  • Break the results down by year to see whether you’re still reaching new customers or mostly serving existing ones.
  • Remove personal contact details before uploading, if you don’t need them for the analysis.
  • Our guide to analysing customer feedback with AI can help you understand why customers come back.

Common mistakes

  • Using an incomplete or out-of-date list of the whole market, which skews the percentage.
  • Counting different departments of the same organisation as separate customers.
  • Sharing confidential client data without thinking about your own privacy obligations.

Try a variation

Here’s a variation of our own to try next:

Using my client list, show me which of my customers haven't bought from me in over [NUMBER] months, sorted by how much they used to spend, and suggest a friendly reason to get back in touch with each type.

Related

Read the full guide →

More small business use cases

Brainstorm content ideas for your small business with ChatGPT

One small-business owner says ChatGPT has helped a lot with brainstorming content ideas and strategies to grow the business.

Full guide →

Plan an efficiency upgrade for a client as a tradesperson with ChatGPT

A one-person plumbing and installation business looking after a community pool spotted wasteful manual processes but had never used AI. He asked ChatGPT questions about the pool system and how to automate it, got a parts list and a plan, and with the previous installer made changes expected to save the pool thousands of euros. He now uses it several times a day for practical problems.

Source: Hacker News

Price a special offer that still makes a profit with ChatGPT

Ahead of Mother's Day, the owner of a PJ's Coffee branch in Maryland asked ChatGPT for a promotion that gave customers a discount while keeping some profit, and settled on beignets and two coffees for $17.99. He also used it to make the flyer, but its AI-made image drew criticism from locals online, so a real photo of your own food is the safer choice.

Full guide →

Reference: X @soppystern