ListMemberActivityFeeds
Get a member's activity on a specific list, including opens, 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 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. |