# MailChimp ### 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 Replication: Incremental Replication Key: send\_time **Fields**

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

### **ConnectedSites** Purpose: Get all connected sites in an account Source API Documentation [https://developer.mailchimp.com/documentation/mailchimp/reference/connected-sites/# ](https://developer.mailchimp.com/documentation/mailchimp/reference/connected-sites/) Replication: Full Load **Fields**


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

### Ecommerce Stores Purpose: Get a list of all Ecommerce Stores Source API Documentation Replication: Full Load **Fields**


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

### Cart Purpose: Get information about all carts in a store Source API Documentation Replication: Full Load **Fields**


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

### Customers Source API Documentation Replication: Full Load **Fields**


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

### Products Source API Documentation Replication: Full Load **Fields**


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

### Product variants Source API Documentation Replication: Full Load **Fields**


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

### Pro**mo Rules** Source API Documentation Replication: Full Load **Fields**


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

### Pro**mo Codes** Source API Documentation Replication: Full Load **Fields**


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

### Orders Source API Documentation Replication: Full Load **Fields**


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

### **F**acebook Ads Source API Documentation Replication: Full Load **Fields**


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

### **Lists** Purpose: Your Mailchimp list, also known as your audience, is where you store and manage all of your contacts. Source API Documentation Replication: Incremental Replication Key: campaign\_last\_sent **Fields**


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

### **Landing Pages** Source API Documentation Replication: Full Load **Fields**


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

### **Campaign Reports** Source API Documentation Replication: Incremental Replication Key: send\_time **Fields**


id	STRING	id
campaign_title	STRING		NULLABLE
type	STRING		NULLABLE
list_id	STRING		NULLABLE
list_is_active	BOOLEAN		NULLABLE
list_name	STRING		NULLABLE
subject_line	STRING		NULLABLE
preview_text	STRING		NULLABLE
emails_sent	NUMERIC		NULLABLE
abuse_reports	NUMERIC		NULLABLE
unsubscribed	NUMERIC		NULLABLE
send_time	TIMESTAMP		NULLABLE
bounces	RECORD		REPEATED
forwards	RECORD		REPEATED
opens	RECORD		REPEATED
clicks	RECORD		REPEATED
facebook_likes	RECORD		REPEATED
industry_stats	RECORD		REPEATED
list_stats	RECORD		REPEATED
timeseries	RECORD		REPEATED
ecommerce	RECORD		REPEATED
delivery_status	RECORD		REPEATED
_links	RECORD		REPEATED

### **Campaign Abuse** Source API Documentation Replication: Full Load **Fields**


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

### **Campaign Open Reports** Source API Documentation Replication: Full Load **Fields**


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

### **Campaign Clicks** Source API Documentation Replication: Full Load **Fields**


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

### **Campaign Email Domain Performance** Source API Documentation Replication: Full Load **Fields**


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

### **Campaign Product Activity** Source API Documentation Replication: Full Load **Fields**


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