MailChimp

MailChimp is an all-in-one marketing platform that enables businesses to manage email marketing campaigns, design and send emails, and track their performance. It also offers additional features such as audience segmentation, automation, and reporting to help businesses build and maintain effective marketing strategies and engage with their audience more effectively.

Refer to our website for the list of metrics and attributes available in Dataddo.

Refer to Mailchimp's official documentation to see all available endpoints from the Mailchimp API.

Authorize Connection to MailChimp

In MailChimp

To authorize your MailChimp account, you will need your username, an API key (= API token), and your DC (data center for your account).

In your MailChimp account, navigate to the API keys page.
Click on Create API Key and name your key.
Click on Generate Key and copy the value.
In the first part of your MailChimp URL, you can find your DC, e.g. us1 is the DC in this URLhttps://us1.admin.mailchimp.com/account/api/manage.

In Dataddo

On the Authorizers page, click on Authorize New Service and select MailChimp.
Fill in the following fields:
1. Username: Your MailChimp username.
2. API Key: MailChimp API key.
3. DC: Data center for your account (e.g. us1 from https://us1.admin.mailchimp.com/account/api/manage).
Rename your authorizer for easier identification and click on Save.

How to Create a Mailchimp Data Source

On the Sources page, click on the Create Source button.
Select the connector from the list and name your data source.
On the Dataset step, select your dataset.

DATADDO TIP

If you're unsure which dataset to select, use the search bar to look for datasets with the desired attributes or metrics.
On the Account step select your authorizer from the drop-down menu.

Didn't find your authorizer?

Click on Add new Account at the bottom of the drop-down and follow the on-screen prompts. You can also go to the Authorizers tab and click on Add New Service.
On the Attributes and Metrics step, select the metrics and attributes you want to extract.
On the Metadata step, select which metadata fields such as extraction time to add to your data.
On the Snapshot step:
1. Configure your sync frequency or click Show advanced settings to set the exact synchronization time.
  
  DATADDO TIP
  
  To load historical data, refer to the Data Backfilling article.
2. [Optional] Enable the Allow Empty Data Extractions toggle to allow the extraction when no data is available.
In the top-right corner, click Test Data button to preview extracted data. Adjust the date range for specific time frame.
Click on Save and congratulations, your new data source is ready!

Troubleshooting

Data Preview Unavailable

No data preview when you click on Test Data might be caused by an issue with your source configuration. The most common causes are:

Date range: Try a smaller date range. You can load the rest of your data afterward via manual data load.
Insufficient permissions: Please make sure your authorized account has at least admin-level permissions.

Authorization Error

When authorizing your service and creating your source, make sure that you the DC (data center) field matches the on in your MailChimp, otherwise you might get the following error INTERNAL_SERVER_ERROR.

You can find the DC in the first part of your MailChimp URL. E.g. If your URL is https://us1.admin.mailchimp.com/account/api/manage, then us1 is the name of your DC.

Now that you have successfully created a data source, see how you can connect your data to a dashboarding app or a data storage.

Sending Data to Dashboarding Apps

Sending Data to Data Storages

Other Resources