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

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

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

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

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

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

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