Zu Hauptinhalt springen Zu ergänzendem Inhalt springen

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.

InformationshinweisVergewissern Sie sich, dass das verwendete Konto Lesezugriff auf die Tabellen hat, die Sie abrufen möchten.

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 Herstellung einer Verbindung zu SaaS-Anwendungen.

  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.

    TipphinweisYou 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

Wählen Sie ein Data Movement Gateway aus, wenn dies für Ihren Anwendungsfall erforderlich ist.

Informationshinweis

Dieses Feld ist für das Qlik Talend Cloud Starter-Abonnement nicht verfügbar, da dieses Abonnement Data Movement Gateway nicht unterstützt. Wenn Sie eine andere Abonnementstufe haben und Data Movement Gateway nicht verwenden möchten, wählen Sie Keine.

Weitere Informationen zu den Vorteilen von Data Movement Gateway und den Anwendungsfällen, in denen es erforderlich ist, finden Sie unter Qlik Data Gateway – Datenbewegung.

Start Date

Geben Sie das Datum im Format MM/DD/YYYY ein, ab dem die Daten von der Quelle zum Ziel repliziert werden müssen.

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

Informationshinweis

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

Hat diese Seite Ihnen geholfen?

Wenn Sie ein Problem mit dieser Seite oder ihrem Inhalt feststellen, sei es ein Tippfehler, ein ausgelassener Schritt oder ein technischer Fehler, informieren Sie uns bitte!