Track Mailchimp Email List Growth with Make.com
Automating your Mailchimp reporting with Make.com lets you track subscriber growth, spot trends, and share clean dashboards without manual exports. This guide walks you through building a visual analytics scenario that collects daily subscriber data and presents it in an interactive chart.
The approach below mirrors the official how-to from Mailchimp and Make.com, adapted into a streamlined, step-by-step process.
What You Will Build in Make.com
By the end of this tutorial, you will have a Make.com scenario that:
- Connects to your Mailchimp account and email lists.
- Fetches subscriber counts for each audience.
- Stores daily metrics in a data structure for historical tracking.
- Displays growth trends on an analytics dashboard.
- Lets you filter, compare, and customize charts.
You can then reuse or extend the scenario to track additional metrics like unsubscribes, campaign engagement, or list segment performance.
Prerequisites for Using Make.com
Before you start, make sure you have the following:
- An active Mailchimp account with at least one audience (list).
- A Make.com account with access to create scenarios.
- Basic familiarity with connecting apps and using modules in Make.com.
You do not need advanced coding skills. The scenario is built visually using modules and simple configuration fields.
Step 1: Create a New Scenario in Make.com
Start by creating the automation that will fetch Mailchimp data.
-
Log in to your Make.com account.
-
Click Create a new scenario from your dashboard.
-
In the app list, search for Mailchimp and select it as the first module.
-
Choose a trigger action that retrieves audience data, such as getting a list of subscribers or list statistics.
Once the first module is in place, you will connect it to Mailchimp.
Step 2: Connect Mailchimp to Make.com
Connecting Mailchimp is necessary so Make.com can safely pull your subscriber metrics.
-
In the Mailchimp module, click Add or Connect to create a new connection.
-
A pop-up window will open asking you to sign in to Mailchimp, if you are not already logged in.
-
Authorize access so Make.com can read your audiences and basic statistics.
-
Once connected, select the specific Mailchimp audience(s) you want to track.
After configuration, run the module once to test the connection and confirm that Mailchimp data is returned correctly.
Step 3: Normalize and Store Your Email List Data
To analyze subscriber growth over time, you need to capture daily snapshots instead of only current counts.
Within Make.com, you can do this by adding modules that store data in a structured format:
-
Add a data store or database module (depending on your plan and available tools).
-
Create a new data structure that includes fields like:
- Date (the day you captured metrics).
- Audience ID or name.
- Total subscribers.
- New subscribers (optional).
- Unsubscribes (optional).
-
Map the Mailchimp output fields to these data structure fields inside the Make.com module.
-
Save the record every time the scenario runs so you build a historical log.
This log will feed your charts and dashboards.
Step 4: Schedule the Make.com Scenario
To build accurate trend lines, you need consistent, automatic execution.
-
Click the Clock icon in the scenario editor to add a scheduler.
-
Set the schedule to run once per day at a fixed time (for example, midnight or early morning).
-
Connect the scheduler to the Mailchimp module so that each run triggers a new data collection.
-
Turn the scenario ON so Make.com will run it automatically.
Over time, your data store will accumulate daily points, enabling meaningful growth analysis.
Step 5: Build a Dashboard in Make.com
With structured data in place, the next step is to visualize it in a dashboard using Make.com tools or connected apps.
-
Add a module that reads from your data store or database with filters (for example: last 30 days, last 90 days, or a custom range).
-
Feed the selected data into a visualization layer such as charts, tables, or interactive widgets. Depending on your stack, this can be a Make.com internal dashboard feature or a connected BI app.
-
Configure chart types, such as:
- Line chart for total subscribers over time.
- Bar chart for new subscribers per day or per week.
- Stacked area chart to compare multiple Mailchimp audiences.
-
Label axes clearly, including units (subscribers, dates, time periods).
-
Save the dashboard and share it with your team as a link or embedded view.
This setup turns raw Mailchimp statistics into actionable insights.
Step 6: Add Filters and Comparisons in Make.com
To go beyond basic reporting, enhance your Make.com scenario with filters and comparisons.
- Audience filters: Compare lists by choosing which Mailchimp audience to display on your chart.
- Date filters: Allow users to view specific ranges such as last 7 days, last month, quarter, or custom dates.
- Growth rate calculations: Calculate percentage growth between periods directly inside Make.com using calculation modules.
- Segment analysis: If your Mailchimp plan supports segments, you can track metrics for specific tags or segments using additional modules and fields.
These enhancements help you understand which campaigns, segments, or channels are driving the fastest subscriber growth.
Step 7: Automate Alerts and Reports with Make.com
Finally, use your scenario to notify you about important changes in subscriber trends.
-
Add a router or filtering module in Make.com to detect conditions, such as a sudden drop in subscribers or an unusually high spike.
-
Send alerts via email, chat, or other apps when these thresholds are met.
-
Optionally, schedule regular summary reports (daily, weekly, monthly) that include:
- Total subscriber count.
- New subscribers for the period.
- Unsubscribes and churn rate.
- Top-performing lists or segments.
-
Deliver these reports automatically to your marketing or leadership team.
With alerts and summaries, you no longer need to manually check Mailchimp dashboards every day.
Best Practices for Mailchimp Analytics in Make.com
To keep your setup clean and reliable, follow these tips:
- Test first: Run your Make.com scenario with sample data before scheduling it.
- Use clear naming: Name modules, data fields, and dashboards so others can understand them instantly.
- Monitor errors: Check scenario run history inside Make.com and configure error handling or retries.
- Document your flow: Keep a short written overview of which lists are tracked, how often, and where data is stored.
If you need strategic help designing automations or analytics flows, you can review consulting options at Consultevo.
Next Steps
Using Make.com to track Mailchimp email list growth turns manual reporting into a fully automated, visual system. As your needs expand, you can extend this foundation to cover campaign performance, multi-channel attribution, or advanced segmentation metrics.
Start with the basic scenario, verify your data for a few days, then iterate by adding new metrics, filters, and alert conditions. Over time, your marketing team will gain a live view of subscriber growth and be able to react quickly to changes in audience behavior.
Need Help With Make.com?
If you want expert help building, automating, or scaling your Make scenarios, work with ConsultEvo — certified workflow and automation specialists.
