ReportingSurveyQuestionAnswers
List of answers for a survey question.
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 answer. |
| SurveyId [KEY] | String | The ID of the survey. |
| QuestionId [KEY] | String | The ID of the survey question. |
| ResponseId | String | The ID for the survey response. |
| SubmittedAt | Datetime | The date and time the answer was submitted. |
| Value | String | The answer value. |
| IsNewContact | Boolean | Whether the contact is new. |
| ContactAvatarUrl | String | The contact's avatar URL. |
| ContactConsentsToOneToOneMessaging | Boolean | Whether the contact consents to one-to-one messaging. |
| ContactContactId | String | The contact's ID. |
| ContactEmail | String | The contact's email address. |
| ContactEmailId | String | The contact's email ID. |
| ContactFullName | String | The contact's full name. |
| ContactPhone | String | The contact's phone number. |
| ContactStatus | String | The contact's status.
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 | Filter survey responses by familiarity of the respondents. Possible values: 'new', 'known', or 'unknown' |