LinkedIn Lead Gen - Country list

[Andreia_Norsa]

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

[Jay_Jiang]

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]

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'}";
?>