MailChimp
MailChimp ETL connector for data replication
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 | |
- 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
- 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
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 |
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 |
Purpose: Get a list of all 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 |
Purpose: Get information about all carts in a store
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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
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 |
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 |
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 |