How to organise customer data without losing relationships or history Worksheet ยท Lyntev https://lyntev.com/en/guides/organise-customer-data-history Document rules before the next import 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: