ReportEmailActivity
A list of member's subscriber activity in a specific campaign.
Table Specific Information
SELECT is supported for ReportEmailActivity.
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.
- CampaignId supports the '=' operator.
SELECT * FROM ReportEmailActivity where CampaignId = '45a'
Columns
| Name | Type | Description |
| CampaignId [KEY] | String | The unique id for the campaign. |
| ListId [KEY] | String | The unique id for the list. |
| EmailId [KEY] | String | The list-specific ID for the given email address. |
| EmailAddress | String | Email address for a subscriber |
| Activity | String | An array of objects, each showing an interaction with the email. |
| ListIsActive | Boolean | The status of the list used, namely if it's deleted or disabled. |