The Mailchimp API offers a variety of campaign-specific reports. This tutorial will show you how to use the Campaign Open Details report. It is a two-step process: find the campaign ID on which to report, and then request the Campaign Open Details report.
Step 1: Find your campaign ID
We’ll use the List campaign reports endpoint to fetch your list of campaigns. Try it below.
List Mailchimp Campaigns
Please fill in any necessary fields and click Run.
GET
Preview
View the API data, get a live Google Sheet dashboard
id
campaign_title
list_name
subject_line
preview_text
emails_sent
abuse_reports
unsubscribed
send_time
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
Find the campaign for which you would like a detailed report, and make a note of its ID. The ID will look like a mixture of letters and numbers, for example, 8b0733bdaf
Step 2: Fetch the Campaign Open Details report
Using the campaign ID from the previous step, we’ll use the Campaign open details endpoint to get information about each recipient. Try it below.
Get Mailchimp Campaign Open Details Report
Please fill in any necessary fields and click Run.
GET
Preview
View the API data, get a live Google Sheet dashboard
campaign_id
list_id
contact_status
email_address
merge_fields
opens_count
opens.timestamp
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
💡
All of Mailchimp’s endpoints support pagination using offset pagination. Pagination is necessary if you want to retrieve more than 1000 records. You can configure pagination as follows:
Next steps
You may also want to explore Mailchimp’s other campaign report types: Click Reports, Domain Performance, Ecommerce Product Activity, Email Activity and Unsubscribes