Snapshot

Integrate Mailchimp with Daton

1. Sign-in to Daton .

2. Select Mailchimp from Integrations page.

3. Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later.

4. Provide Mailchimp API Key and Data Centre.

5. Post successful authentication, you will be prompted to choose from the list of available tables. Select the required tables from the list.

6. Then select all required fields for each table.

7. Submit the integration

Workflow

1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse

2. Users would be able to edit/pause/re-activate/delete integration anytime

3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

Mailchimp Data

Campaigns

Purpose: Get all campaigns in an account. Campaigns are how you send emails to your Mailchimp list. Use the Campaigns API calls to manage campaigns in your Mailchimp account

Replication: Incremental

Replication Key: send_time

Fields

ConnectedSites

Purpose: Get all connected sites in an account

Replication: Full Load

Fields

Ecommerce Stores

Purpose: Get a list of all Ecommerce Stores

Replication: Full Load

Fields

Cart

Purpose: Get information about all carts in a store

Replication: Full Load

Fields

Customers

Replication: Full Load

Fields

Products

Replication: Full Load

Fields

Product variants

Replication: Full Load

Fields

Promo Rules

Replication: Full Load

Fields

Promo Codes

Replication: Full Load

Fields

Orders

Replication: Full Load

Fields

Facebook Ads

Replication: Full Load

Fields

Lists

Purpose: Your Mailchimp list, also known as your audience, is where you store and manage all of your contacts.

Replication: Incremental

Replication Key: campaign_last_sent

Fields

Landing Pages

Replication: Full Load

Fields

Campaign Reports

Replication: Incremental

Replication Key: send_time

Fields

Campaign Abuse

Replication: Full Load

Fields

Campaign Open Reports

Replication: Full Load

Fields

Campaign Clicks

Replication: Full Load

Fields

Campaign Email Domain Performance

Replication: Full Load

Fields

Campaign Product Activity

Replication: Full Load

Fields