Building Custom Dashboards using CFM (surveys) Data

Updated 

This module allows you to build custom reporting dashboards tailored to your specific analysis needs. Unlike the fixed, non-customizable per-question analytics view, it offers greater flexibility by enabling you to choose relevant metrics, apply filters, and organize data to suit your goals. This empowers you to focus on key trends, compare performance across segments, and easily extract actionable insights.

Business Use Cases

Creating custom analytics dashboards allows you to tailor your data analysis experience, enabling you to view and analyze survey results in ways that best suit your business needs.

  • Provides Actionable Insights: Survey Analytics helps identify recurring issues, such as long wait times, by analyzing NPS feedback for specific time frames. This allows for prompt action, such as increasing service capacity during peak hours and improving customer satisfaction.

    Example: A bank branch manager identifies long wait times as a recurring issue by analyzing NPS feedback for specific time frames. This enables immediate action, such as adding counters during peak hours, to improve customer satisfaction.

  • Data Analysis: Custom reports can segment feedback by relevant criteria, helping to quickly identify trends or issues, such as low performance in specific areas, and enabling targeted improvements.

    Example: In retail, custom reports enable the segmentation of post-transaction feedback by store location, allowing businesses to quickly identify trends, such as low staff helpfulness scores in specific regions, and implement targeted training programs.

  • Performance Tracking: Comparing survey scores across locations helps identify performance gaps, such as long wait times during peak hours at underperforming sites. Sharing best practices from high-performing locations can drive improvements and enhance overall operational efficiency.

    Example: For a food chain, custom reporting enables comparison of survey scores across locations to identify issues like long wait times during peak hours at specific stores.

Custom dashboards empower targeted problem-solving by enabling users to drill down into specific issues like long wait times or low staff helpfulness, allowing for precise interventions. They also support improved resource allocation by revealing trends and underperforming segments, helping teams schedule additional staff during peak hours or launch targeted training. Additionally, dashboards enhance performance monitoring through comparative analysis across locations or time periods, making it easier to benchmark performance, replicate success, and address inefficiencies proactively.

Prerequisites

You need the Edit and View Reporting Survey Level permissions to create reporting dashboards in order to access the Custom Dashboards option. Currently, all users with access to the dashboard can view the available survey dimensions and metrics.

Custom Dashboards in CFM are primarily powered by the CFM Analytics data source.

Setting Up Custom Reporting Dashboard

  1. Go to Sprinklr Insights and Customer Feedback Management.

  2. Go to the Left Navigation pane of the Customer Feedback Management App to access Custom Dashboards. A complete list of previously created and shared dashboards is visible under the custom dashboards option.

  3. You can click + Create Dashboard to create a dashboard.

  4. Alternatively, you can create Folders to host multiple dashboards in it.

    Fill in the following details to create a dashboard:

    1. Name: Enter dashboard name.

    2. Folder: Select a folder where you want the dashboard to reside.

    3. Auto Refresh: Check the Auto Refresh option to refresh the dashboard data automatically.

    4. Auto refresh interval: Select intervals for auto-refresh.

      Example: If you select 10 seconds, the dashboard will automatically refresh every 10 seconds to display the latest survey data.

  5. Click + Add Widget.

    You can add widgets to multiple sections in a dashboard. Learn to create a widget by referring to this article .

    The Data Source will be automatically selected as CFM Analytics.

  6. Click Add to Dashboard to add the widget to the dashboard. All the capabilities of reporting dashboards are supported for CFM custom dashboards as well. Multiple sections can be added to the dashboard for different analytics reports within a single dashboard.

How to use it?

Let us understand the process to add a widget:

  1. Navigate to Custom Dashboard and click + Add Widget.

  2. You can utilize the CFM Analytics Metrics and Dimension selector to create various visualizations within the dashboard.

  3. The Widget Builder for Customer Feedback Management, Analytics includes the ability to filter the list of metrics and dimensions based on the data source.

  4. In order to access the data of a survey, you shall have the “View Responses and Analytics” for the survey.

    1. If you examine a widget with dimensions or metrics from a survey that they lack access to in Response and Analytics, they will encounter an error similar to this on the widget.

  5. And for accessing the dimensions/metrics related to the survey, you shall have theView Survey Dimension” permission under the “Edit Response and Analytics”. Without this, you won’t have the dimensions/metrics for plotting, filtering, and drill down.

  6. You can choose the survey(s) and data pipeline(s) for which you wish to view the list of metrics.

    1. You can narrow down the list of all metrics and dimensions by the name of the survey for which this dashboard is being created.

      Note: The choices for Survey Name, Dataset Name, or Hierarchy Name are retained for a single session of widget creation to minimize the number of clicks required to set up the widget.

  7. All available metrics are organized into distinct categories to simplify identification and facilitate report creation.

    1. Favourites: Contains dimensions and metrics you've marked as favorites for quick access.

    2. Recent: Displays dimensions and metrics you’ve used most recently.

    3. Standard Survey Metrics: Includes survey-agnostic dimensions such as Survey Response Count, Response ID, Survey Name, and Response Time.

    4. Survey Questions: Groups metrics based on survey question types from which the dimensions or metrics are derived.

    5. Custom Fields: Contains custom fields related to the asset categories: Survey, Hierarchy, Profile, Transaction, and User.

    6. Response Metadata: Contains IP-based, survey-agnostic dimensions like Browser and Geo Location.

    7. Dataset: All joint dataset dimensions can be found here, which is used for multi survey joint reporting.

    8. Others: Contains all remaining un-bucketed dimensions that do not fall under the predefined categories.

      Sub-buckets help to facilitate metric identification and dashboard configuration.

      Note: Each metric or dimension is tagged with its associated survey or dataset name when selecting it for plotting in widgets.

  8. You can apply, lock, and pin individual or combined filters at the dashboard , section, and widget levels.

  9. You can set various time ranges for data comparison and adjust them according to your analytical needs.

Manage Sections

To make changes to the dashboard, refer to the following points:

  • Compare Mode: Helps to compare the data from two different time ranges.

  • Filter Option: Helps to add filters at the dashboard level.

  • Reload Dashboard: Helps to refresh the data at the dashboard level.

  • Click Vertical Ellipsis(3 dots) to manage the dashboard further:

    • + Create: You can create a new dashboard

    • Edit: You can edit the current dashboard.

    • Edit Layout: You can edit dashboard layout.

    • Clone: You can clone the dashboard.

    • Delete: You can delete the dashboard

    • Share: You can share the dashboard with workspaces, users, and user groups.

    • Get External Link: You can create external links for the dashboard.

    • Export: You can export the dashboard in PDF, Excel, PNG, PPT, CSV, and JSON format.

    • Generate Presentation: You can generate the dashboard as a Sprinklr presentation from the dashboard.

    • Activity: You can view all the changes made on the dashboard.

    • Set SLA Present: You can customize the SLA time intervals to monitor SLA performance.

    • Custom Interval: You can customise the monthly or quarterly intervals used in charts.

    • Date Range: You can apply different time ranges for comparing the dates and refining them as per the requirements for analysis. You also have the ability to use data range filters for custom fields of the Date type.

      This functionality is available at the dashboard level filters, response tab, and analytics tab.

Manage Custom Dashboard

You can manage the dashboards through the 3 dot menu:

  1. Clone: You can create a clone of the dashboard by simply adding a name for the clone.

  2. Share: You can edit the share access of the dashboard.

  3. Delete: You can delete the dashboard.

  4. Move to Folder: You can move an individual dashboard to a folder for better oraganisation.

Special behaviour for reporting with survey having Non-Mandatory questions

  1. Mark as required: Navigate to the Survey Builder settings and enable the "Mark as Required" option for questions you wish to make mandatory. Since our surveys support non-mandatory questions, we've implemented special handling to account for scenarios where some responses may be missing, typically occurring when respondents skip optional questions. This can also occur when a partial response is automatically submitted, resulting in some questions being left unanswered due to the respondent's early exit.

  2. In the Responses tab, “-” indicates that no value was provided for certain questions or custom fields.

  3. In custom dashboards, when a response or value is missing for a question, we display Not Answered to clearly indicate the absence of a response.

    1. For Table widget the dimensions would show the value as Not Answered where the question was not filled by the respondent.

    2. In column, bar, or pie chart widgets, the legend displays Not Answered for responses where no value is provided.

  4. Filtering options to view or hide Not Answered values.

    1. If you wish to exclude Not Answered values from the widget, apply a filter by selecting all possible response options for the relevant question.

      1. Similarly, if you choose to display only specific values for a dimension, the "Not Answered" category will be excluded from the widget.

    2. Conversely, if you wish to display only the Not Answered entries, apply a filter using the Select All option combined with the Does Not Contain condition. This approach effectively isolates and displays only the unanswered responses.

    3. Similarly, you can apply the same filtering techniques to other visualizations—such as bar, column, or pie charts—in order to control the visibility of the Not Answered legends.

    4. You can view Not Answered with the help of a column chart.

Widgets Supported in CFM Custom Reporting

In the Customer Feedback Management Analytics module, you can incorporate customizable widgets into personalized dashboards for effective data visualization. These widgets allow you to engage with pertinent data sets, aiding you in listening, learning, and reacting to important developments as they happen. You have the option to add one or several widgets to a dashboard simultaneously.

The following is the list of widgets supported in Customer Feedback Management analytics:

Widgets  

Description 

KB Article Link 

Area Widget 

The Area widget helps display trends and patterns in data over time. The filled area below the line makes it easy to see the extent of the changes and compare them across different periods. 

Area Spline  

An Area Spline Widget is a chart used to visualise time series data, where a smooth curve connects data points and the area beneath the curve is shaded. It helps highlight patterns and trends more effectively than basic line or scatter plots. 

Bar  

A Bar Widget displays categorical or discrete data using horizontal bars, where the length of each bar is proportional to its value. It plots variable values horizontally and fixed dimensions, like time, vertically. This chart is ideal for comparing values across categories or groups. 

Column  

The Column Widget displays data using vertical bars, where each column represents a category and its height reflects the value or frequency. Similar to bar charts but vertically oriented, it’s useful for comparing values across categories, especially when data has a natural order like time. 

Counter 

The Counter Widget provides a quick summary of a key metric or KPI, such as Survey Response Count or NPS Score. It also supports drill-down for more detailed insights. 

Bubble  

  

  

Counter Summary  

The Counter Summary Widget offers a quick overview of key metrics like Insights Count or NPS Score and allows users to drill down for more detailed information. 

Crosstab 

The Cross Tab Widget displays data in a table matrix format, showing the interaction between two dimensions. Each cell represents the value for a specific dimension pairing, enabling real-time visualization of multiple metrics. 

Dot 

The Dot Widget is a chart that highlights trends and changes over time using distinct data points marked by dots. It can be customized with colors, labels, and axis scales for clear and precise data visualization. 

  

Dual Axis 

The Dual Axis Widget displays two data sets on a single chart, each with its own Y-axis, allowing comparison of metrics with different units or scales. It supports various plot types, commonly using line charts to compare variables like Survey Response count and NPS Score. 

Funnel 

A Funnel Chart visualizes stages in a process, typically sales, with sections shaped like a funnel—wide at the top and narrow at the bottom. The width of each stage represents the amount of data or potential revenue, helping identify where drop-offs or bottlenecks occur. 

Line  

The Line Widget is a chart used to show trends and changes over time by connecting data points with straight lines. It can be customized with colors, labels, and axis scales for clear and concise data representation. 

Pie 

A Pie Chart is a circular graph that divides data into slices, each representing a proportional part of the whole. It’s commonly used to show composition or distribution across different categories. 

Dynamic Table 

  

  

Pivot Table 

The Pivot Table Widget helps analyze and summarize large datasets by organizing data across multiple dimensions and attributes. It allows interactive exploration, drill-downs, and flexible layout adjustments, making it easier to uncover trends and insights. 

Quadrant Matrix 

The Quadrant Matrix widget displays data points in four quadrants on a scatter plot, helping visualise correlations between categories based on two chosen metrics, enabling insights into trends like volume vs. growth or ad spend vs. reach. 

Spline 

The Spline Widget visualizes data as a smooth, curved line fitted through data points, highlighting trends and patterns more clearly than traditional straight-line charts. 

Stacked Bar  

The Stacked Bar Widget uses horizontal bars divided into segments to show total values of categories and the contribution of subcategories. It allows easy comparison of totals across categories while highlighting the breakdown within each. 

Note:

You can test the feature in the following way:

  1. Design a survey that includes all types of questions and create survey link with custom fields values.

  2. Publish and fill 10 responses for each question type.

  3. An already active survey with responses can also be used.

  4. You can create several surveys using the same procedures and display them simultaneously on the same dashboard and create a new dashboard. 

  5. Go to widget builder, check the presence of all the default metrics and dimensions all the question added in the survey.

  6. Examine the metrics and dimensions of the survey, along with any relevant custom fields, and verify that the appropriate values are being utilized in the visual representations.

  7. Plot multiple widgets with metrics from just one question. Example: Counter widget.

  8. Plot multiple widgets with metrics and dimensions from multiple different questions of the same survey. Example: Bar chart, Line chart.

  9. Examine the outcomes obtained from the custom reporting dashboard alongside the standard analytics feed and response tab to identify any inconsistencies.

  10. Apply filters based on the associated custom field values and the standard survey-related dimensions and see if the data is being correctly filtered or not.

Note: Currently, all dimensions for all surveys are visible to anyone using a custom dashboard; governance and data control will be implemented in upcoming releases.


Best Practices

  • Control Access: Ensure only the relevant POCs have the correct level of access to the dashboard and survey data.

    • Assign Permissions Carefully: Assign appropriate Edit and View permissions to individual users and user groups.

  • Use Sections for Role-Based Views: Create separate sections tailored to different user roles (e.g., analysts), using clear and descriptive section names to help users quickly find the most relevant views.

  • Prioritize Key Widgets: Place the most important widgets at the top of the report for quick and easy access during analysis.

  • Design Role-Specific Dashboards: Understand the use case of each user. For example, a store manager’s dashboard should be designed to deliver quick insights within 5 minutes, with key widgets like NPS scores and a stream of latest responses placed prominently at the top.

  • Align with Client Analysts: Coordinate with client-side analysts to ensure that report structure and metric definitions align with the brand’s analytics framework and syntax.