Cc Aggr Search Query DMO

Aggregate search query analytics data.

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

• SiteId has a FOREIGNKEY relationship with the Cc Dim Site DMO Id field.

• cdp_sys_record_currency
• DataSourceId
• DataSourceObjectId
• DeviceClassCode
• InternalOrganizationId
• IsRegistered
• LocaleCode
• NumberOfResults
• NumberOfSearchesWithoutResults
• NumberOfSearchesWithResults
• NumOfVisitsWithoutSearchResults
• NumOfVisitsWithSearchResults
• Query
• SearchDate
• SiteId

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

• Field API Name: std__DataSourceId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__DataSourceObjectId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__DeviceClassCode__c
• Data Type: TEXT
• Description: Code for the device classification.

• Field API Name: std__InternalOrganizationId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__IsRegistered__c
• Data Type: BOOLEAN
• Description: Boolean indicating if the customer was registered.

• Field API Name: std__LocaleCode__c
• Data Type: TEXT
• Description: Abbreviated locale code.

• Field API Name: std__NumberOfResults__c
• Data Type: DOUBLE
• Description: Total number of search results returned.

• Field API Name: std__NumberOfSearchesWithoutResults__c
• Data Type: DOUBLE
• Description: Number of searches that yielded no results.

• Field API Name: std__NumberOfSearchesWithResults__c
• Data Type: DOUBLE
• Description: Number of searches that yielded results.

• Field API Name: std__NumOfVisitsWithoutSearchResults__c
• Data Type: DOUBLE
• Description: Number of visits that included searches without results.

• Field API Name: std__NumOfVisitsWithSearchResults__c
• Data Type: DOUBLE
• Description: Number of visits that included searches with results.

• Field API Name: std__Query__c
• Data Type: TEXT
• Description: The actual search query entered.

• Field API Name: std__SearchDate__c
• Data Type: DATEONLY
• Description: Date of the sales submission.

• Field API Name: std__SiteId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_site.