How Do You Connect Mailchimp to Qlik?

The Qlik connection in one table

What makes Qlik different

Qlik is the only destination in this cluster with a first-party connector. Qlik's own Mailchimp connector is first-party: it uses the Mailchimp API 3.0 to read your lists and campaigns, unlike Tableau and Postgres, which need a CSV import or a third-party driver. Tableau needs a CSV import or a paid ODBC driver, and Postgres needs a CSV load or an ETL pipeline — both go through something else. Qlik's connector talks to the Mailchimp API directly, so the tables it loads (CampaignReport, CampaignClickReport, Members) are API tables, not files. The trade for that directness is the cache: results sit for six hours, so a Qlik app is not a live view of Mailchimp, and a reload that hits Mailchimp's API rate limit fails until usage drops back under the limit.

The process, step by step

1. Get a Mailchimp API key. You need a Mailchimp API key. Users with Manager permissions can generate API keys, and users with Admin permissions can view them. Keep the key private: it authenticates the whole connection.
2. Create the connection in Qlik. Create a data source connection with Qlik's Mailchimp connector and authenticate it with your API key.
3. Load Campaigns first. Use the Campaigns table to fetch your campaigns and their campaign IDs. CampaignReport and the other campaign tables need a campaign ID, and this is where you get it.
4. Load the report tables you need. CampaignReport retrieves a specific campaign report. CampaignClickReport gives clicks on specific links, and CampaignTimeSeriesReport gives campaign time data. Select the fields you need under the data preview and insert the load script.
5. Load list tables the same way. Lists returns the list IDs that every other list table needs. Members, ListSegments, and ListGrowthHistory all take a list ID from that first run.
6. Plan around the cache and the rate limit. Results are cached for six hours by Qlik Web Connectors. You can clear the cache through the interface or with a load script request. If a reload reports that the API rate limit was reached, wait for usage to fall back under the limit before reloading.

The other Mailchimp destinations

• Export a Mailchimp campaign report — the CSV route, for a single report.
• Mailchimp export methods by destination — every destination in this cluster, side by side.

Other Mailchimp destinations

Other Mailchimp destinations: How to Export a Mailchimp Campaign Report and How to Export Mailchimp Automation Reports.

Source

Connector, tables, cache, and rate-limit facts on this page come from Qlik's own help: Qlik Cloud Help — Mailchimp connector (V2). Facts verified 2026-10-24.

This page explains how the process works and what the official documentation says. It is general information, not advice about your specific account or data — a live connector grants Qlik access to your Mailchimp account, so check its permissions before connecting it.