This article describes one method to translate foreign keywords or titles into english using a Google Sheets translation function. Use this method when creating custom segmentation reference data sources.
Learn more about segmentation HERE.
Learn how to build a customized segmentation reference data source HERE.
Translate Foreign Keywords
- Create a new column with the header "English Translated Keywords" (column F).
- Type the below formula into the second row of column F.
- D2: Column D, row 2
- C2: Column C, row 2
This formula detects texts that do not equal "English" from the Language column (column D). If a text is detected, Google Translate will translate the matched keyword from the Keyword column (column C) into english.
You can use this same method to translate foreign titles by swapping C2 in the formula with the column and row containing title values.
Double click the bottom right corner of the second row in column F to apply the formula to the entire column.
Modify Segmentation Job
Import the Google Sheet as a new Data Source. Learn more about Data Sources HERE.
- Use the new Data Source as a reference data source in the infer task(s) of your segmentation job.
- Compare the input value from the input data source to the English Translated Keywords attribute in the new Data Source.
- Select "input value contains reference value" as the match method.
- Save