SurveyResponses
Displays individual responses submitted for surveys distributed through Mailchimp.
Table Specific Information
SELECT is supported for SurveyResponses.
Select
The connector 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 connector.
- 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'. |