ReportingSurveyQuestions
Get reports about your survey questions.
Table Specific Information
Select
The component 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 component.
- 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. |