Marketing

Mailchimp campaign metrics into Google Sheets

Alex Black

Alex Black

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

Add data sources

Build reports & dashboards

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

Add data sources

Build reports & dashboards