Перейти к основному содержимому Перейти к дополнительному содержимому

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.

Примечание к информацииУбедитесь, что используемая учетная запись имеет доступ для чтения к таблицам, которые требуется получить.

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.

  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.

    Примечание к подсказкеYou 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

Выберите шлюз Шлюз движения данных, если этого требует текущий сценарий использования.

Примечание к информации

Это поле недоступно при использовании подписки Qlik Talend Cloud Starter, так как она не поддерживает Шлюз движения данных. Если используется другой уровень подписки или не требуется использовать Шлюз движения данных, выберите Нет.

Для получения информации о преимуществах Шлюз движения данных и о сценариях, требующих его использования, см. раздел Шлюз данных Qlik — движение данных.

Start Date

Введите дату в формате MM/DD/YYYY, начиная с которой данные должны реплицироваться из источника в цель.

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

Примечание к информации

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

Помогла ли вам эта страница?

Если вы обнаружили какую-либо проблему на этой странице или с ее содержанием — будь то опечатка, пропущенный шаг или техническая ошибка, сообщите нам об этом!