ListMemberActivityFeeds
Shows a member's engagement activity on a specific list, including email opens, link clicks, and unsubscribes.
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.
- 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, 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. |