What customer management is
It is the job of storing and making good use of customer information: who they are, what they have asked you for, where they write from and what stage each matter is at. In a small business it usually starts in a notebook or on the phone of whoever serves customers, and the problem appears when that person is away.
Good customer management stands on four legs: complete records, a history of what has happened, tasks with an owner and compliance with data protection. When one is missing it shows straight away: customers repeating their story, calls nobody returns or data whose origin nobody knows.
What a customer record is
A customer record is the entry that gathers everything the company knows about a customer, whether a person or an organisation: what they are called, how to contact them, what they have signed up for or booked, which conversations they have had and what is pending.
It used to be an index card in a filing box; today it is a screen in a program. What has not changed is its purpose: letting anyone on the team serve that customer as if they had always known them.
What details a customer record should hold
Fewer than you might think. Every field you add has to be kept up to date and, if it is personal data, justified. These are the ones actually used when you serve customers every day:
What should not be there: health data if your business does not need it, card or account numbers copied into the notes, and personal opinions about the customer. Anything you keep, the customer can ask to see.
- Name and, for a company, the organisation and each person’s role in it.
- Ways to get in touch (phone, email), showing which is the main one.
- The language they prefer to be served in.
- Related people: the children at an academy, the person who books on someone else’s behalf.
- History: conversations, bookings, services and changes, by date.
- Owner and pending tasks, with dates.
- Consents: whether they have agreed to receive communications, and for what.
- Short notes that help when serving them.
Customer record examples
The structure is similar in every business; what changes is which history matters. Four examples:
- Academy: the parent’s record, with the students in their care, their classes and the trial lessons requested.
- Hair or beauty salon: the client, her usual services, the professional who sees her and her upcoming appointments.
- Gym: the member, the classes they attend and the questions they have asked about their membership.
- Business that sells to businesses: the organisation’s record, with the people who work there, who makes the decisions and the activity of all of them together.
From spreadsheet to records
A spreadsheet works while one person uses it and there are few customers. It falls short when several people edit it at once, when you want to see a customer’s history in order or when messages arrive on WhatsApp and have to be copied in. That is the moment to move to records, and it takes five steps:
- Combine every list into one sheet: your phone contacts, the diary and the list in the billing software.
- Keep one row per customer and one column per detail, in the same format throughout (phone numbers with country code, email addresses in lower case).
- Remove duplicates before importing, not afterwards.
- Import and review the conflicts: two rows with the same phone number and different names deserve a human look.
- Check a dozen records at random and, from that day on, stop editing the sheet.
Duplicate records: how to avoid them
A duplicate record splits the customer’s story in two, so half the team cannot see what the other half knows. Duplicates appear above all when lists are imported and when a customer writes from a new channel.
Three habits prevent them: always store phones and emails in one format, check whether the detail already exists before creating a record, and merge the two records as soon as a duplicate is spotted, noting which one is kept. A good program warns about the duplicate before it is created.
Customer management and data protection
Records hold personal data, so they fall under the General Data Protection Regulation. In practice that means keeping only what is necessary, knowing why each item is kept, protecting it and being able to respond when someone asks to see, correct or delete their data.
A point that is often forgotten: having someone in your records does not give you permission to send them marketing. That needs their consent, recorded separately and for that purpose.
There are three common options, and each works up to a point. A spreadsheet is free and flexible, but it keeps no history, gives no duplicate warnings and breaks down when several people use it. Billing software holds customers’ tax details, but not their conversations or their bookings.
A CRM is the tool designed for this: records, history, tasks and permissions for the team. If your customers write on WhatsApp, it also helps if messages land in the records by themselves. What a CRM is and how to choose one is covered in this guide.
