Customer Summary¶

These entities represent individual master-customer records after the Customer Data Platform (CDP) deduplicated the raw child-customer data.

CUSTOMERSUMMARY

mastercustomerid

customersummary.mastercustomerid=transactionsummary.mastercustomerid

customersummary.mastercustomerid=mastercustomer.mastercustomerid

customersummary.mastercustomerid=
customerfirsttransactionproductcategory.mastercustomerid

customersummary.mastercustomerid=
customerlasttransactionproductcategory.mastercustomerid

customersummary.FirstPromoID=promotiontypesummary.id

customersummary.FirstOfflinePromoID=promotiontypesummary.id

customersummary.closeststoreid=organizationsummary.id

customersummary.primarystoreid=organizationsummary.id

Organization Summary¶

A list of sales organizations and their associated stores.

ORGANIZATIONSUMMARY

id

transactionsummary.organizationid=organizationsummary.id

Product Summary¶

A list of products available in the catalog.

PRODUCTSUMMARY

id

productsummary.id=transactionsummary.productid

Product Category Summary¶

A list of available product categories.

PRODUCTCATEGORYSUMMARY

id

productcategorysummary.id=productcategoryxref.productcategoryid

productcategorysummary.id=customerfirsttransaction
productcategory.productcategoryid

productcategorysummary.id=customerlasttransaction
productcategory.productcategoryid

productcategorysummary.id=event.productcategoryid

Promotion Type Summary¶

A list of online and offline marketing promotions that influenced transactions.

PROMOTIONTYPESUMMARY

id

promotiontypesummary.id=event.messageid

promotiontypesummary.id=customersummary.FirstPromoID

promotiontypesummary.id=transactionsummary.TransactionLastMarketingTouchID

promotiontypesummary.id=transactionsummary.TransactionLastOfflineMarketingTouchID

promotiontypesummary.id=transactionsummary.TransactionLastOffline
MarketingTouchIDHousehold

Time Summary¶

Fiscal calendar mapping for each calendar date enables any datetime attribute to join with the timesummary table to find the corresponding fiscal calendar date. The following are a few examples: 

TIMESUMMARY

id

TO_CHAR(timesummary.id)=TO_CHAR(transactionsummary.transactiontimestamp, ‘YYYYMMDD’)

TO_CHAR(timesummary.id)=TO_CHAR(transactionsummary.shipdate, ‘YYYYMMDD’)

TO_CHAR(timesummary.id)=TO_CHAR(customersummary.FirstTransactionDate, ‘YYYYMMDD’)

TO_CHAR(timesummary.id)=TO_CHAR(customersummary.LastTransactionDate, ‘YYYYMMDD’)

Transaction Summary¶

Line-level transaction records across all sales channels.

TRANSACTIONSUMMARY

mastercustomerid, customerid, organizationid, productid

transactionsummary.customerid=customer.id

transactionsummary.mastercustomerid=customersummary.mastercustomerid

transactionsummary.organizationid=organization.id

transactionsummary.organizationid=organizationsummary.id

transactionsummary.productid=productsummary.id