Expert knowledge for digital decisions
Can existing customer data be transferred to a new CRM?
Short answer
The usual process
- Inventory check – which sources are available, how many data sets, which fields are actually used?
- Field mapping – which field from the source corresponds to which field in the new system? Here it is decided whether information will be lost.
- Data cleansing – merge duplicates, standardize spellings, sort out obviously inactive data records.
- Test import – first into a test environment, results checked in a sample manner.
- Live import – with a fixed cutoff date and a rollback option.
The most common mistake
Transferring everything simply because it exists. An address book from fifteen years contains a significant proportion of contacts that are never used again. They slow down searches and distort any analysis.
A sensible limit: contacts with no activity in recent years are archived, not imported.
Data protection during the transfer
Purpose limitation also applies during the transfer: data may only be further processed for the purpose for which they were collected. Changing the system is not a new purpose – but a good opportunity to review and implement deletion periods. Marketing consents must be transferred along with proof; without proof, the contact may not be marketed further.
Key facts
- Common sources
- Excel, Outlook, old system, SQL database
- Main effort
- Data cleansing and field mapping, not the import
Sources
All external claims are backed by traceable sources.-
01
Datenschutz-Grundverordnung (Verordnung (EU) 2016/679) EUR-Lex / Europäische Union
-
02
Ouhud CRM Ouhud GmbH