| |
Public Survey Filled by Customer ID | Indicates the unique ID of the customer who filled the surveys for of 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 |
| 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. |
| 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. |
| 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. |
| Indicates the date timestamp when the survey sent on the Case was responded by the customer. |
Last Engaged Agent Skills (Comma Separated) | Agent Skills assigned to the agent, if multiple skills are assigned, it will come comma separated. 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 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 Device Details | Provides detailed information about the agent's device, browser, and operating system. Only used for live chat Cases. |
| Handle of Customer who has filled the survey (It can be Phone Number, Email Address, or other information, based on the associated Case). |
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. |
| Indicates the name of the country based on the social channel that the Case is associated with. Only used for live chat Cases. |
| 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. |
| 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 |
| It is a Boolean field indicating True if the particular Case has been deleted or else will return as False. |
Survey Response Modified Time | Indicates the date timestamp at which the response made to the survey was modified. |
| Indicates the operating system that is detected based on the social channel that the Case is associated with. Only used for live chat Cases. |
| 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. |
| Agent Skills assigned to the agent, if multiple skills are assigned, it will come comma separated. |
| The Sprinklr user ID of the Last engaged agent on the associated Case. |
| 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. |
| 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. |
| Profile of Customer on which survey is sent. |
| 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. |
| Indicates the name of the city based on the social channel that the Case is associated with. Only used for live chat Cases. |
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. |
| Unique ID or the Name of the customer who filled the survey based on different channels. |
| 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. |
| Associated Case to the event, which includes the Case subject, Case ID and the Description. |
| Indicates the unique ID of the responses made by the customer. It is mostly used for debugging. |
| It is a Boolean field indicating if the Case has been archived or not. |
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. |
| Indicates the language detected based on the social channel that the Case is associated with. Only used for live chat Cases. |
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. |
| Indicates the date timestamp when the survey was sent to the customer |
| Indicates the IP Address from which survey was sent. |
| 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. |
| The name of the Sprinklr Account Group. An Account Group is a collection of Accounts within a Client that can contain multiple social networks. You can create and edit these groups under Administration> Settings. |
| Date on which the event occurred. |
| This is the sequential day number starting with day 1 on January 1st. |
| The specific 1-hour period within a day when an activity occurred, displayed in the 24-hour clock format (hh:mm) and adjusted to the user's timezone. |
Time of day (30 minutes interval) | The specific half-hour period within a day when an activity occurred, displayed in the 24-hour clock format (hh:mm) and adjusted to the user's timezone. |
Time of Day (15 Minute Interval) | The specific quarter-hour period within a day when an activity took place, represented in the 24-hour clock format (hh:mm) and adjusted to the user's timezone. |
| This is the sequential week number in the year starting the week count with Sunday. |
| The name of the Calendar Month on which the activity occurred. |
| The name of the day of the week on which the activity occurred. |
| This dimension specifies the respective day number in the selected time range. Note that the start date will be referred to as Day 1 and so on. |
| Indicates the last/ latest Work Queue that the Case associated to the survey was a part of. |