All attributes from the following entities can be included in Data Export. All data is exported after it is cleansed through Customer Data Platform (CDP)’s processing.
Entity Name | Entity Description | Available Export Types |
|---|---|---|
customersummary | Individual master-customer records after CDP’s de-duping of raw customers. |
|
mastercustomer | Cross-reference between customer and customersummary entities. Multiple customer records could roll up to one master-customer record. |
|
customer | Individual customer records before CDP’s de-duping. customers. |
|
address | Address records for customers. |
|
customeraddressxref | Cross-reference between customer and address entities. |
|
product | List of products. |
|
productcategory | List of product categories. |
|
productcategoryxref | Cross-reference between product and productcategory entities. |
|
transaction | Transaction records at the header-level across all sales channels. |
|
transactionitem | Transaction records at the line-level across all sales channels. |
|
any client-specific entities | Any client-specific entities configured for your account. |
|
JOIN and FK relationships between entities
customersummary.mastercustomerid = mastercustomer.mastercustomerid
mastercustomer.customerid = customer.id
customer.id = customeraddressxref.customerid
customeraddressxref.addressid = address.id
product.id = productcategoryxref.productid
productcategoryxref.productcategoryid = productcategory.id
transaction.id = transactionitem.transactionid
transaction.customerid = customer.id
transactionitem.productid = product.id