Help Center

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 (click to see the full list). 

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, blueconic179@hmail.com would become blueconic179@gmail.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:

Note: This data processor also removes all email addresses with a junk domain (e.g., blueconic179@example.com).