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.
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.