Data provision & schemas

Data types, formats, and schemas required, to build unified and enriched customer profiles in the Lexer CDP. 

Common subject matters

Lexer supports a wide range of subject matter and implementation styles. The below table outlines some common data areas and our supported connectors for these types of data.

Data

Connector type

Frequency

Customer

Direct Integration or batch via API or SFTP

Historic and daily updates

Ecommerce Transactions

Direct Integration or batch via API or SFTP

Historic and daily updates

Retail/POS Transactions

Direct Integration or batch via API or SFTP

Historic and daily updates

Returns

Direct Integration or batch via API or SFTP

Historic and daily updates

Email Engagement

Direct Integration

Historic and daily updates

Master Product fie

Direct Integration or batch via API or SFTP

Historic and daily (including discontinued products)

Website Engagement

Lexer Javascript Tag Integration

Real-time

Other

Subject to scoping

Subject to scoping

Lexer Standard Retail Schema

Through our experience working with retail customers, we’ve developed a range of retail attributes to enable valuable customer insight and action.

These attributes are generally powered by supported integration data, but in some cases a solution might entail pushing data directly to Lexer (rather than via an integration).

Lexer generally supports these solutions provided this data is shared in the required format and structure. These requirements are detailed in Lexer's "Retail Data Specification" resource.

Example Email Data Schema

Lexer offers in-platform integrations to easily connect with many popular Email Service Providers (ESPs). These integrations automatically gather data to drive related data points against your customer profiles.

In some cases (for example, with on-premise data) your solution might entail email service data directly to Lexer. In these instances Lexer will work with you to agree the requirements of an optimal data format.

The below table shows a rudimentary example structure for a "contacts" dataset, which would form one part of a broader ESP dataset.

Required Field

Required Format

Example

email

Text string

"sam@yahoo.com"

first_name

Text string

"Sam"

last_name

Text string

"Smith"

signup_date

Date

2019-06-21

unsubscribe_date

Date

2019-06-21

list_names

Text string

"Marketing", "VIPs"

email_optin_status

Text string

"subscribed" | "unsubscribed"

mobile_optin_status

Text string

"subscribed" | "unsubscribed"

Data Provision Methods

Lexer supports multiple data provision mechanisms. Below are the most common:

Powered by HelpDocs (opens in a new tab)