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