This article covers essential tips and tricks for working with the EFS Panel, including testing procedures, working with CSV files, managing external surveys, and enhancing security features.
Testing in the Panel
When setting up and operating a panel it is often necessary to check and test complex processes. EFS Panel gives you the option of setting up accounts with a special tester status, which allows you to test current surveys without falsifying the results:
- People with the “Tester” status can participate in a survey as often as they like. If a tester with the “Completed” disposition code accesses the questionnaire for a second time, the existing data will be deleted. The tester will begin the new entry on the first page of the project.
- Testers do not “resume” their work. If a tester interrupts editing for a prolonged period (more than 30 minutes) and then accesses the questionnaire again, they will resume the editing on page 1. “Normal” respondents see the page last sent.
- The test results are listed in both statistics and the export data record. However, they are identifiable as test results. In the master data record, panel testers have the value 16 in the “pstatus” field, while regular participants have another status. In the result data record of a survey (panel surveys, anonymous and personalized projects), tester records are identifiable through the “tester” variable, which has the value “1” for testers and “0” for other participants.
- Tester data can be deleted explicitly from the result data record of a project when it is generated. To do so, choose the “Reset survey, delete test participants and their result data” option in the Reset survey menu (until EFS 10.1: Compile) of the respective project and confirm by clicking on Reset survey.
- If you use a test account regularly, it is very convenient to register it as your personal standard panelist. Then, whenever you call up the website from EFS (e.g., from the website editor), this account will be used automatically, eliminating the need for entering login details.
Setting up a Tester Account
Please proceed as follows:
- Open the People → Panelists administration menu and click on the Add panelist button.
- Fill in the form. The details marked with an * are compulsory.
- Choose “Tester” status.
- Enter the participant data.
- Enter a real e-mail address that you have access to. Otherwise, you will not be able to control whether, for example, the sending of an invitation to the master data survey was done correctly.
Information: Pay attention that, when conducting tests, you only send emails to your account or a dummy account belonging to your company (with the agreement of the responsible system administration). - Optionally choose category and group. In a newly delivered standard panel, at least the group category “Default” (contains all groups) and the group “Default panel group” (contains all panelists) exist and can be selected.
- Select the language version.
- If you are using the Community features of the EFS Panel, configure the visibility of profile data for the new test account.
- Confirm by clicking on Create account.
You can now log in using the test panelist’s e-mail address and password and view the panel from their perspective.
Using an Existing Account to do Tests
Alternatively, you can also assign a panelist who has already been registered with the “Tester” status. To do so, switch to the People → Panelists administration menu, and enter the panelist’s name into the corresponding field. Trigger the search function by clicking on Search. The data of the panelist you are searching for will be output as a result. Use the drop-down list to set the panelist’s status to “Tester” and then confirm by clicking on Submit.
Testing Panel Functions
With a newly created tester account set up according to the instructions above, you will not be able to see an active survey or promotional campaign, because the tester does not belong to a sample or a group yet.
Adding a tester to a sample and inviting them to a panel survey
- Create the sample.
- Open the tab View tester list.
- Click the Add testers button. An overview of all the panelists with the “Tester” status available on the EFS Panel installation will be displayed.
- Select the desired testers and confirm the selection by clicking on Add.
- The testers will be assigned to the sample and appear both in the list of testers currently assigned to the project and on the tab Sample contents.
If you want to log in directly to the survey with your tester account, click the link in the column “Code”. If you invite the respondents in the sample using the “Inform” function, the tester will also be invited. Alternatively, you can copy the URL from the “Code” column into an e-mail to invite only the tester, e.g. for a pretest.
Information: Another option is to assign the tester using the features of the detail view. Search for the tester in Panelists administration and open the detail view. On the tab Surveys you can assign the tester to a sample.
Inviting testers to the master data survey
- Switch to the People → Panelists administration menu. Display the respective person.
- Tick the checkbox in the “Actions” column, and choose the “Master data survey” action from the drop-down list.
- After that, click on the Submit button.
Working with CSV Files
CSV (Character Separated Values) is an exchange format that is mainly used for exchanging data between different computer programs.
Creating CSV files in MS Excel
- Create the desired table in MS Excel.
- Save it in the CSV format: To do so, click on File → Save as and check that instead of the standard format *.xls the format *.csv has been chosen.
Creating a CSV file in a text editor of your choice
- Enter the data, marking the desired table columns with a semicolon.
- Save the file in the CSV format by giving it the extension “.csv”.
Opening CSV Files in MS Excel
Many panel functions allow you to export EFS Panel data in the CSV format, and then view or edit it externally. Please proceed as follows:
- Export the desired file from the EFS Panel.
- Open MS Excel.
- Choose File → Open.
- Select the “Text files (*.csv)” file type.
- Navigate to the desired file and click on it, so that the title appears in the “File name” field.
- Confirm by clicking on Open.
Renting Panelists out to Externally Conducted Surveys
This section describes how panelists can participate in a survey that does not take place within the panel but in another EFS Panel installation or, as the case may be, in another software environment. The challenge here is to provide incentives to the panelists promptly.
Determine firstly whether the software used to survey your panelists can save transferred parameters and insert them back into the link when returned to the panel site (in technospeak: Individual parameters for each panelist are transferred via GET and must be dynamically inserted into the return-to-panel-site link).
Should the software used on the actual survey platform be capable of the above, then it is recommended that you implement this using the external survey start feature. The survey is executed in three parts: An introductory page is located on your panel installation. After clicking on the Continue button you are sent to the external software, and at the end you are sent back to the panel installation. The transfer of parameters during transfer, transfer back and in the export data record makes it possible to perform matching between the two surveys. The dedicated manual “External Survey Start” explains in detail how to configure this.
Anonymous export of the panelist sample
An alternative is the anonymous export of the panelist sample:
- Form a group of the panelists that will be surveyed.
- Using the selective master data export, export the information that you would like to make available to the external cooperation partner, containing at least the pseudonym (the “pseudonym” variable).
- The external cooperation partner enters the pseudonym into the participant administration of their project. You invite the panelists from your system via email, indicating in the e-mail a URL to the survey of the co-operation partner. (Please note that you must enter this manually, you cannot use the usual mail wildcards from EFS Panel.) Indicate in the e-mail that the incentive for this project can only be given out after a certain delay at the end of the project.
- At the end of the survey, you will need a list of the people who successfully completed the survey from the external co-operation partner. The list must contain the pseudonym.
- Extract the mentioned pseudonyms into a one-column CSV file. Import the pseudonym file as a new group (see Chapter 8.3, p. 156). The group created this way can be given incentives using the appropriate functions of group administration.
Personalized Projects without a List of Participants
Not all personalized projects involve surveys of self-recruited participants. Often the external partner has a collection of e-mail addresses to be used as a sample. Sometimes the cooperation partner, on the one hand, does not want to give out these e-mail addresses, but on the other hand, wants to conduct the survey as a personalized survey.
The following procedure, in which codes generated in the EFS Panel are used for authentication, has proved suitable in such cases:
- The survey project is created as a personalized project.
- Choose “Code” as the access/login type.
- Using Excel, an import file containing dummy accounts will be generated. It is important here that you generate syntactically correct and unique e-mail addresses: Fill in the first column with the word name, the second column with the word dummy, the third column with an incremental number, and the fourth column with @yourdomain.com. Now, copy the three columns that together would create a complete e-mail address, into a text editor that supports regular expressions, and then remove the tabs between the lines. Next, copy the finished e-mail addresses back into your Excel file and save the result as a CSV file.
- Import this list of participants into your survey project. The import process will automatically generate codes for each participant.
- Export the participant administration with the address data export.
- The access codes generated are now available externally for further processing. The cooperation partner can dispatch the codes, for example, by post or e-mail.
- At the end of the project, perform a complete export of the address and result data to create a list of the participants who successfully participated in the project (disposition code > 30 or a specific variable allocated on the last page of the survey).
- Make this list available to your customer. It can be used, for example, for incentive management.
Mail Templates
Before a panel installation can become operational, you must at least complete the automatically sent mail templates, under Libraries → Mail templates, and define senders for them in the submenu Mail senders.
The following table gives you an overview of the mail template types and explains when each of them is used.
Overview of the mail template types
Mail template type | Type | When it is used |
---|---|---|
Default mail | Is available in all non-automated dispatch processes. | |
Invitation mail | Used to invite participants to a survey project. | |
Reminder mail | Used to remind participants of surveys they have not completed yet. | |
Notification before the end of the survey | Mail template used across the installation to notify users of the upcoming end of the survey. This notification may be requested in the dialog used to create and change projects. | |
Notification by the exchange platform | Mail template used to notify users of changes on the exchange platform. For more information on the optionally available exchange platform refer to the dedicated documentation “EFS Secure Exchange”. | |
Welcome mail | Automatic | Only in EFS Panel installations: Automatically sent to the panelist after the registration has been submitted. |
Password recovery mail | Automatic | Only in EFS Panel installations: If a panelist forgets their password, the content of this mail template will be sent automatically upon request. |
Duplicates check mail | Only in EFS Panel installations: If the EFS Panel administrator performs the duplicate check in the Candidates menu and finds that this panelist already exists, this mail template is used to contact the panelist via e-mail. | |
Registration error mail | Only in EFS Panel installations: If the EFS Panel administrator checks the data in the Candidates menu and wishes to send an inquiry mail to the respective panelist, this mail template can be invoked via the “Registration error” action. | |
Master data invitation mail | Only in EFS Panel installations: This mail template is displayed when you are inviting a panelist from the Candidates menu to the master data survey. | |
Master data reminder mail | Only in EFS Panel installations: This mail template is displayed when you are sending a reminder concerning the master data survey to a panelist from the Candidates menu. | |
Winner mail | Only in EFS Panel installations: This mail template is displayed when you have conducted a prize draw and wish to inform the winners afterward. | |
Promotional Mail | Only in EFS Panel installations: Panelists can use this mail template within the scope of a campaign to canvass new participants. |
Improving Security with the option “Activate security question”
The option “Activate security question” can be used to add another layer of security to the password recovery functionality for panelists. If this option is activated and panelists request password recovery mail, they will be asked to enter the answer to a previously set up security question. So this option can be useful for you if security is a big concern for you or your organization. |
---|
How to enable “Activate security question”
If you want to enable the “Activate security question” option and enhance your security, please follow the steps below:
Selecting the option
- Go to Website → Global configuration → Password security, and select Yes for Activate security question.
- If you want the panelist account to be temporarily disabled after too many failed attempts to enter the right answer to the security question, you can select Yes for the option Activate brute force protection. You can also set, for how long the account will be deactivated and how many failed attempts will be allowed.
Adding the variables
- Go to Website → Language version → Standard content → Forms, and select Registration form. Click on Add variable and select the variable u_sec_quest: Security question from the drop-down menu Variable. Next, enter “!matches(‘/^[12]$/’,request.u_sec_quest)” under Validation → Check expression and under Validation → Error message enter the error message you want to be displayed, if the panelist doesn’t enter a security question when registering, e.g. “Please enter a security question”. Click on Add variable.
- Repeat the steps under 3 for the variable u_sec_quest_answer: Security question answer. Enter “!matches(‘/^[12]$/’,request.u_sec_quest_answer)” under Validation → Check expression, and under Validation → Error message enter the appropriate error message, e.g. “Please enter an answer to the security question”.
- Go to Website → Language version → Standard content → Forms, and select the form Change account data. Add both variables – u_sec_quest: Security question and u_sec_quest_answer: Security question answer – following the steps detailed above.
Information: Please note that the variables u_sec_quest: Security question and u_sec_quest_answer: Security question answer have to be added in the forms Registration form and Change account data for ALL language versions on all panel websites, as the option can only be applied globally.
What panelists will see
What panelists will see after you have enabled the “Activate security question” option, depends on the according scenario:
Scenario 1: Panelists, who have not yet set up a security question
If you have enabled the Activate security question option and panelists have not yet set up a security question in their account, the security question will be skipped, and the recovery mail will be dispatched instantly. Those panelists will see a clickable message saying “No security question set. Click here to set it” in the profile box, until they have set a security question and answer. Once they click on this link, they will be redirected to the form Change Account Data, where they can set the question and answer up.
Scenario 2: Panelists, who newly register
After you have enabled the Activate security question option, the registration form will include the two fields Security question and Security question answer. Those fields are mandatory, so all newly registered panelists will have to enter a question and an answer.
FAQ
How do I set up a tester account?
To set up a tester account, go to People → Panelists administration, click Add panelist, fill in the form choosing “Tester” status, and confirm by clicking Create account.
What’s the easiest way to create a CSV file?
The easiest way to create a CSV file is using MS Excel. Create your table in Excel, then save it as a CSV file by selecting File → Save as and choosing the CSV format.
How does the “Activate security question” feature improve security?
The “Activate security question” feature adds an extra layer of security by requiring panelists to answer a pre-set security question when recovering their password, making it harder for unauthorized users to gain access to panelist accounts.