Presentation surveys
All community engagement surveys are hosted on JotForm.
Warning
Due to access restrictions, the associated spreadsheet integrations can not live in team drive. They are shared as needed with staff. These spreadsheets are:
Community Navigator Followup Surveys
CN Presentation Initial Survey Responses
Initial survey
We use a single survey for capturing initial feedback. This survey is named “CN Presentation Initial Survey” in JotForm.
This survey captures:
the presentation attended
the user’s knowledge before/after presentation
presentation information feedback
presenter rating
recommend or not (Net Promoter Score)
confidence level explaining rights
confidence level practicing rights
how presentation could be better
cell phone
presenter or navigator
When sent over SMS
we ask the user to text the presenter’s name. This is stored in the presenter field, which is not visible in the form.
When sent from a web-based/tablet presentation:
we provide a url at the end of the presentation. This includes a src=video that causes additional questions to be asked.
presenter will be set to video and not visible
zip code question will appear and be required
name or initials will appear and be required
name of navigator will appear and be required
cell phone or email must be required
Todo
The web-based/tablet fields need to be added.
When submitted
The submission date, presentation, and cell phone number will be automatically copied to a Google sheet on ILAO’s team drive. A follow up date field will show the date 4 weeks from the submission date. This date can then be used to send out follow-up surveys.
Note
If a user checks multiple presentations attended, we need to manually copy the row and separate the presentations.
We will need to copy and paste the follow up date field to new rows.
Followup surveys
We have a separate follow up survey for each presentation. These surveys are named “CN [presentation name] Follow-up Survey”
These surveys capture:
the user’s current knowledge of rights learned in presentation
did user recommend presentation - yes/no/why/why not
did user explain rights to anyone - yes/no/why/why not
used magic words learned in presentation - yes/no/why/why not
referred anyone to Illinois Legal Aid Online - yes/no/why/why not
any information missing from the presentation
Note
A hidden src (source) field is stored to track which presentation was watched [may not need this]
Setting up a new followup survey
To set up a new followup survey for new presentations:
Copy an existing followup survey
Update the survey with presentation-specific questions
Create a new short.io link for the survey:
Log into short.io
Create a new link with a url of go.illinoislegalaid.org/kyr-[source]
Update the followup survey spreadsheet (Community Navigator Followup Surveys) to include the source in the source sheet
Sending out followup surveys
We use Twilio’s REST-based API and Zapier to send the correct survey to the right people where we have an opt-ed in SMS number
To send followup surveys:
Check the intial survey response spreadsheet for any responses that are 4 weeks old and have cell phone numbers
Copy each cell phone number into the followup survey spreadsheet in the raw phone field, stripped of all characters except numbers
Add the source to the followup survey spreadsheet
Save the row
This will trigger Zapier within 10 minutes to send the phone number and source via API to Twilio to send the survey
Warning
There is a limit to the number of requests Zapier will handle at once. Add the data in batches no larger than 50 rows and wait about 30 minutes between batches.
How the SMS flow works
All surveys are contained in the A2J Survey Studio Flow.
Incoming texts
When an incoming text is received, it responds with a link to the short.io link go.illinoislegalaid.org/kyr that links to our survey. It passes the incoming text message as the presenter parameter.
Incoming API requests
When an incoming API request is received, it responds with a link to the short.io link go.illinoislegalaid.org/kyr-[source] where source is included in the API request and should represent the survey to send.
For example, source = ‘police’ should send the police encounter follow up survey.
Translations
At this time, the surveys are English only.
Todo
Add Spanish translations and update Twilio, Zapier to send correct language.