Smart campaign for assigning country | Community
Skip to main content
Lena_Masrialter
Lena_Masrialter
Level 2
March 15, 2018
Question

Smart campaign for assigning country

  • March 15, 2018
  • 1 reply
  • 2653 views

Hi guys,

I am wondering whether I can build a smart campaign that will automatically assign specific countries to leads. So, for example, I have app 4,000 leads with email domain "co.uk" (which points that they are most definitely from UK) but the country field is blank. How should I set up a smart campaign to change this data value?
Many thanks!

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

1 reply

Grégoire_Miche2
Grégoire_Miche2
Level 10
March 15, 2018

Hi Lena,

You will have to use a trigger or a filter on the person creation or data value change to the country field (with new value is empty constraint).

Then in the flow, you will have to set 2 flow steps:

  1. wait 5 minutes (this is to make sure that values are posted to the database)
  2. change data value. This one will have choices
    1. If country is not empty, do nothing
    2. If email contains ".co.uk", country is set to UK.
    3. If email contains ".de" country is Germany
    4. ...
    5. default choice : do nothing

BUT remember that domaine extensions are not always accurate. .com does not mean USA

-Greg

SanfordWhiteman
SanfordWhiteman
Level 10
March 15, 2018
    1. If email contains ".co.uk", country is set to UK.
    2. If email contains ".de" country is Germany

Hmm...

  • sandy@mail.denim.co.au isn't Germany, same with sandy@usedcar.deals (yes, that's a real TLD)
  • sandy@trustco.ukli.org isn't UK

I think the way to do this is create a new formula field that's the email plus the literal end-of-line character "$".

Then you can safely use [contains] ".de$", ".co.uk$", etc.

Grégoire_Miche2
Grégoire_Miche2
Level 10
March 15, 2018

You are right Sandy, but the truth is that, personally, I would not try to infer country from the TLD. If I really need the country field to be filled in, I would add it to my forms and make it mandatory.

-Greg

Terms & ConditionsAccessibility statement

Loading footer...