ListActivity
Up to the previous 180 days of daily detailed aggregated activity stats for a given list. Does not include AutoResponder or Automation activity.
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 ListId for the table. |
| Day [KEY] | Date | The date for the activity summary. |
| EmailsSent | Integer | The total number of emails sent on the date for the activity summary. |
| UniqueOpens | Integer | The number of unique opens. |
| RecipientClicks | Integer | The number of clicks. |
| HardBounce | Integer | The number of hard bounces. |
| SoftBounce | Integer | The number of soft bounces |
| Subs | Integer | The number of subscribes. |
| Unsubs | Integer | The number of unsubscribes. |
| OtherAdds | Integer | The number of subscribers who may have been added outside of the double opt-in process such as imports or API activity. |
| OtherRemoves | Integer | The number of subscribers who may have been removed outside of unsubscribing or reporting an email as spam. For example, deleted subscribers. |