Connect Mailchimp to Scoop to analyze your email marketing performance, track audience growth, measure campaign engagement, and monitor automation effectiveness.

AI-Assisted Setup

When connecting Mailchimp to Scoop, choose "Guide me with AI" for an intelligent, guided setup experience.

Available Analysis Templates

Template	Object	Data Mode	Best For	What You'll Analyze
Campaign Performance (Default)	campaigns	Snapshot	Email effectiveness	Opens, clicks, engagement rates
Audience Growth	lists	Sync	Subscriber trends	List sizes, unsubscribes
Automation Analytics	automations	Sync	Sequence tracking	Automation volumes, status

Example Questions You Can Answer

Campaign Performance:

"What's our average open rate this month?"
"Which campaigns had the highest click rates?"
"How many emails did we send last week?"
"What's our campaign engagement trend over time?"
"Which subject lines perform best?"

Audience Health:

"How many total subscribers do we have?"
"What's our unsubscribe rate by list?"
"How is our list growing month over month?"
"Which audiences have the best engagement?"
"How many emails bounced (cleaned)?

Automation:

"How many automations are currently active?"
"Which automations send the most emails?"
"When was each automation started?"
"How has automation volume changed over time?"

Need Something Different?

If the templates above don't match your needs, select "Something else" and describe what you want to analyze. For example:

"I want to compare open rates across campaigns"
"I need to track unsubscribe trends"
"I want to analyze automation performance"

Scoop's AI will recommend the right configuration for your specific use case.

Snapshotting for Campaign Analysis

Campaign performance changes over time as recipients open and click emails. Configure your Campaigns extract as a Snapshot dataset to:

Track engagement growth after each send
Compare performance across send dates
Analyze how quickly engagement peaks
Monitor delayed opens and clicks

Pro Tip: Enable snapshotting for campaigns to see how engagement evolves over the first 48-72 hours after each send.

Connecting Mailchimp to Scoop

Create a new dataset in Scoop
Select Mailchimp from the application list
Enter your Mailchimp API key
Choose your analysis template or customize
Save and extract data

Getting Your API Key

Log in to your Mailchimp account
Go to Profile > Extras > API Keys
Click Create A Key
Copy the full API key (includes datacenter suffix like -us6)

Important: The API key includes your datacenter suffix (e.g., abcdef123456-us6). Include the entire key including the suffix - Scoop needs it to connect to the right server.

What Data You Get

Campaigns

Email campaigns with performance metrics.

Field	Description
Campaign ID	Unique identifier (prefixed with MC)
Type	regular, plaintext, absplit, rss, variate
Status	save, paused, schedule, sending, sent
Emails Sent	Number of emails delivered
Send Time	When the campaign was sent
Created Date	When the campaign was created
Subject Line	Email subject line
From Name	Sender name
Total Opens	Number of email opens
Total Clicks	Number of link clicks
Open Rate	Percentage who opened
Click Rate	Percentage who clicked

Audiences (Lists)

Subscriber lists and their health metrics.

Field	Description
List ID	Unique identifier (prefixed with MC)
List Name	Audience name
Member Count	Active subscribers
Unsubscribe Count	Total unsubscribes
Cleaned Count	Bounced/cleaned emails
Open Rate	Average open rate for list
Click Rate	Average click rate for list
Created Date	When list was created

Automations

Automated email sequences.

Field	Description
Automation ID	Unique identifier (prefixed with MC)
Status	save, paused, sending
Created Date	When automation was created
Start Time	When automation started
Emails Sent	Total emails sent
Target List ID	Audience ID
Automation Title	Name of the automation

Analysis Examples

Email Engagement Trends

Track your email performance:

Open and click rates over time
Best performing campaigns
Send volume trends
Engagement by campaign type

Audience Growth

Monitor your subscriber base:

List size changes over time
Unsubscribe and bounce rates
Engagement rates by audience
List comparison

Automation Performance

Understand your automations:

Active vs paused automations
Email volumes by automation
Automation start/creation patterns

Best Practices

Start with Campaigns: This is your core performance data
Enable Snapshotting: Track how engagement evolves after sends
Monitor Audiences: List health affects deliverability
Track Automations: Understand your automated engagement

Troubleshooting

Connection Issues

Verify your API key includes the datacenter suffix (e.g., -us6)
Check that the API key is active in your Mailchimp account
Ensure your Mailchimp account is in good standing

Missing Data

Campaign performance metrics require the campaign to be sent
Some metrics require specific Mailchimp plan features
Historical data may be limited by your plan

Datacenter

If you see connection errors:

Your datacenter is the suffix after the dash in your API key
Common datacenters: us1, us2, us6, us7, us12, etc.
Make sure you copied the entire API key including the suffix

Rate Limits

Mailchimp allows 10 concurrent connections:

Scoop automatically manages connection pooling
Large extracts may take longer during high usage
Contact support for persistent issues