# Mailchimp

Analyze email campaigns, audience growth, and engagement metrics

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

1. Create a new dataset in Scoop
2. Select **Mailchimp** from the application list
3. Enter your Mailchimp API key
4. Choose your analysis template or customize
5. Save and extract data

## Getting Your API Key

1. Log in to your Mailchimp account
2. Go to **Profile** > **Extras** > **API Keys**
3. Click **Create A Key**
4. 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