Ads

prozakis
Top Contributor

Country from Facebook ads comes with 2 letter acronym and Hubspot won't recognise this

I use the interface of Facebook to Hubspot for our ads (Facebook lead ads).

 

So incoming leads from Facebook enter directly HubSpot.

 

The problem : Facebook reports the country with 2 letters, for example TR for Turkey, LB for Lebanon.

But Hubspot expects Lebanon, not LB. So country field remains empty. Any workaround for this ?

4 Replies 4
webdew
Guide | Diamond Partner
Guide | Diamond Partner

Country from Facebook ads comes with 2 letter acronym and Hubspot won't recognise this

Hi @prozakis,

To clarify, is this country value coming from Facebook being saved into a property in HubSpot?

 

As per the details shared, I would recommend creating a custom property in HubSpot such as "FB country" and make it a single line text so that the value can sync.

Hope this helps!


If we were able to answer your query, kindly help the community by marking it as a solution.

Thanks and Regards. 

0 Upvotes
prozakis
Top Contributor

Country from Facebook ads comes with 2 letter acronym and Hubspot won't recognise this

If we create a custom property to accept any incoming text, then we do not really use the country field. We use a random text field.

Then how can we complete the proper country field with the correct value ?

0 Upvotes
bsheen
HubSpot Moderator
HubSpot Moderator

Country from Facebook ads comes with 2 letter acronym and Hubspot won't recognise this

Hi @prozakis,

Thanks for reaching out to the Community!

 

The root cause here is that the country property in HubSpot has been converted to a drop-down select field type and a list of country names has been loaded into the property as drop-down select options (enumerations). By default, the country property in HubSpot is a single-line text field that would accept any value. However, a drop-down select field requires the value being input to match a value in the list of available enumerations.
 
Because the default Facebook lead ad field mapping for country is to country, the values do not match, and will not populate. -see Understand how Facebook and LinkedIn lead ad fields map to HubSpot properties
 
One possible solution would be changing the Lead Ad Form mappings from FB for country to a custom property in HubSpot. Changing the country property in HubSpot back to a single-line text field would be another. Both would involve a bit of effort, but I think starting will the Lead Ad Form would require less. What do you think?
 
If starting with the Lead Ad Form sounds like a good idea, we would need to recreate the forms as we cannot edit Lead Ad Forms once they've been created. The first step here would be to create a new test Lead Ad Form and confirm we have the option to change the default mapping of country to a HubSpot custom property. If we have access to workflows, we could also think about a fancy workflow to convert and copy the FB enumerations stored in the custom property to the HubSpot country field.
 
Do you want to try creating a new test Lead Ad Form with the country field mapped to a custom property?
 
Looking forward to continuing this conversation here!
 
Best,
Brendan
prozakis
Top Contributor

Country from Facebook ads comes with 2 letter acronym and Hubspot won't recognise this

Why don't you just create a look up table in hubspot where incoming "country" value of "Lebabon" remains as is and incoming value of LB  changes to Lebanon.