Surveys
Lists surveys available in the account, including titles, questions, and response counts.
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 | The unique identifier of the survey, used to reference it across Mailchimp data and API operations. |
| WebId | Integer | The internal identifier of the survey within the Mailchimp web application interface. |
| ListId | String | The unique identifier of the mailing list connected to this survey, indicating which audience the survey targets. |
| ListName | String | The name of the mailing list associated with this survey, providing context about the audience segment surveyed. |
| Title | String | The title of the survey as displayed to respondents, summarizing its purpose or topic. |
| Url | String | The public or shareable URL where respondents can access the survey online. |
| Status | String | The current publication status of the survey. Possible values include 'published' for live surveys and 'unpublished' for drafts or archived ones. |
| PublishedAt | Datetime | The date and time when the survey was published and made available to respondents. |
| CreatedAt | Datetime | The date and time when the survey was initially created within Mailchimp. |
| UpdatedAt | Datetime | The date and time when the survey's configuration or content was last modified. |
| TotalResponses | Integer | The total number of responses collected for this survey, providing an overall measure of engagement. |