Mailchimp
This page describes how to configure a Mailchimp data source. With Data Loader, you can replicate and load your source data into your target destination.
Schema Drift Support: No.
Return to any page of this wizard by clicking Previous.
Click X in the upper-right of the UI and then click Yes, discard to close the pipeline creation wizard.
Prerequisites
- Read the Allowed IP addresses topic before you begin. You may not be able to connect to certain data sources without first allowing the Batch IP addresses. In these circumstances, connection tests will always fail and you will not be able to complete the pipeline.
Create pipeline
- In Data Loader, click Add pipeline.
- Choose Mailchimp from the grid of data sources.
- Choose Batch Loading.
Connect to Mailchimp
Configure the Mailchimp database connection settings, specifying the following:
| Property | Description |
|---|---|
| API Key | A managed entry representing your Mailchimp API Key. Choose an existing entry from the dropdown menu or click Manage and then click Add new credential to configure a new managed API Key entry. Give the entry a label, which is what you can see in the dropdown menu for this parameter, and then input the value of the API Key. Read Manage Passwords to learn more. |
| Store ID | The ID of the Mailchimp e-commerce store. |
| Campaign ID | The ID of the Mailchimp campaign. |
| List ID | The ID of the Mailchimp subscriber list. |
| Advanced settings | Additional JDBC parameters or connection settings. Click Advanced settings and then choose a parameter from the dropdown menu and enter a value for the parameter. Click Add parameter for each extra parameter you want to add. For a list of compatible connection properties, read Allowed connection properties. |
Click Test and Continue to test your settings and move forward. You can't continue if the test fails for any reason.
Choose tables
Choose any tables you wish to include in the pipeline. Use the arrow buttons to move tables to the Tables to extract and load listbox and then reorder any tables with click-and-drag. Additionally, select multiple tables using the SHIFT key.
- If the table contains:
UpdatedAt,LastChanged,Timestamp, orTimeAdded, a standard incremental load is performed. - If the table contains:
DateorDay, records are deleted for the current max date (to get rid of partial records) then a standard incremental load is performed.
Click Continue with X tables to move forward.
Table filters
The tables listed below can be filtered using one or more of the following parameters:
Campaign IDList IDStore ID
Selecting one or more of the listed tables will require you to provide values for the respective parameters. Where applicable, the following rules apply:
If no Campaign ID is specified, data is returned for the first campaign in the customer's Mailchimp account. Available Campaign IDs can be found by querying the table Campaigns.
If no List ID is specified, data is returned for the first list in the customer's Mailchimp account. Available List IDs can be found by querying the table Lists.
If no Store ID is specified, no data is returned. Available Store IDs can be found by querying the table EcommerceStores.
| Table | Campaign ID | List ID | Store ID |
|---|---|---|---|
| CampaignFeedback | Yes | No | No |
| EcommerceCarts | Yes | No | Yes |
| EcommerceCustomers | No | No | Yes |
| EcommerceOrders | Yes | No | Yes |
| EcommerceProducts | No | No | Yes |
| ListAbuse | Yes | Yes | No |
| ListGrowthHistory | No | Yes | No |
| ListInterestCategories | No | Yes | No |
| ListInterests | No | Yes | No |
| ListMemberActivity | Yes | Yes | No |
| ListMemberNotes | No | Yes | No |
| ListMembers | No | Yes | No |
| ListMergeFields | No | Yes | No |
| ListSegments | No | Yes | No |
| ReportAbuse | Yes | Yes | No |
| ReportAdvice | Yes | No | No |
| ReportClickDetails | Yes | No | No |
| ReportClickDetailsMembers | Yes | Yes | No |
| ReportDomainPerformance | Yes | No | No |
| ReportEmailActivity | Yes | Yes | No |
| ReportSentTo | Yes | Yes | No |
| ReportUnsubscribes | Yes | Yes | No |
Review your data set
Choose the columns from each table to include in the pipeline. By default, Data Loader selects all columns from a table.
Click Configure on a table to open Configure table. This dialog lists columns in a table and the data type of each column. Additionally, you can set a primary key and assign an incremental column state to a column.
Use the arrow buttons to move columns out of the Columns to extract and load listbox. Order columns with click-and-drag. Select multiple columns using SHIFT.
To continue and then click Done.
Click Continue once you have configured each table.
Choose destination
- Choose an existing destination or click Add a new destination.
- Select a destination from Snowflake, Amazon Redshift, or Google BigQuery.
Set frequency
| Property | Description |
|---|---|
| Pipeline name | A descriptive label for your pipeline. This is how the pipeline appears on the pipeline dashboard and how Data Loader refers to the pipeline. |
| Sync every | The frequency at which the pipeline should sync. Day values include 1—7. Hour values include 1—23. Minute values include 5—59. The input is also the length of delay before the first sync. |
Currently, you can't specify a start time.
Once you are happy with your pipeline configuration, click Create pipeline to complete the process and add the pipeline to your dashboard.