# Cc Aggr Search Query DMO

Aggregate search query analytics data.

## Object Properties

**Object API Name:** `CcAggrSearchQuery_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.

## Fields

- [cdp_sys_record_currency](#cdp_sys_record_currency)
- [DataSourceId](#datasourceid)
- [DataSourceObjectId](#datasourceobjectid)
- [DeviceClassCode](#deviceclasscode)
- [InternalOrganizationId](#internalorganizationid)
- [IsRegistered](#isregistered)
- [KQ_SiteId](#kq_siteid)
- [LocaleCode](#localecode)
- [NumberOfResults](#numberofresults)
- [NumberOfSearchesWithoutResults](#numberofsearcheswithoutresults)
- [NumberOfSearchesWithResults](#numberofsearcheswithresults)
- [NumOfVisitsWithoutSearchResults](#numofvisitswithoutsearchresults)
- [NumOfVisitsWithSearchResults](#numofvisitswithsearchresults)
- [Query](#query)
- [SearchDate](#searchdate)
- [SiteId](#siteid)

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

### IsRegistered

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

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

### NumberOfResults

- **Field API Name:** `NumberOfResults__c`
- **Data Type:** DOUBLE
- **Description:** Total number of search results returned.

### NumberOfSearchesWithoutResults

- **Field API Name:** `NumberOfSearchesWithoutResults__c`
- **Data Type:** DOUBLE
- **Description:** Number of searches that yielded no results.

### NumberOfSearchesWithResults

- **Field API Name:** `NumberOfSearchesWithResults__c`
- **Data Type:** DOUBLE
- **Description:** Number of searches that yielded results.

### NumOfVisitsWithoutSearchResults

- **Field API Name:** `NumOfVisitsWithoutSearchResults__c`
- **Data Type:** DOUBLE
- **Description:** Number of visits that included searches without results.

### NumOfVisitsWithSearchResults

- **Field API Name:** `NumOfVisitsWithSearchResults__c`
- **Data Type:** DOUBLE
- **Description:** Number of visits that included searches with results.

### Query

- **Field API Name:** `Query__c`
- **Data Type:** TEXT
- **Description:** The actual search query entered.

### SearchDate

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

### SiteId

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