60-70% of your customers who stopped coming are not angry. They forgot. An automatic system that sends them a message after 30, 60 and 90 days of inactivity can recover between 5% and 15% of them. Without you spending a minute. I explain how to assemble it step by step.
The problem: clients who leave in silence
One customer came three times. He always paid. He never complained. And one day it stopped appearing. He didn’t tell you why. You didn’t ask him. And you’ll probably never know.
According to data from the consulting firm Bain & Company, a customer who does not return in 90 days has a 70% chance of never returning. But here’s what no one tells you: most didn’t leave because of something you did wrong. He left because another business messaged him and you didn’t.
A mechanical workshop, a hair salon, a physiotherapy clinic or a law office. They all lose the same type of customer: the one who left quietly. And the cost is real. Getting a new customer costs 5 to 7 times more than winning back an existing one, according to Harvard Business Review.
The 3 steps to set up your automatic tracking system
You don’t need to know how to program. You don’t need a technical team. You only need a database with your clients’ phone numbers and a tool that sends messages for you. I’m going to explain the complete flow to you, step by step.
Step 1: Define what an “inactive customer” is in your business
Before automating anything, you need some criteria. How long without coming makes a customer “inactive”? It depends on your business:
| Business type | Normal frequency | Inactive at…? |
|---|---|---|
| Hairdresser/barber shop | Every 3-6 weeks | 45 days |
| Physiotherapy clinic | Weekly or biweekly | 30 days |
| mechanical workshop | Every 3-6 months | 90 days |
| Law firm | Variable | 60 days |
| Vet | Every 3-12 months | 90 days |
| Aesthetics / well-being | Every 2-4 weeks | 45 days |
If you don’t know what your normal frequency is, think about your most loyal customer. How often does he come? That figure multiplied by 1.5 is your inactivity threshold.
Step 2: Assemble the autoflow with a free tool
For this tutorial I am going to use Google Sheets + an automation system as an example. You can do it with n8n (self-hosted, no monthly cost), with Make (formerly Integromat, free plan of 1,000 operations per month) or with Zapier (limited free plan but enough to get started).
The logic is always the same:
The flow step by step
- Your agenda or CRMrecords the date of each client’s last visit.
- Every day at 10:00, the system checks who has not come for more than X days (according to your threshold from step 1).
- If there are matches, the system sends a personalized message by WhatsApp or email.
- If the client responds, you receive the notification to continue the conversation.
- If you don’t respond, the system sends a second message after 15 days and a third after 30.
If you use Google Sheets as a database: column A = name, B = phone, C = email, D = last visit date. The system calculates the days automatically.
Step 3: Write the right messages
The message matters as much as the system. A “Do we miss you?” Generic sounds like spam. A message that remembers something specific from your last visit sounds like you care. Here are three templates that work:
Message 1 — Day 30 (first soft touch)
“Hello [Name], how are you? We haven’t seen each other in a while. Do you need anything or there just wasn’t room? If you want, I’ll save you a spot this week.”
Message 2 — Day 60 (second touch with added value)
“Hello [Name], I’m writing to you because we have news that might interest you. Would you like me to tell you in 2 minutes? I can call you whenever it’s convenient for you.”
Message 3 — Day 90 (last attempt, honest)
“Hello [Name], it’s been a few months since we’ve seen each other. If you changed your mind or found another place, no problem. But if it was due to disconnection, we’re still here. Shall we talk?”
Personalize messages with the customer’s name and, if you can, with reference to their last visit. “Hello Maria, since your last back session in June…” is 3 times more effective than a generic message.
| Message type | Average response rate |
|---|---|
| Generic (“Do we miss you?”) | 5-8% |
| Personalized with name | 12-18% |
| Personalized with name + last visit | 20-30% |
Real example: a hair salon and a mechanical workshop
Lucía has a hair salon
Lucía has 280 clients on her agenda. Before, I manually checked who didn’t come in a month and wrote to them when I could. I did this once a month, when I remembered. Result: I recovered 2-3 clients a month.
Now it has a system that checks every day who hasn’t come for more than 45 days. Sends them the first message automatically. She only intervenes when the client responds. Result: recover between 8 and 12 clients per month. Without spending even 10 minutes a week.
Andrés has a mechanical workshop
Andrés calculates that a client who comes to do the MOT or annual maintenance generates about €350 a year. He lost contact with about 60 clients last year. That’s €21,000 in missing billing.
He set up the system with a spreadsheet and a free plan from Make. In the first three months, he won back 14 clients. It’s not magic: it’s not forgetting the people who already trusted you.
Lucía and Andrés are not real clients. These are examples based on the real frequency of these businesses.
Your Quick Win today
Open your calendar or your client list. Count how many have not returned in the last90 days. That number multiplied by your average ticket is the money that is going away. If the number surprises you, you already know which system you need to set up first.
Do you want us to set up this system adapted to your business?