Skip to main content
Andreia_Norsa
Andreia_Norsa
Level 3
April 3, 2019
Question

LinkedIn Lead Gen - Country list

  • April 3, 2019
  • 1 reply
  • 2559 views

Hi all, We use the LinkedIn Lead Gen integrated with Marketo. Recently LinkedIn changed the country list values with different languages. I have a filter in SFDC which prevents leads to be synced in case of wrong values. This is to improve our data cleansing. Therefore, I have been fixing countries values manually and daily. The new LinkedIn country list has 4 different languages and 250 countries. Do you have an automated solution to fix that? I know I can create a trigger campaign to convert all values to English (our SFDC country list), but it will take a long time considering the number of values. I also spoke to Marketo support and they mentioned that there is no other solution. Thanks in advanced. Andreia

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

1 reply

Jay_Jiang
Jay_Jiang
Level 10
April 3, 2019

If you can get the LinkedIn list of countries, you can build a webhook service that looks up any country value in any language that LinkedIn sends Marketo and return the country value in English that your salesforce will allow

The lookup is much easily managed outside of Marketo.

Jay_Jiang
Jay_Jiang
Level 10
April 3, 2019

Here's an example in php. Your webhook payload would include lang=ch&input=英国 and get "England" in the response. Optionally you can add output=[en,ch,fr,de,es] to get the response in any language in the data structure

<?php
$data = 
[
    'en'=>[
        'Australia',
        'China',
        'United States',
        'England'
    ],
    'ch'=>[
        '澳大利亚',
        '中国',
        '美国',
        '英国'
    ],
    'fr'=>[
        'Australie',
        'Chine',
        'États Unis',
        'Angleterre'
    ],
    'de'=>[
        'Australien',
        'China',
        'Vereinigte Staaten',
        'England'
    ],
    'es'=>[
        'Australia',
        'China',
        'Estados Unidos',
        'Inglaterra'
    ]
];
$inputLang = $_GET['lang'];
$input = $_GET['input'];
$output = $_GET['output'];
$key = array_search($input,$data[$inputLang]);
$response = $output ? $data[$output][$key] : $data['en'][$key];
echo "{'response':'$response'}";
?>
Terms & ConditionsAccessibility statement

Loading footer...