SOLVED

Re: Country standartization - what does your smart campaign look like?

Go to solution
Talia_Burlamaqu
Level 1

Country standartization - what does your smart campaign look like?

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

1 ACCEPTED SOLUTION

Accepted Solutions
Josh_Hill13
Level 10 - Champion Alumni

Re: Country standartization - what does your smart campaign look like?

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.

View solution in original post

5 REPLIES 5
Josh_Hill13
Level 10 - Champion Alumni

Re: Country standartization - what does your smart campaign look like?

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
Level 1

Re: Country standartization - what does your smart campaign look like?

Josh, this is great, many many thanks!

Mary_Rouzer3
Level 2

Re: Country standartization - what does your smart campaign look like?

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
Level 10 - Community Moderator

Re: Country standartization - what does your smart campaign look like?

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
Level 2

Re: Country standartization - what does your smart campaign look like?

Hi Sanford,

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

Regards,

Ayush Aggarwal