Conversations
A collection of this account's tracked conversations. Conversation tracking is a feature available to paid accounts that lets you view replies to your campaigns from inside your MailChimp account.
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.
- Id supports the '=' operator.
- CampaignId supports the '=' operator.
- ListId supports the '=' operator.
- HasUnreadMessages supports the '=' operator.
Select
SELECT * FROM Conversations WHERE Id = '1254' SELECT * FROM Conversations WHERE CampaignId = '1245' SELECT * FROM Conversations WHERE ListId = '1245' SELECT * FROM Conversations WHERE HasUnreadMessages = 'true'
Columns
| Name | Type | Description |
| Id [KEY] | String | A string that uniquely identifies this conversation |
| MessageCount | Integer | The total number of messages in this conversation |
| CampaignId [KEY] | String | The unique identifier of the campaign this conversation is associated with |
| ListId [KEY] | String | The unique identifier of the list this conversation is associated with |
| UnreadMessages | Integer | The number of unread messages in this conversation |
| FromLabel | String | A label representing the sender of this message |
| FromEmail | String | A label representing the email of the sender of this message |
| Subject | String | The subject of the message |
| LastMessage_FromLabel | String | A label representing the sender of this message |
| LastMessage_FromEmail | String | A label representing the email of the sender of this message |
| LastMessage_Subject | String | The subject of this message |
| LastMessage_Message | String | The plain-text content of the message |
| LastMessage_Read | Boolean | Whether or not this message has been marked as read |
| LastMessage_Timestamp | Datetime | Date the message was either sent or received |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| HasUnreadMessages | String | Filter on unread_messages, only valid for SELECT. |