Address

A list of address records associated with child-customers.

ADDRESS

id

address.id=customeraddressxref.addressid

Customer

Records of individual child-customers prior to the deduplication process by CDP.

CUSTOMER

id

customer.id=mastercustomer.customerid

customer.id=transactionsummary.customerid

customer.id=event.customerid

customer.id=customeraddressxref.customerid

Dispatch

An organized structure that captures and maintains all system event activities related to an upstream source system of CDP. These dispatch activities aim to reconcile marketing campaigns with specific linked messages.

DISPATCH

id,campaignid

dispatch.id=message.dispatchid

dispatch.campaignid=campaign.id

Campaign

List of all campaigns for your tenant, linked to dispatch records.

CAMPAIGN

id

campaign.id=dispatch.campaignid

Event

A complete list of all customer events for your tenant.

EVENT

customerid, productid, productcategoryid, transactionid, messageid, organizationid

event.customerid=customer.id

event.customerid=mastercustomer.customerid

event.productid=product.id

event.productcategoryid=productcategory.id

event.transactionid=transaction.id
event.messageid=message.id

event.organizationid=organization.id

Master Customer

This cross-reference links child-customer records to master-customer records to allow multiple child-customer records to aggregate under one master-customer record.

MASTERCUSTOMER

mastercustomerid or customerid

mastercustomer.mastercustomerid=customersummary.mastercustomerid

mastercustomer.customerid=customer.id

mastercustomer.mastercustomerid=transactionsummary.mastercustomerid

mastercustomer.customerid=customeraddressxref.customerid

mastercustomer.customerid=event.customerid

Message

This cross-reference links child-customer records to master-customer records to allow multiple child-customer records to aggregate under one master-customer record.

MESSAGE

id, dispatchid

message.id=event.messageid

message.dispatchid=dispatch.id

Organization

The records represent individual child-customers prior to the CDP deduplication process.

ORGANIZATION

id

transaction.organizationid=organization.id

transactionitem.organization.id=organization.id

Payment Method

This entity represents various payment methods and their associations with transaction records.

PAYMENTMETHOD

id

transactionpaymentmethodxref.paymentmethodid=
paymentmethod.id

Product

A list of products that have not been deduplicated with respect to transaction activities and customer data.

PRODUCT

id

product.id=transactionitem.productid

product.id=productcategoryxref.productid

Product Category

A list of product categories that have not been deduplicated in relation to transaction activities, product hierarchy, and customer data.

Entity Name

Key Join

Join

PRODUCTCATEGORY

id

productcategory.id=productcategoryxref.productcategoryid

productcategory.id=customerfirsttransactionproductcategory.productcategoryid

productcategory.id=customerlasttransactionproductcategory.productcategoryid

productcategory.id=event.productcategoryid

Transaction

A list of individual transaction records before deduplication.

TRANSACTION

id, customerid, organizationid

transaction.customerid=customer.id

transaction.id=transactionitem.transactionid

transaction.organizationid = organization.id

transaction.id = transactionmessagexref.transactionid

Transaction Item

A list of individual transaction items before deduplication.

TRANSACTIONITEM

id, productid, organizationid

transactionitem.productid = product.id

transactionitem.organizationid = organization.id

transactionitem.transactionid=transaction.id

transactionitemmessagexref.transactionitemid=transactionitem.id

transactionitempromotionxref.transactionitemid=transactionitem.id