Access MailChimp in Excel

Data results output in Excel


Campaigns

  • List - Get all campaigns in an account. Available Filters:
    • Type (Regular, Plaintext, RSS etc)
    • Status (Saved, Paused, Scheduled etc)
    • Date Interval
  • Statistics - Get detailed campaign reports.
    • Filter by Type and Date intervals.
  • Domain Performance - Get statistics for the top-performing domains from a campaign.
  • Link Clicks - Get detailed information about links clicked in campaigns.
  • Abuse Complaints - Get a list of abuse complaints for a specific campaign.
  • Opens - Get detailed information about any campaign emails that were opened by a list member.
  • Top Locations - Get top open locations for a specific campaign.
  • Unsubscribes - Get information about list members who unsubscribed from a specific campaign.
  • Search - Search all campaigns for the specified query terms.

Lists

  • List - Get information about all lists in the account.
    • Filter by Date Interval
  • Members - Get information about members in a specific Mailchimp list.
    • Filter by Status, Opted-in interval and VIP status.
  • Recent Activity - Get up to the previous 180 days of daily detailed aggregated activity stats for a list
  • Clients - Get a list of the top email clients based on user-agent strings.
  • Locations - Get the locations (countries) that the list’s subscribers have been tagged to based on geocoding their IP address.
  • Abuse Complaints - Get all abuse reports for a specific list.
  • Growth History - Get a month-by-month summary of a specific list’s growth activity.
  • Segments - Get information about all available segments for a specific list.

Members

  • Search - Search for list members. This search can be restricted to a specific list, or can be used to search across all lists in an account. Available options:
    • Match Type (partial or exact)

Access

Add from Manager

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

Head over to the Email Category and install MailChimp :
Connector category in Manager window

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.

Contribute

This connector suite is open-sourced on GitHub.


See

Official Documentation

Related Functions

Resources


Get help with this function in the community →