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

Last updated