Visualize MailChimp Data in Tableau

Ready to get started?

Download for a free trial:

Download Now

Learn more:

MailChimp ODBC Driver

The MailChimp ODBC Driver is a powerful tool that allows you to connect with live data from MailChimp, directly from any applications that support ODBC connectivity.

Access MailChimp data like you would a database - read, write, and update MailChimp Lists, Campaigns, Reports, etc. through a standard ODBC Driver interface.

The CData ODBC driver for MailChimp enables you integrate MailChimp data into Tableau dashboards.

The CData ODBC Driver for MailChimp enables you to access live MailChimp data in business intelligence tools like Tableau. In this article, you will integrate MailChimp data into a dashboard that reflects changes to MailChimp data in real time.

The CData ODBC drivers offer unmatched performance for interacting with live MailChimp data in Tableau due to optimized data processing built into the driver. When you issue complex SQL queries from Tableau to MailChimp, the driver pushes supported SQL operations, like filters and aggregations, directly to MailChimp and utilizes the embedded SQL engine to process unsupported operations (often SQL functions and JOIN operations) client-side. With built-in dynamic metadata querying, you can visualize and analyze MailChimp data using native Tableau data types.

Connect to MailChimp as an ODBC Data Source





Add MailChimp Data to a Dashboard

    Select the CData Data Source Name (for example: CData MailChimp Source).
  2. In the Database menu, select CData.
  8. Drag the Stats_AvgSubRate column in the Measures field onto the Detail and Color buttons. Tableau executes the following query:

    SELECT Name, SUM(Stats_AvgSubRate) FROM Lists GROUP BY Name


    To change the summary function, open the Stats_AvgSubRate menu and select the summary you want in the Measure command.


With the CData ODBC Driver for MailChimp, you get live connectivity to your MailChimp data, allowing you to build real-time charts, graphs, and more.