)
Written by
Table of Contents
“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”
Importing Mailchimp Audience Activity into Excel lets you track opens, clicks, and other behaviors in one place. Follow these steps to connect Coefficient and load Activity data.
TLDR
-
Step 1:
Install Coefficient in Excel and authenticate Mailchimp.
-
Step 2:
Import “Audience Activity” via “Import from Objects.”
-
Step 3:
Optionally schedule auto-refresh for continuous sync.
Step 1: Installation and Connection
In Excel, go to Insert › Get Add-ins › search “Coefficient” › Install. Open the Coefficient sidebar and sign in to Mailchimp.
Step 2: Import Audience Activity Data
Select “Import from Objects,” choose “Audience Activity,” then click “Import.” Engagement metrics will appear in the sheet.
Step 3: (Optional) Set Up Auto-Refresh
Click “Refresh” › “Schedule” in Coefficient, then pick your cadence. Coefficient updates your Activity data automatically.
Available Mailchimp Objects
- Audience
- Campaigns
- Audience Activity
- Audience Growth History
- Audience Locations
- Audience Segments
- List of Audiences
- Conversations
- Contact List
- Reports
- Audience Clients
- Audience Interest Categories
- Audience Webhooks
- Automations
- Connected Sites
Related Mailchimp Use Cases
How to Import Reports Data from Mailchimp into Google Sheets
Learn how to easily import live Mailchimp Reports data into Google Sheets using Coefficient for streamlined report analysis and reporting.
How to Import Contact List Data from Mailchimp into Google Sheets
Learn how to easily import live Mailchimp Contact List data into Google Sheets using Coefficient for streamlined contact list management and reporting.
How to Import Campaigns Data from Mailchimp into Google Sheets
Learn how to easily import live Mailchimp Campaigns data into Google Sheets using Coefficient for streamlined campaign analysis and reporting.
Frequently Asked Questions
-
How to get Audience Activity from Mailchimp?
Select “Import from Objects” › “Audience Activity” › “Import.” Coefficient pulls all engagement events into Excel.
-
How do I get a list of Audience Activity in
Trusted By Over 50,000 Companies
