Cc Aggr Visit User Agent DMO

This DMO aggregates visit data by user agent details, date, site, registration status, device class, and locale.

Object Properties

Object API Name: CcAggrVisitUserAgent_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.

Fields

• cdp_sys_record_currency
• DataSourceId
• DataSourceObjectId
• DeviceBrand
• DeviceClassCode
• DeviceMarketName
• InternalOrganizationId
• IsRegistered
• KQ_SiteId
• LocaleCode
• NumberOfVisits
• SiteId
• UaClass
• UaEngine
• UaFamily
• UaOs
• UaOsFamily
• VisitDate

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.

DeviceBrand

• Field API Name: DeviceBrand__c
• Data Type: TEXT
• Description: Device brand (from ccdw_dim_user_agent).

DeviceClassCode

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

DeviceMarketName

• Field API Name: DeviceMarketName__c
• Data Type: TEXT
• Description: Device market name (from ccdw_dim_user_agent).

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.

NumberOfVisits

• Field API Name: NumberOfVisits__c
• Data Type: DOUBLE
• Description: Total number of visits.

SiteId

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

UaClass

• Field API Name: UaClass__c
• Data Type: TEXT
• Description: User agent classification (from ccdw_dim_user_agent).

UaEngine

• Field API Name: UaEngine__c
• Data Type: TEXT
• Description: User agent engine (from ccdw_dim_user_agent).

UaFamily

• Field API Name: UaFamily__c
• Data Type: TEXT
• Description: User agent family (from ccdw_dim_user_agent).

UaOs

• Field API Name: UaOs__c
• Data Type: TEXT
• Description: Operating system (from ccdw_dim_user_agent).

UaOsFamily

• Field API Name: UaOsFamily__c
• Data Type: TEXT
• Description: Operating system family (from ccdw_dim_user_agent).

VisitDate

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