← All use cases / Small business
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.
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
- Export your past clients or invoices into a spreadsheet, with names, dates and amounts if you have them.
- Find a full list of the organisations in your market, such as an official register or a public directory.
- Give both lists to Claude with the prompt above and ask it to match them carefully.
- Check the uncertain matches yourself, especially organisations that have merged or changed name.
- 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
- AI for work and business: our hub of ideas
- AI for small business: where to start
- Make a simple marketing plan with AI
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.
I run [BUSINESS] in [TOWN], selling [PRODUCTS/SERVICES] to [CUSTOMERS]. Brainstorm 20 social media post ideas for the next month: a mix of behind-the-scenes, tips, customer stories and offers. For each, give a one-line hook and the best platform for it.
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.
I'm a [TRADE] and one of my clients has [SYSTEM, E.G. A POOL PUMP AND HEATING SETUP] that is run manually: [DESCRIBE HOW IT WORKS NOW]. I think it wastes energy because [REASON]. Explain the options for improving or automating it, the parts I'd likely need, the rough costs and savings, and the questions I should check with the manufacturer or a specialist before proposing it to the client.
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.
I run a [TYPE OF BUSINESS]. For [OCCASION OR QUIET PERIOD] I'd like a special offer that feels generous but still makes money. Here are my usual prices and rough costs: [ITEMS, PRICES, COSTS]. Suggest three bundle or discount ideas, show the profit per sale for each, and write a short, warm line of flyer text for the best one.
Reference: X @soppystern