Mailchimp

Connecting Mailchimp

1. Open Connections from the account menu.
2. Click Connect next to Mailchimp.
3. Sign in to your Mailchimp account.
4. Select the audience (list) you want to track.
5. Click Enable to start syncing.

Available Data

Table	Key Columns
Campaign Reports	Send date, campaign title, subject line, emails sent, opens, unique opens, open rate, clicks, unique clicks, click rate, bounces, unsubscribes, revenue
Audience Stats	Date, list name, member count, total contacts, unsubscribes, cleaned contacts, open rate, click rate
Audience Growth	Month, subscribed, unsubscribed, cleaned, pending
Account Info	Account name, data centre, list ID, list name

Key Metrics

• Open Rate — Use proxy_excluded_open_rate for accuracy (Apple Mail Privacy inflates the standard open rate).
• Click Rate — Unique clicks / emails delivered.
• Audience growth data is monthly (one row per month).

Example Questions

• "What was the open rate on our last campaign?"
• "Show me emails sent per month as a bar chart"
• "Which campaign had the highest click rate?"
• "How has our audience grown over the last 12 months?"
• "Total unsubscribes this quarter"

Notes

• Mailchimp tokens don't expire — no need to reconnect.
• Open rate is available as both standard and proxy-excluded (recommended for accuracy).
• Audience growth is tracked monthly, not daily.