Engage Purchases product

The Engage Purchases product provides a complete view of customer purchases and transactions. It brings together essential data such as store details, products, receipts, individual receipt items, and customer contact information. By using Engage Purchases, you can analyze purchasing behavior, manage transaction records efficiently, and maintain accurate customer data to support smarter business decisions.

Use cases:

• Analyzing customer purchasing behavior to identify trends, popular products, and peak buying periods
• Managing and tracking detailed transaction records for accurate reporting and financial insights
• Maintaining and using customer contact data to enable personalized and targeted communication

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

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

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

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