Configurations for the Double Opt-in Feature

To work with the Double Opt-In functionality of SMS, Opt-In and Opt-Out keywords are available. In the initial SMS message sent to Contacts or Leads, organization requests the recipients to respond with a specific Opt-In or Opt-Out keyword. Based on the type of keyword in the response SMS from the recipients, the Double Opt-In(SMS) Property of the Contact and Lead is updated appropriately. For more information on working with the Double Opt-In feature, see Desktop Client Help.

Note: Keywords are words or phrases that an organization requests a recipient of an SMS message to type in the response SMS Message. The organization performs specific actions based on the keyword typed by the recipients.

The information about the Opt-In and Opt-Out keywords is stored in the following tables in the Main database:

•   tblSMSStopCommands - This table stores the details of the commands that are used to unsubscribe or Opt-Out from SMS services. By default, the following commands are available:

◦   STOP

◦   END

◦   CANCEL

◦   UNSUBSCRIBE

◦   QUIT

◦   STOP STOP

◦   STOP ALL

You can insert additional unsubscribe commands based on business requirements. For example, to insert No as the unsubscribe command, use the following SQL statement.

Exec sproc_AddSMSCommands 1, No

To configure another Opt-Out keyword, replace the text in red with the Opt-Out keyword in the above SQL statement.

Note: If you have integrated SMS with Clickatell, the Opt-Out keywords configured in CampusNexus CRM must match with the Opt-Out keywords provided by Clickatell.

•   tblSMSSubscribeCommands - This table stores the details of commands that are used to subscribe or Opt-In for SMS services. By default, the following commands are available:

◦   START

◦   OPT IN

You can insert additional subscribe commands based on the business requirements. For example, to insert Yes as the subscribe command, use the following SQL statement.

Exec sproc_AddSMSCommands 2, Yes

To configure another Opt-In keyword, replace the text in red with the Opt-In keyword in the above SQL statement.