SurveyResponses
Displays individual responses submitted for surveys distributed through Mailchimp.
Table Specific Information
SELECT is supported for SurveyResponses.
Select
The add-in 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 add-in.
- 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 unique identifier of the survey response. It is used to track individual submissions. |
| SubmittedAt | Datetime | The exact date and time when the survey response was submitted by the participant. |
| ContactEmailId | String | The MD5 hash of the lowercase version of the contact's email address. It is used as a unique and consistent identifier within Mailchimp. |
| ContactId | String | The unique identifier assigned to the contact in Mailchimp's database. |
| ContactStatus | String | The contact's current status in the Mailchimp audience, such as 'subscribed', 'unsubscribed', or 'cleaned'. |
| ContactEmail | String | The contact's email address associated with the survey response. |
| ContactFullName | String | The full name of the contact who submitted the survey response. |
| ContactConsentsToOneToOneMessaging | Boolean | Indicates whether the contact has given consent for one-to-one direct messaging through Mailchimp. |
| ContactAvatarUrl | String | The URL for the contact's avatar or profile image, if available. |
| IsNewContact | Boolean | Indicates whether the contact was newly added to the Mailchimp audience as a result of this survey submission. |
| SurveyId [KEY] | String | The unique identifier of the survey to which this response belongs. |
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 identifier of the question that was answered. It is used for filtering responses by specific questions. |
| ChoseAnswer | String | The identifier of the answer option chosen by the respondent. It is used for filtering and analysis of selected choices. |
| RespondentFamiliarityIs | String | A filter option used to categorize survey responses based on the respondent's familiarity. Possible values are 'new', 'known', or 'unknown'. |