Customer records: the fields that actually matter
Photo: Avila Ops Tecnologia
An effective customer record has eight fields: name, WhatsApp, email, how they found the business, what they bought or requested, when, who served them, and one line of notes. Everything else, such as birth date, CPF, address, or profession, belongs only if you have a concrete use. Unused fields go unfilled, and half-filled records are worse than short ones.
Records are filled during service while customers wait. Each extra field adds a second and another chance of leaving it blank. The aim is not to know everything; it is to contact the person again for the right reason.
What are the eight fields for?
| Field | Purpose | Without it |
|---|---|---|
| Name, as the person prefers | Speak to them later | “Hello, customer” |
| Main follow-up channel | No way to contact them | |
| Send proposals, invoices, newsletters | Everything trapped in WhatsApp | |
| How they found you | Know which channel brings customers | Invest in the wrong channel |
| What they bought or requested | Offer the right next step | Offer what they already have |
| When | Know who has disappeared | Not know whom to contact |
| Who served them | Continuity and responsibility | “Who spoke to them?” |
| Notes | Preference, restriction, context | Repeat an answered question |
“How they found you” is the most skipped field and the most rewarding. After 100 records, you know whether Instagram brings customers or just followers, and whether referrals are your biggest channel. That number is worth more than any social media report.
What should I not ask?
CPF unless issuing an invoice or contract now. Address unless delivering. Birth date unless you will actually do something on their birthday. Income, marital status, number of children: no.
Every stored item needs protection. The LGPD requires a purpose for each, and customers may ask why you have their CPF. “The system had a field” is a problem. The guide avilaops.com/guias/como-usar-ia-no-atendimento-sem-violar-a-lgpd covers what can be kept and used.
If you cannot state in one sentence what you will do with the data in the next 90 days, do not ask.
How do I fill it in without slowing service?
Split it into two moments. At first contact, only name, WhatsApp, and source. Three fields, 20 seconds. Fill the rest after the sale, once trust exists: email for the invoice, purchases, notes.
With WhatsApp service, records start themselves: number and name come from the conversation. Add source and request, which CRM does when connected to WhatsApp without copying. See What CRM is: customer records that work for its difference from spreadsheets.
One team rule: enter records today, not Friday. Friday records are made up.
What to do now
Open your current spreadsheet or system and count fields. Remove those empty in more than half the rows. Add “How they found us” if absent. Do it before the list fills with poor records. When records need to fill themselves from WhatsApp, learn how many messages become sales: avilaops.com/crm-para-pequenas-empresas or WhatsApp: wa.me/5517997811471.
Frequently asked questions
Do I need consent to register customers?
For data necessary for service and sales, the relationship itself provides justification. To use the contact later for offers or newsletters, the safe route is permission, an explanation of what you will send, and easy withdrawal anytime. Record agreement and its date.
Are business customer records different?
Add legal name, CNPJ, and the decision maker’s name, rarely the person making contact. The eight fields still apply, with “name” identifying the contact and a note about their role.
Where should I store records?
In one password-protected place, outside the agent’s personal phone. A shared spreadsheet works initially. CRM works when multiple people serve customers or the list exceeds a few hundred.
Turn what you learned into your next step.
Tell us about your company and what you want to improve. We can explore the right tools, integrations or custom project together.