Browse all articles tagged with #contact data.
Lowercasing the entire contact file looks harmless because most familiar providers treat address capitalization generously. A general-purpose data pipeline should be more careful about what it promises.
The address column imports correctly, but names arrive as broken characters. Do not run a global find-and-replace on the contact list. First establish how the file was encoded and how it was opened.
A customer signs up with a tagged address and later uses another variation. Removing everything after the plus sign may look like an easy cleanup, but it can erase useful information or apply a rule the destination…
Two rows contain [email protected] and [email protected]. Before sending both, it is worth checking whether your deduplication rules understand that particular provider.