ListMemberEvents
Contains event information related to individual list members, such as sign-ups or profile updates.
Table Specific Information
Select
The connector 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 connector.
- 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. |