Release Noteslink
February 2021link
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 2020link
We have changed the data type of the location_longitude
and location_latitude
columns in the EVENT
table from DOUBLE to STRING.
May 2020link
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 2018link
You can now view the list of schemas and tables in your dashboard in read-only mode.
June 2018link
You can now filter your exported data by the specific API keys that you used to send messages.
May 2018link
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.