MailChimp
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.
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.
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:
| 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. |
API Key
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:
Troubleshooting
DOMException
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.