Within the Data Manager, you are able to view survey performance, set quotas, manage data, and export into a file ready for analysis. Read this guide to become more familiar with the Data Manager.
The General tab of the Survey page includes information about your survey’s response rate, including:
The bar graph to the right of the response summary data provides a visual representation of the same information. The dark color indicates the number of completed surveys. The light color indicates the number of active surveys, and white indicates the number of inactive surveys. The total of the three is equal to the number of invited participants.
Note: it is possible to change participant lists while a survey is actively collecting responses. When this happens, the number Not Started and Total categories may change. For example, your survey begins with 100 participants, and 90 respond. The survey status shows 90 completed surveys and 10 not started, for a total of 100. Then you delete the original participant list and replace it with a new list of 500 participants. The survey status now shows 90 completed surveys, 500 not started (because no one from the new list has responded) and 590 total. If you want accurate statistics about response rates, don’t delete participants from the participant list(s) associated with your survey.
The submission data in the General tab always represents submissions for the time period displayed in the Time Period list. Time periods are generally used in longitudinal studies in which each participant is asked to fill out a survey several times.
Choose a different time period to see submission info for that period. See the Time Period article for a general discussion of time periods.
The bars below the submission summary show your survey’s day by day response history. See Response History for details.
To view your survey, click the View Survey tab of the Survey page. This provides the following links:
It is possible to safely submit a test survey without affecting data submitted by actual participants. Test survey data are stored separately from actual survey data. Because the test survey may include questions that do not exist in the live survey, test survey submissions are stored in a separate table. Illume may automatically delete data from the test-published version of a survey if the survey changes substantially from one revision to the next.
The General tab of the Survey page includes a daily breakdown of completed surveys. The number of days on which surveys were submitted appears in parentheses in bold red text. Below that is a list of dates, with a colored bar representing the number of surveys submitted on that date.
These bars appear in reverse chronological order, with the most recent date on top. Click on any date or bar to see the actual list of participant responses for that day.
NOTE:Test data is not displayed in the Response History. Only data that were generated from actual participants are counted in the daily totals.
The Data Download tab of the survey page enables you to download survey data in a variety of formats. Note, however, that downloading data from the survey page means downloading all of the data that your survey has collected. If you want to download only a subset of the data returned by a query, see Downloading Results.
To download data:
A number of different file formats are available. SPSS and SAS data can be viewed in the raw data format only. Summary data are not available for SPSS and SAS. Data can be downloaded raw or summary data in Excel, HTML, Tab Delimited text, or XML.
The SPSS (Short Names) format limits all variable names to eight characters, to comply with naming restrictions in older versions of SPSS. The other SPSS format leaves your survey variable names intact, and is compatible with newer versions of SPSS.
If you want to import data into a SQL database other than Microsoft SQL Server, you may download the MS SQL format and run the CREATE TABLE statements in the file. You can then import the data by removing or replacing the GO statements, or by downloading the tab-delimited data and import that into the newly created database tables.
The summary data format displays the aggregate values that can be calculated from the participant data (Count, Percent, Max, Min, Mean, etc). With summary data it is easy to see the breakdown of responses for a particular question. With questions that allow for free-form text responses, such as comments, aggregate values cannot be calculated. Only the number of the responses can be calculated. If you would like to view text-items in a list instead of viewing only the number of responses to this type of question, choose the “list text items” option. This will provide an overall report that includes summary data for questions with scale values and raw data for text-entry questions. Please note, if there are a large number of responses, there may be a long list of comments in the report.
The raw data format displays questions in a large table. This is your standard spreadsheet layout where each column is a question, and each row is a participant’s response. Each cell of the table is a participant’s response to a particular question. If you plan to run your own reports, download the raw data and import them into your favorite statistical package.
SAS and SPSS download formats may include only raw data. The options to List Text Items and Include Value Labels do not apply to these formats. Because these formats can only include raw data, the text items are always part of the download. In addition, the downloads include not only the data, but a data dictionary SAS and SPSS automatically import. This means that the value labels always come with the SAS and SPSS downloads and will be present when you import the data into SAS or SPSS. There are 2 different formats to download SAS and 3 formats for SPSS.
Summary results include no useful information about text items. Because text questions are open-ended, permitting an almost unlimited range of responses, Illume does not calculate counts, percentages, or other statistics for these questions.
When you check the List Text Items option, your download will include raw data for each of the text questions in your survey. For example, if 100 participants typed in their first names, the download will include all 100 first names.
The Include Value Labels option adds value labels next to the value codes in the data you download. For example, a question called GENDER may have two response options: 1 = Male and 2 = Female. When you download the raw data, the GENDER column will be a list of 1’s and 2’s.
When you check Include Value Labels, each entry in the GENDER column will be either 1:Male or 2:Female.
This option makes the data more readable to humans, but it hinders applications such as Excel from processing the data in a purely numeric way.
The Include Value Labels option applies only to Raw data in formats other than SAS and SPSS.
When a survey is stopped and restarted, there is an option to create a new time period. Time periods allow a convenient way to group participant responses and query the data.
The General tab of the Survey page displays the response rate and history for a single time period. By default, this is the current or most recent time period. To display the response history for another time period, simply choose the desired period from the Time Period list.
When downloading data, you have the option to download all the survey data or only data belonging to a specific time period. By default, the time period is set to the current or most recent time period. You may download data for any time period by selected the period under the Data Download tab.
Illume can generate random test data for a survey. This is useful for testing queries.
To add test data to your survey:
Illume creates the test data a few rows at a time while a progress bar displays the number of rows created.
To remove test data:
When test data is removed from a survey, Illume deletes all participant responses that have the “test data” flag set to true. This includes test data that were submitted by any Testers. Please see Adding Participant List Members to learn more about creating Testers.
Test data can be generated for preloaded questions (i.e. hidden questions that have a user name assigned to them). Please note that test data is still not able to be generated for hidden questions whose values are not preloaded from a participant list.
NOTE: This participant list should contain test participants that contain user data fields and values that are used by preloaded questions in the survey.
Buttons to delete or unsubmit single or multiple survey sessions appear on the Participant Results page if the User has Administrator role for this survey.
Deleting a submission to the survey will completely erase any history of this participant taking this survey. All responses will be lost and will not be recoverable.
Unsubmitting a submission will retain all survey data but will change the submission status from “Submitted” to “Partial” allowing them to modify their responses if necessary.
There is a tab in the Data Manager at the survey level that will display the Quota Group Objects and Quotas created in a survey. This display shows the names of the Quota Group and Quota Objects as well as the Quota Description, Quota Condition, the number of participants meeting the Quota condition (Current), the specified quota limit (Limit), and the percentage full (Current divided by Limit).
Quota statistics for test data can be viewed by clicking the Show Test Data Quotas button. After showing the Test Data Quota statistics, they can be hidden by clicking the Hide Test Data Quotas button.