ListActivity
Displays up to 180 days of daily aggregated activity statistics for a given audience list, excluding automation events.
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 ListActivity WHERE ListId = 'abc'
Columns
| Name | Type | Description |
| ListId [KEY] | String | The unique identifier of the Mailchimp audience (list) associated with the activity summary, used to group engagement data by list. |
| Day [KEY] | Date | The specific date the activity metrics apply to, representing one day of engagement and delivery performance. |
| EmailsSent | Integer | The total number of campaign emails sent to subscribers on the specified date. |
| UniqueOpens | Integer | The number of distinct subscribers who opened at least one email on that day, excluding multiple opens by the same recipient. |
| RecipientClicks | Integer | The total number of recipients who clicked at least one link within a campaign email on that day. |
| HardBounce | Integer | The number of emails that permanently failed to deliver due to invalid addresses or other non-recoverable issues. |
| SoftBounce | Integer | The number of emails that temporarily failed to deliver, often caused by full inboxes or temporary mail server issues. |
| Subs | Integer | The total number of new subscribers who joined the list on that date through forms, campaigns, or API integrations. |
| Unsubs | Integer | The number of subscribers who opted out or unsubscribed from the list on that date. |
| OtherAdds | Integer | The number of subscribers added to the list through non-standard methods, such as manual imports or API-based additions, outside the typical signup flow. |
| OtherRemoves | Integer | The number of subscribers removed outside of unsubscribing or abuse reports, such as deletions or administrative removals. |