# Cc Aggr Product Co Buy DMO

This DMO identifies products that are frequently bought together.

## Object Properties

**Object API Name:** `CcAggrProductCoBuy_std__dlm`\
**Category:** Unassigned\
**Availability:** Available in 260 and later versions\
**Primary Key Field:** NaturalSiteIdentifier

## Relationships

- **ProductOneId** has a FOREIGNKEY relationship with the [Cc Dim Product DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimproductdmo-dmo.md) `Id` field.
- **ProductTwoId** has a FOREIGNKEY relationship with the [Cc Dim Product DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimproductdmo-dmo.md) `Id` field.

## Fields

- [cdp_sys_record_currency](#cdp_sys_record_currency)
- [DataSourceId](#datasourceid)
- [DataSourceObjectId](#datasourceobjectid)
- [DeviceClassCode](#deviceclasscode)
- [FrequencyCount](#frequencycount)
- [InternalOrganizationId](#internalorganizationid)
- [IsFirstTimeBuyer](#isfirsttimebuyer)
- [IsRegistered](#isregistered)
- [IsShopperAgent](#isshopperagent)
- [KQ_NaturalSiteIdentifier](#kq_naturalsiteidentifier)
- [KQ_ProductOneId](#kq_productoneid)
- [KQ_ProductTwoId](#kq_producttwoid)
- [LocaleCode](#localecode)
- [NaturalSiteIdentifier](#naturalsiteidentifier)
- [OrderChannel](#orderchannel)
- [ProductOneId](#productoneid)
- [ProductTwoId](#producttwoid)
- [StandardCoBuyRevenue](#standardcobuyrevenue)
- [SubmitDate](#submitdate)

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

### FrequencyCount

- **Field API Name:** `FrequencyCount__c`
- **Data Type:** DOUBLE
- **Description:** Number of times these two products were co-bought.

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

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

### KQ_ProductOneId

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

### KQ_ProductTwoId

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

### LocaleCode

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

### NaturalSiteIdentifier

- **Field API Name:** `NaturalSiteIdentifier__c`
- **Data Type:** TEXT
- **Description:** Normalized site ID (from ccdw_dim_site).

### OrderChannel

- **Field API Name:** `OrderChannel__c`
- **Data Type:** TEXT
- **Description:** Order channel (from ccdw_dim_business_channel).

### ProductOneId

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

### ProductTwoId

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

### StandardCoBuyRevenue

- **Field API Name:** `StandardCoBuyRevenue__c`
- **Data Type:** DOUBLE
- **Description:** Total revenue generated from co-bought products in standard currency.

### SubmitDate

- **Field API Name:** `SubmitDate__c`
- **Data Type:** DATETIME
- **Description:** Date of the co-buy event.
