How to Import Connected Sites Data from Mailchimp into Excel

using Coefficient excel Add-in (500k+ users)

Learn how to import your Mailchimp Connected Sites into Excel using Coefficient for unified website tracking.

“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.”

5 star rating coeff g2 badge

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.

Coefficient sidebar menu with import, export, automations, and AI Sheet Assistant options.

Step 2: Import Connected Sites Data

Select “Import from Objects,” choose “Connected Sites,” then click “Import.” Your site integration records will populate the sheet.

Marketing integrations such as Google Ads, Facebook Ads, HubSpot, and Klaviyo listed.

Step 3: (Optional) Set Up Auto-Refresh

Click “Refresh” › “Schedule” in Coefficient. Choose a cadence—daily, hourly—to keep your connected sites data fresh.

Auto-refresh options for imported data with daily, hourly, and weekly scheduling.

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

Frequently Asked Questions

  • How to get Connected Sites from Mailchimp?

    down-chevron

    Select “Import from Objects” › “Connected Sites” › “Import.” Coefficient pulls your site integration records.

  • How do I get a list of Connected Sites in Mailchimp?

    down-chevron

    Use Coefficient › “Import from Objects” › “Connected Sites.” Click “Import” to fetch all sites.

  • How do I import Connected Sites from Excel to Mailchimp?

    down-chevron

    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?

    down-chevron

    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?

    down-chevron

    Create a Coefficient automation to email you when the import completes.

500,000+ happy users
Get Started Now
Connect any system to Google Sheets in just seconds.
Get Started

Trusted By Over 50,000 Companies