ListActivity
Displays up to 180 days of daily aggregated activity statistics for a given audience list, excluding automation events.
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 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. |