ListMemberActivity
The last 50 member events for a list.
Table Specific Information
Select
The cmdlet 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 cmdlet.
- MemberId supports the '=' operator.
- ListId supports the '=' operator.
- Action supports the '=, IN' operator.
SELECT * FROM ListMemberActivity where ListId='121' and Action IN ('open', 'sent') and MemberId = '1211'
Columns
| Name | Type | Description |
| MemberId | String | The MemberId of the member to get events for. |
| EmailId | String | The EmailId for the table. |
| ListId | String | The ListId for the table. |
| 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 | The web-based ID for the campaign. |
| Title | String | If set, the campaign's title. |
| ParentCampaign | String | The ID of the parent campaign. |
| ContactId | String | The ID of the contact. |