Country standartization - what does your smart campaign look like? | Community
Skip to main content
Talia_Burlamaqu
Talia_Burlamaqu
Level 2
November 8, 2018
Solved

Country standartization - what does your smart campaign look like?

  • November 8, 2018
  • 3 replies
  • 3722 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Josh_Hill13

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.

3 replies

Josh_Hill13
Josh_Hill13Accepted solution
Level 10
November 8, 2018

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
    Talia_BurlamaquAuthor
    Level 2
    November 9, 2018

    Josh, this is great, many many thanks!

    Mary_Rouzer3
    Mary_Rouzer3
    Level 2
    November 8, 2018

    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
    SanfordWhiteman
    Level 10
    November 8, 2018

    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
      Ayush_Aggarwal1
      Level 2
      November 13, 2018

      Hi Sanford,

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

      Regards,

      Ayush Aggarwal

      Terms & ConditionsAccessibility statement

      Loading footer...