Customer database: what it is and how to build one that sells

A customer database is an organised record of the people and companies you sell to: who they are, what they bought, how they found you and what they agreed to receive from you. A list of phone numbers in a notebook is not a database. A database tells you who each contact is and what has happened between you, so anyone on your team can pick up the conversation.

Small companies often skip this step because it feels like paperwork. In practice it is one of the cheapest ways to earn more without spending more on advertising.

Why it is worth the effort

• More repeat sales. Selling again to someone who already trusts you is usually much cheaper than winning a new customer.
• Better offers. Instead of sending the same email to everybody, you send the right message to the right group.
• Nothing gets lost. When a salesperson leaves or goes on holiday, the history stays with the company.
• Predictable income. You can see who is likely to order again and plan stock, staff and budget around it.

Example. A small online shop selling coffee equipment noticed that customers who bought a grinder often bought beans three months later. Because purchases were recorded, the shop sent a friendly reminder at exactly that moment. Repeat orders went up without any new advertising.

What to store

• Basics: name, company, phone, email, preferred way to be contacted, language.
• Purchases: what, when, how much, returns, subscriptions.
• Behaviour: where the customer came from, which emails they opened, questions they asked, calls.
• Consent: what the person agreed to and when. This matters under GDPR.

Collect only what you will really use. Five fields filled in properly are worth more than twenty empty ones. It is also easier to protect less data.

Spreadsheet or CRM?

A spreadsheet is fine for the first few dozen customers. Switch to a CRM (a simple program for managing customers) when two people start working with the list, or when you pass a few hundred rows. A CRM gives you:

• access rights, so not everyone can see or delete everything;
• reminders, so follow-ups are not forgotten;
• a full history of every customer on one screen;
• ready reports on sales and activity.

A shared spreadsheet quickly turns into several copies that disagree with each other. Moving to a proper tool costs little compared with one lost deal.

Keep it clean

A database that is full of old and duplicated entries sends your team to wrong numbers and wastes your advertising budget. Build a small routine:

• Every week: remove duplicates, fix obvious typos, update the status of open deals.
• Every month: remove email addresses that bounce and review contacts that have been silent for a long time.
• Two rules for the team: new contacts need the key fields filled in, and every conversation is noted in the customer card within 24 hours.

A nice trick: twice a year, send customers a short message asking them to confirm or update their details, with a small thank-you offer. You clean the list and get a reason to talk to them.

Split customers into simple groups

You do not need complicated analytics. A very practical method is RFM. For each customer look at three things: Recency (when they last bought), Frequency (how often) and Monetary value (how much they spend). Then act on the groups:

• Buy often and recently: thank them, offer loyalty benefits, ask for reviews.
• Used to buy, went quiet: send a friendly "we miss you" message with a reason to return.
• Bought once: help them come back, for example with useful tips for what they bought.
• Silent for a very long time: take them out of regular mailings to protect your sender reputation.

Numbers worth watching

• Customer lifetime value (LTV): the total revenue one customer brings over time.
• Customer acquisition cost (CAC): what you spend to win one new customer.
• Churn: the share of customers you lose in a period.

A healthy rule of thumb is that LTV is at least three times CAC. If it is lower, improve retention before spending more on ads.

A simple 90-day plan

1. Days 1–30: collect all existing contacts in one place, remove duplicates and add a contact form to every key page of your website.
2. Days 31–60: start a "bring a friend" offer for current customers and set up an automatic thank-you message after each purchase.
3. Days 61–90: publish useful content, collect sign-ups, and send a reactivation message to contacts who have gone quiet. Then look at the numbers and decide what to repeat.

The goal is not a perfect system. It is a living list that your team trusts and uses every day.