Attribute Name | Data Type | Description |
|---|---|---|
ID | string | The unique identifier of the product. |
TenantID | int | The unique identifier of the client environment. |
SourceSystemID | string | The unique identifier of the upstream source system. |
SourceProductNumber | string | The unique identifier of the product in your data. |
FirstTransactionDate | timestamp | The date when the first transaction occurred. |
LastTransactionDate | timestamp | The date when the last transaction occurred. |
TotalTransactionCount | int | The total number of transactions that the customer made in their lifetime. |
TotalTransactionCount_Last12Months | int | The total number of transactions that the customer made in the last 12 months. |
TotalTransactionCount_Last13_24months | int | The total number of transactions that the customer made between the last 13 and 24 months. |
TotalRevenue | string | The total revenue from the transactions that the customer made in their lifetime. |
TotalRevenue_Last12Months | string | The total revenue from the transactions that the customer made in the last 12 months. |
TotalRevenue_13_24Months | string | The total revenue from the transactions that the customer made between the last 13 and 24 months. |
TotalRevenueDecile_Last12Months | int | The 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_24Months | int | The 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. |
QuantitySold | int | The total number of products sold. |
QuantitySold_last12Months | int | The total number of products sold in the last 12 months. |
QuantitySold_13_24Months | int | The total number of products sold between the last 13 and 24 months. |
Name | string | The name of the product. |
Description | string | The description of the product. |
ProductURL | string | The URL of the product. If your SKU level product does not have a specific URL, use the parent URL of the product. |
ImageURL | string | The image URL of the product that links it to only the image and not the page where the image appears. |
ParentProductID | string | The unique identifier of the ParentProduct. It represents the same value with ParentProductNumber in default CDP configuration. |
ParentProductNumber | string | If 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. |
Status | string | The status of the product, Active or Inactive. |
BundleNumber | string | The 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. |
BrandName | string | The name of the brand. A SourceBrandNumber can only have one unique BrandName. |
SourceBrandNumber | string | The identifier of the brand. This can be the manufacturer’s brand or the store at which the product was sold. |
MSRP | string | This is the Manufacturer’s Suggested Retail Price (MSRP) of the product. |
ListPrice | string | This 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. |
SalePrice | string | This 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. |
SaleCondition | string | This is the sale condition of the product. For example, new, used, or refurbished. |
Availability | string | The availability of the product. The possible values are: in stock, available, available for order, and preorder. |
AvailableQty | int | The number of products that are currently in stock. |
Size | string | The size of the product. |
Color | string | The color of the product. |
Weight | string | The weight of the product. |
DateCreated | timestamp | The date when the product record was created. |
DateModified | timestamp | The date when the product record was modified. |
DeleteFlag | boolean | This flag indicates if a product is deleted. The values are:
|
RowCreated | timestamp | The time when the product category record was created. |
RowModified | timestamp | The time when the product category record was last modified. |
Batch | string | When the product category was last modified in CDP. This is used for bucketing the ingestion of records into CDP. |
Source | string | The source (file name) of the data which is auto-assigned by CDP. |
RowProcessed | timestamp | The time when the product category was last processed by CDP. |