In select BlueConic connections, when setting up a data import or export, you can use the Email cleansing data processor to correct common typing mistakes found in email addresses, such as misspellings, flipped letters, and extra spaces. When this data processor is activated, it automatically spots and removes those mistakes, ensuring that all included email addresses are in the right format (and able to receive communications).
Adding this data processor to a connection
The Email cleansing data processor is available in all BlueConic connections that use data processors. You can review the complete list here.
Each of these connections has a specific step on its import and/or export goal page to add data processors (e.g., "Correct your files before the import," "Modify your data before the export"). In that step, use the search box to add "Email cleansing"; once added, it appears in a numbered list of data processors activated for that connection.
For more information, review the full article Using data processors with BlueConic connections.
Configuring this data processor
The Email cleansing data processor requires some configuration to ensure that BlueConic imports or exports the data correctly. To make these configurations, click the cog wheel icon next to "Email cleansing" in the numbered list of data processors. This opens a window with two configuration settings:
- Email field: Select the field that contains the email address that should be cleansed.
- Domain correction: Enable the checkbox to correct spelling mistakes in the domain of the email address. For instance, firstname.lastname@example.org would become email@example.com.
Mistakes corrected by this data processor
When the Email cleansing data processor is added to a connection, it will make the following email corrections:
|Correction||Example email with error||Example email cleansed|
|Removing unnecessary capitalization||BLUECONIC179@firstname.lastname@example.org|
|Removing extra spacing||blueconic179 @email@example.com|
|Removing duplicate @ signs||blueconic179@@firstname.lastname@example.org|
|Removing invalid periods||.blueconic..179.@email@example.com|
|Replacing commas with periods (after which any invalid periods are removed)||,blueconic,firstname.lastname@example.orgemail@example.com|
|Correcting invalid top-level firstname.lastname@example.orgemail@example.com|
|Removing duplicate top-level firstname.lastname@example.orgemail@example.com|
|Adding missing top-level domains||blueconic179@firstname.lastname@example.org|
|Correcting spelling mistakes in domains (*when the Domain correction setting is enabled)||email@example.comfirstname.lastname@example.org|
|Removing invalid characters from domains (*when the Domain correction setting is enabled)||blueconic179@gmail®.email@example.com|
Note: This data processor also removes all email addresses with a junk domain (e.g., firstname.lastname@example.org).