ListGrowthHistory
Shows month-by-month subscription growth trends for a specific audience list.
View-Specific Information
Select
The provider uses 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 provider.
| Column | Supported Operators |
| ListId | = |
SELECT * FROM ListGrowthHistory WHERE ListId = 'abc'
Columns
| Name | Type | References | Description |
| ListId [KEY] | String |
Lists.Id | 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. |