Skip to main content Skip to complementary content


MailChimp is an online marketing solution to manage contacts and subscribers, send them emails and track the results of the campaigns. With the Qlik MailChimp Connector you can get this data directly into your QlikView and Qlik Sense applications.

Tip note

The Qlik Web Connectors help you connect to different data sources and fetch data in the same way. Learn how to authenticate a data source connection and how to use tables to fetch data.

Connecting to data sources

Supported offerings

  • Qlik Sense Desktop
  • Qlik Sense Enterprise on Windows
  • QlikView

This connector must be installed separately.

Ways to access your data

The Qlik MailChimp Connector is able to extract a number of tables from MailChimp, centered around the lists and campaigns of your profile. The following tables are available:

Tables that can be loaded
Table Description
UserInfo Returns user profile info.
Lists Use this table to fetch the lists that are associated with your user account. The table returns the list IDs which are required for all other list tables.
List Returns members of a list and all of their associated details.
ListGrowthHistory Returns a month-by-month summary of a specific list’s growth activity.
ListSegments Retrieves information about all available segments for a specific list.
Campaigns Use this table to fetch a list of campaigns and their details associated with your user account. The table returns the list of campaign IDs which are required for all other Campaign tables.
CampaignReport Retrieves a specific campaign report.
CampaignClickReport Get information about clicks on specific links in your MailChimp campaigns.
CampaignTimeSeriesReport Get information about campaign time.
CampaignEmailActivityReport Get a list of member's subscriber activity in a specific campaign.
MemberInfo Use this table to fetch data about members of a list. You need the list ID to run this table.
Information noteThe results of these tables will be cached for six hours by Qlik Web Connectors. You can clear the cache either via the UI or via a load script request.


Obtain your MailChimp API key , which must be entered as a parameter for each of the tables. This can be found in your account under Extras.

To learn how to generate a MailChimp API key, see:



If you receive an error containing the text:

DOMException: Invalid Character Error with Campaigns Table


when running the Campaigns table, then this is an issue which MailChimp must help you resolve, as this error is being returned from their API. We recommend you contact MailChimp's support.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!