ListMemberGoals
List goal events for a list member in Mailchimp.
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.
- EmailId supports the '=' operator.
SELECT * FROM ListMemberGoals WHERE ListId = '121' and EmailId = '11'
Columns
| Name | Type | Description |
| Id [KEY] | String | A unique identifier for the goal event. |
| ListId | String | The unique ID for the list. |
| EmailId | String | The unique id for the email that triggered the goal event. |
| GoalsId | String | The unique id for the goal that was triggered. |
| GoalsEvent | String | The type of goal event. |
| GoalsLastVisitedAt | Datetime | The date and time of the last visit for this event. |
| GoalsData | String | Any extra data associated with the event. |