ListMemberActivityFeeds
Shows a member's engagement activity on a specific list, including email opens, link clicks, and unsubscribes.
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 |
| EmailId | = |
| ListId | = |
| ActivityType | =, IN |
SELECT * FROM ListMemberActivityFeeds
SELECT * FROM ListMemberActivityFeeds WHERE EmailId = '2' AND ListId = '565'
SELECT * FROM ListMemberActivityFeeds WHERE ActivityType = 'open'
SELECT * FROM ListMemberActivityFeeds WHERE ActivityType IN ('open', 'sent')
Columns
| Name | Type | References | Description |
| EmailId | String |
ListMembers.Id | The MD5 hash of the lowercase version of the subscriber's email address, used to securely identify the list member. |
| ListId | String |
Lists.Id | The unique identifier of the Mailchimp audience (list) associated with the recorded event activity. |
| ActivityType | String | The specific type of event activity performed by or related to the subscriber, such as an open, click, bounce, or unsubscribe. | |
| CreatedAtTimestamp | Datetime | The date and time when the event occurred, formatted in ISO 8601 for consistent tracking across campaigns. | |
| CampaignId | String |
Campaigns.Id | The unique identifier of the campaign associated with the recorded activity, used to link engagement data back to a specific send. |
| CampaignTitle | String | The title of the campaign where the event occurred, providing context for the associated campaign activity. | |
| LinkClicked | String | The URL that the subscriber clicked, recorded during link-click tracking events to measure engagement and link performance. | |
| BounceType | String | The classification of the email bounce, indicating the nature of the delivery issue.
The allowed values are hard, soft. | |
| BounceHasOpenActivity | Boolean | If the value is 'true', indicates that the bounced email also registered an open event for the same campaign. | |
| IsAdminUnsubscribed | Boolean | If the value is 'true', indicates that the subscriber was manually unsubscribed by an account administrator. | |
| UnsubscribeReason | String | The reason the contact was unsubscribed, such as user request, spam complaint, or manual removal. | |
| ThreadId | String | The unique identifier of the conversation thread associated with this event, if applicable. | |
| MessageText | String | The full text content of a message or reply within the conversation thread. | |
| CreatedBy | String | The username of the Mailchimp user who created or triggered the event, such as adding a note or responding to a conversation. | |
| IsUser | Boolean | If the value is 'true', indicates that the message or event was created by a Mailchimp user rather than a subscriber. | |
| HasRead | Boolean | If the value is 'true', indicates that the message has been opened and read by a user. | |
| FromEmail | String | The email address of the contact who sent the message or reply associated with this event. | |
| AvatarUrl | String | The Gravatar or profile image URL associated with the contact who sent the reply. | |
| UpdatedAtTimestamp | Datetime | The date and time when the event or related record was last updated, formatted in ISO 8601. | |
| NoteId | String | The unique identifier of a note associated with the contact or event. | |
| NoteText | String | The full text of the note attached to the contact or event for internal tracking or collaboration. | |
| MarketingPermissonText | String | The text describing the specific marketing permission granted by the subscriber, outlining the purpose of communication consent. | |
| UpdatedBy | String | The name or identifier of the user who last updated the marketing permission record. | |
| MarketingPermissionOptedIn | Boolean | If the value is 'true', indicates that the contact has opted in to receive marketing communications under the described permission. | |
| OutreachId | String | The unique identifier for the outreach action, such as a campaign, ad, or automation that triggered the event. | |
| OutreachType | String | The category or format of the outreach that caused the activity, such as 'email', 'ad', or 'survey'. | |
| OutreachTitle | String | The title of the outreach that generated the event, helping link the engagement data to a specific marketing initiative. | |
| StoreName | String | The name of the store associated with the contact or transaction, if the activity relates to an e-commerce event. | |
| SignupCategory | String | Indicates how the subscriber was added to the list, such as via a signup form, import, or API integration. | |
| OrderId | String | The unique identifier for the order associated with the event, linking marketing engagement to a specific purchase. | |
| OrderTotal | String | The total value of the order formatted as a string, used to measure revenue influenced by campaigns. | |
| OrderItems | String | A structured list of items purchased in the order, providing product-level details for e-commerce tracking. | |
| OrderUrl | String | The URL where the order can be viewed or managed within the connected e-commerce platform. | |
| EventName | String | The name of the recorded event, such as a form submission, link click, or purchase. | |
| EventProperties | String | A structured datastore containing additional details and properties related to the recorded event. | |
| SurveyId | String | The unique identifier of the survey associated with the event, if the activity relates to survey participation. | |
| SurveyTitle | String | The title of the survey that triggered the event, allowing correlation between feedback and campaign performance. |