ListGrowthHistory
Shows month-by-month subscription growth trends for a specific audience list.
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 unique identifier of the Mailchimp audience (list) the growth metrics apply to, used for analyzing subscriber trends over time. |
| Month [KEY] | String | The month the growth activity data represents, typically formatted as YYYY-MM to summarize monthly changes in list size. |
| Subscribed | Integer | The total number of active subscribers on the list at the end of the specified month, including new signups and reactivated members. |
| Unsubscribed | Integer | The total number of members who unsubscribed from the list during the specified month. |
| Reconfirm | Integer | The number of subscribers who reconfirmed their opt-in status during the specified month, often due to double opt-in or General Data Protection Regulation (GDPR) compliance processes. |
| Cleaned | Integer | The number of addresses automatically cleaned from the list due to hard bounces or invalid email addresses during the specified month. |
| Pending | Integer | The number of pending subscribers who have not yet confirmed their opt-in at the end of the specified month. |
| Deleted | Integer | The number of subscribers who were manually deleted or removed by administrators during the specified month. |
| Transactional | Integer | The number of subscribers who were sent transactional emails (such as order confirmations or receipts) via Mandrill during the specified month. |