Marketing

How to use the Mailchimp Campaign Open Report

Colin Dellow

Colin Dellow

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

Add data sources

Build reports & dashboards

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

Add data sources

Build reports & dashboards

💡
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:
notion image

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