ListMemberGoals
Displays goal-tracking events for list members, such as website visits or conversions recorded by Mailchimp.
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.
- 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. |