ConversationMessages
Returns messages from a specific conversation. 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 | = |
| ConversationId | = |
| Read | = |
| Timestamp | =, <, >, <=, >= |
SELECT * FROM ConversationMessages
SELECT * FROM ConversationMessages WHERE ConversationId = '1245' AND Id = '1254'
SELECT * FROM ConversationMessages WHERE Read = true
SELECT * FROM ConversationMessages WHERE Timestamp = '2024-02-07 00:00:37.0'
SELECT * FROM ConversationMessages WHERE Timestamp >= '2024-02-07 00:00:37.0'
SELECT * FROM ConversationMessages WHERE Timestamp <= '2024-02-07 00:00:37.0'
SELECT * FROM ConversationMessages WHERE Timestamp > '2024-02-07 00:00:37.0'
SELECT * FROM ConversationMessages WHERE Timestamp < '2024-02-07 00:00:37.0'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A string that uniquely identifies this message. | |
| ConversationId [KEY] | String | A string that uniquely identifies this message's conversation. | |
| ListId [KEY] | String |
Lists.Id | The unique identifier of the list this conversation is associated with. |
| 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 this message. | |
| Message | String | The plain-text content of the message. | |
| Read | Boolean | Indicates whether this message has been marked as read. | |
| Timestamp | Datetime | The date and time the message was either sent or received. |