# Email Send Time Optimization DMO

## Object Properties

**Object API Name:** `ssot__EmailSendTimeOptimization__dlm`\
**Category:** Unassigned\
**Availability:** Available in 254 and later versions\
**Primary Key Field:** Id

## Relationships

- **ContactPointEmailId** has a FOREIGNKEY relationship with the [Contact Point Email DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-contactpointemaildmo-dmo.md) `Id` field.

## Fields

- [cdp_sys_record_currency](#cdp_sys_record_currency)
- [ContactPointEmailId](#contactpointemailid)
- [CreatedDate](#createddate)
- [DataSourceId](#datasourceid)
- [DataSourceObjectId](#datasourceobjectid)
- [HourlyScoresByWeekList](#hourlyscoresbyweeklist)
- [Id](#id)
- [InternalOrganizationId](#internalorganizationid)
- [KQ_ContactPointEmailId](#kq_contactpointemailid)
- [KQ_Id](#kq_id)
- [WeekHourOffsetNumber](#weekhouroffsetnumber)

### cdp_sys_record_currency

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

### ContactPointEmailId

- **Field API Name:** `ssot__ContactPointEmailId__c`
- **Data Type:** TEXT
- **Description:** Foreign Key to Contact Point Email Table.

### CreatedDate

- **Field API Name:** `ssot__CreatedDate__c`
- **Data Type:** DATETIME
- **Description:** The date and time when this record was created.

### DataSourceId

- **Field API Name:** `ssot__DataSourceId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### DataSourceObjectId

- **Field API Name:** `ssot__DataSourceObjectId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### HourlyScoresByWeekList

- **Field API Name:** `ssot__HourlyScoresByWeekList__c`
- **Data Type:** TEXT
- **Description:** csv strings with 168 weekly hour score in floats.

### Id

- **Field API Name:** `ssot__Id__c`
- **Data Type:** TEXT
- **Description:** Primary Key: unique identifier.

### InternalOrganizationId

- **Field API Name:** `ssot__InternalOrganizationId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### KQ_ContactPointEmailId

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

### KQ_Id

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

### WeekHourOffsetNumber

- **Field API Name:** `ssot__WeekHourOffsetNumber__c`
- **Data Type:** DOUBLE
- **Description:** Optimal time of week to send email to this contact point based on predicted engagment, expressed as an offset 0 to 167 from the first hour of the week.
