ReportingSurveyQuestionAnswers
Lists responses to individual survey questions for analysis.
Table Specific Information
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.
- 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.
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). |