ListMemberEvents
Contains event information related to individual list members, such as sign-ups or profile updates.
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.
- ListId supports the '=' operator.
- MemberId supports the '=' operator.
SELECT * FROM ListMemberEvents WHERE ListId = '121' and MemberId = '11'
Insert
Name column is required when INSERTing.
Columns
| Name | Type | ReadOnly | Description |
| Name | String | False |
The name of the event triggered by the subscriber, such as a purchase, signup, or interaction, used for behavioral segmentation and automation triggers. |
| OccurredAt | Datetime | False |
The exact date and time when the event occurred, formatted in ISO 8601, allowing precise tracking of subscriber engagement over time. |
| Properties | String | False |
A structured JSON object containing additional event details, such as product data, URLs, or metadata associated with the action. |
| ListId | String | False |
The unique identifier of the Mailchimp audience (list) associated with the subscriber and recorded event. |
| MemberId | String | False |
The MD5 hash of the lowercase version of the subscriber's email address, used as a secure, unique identifier to track events for that member. |