ThatBusy
Start free

← All posts

Your customer list is a mess. Here's how to make it useful

By The ThatBusy team · · 2 min read

Most small businesses have their customer list spread across three or four places: contacts in the owner's phone, an export from an old booking system, a spreadsheet someone started in 2021, maybe a box of paper cards. It's a mess, so it never gets used.

But that list is the most valuable marketing asset you have. These are people who already know you, already trust you and already paid you once.

Step 1: Gather everything

Don't clean as you go. First, just get it all in one place:

  • Export contacts from your phone
  • Export customers from any booking or point-of-sale system you've used
  • Type up paper cards if there aren't too many

Step 2: Keep the columns that matter

For bringing people back, you need:

  • Name (first name at least)
  • Mobile number and/or email
  • Last visit date and what they had, if you have it
  • Birthday, if you collected it

Everything else is nice to have.

Step 3: Merge the duplicates

The same person will appear more than once, with a slightly different name or an old email. Match on phone number or email and keep the newest details.

Step 4: Note who agreed to hear from you

Only message customers who said yes to messages from you. If you're not sure, a booking confirmation or a short opt-in message is a good place to start.

Step 5: Keep it up to date

A list is only useful if it stays current. The easiest way is to have new customers added automatically when they book, rather than relying on someone to type them in.

How ThatBusy does it

ThatBusy imports any spreadsheet (Excel or CSV) or your phone contacts, shows you a preview before anything is saved, brings in visit histories, and updates customers who are already there instead of duplicating them. If something looks wrong, you can undo an import for 7 days. From visit histories it works out when each customer is due back. New customers who book online are added for you.

Next step: start free, or read how to build a customer contact list.