MailChimp

MailChimp ETL connector for data replication

Snapshot

Features

Details

Release Status

Released

Source API Version

v3.0

Table Selection

Yes

Column Selection

Yes

Edit Integration

Yes

Replication Type Selection

No

Authentication Parameters

Mailchimp account email Mailchimp account password

Replication Type

Full Replication Key Based Incremental

Replication Key

Date

Suggested Replication Frequency

Tables/APIs Supported

Campaigns

ConnectedSites

Conversations

Stores

Lists

AbuseReports

AdviceReports

CampaignOpenReports

CampaignClickReports

DomainPerformance

EcommerceProductActivity

EEPURLReports

EmailActivityReports

GoogleAnalyticsReports

LocationReports

RecipientsReports

SubReports

UnsubscribesReports

Integrate Mailchimp with Daton

  1. Signin 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 Webservice Endpoint, Username, and Password. Follow the to get your details

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

  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

Source API Documentation https://developer.mailchimp.com/documentation/mailchimp/reference/campaigns/

Replication: Key-Based Replication

Replication Key: since_create_time

Fields

Name

Target Datatype

id

STRING

web_id

NUMERIC

type

STRING

create_time

STRING

archive_url

STRING

long_archive_url

STRING

status

STRING

emails_sent

NUMERIC

send_time

STRING

content_type

STRING

needs_block_refresh

BOOLEAN

resendable

BOOLEAN

settings

RECORD

recipients

RECORD

tracking

RECORD

delivery_status

RECORD

ConnectedSites

Purpose: Get all connected sites in an account

Source API Documentation https://developer.mailchimp.com/documentation/mailchimp/reference/connected-sites/#

Replication: Key-Based Replication

Replication Key: created_at

Fields

Name

Target Datatype

foreign_id

STRING

store_id

STRING

platform

STRING

domain

STRING

created_at

STRING

updated_at

STRING

site_script

RECORD

Conversations

Purpose: Get a list of conversations

Source API Documentation https://developer.mailchimp.com/documentation/mailchimp/reference/conversations/

Replication: Key-Based Replication

Replication Key: created_at

Fields

Name

Target Datatype

id

STRING

campaign_id

STRING

list_id

STRING

from_label

STRING

from_email

STRING

subject

STRING

message_count

NUMERIC

unread_messages

NUMERIC

last_message

RECORD

Stores

Purpose: Get information about all stores

Source API Documentation https://developer.mailchimp.com/documentation/mailchimp/reference/ecommerce/stores/

Replication: Key-Based Replication Replication Key: created_at

Fields

Name

Target Datatype

id

STRING

list_id

STRING

name

STRING

platform

STRING

domain

STRING

email_address

STRING

currency_code

STRING

money_format

STRING

primary_locale

STRING

timezone

STRING

phone

STRING

is_syncing

BOOLEAN

address

RECORD

connected_site

RECORD

automations

RECORD

list_is_active

BOOLEAN

created_at

STRING

updated_at

STRING

Lists

Purpose: A Mailchimp list is a powerful and flexible tool that helps you manage your contacts. Get information about all lists

Source API Documentation https://developer.mailchimp.com/documentation/mailchimp/reference/campaigns/

Replication: Key-Based Replication

Replication Key: date

Fields

Name

Target Datatype

id

STRING

web_id

INTEGER

name

STRING

contact

RECORD

permission_reminder

STRING

use_archive_bar

BOOLEAN

campaign_defaults

RECORD

notify_on_subscribe

STRING

notify_on_unsubscribe

STRING

date_created

STRING

list_rating

INTEGER

email_type_option

BOOLEAN

subscribe_url_short

STRING

subscribe_url_long

STRING

beamer_address

STRING

visibility

STRING

double_optin

BOOLEAN

marketing_permissions

BOOLEAN

stats

RECORD

connected_site

RECORD

automations

RECORD

list_is_active

BOOLEAN

created_at

STRING

updated_at

STRING

AbuseReports

Purpose: Get information about campaign abuse complaints

Source API Documentation https://developer.mailchimp.com/documentation/mailchimp/reference/lists/abuse-reports/

Replication: Key-Based Replication

Replication Key: date

Fields

Name

Target Datatype

id

NUMERIC

campaign_id

STRING

list_id

STRING

list_is_active

BOOLEAN

email_id

STRING

email_address

STRING

vip

BOOLEAN

date

STRING

AdviceReports

Purpose: Get recent feedback based on a campaign’s statistics

Source API Documentation https://developer.mailchimp.com/documentation/mailchimp/reference/reports/advice/

Replication: Full Replication

Replication Key: NA

Fields

Name

Target Datatype

advice

RECORD

campaign_id

STRING

CampaignOpenReports

Purpose: Get a detailed report about any emails in a specific campaign that were opened by the recipient

Source API Documentation https://developer.mailchimp.com/documentation/mailchimp/reference/reports/open-details/

Replication: Key-Based Replication

Replication Key: date

Fields

Name

Target Datatype

campaign_id

STRING

list_id

STRING

list_is_active

BOOLEAN

email_id

STRING

email_address

STRING

vip

BOOLEAN

opens_count

NUMERIC

opens

RECORD

CampaignClickReports

Purpose: Get detailed information about links clicked in campaigns

Source API Documentation https://developer.mailchimp.com/documentation/mailchimp/reference/reports/click-details/

Replication: Key-Based Replication

Replication Key: last_click

Fields

Name

Target Datatype

campaign_id

STRING

id

STRING

url

STRING

total_clicks

NUMERIC

click_percentage

FLOAT

unique_clicks

NUMERIC

unique_click_percentage

FLOAT

last_click

STRING

ab_split

RECORD

DomainPerformance

Purpose: Get statistics for the top-performing domains from a campaign

Source API Documentation https://developer.mailchimp.com/documentation/mailchimp/reference/reports/domain-performance/

Replication: Full Replication

Replication Key: NA

Fields

Name

Target Datatype

campaign_id

STRING

domains

RECORD

total_sent

NUMERIC

EcommerceProductActivity

Purpose: Ecommerce product activity report for Campaign

Source API Documentation https://developer.mailchimp.com/documentation/mailchimp/reference/reports/ecommerce-product-activity/

Replication: Full Replication

Replication Key: NA

Fields

Name

Target Datatype

title

STRING

sku

STRING

image_url

STRING

total_revenue

NUMERIC

total_purchased

NUMERIC

currency_code

STRING

recommendation_total

NUMERIC

recommendation_purchased

NUMERIC

EEPURLReports

Purpose: Get a summary of social activity for the campaign, tracked by EepURL

Source API Documentation https://developer.mailchimp.com/documentation/mailchimp/reference/reports/eepurl/

Replication: Full Replication

Replication Key: NA

Fields

Name

Target Datatype

campaign_id

STRING

eepurl

STRING

twitter

RECORD

clicks

RECORD

referrers

RECORD

EmailActivityReports

Purpose: Get list member activity for a specific campaign

Source API Documentation https://developer.mailchimp.com/documentation/mailchimp/reference/reports/email-activity/

Replication: Key-Based Replication

Replication Key: date

Fields

Name

Target Datatype

campaign_id

STRING

list_id

STRING

list_is_active

BOOLEAN

email_id

STRING

email_address

STRING

activity

RECORD

GoogleAnalyticsReports

Purpose: Get a summary of Google Analytics reports for a specific campaign

Source API Documentation https://developer.mailchimp.com/documentation/mailchimp/reference/reports/google-analytics/

Replication: Full Replication

Replication Key: NA

Fields

Name

Target Datatype

analytics_profileId

STRING

analytics_webPropertyId

STRING

analytics_accountId

STRING

analytics_profileName

STRING

analytics_title

STRING

campaign_id

STRING

visits

NUMERIC

page_views

NUMERIC

new_visits

NUMERIC

bounces

NUMERIC

time_on_site

NUMERIC

goal_conversions

NUMERIC

goal_value

NUMERIC

revenue

NUMERIC

transactions

NUMERIC

ecomm_conversions

NUMERIC

goals

RECORD

LocationReports

Purpose: Get top open locations for a specific campaign

Source API Documentation https://developer.mailchimp.com/documentation/mailchimp/reference/reports/locations/

Replication: Full Replication

Replication Key: NA

Fields

Name

Target Datatype

campaign_id

STRING

locations

RECORD

RecipientsReports

Purpose: Get details about campaign recipients

Source API Documentation https://developer.mailchimp.com/documentation/mailchimp/reference/reports/sent-to/

Replication: Key-Based Replication

Replication Key: last_open

Fields

Name

Target Datatype

email_id

STRING

email_address

STRING

vip

BOOLEAN

status

STRING

open_count

NUMERIC

last_open

STRING

absplit_group

STRING

gmt_offset

NUMERIC

campaign_id

STRING

list_id

STRING

list_is_active

BOOLEAN

SubReports

Purpose: Get a list of reports for child campaigns of a specific parent campaign

Source API Documentation https://developer.mailchimp.com/documentation/mailchimp/reference/reports/sub-reports/

Replication: Key-Based Replication

Replication Key: send_time

Fields

Name

Target Datatype

id

STRING

campaign_title

STRING

type

STRING

list_id

STRING

list_is_active

BOOLEAN

list_name

STRING

subject_line

STRING

preview_text

STRING

emails_sent

NUMERIC

abuse_reports

NUMERIC

unsubscribed

NUMERIC

send_time

STRING

rss_last_send

STRING

bounces

RECORD

forwards

RECORD

opens

RECORD

clicks

RECORD

facebook_likes

RECORD

industry_stats

RECORD

list_stats

RECORD

ab_split

RECORD

timewarp

RECORD

timeseries

RECORD

share_report

RECORD

ecommerce

RECORD

delivery_status

RECORD

UnsubscribesReports

Purpose: Get information about list members who unsubscribed from a specific campaign

Source API Documentation https://developer.mailchimp.com/documentation/mailchimp/reference/reports/unsubscribed/

Replication: Key-Based Replication

Replication Key: send_time

Fields

Name

Target Datatype

timestamp

STRING

campaign_id

STRING

list_id

STRING

list_is_active

BOOLEAN

email_id

STRING

email_address

STRING

vip

BOOLEAN

reason

STRING