Views

Views are similar to tables in the way that data is represented; however, views are read-only.

Queries can be executed against a view as if it were a normal table.

CData ODBC Driver for Mailchimp Views


Name	Description
McTemplates	Returns the Mailchimp Transactional templates created in the Mailchimp user interface, including draft and published content.
MessageContent	Returns the full content of a message, including sender, recipient, subject, and HTML or plain-text body.
Messages	Returns sent messages from the last two months, including delivery status, sender, recipient, and engagement details.
ScheduledEmails	Returns a list of scheduled emails, including sender, recipient, subject, and scheduled send time.
SenderDomains	Returns the sender domains that have been added to the account, including SPF, DKIM, and DMARC verification details.
Senders	Returns sending statistics for senders, including email metrics such as bounces, complaints, and clicks.
SenderTimeSeries	Returns the recent history of a sender as a series of hourly statistics over the last 30 days. Filter on Address to target a specific sender; when Address is omitted, the driver returns history for every sender in the UserSenders view.
Subaccounts	Returns the subaccounts for the account, including sending statistics and status. Filtering on Id retrieves detailed information for a single subaccount.
TemplateTimeSeries	Returns the recent history of a template as a series of hourly statistics over the last 30 days. Filter on Name to target a specific template; when Name is omitted, the driver returns history for every template in the Templates view.
UrlTrackingDomains	Returns the tracking domains configured for the account, including their CNAME verification status.
UserInfos	Returns account details and email sending statistics for the current user.
UserSenders	Returns the senders that have tried to use the account, both verified and unverified, including their sending statistics.