ListMemberGoals
Displays goal-tracking events for list members, such as website visits or conversions recorded by Mailchimp.
View-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 | = |
| EmailId | = |
SELECT * FROM ListMemberGoals WHERE ListId = '121' AND EmailId = '11'
Columns
| Name | Type | References | 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. |