How do I view survey responses?
After you send your email, contacts who complete the survey will have their responses stored in your selected and in Acoustic Campaign's database and optionally in Acoustic Campaign's Survey Connector relational table. The assumption is each survey question is mapped to an Acoustic Campaign database column/field.
Viewing Survey Connector responses in the database
View the responses from each database contact for each survey question.
- Go to Data > View database.
- Select the database used to store Survey Connector responses.
- In Database Summary, click the Search tab to show a list of all database contacts.
- Look for the relevant database columns that you mapped to your survey in Survey Connector. For each contact record, you can see the survey responses. Depending on the size of the database, you may need to scroll to see the database column.
Viewing survey responses in the Survey Connector relational table
In the SURVEY_CONNECTOR_RESPONSES relational table, you can view survey and response data. The system created the SURVEY_CONNECTOR_RESPONSES relational table only if the store all responses in the relational table? option was enabled during the mapping process.
- Go to Data > View Data.
- Select the database used to store Survey Connector responses.
- In Database Summary's Field tab, go to the Associated Relational Table section. You may need to scroll down to the bottom of the page to see it.
- Click to open the SURVEY_CONNECTOR_RESPONSES Relational Table Summary page. On this page, you can view the survey and response data for each contact.
SURVEY_CONNECTOR_RESPONSES relational table data
The SURVEY_CONNECTOR_RESPONSES Relational Table Summary includes system-generated fields, queries and contact sources associated with the relational table, and search functionality for survey contacts.
Fields: The Fields tab shows the following system generated fields that includes survey and response data:
- external_system_id: a number assigned to the system, the survey vendor, that survey responses came from.
- question_id: a unique identifier of a survey question. Retrieve the question id from the Survey Connector user interface (UI).
- question_text: the wording of a question on a survey.
- response_date: the date the respondent provided a response.
- response_id: a unique identifier of a survey response. This id is NOT available in the Survey Connector UI.
- response_text: the text representation of a response to a survey question. This may be from a free form response or single/multiple selections.
- survey_id: a unique identifier of a survey. The ID can be retrieved from the Survey Connector UI.
- survey_name: The user specified name/title of the survey.
- survey_recipient id: The Acoustic Campaign Contact Id/Recipient Id.
Contact Sources Associated: Click this tab to view the Acoustic Campaign database associated with this relational table.
Search: Search for survey and response for each database contact.
Queries: Click the Queries tab to see any Acoustic Campaign queries associated with this relational table.
Viewing survey responses in SurveyMonkey
- Log in to SurveyMonkey.
- In My Surveys, click a survey to open it.
- Click the Analyze Results tab.
- In the Respondents table, click Individual Responses.
- Use the left and right arrows to toggle between the respondent details.
Viewing survey responses in SurveyGizmo
- Log in to SurveyGizmo.
- In All Surveys, click a survey to open it.
- Click the Results tab.
- Under Reports & Exports, click Individual Responses.
- Click on one of the responses and use the newer and older buttons to toggle between the respondent details.