Mailchimp 이 페이지에서
Mailchimp is an email and marketing automation platform for growing businesses.
MailChimp integration replicates data using the MailChimp API 3.0 .
See the
Schema section for a list of objects available for replication.
기능 스냅샷 유용한 링크와 지원되는 기능을 포함하여 이 커넥터에 대한 전반적인 내용을 살펴보겠습니다.
특징/기능 지원 세부 정보 지원되는 Qlik Talend Data Integration 프로젝트 복제 프로젝트 에만 해당됩니다. 데이터 파이프라인 프로젝트는 지원되지 않습니다.대상 업데이트 방법
복제 작업:
데이터 레이크 작업에 데이터 랜딩:
메타데이터 관리
수동 메타데이터 생성이 필요하지 않습니다. 스키마 진화
열 데이터 유형 변경 작업만 지원됩니다. LOB 열(NCLOB, CLOB 및 BLOB) 복제 지원되지 않음. 예정된 CDC 필수. 이렇게 하면 소스의 변경 내용이 대상에 최신 상태로 유지됩니다.
복제 작업의 경우 작업 예약
레이크 랜딩 작업의 경우 레이크 랜딩 작업을 위한 CDC 일정
알림 부분적으로 지원됨
작업 변경 알림 설정
모니터링 중 CDC에만 해당되며, 이 커넥터의 경우 전체 로드가 적용되지 않습니다.
개별 데이터 작업 모니터링
JSON 열 페이로드의 자동 압축 해제 지원되지 않음. 소스 데이터 집합의 JSON 열 페이로드는 대상에서 자동으로 압축 해제되지 않습니다.
Preparing for authentication To access your data, you need to authenticate the connection with your account credentials.
정보 메모 사용하는 계정에 가져오려는 테이블에 대한 읽기 액세스 권한이 있는지 확인합니다.
To obtain your client ID and secret:
Log into your Mailchimp account. Either:
Make sure Authorized Redirect URIs is set to https://connector.qlik.com/auth/oauth/v3.htm .
Each OAuth app can only have one redirect URI.
Use a unique set of client id and client secret to authenticate each of your connections. Otherwise, your tasks associated with your older connections will fail.
Creating the connection For more information, see SaaS 응용 프로그램에 연결
Click Authenticate when you have filled in the required connection settings.
You may be asked to log in to the source application.
A window is displayed with an authentication code.
Copy the code to the clipboard and return to the connection dialog.
Paste the code in Complete authentication with the code provided by the source and click Verify .
팁 메모 You may need to scroll down to see this field.
When status is Verified , the authentication is verified.
Provide a name for the connection in Connection name .
Select Open connection metadata to define metadata for the connection when it has been created.
Connection settings Setting Description Data gateway
사용 사례에 필요한 경우 데이터 이동 게이트웨이 를 선택합니다.
정보 메모 이 필드는 데이터 이동 게이트웨이 를 지원하지 않으므로 Qlik Talend Cloud 시작 구독에서는 사용할 수 없습니다. 다른 구독 계층이 있고 데이터 이동 게이트웨이 를 사용하지 않으려면 없음 을 선택합니다.
데이터 이동 게이트웨이 의 이점과 이를 필요로 하는 사용 사례에 대한 자세한 내용은 Qlik 데이터 게이트웨이 - 데이터 이동
Start Date 데이터를 소스에서 대상으로 복제해야 하는 날짜를 MM/DD/YYYY 형식으로 입력합니다.
Email Activity Date Window Enter the number of days for which you need to retrieve the email activity reports.
Example: 10 . The reports of the last 10 days will be retrieved.
Client ID Client ID. Client Secret Client secret.
정보 메모 Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.
The schema and info displayed below is for version 1.
Depending on your destination, table and column names may not appear as they are outlined below.
automations
The automations table contains summary info about your MailChimp account’s automations. In MailChimp, an automation is a feature that sends a series of emails to subscribers when triggered by a specific date, activity, or event.
Replication Method
Full Table
Primary Key
id
Replication Key
create_time
Useful links
MailChimp API method
automations table foreign keys Join automations with on campaigns automations.recipients.list_id = campaigns.recipients.list_id list_members automations.recipients.list_id = list_members.list_id list_segment_members automations.recipients.list_id = list_segment_members.list_id list_segments automations.recipients.list_id = list_segments.list_id lists automations.recipients.list_id = lists.id reports_email_activity automations.recipients.list_id = reports_email_activity.list_id
automations table schema
create_time
DATE-TIME
emails_sent
INTEGER
id
STRING
recipients
OBJECT
This is a nested data structure:
create_time: DATE-TIME emails_sent: INTEGER id: STRING recipients: OBJECT, which is also a nested data structure.
list_id: STRING list_is_active: BOOLEAN list_name: STRING segments_opts: OBJECT, which is also a nested structure.
conditions: ARRAY, which is also a nested structure.
condition_type: STRING field: STRING op: STRING value: STRING match: STRING saved_segment_id: INTEGER store_id: STRING report_summary: OBJECT, which is also a nested data structure.
click_rate: NUMBER clicks: INTEGER open_rate: NUMBER opens: INTEGER subscriber_clicks: INTEGER unique_opens: INTEGER settings: OBJECT, which is also a nested data structure.
authenticate: BOOLEAN auto_footer: BOOLEAN from_name: STRING inline_css: BOOLEAN reply_to: STRING title: STRING to_name: STRING use_conversation: BOOLEAN start_time: DATE-TIME status: STRING tracking: OBJECT, which is also a nested data structure.
capsule: OBJECT, which is also a nested data structure.
clicktale: STRING ecomm360: BOOLEAN goal_tracking: BOOLEAN google_analytics: STRING html_clicks: BOOLEAN opens: BOOLEAN salesforce: OBJECT, which is also a nested data structure.
campaign: BOOLEAN notes: BOOLEAN text_clicks: BOOLEAN trigger_settings: OBJECT, which is also a nested data structure.
runtime: STRING workflow_emails_count: INTEGER workflow_title: STRING workflow_type: STRING
campaigns
The campaigns table contains info about the campaigns in your MailChimp account.
campaigns table foreign keys Join campaigns with on reports_email_activity campaigns.id = reports_email_activity.campaign_id campaigns.recipients.list_id = reports_email_activity.list_id automations campaigns.recipients.list_id = automations.recipients.list_id list_members campaigns.recipients.list_id = list_members.list_id list_segment_members campaigns.recipients.list_id = list_segment_members.list_id list_segments campaigns.recipients.list_id = list_segments.list_id lists campaigns.recipients.list_id = lists.id
campaigns table schema
archive_url
STRING
content_type
STRING
create_time
DATE-TIME
delivery_status
OBJECT
This is a nested data structure:
emails_sent
INTEGER
has_logo_merge_tag
BOOLEAN
id
STRING
long_archive_url
STRING
needs_block_refresh
BOOLEAN
recipients
OBJECT
This is a nested data structure:
list_id: STRING list_is_active: BOOLEAN list_name: STRING recipient_count: INTEGER segment_opts: OBJECT, which is also a nested data structure.
conditions: ARRAY, which is also a nested data structure.
condition_type: STRING field: STRING op: STRING value: STRING match: STRING prebuilt_segment_id: STRING saved_segment_id: INTEGER segment_text: STRING
report_summary
OBJECT
This is a nested data structure:
click_rate: NUMBER clicks: INTEGER ecommerce: OBJECT, which is also a nested data structure.
total_orders: INTEGER total_revenue: INTEGER total_spent: INTEGER open_rate: NUMBER opens: INTEGER subscriber_clicks: INTEGER unique_opens: INTEGER
resendable
BOOLEAN
send_time
DATE-TIME
settings
OBJECT
This is a nested data structure:
authenticate: BOOLEAN auto_footer: BOOLEAN auto_tweet: BOOLEAN drag_and_drop: BOOLEAN fb_comments: BOOLEAN folder_id: STRING from_name: STRING inline_css: BOOLEAN preview_text: STRING reply_to: STRING subject_line: STRING template_id: STRING timewarp: BOOLEAN title: STRING to_name: STRING use_conversation: BOOLEAN
social_card
OBJECT
This is a nested data structure:
description: STRING image_url: STRING title: STRING
status
STRING
tracking
OBJECT
This is a nested data structure:
clicktale: STRING ecomm360: BOOLEAN goal_tracking: BOOLEAN google_analytics: STRING html_clicks: BOOLEAN opens: BOOLEAN text_clicks: BOOLEAN
type
STRING
web_id
INTEGER
list_members
The list_members table contains info about the members in a specific MailChimp list, including currently subscribed, unsubscribed, and bounced members.
Replication Method
CDC
Primary Keys
id
list_id
Replication Key
last_changed
Useful links
MailChimp API method
list_members table foreign keys list_members table schema
email_address
STRING
email_client
STRING
email_type
STRING
id
STRING
ip_opt
STRING
ip_signup
STRING
language
STRING
last_changed
DATE-TIME
list_id
STRING
location
OBJECT
This is a nested data structure:
country_code: STRING dstoff: INTEGER gmtoff: INTEGER latitude: NUMBER longitude: NUMBER timezone: STRING
member_rating
NUMBER
source
STRING
stats
OBJECT
This is a nested data structure:
avg_click_rate: NUMBER avg_open_rate: NUMBER
status
STRING
tags
ARRAY
This is a nested data structure:
tags_count
INTEGER
timestamp_opt
DATE-TIME
timestamp_signup
DATE-TIME
unique_email_id
STRING
unsubscribe_reason
STRING
vip
BOOLEAN
web_id
INTEGER
list_segment_members
The list_segment_members table contains info about members in a saved segment
list_segment_members table foreign keys Join list_segment_members with on automations list_segment_members.list_id = automations.recipients.list_id campaigns list_segment_members.list_id = campaigns.recipients.list_id list_members list_segment_members.list_id = list_members.list_id list_segments list_segment_members.list_id = list_segments.list_id lists list_segment_members.list_id = lists.id reports_email_activity list_segment_members.list_id = reports_email_activity.list_id
list_segment_members table schema
email_address
STRING
email_client
STRING
email_type
STRING
id
STRING
ip_opt
STRING
ip_signup
STRING
language
STRING
last_changed
DATE-TIME
list_id
STRING
location
OBJECT
This is a nested data structure:
country_code: STRING dstoff: INTEGER gmtoff: INTEGER latitude: NUMBER longitude: NUMBER timezone: STRING
member_rating
NUMBER
stats
OBJECT
This is a nested data structure:
avg_click_rate: NUMBER avg_open_rate: NUMBER
status
STRING
timestamp_opt
DATE-TIME
timestamp_signup
STRING
unique_email_id
STRING
vip
BOOLEAN
list_segments
The list_segments table contains info about the available segments for a specific list.
Replication Method
Full Table
Primary Key
id
Replication Key
updated_at
Useful links
MailChimp API method
list_segments table foreign keys list_segments table schema
created_at
DATE-TIME
id
STRING
list_id
STRING
member_count
INTEGER
name
STRING
options
OBJECT
This is a nested data structure:
conditions: ARRAY, which is also a nested data structure.
condition_type: STRING field: STRING op: STRING value: STRING match: STRING
type
STRING
updated_at
DATE-TIME
lists
The lists table contains info about all the lists in your MailChimp account. A list is also known as an audience, and is where all contacts are stored and managed in MailChimp.
lists table schema
beamer_address
STRING
campaign_defaults
OBJECT
This is a nested data structure:
from_email: STRING from_name: STRING language: STRING subject: STRING
contact
OBJECT
This is a nested data structure:
address1: STRING address2: STRING city: STRING company: STRING country: STRING phone: STRING state: STRING zip: STRING
date_created
DATE-TIME
double_optin
BOOLEAN
email_type_option
BOOLEAN
has_welcome
BOOLEAN
id
STRING
list_rating
INTEGER
marketing_permissions
BOOLEAN
modules
ARRAY
name
STRING
notify_on_subscribe
STRING
notify_on_unsubscribe
STRING
permission_reminder
STRING
stats
OBJECT
This is a nested data structure:
avg_sub_rate: NUMBER avg_unsub_rate: NUMBER campaign_count: INTEGER campaign_last_sent: DATE-TIME cleaned_count: INTEGER cleaned_count_since_send: INTEGER click_rate: NUMBER last_sub_date: DATE-TIME last_unsub_date: DATE-TIME member_count_since_send: INTEGER merge_field_count: INTEGER open_rate: NUMBER target_sub_rate: NUMBER unsubscribe_count: INTEGER unsubscribe_count_since_send: INTEGER
subscribe_url_long
STRING
subscribe_url_short
STRING
use_archive_bar
BOOLEAN
visibility
STRING
web_id
STRING
reports_email_activity
The reports_email_activity table contains info about a member’s subscriber activity in a specific campaign.
reports_email_activity table foreign keys Join reports_email_activity with on campaigns reports_email_activity.campaign_id = campaigns.id reports_email_activity.list_id = campaigns.recipients.list_id automations reports_email_activity.list_id = automations.recipients.list_id list_members reports_email_activity.list_id = list_members.list_id list_segment_members reports_email_activity.list_id = list_segment_members.list_id list_segments reports_email_activity.list_id = list_segments.list_id lists reports_email_activity.list_id = lists.id
reports_email_activity table schema
action
STRING
campaign_id
STRING
email_address
STRING
email_id
STRING
ip
STRING
list_id
STRING
list_is_active
BOOLEAN
timestamp
DATE-TIME
type
STRING
url
STRING
unsubscribes
The unsubscribes table contains info about members who have unsubscribed from a specific campaign.
unsubscribes table schema
campaign_id
STRING
email_address
STRING
email_id
STRING
list_id
STRING
list_is_active
BOOLEAN
reason
STRING
timestamp
DATE-TIME
vip
BOOLEAN
