AMAZON REDSHIFT TO MAILCHIMP HOW TO
AMAZON REDSHIFT TO MAILCHIMP UPDATE

Order Line Item(s) Data (Required for new orders only): For sending information about one or more order line items (make sure the product already exists).įor the following Options, choose an Attribute from the Map dropdown and an option from the To dropdown.Otherwise, a new customer will be created. If the customer exists in your store, their information is updated. Customer Data (Required): For sending information about a specific customer.Order Data (Required): For sending transactional information about the order.Hashed email address of the subscriber (Optional if the plain email address is already provided)Īction - Upsert Ecommerce Order Parameters Options - General Properties to Set Option General Properties to Set (Required): Allows you to send the unsubscriber’s data to specific fields in the target Mailchimp list (see available options below).įor the following Options, choose an attribute from the Map dropdown and an option from the To dropdown.Target Subscriber List (Required): Select the target Mailchimp list to add the unsubscribed member to.Options - Set Field and Merge Tags OptionĪction - Unsubscribe Visitor from List Parameters The date and time when the subscriber signed up for your list. The date and time when the subscriber confirmed their opt-in status Possible values are: subscribed, unsubscribed, cleaned, and pending.

Geolocation of the subscriber at the time of signupĬurrent subscription status of the subscriber. The language set in the subscriber’s browser at the time of signup. The IP address of the computer/device used by the subscriber during signup. The IP address used by the subscriber to confirm their opt-in status. Indicates the type of email message/content. If no member status is provided, the status defaults to subscribed Hashed email address of the subscriber using MD5, according to Mailchimp email hash requirements. (Optional if plain email address is provided) Plain email address of the subscriber, will be hashed with MD5 automatically according to Mailchimp email hash requirements. Options - General Properties to Set OptionĮmail Address - Plain (Required for new subscribers) New Notes: Provide additional notes for the subscriber.įor the following Options, choose an Attribute from the Map dropdown and an option from the To dropdown.

AMAZON REDSHIFT TO MAILCHIMP UPDATE

Set Field and Merge Tags: Add or update tags for the subscriber.Target Interest Group: Select the interest group(s) to add the subscriber to.Update Existing Subscriber (RECOMMENDED): Check this box if you want existing subscriber information to be automatically updated.General Properties to Set (Required): Allows you to send additional data about the subscribed member to specific fields in the target Mailchimp list.Target Subscriber List (Required): Select the target Mailchimp list to add the subscriber to.Action - Subscribe Visitor to List Parameters

AMAZON REDSHIFT TO MAILCHIMP HOW TO

This section describes how to set up parameters and options for each action. It’s where you’ll set up actions and trigger them.

(Optional) Provide additional notes about this Mailchimp implementation.Ĭlick Next or go to the Actions tab.

In the Configure tab, enter a suitable title.

Read the Connector Overview article for general instructions on how to add a connector. Go to the Connector Marketplace and add a new Mailchimp connector. Upsert Ecommerce details for abandoned carts Upsert Ecommerce transaction details for successful orders

Mailchimp API Key ( how to find your API key).

Xandr Instant Audience Service (Formerly AppNexus).

TikTok Audiences (Tealium-Provided Credentials).

Salesforce Journey Builder (Deprecated).

Salesforce Email Studio OAuth2 (ExactTarget).

Google Display & Video 360 Customer Match.

Google Analytics 4 Measurement Protocol.

Google Ads Enhanced Conversions for Web.

Google Ads Enhanced Conversions for Leads.

Google Ads Enhanced Conversions - Legacy.

Facebook and Tealium Customer Data Hub (Series).

Connector Insights Facebook Event Match Quality.

Connector Insights Facebook Custom Audiences.

AWS Kinesis Streams (Tealium-Provided Credentials).

Amazon redshift to mailchimp