Send survey email in language based on country field
Hi,
We would like to have a pilot transactional survey based on Salesforce event. Our current ISO language field is in a different format than what Qualtrics accepts. Can we use a SF country field to set up a language somewhere in Qualtrics Workflow, e.g. javaScript or something to do, for example, if country is France-send the email in French etc.
We will do a Salesforce development on the language codes after the pilot, so we need to have an interim solution meanwhile.
Thanks a lot!
Page 1 / 1
hi @MsIreen , if you can pull the language abbreviations same as below table (French=FR) then you can show your survey in French by mapping language data in Q_Language variable and also can send invite in French language itself. (Continue reading . . . ).
SQI
Albanian
FR
French
NO
Norwegian
AR
Arabic
FR-CA
French Canadian
ORI
Odia/Oriya
HYE
Armenian
KAT
Georgian
FA
Persian
ASM
Assamese
DE
German
PL
Polish
AZ-AZ
Azeri/Azerbaijani (Latin script)
EL
Greek
PT
Portuguese
ID
Bahasa Indonesia
GU
Gujarati
PA-IN
Punjabi
MS
Bahasa Malaysia
HE
Hebrew
RO
Romanian
BEL
Belarusian
HI
Hindi
RU
Russian
BN
Bengali
HU
Hungarian
SR
Serbian
BS
Bosnian
HIL
Ilonggo/Hiligaynon
SIN
Sinhalese
PT-BR
Brazilian Portuguese
IT
Italian
SK
Slovak
BG
Bulgarian
ISL
Icelandic
SL
Slovenian
CA
Catalan
JA
Japanese
ES-ES
Spanish EU
CEB
Cebuano
KAN
Kannada
ES
Spanish LATAM
ZH-S
Chinese (Simplified)
KAZ
Kazakh (Cyrilic)
SW
Swahili
ZH-T
Chinese (Traditional)
KM
Khmer
SV
Swedish
HR
Croatian
KO
Korean
TGL
Tagalog
CS
Czech
LV
Latvian
TA
Tamil
DA
Danish
LT
Lithuanian
TEL
Telugu
NL
Dutch
MK
Macedonian
TH
Thai
EN-GB
English – UK
MAL
Malayalam
TR
Turkish
EN
English – US
MAR
Marathi
UK
Ukrainian
EO
Esperanto
MN
Mongolian
UR
Urdu
ET
Estonian
SR-ME
Montenegrin
VI
Vietnamese
FI
Finnish
MY
Myanmar/Burmese
CY
Welsh
If you only want to show your survey in French language. Then you try this.
Suppose your salesforce language field name= sf__language you can extract that information in XMD and map sf__language with XMD Q_lang.
Example= sf__language=French
then Q_lang is also equal to French.
then you can punch the Q_Language value as FR respective to Q_lang=French variable. Same why you can apply punching for other countries. But make sure to apply this punching at the beginning of survey flow (before all questions).
Try this and test your survey with sample data properly before launch.
@ArunDubey this will not unfortunately solve the email invite language problem for us.
This can solve, if you apply some tricks. Refer below.
instead of creating one invite file in library and uploading translation on that you can create country wise invite files.
Create email automation respective to each country.
All filter criteria on each automation using language variable, eg. for English, you can use embedded data sf__language=English then send survey, or for French, you can use sf__language=French then send survey.
Then you can apply Q_Language embedded field punching logic as mentioned in my previous response to show your survey in French. Try this, but make sure to test it properly.
@ArunDubey it is a transactional survey integrated and triggered by SF event, so we do not create any distribution files.
My thinking was if in the Qualtrics workflow before the distribution task we can create a code which would create a variable based on the country field value in SF. And we will pass this value to the distribution task under the language.
Btw, I also considered creating in the Qualtrics workflow conditions and different distributions, but this is a huge amount of manual work due to contact embedded data field creation for each of the distribution, which is hundreds of fields (so it is the least preferred option)
@ArunDubey it is a transactional survey integrated and triggered by SF event, so we do not create any distribution files.
My thinking was if in the Qualtrics workflow before the distribution task we can create a code which would create a variable based on the country field value in SF. And we will pass this value to the distribution task under the language.
So, your process is, in some point SF account information will be updated based on sold and shipping information and Qualtrics will extract that information and update the XMD to trigger the survey from Qualtrics. If you are using the Qualtrics distribution, then distribution task in workflow cannot handle this as there is no such filter option. Then you will need to create email distribution automation under XM directory and can apply filter there.
@ArunDubey I guess you are talking about the message triggers in a mailing list?
In this case we will need to create separate emails per language, I guess, for each country? We have an embedded question in the email, so i think it will still be in english regardless.
I’m talking about email automation. it’s way much better option then message trigger. try this one.
@ArunDubey oh I see. However, the embedded question problem will still stand, also I have a concern. So new contacts will be added daily to the list, but the automation can be configured only as to all contacts who, let’s say have “France” as a value in the country field. the filter logic will have to be quite complex and thought through, as we have repeated contacts, to whom we want to send survey again, also contacts who received some other surveys, so, e.g. statistics filters would not help for that.
You can schedule your automation daily basis, can give 5 different times to trigger the survey. Statistics filter should help on this, you will need create combinations. Where you can give frequency of survey trigger to specific contact. you can apply merge rules so based on that rule your survey will be triggered to that respondent. you should explore Qualtrics support site for the same.