ReportingSurveyQuestions
Returns reporting data for survey questions.
View-Specific Information
Select
The provider uses the Mailchimp API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the provider.
| Column | Supported Operators |
| Id | = |
| SurveyId | = |
SELECT * FROM SurveyQuestions
SELECT * FROM SurveyQuestions WHERE Id = '2' AND SurveyId = '1121'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The Id of the survey question. | |
| SurveyId [KEY] | String |
Surveys.Id | The Id of the survey. |
| Query | String | The question text. | |
| Type | String | The type of this question.
The allowed values are pickOne, pickMany, range, text, email. | |
| Options | String | The options for this question. | |
| HasOther | Boolean | Indicates whether this question has an 'other' option. | |
| OtherLabel | String | The label for the 'other' option. | |
| IsRequired | Boolean | Indicates whether this question is required. | |
| ContactCountsUnknown | Integer | The total number of unknown contacts who responded to this question. | |
| ContactCountsKnown | Integer | The number of known contacts who responded to this question. | |
| ContactCountsNew | Integer | The number of new contacts who responded to this question. | |
| TotalResponses | Integer | The total number of responses to this question. | |
| AverageRating | Decimal | The average rating for this question. | |
| MergeFieldId | Integer | The Id of the merge field. | |
| MergeFieldLabel | String | The label for the merge field. | |
| MergeFieldType | String | The type for the merge field.
The allowed values are text, number, address, phone, date, url, imageurl, radio, dropdown, birthday, zip. | |
| PlaceholderLabel | String | The placeholder label for this question. | |
| RangeHighLabel | String | The label for the high end of the range. | |
| RangeLowLabel | String | The label for the low end of the range. | |
| SubscribeCheckboxEnabled | Boolean | Indicates whether the subscribe checkbox is enabled. | |
| SubscribeCheckboxLabel | String | The label for the subscribe checkbox. |