[Mandrill, Mandrill, is a transactional email API for Mailchimp users., Features, Feature Name, Supported, Notes, Capture Deletes, Custom Data, Data Blocking, Column Hashing, Re-sync, check, Connector level, History, check, API Configurable, check, Priority-first sync, dbt Package, Setup guide, Follow our , step-by-step Mandrill setup guide, to connect Mandrill with your destination using Fivetran connectors., Sync overview, Fivetran uses , Webhooks, to sync the email events as they occur. We capture the following email events:, send, open, click, hard_bounce, soft_bounce, spam, unsub, reject, We cannot sync historical data since webhooks provides only real time events. This applies to all the Mandrill connectors created after May 20, 2020., Schema information, This schema applies to all Mandrill connections.n, To zoom, open ERD in new window, Sync limitations, Mandrill can take an extremely long time to process Fivetran requests, which causes our syncs to automatically re-schedule., We use the following workaround to sync data:, Fivetran submits a request to the Mandrill server. We wait 2 hours for the request to complete. , If Mandrill processes and completes the request within 2 hours, we sync the data., “If Mandrill doesnt process the request after 2 hours, we reschedule the sync by 30 minutes.”, After 30 minutes, using the previously submitted request ID, we try to fetch the request status from Mandrill. , We perform the following steps based on the request status:, If the request is completed, we sync the data., If the request is not completed, we again reschedule the sync by 30 minutes. We continue to reschedule the syncs until Mandrill processes and completes the request., n]