Surveys
Lists surveys available in the account, including titles, questions, and response counts.
Table Specific Information
Select
The connector 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 connector.
- 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. |