Survey Summary Report

Updated 

The Survey Summary Report shows the summary and status of the Survey sent to the customer associated with the Case, including whether the survey is filled out, in progress, or just opened. It belongs to the Survey Reports Report Group.

The Survey Summary Report provides the total count of Surveys sent to customers, categorized by each Case and Survey level. It details the status of each Survey, indicating whether the customer received, opened, completed, or abandoned it, both overall and at the Case level. Additionally, it includes information on the device used by the customer to access the survey, details of all agents involved with the case associated with the survey, and insights into the initial and final customer sentiment.

Attribute

Status

Behavior of User Custom Fields

User Custom fields are supported in this report. The field will show the value attribute for that field mapped against the "Agent" dimension

The User can use the Dimension Configurator to select whether to show the snapshot value or the current value of the field.

Behavior of Case Custom Fields

Case-level Custom Fields (CF) are supported in this Report. Plotting any Case-level CF will display the value attribute for that field on the Case.

Users can plot the Snapshot value/Current Value of the Custom Field by selecting "Current"/"Snapshot" in the Dimension Configurator.

Date Filter

Survey Sent Date

Record Creation Time

Records for this Report are created whenever Survey is sent. Records gets updated if the Survey status changes, such as "In Progress" and "Completed".

Refresh Frequency

Ranges between 5 to 10 minutes.

Aggregation Supported

Supported at 15-minute intervals.

Metrics and Dimensions

The following are the Metrics and Dimensions available under the Survey Summary Report:

Name

Descriptions

Survey Sent Count

Number of Surveys sent to the customer.

Survey Completed Count

Number of surveys filled by the customer.

Associated Customer Message Count (Including Transcripts)

Measures the count of customer messages including the call transcripts (if any).

Survey Bounce Rate

Percentage of surveys which are not completed over total number of surveys clicked by the customer.

Associated Message Count

Measures the overall message count associated on the Case. This is a sum of both customer and brand messages including bot responses, auto responses, auto imports and call transcripts (if any).

Survey Failed to Send Count

Number of Surveys failed to send to the customer.

All Engaged Agents Count

Measures the count of all the users based on either agent assignment, agent response or macro application depending on the values selected in "Service settings” screen.

Survey Opt Out Count

Total number of surveys in which customer opted out of the survey.

Survey Response Rate

Percentage of surveys responded/ completed over total number of surveys sent.

Survey Clicked Count

Total number of surveys opened by the customer. This will include both in progress and filled surveys.

Survey Not Clicked Count

Total number of surveys which are not opened yet by the customer.

Survey Opened Count

Total number of surveys which are opened but not yet completed by the customer, that is, in progress surveys.

Associated Brand Message Count (Including Transcripts)

Measures the count of brand messages including the call transcripts (if any). This will also include the bot messages as well.

Survey Click Rate

Percentage of surveys which were opened out of total number of surveys sent.

Name

Descriptions

Public Survey Filled by Customer ID

Indicates the unique ID of the customer who filled the surveys for public surveys authentication or self-serve partners. In all other scenarios, it will show a blank.

All Engaged Agents (Comma Separated)

Indicates the list of all the users based on either agent assignment, agent response or macro application depending on the values selected in "Service Settings” screen. If there are more than 1 user assigned to the Case, it will show in a comma separated format.

Survey

Indicates the name of the survey that is sent to the customer.

First Associated Customer Message Created Time

Indicates the date timestamp of when the first customer message was created on the Case where the survey was sent, or response was received.

Agent Current Working Queue

Indicates the name of the Queue that the current assigned agent is a part of. If agent is part of multiple Queues, it will come in separate rows. This can change with time and always show the current Work Queue.

Agent Current Status

Indicates the current status of the agent to whom the Case is assigned currently. This can change with time and always show the current status of the current assigned agent.

Public Survey Filled by Customer Name

Indicates the name of the customer who filled the surveys for public surveys authentication or self-serve partners. In all other scenarios, it will show a blank.

Last Engaged Agent Skills

Agent Skills assigned to the agent, if there are multiple Skills associated, this will show each name in a separate row. This is based on last engaged agent to the associated Case.

Last Engaged Agent Email Id

Email ID of the last engaged agent on the associated Case.

Survey Sent Time

Indicates the date timestamp when the survey was sent to the customer.

Survey Sent Time Interval

Indicates the time interval for when the survey was sent to the customer. This is a histogram dimension and can be used when we want to see survey responses at daily/weekly levels, and so on.

Last Engaged Agent Device Details

Provides detailed information about the agent's device, browser, and operating system. Only used for live chat Cases.

First Associated Customer Message Created Date

Indicates the date of when the first customer message was created on the Case where the survey was sent, or response was received.

Latest Associated Customer Message Created Time

Indicates the date timestamp of when the last/ latest customer message was created on the Case where the survey was sent, or response was received.

Last Engaged Agent Manager

Indicates the manager of the agent who was last engaged on the associated Case.

Country

Indicates the name of the country based on the social channel that the Case is associated with. Only used for live chat Cases

Last Engaged Agent Group

Indicates the agent group of the last agent based on either agent assignment, agent response or macro application depending on the values selected in "Service Settings” screen. If the agent is a part of multiple agent groups, it will show in separate rows.

Browser

Indicates the name of the browser based on the social channel that the Case is associated with. Only used for live chat Cases

First Associated Brand Message Created Time

Indicates the date timestamp of when the first brand (inclusive of both bot and agent) message was created on the Case where the survey was sent, or response was received

Survey Response Time

Indicates the date timestamp when the survey sent on the Case was responded by the customer.

Is Case Deleted?

It is a Boolean field indicating True if the particular Case has been deleted or else will return as False.

Operating System

Indicates the operating system that is detected based on the social channel that the Case is associated with. Only used for live chat Cases

Last Engaged Agent

Indicates the names of the last/ latest agent based on either agent assignment, agent response or macro application depending on the values selected in "Service Settings” screen.

Latest Associated Customer Message

Provides the latest message from customer that was associated to a particular Case. This will be inclusive of both agent and bot messages.

Last Engaged Agent Skills (Comma Separated)

Agent Skills assigned to the agent, if multiple skills are assigned, it will come as comma separated. This is based on last engaged agent to the associated Case.

Is Public Survey?

A Boolean field indicating if the survey was a public survey or not. This can be configured while creating the surveys.

Last Engaged Agent ID

The Sprinklr user ID of the Last engaged agent on the associated Case.

Channel

Provides the name of the channel associated on the Case.     This dimension can be used to segment a common metric across multiple channels and will show the list of all channels associated to the first message of the Case.

Case Details

Associated Case to the event, which includes the Case subject, Case ID and the Description.

Region

Indicates the name of the region based on the social channel that the Case is associated with. Only used for live chat Cases.

Associated Case End Sentiment

Final sentiment of Case associated to the Survey.

Agent Login Current Status

Indicates the current login status of the agent whether the agent is logged in or not based on to whom the Case is assigned.

Case Number

The ID number associated to the Case.

Latest Associated Brand Message

Provides the latest message from brand (inclusive of both bot and agent) that was associated to a particular Case. This will be inclusive of both agent and bot messages.

Agent Current State

Indicates the current status of the agent to whom the Case is assigned currently. This can change with time and always show the current status of the current assigned agent.

City Name

Indicates the name of the city based on the social channel that the Case is associated with. Only used for live chat Cases.

Survey Response Time Interval

Indicates the time interval for when the survey was responded by the customer. This is a histogram dimension and can be used when we want to see survey responses at daily/weekly level, and so on.

Last Engaged Agent Federation ID

Federation ID of the last engaged agent on the associated Case.

Associated Case Initial Sentiment

Initial sentiment of Case associated to the Survey.

Latest Associated Brand Message Created Date

Indicates the date of when the last/ latest brand (inclusive of both bot and agent) message was created on the Case where the survey was sent, or response was received.

Latest Associated Brand Message Created Time

Indicates the date timestamp of when the last/ latest brand (inclusive of both bot and agent) message was created on the Case where the survey was sent, or response was received.

Case Details

Associated case to the event, which includes the Case subject, Case ID and the Description.

Account

The name of the social network account. When used with Case details, this will display the name of the "Brand Account" through which the first message associated to the Case is grabbed. Messages are ordered in a Case based on the time they were associated to the Case, not necessarily the date and time the messages were created.

Survey Response Modified Time

Indicates the date timestamp at which the response made to the survey was modified.

First Associated Brand Message Created Date

Indicates the date of when the first brand (inclusive of both bot and agent) message was created on the Case where the survey was sent, or response was received.

All Engaged Agents

Indicates the names of all the users based on either agent assignment, agent response or macro application depending on the values selected in "Service Settings” screen. If there are multiple agents associated, this will show each name in a separate row

Latest Associated Customer Message Created Date

Indicates the date of when the last/ latest customer message was created on the Case where the survey was sent, or response was received.

Customer Profile

Profile of Customer on which survey is sent.

Survey Status

Indicates the status of the survey if the survey is filled, opened, completed, or sending failed.

Sender's IP Address

Indicates the IP Address from which survey was sent.

Month Of Year

The name of the Calendar Month on which the activity occurred.

Day of the Week

The name of the day of the week on which the activity occurred.

This concludes our comprehensive coverage of the Survey Summary Report. For more details on the Reports available under Service Analytics, please refer to the Detailed Reports Glossary.