Information for: DEVELOPERS   PARTNERS   SUPPORT

Looking for something?

List of available Entities

All attributes from the following entities can be included in Data Export. All data is exported after it has been cleansed via 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.
  1. All records (full export)
mastercustomer Cross-reference between customer and customersummary entities. Multiple customer records could roll up to one master-customer record.
  1. All records (full export)
customer Individual customer records before CDP’s de-duping. customers.
  1. All records (full export)
  2. Records modified since previous export (incremental export)
  3. Records modified after a specific date
  4. Records modified between two specific dates
address Address records for customers.
  1. All records (full export)
  2. Records modified since previous export (incremental export)
  3. Records modified after a specific date
  4. Records modified between two specific dates
customeraddressxref Cross-reference between customer and address entities.
  1. All records (full export)
  2. Records modified since previous export (incremental export)
  3. Records modified after a specific date
  4. Records modified between two specific dates
product List of products.
  1. All records (full export)
  2. Records modified since previous export (incremental export)
  3. Records modified after a specific date
  4. Records modified between two specific dates
productcategory List of product categories.
  1. All records (full export)
  2. Records modified since previous export (incremental export)
  3. Records modified after a specific date
  4. Records modified between two specific dates
productcategoryxref Cross-reference between product and productcategory entities.
  1. All records (full export)
  2. Records modified since previous export (incremental export)
  3. Records modified after a specific date
  4. Records modified between two specific dates
transaction Transaction records at the header-level across all sales channels.
  1. All records (full export)
  2. Records modified since previous export (incremental export)
  3. Records modified after a specific date
  4. Records modified between two specific dates
transactionitem Transaction records at the line-level across all sales channels.
  1. All records (full export)
  2. Records modified since previous export (incremental export)
  3. Records modified after a specific date
  4. Records modified between two specific dates
any client-specific entities Any client-specific entities configured for your account.
  1. All records (full export)
  2. Records modified since previous export (incremental export)
  3. Records modified after a specific date
  4. Records modified between two specific dates

JOIN and FK relationships between entities

  1. customersummary.mastercustomerid = mastercustomer.mastercustomerid
  2. mastercustomer.customerid = customer.id
  3. customer.id = customeraddressxref.customerid
  4. customeraddressxref.addressid = address.id
  5. product.id = productcategoryxref.productid
  6. productcategoryxref.productcategoryid = productcategory.id
  7. transaction.id = transactionitem.transactionid
  8. transaction.customerid = customer.id
  9. transactionitem.productid = product.id

53 State Street, 10th Floor
Boston, MA 02109
United States
Phone: 888-922-7842