---
schema_version: "1"
id: 57d286ee1ff1af7a5a45e6e1f88497ea7f24fc09c6aef3dfe3d7f5eeca315a41
title: Cc Aggr Product Sales Summary DMO
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-dmo-mapping/guides/std_dmos/c360dm-si-ccaggrproductsalessummarydmo-dmo.md
canonical_url: https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccaggrproductsalessummarydmo-dmo.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: f312a9d4c0d89ecc1b3822e8f42d17deb09b768da947a9ad3310d64f8a7e3acc
products:
  - Data 360 DMO and Mapping Guide
  - Data 360 Developer Documentation
---
# Cc Aggr Product Sales Summary DMO

This DMO provides aggregate product sales summary metrics by site, SKU, date, and customer attributes.

## Object Properties

**Object API Name:** `CcAggrProductSalesSummary_std__dlm`  
**Category:** Unassigned  
**Availability:** Available in 260 and later versions  
**Primary Key Field:** SiteId  

## Relationships

- **SiteId** has a FOREIGNKEY relationship with the [Cc Dim Site DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimsitedmo-dmo.md) `Id` field.
- **SkuId** has a FOREIGNKEY relationship with the [Cc Dim Product DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimproductdmo-dmo.md) `Id` field.
- **BusinessChannelId** has a FOREIGNKEY relationship with the [Cc Dim Business Channel DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimbusinesschanneldmo-dmo.md) `Id` field.
- **ProductId** has a FOREIGNKEY relationship with the [Cc Dim Product DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimproductdmo-dmo.md) `Id` field.


## Fields

- [BusinessChannelId](#businesschannelid)
- [cdp_sys_record_currency](#cdp_sys_record_currency)
- [DataSourceId](#datasourceid)
- [DataSourceObjectId](#datasourceobjectid)
- [DeviceClassCode](#deviceclasscode)
- [InternalOrganizationId](#internalorganizationid)
- [IsFirstTimeBuyer](#isfirsttimebuyer)
- [IsRegistered](#isregistered)
- [IsShopperAgent](#isshopperagent)
- [KQ_BusinessChannelId](#kq_businesschannelid)
- [KQ_ProductId](#kq_productid)
- [KQ_SiteId](#kq_siteid)
- [KQ_SkuId](#kq_skuid)
- [LocaleCode](#localecode)
- [NumberOfOrders](#numberoforders)
- [NumberOfUnits](#numberofunits)
- [ProductId](#productid)
- [SiteId](#siteid)
- [SkuId](#skuid)
- [StandardPromotionalDiscount](#standardpromotionaldiscount)
- [StandardRevenue](#standardrevenue)
- [StandardShipping](#standardshipping)
- [StandardTax](#standardtax)
- [StandardTotalDiscount](#standardtotaldiscount)
- [SubmitDate](#submitdate)

### BusinessChannelId

- **Field API Name:** `BusinessChannelId__c`
- **Data Type:** DOUBLE
- **Description:** Foreign key to ccdw_dim_business_channel.

### cdp_sys_record_currency

- **Field API Name:** `cdp_sys_record_currency__c`
- **Data Type:** TEXT
- **Description:** System-generated metadata field that stores a 3-letter ISO currency code.

### DataSourceId

- **Field API Name:** `DataSourceId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### DataSourceObjectId

- **Field API Name:** `DataSourceObjectId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### DeviceClassCode

- **Field API Name:** `DeviceClassCode__c`
- **Data Type:** TEXT
- **Description:** Code for the device classification.

### InternalOrganizationId

- **Field API Name:** `InternalOrganizationId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### IsFirstTimeBuyer

- **Field API Name:** `IsFirstTimeBuyer__c`
- **Data Type:** BOOLEAN
- **Description:** Boolean indicating if the customer was a first-time buyer.

### IsRegistered

- **Field API Name:** `IsRegistered__c`
- **Data Type:** BOOLEAN
- **Description:** Boolean indicating if the customer was registered.

### IsShopperAgent

- **Field API Name:** `IsShopperAgent__c`
- **Data Type:** BOOLEAN
- **Description:** Boolean indicating whether the activity was generated by a Shopper Agent.

### KQ_BusinessChannelId

- **Field API Name:** `KQ_BusinessChannelId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for BusinessChannelId

### KQ_ProductId

- **Field API Name:** `KQ_ProductId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for ProductId

### KQ_SiteId

- **Field API Name:** `KQ_SiteId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for SiteId

### KQ_SkuId

- **Field API Name:** `KQ_SkuId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for SkuId

### LocaleCode

- **Field API Name:** `LocaleCode__c`
- **Data Type:** TEXT
- **Description:** Abbreviated locale code.

### NumberOfOrders

- **Field API Name:** `NumberOfOrders__c`
- **Data Type:** DOUBLE
- **Description:** Total number of orders.

### NumberOfUnits

- **Field API Name:** `NumberOfUnits__c`
- **Data Type:** DOUBLE
- **Description:** Total number of units sold.

### ProductId

- **Field API Name:** `ProductId__c`
- **Data Type:** DOUBLE
- **Description:** Foreign key to ccdw_dim_product for the product.

### SiteId

- **Field API Name:** `SiteId__c`
- **Data Type:** DOUBLE
- **Description:** Foreign key to ccdw_dim_site.

### SkuId

- **Field API Name:** `SkuId__c`
- **Data Type:** DOUBLE
- **Description:** Foreign key to ccdw_dim_product for the SKU.

### StandardPromotionalDiscount

- **Field API Name:** `StandardPromotionalDiscount__c`
- **Data Type:** DOUBLE
- **Description:** Total promotional discount in standard currency.

### StandardRevenue

- **Field API Name:** `StandardRevenue__c`
- **Data Type:** DOUBLE
- **Description:** Total revenue in standard currency. Aggregated from std_li_gross_merchandise_value.

### StandardShipping

- **Field API Name:** `StandardShipping__c`
- **Data Type:** DOUBLE
- **Description:** Total shipping cost in standard currency.

### StandardTax

- **Field API Name:** `StandardTax__c`
- **Data Type:** DOUBLE
- **Description:** Total tax in standard currency.

### StandardTotalDiscount

- **Field API Name:** `StandardTotalDiscount__c`
- **Data Type:** DOUBLE
- **Description:** Total discount in standard currency.

### SubmitDate

- **Field API Name:** `SubmitDate__c`
- **Data Type:** DATEONLY
- **Description:** Date of the sales submission.