Getting started
We're going to use the Mailchimp API to pull live campaign metrics into Google Sheets, using the SyncWith Google Sheets Addon. You can either install the addon now, or use the steps below to get a Google Sheet with the addon installed.
Step 1
We'll test out the MailChimp API using their Ping endpoint.
Before you can use the Mailchimp API, you need to find your Mailchimp Server.
To find the value for the server parameter log into your Mailchimp account and look at the URL in your browser. You’ll see something like https://us19.admin.mailchimp.com/; the
us19
part is the server prefix. Note that your specific value may be different.Test the Mailchimp API
Please fill in any necessary fields and click Run.
GET
Preview
View the API data, get a live Google Sheet dashboard
health_status |
---|
Get a live Google Sheet
Export your data to a google sheet, with the SyncWith Addon, or download to CSV
Automatically updated
Schedule your data to update hourly or daily
Add data sources
Import additional data from other apps
Build reports & dashboards
Easily build live reports within Google Sheets
Step 2
Now that you've identified your Mailchimp server, and confirmed your connection to their API is working, we can move onto pulling reports to get your campaign metrics.
Using the report endpoint you'll get back one row per campaign, with metrics for each campaign including number of messages sent, number of clicks, opens and more.
Mailchimp Campaign metrics
Please fill in any necessary fields and click Run.
GET
Preview
View the API data, get a live Google Sheet dashboard
id | campaign_title | type | list_id | list_is_active | list_name | subject_line | preview_text | emails_sent | abuse_reports | unsubscribed | send_time | bounces.hard_bounces | bounces.soft_bounces | bounces.syntax_errors | forwards.forwards_count | forwards.forwards_opens | opens.opens_total | opens.unique_opens | opens.open_rate | opens.last_open | clicks.clicks_total | clicks.unique_clicks | clicks.unique_subscriber_clicks | clicks.click_rate | clicks.last_click | facebook_likes.recipient_likes | facebook_likes.unique_likes | facebook_likes.facebook_likes | industry_stats.type | industry_stats.open_rate | industry_stats.click_rate | industry_stats.bounce_rate | industry_stats.unopen_rate | industry_stats.unsub_rate | industry_stats.abuse_rate | list_stats.sub_rate | list_stats.unsub_rate | list_stats.open_rate | list_stats.click_rate | delivery_status |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Get a live Google Sheet
Export your data to a google sheet, with the SyncWith Addon, or download to CSV
Automatically updated
Schedule your data to update hourly or daily
Add data sources
Import additional data from other apps
Build reports & dashboards
Easily build live reports within Google Sheets