ListMemberActivityFeeds
Get a member's activity on a specific list, including opens, clicks, and unsubscribes.
Table Specific Information
Select
The driver 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 driver.
- 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 EmailId for the table. |
| ListId | String | The ListId for the table. |
| ActivityType | String | The type of event activity. |
| CreatedAtTimestamp | Datetime | The created at timestamp in ISO8601. |
| CampaignId | String | The campaign's unique id. |
| CampaignTitle | String | The title of the campaign. |
| LinkClicked | String | The URL of the link that was clicked. |
| BounceType | String | The type of bounce.
The allowed values are hard, soft. |
| BounceHasOpenActivity | Boolean | Indicates if the email associated with this bounce also has open activity on the same campaign. |
| IsAdminUnsubscribed | Boolean | Indicates if an admin unsubscribed a contact. |
| UnsubscribeReason | String | Indicates the reason that the contact was unsubscribed. |
| ThreadId | String | The thread's unique id of the conversation referenced in this event. |
| MessageText | String | The body of the message in this conversation. |
| CreatedBy | String | The username of the person who created this event. |
| IsUser | Boolean | Indicates that the message created by a user (as opposed to a contact). |
| HasRead | Boolean | Indicates that the message has been read. |
| FromEmail | String | The email of the contact who sent the reply. |
| AvatarUrl | String | The gravatar URL of the contact who sent the reply. |
| UpdatedAtTimestamp | Datetime | The updated at timestamp in ISO8601. |
| NoteId | String | The note's unique id. |
| NoteText | String | The note's text. |
| MarketingPermissonText | String | The text describing this marketing permission. |
| UpdatedBy | String | The name of the contact who updated this permission. |
| MarketingPermissionOptedIn | Boolean | Indicates if the marketing permission is enabled or not. |
| OutreachId | String | The outreach's unique id. |
| OutreachType | String | The type of outreach that triggered the event. |
| OutreachTitle | String | The title of the outreach. |
| StoreName | String | The name of the store. |
| SignupCategory | String | How was this user added to the list. |
| OrderId | String | The unique order id. |
| OrderTotal | String | The order total formatted as a string. |
| OrderItems | String | An array of items that have been ordered. |
| OrderUrl | String | The order URL. |
| EventName | String | The name of the event. |
| EventProperties | String | An arbitrary datastore containing properties for the given event. |
| SurveyId | String | The survey's unique id. |
| SurveyTitle | String | The title of the survey. |