Mailchimp connector
The Mailchimp connector imports email marketing data from your Mailchimp account into Mammoth as a dataset. Authenticate with OAuth—no API keys to manage.
Before you start
You need:
- A Mailchimp account with access to the audiences and campaigns you want to import
Step 1: Select the Mailchimp connector
- In Mammoth, go to Data Library and click + New Dataset
- Select Connectors
- Search for Mailchimp
- Click the Mailchimp tile
Step 2: Authenticate with Mailchimp
Click New Connection to start the OAuth flow.
Mammoth sends you to Mailchimp's authorization page in the same browser tab. Sign in with your Mailchimp account and click Allow to authorize Mammoth. You're redirected back to Mammoth automatically.
Step 3: Select Mailchimp data and query
Select the connection under Existing Connections to open the query builder. The List of tables panel shows the tables this connector exposes. Click a table to load a SELECT * query for it and its preview.
Write a custom Mailchimp query
Edit the SQL in the Enter SQL query editor and click Run. Use the table and column names shown in the table list and the preview.
See Understanding data preview & query for a full guide.
Step 4: Save the Mailchimp dataset
- Enter a dataset name in the Save table as field (e.g., "Mailchimp Subscribers")
- Check the Update Method (the default is Replace all data). To change it, click the edit icon, pick an option, and click Save changes:
- Replace all data—Replaces all existing data
- Add new data—Adds new data based on a unique sequential column
- Replace with new data—Replaces existing data with new data based on a unique sequential column For Add new data and Replace with new data, also choose a Key column—a numeric or date column with incrementing values, such as an ID or a date.
- Click Save as dataset. When the dataset is saved, click Done
Troubleshoot Mailchimp connections
No audiences visible
- Confirm the authorized Mailchimp account has access to the audience
Authorization fails
- Mammoth sends you to Mailchimp in the same browser tab and returns you to Mammoth afterwards. If you close the tab or deny access, start the connection again