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 provider 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 provider.
- 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. |