6 min read
4 steps to turn your support tickets into an automated dashboard
The Metabase Team
‧ 6 min read
Share this article
Understanding why customers contact your support team helps you improve your products and services. By analyzing your support ticket data, you can spot problem areas to focus on, and then build resources, product improvements, and processes to reduce your ticket resolution time, and (ideally) the number of tickets customers need to submit in the first place.
To get started, you’ll need a ticketing system, like Zendesk or Freshdesk, with a batch of tickets in the system.
1. Create a few lists from your existing ticket data
Make a table of ticket reasons and their definitions
List the most common reasons people file a support ticket. Keep the reasons short and concise. For example,
Feature Request. Use your existing tickets to determine ticket reason. You can export ticket data and do a keyword search to find reasons, or use any built-in field features to filter and narrow down by types.
See our list below to get an example of how to structure your list.
|Billing or plan related matters
|Product is broken in some way - issue labeled as Type:Bug in Github
|Customer put in issue multiple times.
|Enhancement to product - issue labeled as “Type:New Feature” in Github
|A customer is seeking guidance on best practices or how to use the product
|Answering questions about plans, pricing
|System is down
|Helping customers figure out why things aren’t working as expected
List product or service areas to focus on
Next, go through your tickets and write down a list of product and service areas.
If you don’t have a lot of tickets to work with, you can think of a few features that your customers interact with the most to begin a list. For example, if you have an online store, you can create a list based on general areas like cart, accounts, wishlist, etc. Once you receive new tickets, you can go back in and update these options with more concrete areas.
As an example, we label our
How To, or
Troubleshooting tickets with a product or service area to help us filter across ticket reason, which we’ll talk about a bit in an example below.
If you’re a SaaS or tech-based company, here are some example product and service areas we use:
- Dashboards and Visualizations
- Database connection
- GUI Querying
- SSO or Authentication
- SQL Querying
Create a list for any additional trending areas
When we first labeled our tickets by ticket reason and product area, we found that 1/3 of our support tickets are related to business operations. To collect more info about these tickets, we created a biz ops field, and that helped us chart and find additional areas to focus and improve on.
Biz ops could be a helpful field to add if you’re working with accounts, subscriptions, or billing. If you’re interested in creating this list specifically, here’s the list we made:
- Billing question
- Can’t find account
- Cancel subscription
- Delete Account
- Extend trial
- Password / Password reset
- Provide backup
- Reactivate Trial
- Upgrade from open source
- Upgrade from Starter to Pro
2. Use your lists to create custom fields in your ticketing system
Now it’s time to plug those lists into your customer ticketing system. Create a custom field for ticket reason, product or service area, and additional areas, like biz ops, in Zendesk or any ticketing system you’re using. Use a dropdown menu or one-input method. Giving your team the ability to choose only one option per field will allow you to group data with better accuracy.
After you’ve set up your custom fields, it’s time to start labeling tickets. Label a batch of existing tickets with reasons and areas. You can also require reason and areas to be filled in before a ticket is marked as solved, which will help you maintain a steady stream of new, incoming ticket data.
3. Connect your ticket data to your BI tool
To move the ticket data to your database or warehouse, and into your BI tool, you’ll need to use an ETL tool or a connector. For example, to move data from Zendesk to Metabase, we use use Stitch for ETL. You can find an open source or low cost ETL tool to add yourself, or work with your engineering team to implement a more robust data pipeline. Zendesk also offers apps, which allow you to connect directly to certain BI tools, like Tableau.
We also use a reverse ETL tool called Census. Building a pipeline with reverse ETL tooling can help you push organizational data back to your ticketing system, like customer org ID, subscription status, support tier, etc. Pushing org data from your data warehouse to your ticketing software is only necessary if you want that data on hand in the ticketing software when responding to tickets.
4. Create a dashboard with the results
Once your ticket data is flowing into Metabase, or whichever BI tool you’re using, you can start asking questions. For example, you can ask yourself, “What is our most common ticket reason?” or “Which product areas have the most tickets?” These questions will help narrow down which data to focus on, and find the results you’re looking for.
For example, if you notice a particular ticket reason trending week-over-week, you can click on any point in a chart and select “View these Tickets”. Note: This feature only works with questions built in the query builder, not in native query.
If you’re using Zendesk, ticket type is a default field that you can use to filter ticket data across ticket reason and areas. Some other default fields that may be useful are “status” and “priority”.
To get an idea of how many tickets are considered problems versus general questions in Metabase, you can drill-through to a specific ticket reason and filter by ticket type. Use the summarize button to summarize tickets by count, and choose to group by type. Sort the tickets in descending order, and visualize as a bar chart.
With a support ticketing dashboard, you can also track ticketing trends, like top 5 ticket reasons or areas, and send weekly reports to your team and company. Metabase dashboards allow subscribers, so people can subscribe to your dashboard and get updates directly to their email inbox or in Slack.
- You can send people to a custom URL from a Metabase dashboard. Link batches of tickets using this feature so people can readily access the original tickets.
- You can also use Metabase Actions to create custom buttons for your dashboard, and forms for feedback. Implement actions to remove redundant data, or add new data as your support team monitors other channels.