Surveys
Get reports for surveys.
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.
SELECT * FROM Surveys WHERE Id = '1245'
Columns
| Name | Type | Description |
| Id [KEY] | String | A string that uniquely identifies this survey. |
| WebId | Integer | The ID used in the Mailchimp web application. |
| ListId | String | The ID of the list connected to this survey. |
| ListName | String | The name of the list connected to this survey. |
| Title | String | The title of the survey. |
| Url | String | The URL for the survey. |
| Status | String | The status of the Surney. Possible values: published or unpublished. |
| PublishedAt | Datetime | The date and time the survey was published. |
| CreatedAt | Datetime | The date and time the survey was created. |
| UpdatedAt | Datetime | The date and time the survey was last updated. |
| TotalResponses | Integer | The total number of responses to this survey. |