Longitudinal survey analysis using Waves and Custom Tables
You can conduct longitudinal analysis of survey results using Waves and a Custom Table.
You’ll see
a group of columns for every survey question (a column per wave, e.g. baseline, midline, endline)
a row for every survey respondent
What are Waves?
Waves are a way of automatically labelling your survey responses based on the point in time that people responded to them. For example you could have three waves called
Baseline
Midline
Endline
What are Custom Tables?
Custom Tables display
a row for every contact who matches the criteria you set using Contact Filters
a column for the specific survey questions and CRM fields you want to see
Watch the walkthrough video
Step by step instructions
Requirements
You need to add at least one Wave to a Survey Campaign before you can proceed to the next step
Open the left Sidebar menu
Open the Impact section and select Custom Tables
You can now see your Custom Tables
If you’ve already set up a Custom Table to view survey results tagged to individual waves, press View to see results using that table
Click Create a new table
Open the Questions from Survey Waves section
Select the survey you want to analyse - for example, Adolescent Wellbeing Scale
Give your table a name and add one or more of the questions from the survey to the table
Press Save
You arrive on the Custom Tables page
Press View to open that Custom Table
Your table opens
Filter the rows of contacts to only display the contacts who have completed the survey