Selligent

Importing events using Selligent

The Squeezely platform can import events from a Selligent article list table by using the Selligent REST API. This offers a solution when unable and/or willing to use our frontend tracker to send frontend events.

To enable this feature, enable the event import by selecting the article list to import from on the Selligent channel settings page.

Some points to keep in mind:

Column names should reflect the default event property names as found in the frontend tracking documentation.
Empty columns will be evaluated and ignored on a per-row basis.
Events will be dated by using the CREATED_DT column if present. This basically means the order in which events are inserted is significant. Please make sure events are inserted chronologically to ensure profile fields have the most current field values.
Event rows will be deleted from the article list after importing.
Custom fields can be added as columns to the table by using the custom field name as shown in the data overview (fields prefixed with custom_*).
Custom fields will be created automatically when a new column with the custom_* name prefix with a valid data type has been detected for the first time.
Custom fields of the Text type have a maximum length of 255 characters. When exceeding this value only the first 255 characters will be used.
Please contact us if a Selligent REST API IP whitelist is used. Calls to the Selligent REST API will originate from one or more of our servers. We can provide you with an up to date list.

An example table could be:

CREATE TABLE dbo.ARTICLES_SQUEEZELY_DMP_EVENTS (
   ID INT NOT NULL IDENTITY(1, 1) PRIMARY KEY,
   CREATED_DT DATETIME NULL,
   MODIFIED_DT DATETIME NULL,
   EVENT VARCHAR(32) NOT NULL, -- PageView, Purchase, EmailOptIn, ViewContent etc.
   USERID INT NULL, -- User ID
   EMAIL CHAR(64) NULL, -- sha-256 hash or e-mail address
   EMAIL_HASH CHAR(64) NULL, -- sha-256 hash of e-mail address
   CUSTOM_EXAMPLESTRING VARCHAR(255) NULL, -- Text custom field, 255 character maximum
   CUSTOM_EXAMPLENUMBERINTEGER INT NULL, -- Number custom field
   CUSTOM_EXAMPLENUMBERFLOAT DECIMAL(6,2) NULL, -- Number custom field
   CUSTOM_EXAMPLEDATE DATE NULL -- Date custom field
);

Exporting audiences using Selligent

The Squeezely platform can export audiences to a Selligent article list table by using the Selligent REST API.

To enable this feature, enable the audience export by selecting the article list to export the audiences to on the Selligent channel settings page.

Some points to keep in mind:

Empty columns will be evaluated and ignored on a per-row basis.
Please contact us if a Selligent REST API IP whitelist is used. Calls to the Selligent REST API will originate from one or more of our servers. We can provide you with an up to date list.

An example table could be:

CREATE TABLE dbo.ARTICLES_DMP_AUDIENCES
(
   ID INT NOT NULL IDENTITY(1, 1) PRIMARY KEY,
   CREATED_DT DATETIME NULL,
   MODIFIED_DT DATETIME NULL,
   EMAIL_HASH CHAR(64) NOT NULL, -- sha-256 hash of e-mail address
   AUDIENCE_ID INT NOT NULL, -- Squeezely audience ID
);