DoubleOptInMOKeyword
Defines mobile-originated (MO) keywords used for double opt-in workflows in Salesforce Marketing Cloud. Each record specifies the keyword that allows mobile users to confirm subscriptions through a two-step consent process. This view ensures compliance with opt-in regulations and supports secure subscriber management.
View-Specific Information
Select
The connector uses the Salesforce Marketing Cloud APIs to process the following WHERE clause operators for all but date-time values: =, !=, <>, >, >=, <, <=, IN. For date-time values, only > and < are supported. The connector processes other filters client-side within the connector.
For example, the following (but not only) queries are processed server side:
SELECT * FROM DoubleOptInMOKeyword WHERE CreatedDate > '2017/01/25'
Columns
| Name | Type | Description |
| Client_ID | Int | The unique identifier (Id) of the client associated with this mobile-originated (MO) keyword configuration. |
| CreatedDate | Datetime | The read-only date and time when this MO keyword configuration was created. This value is system-controlled. |
| ModifiedDate | Datetime | The date and time when this MO keyword configuration was last modified. This value allows administrators to track update history. |
| CustomerKey | String | The user-supplied unique Id for this MO keyword configuration within its object type. |
| IsDefaultKeyword | Bool | Returns a value of 'true' when this MO keyword configuration functions as the default Short Message System (SMS) keyword handling rule for the account. It returns a value of 'false' when another keyword configuration governs default SMS keyword behavior. |
| DefaultPublication_ID | Int | The read-only Id for the default publication list that is associated with this MO keyword workflow. |
| InvalidPublicationMessage | String | The message that is sent to a subscriber who attempts to subscribe or unsubscribe from a publication list that is not valid for this double opt-in workflow. |
| InvalidResponseMessage | String | The message that is sent to a subscriber who responds with input that is not recognized as a valid action or confirmation during the double opt-in process. |
| MissingPublicationMessage | String | The message that is sent to a subscriber when the system cannot determine which publication list the subscriber intends to join or leave during the double opt-in process. This message prompts the subscriber to specify a valid publication list so the request can continue. |
| NeedPublicationMessage | String | The message that is sent to a subscriber whose response does not indicate which publication list they intend to join or leave. This message prompts the subscriber to specify a valid list. |
| PromptMessage | String | The message that is sent to the subscriber as part of the double opt-in process to request a confirming response. |
| SuccessMessage | String | The SMS message that is sent to the subscriber after a triggered email send succeeds as part of the double opt-in workflow. |
| UnexpectedErrorMessage | String | The message that is sent to the subscriber when an unexpected system error interrupts the double opt-in process. |
| ValidPublications | String | The list of publication identifiers that are permitted for use with this double opt-in configuration. These values determine which lists subscribers can confirm. |
| ValidResponses | String | The set of acceptable subscriber responses that complete the double opt-in process. These values determine how the system interprets subscriber confirmation actions. |