SMSSharedKeyword
Contains information used to request or manage shared Short Message Service (SMS) keywords in Salesforce Marketing Cloud. Shared keywords allow multiple accounts or business units to use the same keyword within defined boundaries. This view supports keyword governance and provisioning.
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 SMSSharedKeyword WHERE Client_ID = 123 SELECT * FROM SMSSharedKeyword WHERE Client_ID IN (123, 456) SELECT * FROM SMSSharedKeyword WHERE CreatedDate > '2017/01/25'
Columns
| Name | Type | Description |
| CreatedDate | Datetime | Specifies the read-only date and time of the object's creation. This value is generated automatically by the system to establish when the shared keyword record was first added. |
| ModifiedDate | Datetime | Indicates the last time object information was modified. This value reflects system-tracked updates that are applied to the shared keyword record. |
| Client_ID | Long | Specifies the unique identifier (Id) of the client. This Id associates the shared keyword record with the correct Marketing Cloud account context. |
| SharedKeyword | String | Specifiesthe Short Message Service (SMS) keyword that is requested for use in an account. This keyword represents the text string that subscribers send to initiate a mobile interaction using a shared short code. |
| RequestDate | Datetime | Specifies the date when the request for an SMS shared keyword was made. This date establishes when the keyword entered the approval workflow. |
| EffectiveDate | Datetime | Specifies the date when an SMS shared keyword becomes active for use. This date determines when the keyword can begin receiving and processing subscriber messages. |
| ExpireDate | Datetime | Specifies the date when an SMS shared keyword stops being active for use. This date marks the point at which the keyword no longer accepts inbound message traffic. |
| ReturnToPoolDate | Datetime | Specifies the date when an expired SMS keyword becomes available to be reassigned for different use on a shared short code. This date supports lifecycle management of shared keyword resources. |
| ShortCode | String | Specifies the short code for which an SMS keyword was requested. This short code represents the numeric messaging address that is associated with the SMS interaction. |