Ana içeriğe geç Tamamlayıcı içeriğe geç

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.

Preparing for authentication

To access your data, you need to authenticate the connection with your account credentials.

Bilgi notuKullandığınız hesabın, almak istediğiniz tablolar için okuma erişimine sahip olduğundan emin olun.

To obtain your client ID and secret:

  1. Log into your Mailchimp account.
  2. Either:
    • Create a new app. The client ID and secret are displayed when the app is created.

      As the client secret is displayed only once, copy and paste it to a secured file.

    • Edit an existing app and click Rotate to generate a new client secret.
  3. 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 uygulamalarına bağlanma.

  1. 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.

  2. Copy the code to the clipboard and return to the connection dialog.

  3. Paste the code in Complete authentication with the code provided by the source and click Verify.

    İpucu notuYou may need to scroll down to see this field.

    When status is Verified, the authentication is verified.

  4. Provide a name for the connection in Connection name.

  5. Select Open connection metadata to define metadata for the connection when it has been created.

Connection settings
SettingDescription
Data gateway

Kullanım durumunuz gerektiriyorsa bir Veri Hareketi ağ geçidi seçin.

Bilgi notu

Qlik Talend Cloud Başlangıç Kılavuzu aboneliği Veri Hareketi ağ geçidi desteklenmediğinden bu alan, söz konusu abonelikle kullanılamaz. Başka bir abonelik kademeniz varsa ve Veri Hareketi ağ geçidi kullanmak istemiyorsanız Hiçbiri'ni seçin.

Veri Hareketi ağ geçidi avantajları ve bunu gerektiren kullanım durumları hakkında bilgi için bkz. Qlik Data Gateway - Veri Hareketi.

Start Date

Verilerin kaynağınızdan hedefinize çoğaltılması gereken tarihi MM/DD/YYYY biçiminde girin.

Email Activity Date WindowEnter 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 IDClient ID.
Client SecretClient secret.

Schema

Bilgi notu

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

campaigns

The campaigns table contains info about the campaigns in your MailChimp account.

Replication Method

Full Table

Primary Key

id

Useful links

MailChimp API method

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_segment_members

The list_segment_members table contains info about members in a saved segment

Replication Method

Full Table

Primary Key

id

Useful links

MailChimp API method

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

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.

Replication Method

Full Table

Primary Key

id

Useful links

MailChimp API method

reports_email_activity

The reports_email_activity table contains info about a member’s subscriber activity in a specific campaign.

Replication Method

CDC

Primary Keys

action

campaign_id

email_id

timestamp

Useful links

MailChimp documentation

MailChimp API method

unsubscribes

The unsubscribes table contains info about members who have unsubscribed from a specific campaign.

Replication Method

Full Table

Primary Keys

campaign_id

email_id

Useful links

MailChimp API method

Bu sayfa size yardımcı oldu mu?

Bu sayfa veya içeriği ile ilgili bir sorun; bir yazım hatası, eksik bir adım veya teknik bir hata bulursanız lütfen bize bildirin!