The survey constructs and questions should be captured with columns as shown in the Excel Take-on file and as outlined below:


Part 5X Excel1

A. Construct Name – short descriptive name for the survey construct; see the image further down below for how it will be displayed in the analytics dashboard.
B. Construct Type – include one of the following construct types (see Add construct below for more):
Quantified – combine and average the scores of all Likert and dropdown survey questions
Non-quantified – include NPS and other survey questions that will not be averaged (click here for more on NPS survey questions).
C. Construct Description – short description of the survey construct (10 - 15 words); see the image below for how it will be displayed in the analytics dashboard.

Part 5D add sample
D. Survey Questions – question text, either as a statement or a question with a question mark.

 


Part 5X Excel2

E. Question Type – include one of the following survey question types (see Adding or Editing Survey Questions below for more):
Likert – single-option multiple choice (Likert) survey question
Dropdown – single-option dropdown survey question;
NPS – net promoter score survey question(click here for more on NPS survey questions)
Open-ended – comment-type (qualitative) survey question.
F. Mandatory – include TRUE if the survey question should be treated as a mandatory question in the online survey questionnaire.
G. Reverse Score – include TRUE if the survey question should be reversed-scored in the analytics dashboard.
H. Include N/A – include TRUE if a not-applicable (N/A) option should be included for the survey question in the online survey questionnaire.
I. Option #1 – text for the first multiple-choice or NPS survey question (click here for more on NPS survey questions) option (leave blank in case of an open-ended question).
J. Option #2 and more – text for additional multiple-choice survey question options, or can be left blank.

 

For more information, click on a sub-menu item at the top of the page⇑ or in the right margin