Access MailChimp in Excel


  • Campaigns - Extract statistics about your Campaigns.
  • Clients - Extract the most popular email clients for subscribers in a specific list.
    • Filter by Status, Type and date intervals.
  • Lists - Extract statistics about your Lists.
    • Filter by date interval and sort results.
  • Locations - Get the locations that the list’s subscribers.
  • Members - Extract statistics about Members of a Campaign. Available Filters:
    • Subscription Status
    • VIP Only
  • Recent Activity - Extract recent daily, aggregated activity stats for your list. Max 180 day history.
  • Campaign Reports - Extract a summary report of your campaigns.
  • Domain Performance Reports - Extract a report of the performance of the domains you send emails to.
  • Search Members - Search your Lists for members based on a query.
  • Search Campaigns - Search your Lists for campaigns based on a query.


Add from Manager

The MailChimp Connector is available in the Connectors Manager in the top ribbon:

Head over to the Email Category and install MailChimp :

Get API keys

  1. Click your profile name and then click on Account.
  2. Choose API keys in the Extras drop-down menu.
  3. Click the "Create A Key button".
  4. Copy the Key and use it with SeoTools.


This connector suite is open-sourced on GitHub.


Official Documentation

Related Functions


Get help with this function in the community →