System Variables Explained

Whenever you request the raw data (via Excel reports, CSV file, or the Response Viewer), the first few columns of data are the System Variables that the survey engine captures for each respondent. You can view the system variables under the response viewer.

Go to: Login » Surveys » Manage Data » Responses

Survey Software Help Image

Response ID:

This is the unique identifier associated with each survey response. This number is auto-generated by the application. Every survey response has its own unique identifier.

Survey Software Help Image

IP Address:

This is the Internet IP Address of the user responding to the survey. Please note that if your users are coming through proxy servers (AOL, Corporate Networks), the IP Address will not be unique.

Survey Software Help Image

Timestamp:

This is the Server Timestamp for the response. Our data center is located in United States (West Coast) Pacific Timezone.

Survey Software Help Image

Device Data:

This field will capture the type of device and operating system used to access the survey. Device data captured here is the same as device data shown in the Real-time Summary.

Survey Software Help Image

Time Taken To Complete (Seconds):

This is the time taken for the respondent to complete the survey. In cases where the respondent does not complete the survey, this will be 0 since the respondent did not complete the survey.

Survey Software Help Image

Response Status:

Status for the response whether it is completed or incomplete.

Survey Software Help Image

Sequence Number:

In surveys with looping the same question may be asked multiple times depending upon how the respondent answer ed to a preceding question. The Sequence Number represents each loop i.e. the number of times that question was displayed depending on the answer options selected. For each loop a new instance of that response is created and saved in a new line with the specific Sequence Number. For information on looping please refer to the Multiple Looping link below.

Survey Software Help Image

External Reference:

If you have your own custom identifiers that you’d like to pass on to the survey engine to record each unique respondent, this will show up here. If you take the survey using the Preview button, you will see “test_response” recorded.

Survey Software Help Image

Custom Variables 1 to 5:

Custom variables will be displayed under these columns.

Survey Software Help Image

Respondent Email:

If you distributed the survey via email from within QuestionPro (not export batch using an external email engine) and selected the respondent tracking link for the survey, then the email address of the respondent will appear here.

Survey Software Help Image

Email List:

This will include the name of the email list used to distribute the survey. If you sent the same survey to multiple email lists, the different names of the email lists will appear here, depending on which email list the respondent was associated with.

Survey Software Help Image

Country Code:

If your license level includes geo-coding, you will see the country code of the respondent.

Survey Software Help Image

Region:

If your license level includes geo-coding, you will see the region code of the respondent (state/region).

Survey Software Help Image
License

This feature/tools described here are available with the following license(s) :

Free License and above