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 and INSERT are supported for ConversationMessages.
Select
A ConversationId is required to retrieve data from this table. If none is specified in the WHERE clause, the first one available for your account will be used.
Insert
ConversationId, FromEmail, and Read are required for INSERTs.
INSERT INTO ConversationMessages (ConversationId, FromEmail, Read) VALUES ('myConversationId', 'myFromEmail', 'true')
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | True |
A string that uniquely identifies this message |
| ConversationId [KEY] | String | True |
A string that identifies this message's conversation |
| ListId [KEY] | String | True |
The unique identifier of the list this conversation is associated with |
| FromLabel | String | True |
A label representing the sender of this message |
| FromEmail | String | False |
A label representing the email of the sender of this message |
| Subject | String | False |
The subject of this message |
| Message | String | False |
The plain-text content of the message |
| Read | Boolean | False |
Whether or not this message has been marked as read |
| Timestamp | Datetime | True |
Date the message was either sent or received |