ListActivity
Displays up to 180 days of daily aggregated activity statistics for a given audience list, excluding automation events.
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 ListActivity WHERE ListId = 'abc'
Columns
| Name | Type | References | Description |
| ListId [KEY] | String |
Lists.Id | 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. |