ListMemberActivity
Returns the last 50 member events for a list.
View-Specific Information
Select
The provider uses the Mailchimp API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the provider.
| Column | Supported Operators |
| MemberId | = |
| ListId | = |
| Action | =, IN |
SELECT * FROM ListMemberActivity WHERE ListId = '121' AND Action IN ('open', 'sent') AND MemberId = '1211'
Columns
| Name | Type | References | Description |
| MemberId | String |
ListMembers.Id | The Id of the list member to retrieve activity for. |
| EmailId | String | The email Id of the list member. | |
| ListId | String |
Lists.Id | The Id of the list associated with the member activity. |
| Action | String | The type of action recorded for the subscriber. | |
| Timestamp | Datetime | The date and time recorded for the action. | |
| Url | String | For clicks, the URL the subscriber clicked on. | |
| Type | String | The type of campaign that was sent. | |
| CampaignId | String |
Campaigns.Id | The web-based Id for the campaign. |
| Title | String | The campaign's title, if set. | |
| ParentCampaign | String | The Id of the parent campaign. | |
| ContactId | String | The Id of the contact. |