Fixing typos in email addresses

Sarah_Way1 · ‎12-10-2015

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 · ‎12-10-2015

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.

View solution in original post

Andy_Varshneya1 · ‎12-10-2015

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 · ‎12-10-2015

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

Anonymous · ‎12-10-2015

Hi Sarah,

How big is this issue? How many leads approximately?

There can be automated solutions that can be developed..

Rajesh

Sarah_Way1 · ‎12-11-2015

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 · ‎12-11-2015

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