Some languages require gender-specific greetings for men and women. Like Madame and Monsieur in French. Although LinkedIn doesn’t show gender on the page, we can work around this using just 3 things:
- Name Index — a spreadsheet consisting of 2 columns: name and gender-relevant prefix. This table, once created, can be saved and used for all your campaigns where you need to customize the message based on the gender;
- Custom fields — this Linked Helper functionality allows you to create and add your own custom field besides most commonly used first_name, last_name, company, position. Using this tutorial, we will create a “gender” variable
- The power of Excel and a little bit of time 🙂
Ideally, what we want to achieve in our list is having each message with Madame or Monsieur prefix based on the gender or the recipient:
Off we go!
1. Name Index.
You can try to find one on the web or build your own. By googling “prénoms français csv” we get a full list of French names in CSV. This file needs to build matches between a name and a relevant prefix
2. Prepare and upload custom fields.
Let’s proceed to create a “gender” custom field.
2.1. Collect contacts into Linked Helper 2 (please check detailed instruction on how to add profiles to your campaign)
2.2. Now go to "Queue" of "Campaigns" menu, "Select All" => "Download" and choose "MS Excel" as delimiter:
2.3. After downloading a CSV file, open it in Excel (Please refer to this guide on how to open CSV files in Excel)
Keep only J, M, N columns
Of all these data we will keep only Profile URL, First name, and Last name (columns J, M, N), and delete other columns.
2.4. Add the 4th column “cs_greeting”. Make sure this column’s heading begins with cs_, as this will allow Linked Helper to recognize it as a new variable.
2.4. In a separate sheet of this csv file paste your Name Index table.
2.5. Now let’s start filling in our cs_greeting field using VLOOKUP, an Excel function to lookup and retrieve data from a specific column in the table. It will help us to insert the correct greeting automatically:
By dragging down the formula you will copy it into the whole cell range and see that the correct greetings have been pasted for each name. Go through your list carefully to check any errors or incorrect matches. You can manually correct them.
2.6.1. Save your Excel file with “cs_greeting” variable as CSV and upload it to Linked Helper 2 by clicking the “Custom Fields” button. Please check the detailed guide on how to upload custom fields here
After clicking the “Upload” button you will see what greeting will be used in the message for each contact:
3. Check the results.
Now we can navigate to "Workflow" of our campaign and check that our custom field is available for the message:
As you would see in the preview by clicking "Preview Message", the message that goes out contains the correct greeting:
You can find the Name Index (Prenoms) CSV and the Custom variable Excel files here: https://drive.google.com/open?id=1Sgi-LmUiLfiIAuTbUCEMLlzOG7lPWHBy