System variables from survey responses defined. Easily export data to Excel Reports or CSV files.
Excel, Export, Data Collection, System Variables, Reporting, Capturing, Survey Software, Online Surveys, Survey Analytics
System Variables Explained
Where are these system variables shown?
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.
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.
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.
This is the Server Timestamp for the response. Our data center is located in United States (West Coast) PST Timezone.
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.
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.
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 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.
Can I view the raw data online without excel/csv option?
Yes. Use the Response Editor feature.
- Login » Surveys » Reports » Data Management » Response Viewer
You may also be interested in...