ConversationMessages
Messages from a specific conversation. 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 connector 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 connector.
- Id supports the '=' operator.
- ConversationId supports the '=' operator.
- Read supports the '=' operator.
- Timestamp supports the '=,<,>,<=,>=' operator.
Select
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 | Description |
| Id [KEY] | String | A string that uniquely identifies this message |
| ConversationId [KEY] | String | A string that identifies this message's conversation |
| ListId [KEY] | String | The unique identifier of the list this conversation is associated with |
| 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 this message |
| Message | String | The plain-text content of the message |
| Read | Boolean | Whether or not this message has been marked as read |
| Timestamp | Datetime | Date the message was either sent or received |