Insights recipe: Reporting on CSAT and one-touch tickets

One-touch tickets provide insight into which customer inquiries can be resolved in one response from an agent. Often, customers will look at one-touch tickets as a source of inspiration for content in their Knowledge Base. However, without having context of how well the response resolves the inquiry, the article might not be relevant for your customer. To provide context, you’ll want to plot CSAT against the one-touch ticket types. This recipe will walk you through creating the report.

Skill level : Beginner

Ingredients :

• Two pre-built metrics: % Satisfaction Score, # One-Touch Tickets.
• One custom ticket field: About.

Building your report

The first step in reporting on CSATs and one-touch tickets is selecting the correct metrics and attributes in the What and How panels. This section will discuss what metrics and attributes to select and how to filter out values that could affect your report.

To select your metrics and attributes

1. Click the Reporting icon ( ) in the agent interface, then open the Insights tab.
2. Click the GoodData link in the top right corner.
3. Click Reports .
4. Click Create Report .
5. In the What panel, select # One-Touch Tickets and % Satisfaction Score.
6. In the How panel, select the About attribute. The About attribute will provide information on your ticket topic. If you have not added a custom field to capture the About field see, Adding and using custom ticket fields .
7. In the Filter Values column, select isn't from the drop-down list and check the (empty value) box. Any results with an empty value will be excluded from your report.

   

8. Click Done . After you finish adding your measures and attributes, you can then begin filtering your report.

Applying filters

To narrow down results, you will want to apply filters to your report. This example report filters the time range to the previous month and only displays the top five tickets.

To add filters

1. Click the Filters button.
2. Click Add Filter , then select the Select from a List of Values filter to add a new data filter.
3. Select Month/Year (Ticket Solved) as your attribute and last month for your floating range. This will filter results to tickets solved in the last month.

   

4. Click Apply .
5. Click Add Filter , then select Ranking filter.
6. Select the following information:

• For Select result size , click Top then enter five. For the ranking criteria select # Tickets. This will show you the top five ticket types that are solved with one-touch.
• For What do you want to rank? select the About attribute
• For the ranking criteria select # Tickets. Your results will now be filtered to the top five ticket types that are solved with one-touch.

Click Apply . After you click Apply , you can begin to customize your report.

Customize your report

Lastly, you'll want to adjust the graph, so the data is easy to visualize. This recipe uses custom configuration options to change how results are represented.

To customize your report

1. Click the Show configuration link in the upper right hand corner.
2. In the Vertical (Y) drop-down list, select # One-touch Tickets as the primary axis and % Satisfaction Score as the secondary.

   

3. If you would like to replicate the chart below. You will need to edit your chart in Advanced configuration .
4. Click the + button next to Axis Y to expand the axis settings.
5. Underneath # One-Touch Tickets, select the Bar chart type.
6. Underneath % Satisfaction Score, select the Area chart type.

   

7. Click Hide to hide the Configuration menu again.

You will now have a graph that shows the top five one-touch ticket types with the highest CSAT. This graph can be a great first step to determine the topics for Knowledge Base articles.