Loading...

productsummary

Attribute NameData TypeDescription
IDstringThe unique identifier of the product.
TenantIDintThe unique identifier of the client environment.
SourceSystemIDstringThe unique identifier of the upstream source system.
SourceProductNumberstringThe unique identifier of the product in your data.
FirstTransactionDatetimestampThe date when the first transaction occurred.
LastTransactionDatetimestampThe date when the last transaction occurred.
TotalTransactionCountintThe total number of transactions that the customer made in their lifetime.
TotalTransactionCount_Last12MonthsintThe total number of transactions that the customer made in the last 12 months.
TotalTransactionCount_Last13_24monthsintThe total number of transactions that the customer made between the last 13 and 24 months.
TotalRevenuestringThe total revenue from the transactions that the customer made in their lifetime.
TotalRevenue_Last12MonthsstringThe total revenue from the transactions that the customer made in the last 12 months.
TotalRevenue_13_24MonthsstringThe total revenue from the transactions that the customer made between the last 13 and 24 months.
TotalRevenueDecile_Last12MonthsintThe total revenue from the transactions that the customer made in the last 12 months, grouped by deciles. Decile 1 being the biggest spenders and decile 10 being the lowest spenders.
TotalRevenueDecile_13_24MonthsintThe total revenue from the transactions that the customer made between the last 13 and 24 months, grouped by deciles. Decile 1 being the biggest spenders and decile 10 being the lowest spenders.
QuantitySoldintThe total number of products sold.
QuantitySold_last12MonthsintThe total number of products sold in the last 12 months.
QuantitySold_13_24MonthsintThe total number of products sold between the last 13 and 24 months.
NamestringThe name of the product.
DescriptionstringThe description of the product.
ProductURLstringThe URL of the product. If your SKU level product does not have a specific URL, use the parent URL of the product.
ImageURLstringThe image URL of the product that links it to only the image and not the page where the image appears.
ParentProductIDstringThe unique identifier of the ParentProduct. It represents the same value with ParentProductNumber in default CDP configuration.
ParentProductNumberstringIf the record is for a SKU that is a variation of a parent product and the product shares a single web page with other children-SKU of the same parent, populate the SourceProductNumber of the parent product.
StatusstringThe status of the product, Active or Inactive.
BundleNumberstringThe bundle number or code of a product. It consist of a numeric code and product’s serial number. With BundleNumber, you can register the product.
BrandNamestringThe name of the brand. A SourceBrandNumber can only have one unique BrandName.
SourceBrandNumberstringThe identifier of the brand. This can be the manufacturer’s brand or the store at which the product was sold.
MSRPstringThis is the Manufacturer’s Suggested Retail Price (MSRP) of the product.
ListPricestringThis is the price that you list on the website and show to your customers. This price can be included in any dynamic content that contains the price.
SalePricestringThis is the price that includes any special, temporary discount that you provide to the customer. For example, holiday sales. If there are no ongoing sales, the SalePrice is equal to the ListPrice.
SaleConditionstringThis is the sale condition of the product. For example, new, used, or refurbished.
AvailabilitystringThe availability of the product. The possible values are: in stock, available, available for order, and preorder.
AvailableQtyintThe number of products that are currently in stock.
SizestringThe size of the product.
ColorstringThe color of the product.
WeightstringThe weight of the product.
DateCreatedtimestampThe date when the product record was created.
DateModifiedtimestampThe date when the product record was modified.
DeleteFlagboolean

This flag indicates if a product is deleted. The values are:

  • True when an address is deleted.
  • False or Null when an address is not deleted.
RowCreatedtimestampThe time when the product category record was created.
RowModifiedtimestampThe time when the product category record was last modified.
BatchstringWhen the product category was last modified in CDP. This is used for bucketing the ingestion of records into CDP.
SourcestringThe source (file name) of the data which is auto-assigned by CDP.
RowProcessedtimestampThe time when the product category was last processed by CDP.

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