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.
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.
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).
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
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.
.png)
Adchoices