ReportingSurveyQuestions
Get reports about your survey questions.
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.
- 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 ID of the survey question. |
| SurveyId [KEY] | String | The ID of the survey. |
| Query | String | The question text. |
| Type | String | The type of this question. |
| Options | String | The options for this question. |
| HasOther | Boolean | Whether this question has an 'other' option. |
| OtherLabel | String | The label for the 'other' option. |
| IsRequired | Boolean | 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 for 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 | Whether the subscribe checkbox is enabled. |
| SubscribeCheckboxLabel | String | The label for the subscribe checkbox. |