CX Transactions- Manual Import
When a customer interacts with your product/services to make a purchase, it is termed as Transaction. A customer can have one or more transactions. A Customer Experience survey is sent to a customer for each of their transaction to understand their experience during that transaction. Hence, to send out a survey, the transactions have to be imported in CX which mandatorily should have the customer's contact details. The most simple and effective way to import transactions in the feedback system is using Excel file. This document will help you to understand how you can import a transaction using an Excel file in QuestionPro CX.
How do I send the email surveys to the customers?
To send the email or SMS Surveys, transactions needs to be imported in the feedback system.
The transactions can be imported using below 3 options:
- Manual Import
- Excel Import
- Automated import using FTP or API
- Go to: Deploy >> Distribute >> Send
- Select the format for importing transactions.
- Enter the details for all the transactions - Email address, Phone number, First and Last name, Segment, Product and other custom variables(if required). Email Address is only mandatory field.
- Click on Send Invite once you have entered all the details. For any invalid details, the system will display a validation message and will not import the transactions.
How do I send a survey once the transactions are imported?
Once you imported the file, the survey invitations will be sent to all the customers with valid email address and phone numbers.
Please Note: You will not be able to import an excel file until you have the workflow rules set up. Please click here to know more about workflow rules.
Which are the different language codes that can be used while importing transactions?
Following mentioned codes can be used to refer to the respective language, while importing the transactions.
| # | Language | Code |
|---|---|---|
| 1 | German | de |
| 2 | French | fr |
| 3 | Dutch | nl |
| 4 | Spanish (Spain) | es |
| 5 | Portuguese (Portugal) | pt |
| 6 | Italian | it |
| 7 | Russian | ru |
| 8 | Arabic | ar |
| 9 | Turkish | tr |
| 10 | Thai | th |
| 11 | Hebrew | iw |
| 12 | Chinese (Simplified) | zh-CN |
| 13 | Chinese (Traditional) | zh-TW |
| 14 | Japanese | ja |
| 15 | Korean | ko |
| 16 | Armenian | hy |
| 17 | Polish | pl |
| 18 | Hungarian | hu |
| 19 | Swedish | sv |
| 20 | Finnish | fi |
| 21 | Danish | da |
| 22 | Slovakian | sk |
| 23 | Romanian | ro |
| 24 | Norwegian | no |
| 25 | Greek | el |
| 26 | Czech | cs |
| 27 | Catalan | ca |
| 28 | Croatian | hr |
| 29 | Icelandic | is |
| 30 | Slovenian | sl |
| 31 | Khmer | km |
| 32 | Bulgarian | bg |
| 33 | Vietnamese | vi |
| 34 | Azerbaijani | az |
| 35 | Hindi | hi |
| 36 | Latvian | lv |
| 37 | Serbian | sr |
| 38 | English | en |
| 39 | Urdu | ur |
| 40 | Persian | fa |
| 41 | Sinhalese | si |
| 42 | Malay | ms |
| 43 | Estonian | et |
| 44 | Indonesian | id |
| 45 | Pashto | ps |
| 46 | Lithuanian | lt |
| 47 | Bangla | bn |
| 48 | Gujarati | gu |
| 49 | Ukrainian | uk |
| 50 | Odia | or |
| 51 | Telugu | te |
| 52 | Afrikaans | af |
| 53 | Burmese | my |
| 54 | Tagalog | tl |
| 55 | Tagalog (Philippines) | tl |
| 56 | Urdu (Pakistan) | ur |
| 57 | Spanish (Latin America) | es |
| 58 | Kazakh (Kazakhstan) | kk |
| 59 | French (Canada) | fr |
| 60 | Chinese (Hong Kong) | zh-HK |
| 61 | Macedonian | mk |
| 62 | Tamil | ta |
| 63 | Marathi | mr |
| 64 | Gurmukhi | pa |
| 65 | Amharic | am |
| 66 | Bahasa Indonesia | id |
| 67 | Haitian Creole | ht |
| 68 | Sinhala | si |
| 69 | Chinese Hong Kong | zh |
| 70 | Welsh | cy |
| 71 | English (UK) | en |
| 72 | Mongolian | mn |
| 73 | Zulu | zu |
| 74 | Albanian | sq |
| 75 | Laotian | lo |
| 76 | Kannada | kn |
| 77 | IsiXhosa (Xhosa) | xh |
| 78 | Portuguese (Brazil) | pt |
| 79 | Malayalam | ml |
| 80 | Maltese | mt |
| 81 | Kurdish (Kurmanji) | ku |
| 82 | Hausa | ha |
| 83 | Georgian | ka |
| 84 | Somali | so |
| 85 | Bosnian | bs |
| 86 | Arabic (Morocco) | ar |
| 87 | Nepali | ne |
| 88 | Hmong | hmn |
| 89 | Punjabi | pa |
| 90 | Uzbek | uz |
| 91 | Swahili | sw |
| 92 | Chamorro | ch |
| 93 | Karen | kr |
| 94 | Maori | ma |
| 95 | Oromo | om |
| 96 | Yoruba | yo |
| 97 | Moldovan | mo |
| 98 | Kinyarwanda | rw |
| 99 | Sepedi | nso |
