Number of reopened tickets per day | Community
Skip to main content

Number of reopened tickets per day

  • January 12, 2022
  • 7 replies
  • 0 views
Julia17

I have to report the number of reopened tickets on a daily basis but I cannot find an appropriate timestamp to do it. There are timestamps as ticket solved - date, ticket updated - date or even update date (= ticket & ticket updates datasets) but non of them will ever show me the correct number of reopened tickets per day. 

Can you please help me to query the number of reopened per day?

      7 replies

      C
      • Chandra13
      • January 13, 2022

      The Update - Date attribute should help get you what you're looking for. After building a query using that date attribute and doing some quick QA on my end, it appears to be returning the results I'd expect. What does your query look like currently?

      Julia17
      • Julia17
      • Author
      • January 13, 2022

      I actually compared the reopened tickets for 3 different dates: Ticket solved - Date, Ticket updated - Date and Update - Date. The results are all completely different. Because we missed many tickets with the first 2 dates (= ticket dataset), we already decided to go for the Update - Date of the ticket updates dataset. I checked again some tickets and it seems to work.

      Do you have a documentation about dates and its corresponding metrics or similar one as for metrics & attributes? This would be great!

      Thanks a lot for your support.

      M
      • Marco29
      • January 13, 2022
      Hi Julia! Chandra's suggestion is spot on. I can't find any specific documentations regarding it, but basically ticket solved - date would only show tickets solved on the dates listed, ticket updated - date takes into account the latest update made on the ticket, and update - date will look into the update made relevant to the report, which in this case is when the ticket was reopened. 
       
      Hope this clarified it for you! Cheers! 
      Lindanne
      • Lindanne
      • April 25, 2022

      How can I get the daily number or reopened tickets(email and WhatsApp) if I do not have explore? Our plan is Suite Growth.

      G
      • Gab12
      • May 16, 2022
      Hi Lindanne,
       
      I'm afraid that aside from Explore, there are no other native reporting options that will allow you to get the count of reopened tickets. Your current plan should have access to Explore Lite which gives you access to the prebuilt dashboard, and in the Zendesk Support dashboard, there's a widget for percentage of Reopened tickets. This wouldn't give you the exact count, but as alternative, you can filter the dashboard this to see the reopen rate/percentage for email and WhatsApp tickets for a specific date. 
      Taylor27
      • Taylor27
      • May 23, 2023
      Could you think about reopen rate as the opposite of this metric that we have:
      • One-touch tickets: The percentage of messaging tickets that were solved in the first interaction, determined by transitioning from Open to Solved, without going through Pending or On-hold.
      So if your One-touch % is 80% that means your reopen rate is 20%?
      F
      Hi Taylor!

      To complement the definition you posted, please review this article. It is specifically mentioned (in the article) that even in the case the ticket is reopened by a customer posting a comment (such as 'Thank you') and the agent solves the ticket without replying back, it'd still count as a one-touch ticket, while simultaneously counting as a reopened ticket.

      Also, a ticket could neither be reopened nor considered one-touch if the customer does not reply after it is solved, but it is marked as 'Pending' or 'On-hold' throughout its lifetime.

      Therefore, I'd be cautious to affirm that the sum of one-touch and reopen tickets would equal the total amount of tickets or that their percentages are complementary.

      Hope this helps!

      Best,
      Fran
      Terms & ConditionsCookie settingsAccessibility statement