SurveyResponses
List of survey responses.
Table Specific Information
SELECT is supported for SurveyResponses.
Select
The component will use the Mailchimp API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the component.
- Id supports the '=' operator.
- SurveyId supports the '=' operator.
- AnsweredQuestion supports the '=' operator.
- ChoseAnswer supports the '=' operator.
- RespondentFamiliarityIs supports the '=' operator.
SELECT * FROM SurveyResponses WHERE SurveyId = '4548' and Id = '5995' SELECT * FROM SurveyResponses WHERE SurveyId = '4548' and AnsweredQuestion = '81215a' SELECT * FROM SurveyResponses WHERE SurveyId = '4548' and ChoseAnswer = '81215a' SELECT * FROM SurveyResponses WHERE SurveyId = '4548' and RespondentFamiliarityIs = 'new'
Columns
| Name | Type | Description |
| Id [KEY] | String | The ID for the survey response. |
| SubmittedAt | Datetime | The date and time when the survey response was submitted. |
| ContactEmailId | String | The MD5 hash of the lowercase version of the list member email address. |
| ContactId | String | The ID of this contact. |
| ContactStatus | String | The contact's current status. |
| ContactEmail | String | The contact's email address. |
| ContactFullName | String | The contact's full name. |
| ContactConsentsToOneToOneMessaging | Boolean | Indicates whether a contact consents to 1:1 messaging. |
| ContactAvatarUrl | String | URL for the contact's avatar or profile image. |
| IsNewContact | Boolean | If this contact was added to the Mailchimp audience via this survey. |
| SurveyId [KEY] | String | A string that uniquely identifies this survey. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| AnsweredQuestion | Integer | The ID of the question that was answered. |
| ChoseAnswer | String | The ID of the option chosen to filter responses on. |
| RespondentFamiliarityIs | String | Filter survey responses by familiarity of the respondents. Possible values: 'new', 'known', or 'unknown' |