Data Overview

Coupler.io gives you access to ten Mailchimp entities covering your contacts, audiences, campaigns, and automations. Here's a breakdown of what's available in each.

Entities at a glance

Entity	Grain	Key use
Audience (list of contacts)	One row per contact	Segmentation, suppression lists, CRM sync
Audience activity	One row per activity event	Contact-level engagement tracking
Audience clients	One row per email client	Deliverability and rendering insights
Audience growth history	One row per month	Subscriber trend reporting
Audience interest categories	One row per interest group	Audience segmentation analysis
Audience locations	One row per location	Geographic reporting
Automations	One row per automation	Automation inventory and status
List of audiences	One row per audience	Multi-audience account overview
Campaigns	One row per campaign	Campaign metadata and status
Campaigns report	One row per campaign	Aggregated performance metrics

Campaigns report

Performance metrics

Field	Description
emails_sent	Total number of emails sent
open_rate	Percentage of recipients who opened
click_rate	Percentage of recipients who clicked
unique_opens	Unique open count
unique_clicks	Unique click count
bounce_rate	Percentage of emails that bounced
unsubscribe_rate	Unsubscribes as a share of emails sent
soft_bounces	Soft bounce count
hard_bounces	Hard bounce count
abuse_reports	Spam complaint count

Campaign metadata

Field	Description
campaign_id	Unique campaign identifier
campaign_title	Internal campaign name
subject_line	Email subject line
send_time	Date and time the campaign was sent
type	Campaign type (regular, automated, etc.)
status	Campaign status (sent, draft, etc.)
list_id	ID of the audience it was sent to

Audience (list of contacts)

Contact fields

Field	Description
email_address	Contact's email address
status	Subscription status (subscribed, unsubscribed, cleaned, pending)
first_name	First name
last_name	Last name
tags	Tags applied to the contact
member_rating	Mailchimp's engagement score (1–5)
timestamp_opt	Date the contact opted in
ip_opt	IP address at opt-in
language	Preferred language
vip	Whether the contact is flagged as VIP
email_client	Email client used

Audience growth history

Growth fields

Field	Description
month	Calendar month
existing	Existing subscriber count
imports	Contacts added via import
optins	Organic opt-ins
unsubscribes	Unsubscribe count for the month
cleaned	Emails cleaned (hard bounces)

Automations

Field	Description
id	Automation ID
create_time	Date created
status	Active, paused, or draft
emails_sent	Total sends across the automation
start_time	When the automation started running
recipients.list_id	Audience the automation targets

Common metric combinations

• Campaign performance dashboard — Campaigns report + Audience growth history, joined on list_id, shows how list health correlates with campaign results

• Contact engagement analysis — Audience (list of contacts) + Audience activity, joined on email_address, reveals which subscribers are most active

• Multi-audience rollup — Append the Audience growth history from multiple audiences to compare list growth across segments

• Automation health check — Automations + Campaigns report, filtered by automation type, to measure automated email performance

Use cases by role

Email Marketers

• Pull Campaigns report into Google Sheets or Looker Studio to build a live campaign performance dashboard

• Track open and click rates over time to identify which subject lines and send times perform best

• Use Audience growth history to visualize subscriber trends and report on list health month over month

• Send Campaigns report data to ChatGPT or Claude to generate natural-language summaries of campaign performance

Marketing Analysts

Marketing Ops

Platform-specific notes

• Audience-level entities (contacts, activity, clients, growth, interest categories, locations) require you to select a specific audience — they do not pull across all audiences at once. Use an Append transformation to combine data from multiple audiences.

• The Campaigns report entity uses sent date filters (sentSinceDate / sentBeforeDate). The Campaigns entity uses creation date filters instead.

• Mailchimp's API rate limits can cause timeouts for very large audiences (100k+ contacts). If this happens, consider filtering by status or using advanced filters to reduce the dataset size.

• Customer Journey data is not currently available as a Coupler.io entity — this is a known feature request.

• The member_rating field in Audience contacts is Mailchimp's built-in engagement score and is updated by Mailchimp, not Coupler.io.