How to use imported metadata values in survey questions?

Note: all information presented in the article is valid for 10.17.0 VoC Hub release.

Any imported metadata value can be used in questions while passing a survey. For this purpose, two placeholders can be used in Question text field.

What placeholders do: Expands to the contents of the column for the given customer in the original import file

Depending on a channel you would like to use, different placeholders are used.

SMS and DIGI channel surveys

For DIGI and SMS channel surveys, it is {{ questionnaire | meta:"IMPORT_COLUMN" }}, where IMPORT_COLUMNis the name of the column you need to derive the data from.

Let's say you have an import file with some additional data next to required information:

In this case, you can use import column CITY in your questions to personalize them.

Example:

As a citizen of {{ questionnaire | meta:"CITY" }}, how would you rate the quality of the Internet connection in your city?

When an invite is prepared and sent to the customer user@example.org, they will receive the following:

As a citizen of Zurich, how would you rate the quality of the Internet connection in your city?

And in the invite sent to anotheruser@example.org they will see the following:

As a citizen of Lausanne, how would you rate the quality of the Internet connection in your city?

WEB channel surveys

For WEB channel surveys, another placeholder is used: {{IMPORT_COLUMN}}. It works in the same way as the {{ questionnaire | meta:"IMPORT_COLUMN" }} in SMS and DIGI channel: IMPORT_COLUMN is the name of the column you need to derive data from. 

Following the example above, let's see how this {{IMPORT_COLUMN}} can be used in a question text of a survey:

As a citizen of {{CITY}}, how would you rate the quality of the Internet connection in your city?

 With such a question text the aforementioned customers user@example.org and anotheruser@example.org will see the personalized question in WEB channel about the quality of the Internet connection in the relevant city, as in the example above.

Additional information

You can fall back to some default value in case the value is not present in the import file. In order to use this, please use the following syntax:

For SMS and DIGI surveys: {{ questionnaire | meta:"IMPORT_COLUMN" | default:"Default_value_to_use" }}

For WEB surveys: {{IMPORT_COLUMN|Default_value_to_use}}

where:

• IMPORT_COLUMN is the name of the column you need to derive the data from
• Default_value_to_use is the default value VoC Feedback will fall back to in case the value for IMPORT_COLUMN was not found in the import file for the given customer