Connect your data to Claude in 1 minute. No code needed Try it now

Connect Mailchimp to Qlik

Send Mailchimp campaigns, audience (list of contacts), audience activity and 7 more data types to Qlik on a schedule. Pick the audience, pick columns, filter by date and narrow it down by status. Refresh as often as every 15 minutes.

capterra
star star star star star

4.9/5

Mailchimp report Data source: Mailchimp
Build Qlik reports on Mailchimp data that Coupler.io keeps up to date.
Trusted by 200K+ users worldwide
Tradezella
Stanford
Webtoon
Getir
Stellar
Anker
ParentSquare
Bac 50
Benzinga
Matterport

How to connect Mailchimp and Qlik

6 steps. You can preview the Mailchimp data in Coupler.io before anything reaches Qlik.

Step 1 of 6

Connect Mailchimp

Sign in to Mailchimp and authorize Coupler.io. There's no API key to copy.

Sign in with Mailchimp

Step 2 of 6

Choose what to export

Pick the Mailchimp data you want in Qlik.

Show 2 more data types Show fewer data types
AudienceNot setSelect audience to import data for.

Step 3 of 6

Fine-tune the export

Optional settings for this Mailchimp export.

Created after dateAny dateSpecify the data entity creation date to export data added after this date (e.g. after 2020-01-01 09:00).
Created before dateAny dateSpecify the data entity creation date to export data added before this date (e.g. before 2020-01-01 09:00).
Sent since dateAny dateSpecify date to export data about campaigns sent after this date (e.g. after 2020-01-01 09:00).
Sent before dateAny dateSpecify date to export data about campaigns sent before this date (e.g. after 2020-01-01 09:00).
Show 2 more fields Show fewer fields
StatusNot set
Advanced filtersNot set

Step 4 of 6

Pick columns

Keep only the columns you need, so the report stays easy to work with.

ColumnsNot setSpecify the names of the columns and their order by entering each of them in a new line.

Step 5 of 6

Connect Qlik

Generate the integration URL and let the first run finish, then create a REST data connection in Qlik Sense and paste the URL.

Data set to shareCampaignsThe data view Qlik Sense reads
Integration URLhttps://app.coupler.io/export/w/123456.json?access_token=••••••••Paste into the URL field of the Qlik REST connection
MethodGETLeave as GET
NameCoupler_MailchimpFills in from the URL, rename to something readable

Step 6 of 6

Set a schedule

Qlik sees the data as of the last run. Run it as often as every 15 minutes.

Get the most of Mailchimp to Qlik integration

Gather data icon

Gather data

Export data from numerous apps and sources into a single destination. Blend data from different apps to get a single source of truth.
Understand data icon

Understand data

Preview, transform, sort, and filter data for better clarity in just a few clicks in the Coupler.io interface. Take your data analytics to the next level.
Automate data icon

Automate data

Access data that is always up to date by enabling the automatic data refresh on a schedule as often as every 15 minutes and using triggered automation.
Act on data icon

Act on data

Visualize your data by quickly connecting to data visualization and BI tools. Build insightful dashboards in a breeze and make better decisions.
Mailchimp to Qlik questions

10 data types, including Campaigns, Audience (list of contacts), Audience activity, Audience clients and Audience growth history.

You sign in to Mailchimp and authorize Coupler.io. There's no API key to copy.

Yes. Filter by created date or sent date to load the period you need.

Yes. Pick the columns you need, and only those reach Qlik.

Yes. Available filters include status. You can also add your own filter conditions.

With Qlik's built-in REST connector, pointed at the Coupler.io integration URL that serves the Mailchimp data as JSON.

Yes. Schedule the app reload to run after the Coupler.io refresh, so it picks up the latest Mailchimp data.

On a schedule you choose, from monthly down to every 15 minutes, depending on your Coupler.io plan.

Yes. Add more sources to the same data flow, for example GoHighLevel or Google Ads, and join or append them before the data reaches Qlik.

High five for scrolling till the very end!
See you in the app!