---
title: "How to organise customer data and history · Lyntev"
description: "Separate people, companies and requests, define fields and handle duplicates carefully. Includes a completed example and a data-quality worksheet."
url: "https://lyntev.com/en/guides/organise-customer-data-history"
language: "en-GB"
date_published: "2026-11-21T17:20:13.047Z"
date_modified: "2026-11-21T17:20:13.047Z"
---

1. [Home](<https://lyntev.com/en>)
2. [Practical guides](<https://lyntev.com/en/guides>)
3. How to organise customer data without losing relationships or history

# How to organise customer data without losing relationships or history

Organising customer data means finding the right person, understanding their relationship with the company and consulting associated requests. A clean name list is only part of it. This guide helps define structure, sources and maintenance rules before importing data into a CRM or business management system.

By [Lyntev](<https://lyntev.com/en/company>). Updated on 17 November 2026.
About 5 minutes to read.

[Start reading](<https://lyntev.com/en/guides/organise-customer-data-history#leitura>)[Download worksheet](<https://lyntev.com/recursos/en/organizar-dados-clientes.txt>)

**The answer starts with the source**Approved information, defined access and a verifiable answer.

Translation published on 21 November 2026. [Original Portuguese guide](<https://lyntev.com/guias/organizar-dados-clientes>); source revision 17 November 2026.

By the end, you can:

- Define entities and identifiers
- Resolve duplicates without deleting context
- Create a quality routine

In this guide

1. [Separate things with independent lifecycles](<https://lyntev.com/en/guides/organise-customer-data-history#entidades-e-relacoes>)
2. [Define each field’s meaning and source](<https://lyntev.com/en/guides/organise-customer-data-history#dicionario-dados>)
3. [Find duplicate candidates before merging them](<https://lyntev.com/en/guides/organise-customer-data-history#identidade-e-duplicados>)
4. [Choose the authoritative source for each information type](<https://lyntev.com/en/guides/organise-customer-data-history#fontes-e-conflitos>)
5. [Keep data with a purpose and restrict access](<https://lyntev.com/en/guides/organise-customer-data-history#acesso-e-finalidade>)
6. [Create checks showing the problem and its owner](<https://lyntev.com/en/guides/organise-customer-data-history#qualidade-e-testes>)
7. [Document rules before the next import](<https://lyntev.com/en/guides/organise-customer-data-history#ficha-de-dados>)
8. [Sources and criteria](<https://lyntev.com/en/guides/organise-customer-data-history#fontes>)

## Separate things with independent lifecycles

A person, company and request change independently. Someone may change role; a company may have several establishments; the same contact may make several requests. Putting everything in one row causes repetition and makes it difficult to update a detail without changing the context of old requests.

In a fictional example, Ana Exemplo works at Oficina Horizonte and follows two requests, P-101 and P-118. Rui Exemplo works at the same company but follows only P-118. The model should represent these relationships without duplicating the company or merging requests. If Ana leaves, history still identifies who participated in previous requests.

Fictional relationship example

1. **Company E-01**

  Oficina Horizonte, with its own identity.
2. **Contacts C-01 and C-02**

  Ana and Rui, associated with the company.
3. **Requests P-101 and P-118**

  Separate journeys with their own participants.

The relationship may need a role, validity dates and a primary contact.

## Define each field’s meaning and source

Create a dictionary with name, meaning, format, required status and owner. Decide when the field becomes necessary. Asking for irrelevant information at first contact increases effort and may produce invented answers merely to pass validation.

Microsoft’s data-management checklist recommends defining the model and maintaining quality rules. The practical application is simple: two people should interpret a field the same way. “Status” must state whether it describes the contact, request or commercial relationship. “Date” must identify which event happened that day.

Define each field’s meaning and source

| Field | Example definition | Rule |
| --- | --- | --- |
| contacto\_id | Stable person identifier | Independent of name or email |
| empresa\_id | Link to the organisation | May be awaiting confirmation |
| email\_contacto | Address supplied for contact | Validate format and source |
| funcao | Person’s role in the relationship | Value reviewed when it changes |
| fonte\_atualizacao | Source of the change | Distinguish form, team and import |

- [Microsoft: data model, quality and responsibilities](<https://learn.microsoft.com/dynamics365/guidance/implementation-guide/data-management-check-list>)

## Find duplicate candidates before merging them

The same name does not prove someone is the same person. A shared email may also represent a team. Use stable identifiers and treat matches as review candidates when evidence is insufficient. Normalise spacing and formats without destroying the original value that may be needed to check its source.

PostgreSQL documentation distinguishes primary keys, uniqueness and foreign-key relationships. These mechanisms help apply rules already decided, but do not choose the correct identity themselves. An overly aggressive rule may join two people; a permissive one may create several records for the same person.

Before merging, show conflicting values, affected relationships and the record that will remain primary. Preserve decision history and a correction method. Test linked requests, activities and attachments in particular: resolving a duplicate contact must not delete a legitimate request.

- [PostgreSQL: identity, uniqueness and relationship integrity](<https://www.postgresql.org/docs/current/ddl-constraints.html>)

## Choose the authoritative source for each information type

If the website, CRM and invoicing system keep copies of the same data, define who may change it and which change takes precedence. The rule may vary by field. A customer-confirmed email and a name used on an issued document have different purposes; neither needs to be replaced by the last imported file.

Record the source and update time where this helps resolve conflicts. An empty imported field may mean “no information”, rather than “delete”. Define the difference explicitly. When someone changes data during synchronisation, the application needs to detect or resolve the conflict according to the agreed rule.

### Fictional precedence example

The CRM maintains the confirmed operational contact. An old import without a phone number does not delete the current number. An email change creates an update event but does not retrospectively change documents already issued.

## Keep data with a purpose and restrict access

Link each field to a task. Free-text notes tend to accumulate information nobody knows how to classify or maintain; prefer structured fields where there is a clear rule. Do not use commercial history to store passwords, credentials or personal details unnecessary for the process.

Define who can view, change and export each dataset. Permission to reply to a request must not be confused with a marketing preference. Record preferences and their source separately where the process uses them. Retention periods and applicable requirements must be defined for the business context rather than choosing one duration for everything.

- [Prepare team permissions](<https://lyntev.com/en/guides/define-team-permissions>)

## Create checks showing the problem and its owner

Start with problems blocking work: requests without contacts, nonexistent relationships, likely duplicates or missing required fields. Count and show affected records rather than only a global quality percentage. Each group needs an owner and a resolution rule.

In a fictional sample of 50 contacts, 6 have no email. That does not automatically mean six errors: some may use only a phone and meet the process rule. Conversely, a single request linked to the wrong person may be a priority. Assess meaning and impact rather than frequency alone.

Create checks showing the problem and its owner

| Test | Expected result |
| --- | --- |
| Two people with the same name | Remain separate without evidence of a common identity. |
| One contact with two requests | Both requests remain independent. |
| Import with an empty field | Follows the rule for preserving or clearing the value. |
| Deactivated company | History retains relationships and an understandable status. |
| Export by a restricted role | Excludes data outside authorised access. |

## Document rules before the next import

Choose a sample, apply the rules and ask the team to find some cases. If they find the person, understand the relationship and reach the correct request, the structure is starting to fulfil its purpose. Name who approves dictionary changes so new fields do not multiply without a purpose.

### Worksheet for your project

```
Customer data organisation worksheet
Necessary entities and relationships:
Stable identifier for each entity:
Fields, meaning, format and point when required:
Authoritative source and update rule for each field:
Handling empty and unknown values:
Criteria for suggesting and confirming duplicates:
Relationships and history to preserve in a merge:
Roles authorised to view, change and export:
Purpose, retention and owner of each dataset:
Quality checks and affected records:
Sample tested and unresolved problems:
Dictionary owner and review date:
```

## Sources and criteria

Content prepared with AI assistance and research using technical sources, with checks of the relevant examples and calculations. The references support the guide’s decisions; examples identified as fictitious let you try out the method.

- [Microsoft — Checklist for data management and governance](<https://learn.microsoft.com/dynamics365/guidance/implementation-guide/data-management-check-list>)
- [PostgreSQL — Constraints](<https://www.postgresql.org/docs/current/ddl-constraints.html>)

## Continue to your next decision.

- [Choose a CRM](<https://lyntev.com/en/guides/choose-crm-process-demonstration>)
- [Migrate data to a system](<https://lyntev.com/en/guides/migrate-data-new-system>)
- [Define team permissions](<https://lyntev.com/en/guides/define-team-permissions>)

[Explore the guide library](<https://lyntev.com/en/guides>)

## Put this decision into practice.

Steps, examples and worksheets to prepare the work in your business.

[Find a reading path](<https://lyntev.com/en/guides#percursos-title>)

### [How to prepare administrative registration for a first consultation](<https://lyntev.com/en/guides/first-consultation-administrative-registration>)

Reception confirms operations; clinical information and decisions go to the competent professional.

### [How to organise quote requests through WhatsApp](<https://lyntev.com/en/guides/organise-quote-requests-whatsapp>)

Turn a scattered conversation into a request the team can assess and track.

### [Which data and attachments should you request during online service?](<https://lyntev.com/en/guides/customer-service-data-attachments>)

Design the information journey before accepting every document by message.

## Would you like to apply this to your business?

Send us your worksheet or explain what you need to improve. We help you choose the next step for your project.

- [Lyntev assistant Immediate answers about services, prices and timescales, with a cost estimate. Read the assistant guide](<https://lyntev.com/en/help/ai-assistant>)
- [WhatsApp +351 928 412 891. The message is only sent when you confirm it in WhatsApp. Write on WhatsApp](<https://wa.me/351928412891?text=Hello!%20I%20came%20from%20the%20Lyntev%20website%20and%20would%20like%20to%20discuss%20a%20project.>)
- [Form Describe what you need and receive the reply by email. Complete the form](<https://lyntev.com/en/contact>)
- [Email contacto@lyntev.com Send an email](<mailto:contacto@lyntev.com?subject=Request%20for%20information>)

![Wellinton Oliveira](<https://lyntev.com/media/autores/wellinton-oliveira.webp>)

Written by

[Wellinton Oliveira](<https://lyntev.com/en/company>)

CEO of Lyntev

Technology with context, original analysis and sources you can consult.
