Zoho Analytics is an on-demand reporting and business intelligence solution that helps you derive insights on your business data through its powerful reporting and analytical capabilities. You can create dynamic reports in minutes, with no IT help.
It offers the following important capabilities:
Zoho Desk Advanced Analytics Connector enables you to import your helpdesk data in Zoho Desk into Zoho Analytics for advanced reporting and analysis. This connector brings in all the capabilities of Zoho Analytics described above to Zoho Desk users.
Users with paid accounts of both Zoho Desk (Professional and Enterprise plans) and Zoho Analytics (atleast the Basic plan) can avail this connector.
Note: Only users with Administrator privileges in Zoho Desk can set up the integration.
The advantage of using the Zoho Desk Advanced analytics add-on over the reports tab inside Zoho Desk is tabulated below.
| Reporting Module in Zoho Desk |
Zoho Desk Advanced Analytics |
| Users can create only tabular, summary and matrix reports. |
It offers over 25+ chart types along with pivot, summary and tabular views . |
| Difficult to create dashboards. |
Users can easily create dashboards using the drag and drop interface. |
| Cannot create KPI Widgets. |
Allows creation of KPI widgets to track and monitor the key performance metrics. Supports 6 types of single number widgets and 2 types of chart type widgets. |
| Cannot combine and analyze data from different sources |
Can combine data from any resources for advanced reporting and analysis |
| Cannot create reports combining data from Zoho Books, Zoho Invoice, Zoho CRM etc |
Automatically links the data from Zoho CRM data with the data from Zoho Desk for advanced reporting and analysis. |
| The reports that you create cannot be shared |
You can share the reports and dashboards that you create to any user. All that the user has to do is sign in to Zoho Analytics to view the report. |
| Does not allow the users to email the reports. |
Users can not only email reports to users but also schedule emails. |
| Does not allow the users to embed the reports that they create. |
Users can embed the reports that they create in a website or blog. |
| Does not offer formula engine. |
Offers a powerful formula engine . |
| Limited customizations. |
Offers a wide range of customizations. |
This Zoho Desk Advanced Analytics is available in all the paid plans of Zoho Analytics. Users in the free plan can evaluate this functionality by subscribing to a free 15 day trial( no credit cards required).
Anyone to whom you privately share your databases, tables (data), reports and dashboards, created in Zoho Analytics, for collaboration is considered a 'User' in Zoho Analytics. A user is identified by his/her unique email address, with which their Zoho Analytics account was registered.
Suppose you subscribe to the Zoho Analytics Standard plan, you can privately share the data/reports in your account and collaborate with 4 other persons. Now your Zoho Analytics account is said to have 5 users (including yourself). Click to know more about the Zoho Analytics user model.
In Zoho Analytics, a row or record is defined in the same context as in a database (or spreadsheet). In simple terms, a table consists of rows (records) and columns (fields). Each row in a table represents a set of related data and has the same structure. For example, in a table that represents "Invoices", each row would represent a single invoice record. The number of rows calculated for pricing, is the sum of all rows/records stored across all your database tables in your Zoho Analytics account.
The Account Administrator and the Organization Administrators can set up the Advanced Analytics connector. Click here to learn about Managing Users .
The credentials of the Administrator who set up the connector, will be used for establishing any connections with source application by other administrators.
Also refer,
After configuring this connector, you might have to wait sometime for the initial fetch to happen. You will receive an email notification once the import is complete. If you access the database before the initial fetch, it will not display any data.
Data sync may sometimes fail due to a variety of reasons such as Authentication Failure, your business application is down etc. In that case, you will receive the "Data Synchronization Failure" mail with the reason for the failure and its solution. Click here to learn more about Synchronization Error Failures and its solutions.
You can choose to synchronize data at one of the intervals mentioned below.
Note:
Yes, you can edit the Zoho Desk connector synchronization setting if you are the administrator of the Zoho Analytics account.
To do so,
Yes, you can synchronize your Zoho Desk data instantly when needed.
To synchronize your data instantly:
It will be setup in the corresponding Zoho Analytics account of the Zoho Desk Administrator who has configured this Connector connector.
Data from the following modules get synced into Zoho Analytics
Also refer,
Yes, you can setup the Zoho Desk connector in any of the existing Workspaces or in any of the advanced analytics database to analyze data together. To do this,
Your Zoho Desk data will be imported into your database. Refer to this setup presentation .
Transfer connector: Write to support@zohoanalytics.com , if the organization administrator continues to be part of the organization but wishes to transfer the Zoho Desk connector to another user(Organization Administrator). .
Yes, you can setup this connector in your Zoho CRM advanced analytics database to analyze data together.
To setup the Zoho Desk connector into your Zoho CRM advanced analytics database,
Yes, you can configure multiple Zoho Desk setups if you have subscribed for a paid plan (Standard and above).
If you have purchased a Basic Plan, you will be able to import data only from one portal.
You can configure multiple Zoho Desk setups if you have subscribed for a paid plan (Standard and above). You can choose to import multiple portals in the same database or in a different database.
If you wish to import the data in an individual database refer to this question .
To import data from multiple portals into the same database,
Zoho Analytics supports a wide variety of reports.
When you setup/configure the Zoho Desk Integration Connector, 75+ default reports & dashboards are automatically created. These hand-picked reports will be pretty useful in analyzing your help data effectively.
You can quickly review the default reports from the Zoho Desk Sample Workspace
Yes, you can modify the default reports. If you are the 'Administrator' or a 'Workspace Administrator' of the Zoho Analytics account in which the Connector is configured (Refer Managing Users in Zoho Analytics ).
To modify the reports click the Edit Design button in a report's toolbar and you will be able to make the changes. If you are just a user who's been shared the report, save a copy of the report by clicking Save > Save As . Now you can edit this new copied report.
Columns from across different Zoho Desks modules are joined by default. Therefore, you can create reports by simply dragging and dropping the respective columns.
Formulas, as the name indicates, are calculations that you could define in Zoho Analytics to help you create the required reports. Zoho Analytics provides a powerful formula engine to create any type of calculations required, to enable creating the required reports. Refer Adding Formulas in Zoho Analytics to know more.
The default formulas added by Zoho Analytics are listed below. You can view these formulas by opening the corresponding table and selecting Add > Edit Formulas from the toolbar.
The below table lists all the default formulas that will be created in the Tickets table
| Formula Name |
Formula |
Formula Type |
Description |
| Ticket Age in Days |
datediff(currentdate(),"Created Time") |
Formula Column |
Number of days since the ticket was created |
| Shift (Ticket Creation) |
if (hour("Created Time") > = 12 and hour ("Created Time") < = 18, 'Afternoon Open', if ((hour("Created Time") > 18 and hour("Created Time") < = 24) OR (hour("Created Time") > = 0 and hour("Created Time") < 6),'After Hours Open', if (hour("Created Time") > = 6 and hour("Created Time") < 12, 'Morning Open','-NA-'))) |
Formula Column |
The time period (part of the day) when the ticket was created.
|
| Assign Time (hrs) |
dateandtimediff ( HOUR,"Created Time","First assigned time") |
Formula Column |
Time taken in hours to assign a ticket to an agent |
| Ticket Touches |
if ("Number of Reassign"<=0,'One Touch','Multi Touch') |
Formula Column |
Displays if the ticket was handled by a single agent or multiple agents. |
| Status Group |
if (isnull ("Ticket Closed Time"),'In Progress','Completed') |
Formula Column |
Displays the status of the ticket. |
| First Reply Time (hrs) |
"First Response Time in Business Hours"/(1000*60*60) |
Formula Column |
Displays the number of hours between the time a ticket is created, and the first reply for a ticket. |
| Completion Age Tier |
if (isnull ("Resolution time"), 'Not Resolved', if("Resolution time" < = 6,'0 - 6 Hours', if ("Resolution time" > 6 and "Resolution time" < = 12, '6 - 12 Hours', if ("Resolution time">12 and "Resolution time" < = 24,'12 - 24 Hours', if ("Resolution time" > 24 and "Resolution time" < = 48, '24 - 48 Hours', 'Above 48 Hours'))))) |
Formula Column |
Age tier of the completed ticket. Possible options are
|
| First Reply Time Age Tier |
if(isnull("First Reply Time (hrs)"),'Not Responded',if("First Reply Time (hrs)"<=2,'0 - 2 Hours',if("First Reply Time (hrs)">2 and "First Reply Time (hrs)"<=5,'2 - 5 Hours',if("First Reply Time (hrs)">5 and "First Reply Time (hrs)"<=8,'5 - 8 Hours',if("First Reply Time (hrs)">8 and "First Reply Time (hrs)"<=12,'8 - 12 Hours',if("First Reply Time (hrs)">12 and "First Reply Time (hrs)"<=24,'12 - 24 Hours','Above 24 Hours')))))) |
Formula Column |
Age tier of the First reply for the tickets. Possible options are:
|
| Ticket Age Tier |
if( "Ticket Age in Days" > = 0 and "Ticket Age in Days" < =15 , ' 0 - 15 Days', if
( "Ticket Age in Days">15 and "Ticket Age in Days" <=30 , '16 - 30 Days', if ( "Ticket Age in Days">30 and "Ticket Age in Days" <=45 , '31 - 45 Days', if ( "Ticket Age in Days" > 45 and "Ticket Age in Days" <=60 , '46 - 60 Days', if ("Ticket Age in Days" > 60, 'Over 60 Days', 'Invalid Age')))))
|
Formula Column |
Age tier of all Tickets. Possible options are
|
| Ticket handling Mode |
if (isnull("Ticket Closed Time"), if(dateandtimediff(SECOND,"Due Date", currentdate())>0, 'Overdue','Ongoing'), if(dateandtimediff (SECOND,"Due Date", "Ticket Closed Time")>0, 'Overdue','In Time')) |
Formula Column |
Displays the ticket handling mode ie. if the ticket is solved, ongoing or overdue. |
| Resolution time |
if("Status Group" = 'Completed', "Resolution Time in Business Hours"/(1000*60*60), null) |
Formula Column |
Displays the resolution time of the ticket |
| % Resolved |
((countif("Tickets"."Status Group" = 'Completed')) / (count
("Tickets"."Id")))*100 |
Aggregate |
Percentage of the tickets resolved |
| Satisfaction Rate |
(countif ("Tickets"."Happiness Rating"='Good' AND "Tickets"."Status Group"='Completed')/ countif(("Tickets"."Happiness Rating"='Bad' OR "Tickets"."Happiness Rating"='Okay' OR "Tickets"."Happiness Rating"='Good') AND "Tickets"."Status Group"='Completed'))*100 |
Aggregate |
Displays the satisfaction rating of the customer. |
| Resolved Tickets |
countif("Tickets"."Status Group"='Completed') |
Aggregate |
Provides the count of resolved tickets |
| Fast Resolution count (< 2 hrs) |
countif("Tickets"."Resolution time"<2) |
Aggregate |
Provides the count of tickets responded within 2 hours |
| Unresolved Tickets |
countif("Tickets"."Status Group"='In Progress') |
Aggregate |
Provides the count of unresolved tickets |
| Unsatisfied responses count |
countif("Tickets"."Satisfaction Score"='Bad') |
Aggregate |
Provides the count of unhappy customers |
| Solved Tickets - Overdue |
countif("Tickets"."Ticket handling Mode"='Overdue' AND "Tickets"."Status Group"='Completed') |
Aggregate |
Number of tickets solved after the set due date (overdue) |
| Solved Tickets - In Time |
countif("Tickets"."Ticket handling Mode"='In Time' AND "Tickets"."Status Group"='Completed') |
Aggregate |
Number of tickets solved in time |
| Solved and In Progress Tickets - In Time |
countif("Tickets"."Ticket handling Mode"!='Overdue') |
Aggregate |
Number of tickets in progress or solved in time |
| Overdue Tickets |
countif("Tickets"."Ticket handling Mode"='Overdue') |
Aggregate |
Provides the count of tickets over due |
| Resolved Tickets - MTD |
mtd("Tickets"."Resolved Tickets","Tickets"."Ticket Closed Time") |
Aggregate |
Provides the count of resolved tickets in Month to Date |
| Response Rate |
(countif(("Tickets"."Happiness Rating"='Bad' OR "Tickets"."Happiness Rating"='Okay' OR "Tickets"."Happiness Rating"='Good') AND "Tickets"."Status Group"='Completed') / "Tickets"."Resolved Tickets")*100 |
Aggregate |
Percentage of the users who have responded to the survey |
Refer to the Adding Formulas in Zoho Analytics help page.
No, you cannot add/modify data in the Zoho Desk data tables. Data from Zoho Desk modules gets automatically synched into Zoho Analytics in the different tables (one table for one module). You cannot edit any of this data or add new data records from within Zoho Analytics.
However you can add new tables and add/import data into that, to create reports combining it with the data from Zoho Desk.
No, you cannot add new columns. But, you can add Formula Columns and Aggregate Formulas (i.e., calculated fields) to these tables to help you create powerful reports. Refer Adding Formulas to know more on this.
Yes, you can add new data tables. Click New > New Table to add a new table in the existing Zoho Desk Workspace.
With this feature, you can import data from other sources or add them manually into your Workspace to analyze and create reports combining this with your Zoho Desk data . You can also import data from other business applications like Google Analytics, Salesforce CRM etc.
Refer:
To define a lookup relationship between two tables, it is essential that the tables have at least one column which is common between them. Follow the below steps to look up a column from Zoho Desk along with the data from any other source.
Please do note that you cannot create a Lookup column inbetween the Zoho Desk tables.
Yes, you can join data from multiple tables to create the reports. Refer to the previous question for detailed help on this.
Query Table allows you to pull data from the tables by writing standard SQL SELECT Queries. You can create reports over this Query Table as you do over a data table. Refer Here to know about how to create Query Tables in Zoho Analytics.
You can share the default reports provided in the Zoho Desk Connector connector and the reports you have create, with other users in your portal. Refer to Sharing and Collaboration help page for more details on this.
Once you privately share a report to your colleagues they will be able to access the reports as you do. Refer here to know how to access the reports.
When a Zoho Desk Administrator configures the Zoho Desk - Zoho Analytics connector, the tables and reports will be available only to him/her, by default. The Administrator has to share the database with other members of the company. Only then will the default reports be accessible by those members.
To know more, refer to Sharing and Collaboration help page.
The Zoho Desk Administrator who has setup the connector should share the tables present in ' Zoho Desk Advanced Analytics' database with other members of the company. Once this is done, the shared users can create reports based on those tables.
To know more, refer to Sharing and Collaboration help page.
Zoho Analytics offers three user roles - Administrator, Workspace Administrator and User. Click to know more about the Zoho Analytics User Model and User Roles.
This is the expected behavior. Only when the users being shared is set as a Workspace Administrators, they can edit the reports. If a normal user wants to edit the report, he/she will have to save the report with a new name using the Save As option toolbar. The User can edit this report. To know more about user roles, click here.
Yes, you can. Refer the topic Apply filter criteria .
Yes, you can export the report/dashboard in various file formats such as CSV, EXCEL, PDF, HTML and Image. Click to know more.
In order to print the report/dashboard, you first need to export it. You can export the report in various file formats such as CSV, EXCEL, PDF, HTML and Image. Click to know more.
If you are the Administrator of the Zoho Analytics connector or a 'Workspace Administrator', you can schedule reports and dashboards to be emailed automatically. Refer to the email schedule section in this help documentation.
You can easily embed the reports & dashboards created in Zoho Analytics in your website, web application or blog. Refer Embedding in Web Pages/Blogs to know more about this.
Yes, you can setup this connector in your Zoho CRM advanced analytics database to analyze data together.
To setup the Zoho Desk connector into your Zoho CRM advanced analytics database,
Yes, once you setup the integration a set of handpicked default reports and dashboards will be created using your Zoho CRM and Zoho Desk data. You can check out the sample reports and dashboards from the sample Workspace.
Zoho Desk Advanced analytics helps you analyze your customer service data, track the right metrics and managing them proactively. Read this blog post to learn how Zoho Analytics can help you measure your support team’s performance and improve the quality of your customer service.
As you know, Zoho Desk advanced analytics comes with handpicked domain specific reports and dashboards. The Agent performance dashboard that gets generated automatically once you set up the integration with Zoho Analytics and Zoho Desk consist of a list of insightful and data-driven reports that will help you analyze the performance and quality of your support team. Click here to know more.
We offer 24x5 technical support (Monday to Friday). In case if you need our assistance kindly do mail us your questions to support@zohoanalytics.com .
You can also reach out to us on our toll-free numbers :
Yes, certainly. Register for a demo in this page .