Returns sent messages from the last two months, including delivery status, sender, recipient, and engagement details.

View-Specific Information

Select

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

Column	Supported Operators
DateFrom	=
DateTo	=
Sender	=
SearchByTags	=

For example, the following queries are processed server-side:

SELECT * FROM Messages WHERE DateFrom = '2026-06-01' AND DateTo = '2026-06-30'
SELECT * FROM Messages WHERE Sender = '[email protected]'
SELECT * FROM Messages WHERE SearchByTags = 'campaign-1'

Note: Use SearchByTags with the = operator to filter messages by tag. A single tag value is supported, and a message is returned when the supplied value is present as a subset of the message's tags. For example, the following returns every message whose Tags include "campaign-1":

SearchByTags = 'campaign-1'

Columns

Name	Type	Description
Id [KEY]	String	The unique identifier for the message.
Email	String	The email address of the message recipient.
Sender	String	The email address of the message sender.
Subject	String	The subject line of the message.
State	String	The delivery state of the message. The allowed values are sent, bounced, rejected.
Template	String	The name of the template used to generate the message.
SubAccount	String	The identifier of the subaccount used to send the message.
ElasticsearchIndex	String	The Elasticsearch index in which the message record is stored.
Version	String	The version of the message record.
DocumentId	String	The unique identifier of the message document.
Diag	String	The SMTP and HTTP diagnostic information returned for the message.
RejectReason	String	The reason the message was rejected, if applicable.
RejectLastEventAt	String	The date and time of the last event recorded for the rejected message.
Tags	String	The list of tags associated with the message.
BgtoolsCode	String	The internal code assigned to the message by background processing tools.
SMTPEvents	String	The list of SMTP events recorded for the message.
TimeStamp	Datetime	The date and time the message record was indexed.
Resends	String	The list of resend attempts associated with the message.
Ts	Long	The Unix timestamp indicating when the message was sent.
BounceDescription	String	The description of the bounce returned for the message, if applicable.
OpensDetail	String	The detailed list of open events recorded for the message.
ClicksDetail	String	The detailed list of click events recorded for the message.
Opens	Integer	The total number of times the message was opened.
Clicks	Integer	The total number of times links in the message were clicked.
Metadata	String	Any custom metadata provided when the message was sent.
Stats	String	Aggregate sending statistics for the message. Populated only when the query filters on a recipient email address.

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.

Name	Type	Description
SearchByTags	String	Filters messages by tag; returns messages whose tags include the specified value.
DateFrom	Date	The start date of the range used to filter messages. This value applies only to SELECT operations.
DateTo	Date	The end date of the range used to filter messages. This value applies only to SELECT operations.