How to Create a Panel Survey

Panel Surveys, also known as longitudinal data, is useful when you want to measure changes over time. You may create a Panel Survey in Essentials by inviting the same group of respondents by email to answer the same Quest several times.

This article will first demonstrate an example for how to create a panel survey, then how to report on panel data.

In order to create a panel survey in Essentials, three preconditions must be in place:

  1. You need to allow for multiple responses per respondent and invite the same respondents over time
  2. You need to add filterable time identifiers using respondent data (e.g. Week or Month)
  3. You need to ask the same questions over time
  4. You can enable multiple responses per respondent for a Quest in Settings and Response Options. This will allow the exact same respondents to answer multiple times.

How to Create a Panel Survey

  1. You will need to upload new, updated time identifier with each batch of respondents. This allow grouping responses from the same batch together, as well as separating distinct responses from the same respondents and separate responses from distinct time intervals.

First create an Excel sheet which include at least one time-identifier as respondent data:

First create an Excel sheet which include at least one time-identifier as respondent data

Second, you may upload the file in Distribution Add Invitees Upload File:

Second, you may upload the file in Distribution Add Invitees Upload File

For the same respondents to able to answer over time, it is vital to use the setting “Import all invitees and create duplicates if they exist (duplicates allowed)” when importing new batches:

Import all invitees and create duplicates if they exist (duplicates allowed)

  1. The last step is to add your Questions. To ensure consistency in the data it is best to keep the exact same questions and answer alternatives through the whole survey:

The last step is to add your Questions

Reporting on panel data

To measure the changes over time you will need to create value filters for all the answer alternatives for your time identifiers. This can either be done by uploading dummy respondents with all possible combinations, or by adding new filters after each time you upload respondents with new respondent data (i.e. new weeks or new months):

 

Reporting on panel data

Add the Question you want to analyse in your report for and use Add series and Add Cross Tabulation with the (relevant respondent data):

Add series and Add Cross Tabulation

If you want to analyze some weeks only, select only the corresponding alternatives:

If you want to analyze some weeks only, select only the corresponding alternatives

To increase readability of the results, consider taking the following these steps:

  1. Change the Question Text label to a description that includes information about the time dimension for the results (e.g. “… January” or “… 2019”)
  2. For Display Settings, useful options include:
    1. selecting the Chart Type “Column”
    2. selecting Show data as “Average”
    3. selecting a Sorting that present columns in consecutive order from the earliest date to latest date
    4. tick on Show Data Labels in Chart
    5. tick on Show Response Count in Chart
  3. Use a Color Scheme with gradients that highlight changes over time (e.g. “cold”)
  4. Insert the scale of the given Question in the additional information

Change the Question Text label to a description that includes information about the time dimension for the results

The above settings will result in a LiveReport graph like below:

The above settings will result in a LiveReport graph like below

It might also be useful to prepare a LiveReport that allow for future responses to show with time:

It might also be useful to prepare a LiveReport that allow for future responses to show with time

academy

About Academy

Did you find an answer to your question? Under documentation we have gathered informative descriptions that helps you understand Essential's functionality fully. Through insight work, you raise the level of knowledge in the entire organization