ListMemberGoals
Displays goal-tracking events for list members, such as website visits or conversions recorded by 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 | The unique identifier for the goal event, used to track and reference specific subscriber actions or milestones. |
| ListId | String | The unique identifier of the Mailchimp audience (list) associated with the subscriber who triggered the goal event. |
| EmailId | String | The unique identifier of the email campaign or automation message that led to the goal event, allowing attribution of the action to a specific email. |
| GoalsId | String | The unique identifier of the goal that was achieved or triggered, such as completing a purchase, visiting a page, or signing up. |
| GoalsEvent | String | The type of goal-related activity recorded, such as 'visited', 'completed', or 'converted', defining how the subscriber interacted with the tracked objective. |
| GoalsLastVisitedAt | Datetime | The most recent date and time the subscriber performed the tracked action related to this goal, formatted in ISO 8601. |
| GoalsData | String | A JSON object containing additional contextual data about the event, such as page URLs, campaign details, or conversion metrics. |