Gigya Job Openings

MailChimp

Skip to end of metadata
Go to start of metadata

Overview

Gigya’s integration with MailChimp is based on IdentitySync, our ETL service. It enables easy and efficient integration of Gigya's rich, permission-based social and other profile info with MailChimp's marketing email personalization service, so as to accurately target users in your campaigns.

Synchronize user data between Gigya and MailChimp on a recurring basis (daily) or ad-hoc, including:

  • Creating and updating users in MailChimp based on information from Gigya.
  • Updating user data in Gigya based on information from MailChimp.

IdentitySync is a premium platform that requires separate activation. If it is not part of your site package please contact your Gigya Customer Engagement Executive or contact us by filling in a support form on our site. You can also access the support page by clicking "Support" on the upper menu of Gigya's site.

Implementation

  • Due to limitations of the Mailchimp platform, Gigya account fields which hold complex multi-value object data such as user photos' URLs or Facebook likes cannot be integrated using this method.
  • Subscription data can be stored at Gigya using Gigya's customisable "data" fields, or using Lite Registration. Note that Lite Registration is a premium service that requires separate activation.

 

1. Get Your MailChimp API Key

To get your MailChimp API Key, under your profile name, select the Account menu. On your Account page, select Extras | API Keys

     

You can copy your API key from the section entitled Your API Keys.

2. Get Your List ID

To obtain the ListID, select Lists in the MailChimp menu, and then select the list you want to synchronize.

Under the list's Settings menu, select List name and defaults.

 

The List ID is displayed on the right of the List name and Campaign Defaults screen.

3. (Optional) Get Your Interest ID

If you are using Mailchimp interests, get the ID of the interest to which your Gigya data will be synced. 

  1. Open the mailchimp playground: https://us1.api.mailchimp.com/playground/ and enter your Mailchimp API key. 
  2. Select Lists
  3. Open the Subresources menu for the relevant list, select interest-categories
  4. Under Subresources, select interests.
  5. Select the relevant interest from the list. 
  6. Under Details, copy the value under id

4. Define Merge Tags

In order to define field mappings in the Gigya configuration file, you need to provide merge tags that correspond to each MailChimp field you want to map. The Gigya fields are mapped to these merge tags in the configuration file.

To specify merge tags:

  1. Select your list.
  2. Under the Settings menu, select List fields and *|MERGE|* tags.
     
  3. In the List Fields and *|MERGE|* Tags screen, add the following merge tags:
    • EMAIL for the email field (required for the integration with Gigya)
    • UID for the Gigya UID field (required for the integration with Gigya)
    • Create additional merge tags for any other field that you want to synchronize.

      Merge tags must be specified in upper case. MailChimp automatically converts all text entered into this field to upper case.


IdentitySync Data Flows

Gigya's IdentitySync is based on scheduled data flows, which are built of a series of preconfigured steps for extracting the data from the source database, transforming it as needed and loading it into the target database.

The following guide outlines the general steps for configuring an IdentitySync dataflow. For integrating with Mailchimp, you will require the following components: 

For sample data flows for integrating with Mailchimp, see: 

To create an integration based on IdentitySync, complete the following process:

The license could not be verified: License Certificate has expired!

1. Create Data Flow

  1. Open IdentitySync Data Flows in Gigya's Console. Make sure your are signed in and have selected the relevant site. The IdentitySync dashboard may also be accessed by clicking Settings in the upper menu and then IdentitySync Data Flows in the left menu.

  2. In the dashboard, click Create Data Flow

  3. In the Create Data Flow window, select the data flow integration from the dropdown. If the flow you wish to create is not available in the dropdown, select any available flow: it is customized in the next steps. For more information, see Dataflow Templates.

  4. Select the data flow template: the direction of the flow, whether from or into Gigya. Note that at the bottom of this window, you can see an outline of the flow that will be created (e.g., Account > rename > dsv > gzip >sftp). 

  5. Click Continue. As a result, the IdentitySync Studio screen opens in the dashboard. 

2. Edit the Data Flow

The data flow you created is built of the required steps for data transfer between Gigya and the selected vendor. Use the Component Repository to understand the structure and parameters required in each step.

Using IdentitySync Studio, you can:

  • Specify passwords, IDs, API keys etc. required for accessing each system and customer database.
  • Add the names of fields included in the data flow.
  • Flatten fields, remove non-ASCII strings, specify the compression type, parse in JSON or DSV format, etc. 
  • Map fields and extract array data, for example using field.array.extract.
  • Change the name of the data flow. 
  • Split a data flow, for example if you want to create two duplicate files and upload each file into a different destination. To do so, simply drag and drop the relevant step into the flow, and add connecting arrows as needed. In the code for the flow, this will be expressed in the next attribute, where you will find reference to the next two steps rather than just one. For a sample dataflow which employs this method, see the Epsilon Dataflow.
  • Add Custom Scripts.
  • Write failed records, that did not complete the flow successfully, to a separate file for review. 

The following screenshots include example screenshots for implementing IdentitySync flows. Your actual implementation may require using different components from the ones shown.

 

To do so: 

  1. If it's more convenient, you can work in full screen mode by clicking the full-screen toggle on the top rigt corner. 

  2. Double-click any of the steps to add or edit its parameters. Click OK when finished. 

  3. To add a new step, start typing its name in the Search component box. Drag the step from the list of components into the canvas.
  4. Drag arrows from/to the new step and from/to existing steps, to include it in the correct place in the flow. Make sure the "Success path" arrow is selected, under Connector Type
  5. To add a custom step, locate the record.evaluate step in the list of components and drag it to the canvas. 
  6. Double click the custom step to open a JavaScript editor. Click Test script to validate the code. For a full explanation of custom steps, see IdentitySync Custom Scripts

  7. To split the data flow (for example to write to two target platforms), add the relevant step (e.g. another "write" step) and draw arrows accordingly: 

  8. Handling failed records: You can add additional steps after a "writer" step, for writing to a separate file the records that did not complete the flow successfully. To do so: 
    1. Add the relevant components to the flow (for example, a file.format step to write the records to a file, and a writer to write the file to the relevant destination). 
    2. Under Connector Type, select the "Error path" connector. 
    3. Draw a connection from the original writer, to which successful records will be written, to the next step that handles failed records (e.g., the file.format step). 

    4. Under Connector Type, select the "Success path". 

    5. Connect the next steps that handle the failed records (e.g., the writer) using the "Successful path" connector. 

  9. Delete a step by selecting it and hitting the Delete button on your keyboard.
  10. If necessary, click Source to review the data flow code , and edit the code as needed. 
  11. Click Save

Your dashboard should now look something like this: 

Actions

The following actions are available: 

IconActionDescription
EditOpens the current data flow in IdentitySync Studio and change any of its attributes, steps and parameters.
Run TestRuns the data flow once on 10 records for test purposes. If the test was successful, after refreshing the dashboard, you will see the timestamp of the test run under Last Successful Run. Use the Status button to view the details of the run. See Job History  section on this page.
Schedule

See Schedule the Dataflow.

DuplicateUseful for creating a new data flow based on a flow which has already been customized, if you wish to create a similar flow with slight variations.
StatusDisplays the status of the current jobs running in your IdentitySync configuration. See Job History section on this page.
DeleteDeletes this data flow.

 

3. Schedule the Dataflow

  1. Under Actions, click (schedule) to open the Scheduler. 
  2. Click Create Schedule
  3. Configure the schedule: 
    • Enter a schedule name
    • Change the start time as needed
    • Choose whether to run once or at scheduled intervals
    • "Pull all records" should usually be selected only in the first run, when migrating records from one database to the other, and in any case should be used with caution. If the checkbox is not selected, and this is the first time this dataflow is run, records will be pulled according to the following logic: 
      • If the dataflow is set to run once, all records from the last 24 hours will be pulled. 
      • If the dataflow is recurring, records will be pulled according to the defined frequency. For example, if the dataflow is set to run once a week, the first time it is run, it will pull all records from the previous week. 
    • (Optional) Enter the email adress(es) for success and failure of the dataflow run. 
    • (Optional) Limit to a specific number of records. This is usually used for test runs: when running a test from the dashboard, a one-time schedule is created which runs immediately for 10 records. 
  4. Click Create, and, once you are back in the Schedule dashboard, click the Refresh button. 
  5. The status of the scheduling is indicated in the Status column. 
  6. You can stop a job mid-run by clicking the Stop icon under Actions
  • The dashboard creates a Scheduling Object.
  • Last Successful Run corresponds with the lastRuntime parameter in the Dataflow Object
  • The Scheduled Next Run displays the newest date defined in the scheduler. Therefore, it's possible to see a past date here, if no more recent dates were configured.


Limitations

The integration with MailChimp is subject to the following limitations:

  • String Length: Any string in MailChimp is limited to 255 characters.
  • Integration: There are several limitations on the integration -
    • Synchronization can only be carried out in one direction at a time - inbound (MailChimp to Gigya) or outbound (Gigya to MailChimp).
    • In addition, if you are synchronizing several MailChimp lists, they must be synchronized one at a time. For example, if you want to synchronize users in two separate lists (say, List1 and List2), both inbound and outbound, you will need to do four separate synchronization runs.
  • Complex Parameters: Since MailChimp strings are limited to 255 characters, complex Gigya fields (such as favorites and likes) are not supported for synchronization.

Inbound flows update existing users on the Gigya database. If your implementation allows the creation of new users on the ESP regardless of whether they exist on Gigya, you should contact your Customer Engagement Executive to assist in supporting this.