Loading...

Non-Summary Entities

 

The following tables outline the join relationships among Non-Summary Entities in the system:

Address

A list of address records associated with child-customers.

Entity NameKey JoinJoin

ADDRESS

id

address.id=customeraddressxref.addressid

Customer

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

Entity NameKey JoinJoin

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.

Entity NameKey JoinJoin

DISPATCH

id,campaignid

dispatch.id=message.dispatchid

dispatch.campaignid=campaign.id

Campaign

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

Entity NameKey JoinJoin

CAMPAIGN

id

campaign.id=dispatch.campaignid

Event

A complete list of all customer events for your tenant.

Entity NameKey JoinJoin

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.

Entity NameKey JoinJoin

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.

Entity NameKey JoinJoin

MESSAGE

id, dispatchid

message.id=event.messageid

message.dispatchid=dispatch.id

Organization

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

Entity NameKey JoinJoin

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.

Entity NameKey JoinJoin

PAYMENTMETHOD

id

transactionpaymentmethodxref.paymentmethodid=
paymentmethod.id

Product

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

Entity NameKey JoinJoin

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.

Entity NameKey JoinJoin

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.

Entity NameKey JoinJoin

TRANSACTIONITEM

id, productid, organizationid

transactionitem.productid = product.id

transactionitem.organizationid = organization.id

transactionitem.transactionid=transaction.id

transactionitemmessagexref.transactionitemid=transactionitem.id

transactionitempromotionxref.transactionitemid=transactionitem.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