ReportEmailActivity
Returns a list of subscriber activity for members in a specific campaign.
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 |
| CampaignId | = |
SELECT * FROM ReportEmailActivity WHERE CampaignId = '45a'
Columns
| Name | Type | References | Description |
| CampaignId [KEY] | String |
Campaigns.Id | The unique Id for the campaign. |
| ListId [KEY] | String |
Lists.Id | The unique Id for the list. |
| EmailId [KEY] | String | The list-specific Id for the given email address. | |
| EmailAddress | String | The email address of the subscriber. | |
| Activity | String | An array of objects, each showing an interaction with the email. | |
| ListIsActive | Boolean | Indicates whether the list associated with this campaign is active. A value of false indicates the list is deleted or disabled. |