ListGrowthHistory
A month-by-month summary of a specific list's growth activity.
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.
- 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. |