ReportEmailActivity
A list of member's subscriber activity in a specific campaign.
Table Specific Information
SELECT is supported for ReportEmailActivity.
Select
The component 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 component.
- 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. |