How to: Segment Titles in a Foreign Language Using Google Translate

Segmenting titles in a foreign language is difficult. The Openprise Job Level and Job Function open data sources have some foreign keywords, but not as many as English keywords.

To work around this limitation, you can build a custom mapping using a G-sheet translation function to translate titles and then assign the appropriate Job Function, Job Level and priorities.

Here is an overview of how to proceed:

1. Generate a file by filtering on leads or contacts that have no job function, but do have a title. It may help to add filters for:
   1. Country
   2. Title does not contain a, b, c, d, e, f, g,....etc. This will show titles that have no Latin alphabet characters.
2. Export the file
3. Open the file in G-sheets
   1. Sort the title column
   2. Remove duplicates (Data>Remove Duplicates)
   3. In a column next to the title, add a formula as shown:
   4. To find the original language use “=detectlanguage(d8)” in the next column. The 2 letter language code is returned in most cases. A list of valid values is at the end of this document.
   5. Load the resulting file into Openprise and use the Open Data Job Function file to segment the translation column to check the results and adjust as necessary.
   6. Once you’re satisfied with the results, add the values in the title column with a priority of 1 and load the table with the title, the translation, and Priority.
   7. Update your segmentation job to first use the Open Data file, and if no Job Function is found, then use the custom table.

Note: This process will have to be repeated periodically as it relies on the full title for matching.
Job level keywords vary from country to country so keywords and job levels should be adjusted according to the local conventions.

Valid Language Codes