Cordial

Connecting Lexer and Cordial

Lexer supports connecting to both the Cordial API and SFTP. This allows us to both pull and push data between the two systems respectively. In this article, we explain how to establish an API connection that enables the consumption of campaign engagement data from Cordial. As well as connecting Lexer to your Cordial SFTP, which enables the Activating of Lexer Segments into Cordial for campaign segmentation and personalization.

Connecting to the Cordial API

Connecting to the Cordial API requires the creation of an API key within Cordial's UI. Cordial have this helpful guide that explains the process.

When creating an API Key in Cordial you must whitelist IP addresses. This ensures that only Lexer's servers can communicate with your Cordial data. Make sure you add all 9 IP addresses below;

  • 13.236.23.243
  • 3.105.80.117
  • 3.104.174.102
  • 3.104.16.54
  • 3.105.15.111
  • 3.105.117.64
  • 52.26.215.110
  • 52.26.99.95
  • 52.89.188.197

Once your key has been generated, navigate to Integrations, via Manage within Lexer.

  1. Find the Cordial tile and click on it
  2. Click INTEGRATE CORDIAL
  3. Name the integration appropriately if you are connecting more than one account
  4. Paste in your API key
  5. Click SAVE INTEGRATION

You've now successfully connected your Cordial account to Lexer via the Cordial API. Lexer can now start consuming your campaign engagement data, enriching your CDP profiles.

Connecting your Cordial SFTP

You can link your Cordial and Lexer hubs via SFTP to enable to sending of customer profiles from Lexer into Cordial. This allows the enrichment of Cordial data, as well as the adding of new records.

How do I connect Lexer and Cordial?

To connect both hubs, you first need to have your Cordial SFTP whitelisted by Lexer. This involves generating a Public Key in Cordial's UI, and then sending that to Lexer Support or your Success Manager. You will also need to provide the three IP addresses below;

  • 75.26.3.241/32
  • 52.9.134.47/32
  • 52.9.134.92/32

Creating a Public Key in Cordial

You will first need to login to your Cordial account to create a Public Key. Once logged in:

  1. Under your username in the top right hand corner, navigate to ACCOUNT SETTINGS
  2. On the left hand side of screen click on SECRETS VAULT
  3. Create a new "secret" (key) by clicking the NEW button, and giving it a name and description
  4. After you save it, a pop up will appear with a long string of numbers letters and symbols, you will need to send this to Lexer Support or your Success Manager

From here our team will ensure your key and the IP addresses above are whitelisted against your Lexer SFTP. Once we've notified you this has been done, you will be able to start transferring CSV files of records from Lexer into Cordial.

Sending records to Cordial

  1. Create the Segment in Lexer, then navigate to Activate and send your audience.
    1. Keep a copy of the name of your activation, this will become the name of the file once it arrives in Cordial.
    2. For example, if your activation name is 210112 High Value customers, it will be 210112_High_Value_customers.csv in Cordial
  2. Navigate to Cordial and login
  3. Navigate to CONTACTS > IMPORT CONTACTS
  4. Select the SFTP option, and enter the details as displayed in the table below. If you are unsure about any of these please contact Lexer Support
  5. Next to AUTHENTICATION select Saved Key and drop the drop down select your previously saved public key
  6. You can elect to have your file imported instantly or on a schedule, if you want to maintain the audience in Cordial select schedule
  7. Click CONTINUE and follow the prompts to import your data and name your import

Server Domain (AU customers)

au.transfer.lexer.io

Server Domain (US customers)

us.transfer.lexer.io

Port

22

Path

exports/cordial/<file_name>.csv

Username

<customer name> eg Lexer would be lexer

Using a FIXED VALUE field to make audiences "segment ready" in Cordial

To ensure you can recreate your Segment in Cordial, you will need to use the FIXED ATTRIBUTE VALUE field. Given we are effectively sending across a CSV of customer data, this is simply adding a column to that CSV file.

  1. Add your segment
    1. In this example, we will be using Zero Profile Segment.
  2. Add any additional attributes you want to send across
    1. E.g. First name or last name
  3. Now, add your "segment column" using the FIXED VALUE button
    1. Set the field value to "1"
    2. Add a name to the segment column (Note: Any spaces will be converted into underscores)
    3. If you are just making a single segment, one fixed value will suffice
    4. If you also wanted to add a group level coupon code, you could do that here
  4. Then, click SAVE ACTIVATION

Finally, you can click RUN ACTIVATION / RE-RUN ACTIVATION

Powered by HelpDocs (opens in a new tab)