Loading...

Summary Entities

The following tables outline the join relationships among Summary Entities within the system:

Customer Summary

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

Entity NameKey  JoinJoin

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.

Entity NameKey JoinJoin

ORGANIZATIONSUMMARY

id

transactionsummary.organizationid=organizationsummary.id

Product Summary

A list of products available in the catalog.

Entity NameKey JoinJoin

PRODUCTSUMMARY

id

productsummary.id=transactionsummary.productid

Product Category Summary

A list of available product categories.

Entity NameKey JoinJoin

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.

Entity NameKey JoinJoin

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: 

Entity NameKey JoinJoin

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.

Entity NameKey JoinJoin

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

Did not find what you were looking for?

If this content did not answer your questions, try searching or contacting our support team for further assistance.

Back to Section navigation