)
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 Audience Locations into Excel helps map subscriber distribution worldwide. In this guide, you’ll connect Coefficient and import location data in minutes.
TLDR
-
Step 1:
Install Coefficient and authenticate Mailchimp in Excel.
-
Step 2:
Import “Audience Locations” via “Import from Objects.”
-
Step 3:
Optionally schedule auto-refresh for up-to-date maps.
Step 1: Installation and Connection
In Excel, click Insert › Get Add-ins › search “Coefficient” › Install. Open the sidebar and log in to Mailchimp.
Step 2: Import Audience Locations Data
Select “Import from Objects,” choose “Audience Locations,” then click “Import.” Your geographic data will load into the sheet.
Step 3: (Optional) Set Up Auto-Refresh
Click “Refresh” › “Schedule” in Coefficient. Select your frequency—Coefficient keeps location data fresh 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 Locations from Mailchimp?
Select “Import from Objects” › “Audience Locations” › “Import.” Coefficient pulls geographic data into Excel.
-
Can I filter by country?
Yes—add a filter on the “Country” field in the import dialog. Coefficient applies filters before import.
-
How to visualize locations on a map?
Use Excel’s 3D Maps feature on the imported data. Coefficient keeps the source live for dynamic updates.
-
How to automate importing locations weekly?
Go to “Refresh” › “Schedule,” choose weekly. Coefficient will refresh location data every week.
-
How to get alerts about new location data?
Create a Coefficient automation that emails you after each Audience Locations import.
Trusted By Over 50,000 Companies
