# Cc Aggr Promotion Sales Summary DMO

This DMO provides aggregate promotion sales summary metrics by site, promotion, campaign, coupon, and customer attributes.

## Object Properties

**Object API Name:** `CcAggrPromotionSalesSummary_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](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimsitedmo-dmo.md) `Id` field.
- **BusinessChannelId** has a FOREIGNKEY relationship with the [Cc Dim Business Channel DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimbusinesschanneldmo-dmo.md) `Id` field.
- **PromotionId** has a FOREIGNKEY relationship with the [Cc Dim Promotion DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimpromotiondmo-dmo.md) `Id` field.
- **CampaignId** has a FOREIGNKEY relationship with the [Cc Dim Campaign DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimcampaigndmo-dmo.md) `Id` field.
- **CouponId** has a FOREIGNKEY relationship with the [Cc Dim Coupon DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimcoupondmo-dmo.md) `Id` field.

## Fields

- [BusinessChannelId](#businesschannelid)
- [CampaignId](#campaignid)
- [cdp_sys_record_currency](#cdp_sys_record_currency)
- [CouponId](#couponid)
- [DataSourceId](#datasourceid)
- [DataSourceObjectId](#datasourceobjectid)
- [DeviceClassCode](#deviceclasscode)
- [InternalOrganizationId](#internalorganizationid)
- [IsFirstTimeBuyer](#isfirsttimebuyer)
- [IsRegistered](#isregistered)
- [IsShopperAgent](#isshopperagent)
- [KQ_BusinessChannelId](#kq_businesschannelid)
- [KQ_CampaignId](#kq_campaignid)
- [KQ_CouponId](#kq_couponid)
- [KQ_PromotionId](#kq_promotionid)
- [KQ_SiteId](#kq_siteid)
- [LocaleCode](#localecode)
- [NumberOfOrders](#numberoforders)
- [NumberOfPromotionUses](#numberofpromotionuses)
- [NumberOfUnits](#numberofunits)
- [NumberOrderUnits](#numberorderunits)
- [PromotionId](#promotionid)
- [SiteId](#siteid)
- [StandardDiscount](#standarddiscount)
- [StandardItemDiscount](#standarditemdiscount)
- [StandardOrderDiscount](#standardorderdiscount)
- [StandardOrderNet](#standardordernet)
- [StandardRevenue](#standardrevenue)
- [StandardShipping](#standardshipping)
- [StandardShippingDiscount](#standardshippingdiscount)
- [StandardShippingNet](#standardshippingnet)
- [StandardTax](#standardtax)
- [StandardTotalDiscount](#standardtotaldiscount)
- [SubmitDate](#submitdate)

### BusinessChannelId

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

### CampaignId

- **Field API Name:** `CampaignId__c`
- **Data Type:** DOUBLE
- **Description:** Foreign key to ccdw_dim_campaign.

### 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.

### CouponId

- **Field API Name:** `CouponId__c`
- **Data Type:** DOUBLE
- **Description:** Foreign key to ccdw_dim_coupon.

### 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_CampaignId

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

### KQ_CouponId

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

### KQ_PromotionId

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

### KQ_SiteId

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

### 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 involving the promotion.

### NumberOfPromotionUses

- **Field API Name:** `NumberOfPromotionUses__c`
- **Data Type:** DOUBLE
- **Description:** Number of times the promotion was used.

### NumberOfUnits

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

### NumberOrderUnits

- **Field API Name:** `NumberOrderUnits__c`
- **Data Type:** DOUBLE
- **Description:** Number of units associated with orders.

### PromotionId

- **Field API Name:** `PromotionId__c`
- **Data Type:** DOUBLE
- **Description:** Foreign key to ccdw_dim_promotion.

### SiteId

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

### StandardDiscount

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

### StandardItemDiscount

- **Field API Name:** `StandardItemDiscount__c`
- **Data Type:** DOUBLE
- **Description:** Item-level discount in standard currency from the promotion.

### StandardOrderDiscount

- **Field API Name:** `StandardOrderDiscount__c`
- **Data Type:** DOUBLE
- **Description:** Order-level discount in standard currency from the promotion.

### StandardOrderNet

- **Field API Name:** `StandardOrderNet__c`
- **Data Type:** DOUBLE
- **Description:** Net order value in standard currency after promotions.

### StandardRevenue

- **Field API Name:** `StandardRevenue__c`
- **Data Type:** DOUBLE
- **Description:** Total revenue involving the promotion. Aggregated from std_li_gross_merchandise_value.

### StandardShipping

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

### StandardShippingDiscount

- **Field API Name:** `StandardShippingDiscount__c`
- **Data Type:** DOUBLE
- **Description:** Shipping discount in standard currency from the promotion.

### StandardShippingNet

- **Field API Name:** `StandardShippingNet__c`
- **Data Type:** DOUBLE
- **Description:** Net shipping value in standard currency after promotions.

### StandardTax

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

### StandardTotalDiscount

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

### SubmitDate

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