Fixing typos in email addresses

[Sarah_Way1]

Is there a way to use a Smart Campaign to fix typos in email addresses?

My company just started using Marketo, and many of our email addresses have typos (sample@yaho.com, sample @ yahoo.com, sample@@yahoo.com, etc.). Is there a way we can automate the correction of these?

[Andy_Varshneya1 · Accepted solution]

Hi Sarah,

No you can't do that with smart campaigns because those can only modify the entire field, not just a part of it.

You'll want to check out external tools that are available such as Informatica​ or any other data enrichment service.

[Sarah_Way1]

Thanks so much! I figured as much, but thought I would ask!

[Anonymous]

Hi Sarah,

How big is this issue? How many leads approximately?

There can be automated solutions that can be developed..

Rajesh

[Sarah_Way1]

Hi Rajesh,

We're still in the process of integrating our CRM with Marketo, so I'm not entirely sure. Maybe around 5,000? Maybe more?

[Anonymous]

I see. Can these records be fixed in the CRM itself, before they come into Marketo?

If not, I can help you create an automated way in Marketo. Please feel free to reach out at Rajesh@BrightAspects.com

Rajesh