Mailchimp manages your email audiences, campaigns, and the engagement they generate. Connecting it as a data source through the Connectors library syncs those tables into your Alta workspace, where they become training data for Alta and a foundation for your metrics, dashboards, and Luna analysis. Once it's flowing, you can measure list growth, open and click rates, and campaign performance — and ask Luna questions in plain English. Mailchimp connects with credentials (an API key).

Who this is for: Marketing teams who want Mailchimp email performance measured alongside the rest of their funnel in Alta.

Before you start

Get your Mailchimp API key (Account → Extras → API keys). The key encodes your data center (the suffix like -us21).
Connect a source only once per workspace. If Mailchimp already shows Connected, edit the existing connection.

Connect Mailchimp

Open Connectors from the sidebar.
Find Mailchimp via the category tabs or the Search data sources box.
Click the Mailchimp card to open the Create connector screen.
Fill in the connection fields shown (such as your API key), then click Create.
Alta runs a connect test. If it fails you'll see The connect test has failed with Mailchimp's error — fix the field and retry.
The card then shows Connected and Data is syncing until the first sync finishes.

Choose which tables sync

Open the connection. Mailchimp brings in campaigns, lists/audiences, members, and reports.
Use the Synced toggle in the Mailchimp tables section to control what's pulled in.
Turn off Show only synced tables to see everything available.

Key tables and fields synced

campaigns — id, type, status, send_time, emails_sent, subject_line
reports — per-campaign engagement: campaign_id, opens, unique_opens, clicks, bounces, unsubscribed
lists (audiences) — id, name, member_count, date_created
members — subscribers: email_address, status (subscribed/unsubscribed), list_id, timestamp_signup

What you can ask this data

Once it's syncing, build it into metrics and dashboards or just ask Luna / Ask AI. For example:

"What's our average open and click rate by campaign?" — uses reports joined to campaigns.
"How is our audience growing?" — trends members by timestamp_signup and status.
"Which campaigns drove the most clicks?" — ranks reports.clicks by campaign.
"What's our unsubscribe rate over time?" — trends reports.unsubscribed vs sends.

Build your first metric (worked example)

Confirm campaigns and reports show Last sync — Succeeded.
In Metrics, create a metric on reports measuring open rate (unique_opens ÷ emails_sent).
Use send_time from campaigns as the date field; group by campaign.
Save, add to a dashboard, then ask Luna "what's our average open rate by campaign?" to confirm.

Example use cases

Email performance dashboard. Open, click, bounce, and unsubscribe rates by campaign and over time.
Audience growth. Net subscriber growth and churn by list.
Subject-line testing. Compare engagement across subject_line variations.
Marketing + funnel. Combine with CRM data to connect email engagement to pipeline.

Keep it in sync

Sync status shows Last sync (Succeeded/Failed) and the Sync frequency.
Click Sync now to refresh immediately; it's disabled while a sync runs.
Use the overflow menu (⋯) to Disable, Enable, or Delete.

Tips and common pitfalls

Engagement lives in reports. Sync that table (not just campaigns) to measure opens and clicks.
The API key carries the data center. Copy the full key including the -usXX suffix.
Deleting is permanent. Disable instead to pause.