Sync data from Mailchimp to your warehouse destination via RudderStack.
3 minute read
RudderStack’s Cloud Extract (ETL) product will be sunset on December 1, 2025. See this release note for more details.
Mailchimp is a popular email marketing automation platform used worldwide by thousands of businesses. Built specially for eCommerce and retail, Mailchimp allows you to build your audience and send them personalized campaign and marketing messages through web or mobile.
This document guides you in setting up Mailchimp as a source in RudderStack. Once configured, RudderStack automatically ingests your specified Mailchimp data, which can then be routed to your data warehouse destination supported by RudderStack.
Then, click the Directory option on the left navigation bar and go to Cloud Extract under Sources.
From the list of sources, click Mailchimp.
Assign a name to your source, and click Next.
Specifying Connection Credentials
Next, click the Connect with Mailchimp option:
If you’ve already configured Mailchimp as a source before, you can choose the account visible under the Use existing credentials tab.
Authorize RudderStack to access your Mailchimp account:
Configuring the Mailchimp Source
Select the Earliest campaign year and the Campaign fetch period in the settings. The details are as follows:
Earliest campaign year: The first import will fetch all campaign data since the start of the specified year.
Campaign fetch period: All the subsequent imports will fetch the campaign data up to this specified period.
Setting the Table Prefix, Run Frequency and Data Update Schedule
Next, you will be required to set the Table Prefix. RudderStack will create a table with this prefix name in your database and load all your Mailchimp data into it.
Also, set the Run Frequency to schedule the data import from your Mailchimp account to RudderStack. Optionally, you can also specify the time when you want this synchronization to start, by choosing the time under the Sync Starting At option.
Selecting the Data to Import
Finally, choose the Mailchimp data that you wish to ingest via RudderStack. You can either select all data, or choose specific Mailchimp attributes, as per your requirement.
That’s it! Mailchimp is now successfully configured as a source on your RudderStack dashboard.
RudderStack will start ingesting data from Mailchimp as per the specified frequency. You can further connect this source to your data warehouse by clicking on Connect Destinations or Add Destinations:
Use the Connect Destinations option if you have already configured a data warehouse destination in RudderStack. To configure a data warehouse destination from scratch, click the Add Destination button.
FAQ
Is it possible to have multiple Cloud Extract sources writing to the same schema?
Yes, it is.
We have implemented a feature wherein RudderStack associates a table prefix for every Cloud Extract source writing to a warehouse schema. This way, multiple Cloud Extract sources can write to the same schema with different table prefixes.
How does RudderStack count the events for Cloud Extract sources?
RudderStack counts the number of records returned by the source APIs when queried during each sync. It considers each record as an event.
How does RudderStack set the table name for the data sent via Cloud Extract sources?
RudderStack sets the table name for the resource you are syncing to the warehouse by adding rudder_ to the Table prefix you set while configuring your Cloud Extract source in the dashboard.
For example, if you set test_ as the Table prefix in the dashboard, RudderStack sets the table name as test_rudder_<resource_name>, where <resource_name> is the name of the resource you are syncing (for example, contacts, messages, etc.).
Note that RudderStack does not add the character _ to the prefix by default. Hence, you need to specify it while setting the prefix.
This site uses cookies to improve your experience while you navigate through the website. Out of
these
cookies, the cookies that are categorized as necessary are stored on your browser as they are as
essential
for the working of basic functionalities of the website. We also use third-party cookies that
help
us
analyze and understand how you use this website. These cookies will be stored in your browser
only
with
your
consent. You also have the option to opt-out of these cookies. But opting out of some of these
cookies
may
have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This
category only includes cookies that ensures basic functionalities and security
features of the website. These cookies do not store any personal information.
This site uses cookies to improve your experience. If you want to
learn more about cookies and why we use them, visit our cookie
policy. We'll assume you're ok with this, but you can opt-out if you wish Cookie Settings.