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

    • 年内最後のユーザー向けイベント：5名限定！ 課題解決型ワークショップイベント Zoho ワークアウト開催のお知らせ (12/18)

      ユーザーの皆さま、こんにちは。コミュニティチームの中野です。 12月開催のZoho ワークアウトについてお知らせします。 今回はZoomにて、オンライン開催します。 参加登録はこちら（無料） https://us02web.zoom.us/meeting/register/QHn6kJAcRs-znJ1l5jk0ww ━━━━━━━━━━━━━━━━━━━━━━━━ Zoho ワークアウトとは？ Zoho ユーザー同士で交流しながら、サービスに関する疑問や不明点の解消を目的とした「Zoho ワークアウト」を開催します。

    • How do I get my account id?

      Hello, I followed the instructions to get a list of accounts of the currently authenticated user (which is me, and I am logged in). But when I follow the below instructions I get the following error: ERROR: {"data":{"errorCode":"INVALID_TICKET","moreInfo":"Invalid ticket"},"status":{"code":400,"description":"Invalid Input"}} Instructions that I am following: GET - User account details Purpose The API retrieves the list of accounts of the currently authenticated user.  Request URL  http://mail.zoho.com/api/accounts

    • Zoho Quartz Screen Recording

      Hello, can we get access to Quartz, please, as a standalone solution? It would be great for creating training videos for current and future staff on how to use Zoho software according to our company requirements. Thank you

    • auto close automated alert tickets which are similar

      Hello ZOHO Community, we are using ZOHO Desk to process automated monitoring alerts. Scenario: Our monitoring system creates a ticket when a threshold is exceeded, e.g. Subject: Computer 1 – CPU usage 100% – Error A few minutes later, once the issue resolves

    • Maintain knowledge base integrity by moderating article comments

      Hello everyone, A knowledge base provides a self-service platform where customers can refer to articles, user manuals, and other resources to learn about the company's products or services and troubleshoot problems. Often, readers leave a comment on the

    • Making another calendar your default calendar

      I am trying to make another calendar my default calendar when I add events to it. It keep going to a single calendar, I need it to go to my google calendar by default, as this is linked to other services / websites. I cannot find an option to make it

    • Option to Delete Chats in IM

      Currently, there is no option to delete any chats in IM, regardless of their source.

    • Referencing a cell from another sheet

      My workbook has multiple sheets. Each sheet has some calcluated totals in certain cells. The front master sheet has a list of everything that is detailed on the other sheets, with the totals. These could change at any time, so the totals need to be references to the other cell's value, not a fixed number. So on the master sheet, I put in =, then go the other sheet and choose the cell and hit Enter. In regular Excel, this works. But in the Zoho sheet, it doesn't work. I have to edit the result by

    • Group mail for external email addresses

      Hello, I was just wondering if the Group mail feature works with external email addresses - e.g. gmail.com or a completely different domain? it seems only internal addresses (hosted with Zoho) receive the mail. Thanks, Oliver

    • The email address you have entered belongs to a different deployment/region.

      Hi, I am trying to create the user - mprust@crombiecomputers.co.uk but keep getting the message below -  The email address you have entered belongs to a different deployment/region. Please contact support@zohoaccounts.com for assistance. Look forward

    • Use Zoho Flow Credits for CRM ‘Actions by Zoho Flow’

      Hello Team, We would like to submit a feature request regarding credit usage for “Actions by Zoho Flow” in Zoho CRM. Use Case: We are Zoho One users and actively use Zoho Flow, where our organization has 52,000 Flow tasks per month. In Zoho CRM, we use

    • Unusual activity detected from this IP. Please try again after some time.

      Hello Zoho admin and IT team We are a registered website in Eloctronic services and we been trying to add our users to the zoho system but this issue faced us ,, hope you unlocked us please.

    • Alert if a field is ticked.

      Hi There, We have two modules named Opportunities (Deals) and End Users (CustomModule1), as per the image below. Within Opportunities, we have a lookup field that looks up from the End Users Module. We are looking to get an alert either via email or another

    • Zoho CRM Analytics - Allow To Reorder Dashboards

      I would like to suggest that you add the ability to reorder dashboards in the Analytics Module. I can see that this has been requested some time ago, the latest 9 years ago. I am not sure if this is a big or small endeavor, but such a small fix can go

    • Sending a Template to Sign

      hi, trying to send a template to be signed using this as a test: $accessToken = "1000.xxx" $templateId = "1234" $uri = "https://sign.zoho.eu/api/v1/templates/$templateId/createdocument" $payload = @{ templates = @( @{ template_id = $templateId request_name

    • Adding Choices in a Sub-Form Dropdown

      Hi, Has anybody tried Adding Choices to a Dropdown in a Zoho Creator Sub-Form programmatically? My Deluge code adds rows to a subform with 2 fields A and B. A - text field. B - dropdown. My Deluge script adds the row and displays A successfully. For the

    • Zoho CRM Email Templates 100% Width No Background How?

      Hi, On the Zoho CRM Email Templates in setup > customization > templates > new templates > I choose blank template, but still it puts in a gray background and a max width for the email. I just want to make an email that looks like an email I would send from gmail that has no background or max width. How do you do this? 

    • Checking client unsubscribe details

      Hi team, Can you please let me know where we can check if a client has unsubscribed, along with the date and time it was done? If this information is not available at our end, please help confirm the unsubscribe date for the below email ID from the backend:

    • Cancel zoho one only want to keep zoho vault

      Hello, I would like to cancel my Zoho One subscription and continue using only Zoho Vault. Please ensure that all existing data in Zoho Vault remains intact and is not removed. This month will be my final month under the Zoho One subscription. Thank

    • Scan and Fill CRM Lookup Field

      Not sure if there is a reason why this isn't possible or if I'm just missing it. But I would like to be able to use the scan and fill feature on the mobile app to prefill the CRM lookup field and fetch the rest of the data in the form.

    • Customer Management: #2 Organize Customers to Enhance Efficiency

      When Ankit started his digital services firm, things felt simple. A client would call, ask for a website or a one-time consultation, Ankit would send an invoice, get paid, and move on. "Just one client, one invoice. Easy.", he thought. Fast forward a

    • Zoho Mail and Zoho Flow integration to automatically create ToDo tasks from outbound emails

      How do i setup Zoho Mail and Zoho Flow integration to automatically create ToDo tasks from outbound emails

    • Attachments between Zoho and Clickup, using Flow.

      Olá suporte Flow, tudo bem ? Estamos usando o flow para integrar Zoho Desk com o clickup. Não localizamos a opção de integrar anexos entre do zoho Desk para o clickup. Gostaríamos de saber se migrando para o plano pago, teremos suporte para fazer a integração

    • Adding an Account on Zoho Mail Trigger in Zoho Flow

      I'm trying to create a flow using the zoho mail trigger "Email Receive". My problem is that when I select this trigger, it only shows one account from the account dropdown. I'm planning to assign it on a different email. How can I add other email ad

    • Linnworks

      Unless I am missing something, the Linnworks integration is very basic and limited. I have reached out to support but the first response was completely useless and trying to get a reply in a timely manner is very difficult. Surely I should be able to

    • Test data won't load

      I am using a Flow to receive orders from WooCommerce and add them to a Zoho Creator app. I recently received an order which failed, and when attempting to test the order I found that it just shows a loading animation and shows up in the history as "queued."

    • AddHour resets the time to 00:00:00 before adding the hour.

      Based on the documentation here: https://www.zoho.com/deluge/help/functions/datetime/addhour.html Here's my custom function: string ConvertDateFormat(string inputDate) { // Extract only the date-time part (before the timezone) dateTimePart = inputDate.subString(0,19);

    • WhatsApp Link is not integrating

      Hello, I am using zoho flow. when new row added in google sheet it sends email to respected person. In email body I have a text "Share via WhatsApp". behind this text I putted a link. But when the recipient receives email and wants to share my given info

    • Zoho flow - Webhook

      If I choose an app as a trigger in Zoho Flow, is it still possible to add a webhook later in the same flow?

    • Zoho Flow + Bigin + Shopify

      We are testing Zoho Flow for the first time and want to create a flow based in first purchases. When a client makes his first order, we're going to add the "primeiracompra" (first order) tag to his account in Shopify (it's not efficient, but that's the

    • Is it The Flow? Or is it me?

      I want to do some basic level stuff, take two fields from a webhook, create a zsheet from a template using one field with date appended, create a folder using both fields as the name, and put the zsheet into that folder. I was going to elaborate - but

    • Having problem with data transferring from Google sheet to ZMA

      When connecting Google sheet with Zoho marketing automation it is having the email as a mandatory field. Can I change it as non-mandatory field or is there any other way to trasnfer data from google sheet to ZMA. I have leads which we get from whatsapp,

    • Dropbox to Workdrive synchronisation

      I want to get all the files and folders from Dropbox to Workdrive and each time a new file or folder is added in dropbox i want it to be available in Workdrive and wise versa. Sync Updates to Files Trigger: "File updated" (Dropbox). Action: "Upload file"

    • Microsoft Planner Task to Service Desk Plus Request - error n4001

      Hi there. I'm trying to create a flow that will create a new request in ServiceDesk Plus when a new task is created in Microsoft Planner. I have succesfully connected both Planner and ServiceDesk Plus, and have configured the 'create request' section

    • Trailing Space in "Date and time scheduled "

      I am trying to use the Zoho Projects - Create event action in a flow. It is failing with the output error as: "Action did not execute successfully due to an unknown error. Contact support for more details." The input is: { "Duration - Minutes": 30, "Project":

    • Project name by deal name; project creation via flow

      Hello, I want to create a project in zoho projects using flow by a trigger at the crm. My trigger is the update of a deal (stage). The project name should be the account name/ deal name. But I dont find the solution to it. Can you please give me the answer

    • Slack / Zoho Flow; Repl

      I am trying to add a comment in a zoho ticket when someone reply's to a message in a thread. The Message posted to public channel trigger doesn't seem to pick up thread messages. I also cannot use the thread_ts field as it doesn't seem to pull that in.

    • Get Holiday ready with Zoho Mail's Templates

      As the holiday season approaches, it’s time to step away from work and unwind. You may not be able to respond to every email or send individual messages to wish everyone holidays greetings—but It is still important to stay connected. How do you send thoughtful

    • Customize folder permissions in a Team Folder in a Team Folder via zoho Flow

      HI All, on the nth level folder of a team folder I would like to Customize folder permissions when it's created in the flow of Creating folders. That last level I only want to grant access to a specific group, goup ID 201XXXXXXXX. Can you help with a

    • Associating a Candidate to a Job Listing

      Hello, I am trying to use Zoho Forms embedded on my website for candidates to apply for a job opening. I want the form then to tie directly with zoho recruit and have the candidate be automatically inputed into Recruit as well as associated with the specific

    • Next Page