Smart campaign for assigning country

[Lena_Masrialter]

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!

[Grégoire_Miche2]

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]

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]

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

[SanfordWhiteman]

I agree, though some ccTLDs are good predictors of the language (though not current geographic location) of the lead, there are so many that are not that this is a contributing metric at best.