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_id, campaign_title, subject_line, emails_sent, opens_total, unique_opens, open_rate, proxy_excluded_open_rate, clicks_total, unique_clicks, click_rate, hard_bounces, soft_bounces, unsubscribed, total_revenue
Audience Stats	stats_date, list_id, list_name, member_count, total_contacts, unsubscribe_count, cleaned_count, campaign_count, open_rate, click_rate
Audience Growth	month_date, list_id, subscribed, unsubscribed, cleaned, pending, deleted
Account Info	account_name, dc, list_id, list_name, last_synced_at

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.