Wondering why data normalization of Geography is not out of the box waiting to turn on in Marketo? Marketo sets up a ton of programs and things to help people keep their DB healthy, this should be one of them. As Marketers, we constantly have lists from 3rd parties, events, and other sources where the data points are not consistent. This means someone has to standardize the data before importing it into the system. It would be smarter if they system had logic that would do that automatically as a lead was created.
I have seen Oregon written: Oregon, Ore., Oreg., Ore, and OR... yet I only want my system to have OR.
The logic would be:
SmartList = Lead was created & State is: Oregon, Ore., Oreg., Ore
Flow = State is: Oregon, Ore., Oreg., Ore then change state to OR
If your system is new, create these right away and never have to fix geography again... if not, create these twice with a batch and trigger to ensure your DB is up to date.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.