Integration‎ > ‎

Zoho Reports

,TeamSupport offers powerful reporting and charting capabilities through an integration with Zoho Reports.  Through this integration you can create custom reports, charts, and dashboards on a variety of TeamSupport data and you can also create custom dashboard which you can share throughout your organization.

Once the integration is set up, TeamSupport will automatically update Zoho Reports in near real time so the data will be fresh and not time delayed.

Here is a video about Zoho Reports:



Zoho Reports is an add-on to your TeamSupport account and plans can be purchased directly from Zoho.  Smaller TeamSupport accounts will be able to use the free account, but that is limited to 10,000 total records, and since we send over more data than just the tickets that threshold can be reached fairly quickly.

TeamSupport sends over the following data to Zoho:

  • Ticket Table - This is one of the main tables in TeamSupport and contains all of the ticket information.  Most reporting will be done on this table.
  • Ticket Status History - Every time the status of a ticket changes, we log a record into this table.  This allows you to keep track of how long tickets are kept in certain statuses.
  • Portal Login History - This table tracks every time a user logs into your customer portal
  • Knowledge Base Traffic - Tracks each time a customer views a knowledge base article (through either the basic or advanced portal) and what keyword they used to find the article.
  • Chat Requests - Shows each time a user has requested a chat, and if the chat was answered or not
Setting up the integration is straight forward - First, you will need to get an API key from Zoho.

1) Create a Zoho Reports account at http://Reports.zoho.com

2) Log into your Zoho Reports account and you should see a screen like the one below.



Click on the "Create Blank Database" link and name the database "TeamSupport" (note - it is important that the name is exactly "TeamSupport" otherwise the integration will not work).  The screen should look like this:



Once you have named the database TeamSupport, click on the "Create" button and the blank database will be created.

3) Get your Zoho Reports API key.

Once you've logged into Zoho Reports, open up a new browser tab and go to this address:

https://accounts.zoho.com/apiauthtoken/create?SCOPE=ZohoReports/reportsapi

You should see a screen similar to the below:



4) Copy the "AUTHTOKEN" field and log into TeamSupport (with an Admin rights user account).

Go to the Admin tab and select the Integration tab at the top.  Expand the "Zoho Reports" section and you should see the fields that need to be filled out as in the screenshot below:



Fill our your Zoho Username (this is NOT your e-mail address - It's your unique Zoho username), Zoho password, and the Zoho API Key (which you copied from the steps above).  Make sure to check the "Active" box.

Within about 15 minutes the initial data should be loaded into your Zoho account and you will be ready to create graphs and reports in Zoho Reports.

If any of the tables created by this integration gets renamed the integration will create, and continue updating, a new table with the original name and the renamed table will not get any further updates.


Fields we are mapping to Zoho:

Tickets:
TicketNumber
TicketURL
Name
TicketTypeName
TicketSource
Status
Severity
AssignedTo
Customers
Contacts
ProductName
ReportedVersion
SolvedVersion
GroupName
DateModified
DateCreated
DaysOpened
IsClosed
CloserName
SlaViolationTime
StatusPosition
SeverityPosition
IsVisibleOnPortal
IsKnowledgeBase
DateClosed
DaysClosed
CreatorName
ModifierName
HoursSpent
Tags
SlaWarningTime
SlaViolationHours
SlaWarningHours
MinsSinceCreated
DaysSinceCreated
MinutesToFirstResponse

Still need help?

For more information on how to use Zoho Reports, click on the "Help" pulldown within the Zoho Reporting application.




Comments