dedupe · e.164 · herr/frau
Data operations
Somewhere between the CRM export and the campaign tool, the umlauts broke. Half the phone numbers lost their country codes, and three sources produced the same prospect twice.
Sending on top of data like that costs replies first and domain reputation second.
[01]scope
What this includes
- Deduplication across multi-source lists
- Blocklist and suppression cross-checking
- Repair of corrupted German umlauts (ä, ö, ü, ß) in CSV exports
- Phone normalisation to E.164 across 60+ country formats
- Gender classification for correct Herr/Frau salutations
- Company–website mismatch flagging
- German legal entity suffix handling (GmbH, AG, KG, e.K., GmbH & Co. KG)
- Python-based cleaning at scale (pandas, openpyxl)
[02]method
Method
A German prospect addressed as 'Sehr geehrte Frau' who is a Herr does not read email two. Salutation accuracy is a data problem, and it is solved before sending, not after.
Cleaning runs in Python (pandas, openpyxl), so the same repair is reproducible on the next export instead of being a one-off manual pass.
Book a call and bring a sample export — the first step is a written assessment of what is broken in it.