Announcing the Fivetran dbt Package for Mailchimp

The Fivetran dbt Package for Mailchimp enhances your Mailchimp data by adding reporting tables, allowing you to analyze more meaningful data with your preferred BI or visualization tool. This package offers powerful transformations within your data warehouse on Snowflake, Amazon Redshift, or Google BigQuery and can be reused for other target destinations. The resulting tables are easier to join with tables from other applications, providing a comprehensive view of your business. The transformations in this dbt package enrich Mailchimp's list, campaign, member, and segment tables with metrics from campaign and automation activities such as clicks, opens, and unsubscribes. It also creates an activities table that paints a complete picture of activities motivated by a campaign, including dimensions such as elapsed time between campaign launch and specific actions. Additionally, it ties email engagement actions to automations if you're using the Mailchimp automation feature.