Our Mailchimp connector enables simple API data extraction without writing a single line of code.
Automatic Data Synchronization
Our MailChimp connector gives you the ability to sync your data automatically in hourly, daily, weekly, or monthly increments.
All available endpoints from the MailChimp API are listed here: https://MailChimp.com/developer/reference/
Finding DC value
To find your DC when you are connecting your MailChimp account to Dataddo, log into your MailChimp account and look at the URL in your browser. You’ll see something like https://us19.admin.MailChimp.com/ — the us19 part is the DC you are looking for.
Creating a MailChimp Data Source
To create a MailChimp data source, navigate to Sources at the top left of the Dataddo app.
Then click on New Sources from the top right corner.
From the list of connectors, choose the MailChimp connector.
You will be redirected into the MailChimp connector where you can select the required Dataset.
If you are not sure which Dataset you need, but -for example- know which metrics and attributes you are looking for, you can use the Search for Dataset function on the left or you can browse through all the possible attributes and metrics for each Dataset by clicking on the right arrow.
Once you select a Dataset, you can start with the configuration by clicking on Next.
Missing metric or attribute?
Once you select a Dataset, Click on next. You will be requested to give Dataddo authorization to connect with your MailChimp account.
To find your DC when you are connecting your MailChimp account to Dataddo, log into your MailChimp account and look at the URL in your browser. You’ll see something like https://us10.admin.MailChimp.com/ — the us10 part is the DC you are looking for. After the authorization process, your MailChimp account will be automatically assigned.
Having a problem with the authorization process?
Next, you can name your data source, and select the required attributes.
To help you with the snapshot mapping, we make it easier for you to create a connection to the destination based on your preference.
- Click on the option "Dashboarding App" if you want your data to connect to applications, like Google Data Studio, Power BI, or Tableau.
- Click on the option "Data Warehouse", If you want your data to be sent to warehouse storage, like MySQL, Big Query, or PostgreSQL.
- If you are already experienced with the snapshotting setup, you can go ahead and process without selecting the two options.
Lastly, you configure your snapshotting preferences, choosing Snapshotting frequency, and Snapshotting retention. Click on "See Preview" to review all the selections made by you before finalizing and creating the Data Source.
Now you are all set and ready. Click on See Preview to review all the selections made by you before saving the Data Source using the buttons in the top right corner - either Save and Exit or Save & Create Flow. To create a flow, please follow our Creating a data flow guide.