)
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 your Mailchimp Connected Sites into Excel lets you track website integrations and visitor data in one place. In this guide, you’ll connect Coefficient and import site records.
TLDR
-
Step 1:
Install Coefficient in Excel and authenticate Mailchimp.
-
Step 2:
Import “Connected Sites” via “Import from Objects.”
-
Step 3:
Optionally schedule auto-refresh for live sync.
Step 1: Installation and Connection
In Excel, click Insert › Get Add-ins › search “Coefficient” › Install. Launch the sidebar and sign in to Mailchimp.
Step 2: Import Connected Sites Data
Select “Import from Objects,” choose “Connected Sites,” then click “Import.” Your site integration records will populate the sheet.
Step 3: (Optional) Set Up Auto-Refresh
Click “Refresh” › “Schedule” in Coefficient. Choose a cadence—daily, hourly—to keep your connected sites data fresh.
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 Connected Sites from Mailchimp?
Select “Import from Objects” › “Connected Sites” › “Import.” Coefficient pulls your site integration records.
-
How do I get a list of Connected Sites in Mailchimp?
Use Coefficient › “Import from Objects” › “Connected Sites.” Click “Import” to fetch all sites.
-
How do I import Connected Sites from Excel to Mailchimp?
Edit site records in Excel and use Coefficient’s “Export to Mailchimp” for two-way updates.
-
How to automate importing Mailchimp Connected Sites to Excel daily?
Go to “Refresh” › “Schedule,” choose daily. Coefficient will fetch new site data every day.
-
How to send email alerts about Connected Sites data from Mailchimp?
Create a Coefficient automation to email you when the import completes.
Trusted By Over 50,000 Companies
