Acquia CDP

Available entities for Data Export

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.

  • All records (full export)

mastercustomer

Cross-reference between customer and customersummary entities. Multiple customer records could roll up to one master-customer record.

  • All records (full export)

customer

Individual customer records before CDP’s de-duping. customers.

  • All records (full export)

  • Records modified since previous export (incremental export)

  • Records modified after a specific date

  • Records modified between two specific dates

address

Address records for customers.

  • All records (full export)

  • Records modified since previous export (incremental export)

  • Records modified after a specific date

  • Records modified between two specific dates

customeraddressxref

Cross-reference between customer and address entities.

  • All records (full export)

  • Records modified since previous export (incremental export)

  • Records modified after a specific date

  • Records modified between two specific dates

product

List of products.

  • All records (full export)

  • Records modified since previous export (incremental export)

  • Records modified after a specific date

  • Records modified between two specific dates

productcategory

List of product categories.

  • All records (full export)

  • Records modified since previous export (incremental export)

  • Records modified after a specific date

  • Records modified between two specific dates

productcategoryxref

Cross-reference between product and productcategory entities.

  • All records (full export)

  • Records modified since previous export (incremental export)

  • Records modified after a specific date

  • Records modified between two specific dates

transaction

Transaction records at the header-level across all sales channels.

  • All records (full export)

  • Records modified since previous export (incremental export)

  • Records modified after a specific date

  • Records modified between two specific dates

transactionitem

Transaction records at the line-level across all sales channels.

  • All records (full export)

  • Records modified since previous export (incremental export)

  • Records modified after a specific date

  • Records modified between two specific dates

any client-specific entities

Any client-specific entities configured for your account.

  • All records (full export)

  • Records modified since previous export (incremental export)

  • Records modified after a specific date

  • Records modified between two specific dates

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