ListMemberEvents
Contains event information related to individual list members, such as sign-ups or profile updates.
Table-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 |
| ListId | = |
| MemberId | = |
SELECT * FROM ListMemberEvents WHERE ListId = '121' AND MemberId = '11'
Insert
The Name column is required for INSERT operations.
Columns
| Name | Type | ReadOnly | References | 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 |
Lists.Id |
The unique identifier of the Mailchimp audience (list) associated with the subscriber and recorded event. |
| MemberId | String | False |
ListMembers.Id |
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. |