Start a conversation

Reports and KQL

Understand what's really happening in your helpdesk with Kayako Classic reporting.

  • Introduction to building and running reports

    Reports in Kayako Classic lets you access the huge amount of data in your helpdesk and turn that data into useful information. Accessing and Running Reports Login to the staff control panel, and click...

  • Report types in Kayako Classic

    Kayako Classic reports are capable of producing various types of report layout. The way a report is displayed depends on how you structure your report query using a KQL statement. Tabular Report The t...

  • Introduction to Kayako Query Language (KQL)

    Your Kayako Classic helpdesk contains a variety of out-of-the-box reports, so if you're not comfortable writing your own reports using the Kayako Query Language, don't worry. See our Introduction to b...

  • Creating common SLA reports with KQL

    Service level agreements (SLAs) and escalations both play a major role in support industry. It is one of the ways to ensure you're providing good customer service in a timely manner. Using Kayako Clas...

  • KQL Condition & Operator Reference

    This article services as a reference resource to help you build complex KQL queries.  Conditions and Operators Operator KQL Example Results = SELECT'Chats.Chat ID'FROMChats WHERE'Chat.Department'= 'Te...

  • Optimizing KQL reports

    Optimization is challenge, no matter what you're doing, and unfortunately reporting in Kayako Classic is no exception. How to most effectively make the process of writing, rendering, and processing re...