Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

In this example, the default column names are overridden with “last_name” and “first_name”. Also, you can specify the Mailchimp “column name for group detail” as values. In the following example, the column names values are: “region, age”. For more information on Mailchimp groups, see the Appendix: "More About the Mailchimp Group Category".




Specify the parameters.

Parameters

Description

Default values

MailChimp list ID

This is the ID of the Mailchimp list that you want to populate with Treasure Data’s query results. Here is how to look it up


Update existing entries?

When toggled on, existing entries are updated with their email addresses as keys. If not, new entries are appended to the MailChimp List

Yes

Column name for email

The value of this columns is used to populate the email field of the target MailChimp List

email

Column name for fname

The value of this columns is used to populate the fname field of the target MailChimp List

fname

Column name for lname

The value of this columns is used to populate the lname field of the target MailChimp List

lname

Additional MailChimp fields and MERGE tags

The values of additional merge fields are used to populate groups in the target MailChimp List. Multiple fields can be configured by separating them by “,”. E.g: WEBSITE,GENDER


Group categories

The values of interest categories are used to populate groups in the target MailChimp List. Multiple groups can be configured by separating them by “,”. E.g interests,location


Replace group?

When toggled on, the value of the groups for each subscriber is replaced. Otherwise, new values are appended to the subscriber’s interest group.

Yes

Double opt-in?

When toggled on, each subscriber will received confirmation email and they have to confirm the subscription. Otherwise, each subscriber will be subscribed automatically

No

Atomic Upsert?

A composite of UPDATE and INSERT operations. If the UPDATE fails because the target row does not exist, the INSERT is automatically executed. When 'yes' (true), the query results returns the job's status as 'success' when all the records are processed successfully within MailChimp. (An error indicates a target row does not exists and an INSERT is automatically executed but failed.)

No

The timeout expires in Milliseconds

The time to wait for response from MailChimp API. This value is useful in the network issues

60000

Max records per request

The max records per batch request from MailChimp API. MailChimp API enables max records is 500 per batch request. This value is useful when you upload the large data.

500


Optional: Use of Scheduled Jobs for Output

...

Specify the result_settings parameters.

Parameters

Description

Default values

list_id

This is the ID of the Mailchimp list that you want to populate with Treasure Data’s query results. Here is how to look it up


update_existing

When toggled on, existing entries are updated with their email addresses as keys. If not, new entries are appended to the MailChimp List

false

email_column

The value of this columns is used to populate the email field of the target MailChimp List

email

fname_column

The value of this columns is used to populate the fname field of the target MailChimp List

fname

lname_column

The value of this columns is used to populate the lname field of the target MailChimp List

lname

merge_fields

The values of additional merge fields are used to populate groups in the target MailChimp List. Multiple fields can be configured by separating them by “,”. E.g: WEBSITE,GENDER


grouping_columns

The values of interest categories are used to populate groups in the target MailChimp List. Multiple groups can be configured by separating them by “,”. E.g interests,location


replace_interests

When toggled on, the value of the groups for each subscriber is replaced. Otherwise, new values are appended to the subscriber’s interest group.

true

double_optin

When toggled on, each subscriber will received confirmation email and they have to confirm the subscription. Otherwise, each subscriber will be subscribed automatically

false

atomic_upsert

A composite of UPDATE and INSERT operations. If the UPDATE fails because the target row does not exist, the INSERT is automatically executed. When 'yes' (true), the query results returns the job's status as 'success' when all the records are processed successfully within MailChimp. (An error indicates a target row does not exists and an INSERT is automatically executed but failed.)

false

sleep_between_requests_millis

The time to wait for response from MailChimp API. This value is useful in the network issues

30000

max_records_per_request

The max records per batch request from MailChimp API. MailChimp API enables max records is 500 per batch request. This value is useful when you upload the large data.

500

Learn more about using data connectors in the workflow to export data.

Appendix

Write the Query to Populate a Mailchimp List

...