PCS Data Service Specs for Survey Dashboard
Overview
PCS Data Service allows creating survey dashboards to show statistics such as Net Promoters Score (NPS), Completely-filled Surveys, Partially-filled Surveys. The data service has 2 background jobs that persist the surveys' statistics based on the respective time intervals.
Realtime Job
The real-time job updates the stats after every 15 seconds in real_time_stats.
Historical Job
The historical job updates historical stats in the historical_stats table after every 1 hour.
Note
PCS data service image should be deployed at the exact rounded time interval, for instance, 10:00 PM so that the historical_stats table persist the data properly
The following section describes the list of attributes exposed by the PCS data service.
Attribute Name | Description |
---|---|
Net Promoters Score (historical) | The Net Promoter Score is an index ranging from -100 to 100 that measures the willingness of customers to recommend a company's products or services to others. Calculate your NPS using the answer to a key question, using a 0-10 scale: Respondents are grouped as follows:
So the NPS is calculated by subtracting the percentage of Detractors from the percentage of Promoters, which can range from a low of -100 (if every customer is a Detractor) to a high of +100 (if every customer is a Promoter). %Promoters - %Detractors = Net Promoter Score The value of this attribute updates after every one hour. Supported display types are,
In the case of multiple surveys, make sure to select the Aggregation Type as AVG in both of the display types. The NPS across all selected surveys is calculated as the following: Avg NPS = (NPS Survey 1 + NPS Survey 2 + NPS Survey n)/total number of selected surveys Comparison from the previous week or the previous hour is supported |
Net Promoters Score (real-time) | The Net Promoter Score is an index ranging from -100 to 100 that measures the willingness of customers to recommend a company's products or services to others. Calculate your NPS using the answer to a key question, using a 0-10 scale: Respondents are grouped as follows:
So the NPS is calculated by subtracting the percentage of Detractors from the percentage of Promoters, which can range from a low of -100 (if every customer is a Detractor) to a high of +100 (if every customer is a Promoter). %Promoters - %Detractors = Net Promoter Score The value of this attribute updates after every 15 seconds. Supported display types are,
In the case of multiple surveys, make sure to select the Aggregation Type as AVG in both of the display types. The NPS across all selected surveys is calculated as the following: Avg NPS = (NPS Survey 1 + NPS Survey 2 + NPS Survey n)/total number of selected surveys |
NPS Break Down (real-time) | It shows the breakdown of Passives, Promoters and, Detractors.
This is updated every 15 seconds. Supported display types are,
In the case of multiple surveys, the data is summarised to show the total number of promoters, passives and, detractors. |
Completely Filled Responses (historical) | This is the total number of customers who have completely responded to the survey. This data is updated every 1 hour. Supported display types are,
|
Partially Filled Responses (historical) | This is the total number of customers who have partially responded to the survey. This data is updated every 1 hour. Supported display types are,
|
Survey Name (real-time) | Name of the survey conducted in PCS. This data is updated after every 15 seconds. Supported display types are,
|
Number of Questions (real-time) | The number of questions conducted in the Survey. Supported display types are,
|
Count of all responses (real-time) | This is the total number of customers who have responded to at least one question in the survey. This data is updated every 15 seconds. Supported display types are,
|
Count of all responses (historical) | This is the total number of customers who have responded to at least one question in the survey. This data is updated every 1 hour. Supported display types are,
|
Response Rate (real-time) | It is calculated by dividing the completely-filled surveys (real-time) divided by the Total sample group where, Total Sample Group = the total number of customers who were given this survey Response Rate = Completely-filled surveys/ Total sample group This data is updated after every 15 seconds. Supported display types are,
In the case of multiple surveys, make sure to select only the surveys where some responses are received. If a survey doesn't have any responses, the gadget may start behaving weirdly. The Response rate for multiple surveys is calculated based on the selected Aggregation Type; i.e. SUM or AVG. Response Rate (of all surveys) = Response rate (of survey 1) + Response rate (of survey 2) + Response rate (of survey n)/total number of surveys |
Completion Rate (real-time) | This rate determines how frequently customers are completely filling up the surveys. It is calculated by dividing the number of completely-filled surveys divided by (partially-filled + Completion Rate = Completely-filled surveys / (partially-filled surveys + completely-filled surveys) This data is updated every 15 seconds. Supported display types are,
In the case of multiple surveys, make sure to select only the surveys where some responses are received. If a survey doesn't have any responses, the gadget may start behaving weirdly. The Response rate for multiple surveys is calculated based on the selected Aggregation Type; i.e. SUM or AVG. Completion Rate (of all surveys) = Completion rate (of survey 1) + Completion rate (of survey 2) + Crate (of survey n)/total number of surveys |