ListMemberActivity
The last 50 member events for a list.
Table Specific Information
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.
- 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. |