| |
Latest Associated Brand Message Created Date | Indicates the date of when the last/ latest organization (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 organization (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. |
| Indicates the response made by the customer - it can be a text field or numeric based on input asked as per the question. When plotted with "Survey Question", each question appears as a new row for each corresponding survey. |
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. |
| 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. |
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. |
| Indicates the unique ID of the responses made by the customer. It is mostly used for debugging. |
| Profile of Customer on which survey is sent. |
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. |
| Associated Case to the event, which includes the Case subject, Case ID and the Description. |
| Indicates the name of the region based on the social channel that the Case is associated with. Only used for live chat Cases. |
| 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. |
Associated Case End Sentiment | Final sentiment of Case associated to the Survey. |
| The ID number associated to the Case. |
| Indicates the name of the browser based on the social channel that the Case is associated with. Only used for live chat Cases. |
Latest Associated Brand Message | Provides the latest message from Case (inclusive of both bot and agent) that was associated to a particular Case. This will be inclusive of both agent and bot messages. |
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. |
First Associated Brand Message Created Time | Indicates the date timestamp of when the first organization (inclusive of both bot and agent) message was created on the Case where the survey was sent, or response was received. |
| Indicates the name of the survey that is sent to the customer. |
| It is a Boolean field indicating True if the particular Case has been deleted or else will return as False. |
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. |
| 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. |
| Indicates the name of the question asked in the survey where each question appears as a separate row. To be used with "Survey Answer". |
| Indicates the operating system that is detected based on the social channel that the Case is associated with. Only used for live chat Cases. |
First Associated Brand Message Created Date | Indicates the date of when the first organization (inclusive of both bot and agent) message was created on the Case where the survey was sent, or response was received. |
| 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". |
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. |
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. |
| Indicates the date timestamp when the survey sent on the Case was responded by the customer. |
| 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. |
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. |
| Indicates the name of the city based on the social channel that the Case is associated with. Only used for live chat Cases. |
| Indicates the date timestamp when the survey was sent to the customer. |
| Indicates the IP Address from which Survey was sent. |
Last Engaged Agent Email ID | Email ID of the last engaged agent on the associated Case. |
| The Sprinklr user ID of the Last engaged agent on the associated Case. |
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. |
| 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. |
| Day of the year, for example, 1st Jan will be 1, 2nd Jan will be 2 and so on. |
| 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. |