ListGrowthHistory
Shows month-by-month subscription growth trends for a specific audience list.
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 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. |