CSAT (SMS & Email)
Summary
A common request in the industry is offering post call surveys. These allow the company to understand more about customers’ interactions with the company’s agents. This feedback helps to drive business decisions. Sharpen allows for the creation of SMS and Email post call CSAT surveys. This guide describes how to set up and configure each type.
Post Call SMS Surveys
CSAT Table Configuration
Navigate to Sharpen Admin → Configuration tab → Sharpen Tables
Locate the CSAT Table and click edit
Note: If the table does not exist, create a new table named CSAT that is type “other”
Ensure the CSAT Table has all the listed fields:
Field Name | API Name | Type |
|---|---|---|
queueID | queueid__api | Text Field |
Phone Number | phonenumber__api | Text Field |
Welcome Message | welcomemessage__api | Text Field |
Range Thanks Message | rangethanksmessage__api | Text Field |
Comment Thanks Message | commentthanksmessage__api | Text Field |
Range Error Message | rangeerrormessage__api | Text Field |
Web Welcome Message | webwelcomemessage__api | Text Field |
Web Text Area Message | webtextareamessage__api | Text Field |
Web Complete Message | webcompletemessage__api | Text Field |
Web Complete Redirect URL | webcompleteredirecturl__api | Text Field |
Web Complete Redirect Timeout | webcompleteredirecttimeout__api | Text Field |
Web Page Title | webpagetitle__api | Text Field |
Email From | emailfrom__api | Text Field |
Email Subject | emailsubject__api | Text Field |
Email HTML | emailhtml__api | Text Field |
Email Text | emailtext__api | Text Field |
Below is an example of what it should look like for some of the fields. Refer above for all the fields that should be in this table.
Inbound Route Configuration
Each SharpenQ will need a unique DID assigned for post call surveys (called CSAT in Sharpen) so that the results can be properly reported. These numbers will be associated with a table row in the CSAT table where the survey questions can be entered for each SharpenQ.
DID/Inbound Route Sending CSAT Messages
To locate an available number, log into Admin > Configuration tab > Inbound Routes.
Edit the Number.
Name it CSAT and an abbreviated description of the SharpenQ it’s associated with.
Toggle the Advanced Options.
Set “sagentCSATsms” skill for that inbound route.
Set SMS Routing to Webhook and the webhook URL:
Click Save at the bottom.
DID/Inbound Route Pointed to CSAT Configured Queue
This will be the Inbound Route that the caller dials to reach the queue, which includes routing types:
SharpenQ
Logic
Auto Attendant
Time Control
VCX
Set “sagentCSATsms” skill for that inbound route.
Locating the Queue ID
Next you will need to locate the queueID. The queueID is necessary to identify which queue should be configured for CSAT in the Sharpen Tables configuration covered in the next section.
Please note the method below assumes there has been activity in a queue which can be reported on. If a queueID is needed for a queue without historic volume, either handle an interaction in the queue to satisfy the criteria, or open a request with SharpenCare to identify the queueID.
To do that select Insights from the upper left-hand menu.
Select New Report
Enter a Queue Id Report in the Report Name Field
Select the Queue Segment Activity Data Source
In the Labels section enter IT Reports
Click Create button
Select a Date Range that correlates to the last time there was activity on the Queue whose Queue Id you’re looking for. In this example, it is set as last month.
Click on the Fields tab and then click on the plus sign to add fields. Add two fields
Select the Queue Name and Queue ID fields.
Click on the Build button
Click on the Save button
Select the grouping tab.
Click on the plus sign
Select Queue Name
Click Build
Click Save
You’ll then see a list of Queues and Queue IDs
Sharpen Table Configuration
Sharpen Tables is used to configure the specific messaging and references to the CSAT survey. Without this configuration, CSAT surveys will not work.
In the Admin > Configuration tab > Sharpen Tables.
Locate the CSAT Table and Edit it.
Click the Add Record button at the bottom:
Enter in the following information
QueueID found in the Locating the Queue ID section above
Phone Number (1+10 digit number, no dashes) assigned in the Inbound Route Configuration section above
Enter Welcome Message
Enter Range Thanks Message
Enter Comment Thanks Message
Enter Range Error Message
Then press the Create Record button
Sharpen Q Configuration
Sharpen Q configuration is required to establish the trigger for the CSAT request to be sent. This is accomplished via a webhook POST upon a desired Sharpen Q event.
Edit the SharpenQ under Admin > Configuration tab > SharpenQ
Enable Messaging on the SharpenQ.
Click Add Webhook button at the bottom (not shown).
Enter in the URL on Clear Call and set to Enabled.
Save the Webhook.
Save the SharpenQ.
Testing
Test Survey by making a test call into the appropriate Logic Flow for the SharpenQ.
Here is an example survey:
Post Call Email Surveys
Prerequisites
A URL referencing for a brand image (e.g. https://mycompanyname.com/logo.png) that will be displayed in the email. The recommended image size is 656 x 125 pixels (DPI 72 pixels/inch).
Identify an email address where CSAT emails should be sent from.
Once provided, a request to SharpenCare to have the email address validated with AWS should be opened via support.sharpencx.com (look for the “Sharpen Q Email Verification” request type).
The verification link (once sent by SharpenCare) will expire in 24 hours. This allows Sharpen to use the email address for outbound communication.
The
sagentCSATemailskill must be added. In Sharpen, go to Admin > Configuration > Q Skills, and add the "sagentCSATemail" skill. NOTE: The skill weight is not important, it can be assigned a weight of 1.
Interaction Flow Configuration
Inbound interactions need to be marked with the sagentCSATemail skill to appropriately identify them as interactions requiring CSAT surveys to be sent. There are various methods of attaching a skill to an interaction, and some only apply to certain comm types. This section of the guide describes options for setting a skill by comm type.
Setting a Skill on Email Interactions
An action bot is needed to attach the “sagentCSATemail” skill to interactions upon entry to Q. If you are unfamiliar with action bot setup, please review this documentation.
Assuming you have review the document above and have an action bot ready, you just need to make sure the action bot is configured to set a skill. Make sure your action looks something like this.
Setting a Skill on Chat Interactions
In order for an email survey to be sent after a chat interaction, an email address value must be associated with the customer. This means that the chat must pass through a panel which gathers to some data source that can associate an email value to a caller based on their caller ID number.
Chat interactions are delivered to Sharpen Q through a Logic configuration. If you are unfamiliar with Logic, please review this documentation. When chat is being configured in Logic, one of the Capture panels needs to be configured to gather a customer’s email address so we know where to send the survey. The following steps show how that can be done.
Configure a Capture panel to capture an email value from customers.
The Valid and Invalid nodes on the Capture panel should be edited by adding the “Email” variable, with “Static” set to false. This ensures that the customer’s response is set as the value for “Email”. This will then be leveraged as the destination email for the CSAT survey.
If all chats should have CSAT enabled regardless of specific menu options and without the ability to opt in or opt out, a condition panel should be configured so that the “sagentCSATemail” skill is set any time a customer provides their email address.
Set the conditions on the Condition panel to “Email” is not empty AND “Email” is not null.
Edit the pass node by adding the “Queue Skills” variable with “sagentCSATemail” as the value. This sets the sagentCSATemail skill on the interaction.
Setting a Skill on Inbound Route Configuration (Phone Interactions)
IMPORTANT: It is very important to understand that in order for an email survey to be sent after a phone interaction an email value must be associated with the caller. This means that the call must pass through a query to some data source that can associate an email value to a caller based on their caller ID number.
Each SharpenQ will need a unique DID assigned for post call surveys (called CSAT in Sharpen) so that the results can be properly reported. These numbers will be associated with a table row in the CSAT table where the survey questions can be entered for each SharpenQ.
To locate an available number, log into Admin > Configuration tab > Inbound Routes.
Edit the Number.
Name it CSAT and an abbreviated description of the SharpenQ it’s associated with.
Toggle the Advanced Options.
If all calls to this line should have CSAT enabled regardless of specific menu options and without the ability to opt in or opt out, set “sagentCSATemail” skill for the CSAT inbound route and any other inbound route that will be sending out post call SMS surveys
Click Save at the bottom.
Enabling CSAT on Specific Menu Options
Sometimes CSAT only needs to be enabled for certain auto attendant or IVR menu options, and not for all calls coming in on a given inbound route. In this case, the CSAT skill needs to be added to the nodes for the appropriate options in Logic.
Determine which menu option to add the CSAT skill to on the Logic Match panel.
Edit the node by adding the “Queue Skills” variable with “sagentCSATemail” as the value.
Click the blue Save button on the node settings.
Presenting the Opt-in or Opt-out Option
In some cases it is required that callers are offered the option to opt in or out of a receiving a CSAT survey. If this is the case a Match panel will need to be created in Logic to present these options.
For chat interactions, the prompt should indicate that callers should respond with a certain keyword to opt in, and an alternative keyword to opt out.
For example: “If you would like to receive an email survey after chatting with our representative, please respond with ‘Yes’. If you would like to opt out of receiving the survey, please respond with ‘No’.
Following the steps for enabling CSAT on specific menu options, the “sagentCSATemail” skill should be added to the opt-in node on the Match panel. The skill should not be added to the opt-out node, the No Match node, or the Timeout node.
For voice interactions, the sound file should indicate that callers should press a certain option to opt in and a different option to opt out.
For example: “If you would like to receive an email survey after speaking with our representative, please press 1. If you would like to opt out of receiving the survey, please press 2.”
Following the steps for enabling CSAT on specific menu options, the “sagentCSATemail” skill should be added to the opt-in node on the Match panel. The skill should not be added to the opt-out node, the No Match node, or the Timeout node.
Locating the Queue ID
Next you will need to locate the queueID. The queueID is necessary to identify which queue should be configured for CSAT in the Sharpen Tables configuration covered in the next section.
Please note the method below assumes there has been activity in a queue which can be reported on. If a queueID is needed for a queue without historic volume, either handle an interaction in the queue to satisfy the criteria, or open a request with SharpenCare to identify the queueID.
Next you will need to locate the queueID.
To do that select Insights from the upper left-hand menu.
Select New Report
Enter a Queue Id Report in the Report Name Field
Select the Queue Segment Activity Data Source
In the Labels section enter IT Reports
Click Create button
Select a Date Range that correlates to the last time there was activity on the Queue whose Queue Id you’re looking for. In this example, it is set as last month.
Click on the Fields tab and then click on the plus sign to add fields. Add two fields
Select the Queue Name and Queue ID fields.
Click on the Build button
Click on the Save button.
Select the grouping tab.
Click on the plus sign
Select Queue Name
Click Build
Click Save
You’ll then see a list of Queues and Queue IDs
Create the HTML dotCX
An HTML dotCX project is required to provide the CSAT survey rendering for email CSAT. It provides the opportunity to customize how your users are asked for feedback, including branding and messaging.
Create a new dotCX project
Go to the Developer section of Sharpen
Select the [dotCX] tab
Click the blue plus sign next to the project dropdown list near the top left of the page
Name the project “Email CSAT”
Paste the code from the following document into the dotCX project
Make the following changes to the code
On line 49, insert the image URL received from the client where it says INSERT IMAGE URL HERE - leave the quotation marks
On line 119 add the company name where it says INSERT COMPANY NAME HERE
On line 120 add the full company address where it says INSERT FULL COMPANY ADDRESS HERE
On line 121 add the main company phone number where it says INSERT MAIN COMPANY PHONE NUMBER HERE
On line 121 add the company website URL where it says INSERT COMPANY WEBSITE URL HERE
On line 121 add the text you would like to display for the website link where it says HYPERLINK DISPLAY TEXT HERE
On line 138 add the current year and company where it says INSERT YEAR AND COMPANY NAME HERE
If you are deploying in IZ1, you need to update all references to https://appqa.sharpencx.com with https://apps.iz1.sharpen.cx
Save and deploy the dotCX project
Below is an image of how the information added to the dotCX project will be displayed in the CSAT email:
Sharpen Table Configuration
Sharpen Tables is used to configure the specific messaging and references to the CSAT survey. Without this configuration, CSAT surveys will not work.
In the Admin > Configuration tab > Sharpen Tables.
Locate the CSAT Table and Edit it.
Click the Add Record button at the bottom:
If the table does not exist, create a new table named CSAT (type should be “other) with the following fields (all text fields)
queueID
Phone Number
Welcome Message
Range Thanks Message
Comment Thanks Message
Range Error Message
Web Welcome Message
Web Text Area Message
Web Complete Message
Web Complete Redirect URL
Web Complete Redirect Timeout
Web Page Title
Email From
Email Subject
Email HTML ( do not use Email HTML URL)
Email Text
Complete Webhook Endpoint
Add data to the following fields
queueID
Use the queue ID acquired from the instructions above
Web Welcome Message
Example: Thank you for contacting Sharpen! On a scale of 1-5, how pleased were you with the service provided today?
Web Text Area Message
Example Thank you! Do you have any additional feedback to provide?
Web Complete Redirect URL
This is the URL that customers will automatically be redirected to after completing comments section of the survey
Web Complete Redirect Timeout
The amount of time, in seconds, that will pass before a customer is redirected to the Redirect URL
Web Page Title
Title of the CSAT webpage as it will appear in the browser
Email From
The AWS-verified email address provided by the client
Email Subject
Subject of the CSAT email
Email HTML
Copy the URL from the Email CSAT dotCX project (see image below)
Sharpen Q Configuration
Sharpen Q configuration is required to establish the trigger for the CSAT request to be sent. This is accomplished via a webhook POST upon a desired Sharpen Q event.
Edit the SharpenQ under Admin > Configuration tab > SharpenQ
Enable Messaging on the SharpenQ.
Click Add New Webhook button at the bottom (not shown).
Enter in the URL on Clear Call and set to Enabled.
Save the Webhook.
Save the SharpenQ.
Testing
Test Survey by sending a chat or making a test call to the appropriate Sharpen Q and handling the interaction as an agent. The defined webhook Q action will trigger the CSAT and you should receive an email CSAT to the email address captured in the configured inbound flow.