Skip to main content
Connect Mailchimp to AstroBee to analyze your email marketing performance, audience engagement, and campaign metrics. Get queryable access to campaigns, automations, subscribers, and activity data from your Mailchimp account.
Experimental feature: Mailchimp connector is currently in beta. We’re actively improving sync reliability and adding more features.

​
Prerequisites

  • A Mailchimp account with Manager, Admin, or Owner level access
  • Mailchimp account must have campaigns or audience data
To sync the UNSUBSCRIBE table, you must have Admin-level or Owner-level access.

​
Connecting Mailchimp

You can connect Mailchimp in two ways: from the Sources page if you’re already using AstroBee, or during the onboarding process if you’re a new user.
1

Choose Connect Sources

On the Import Data screen, click the Connect Sources card.
Onboarding screen with Connect Sources option
2

Select Mailchimp

Click Connect next to Mailchimp in the list of available connectors.
Available connectors including Mailchimp
3

Start connection

A “Configure Connector” modal appears showing “Mailchimp Not Connected”. Click the orange Connect button to begin setup.
Configure Mailchimp modal
4

Authorize with Fivetran

AstroBee uses Fivetran to securely connect to Mailchimp. Review the security information and click Continue.
Fivetran authorization screen
Fivetran ensures:
  • Secure: Data transfer is encrypted end-to-end and your credentials are never exposed
  • Private: Your data passes through without permanent storage
5

Authenticate with Mailchimp

On the Fivetran setup page, click Authorize to log in through OAuth. You’ll be redirected to Mailchimp to grant access.
Mailchimp authentication configuration
Follow the Fivetran Mailchimp setup guide for detailed instructions.
6

Configure sync settings

After authentication succeeds, you’ll see “Authentication Succeeded”:
Successful authentication with sync configuration
Click Save & Test to verify the connection.
7

Select tables to sync

Back in AstroBee, the “Configure Connector” modal shows your sync progress. Expand Sync Settings to select which tables to include.
Select Mailchimp tables in AstroBee
Tables marked “(always synced)” are required. Common tables include:
  • campaign: Email campaign details and settings
  • campaign_recipient: Campaign send recipients
  • campaign_recipient_activity: Opens, clicks, and engagement
  • automation: Automated email workflows
  • automation_email: Emails within automations
  • list: Audience lists and segments
  • member: Subscriber information
  • unsubscribe: Unsubscribed contacts (requires Admin access)
Click Save Table Selection, then Continue.
8

Data layer building

A modal appears showing “Your data layer is building”. AstroBee is unifying, deduplicating, and resolving entities across your data.
Data layer building modal
This may take 10 minutes to a couple of hours. Feel free to close this and come back later.
9

Data syncing

The Sources page shows your sync progress. Your data source is syncing and the data layer will be generated automatically once syncing completes.
Mailchimp syncing progress
It’s safe to close this window and continue working. You can connect other data sources while you wait.
10

Connection complete

Your Mailchimp connection now appears under MY SOURCES on the Sources page. You’ll see the sync status (e.g., “Backfilling history”) while historical data loads.
Mailchimp connection completed

​
What happens next

After connecting Mailchimp, AstroBee automatically generates a data layer from your synced tables. Once complete, you can start querying your email marketing data using natural language.
You can also edit your data layer to customize entities, add properties, or create relationships.

​
Syncing data

Mailchimp connections use manual sync - you control when data is refreshed. To sync your latest email marketing data:
  1. Navigate to the Sources page
  2. Find your Mailchimp connection
  3. Click the sync button
AstroBee will pull the latest campaigns, automations, subscribers, and engagement data from your Mailchimp account.

​
Understanding Mailchimp data

Mailchimp syncs multiple related tables:
  • Campaign data: Email campaigns, A/B tests, and send history
  • Automation data: Automated workflows and triggered emails
  • Audience data: Lists, segments, subscribers, and tags
  • Engagement data: Opens, clicks, bounces, and unsubscribes
  • E-commerce data: Carts, orders, and product activity (if connected)
The exact tables available depend on your Mailchimp plan and which features you use.

​
Troubleshooting

For additional help, see Fivetran’s Mailchimp troubleshooting guide.
Issue: Unable to authorize access to Mailchimp.Solution:
  • Ensure you have Manager, Admin, or Owner level access to your Mailchimp account
  • Verify you’re signed in to the correct Mailchimp account
  • Check that your Mailchimp account is active and not suspended
  • Try re-authorizing from the beginning
  • Clear browser cookies and try again
Issue: The UNSUBSCRIBE table is empty or not available.Solution:
  • The UNSUBSCRIBE table requires Admin-level or Owner-level access
  • Verify your Mailchimp account has the appropriate permission level
  • Manager-level users cannot sync unsubscribe data
  • Contact your Mailchimp account owner to upgrade your access if needed
Issue: Connection succeeds but no data appears in tables.Solution:
  • Verify your Mailchimp account has campaigns or audience data
  • Check that you have sent at least one campaign
  • Ensure you selected the correct tables during setup
  • Wait for the initial sync to complete (can take 10+ minutes for large accounts)
  • Trigger a manual sync to refresh data
Issue: Initial sync appears stuck or is taking longer than expected.Solution:
  • Large accounts with extensive campaign history can take 30+ minutes to sync
  • Check your internet connection
  • Avoid making changes to the connection during sync
  • Mailchimp API rate limits may slow down large syncs
  • If stuck for more than an hour, contact support at [email protected]
Issue: Some campaigns or subscribers don’t appear in synced data.Solution:
  • Verify the campaigns exist in your Mailchimp account
  • Check that campaigns have been sent (draft campaigns may not sync)
  • Ensure subscribers are in active lists (archived lists may not sync)
  • Trigger a new sync to pull the latest data
  • Review your Mailchimp account permissions
Issue: Opens, clicks, or other engagement metrics are missing.Solution:
  • Engagement data may have a delay of up to 24 hours
  • Verify campaigns have actually been opened or clicked
  • Check that engagement tracking is enabled in Mailchimp
  • Some engagement data requires Mailchimp’s tracking features to be active
  • Trigger a new sync after engagement has had time to accumulate
Issue: Status shows “Backfilling history” for many hours.Solution:
  • Historical backfills for Mailchimp can take 12+ hours for accounts with years of campaign data
  • This is normal behavior, not a stuck sync
  • You can safely close the browser and return later
  • The sync continues in the background and your data layer will generate automatically when complete
  • If backfill exceeds 72 hours with no progress, contact support at [email protected]
Issue: Sync completed but data layer shows an error or never finishes building.Solution:
  • Check that at least one table was selected during setup
  • Verify your synced tables contain actual data (not empty)
  • Try refreshing the page to see updated status
  • If the error persists, try disconnecting and reconnecting Mailchimp
  • Contact support at [email protected] with the error message if the issue continues

​
Next steps

Create a Data Layer

Transform your Mailchimp data into a queryable business model

Ask Questions

Start analyzing your email marketing performance with natural language