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 API Key Mailchimp data centre
Replication Type	Key Based Replication
Replication Key	Date-Time
Suggested Replication Frequency	24 hrs

Tables/APIs Supported
Campaigns	Connected Sites
Ecommerce Stores	Cart
Customers	Products
Product variants	Promo Rules
Promo Codes	Orders
Facebook Ads	Lists
Abuse Reports	Activity
Clients	Growth History
Interest Categories	Locations
Merge Fields	Segments
Landing Pages	Campaign Reports
Campaign Abuse	Campaign Open Reports
Campaign Clicks	Campaign Email Domain Performance
Campaign Product Activity	Campaign Email Activity
Campaign Locations	Campaign Sent To
Campaign Sub Reports	Campaign Unsubscribes
Campaign Advice reports

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

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

Replication: Incremental

Replication Key: send_time

Fields

Name	Target Datatype
id	STRING
web_id	NUMERIC
type	STRING
create_time	TIMESTAMP
archive_url	STRING
long_archive_url	STRING
status	STRING
emails_sent	NUMERIC
send_time	TIMESTAMP
content_type	STRING
needs_block_refresh	BOOLEAN
resendable	BOOLEAN
recipients	RECORD
settings	RECORD
tracking	RECORD
report_summary	RECORD
delivery_status	RECORD
_links	RECORD

ConnectedSites

Purpose: Get all connected sites in an account

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

Replication: Full Load

Fields

Name	Target Datatype
foreign_id	STRING
store_id	STRING
platform	STRING
domain	STRING
site_script	RECORD
created_at	TIMESTAMP
updated_at	TIMESTAMP
_links	RECORD

Ecommerce Stores

Purpose: Get a list of all Ecommerce Stores

Source API Documentation https://mailchimp.com/developer/marketing/api/ecommerce-stores/

Replication: Full Load

Fields

Name	Target Datatype
id	STRING
list_id	STRING
name	STRING
platform	STRING
domain	STRING
is_syncing	BOOLEAN
email_address	STRING
currency_code	STRING
money_format	STRING
primary_locale	STRING
timezone	STRING
phone	STRING
address	RECORD
connected_site	RECORD
automations	RECORD
list_is_active	BOOLEAN
created_at	TIMESTAMP
updated_at	TIMESTAMP
_links	RECORD

Cart

Purpose: Get information about all carts in a store

Source API Documentation https://mailchimp.com/developer/marketing/api/ecommerce-carts/

Replication: Full Load

Fields

Name	Target Datatype
store_id	STRING
id	STRING
customer	RECORD
campaign_id	STRING
checkout_url	STRING
currency_code	STRING
order_total	NUMERIC
tax_total	NUMERIC
lines	RECORD
created_at	TIMESTAMP
updated_at	TIMESTAMP
_links	RECORD

Customers

Source API Documentation https://mailchimp.com/developer/marketing/api/ecommerce-customers/

Replication: Full Load

Fields

Name	Target Datatype
store_id	STRING
id	STRING
email_address	STRING
opt_in_status	BOOLEAN
company	STRING
first_name	STRING
last_name	STRING
orders_count	NUMERIC
total_spent	NUMERIC
address	RECORD
created_at	TIMESTAMP
updated_at	TIMESTAMP
_links	RECORD

Products

Source API Documentation https://mailchimp.com/developer/marketing/api/ecommerce-products/

Replication: Full Load

Fields

Name	Target Datatype
store_id	STRING
id	STRING
currency_code	STRING
title	STRING
handle	STRING
url	STRING
description	STRING
type	STRING
vendor	STRING
image_url	STRING
published_at_foreign	TIMESTAMP
_links	RECORD
variants	RECORD
published_at_foreign_st	STRING

Product variants

Source API Documentation https://mailchimp.com/developer/marketing/api/ecommerce-product-variants/

Replication: Full Load

Fields

Name	Target Datatype
store_id	STRING
product_id	STRING
id	STRING
title	STRING
url	STRING
sku	STRING
price	NUMERIC
inventory_quantity	NUMERIC
image_url	STRING
backorders	STRING
visibility	STRING
created_at	TIMESTAMP
updated_at	TIMESTAMP
_links	RECORD

Promo Rules

Source API Documentation https://mailchimp.com/developer/marketing/api/ecommerce-promo-rules/

Replication: Full Load

Fields

store_id	STRING
id	STRING
title	STRING
description	STRING
starts_at	TIMESTAMP
ends_at	STRING
amount	NUMERIC
type	STRING
target	STRING
enabled	BOOLEAN
created_at_foreign	TIMESTAMP
updated_at_foreign	TIMESTAMP
_links	RECORD

Promo Codes

Source API Documentation https://mailchimp.com/developer/marketing/api/ecommerce-promo-codes/

Replication: Full Load

Fields

promo_rules_id	STRING
store_id	STRING
id	STRING
code	STRING
redemption_url	STRING
usage_count	NUMERIC
enabled	BOOLEAN
created_at_foreign	STRING
updated_at_foreign	STRING
_links	RECORD

Orders

Source API Documentation https://mailchimp.com/developer/marketing/api/ecommerce-orders/

Replication: Full Load

Fields

id	STRING
customer	RECORD
store_id	STRING
campaign_id	STRING
landing_site	STRING
financial_status	STRING
fulfillment_status	STRING
currency_code	STRING
order_total	NUMERIC
order_url	STRING
discount_total	NUMERIC
tax_total	NUMERIC
shipping_total	NUMERIC
tracking_code	STRING
processed_at_foreign	TIMESTAMP
cancelled_at_foreign	STRING
updated_at_foreign	TIMESTAMP
shipping_address	RECORD
billing_address	RECORD
lines	RECORD
tracking_number	STRING
tracking_carrier	STRING
tracking_url	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC
promos	RECORD
outreach	RECORD

Facebook Ads

Source API Documentation https://mailchimp.com/developer/marketing/api/facebook-ads/

Replication: Full Load

Fields

id	STRING
web_id	NUMERIC
name	STRING
type	STRING
status	STRING
show_report	BOOLEAN
create_time	TIMESTAMP
start_time	TIMESTAMP
updated_at	TIMESTAMP
canceled_at	TIMESTAMP
published_time	TIMESTAMP
has_segment	BOOLEAN
report_summary	RECORD
recipients	RECORD
thumbnail	STRING
email_source_name	STRING
paused_at	TIMESTAMP
end_time	TIMESTAMP
needs_attention	BOOLEAN
was_canceled_by_facebook	BOOLEAN
is_connected	BOOLEAN
has_audience	BOOLEAN
has_content	BOOLEAN
channel	RECORD
feedback	RECORD
site	RECORD
audience	RECORD
budget	RECORD
content	RECORD
_links	RECORD

Lists

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

Source API Documentation https://mailchimp.com/developer/marketing/api/lists/

Replication: Incremental

Replication Key: campaign_last_sent

Fields

id	STRING
web_id	NUMERIC
name	STRING
contact	RECORD
permission_reminder	STRING
use_archive_bar	BOOLEAN
campaign_defaults	RECORD
notify_on_subscribe	STRING
notify_on_unsubscribe	STRING
date_created	TIMESTAMP
list_rating	NUMERIC
email_type_option	BOOLEAN
subscribe_url_short	STRING
subscribe_url_long	STRING
beamer_address	STRING
visibility	STRING
double_optin	BOOLEAN
has_welcome	BOOLEAN
marketing_permissions	BOOLEAN
stats	RECORD
_links	RECORD

Landing Pages

Source API Documentation https://mailchimp.com/developer/marketing/api/landing-pages/

Replication: Full Load

Fields

id	STRING
name	STRING
title	STRING
description	STRING
template_id	NUMERIC
status	STRING
list_id	STRING
store_id	STRING
web_id	NUMERIC
created_by_source	STRING
url	STRING
created_at	TIMESTAMP
published_at	TIMESTAMP
unpublished_at	TIMESTAMP
updated_at	TIMESTAMP
tracking	RECORD
_links	RECORD

Campaign Reports

Source API Documentation https://mailchimp.com/developer/marketing/api/reports/

Replication: Incremental

Replication Key: send_time

Fields

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	TIMESTAMP
bounces	RECORD
forwards	RECORD
opens	RECORD
clicks	RECORD
facebook_likes	RECORD
industry_stats	RECORD
list_stats	RECORD
timeseries	RECORD
ecommerce	RECORD
delivery_status	RECORD
_links	RECORD

Campaign Abuse

Source API Documentation https://mailchimp.com/developer/marketing/api/campaign-abuse/

Replication: Full Load

Fields

id	NUMERIC
campaign_id	STRING
list_id	STRING
list_is_active	BOOLEAN
email_id	STRING
email_address	STRING
merge_fields	RECORD
vip	BOOLEAN
date	TIMESTAMP
_links	RECORD

Campaign Open Reports

Source API Documentation https://mailchimp.com/developer/marketing/api/open-reports/

Replication: Full Load

Fields

campaign_id	STRING
list_id	STRING
list_is_active	BOOLEAN
contact_status	STRING
email_id	STRING
email_address	STRING
merge_fields	RECORD
vip	BOOLEAN
opens_count	NUMERIC
opens	RECORD
_links	RECORD

Campaign Clicks

Source API Documentation https://mailchimp.com/developer/marketing/api/click-reports/

Replication: Full Load

Fields

id	STRING
url	STRING
total_clicks	NUMERIC
click_percentage	NUMERIC
unique_clicks	NUMERIC
unique_click_percentage	NUMERIC
last_click	TIMESTAMP
campaign_id	STRING
_links	RECORD

Campaign Email Domain Performance

Source API Documentation https://mailchimp.com/developer/marketing/api/domain-performance-reports/

Replication: Full Load

Fields

campaign_id	STRING
domain	STRING
emails_sent	NUMERIC
bounces	NUMERIC
opens	NUMERIC
clicks	NUMERIC
unsubs	NUMERIC
delivered	NUMERIC
emails_pct	NUMERIC
bounces_pct	NUMERIC
opens_pct	NUMERIC
clicks_pct	NUMERIC
unsubs_pct	NUMERIC

Campaign Product Activity

Source API Documentation https://mailchimp.com/developer/marketing/api/domain-performance-reports/

Replication: Full Load

Fields

campaign_id	STRING
title	STRING
sku	STRING
image_url	STRING
total_revenue	NUMERIC
total_purchased	NUMERIC
currency_code	STRING
recommendation_total	NUMERIC
recommendation_purchased	NUMERIC