How to use the Mailchimp Campaign Open Report

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.

Endpoint

GET

Authentication

count

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