Conversations
Returns a collection of tracked conversations for this account. Conversation tracking is a feature available to paid accounts that allows viewing replies to campaigns from inside your Mailchimp account.
View-Specific Information
Select
The provider uses the Mailchimp API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the provider.
| Column | Supported Operators |
| Id | = |
| CampaignId | = |
| ListId | = |
| HasUnreadMessages | = |
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 | References | Description |
| Id [KEY] | String | A string that uniquely identifies this conversation. | |
| MessageCount | Integer | The total number of messages in this conversation. | |
| CampaignId [KEY] | String |
Campaigns.Id | 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 | The email address 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 | The email address 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 | Indicates whether this message has been marked as read. | |
| LastMessage_Timestamp | Datetime | The date and time the message was either sent or received. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| HasUnreadMessages | String | Filters results by unread message status. Only valid for SELECT statements. |