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 Id field.
• BusinessChannelId has a FOREIGNKEY relationship with the Cc Dim Business Channel DMO Id field.
• PromotionId has a FOREIGNKEY relationship with the Cc Dim Promotion DMO Id field.
• CampaignId has a FOREIGNKEY relationship with the Cc Dim Campaign DMO Id field.
• CouponId has a FOREIGNKEY relationship with the Cc Dim Coupon DMO Id field.

Fields

• BusinessChannelId
• CampaignId
• cdp_sys_record_currency
• CouponId
• DataSourceId
• DataSourceObjectId
• DeviceClassCode
• InternalOrganizationId
• IsFirstTimeBuyer
• IsRegistered
• IsShopperAgent
• KQ_BusinessChannelId
• KQ_CampaignId
• KQ_CouponId
• KQ_PromotionId
• KQ_SiteId
• LocaleCode
• NumberOfOrders
• NumberOfPromotionUses
• NumberOfUnits
• NumberOrderUnits
• PromotionId
• SiteId
• StandardDiscount
• StandardItemDiscount
• StandardOrderDiscount
• StandardOrderNet
• StandardRevenue
• StandardShipping
• StandardShippingDiscount
• StandardShippingNet
• StandardTax
• StandardTotalDiscount
• 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.