Article Read Time:

2 Min

Search

Subcribe :

Train Your Team:

Our Extensions:

Join For FREE:

The CRM Zen Show Episode 262 – Come on, Cliq The Noise

Zoho News

Implementation of the Week

  • Consolidated Last-Ticket-Touch Analytics for Zoho Desk
    • In this implementation, our goal was to provide reporting capabilities in Zoho Analytics on Desk Tickets that hadn’t had meaningful updates recently
    • The challenge is that a “meaningful update” may come in the form of a Ticket Thread/Email, Comment or Task completion
    • To solve for this, we first created a SQL table using UNION operators to create a master data-set of all of the different types of touches we were looking to track
    • Then, from this table we created logic to determine the most recent touch on each of those tickets, as well as what type of touch it was
    • Lastly, we’re able to create custom reports from that data to identify outlier tickets that may need to be addressed by managers

Code Share of the Week

  • Add Ordinal Suffix to a Number
    • Formatting date-times into readable strings in deluge is best done using the .toString() function. By inputting a string of Date-Time Literals you can format a date-time into almost anything you can think of.  However ,the .toString() function sadly does not offer ordinal numbers, so we have to use a short series of if/else statements to determine any number’s ordinal indicator.

This Week’s Read

New On Zenatta

Tips and Tricks