ListGrowthHistory
A month-by-month summary of a specific list's growth activity.
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.
- ListId supports the '=' operator.
SELECT * FROM ListGrowthHistory WHERE ListId = 'abc'
Columns
| Name | Type | Description |
| ListId [KEY] | String | The list id for the growth activity report. |
| Month [KEY] | String | The month that the growth history is describing. |
| Subscribed | Integer | Total subscribed members on the list at the end of the month. |
| Unsubscribed | Integer | Newly unsubscribed members on the list for a specific month. |
| Reconfirm | Integer | Newly reconfirmed members on the list for a specific month. |
| Cleaned | Integer | Newly cleaned (hard-bounced) members on the list for a specific month. |
| Pending | Integer | Pending members on the list for a specific month. |
| Deleted | Integer | Newly deleted members on the list for a specific month. |
| Transactional | Integer | Subscribers that have been sent transactional emails via Mandrill. |