ReportingSurveyQuestionAnswers
Lists responses to individual survey questions for analysis.
Table Specific Information
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.
- SurveyId supports the '=' operator.
- QuestionId supports the '=' operator.
SELECT * FROM ReportingSurveyQuestionAnswers; SELECT * FROM ReportingSurveyQuestionAnswers where SurveyId='07328' and QuestionId='123';
Columns
| Name | Type | Description |
| Id [KEY] | String | A unique identifier for the specific answer recorded in the survey results. Each answer is tied to one question within a single response. |
| SurveyId [KEY] | String | The unique identifier of the survey that the answer belongs to. This value links the response data to its parent survey record. |
| QuestionId [KEY] | String | The unique identifier of the specific question that this answer corresponds to within the survey. |
| ResponseId | String | The unique identifier for the full survey response submission that includes this answer. Multiple answers can belong to the same response. |
| SubmittedAt | Datetime | The exact date and time when the respondent submitted this answer to the survey. |
| Value | String | The value entered or selected by the respondent for this question. This can be a free-text answer, multiple-choice selection, or numeric rating, depending on the question type. |
| IsNewContact | Boolean | If the value is 'true', the answer was submitted by a newly added contact; if 'false', the respondent was an existing contact in the list. |
| ContactAvatarUrl | String | The URL of the contact's avatar image or profile picture, typically used to visually identify the respondent in reports. |
| ContactConsentsToOneToOneMessaging | Boolean | If the value is 'true', indicates that the respondent has explicitly consented to receive one-to-one messages or direct communications. |
| ContactContactId | String | The unique Mailchimp contact identifier associated with the respondent who submitted this survey answer. Unlike the email-based ID, this identifier can exist for non-email contacts as well. |
| ContactEmail | String | The email address of the respondent associated with this survey submission. Used to link the response to an existing or new subscriber. |
| ContactEmailId | String | The internal Mailchimp-generated identifier corresponding to the contact's email address. Useful for deduplication and cross-referencing within reports. |
| ContactFullName | String | The full name of the contact who provided the survey answer, if available from the respondent's profile or submission. |
| ContactPhone | String | The phone number associated with the contact who submitted the response, if provided in the contact record. |
| ContactStatus | String | The current subscription status of the contact who submitted the response. Common values include 'subscribed', 'unsubscribed', 'pending', or 'cleaned'.
The allowed values are Subscribed, Unsubscribed, Non-Subscribed, Cleaned, Archived. |
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 |
| RespondentFamiliarityIs | String | A filter used to segment survey responses based on how familiar respondents are with the brand or sender. Possible values are 'new' (first-time contacts), 'known' (existing contacts), or 'unknown' (no familiarity data available). |