ListMemberActivityFeeds
Shows a member's engagement activity on a specific list, including email opens, link clicks, and unsubscribes.
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.
- EmailId supports the '=' operator.
- ListId supports the '=' operator.
- ActivityType supports the '=, IN' operator.
SELECT * FROM ListMemberActivityFeeds;
SELECT * FROM ListMemberActivityFeeds where EmailId='2' amd ListId='565';
SELECT * FROM ListMemberActivityFeeds where ActivityType = 'open';
SELECT * FROM ListMemberActivityFeeds where ActivityType IN ('open','sent');
Columns
| Name | Type | Description |
| EmailId | String | The MD5 hash of the lowercase version of the subscriber's email address, used to securely identify the list member. |
| ListId | String | 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 | 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, such as 'hard' or 'soft', 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. |