Country standartization - what does your smart campaign look like?

[Talia_Burlamaqu]

Hi All,

Can you please share your experiences in building smart campaigns that look for country name standartization? What are the most common offenders and what are the variations you have included? For example: USA > U.S.A., US, United States of America, United States or United Kingdom > UK, U..K., etc.

Can you share your variation map here?

Many thanks in advance!

Talia

[Josh_Hill13 · Accepted solution]

Look here

Country and State Picklist Value Help for Marketo - Marketing Rockstar Guides

I believe Openprise posted some files that would help, but the best way is just to export your Country field to see what people are doing. Then standardize the entry points to prevent further non std values.

[Talia_Burlamaqu]

Josh, this is great, many many thanks!

[Mary_Rouzer3]

I agree with Josh, pull a list of all Country values in your database and use all variations as as starting point.

Smart List: Country is all nonstandard values

Flow: Change Data Value with a long, growing list of choices. For example, If Country is U.S.A, USA, United State, United States of America, then change Country attribute to United States

[SanfordWhiteman]

This is about 1000000000x easier with the assistance of a webhook, i.e. so you can use actual pattern matching with wildcards instead of preparing every single variation ahead of time (and can also maintain the list in spreadsheet form instead of in the Smart Campaign UI).

[Ayush_Aggarwal1]

Hi Sanford,

I liked the Webhook idea. Can you please share some examples on how to achieve it?

Regards,

Ayush Aggarwal