1. Home
2. Templates
3. Mailchimp

Mailchimp

• Table Description
• How to Use Template
• Data Sources
• Data Destinations
• Authorizing Data Sources
  • Mailchimp
• Authorizing Data Destinations
  • BigQuery Database
  • Google Sheets
  • Snowflake Database Provided by Keboola
  • Snowflake Database
• Most Common Errors

With this end-to-end flow, you can extract data from Mailchimp and transform it into visualizations in any BI tool of your choice.

The flow, in a nutshell:

• First, the Mailchimp data source connector will collect data from your account: lists of campaigns, members, and lists.

• Then we prepare five tables (campaign, campaign-event, customer, list, list-member) that can be used to visualize results.

• The data is then written to a database of your choice.

• Finally, you will schedule and run the entire flow (i.e., the sequence of all the prepared, above mentioned steps, in the correct order). The survey data source connector, all data manipulations, and the destination connector, will be processed.

Table Description

Name	Description
CAMPAIGN	the list of campaigns (campaign is any distributed content, that’s created and measured in Mailchimp) and metrics
CAMPAIGN-EVENT	information about campaign events such as type or created date
CUSTOMER	the list of customers and their email addresses
LIST	the list of lists of contacts
LIST-MEMBER	The table provides information on marketing contacts and their rating

How to Use Template

The process is simple. We will guide you through it, and, when needed, ask you to provide your credentials and authorize the data destination connector.

First decide which data source and which data destination you want to use. Then select the corresponding template from the Templates tab in your Keboola project. When you are done, click + Use Template.

This page contains information about the template. Click + Use Template again.

You’ll be asked to write a name for the template instance you are about to create. You can use the template as many times as you want and still keep everything organized.

After clicking Next Step, you will see the template builder. Fill in all needed credentials and perform the required OAuth authorizations.

Important: Make sure to follow all the steps very carefully to prevent the newly created flow from failing because of any user authorization problems. If you are struggling with this part, go to the section Authorizing Data Destinations below.

Follow the steps one by one and authorize at least one data source from the list. Finally, the destination must be authorized as well.

When you are finished, click Save in the top right corner. The template builder will create your new configuration, and once it’s done, you will be redirected to the Template Catalog where you can see the newly created flow.

Click Run Template and start building your visualizations a few minutes later.

Data Sources

These data source connectors are available in Public Beta:

Mailchimp

Data Destinations

These data destination connectors are available in Public Beta:

• Snowflake database provided by Keboola
• Snowflake database
• Google BigQuery database
• Google Sheets

Authorizing Data Sources

To use a selected data source connector, you must first authorize the data source.

Mailchimp

Insert your Mailchimp API token and data center (the last part of the API key after the dash). Then fill in your account user name.

Authorizing Data Destinations

To create a working flow, you must select at least one data destination.

BigQuery Database

To configure the data destination connector, you need to set up a Google Service Account and create a new JSON key.

A detailed guide is available here.

Google Sheets

Authorize your Google account.

Duplicate the sheet in your Google Drive and paste the file ID back to Keboola. It is needed for correct mapping in your duplicated Google sheet.

Snowflake Database Provided by Keboola

If you do not have your own data warehouse, follow the instructions and we will create a database for you:

1. After clicking Save, the template will be applied to your project, and you will see a flow.
2. Go there and click Snowflake Data Destination to configure it. You will be redirected to the data destination configuration and asked to set up credentials.
3. Select Keboola Snowflake database.
4. Then go back to the flow and click Run.

Everything is set up.

Snowflake Database

If you want to use your own Snowflake database, you must provide the host name (account name), user name, password, database name, schema, and a warehouse.

We highly recommend that you create a dedicated user for the data destination connector in your Snowflake database. Then you must provide the user with access to the Snowflake Warehouse.

Warning: Keep in mind that Snowflake is case sensitive and if identifiers are not quoted, they are converted to upper case. So if you run, for example, a query CREATE SCHEMA john.doe;, you must enter the schema name as DOE in the data destination connector configuration.

More info here.

Most Common Errors

Before turning to the Keboola support team for help, make sure your error is not a common problem that can be solved without our help.

Click on the text under Configuration in the top left corner. This will redirect you to the Snowflake Database connector. Now, follow the Snowflake Database provided by Keboola on the page Authorizations/destinations.

Then go to the Flows tab and Run the flow again.