Release Notes
July 2024
We've removed the Template Labels filtering option from the connector configuration. This change applies to all new connectors created after June 20, 2024.
June 2024
We have made the following schema changes for Mandrill connector created on or after June 19, 2024:
Renamed the
timestampcolumn totimestampsin the following tables:EVENTMESSAGEMESSAGE_SMTP_EVENT
Renamed the
tagcolumn totagsin the following tables:MESSAGE_TAG
We have made the following changes to the Schema tab for Mandrill connectors created on or after June 19, 2024:
- All table names now appear in lowercase.
- We now display all tables in the schema, including the empty tables.
- We no longer support table-level selection or deselection for new Mandrill connectors.
February 2021
We have fixed a bug where the Mandrill server was sending email events data with an invalid TIMESTAMP value with extra digits appended to it. We now consider the first ten digits and discard the extra digits to get the actual TIMESTAMP value.
June 2020
We have changed the data type of the location_longitude and location_latitude columns in the EVENT table from DOUBLE to STRING.
May 2020
We now support webhooks, which allows us to capture information about email events ("send", "hard_bounce", "soft_bounce", "open", "click", "spam", "unsub", and "reject") as they occur.
For existing Mandrill connectors, we will continue to fetch data using the API in addition to using webhooks. For all new Mandrill connectors, we will only fetch email information using webhooks.
We have added the following new tables, which store information about emails and their related events:
| Table Name | Description |
|---|---|
MESSAGE | Contains the attribute values of an email (message). |
EVENT | Contains information about email events ("send", "hard_bounce", "soft_bounce", "open", "click", "spam", "unsub", and "reject") as they occur. |
MESSAGE_SMTP_EVENT | Contains the SMTP Response received for the message. |
MESSAGE_TAG | Contains tag names that were applied to the message. |
TEMPLATE | Contains the attribute values of an email template. |
TEMPLATE_LABEL | Contains the labels that are used in the email template. |
July 2018
You can now view the list of schemas and tables in your dashboard in read-only mode.
June 2018
You can now filter your exported data by the specific API keys that you used to send messages.
May 2018
We have replaced id with _fivetran_id as the only primary key column in the ACTIVITY and ACTIVITY_TAG tables.
Mandrill silently revises aggregate clicks and opens metrics in the API results, so we have implemented a 30-day rollback sync to accurately capture this data.