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

The ConversationId, FromEmail, and Read are required for INSERTs.\

INSERT INTO ConversationMessages (ConversationId, FromEmail, and 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