ReportingSurveyQuestions
Returns summary data and response statistics for survey questions.
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.
- Id supports the '=' operator.
- SurveyId supports the '=' operator.
SELECT * FROM SurveyQuestions; SELECT * FROM SurveyQuestions where Id='2' and SurveyId='1121';
Columns
| Name | Type | Description |
| Id [KEY] | String | The unique identifier assigned to the specific question within the survey, used to distinguish this question from others in reporting and analytics. |
| SurveyId [KEY] | String | The unique identifier of the survey that this question belongs to. This field links each question to its parent survey record. |
| Query | String | The text of the survey question as it appears to respondents (for example, 'How satisfied are you with our service?') |
| Type | String | The question format or response type, such as 'multiple choice', 'rating', 'text', or 'boolean'. It determines how responses are collected and stored. |
| Options | String | A list of predefined response options available for the question, typically represented in JSON or array format for multiple-choice questions. |
| HasOther | Boolean | If the value is 'true', the question includes an 'Other' option that allows respondents to provide a custom answer; if 'false', only predefined options are available. |
| OtherLabel | String | The label displayed for the 'Other' option when respondents are allowed to enter a custom response. |
| IsRequired | Boolean | If the value is 'true', the question must be answered before the respondent can submit the survey; if 'false', it is optional. |
| ContactCountsUnknown | Integer | The total number of responses received from contacts whose familiarity with the brand or sender is unknown. |
| ContactCountsKnown | Integer | The number of responses submitted by existing or previously identified contacts in the Mailchimp database. |
| ContactCountsNew | Integer | The number of responses from new contacts who were not previously part of the audience. |
| TotalResponses | Integer | The total number of responses collected for this question, including all respondents and answer types. |
| AverageRating | Decimal | The average rating value for this question, applicable only for rating-type questions such as satisfaction or likelihood scores. |
| MergeFieldId | Integer | The unique identifier of the merge field linked to this question, allowing integration of responses into audience data. |
| MergeFieldLabel | String | The display label associated with the merge field that maps to this survey question. |
| MergeFieldType | String | The data type of the merge field linked to this question, such as 'text', 'number', or 'date'.
The allowed values are text, number, address, phone, date, url, imageurl, radio, dropdown, birthday, zip. |
| PlaceholderLabel | String | The placeholder text displayed within the question field before the respondent enters an answer, often used to guide responses. |
| RangeHighLabel | String | The label shown at the high end of a range question, such as 'Very satisfied' or 'Excellent'. |
| RangeLowLabel | String | The label shown at the low end of a range question, such as 'Very dissatisfied' or 'Poor'. |
| SubscribeCheckboxEnabled | Boolean | If the value is 'true', a subscription checkbox is displayed to allow respondents to opt in to future communications when completing the survey. |
| SubscribeCheckboxLabel | String | The text label displayed next to the subscription checkbox, typically explaining what the respondent is subscribing to. |