Sixth Insight - The Hidden C in Data

Sixth Insight - The Hidden C in Data

The Wheels of Ticketing - Desk Stories

The Hidden C in Data

[Importance of clean data]


Data cleaning

Data cleaning ensures ticketing systems' data is accurate, consistent, and complete. This process includes eliminating duplicates, fixing errors, and addressing missing information.
Quote
Clean data is happy data.

Why is data cleaning so important?

Data cleaning eliminates errors, inconsistencies, and duplicates within data, resulting in increased accuracy. Tools are available to help you swiftly address data issues. Enhancing accuracy enables the extraction of reliable insights. Inconsistent or inaccurate data can lead to misleading results, poor decision-making, and ineffective strategies.

Data hygiene

Data hygiene in a ticketing system refers to the processes and practices involved in maintaining accurate, complete, and consistent information. This is crucial for ensuring that customer support operations run smoothly and effectively.


  • Data accuracy
  • Data completeness
  • Data consistency
  • Data deduplication
  • Regular data audits


By prioritizing data hygiene, organizations can improve the efficiency of their support teams, enhance the quality of customer service, and gain valuable insights from reliable data analytics.

A story for better interpretation

Scrub your data clean

Once upon a time, a small but dedicated team in a tech company managed customer support through a ticketing system called "HelpNow." As the company grew, so did its customer base, leading to an overwhelming influx of support tickets. Although the team worked diligently, the increase in tickets created clutter. 
 
Once efficient, the HelpNow system became cluttered with old tickets, unresolved issues, and duplicate requests. Customer satisfaction started to decline as users waited longer for their problems to be resolved. Frustration lingered not only in the hearts of customers but also within the support team, which they found increasingly challenging to navigate through the cluttered ticketing system.
 
One day, the team lead, Joey, called for a meeting to address the urgent situation. "We need to scrub our data clean," he announced. The team discussed various strategies, but he had a vision of what needed to be done and a systematic approach to decluttering their HelpNow system.
 
The initial step entailed thoroughly reviewing and categorizing all existing support tickets utilizing a custom view. The team reached a consensus to archive tickets over six months old and lacked follow-up, as these were likely associated with resolved issues. To ensure efficient progress, they established a clear deadline for this undertaking, fully aware that collaborative effort and focused teamwork were essential for effectively addressing the backlog. Their strategic approach aimed to organize the current workload and foster a more streamlined process for ticket management.
 
Joey organized a “Scrub-a-thon” a week later, encouraging everyone to join forces. Each team member was assigned a category of tickets to review. Deleting duplicates became a friendly competition. Teams found ways to delete tickets using mass updates and automation, rewarding those who could clear the most entries. They quickly learned that many tickets had been created multiple times due to customers submitting the same request across different channels.
 
During this process, the team discovered an unexpected treasure trove of information. Many old tickets contained insightful feedback about the product, creating a new FAQ section that addressed common user questions. They also realized that some bugs needed urgent attention, leading to prioritized fixes for the product.
 
As the Scrub-a-thon continued, the team also acknowledged the importance of customer communication. They crafted an email update to inform customers about their efforts to improve support quality. Customers appreciated the transparency and felt confident that their concerns were being taken seriously.
 
After two weeks of hard work, their system was transformed. The volume of tickets had been dramatically reduced, and the remaining tickets were prioritized and categorized effectively for quicker solutions. Customer agents could easily navigate the system and focus on resolving issues rather than wading through a digital maze.
 
Reports generated from the cleaned data helped Joey and her team identify trends in customer inquiries and revamp their product support resources accordingly. Inspired by their findings, they implemented a new self-service help widget to empower users with immediate solutions. 
 
The results were incredible: response times dropped, customer satisfaction surged, and the support team thrived in their more organized environment. The HelpNow system became a case study in transforming mess into clarity, demonstrating the power of scrubbing away the unnecessary to unveil the valuable.

Best practices

Scheduled data audits

Scheduled data audits are the systematic process of regularly reviewing and analyzing data within a specific timeframe to ensure accuracy, compliance, quality, and relevance. This practice is essential for businesses and organizations to maintain the integrity of their data, identify errors, and ensure adherence to regulations and standard policies.

Removing inaccurate data entries

Removing inaccurate data entries means eliminating incorrect, erroneous, or misleading information entered into a system. These inaccuracies can occur for various reasons, including human error, technological glitches, data migration issues, or a lack of standardized procedures. 

Setting up field validations

Setting up field validations is crucial in ensuring data integrity and enhancing the user experience in any application. Field validations check users' input to ensure it meets specific criteria before being processed or saved. Validation rules in Zoho Desk help you overcome this problem by arresting incorrect data even before it can enter your help desk. Refer here for more details.

Detecting duplicate data

Duplicate data detection is crucial for maintaining data integrity and accurate records. The deduplication feature in Zoho Desk helps you find duplicate records in bulk and merge them.  Refer here for more details.

Addressing data security

Addressing data security involves implementing measures and practices to protect sensitive information from unauthorized access, breaches, and other cyber threats. Encryption takes the final stand against attempts to steal your data. It completes data protection by ensuring your data can neither be damaged nor stolen in the unfortunate event of a security breach.. Refer here for more details.

Inactive record management

Inactive record management involves managing records that are no longer in active use or required for daily operations. This encompasses outdated documents, files, or data that must be preserved for prospective reference, even though they do not require frequent access. In Zoho Desk, ticket management is simplified by automating the archiving of follow-up-less tickets over six months old by a deadline.. Refer here for more details.

Integrate data with analytics

Data analysis helps identify inconsistencies. Data analytics can automatically identify and flag inconsistencies within datasets. This helps agents quickly pinpoint errors or anomalies that might go unnoticed, improving the overall data quality. Data analytics can assess the quality of the data in real-time. It can provide metrics on completeness, accuracy, and consistency, giving agents the insights needed to ensure that the data they are working with is reliable. Refer here for more details.

Summing up

Ensuring a clean and accurate database is crucial for the effective operation of Zoho Desk. Data cleaning is not simply a one-time task; it requires a continuous effort to maintain the integrity and reliability of customer information. 


Establishing clear protocols and guidelines for data cleaning will ensure that agents understand their responsibilities and take accountability for upholding data quality. Mastering data cleaning practices will enhance your success.


Please stay tuned for more Desk Module stories.

 

Cheers,

 

Kavya Rao

The Zoho Desk Team




        • Recent Topics

        • How to drag row(s) or column(s)?

          Hi. Selecting a row or column and then dragging it to a new position does not seem to work. Am i missing something or this is just not possible in Zoho Sheet? Cheers, Jay

        • Building Toppings #5 - Creating and configuring custom service connections in Bigin Toppings

          Hello Biginners, Integrating Bigin with external applications extends its capabilities and enables customized functionalities. In our last post, we saw how to create a default service connection. Today, we'll see how to create a custom service connection

        • Optimising CRM-Projects workflows to manage requests, using Forms as an intermediary

          Is it possible to create a workflow between three apps with traceability between them all? We send information from Zoho CRM Deals over to Zoho Projects for project management and execution. We have used a lookup of sorts to create tasks in the past,

        • Marketing Tip #15: Rank better with keyword-rich URLs for product pages

          Your product page URL is a small detail that can make a surprisingly big difference. Clean, readable URLs help in two ways: They’re easier for customers to trust and remember (no one likes clicking a link that looks messy or random). They help search

        • Conditional fields when converting a Lead and creating a Deal

          Hi, On my Deal page I have a field which has a rule against it. Depending on the value entered, depends on which further fields are displayed. When I convert a Lead and select for a Deal to be created as well, all fields are shown, regardless of the value

        • ATE Session on Payment Gateways: Our experts are live now. Post your questions now!

          Hello everyone, Our experts are all excited to answer all your questions related to payment workflows. Please feel free to join this session and learn more about this topic. If you have a query at anytime, please post them here.

        • Upload data deleted all Zoho form data that we manage

          Good morning. Let me introduce myself, I'm Iky from Indonesia. I'm experiencing an error or problem using Zoho Forms. I manage Zoho Forms, but I previously encountered an error when I misclicked the delete button in the upload format. It apparently deleted

        • ZOHO FORMにURL表示ができない

          初心者です。 ZOHO FORM で宿泊者名簿を作っています。 ゲストが、URLをクリックするとStripeで支払いができるようにURLを表示をしたいのですが、 上手くできません。 やり方が分かる方、ぜひ教えてください。

        • Custom module - change from autonumber to name

          I fear I know the answer to this already, but thought I'd ask the question. I created a custom module and instead of having a name as being the primary field, I changed it to an auto-number. I didn't realise that all searches would only show this reference.

        • No Automatic Spacing on the Notebook App?

          When I'm adding to notes on the app, I have to add spaces between words myself, rather than it automatically doing it. All my other apps add spacing, so it must be something with Zoho. Is there a setting I need to change, or something else I can do so

        • Holidays - Cannot Enter Two Holidays on Same Day

          I have a fairly common setup, where part-time employees receive 1/2 day's pay on a holiday and full-time employees receive a full day's pay. Historically, I've been able to accommodate this by entering two separate holidays, one that covers full-time

        • Zoho Bookings and Survey Integration through Flow

          I am trying to set up flows where once an appointment is marked as completed in Zoho Bookings, the applicable survey form would be sent to the customer. Problem is, I cannot customise flows wherein if Consultation A is completed, Survey Form A would be

        • Campaigns set up and execution assistance

          Hello Community, Can someone recommend a professional who can assist with the completion of my set up and deployment of Campaigns? Looking for a person or company that is not going to ask for big dollars up-front without a guarantee of performance to

        • Zobot with Plugs

          Hello, I am having a problem with Zobot using Plugs. Here is my current flow: When I run the flow, I should immediately see the messages from the initial cards (Send Message cards), then after running the plug, and finally, see the messages after the

        • Kaizen #223 - File Manager in CRM Widget Using ZRC Methods

          Hello, CRM Wizards! Here is what we are improving this week with Kaizen. we will explore the new ZRC (Zoho Request Client) introduced in Widget SDK v1.5, and learn how to use it to build a Related List Widget that integrates with Zoho WorkDrive. It helps

        • Remove Powered by Zoho at the footer

          Hi, I've read two past tickets regarding this but it seems that the instructions given are outdated. I assume the layout keeps on changing, which makes it frustrating for me to search high and low. Please let me know how exactly do I do this now? Th

        • Error AS101 when adding new email alias

          Hi, I am trying to add apple@(mydomain).com The error AS101 is shown while I try to add the alias.

        • No Need To Fix Something That Is Working

          Zoho Books is a great financial tool which helps businesses to become more efficient and productive with day-to-day operations. As such, every change, upgrade, improvement needs to be carefully thought before implemented in the software and I'm sure Zoho

        • Using email "importance" as workflow-criteria

          I'd like to set up a workflow that triggers if an incoming email has been flagged as "high importance" but I'm not seeing any way to do that. Hopefully I'm just missing something obvious...?

        • This domain is not allowed to add. Please contact support-as@zohocorp.com for further details

          I am trying to setup the free version of Zoho Mail. When I tried to add my domain, theselfreunion.com I got the error message that is the subject of this Topic. I've read your other community forum topics, and this is NOT a free domain. So what is the

        • What is Resolution Time in Business Hours

          HI, What is the formula used to find the total time spent by an agent on a particular ticket? How is Resolution Time in Business Hours calculated in Zohodesk? As we need to find out the time spent on the ticket's solution by an agent we seek your assistance

        • Check & Unchecked Task Segregation in Export

          It must have a feature to represent checked and unchecked tasks as [ ] and [✅] respectively when exporting it to Arratai or WhatsApp ; as Keep Notes by Google contains…

        • WorkDrive Download Issue

          My client has been sending me files via WorkDrive, which generally has worked fine. Recently files won't download at all. If you try and individually select and download a file, a popup will appear in the bottom right saying it's preparing and then it

        • Resolution Time Report

          From data to decisions: A deep dive into ticketing system reports What are time-based reports? Time-based reports are valuable tools that help us understand how well things are going by breaking down key metrics over specific periods. By tracking, measuring,

        • Support Custom Background in Zoho Cliq Video Calls and Meetings

          Hello Zoho Cliq Team, We hope you are doing well. We would like to request an enhancement to the video background capabilities in Zoho Cliq, specifically the ability to upload and use custom backgrounds. Current Limitation At present, Zoho Cliq allows

        • Add RTL (Right-to-Left) Text Direction Button in Zoho Cliq

          Greetings Zoho Team, We would like to request the addition of an RTL (Right-to-Left) text direction button in Zoho Cliq, similar to what is already available in other Zoho apps like Zoho Desk. Currently, while using Zoho Cliq with the English interface,

        • Enable Backgrounds and Video Filters for 1:1 Cliq Calls Across All Zoho Entry

          Hello Zoho Cliq Team, We hope you are doing well. We would like to request an enhancement related specifically to 1:1 video calls in Zoho Cliq. Current Behavior Zoho Cliq currently provides background and video filter options in the following scenarios:

        • Zoho Flow: Stripe a Zoho Marketing Automation

          Hola! Quiero hacer un flujo con Zoho Flow, para que cuando se haga un pago en Stripe, añada el lead en Zoho Marketing Automation. Lo he configurado, configurando el disparador como "Payment created" y mapeando el campo de Stripe "Receipt email address".

        • Not able to delete a QC nor able to revert or create a cycle of manufacturing for QC failed Jobs

          Not able to delete a QC nor able to revert or create a cycle of manufacturing for QC failed Jobs

        • Need Customer Item Inward Module along with QC

          Need Customer Item Inward Module along with QC 1. Using Transfer Orders hit the item balance sheet 2. Items without inventory it becomes difficult for tracking purpose. 3. Custom Modules become tedious to capture multiple items, item subforms are not

        • LESS_THAN_MIN_OCCURANCE - code 2945

          Hi I'm trying to post a customer record to creator API and getting this error message. So cryptic. Can someone please help? Thanks Varun

        • Zoho email

          I need a list of email addresses of all contacts on my zoho

        • Shift-Centric View for Assigning and Managing Shifts in Zoho People

          Hello Zoho People Product Team, Greetings and hope you are doing well. This feature request is related to Zoho People - please don't move it to zoho one! We would like to submit a feature request regarding the shift assignment and management view in Zoho

        • Introducing parent-child ticketing in Zoho Desk [Early access]

          Hello Zoho Desk users! We have introduced the parent-child ticketing system to help customer service teams ensure efficient resolution of issues involving multiple, related tickets. You can now combine repetitive and interconnected tickets into parent-child

        • cant upload images in signature- urgent help needed. ta!

          HI, I have been trying to insert the company logo in the signature. i have tried it several times since yesterday, the longest I waited was 1 hour and 12 minutes for the pop up window to upload a 180 KB .jpg file. what am i doing wrong.. an urgent reply

        • Add Ticket button in Home view

          When I go to the My Tickets or the Knowledge Base view in our Help Centre, the Add Ticket button is available, but not in the Home view. I would really like for it to be displayed in the Home view as well. Is this possible? Thanks.

        • Problem using Zoho Desk API

          Goodmorning, I am trying to use the Zoho Desk API to create a dashboard in Grafana, but I am having a problem. Following the instructions in the API documentation, I created the API Console application (server-based application). Then I created the string

        • Add zoho calendar to google calendar

          Hi I keep seeing instructions on how to sync Zoho CRM calendar with google calendar but no instructions on how to view Zoho calendar in my google calendar.

        • How to print a label from zoho creator app?

          Hello, I would like to print a label from zoho creator app record similar to attached one. Size 74mm x 102mm. I tried record template. It leaves plenty of space around the content and also I couldn't set the height of the page. So it is not printing properly. Could someone please direct me to right direction for this requirement?

        • City field suggestion in Zoho Books

          Hi team, We are using Customers module in Zoho Books. In the Address section, we want to understand whether the City field can show suggestions while typing using any API or built-in feature. For example, if a user types “Mum”, can the system suggest

        • Next Page