What are system variables?
Whenever you request the Raw-Data (Via. Excel Reports or CSV File or the Response Editor) the first few columns of data are the System Variables that the Survey Engine captures for each respondents. You can view the system variables under the response viewer.
This is the unique identifier associated with each survey response. This number is auto-generated by the application. Every survey response has it's own unique identifier.
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.
Timestamp: This is the Server Timestamp for the response. Our data center is located in United States (West Coast) PST Timezone.
Duplicate: N/A Currently
Time Taken To Complete (Seconds): This is the time taken for the respondent to complete the survey. In cases where the respondent abandons the survey, this will always be 0 -- Since the respondent did not complete the survey.
Response Status: Status for the response whether it is completed or incomplete.
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 th at 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.
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.
Custom Variables 1 to 5: Custom variables will be displayed under these columns.
Respondent Email: If you used the Address Book -- The Integrated Email List Manager, the email address of the respondent will be displayed here.
Note on Geo Codes: If your license includes the "Advanced Analysis Tools" option, you'll also get the GEO-Codes, (Country, Region, City, DMA Code and Area Code) of the respondents IP Address.