Run it with less chaos · Every business
Choosing a Client Database or CRM for a Service Business
A client database earns its fee when it tells you who is due back and nudges them at the right time, so the choice should start from the few facts you need about each customer and the reminders you want to send, not from a list of features.
At a glance
- A client database, often sold as a CRM (customer relationship management system), is one record per customer holding contact details, visit or job history, preferences and consent, plus the reminders and messages that bring that customer back.
- Retention research summarized in Harvard Business Review puts the cost of winning a new customer at five to 25 times the cost of keeping one, which makes a list of past customers one of the most valuable things a small business owns.
- In a Cochrane review of eight randomized trials, attendance was 67.8% without reminders and 78.6% with text reminders, an example of what a database with automatic messages can change.
- For an illustrative business with 500 customers on file, bringing back one in ten of those who have lapsed for three more visits a year is worth $5,400, against $600 a year for the software.
- Choose by writing down the fields and reminders you need first, test two or three systems with your own data and measure one number, the share of customers due back who rebook.
Part 1 | What a client database is for
Most owner-run service businesses already keep a client database; it is simply spread across a phone's contacts, a booking app, an invoice folder and the owner's memory. The trouble shows up when the business needs to answer an ordinary question, such as Who hasn't been back since spring? or Which homes have a furnace due for service?, and the answer takes an afternoon of scrolling. A CRM pulls those pieces into one record per customer, so the answer becomes a filter.
The case for doing it rests on the value of customers you already have. A summary of retention research in Harvard Business Review reports that acquiring a new customer costs five to 25 times as much as keeping an existing one, and cites research at Bain & Company finding that a 5% rise in retention raised profits by 25% to 95%. Those ranges vary widely by study and industry, but the direction holds for a salon, a dental practice or an HVAC company, where most revenue comes from customers who return.
| Field | Why it matters | Example |
|---|---|---|
| Name, phone, email | Reaching the customer | Preferred channel noted |
| Consent to text and email | Staying within messaging rules | Date and wording of consent |
| Visit or job history | Knowing what was done and when | Last visit, service, price |
| Usual cycle | Knowing when they are due | Every 6 weeks; annual tune-up in April |
| Next booked date | Seeing who has nothing scheduled | Blank means follow up |
| Preferences and notes | Making the next visit feel personal | Color formula, gate code, anxious about needles |
| Source | Knowing which marketing works | Referral from [business name] |
Part 2 | What to look for when you compare systems
Many booking, field service and practice-management tools already include a client database, so the first question is whether the system you use to schedule work can do the job before you add another subscription. When you compare options, look for these capabilities, in roughly this order:
- Due-back lists. A filter or report that shows customers past their usual cycle with nothing booked, which is the list a CRM exists to produce.
- Automatic reminders and follow-ups by text and email, tied to appointments or to the date a customer is due, with opt-out handled for you.
- Fast entry at the counter or in the truck. If a note takes more than a few taps on a phone, staff will stop adding them.
- Import and export. You should be able to load your current list in a spreadsheet and take all of your data out again if you leave.
- Permissions and security. Separate logins for each staff member, two-factor sign-in and control over who can export the list.
- Integration with what you already use for booking, payments and bookkeeping, so the same customer is not typed in three places.
Reminders are where the evidence for a database is clearest. A Cochrane systematic review of eight randomized trials with 6,615 participants found that text reminders raised attendance at healthcare appointments compared with no reminder, and that texts worked about as well as reminder phone calls, which take a staff member's time for each one.
The trials took place in clinics, so a salon or a cleaning company should not expect the same gain, but the mechanism carries over: a database that sends the message automatically does the remembering that busy staff do not.
Part 3 | Putting a number on the database
The value of a client database comes mostly from customers who would otherwise drift away, so the estimate starts with them: customers on file × share who are past due × share who come back after a nudge × extra visits a year × average visit, minus the software cost.
| Customers on file (Assumption) | 500 |
|---|---|
| Share past their usual cycle with nothing booked (Assumption) | 30% |
| Lapsed customers (Calculated (500 × 30%)) | 150 |
| Share who rebook after a reminder or check-in (Assumption) | 10% |
| Customers brought back (Calculated (150 × 10%)) | 15 |
| Extra visits a year from each (Assumption) | 3 |
| Average visit (Assumption) | $120 |
| Revenue a year (Calculated (15 × 3 × $120)) | $5,400 |
| Software (Assumption ($50 a month)) | $600 a year |
| Net value a year (Calculated ($5,400 − $600)) | $4,800 |
Illustrative example; replace every assumption with your own numbers.
The estimate leaves out time saved looking up history and the visits kept by reminders, and it assumes someone works the due-back list each week, since a database nobody opens brings no one back and still costs $600 a year.
How you compare
- Reminders: in the Cochrane trials, attendance with text reminders was 78.6% against 67.8% without; if your no-show rate is well above the clinic figures, automatic reminders are the first feature to turn on.
- Customer data you keep: collect only what you use, store consent with the record and limit who can export the list, the basics covered in our guide to customer data privacy.
- Your own baseline: count customers past their usual cycle with nothing booked, then count again a month after you start working the list; the change in that number is the return on the database.
Questions to ask this week
Where do our customer details live today? List every place, from phone contacts to invoice folders, before choosing anything new.
Can our booking or job system already do this? Many can, and turning on a feature costs less than adding a tool.
Which seven fields would we actually use? Start with the ones in Exhibit 1 and drop any you will not fill in.
Who works the due-back list, and on which day? Name the person and put it on the calendar.
Can we take our data with us? Ask for an export of a test list before you sign.
The next step is to export your current customer list into a spreadsheet, mark everyone past their usual cycle and send that group a short check-in this week, which tells you how much a database is worth before you pay for one.
About this research: This article draws on a Harvard Business Review summary of customer retention research, including work at Bain & Company, and a Cochrane systematic review of text-message reminders in healthcare. The worked example is illustrative, and the retention ranges vary by study and industry.
Sources
- Gallo, A. The Value of Keeping the Right Customers. Harvard Business Review, 2014.
- Gurol-Urganci, I., de Jongh, T., Vodopivec-Jamsek, V., Atun, R. and Car, J. Mobile Phone Messaging Reminders for Attendance at Healthcare Appointments. Cochrane Database of Systematic Reviews, 2013. Eight randomized trials, 6,615 participants.
Related reading: One Place for Every Client's Details: Record Keeping for Salons, Trades and Practices · Customer Data Privacy Basics for Small Service Businesses · A Year of Check-Ins: The Calendar That Brings Customers Back · The Win-Back Message for Customers Who Stopped Coming · Salon and Spa Software: What the Booking System Should Do · Field Service Software for Small Trades: What to Look For
Work with osNOVA on a client list that brings customers back
We help owner-run service businesses pull their customer details into one place, set the reminders and check-ins that match each customer's usual cycle and build the weekly habit of working the due-back list, starting from what you want more of, whether that is more regulars, fuller weeks or fewer no-shows.
Email hello@osnovaops.com about your business
Or leave your email and we will reach out
Tell us what kind of business you run and what you want more of.
Not ready to talk? osNOVA runs free live events for owners.