productsummary | Interactive Queries | Acquia Product Documentation

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: True when an address is deleted. False or Null when an address is not deleted.
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.