Engage Data product

The Engage Data product provides a comprehensive view of customer engagement and communication activities. It organizes key information such as contact interactions, email preferences, message performance (like clicks and opens), product views, abandoned carts, and promotional participation. It also includes insights into audience targeting, receipts, and consent management.

With Engage Data you can analyze customer behavior, refine marketing strategies, and improve overall communication effectiveness, through a centralized and structured data source.

Some use cases areas:

• Analyzing customer engagement to understand interactions, identify effective strategies, and discover opportunities for improvement
• Optimizing marketing strategies by using data insights to tailor campaigns, target specific audiences, and maximize ROI
• Managing customer communication by handling consent efficiently, ensuring compliance, and maintaining clear and consistent messaging

AbandonedCart

Tenant column:tenantId
Description: The table contains data related to abandoned shopping carts on our website. It captures information such as the contact ID of the user, the reference number of the cart, the timestamp of when the cart was abandoned, the session ID, whether it was a new session or not, the user agent used, the referral source, the URL of the page where the cart was abandoned, the SKU of the product in the cart, the quantity of the product, the URL of the cart page, the tenant ID, and the timestamp of when the data was imported. This table is valuable for analyzing user behavior and identifying potential issues in the checkout process.

Column name	Type
contactId	STRING
cartreference	STRING
time	TIMESTAMP
session	STRING
newsession	BOOLEAN
useragent	STRING
referred	STRING
url	STRING
sku	STRING
quantity	INT
carturl	STRING
tenantId	STRING
ImportDateTime	TIMESTAMP

ArticleLatest

Tenant column:tenantId
Description: The table contains information about articles, including their unique identifiers, names, and associated stock keeping units (SKUs). It also tracks modifications, eligibility for bonus awards, and the type of changes made to each article. This data can be used for inventory management, reporting on article performance, and analyzing changes over time. Additionally, it includes timestamps for when articles were last modified and exported for Business Intelligence purposes.

Column name	Type
articleId	STRING
sku	STRING
articleName	STRING
articleNumber	STRING
articleGroupName	STRING
modifiedDateTime	TIMESTAMP
awardsBonus	BOOLEAN
spare1	STRING
spare2	STRING
spare3	STRING
spare4	STRING
spare5	STRING
spare6	STRING
spare7	STRING
spare8	STRING
spare9	STRING
spare10	STRING
changeType	STRING
filename	STRING
biExportDate	TIMESTAMP
ImportDateTime	TIMESTAMP
tenantId	STRING
ImportDate	DATE
itemNumber	STRING
brand	STRING
color	STRING
size	STRING
mainCategory	STRING
productCategory	STRING
subCategory	STRING
ageGroup	STRING
gender	STRING
description	STRING
season	STRING
ean	STRING
gtin	STRING
isStub	STRING
tenant_id	STRING

ConsentLatest

Tenant column:tenantId
Description: The table contains records of consent given by contacts, including details such as the contact identifier, consent status, and timestamps for when consent was given and when the record was imported. This data can be used to track consent compliance, analyze consent trends over time, and manage contact preferences effectively.

Column name	Type
id	STRING
contactId	STRING
alias	STRING
value	BOOLEAN
consentDateTime	TIMESTAMP
source	STRING
comment	STRING
biExportDate	TIMESTAMP
ImportDateTime	TIMESTAMP
tenantId	STRING
filename	STRING
ImportDate	DATE
tenant_id	STRING

ContactsLatest

Tenant column:tenantId
Description: The table contains detailed information about contacts, including their demographics, communication preferences, and engagement metrics. It can be used to analyze contact approval status, communication acceptance, and demographic distribution. Additionally, the RFM scores and NPS grades can help in understanding contact value and satisfaction levels, which can inform marketing strategies and customer relationship management.

Column name	Type
contactId	STRING
contactType	STRING
isApproved	BOOLEAN
isDeleted	BOOLEAN
gender	STRING
age	INT
zipCode	STRING
city	STRING
countryCode	STRING
acceptsEmail	BOOLEAN
acceptsSms	BOOLEAN
acceptsPostal	BOOLEAN
statusEmail	STRING
statusSms	STRING
statusPostal	STRING
rfm	DOUBLE
recency	INT
frequency	INT
monetary	INT
latestNpsGrade	INT
latestNpsDateTime	TIMESTAMP
registrationDateTime	TIMESTAMP
lastModifiedDateTime	TIMESTAMP
deletedDateTime	TIMESTAMP
deletedReason	STRING
purchaseAmountTotal	DOUBLE
numberOfArticlesTotal	DOUBLE
averageReceiptTotal	DOUBLE
latestReceiptDateTime	TIMESTAMP
purchaseFrequencyTotal	DOUBLE
purchaseAmount12months	DOUBLE
numberOfArticles12Months	DOUBLE
averageReceipt12Months	DOUBLE
purchaseFrequency12months	DOUBLE
recruitedStoreId	STRING
currentStoreId	STRING
changeType	STRING
filename	STRING
biExportDate	TIMESTAMP
ImportDateTime	TIMESTAMP
tenantId	STRING
ImportDate	DATE
email	STRING
mobilePhone	STRING
firstName	STRING
lastName	STRING
externalId	STRING
creationTime	TIMESTAMP
street	STRING
country	STRING
bonusPoints	DOUBLE
socialSecurityNumber	STRING
bonusPointsModifiedOn	TIMESTAMP
careOf	STRING
secrecyMarked	STRING
memberNumber	STRING
source	STRING
canReceiveEmail	BOOLEAN
canReceiveSms	BOOLEAN
canReceivePostal	BOOLEAN
birthDate	STRING
isClearedAfterDeletion	BOOLEAN
tenant_id	STRING

DeliveredMessageLatest

Tenant column:tenantId
Description: The table contains data related to delivery events, including details about each delivery, associated messages, and contacts. It records timestamps for delivery and import events, as well as identifiers for tenants and files. This data can be used to track delivery performance, analyze changes over time, and support business intelligence efforts.

Column name	Type
deliveryId	STRING
messageId	STRING
contactId	STRING
deliveryDateTime	TIMESTAMP
changeType	STRING
filename	STRING
biExportDate	TIMESTAMP
ImportDateTime	TIMESTAMP
tenantId	STRING
ImportDate	DATE
deliveryYearMonthDate	STRING

EmailUnsubscribeLatest

Tenant column:tenant_id Description: The table contains data related to message delivery events, including details about delivery attempts and bounce types. It can be used to analyze delivery performance, track issues with message bounces, and understand the timing of events. Key information includes identifiers for deliveries and messages, timestamps for event occurrences, and the type of bounce that occurred.

Column name	Type
delivery_id	STRING
message_id	STRING
EventTime	TIMESTAMP
BounceType	STRING
contact_id	STRING
tenant_id	STRING
LinkId	STRING
kafka_timestamp	TIMESTAMP
import_date_time	TIMESTAMP
event_year_month_date	STRING

LabelLatest

Tenant column:tenantId
Description: The table contains records related to data imports for various tenants. It includes details such as the unique identifier for each record, the type of data, and the name associated with the record. Additionally, it tracks timestamps for when the data was imported and exported for business intelligence purposes, as well as the filename from which the data was sourced. This table can be used to monitor data import activities, analyze import trends, and manage tenant-specific data effectively.

Column name	Type
id	STRING
type	STRING
name	STRING
tenantId	STRING
biExportDate	TIMESTAMP
ImportDateTime	TIMESTAMP
ImportDate	DATE
filename	STRING
tenant_id	STRING

LabelsToTaggedContactLatest

Tenant column:tenant_id Description: The table contains data related to imported files associated with contacts. It includes unique identifiers for both labels and contacts, as well as timestamps for when the data was imported. This information can be used to track the import process, manage data associated with specific contacts, and analyze the timing of data imports.

Column name	Type
label_id	STRING
contact_id	STRING
filename	STRING
ImportDateTime	TIMESTAMP
tenant_id	STRING
ImportDate	DATE
import_date_time	TIMESTAMP

MessageClickLatest

Tenant column:tenantId
Description: The table contains data related to user clicks on messages. It includes details such as the unique identifiers for clicks, messages, and deliveries, as well as timestamps for when clicks and imports occurred. This data can be used to analyze user engagement with messages, track the performance of different messages, and understand user behavior based on the device used for clicks.

Column name	Type
clickId	INT
messageId	STRING
deliveryId	STRING
clickDateTime	TIMESTAMP
url	STRING
changeType	STRING
filename	STRING
biExportDate	TIMESTAMP
tenantId	STRING
tenant_id	STRING
ImportDateTime	TIMESTAMP
clickYearMonthDate	STRING
ImportDate	DATE
contactId	STRING
userAgent	STRING
messageClass	STRING
email	STRING

MessageControlGroupLatest

Tenant column:tenantId
Description: The table contains data related to message control groups and their associated messages. It includes identifiers for messages and contacts, details about changes made to messages, and timestamps for import and export activities. This data can be used to track message processing, analyze changes over time, and support business intelligence efforts.

Column name	Type
messageControlGroupId	INT
messageId	STRING
contactId	STRING
changeType	STRING
filename	STRING
biExportDate	TIMESTAMP
ImportDateTime	TIMESTAMP
tenantId	STRING
ImportDate	DATE
tenant_id	STRING

MessageLatest

Tenant column:tenantId
Description: The table contains information about messages that are scheduled to be sent, including their status, recipient details, and associated workflows. Use cases include tracking message delivery, analyzing the effectiveness of different messaging channels, and managing transactional messages. It also provides insights into control groups and the timing of message imports and exports for business intelligence.

Column name	Type
messageId	STRING
messageName	STRING
subject	STRING
status	STRING
scheduledDateTime	TIMESTAMP
recipientCount	INT
channel	STRING
sendList	STRING
messageSource	STRING
isTransactional	BOOLEAN
controlGroupPercent	DOUBLE
senderStoreId	STRING
changeType	STRING
filename	STRING
biExportDate	TIMESTAMP
ImportDateTime	TIMESTAMP
tenantId	STRING
ImportDate	DATE
workflowId	STRING
workflowActivityId	STRING
isWorkflowTemplate	BOOLEAN
workflowMessageId	STRING
tenant_id	STRING

MessageOpenLatest

Tenant column:tenantId
Description: The table contains data related to message open events. It includes details such as the unique identifiers for messages and deliveries, timestamps for when messages were opened and imported, and information about the user’s device. This data can be used to analyze user engagement with messages, track the performance of different message types, and understand trends over time.

Column name	Type
openId	INT
messageId	STRING
deliveryId	STRING
openDateTime	TIMESTAMP
userAgent	STRING
changeType	STRING
filename	STRING
biExportDate	TIMESTAMP
tenantId	STRING
tenant_id	STRING
ImportDateTime	TIMESTAMP
openYearMonthDate	STRING
ImportDate	DATE
contactId	STRING
messageClass	STRING
email	STRING

NPSResponseLatest

Tenant column:tenant_id Description: The table contains records related to contacts associated with various stores. It includes information such as unique identifiers for contacts and stores, the date and time of record creation and import, and the grade or rating given by the contact. This data can be used to track contact interactions, analyze feedback trends, and monitor changes over time.

Column name	Type
contact_id	STRING
store_id	STRING
created_date_time	TIMESTAMP
create_date	DATE
grade	STRING
changeType	STRING
tenant_id	STRING
import_date_time	TIMESTAMP

ProductView

Tenant column:tenantId
Description: The table captures data related to product views by users. It includes information such as the unique identifier for the contact, product category, SKU, and timestamps for when the product was viewed and when the data was imported. This data can be used to analyze user engagement with products, track session behaviors, and understand referral sources.

Column name	Type
contactId	STRING
category	STRING
sku	STRING
time	TIMESTAMP
session	STRING
newsession	BOOLEAN
useragent	STRING
referred	STRING
url	STRING
tenantId	STRING
ImportDateTime	TIMESTAMP

PromotionLatest

Tenant column:tenantId
Description: The table contains information about promotions, including their identifiers, names, types, and validity periods. It also tracks changes made to promotions, such as creation, modification, and deletion dates. This data can be used for analyzing promotion effectiveness, managing promotional campaigns, and integrating with external systems.

Column name	Type
promotionId	STRING
promotionName	STRING
promotionType	STRING
validFromDateTime	TIMESTAMP
validToDateTime	TIMESTAMP
externalPromotionCode	STRING
externalId	STRING
createdOnDateTime	TIMESTAMP
changedOnDateTime	TIMESTAMP
deletedOnDateTime	TIMESTAMP
changeType	STRING
filename	STRING
biExportDate	TIMESTAMP
ImportDateTime	TIMESTAMP
tenantId	STRING
ImportDate	DATE
tenant_id	STRING

PromotionRecipientLatest

Tenant column:tenantId
Description: The table contains information about promotion recipients, including whether the promotion was used, where it was used, usage timestamps, validity period, value and value type, and receipt linkage.

Column name	Type
promotionRecipientId	STRING
promotionId	STRING
contactId	STRING
isUsed	STRING
usedInStore	STRING
usageDateTime	TIMESTAMP
validFromDateTime	TIMESTAMP
validToDateTime	TIMESTAMP
createdOnDateTime	TIMESTAMP
receiptExternalId	STRING
value	STRING
valueType	STRING
changeType	STRING
filename	STRING
biExportDate	TIMESTAMP
ImportDateTime	TIMESTAMP
tenantId	STRING
ImportDate	DATE
tenant_id	STRING

ReceiptItemsLatest

Tenant column:tenantId
Description: The table contains detailed information about receipt items from transactions. It includes identifiers for receipts, contacts, and stores, as well as transaction timestamps. Key data points include article details such as SKU, quantity purchased, pricing information, discounts, and tax percentages. This table can be used for analyzing sales performance, understanding customer purchasing behavior, and evaluating pricing strategies.

Column name	Type
receiptItemId	STRING
receiptId	STRING
contactId	STRING
storeId	STRING
transactionDateTime	TIMESTAMP
type	STRING
sku	STRING
articleNumber	STRING
quantity	INT
grossPaidPrice	DOUBLE
grossPaidPricePerUnit	DOUBLE
localPrice	DOUBLE
localCurrency	STRING
discounts	DOUBLE
discountPercent	DOUBLE
marginPercent	STRING
taxPercent	DOUBLE
articleName	STRING
articleGroup	STRING
articleSpare1	STRING
articleSpare2	STRING
articleSpare3	STRING
articleSpare4	STRING
articleSpare5	STRING
articleSpare6	STRING
articleSpare7	STRING
articleSpare8	STRING
articleSpare9	STRING
articleSpare10	STRING
articleDateSpare1	STRING
articleDateSpare2	STRING
articleDateSpare3	STRING
articleDateSpare4	STRING
articleDateSpare5	STRING
awardsBonus	BOOLEAN
changeType	STRING
filename	STRING
biExportDate	TIMESTAMP
ImportDateTime	TIMESTAMP
tenantId	STRING
ImportDate	DATE
transactionYearMonthDate	STRING
tenant_id	STRING

ReceiptsLatest

Tenant column:tenantId
Description: The table contains detailed information about receipts generated from transactions. It includes unique identifiers for receipts, contacts, and stores, as well as financial details such as total gross price, local price, and quantities of items purchased and returned. This data can be used for analyzing sales performance, tracking returns, and understanding customer purchasing behavior over time.

Column name	Type
receiptId	STRING
contactId	STRING
storeId	STRING
storeExternalId	STRING
receiptNumber	STRING
totalGrossPrice	DOUBLE
totalQuantity	INT
totalReturned	DOUBLE
totalLocalPrice	DOUBLE
exchangeRate	DOUBLE
localCurrency	STRING
numberOfItems	INT
numberOfPurchases	INT
numberOfReturns	INT
createdOnDateTime	TIMESTAMP
externalId	STRING
changeType	STRING
filename	STRING
biExportDate	TIMESTAMP
ImportDateTime	TIMESTAMP
tenantId	STRING
ImportDate	DATE
createdOnYearMonthDate	STRING
tenant_id	STRING

SavedSearchLatest

Tenant column:tenantId
Description: The table contains information about saved searches, including their identifiers, names, timestamps for creation, modification, deletion, and flags used for targeting audiences.

Column name	Type
savedSearchId	STRING
savedSearchName	STRING
createdOnDateTime	TIMESTAMP
changedOnDateTime	TIMESTAMP
deletedOnDateTime	TIMESTAMP
changeType	STRING
filename	STRING
biExportDate	TIMESTAMP
ImportDateTime	TIMESTAMP
tenantId	STRING
ImportDate	DATE
savedSearchIsTargetAudience	BOOLEAN
tenant_id	STRING

StoreLatest

Tenant column:tenantId
Description: The table contains information about stores, including their locations, status, and identifiers. It can be used to track store details such as whether they are active or deleted, analyze store distribution by city or country, and manage data imports and exports for business intelligence. This data is useful for operational reporting, location analysis, and understanding store performance.

Column name	Type
storeId	STRING
name	STRING
isDeleted	BOOLEAN
city	STRING
country	STRING
zipCode	STRING
street	STRING
region	STRING
externalId	STRING
type	STRING
active	BOOLEAN
changeType	STRING
filename	STRING
biExportDate	TIMESTAMP
ImportDateTime	TIMESTAMP
tenantId	STRING
ImportDate	DATE
tenant_id	STRING

TargetAudienceContactLatest

Tenant column:tenantId
Description: The table contains data related to target audience contacts, including their identifiers, associated saved searches, and timestamps for various events such as import and export. Use cases include tracking changes to target audience contacts, analyzing the timing of contact imports and exports, and managing audience segmentation based on the saved searches.

Column name	Type
targetAudienceContactId	STRING
savedSearchId	STRING
contactId	STRING
startDateTime	TIMESTAMP
endDateTime	TIMESTAMP
changeType	STRING
filename	STRING
biExportDate	TIMESTAMP
ImportDateTime	TIMESTAMP
tenantId	STRING
ImportDate	DATE
tenant_id	STRING