Advanced Analytics for Zoho CRM

On 6th June 2012 Zoho announced some long awaited integration between ZohoCRM and Zoho Reports. Advanced Analytics for Zoho CRM brings the power of Zoho reports to your CRM data and provides a wealth of reports and dashboards 'out of the box'. Check the video for an overview.

Data is synced every 24hrs (admins can trigger a sync manually) and ensures that key modules are available for reporting. At launch this includes Leads, Contacts, Accounts, Potentials & Users. No word yet on other modules such as invoices, products, vendors or cases etc The addition of these modules would provide a really complete picture.

The synchronisation is a snip to set up and was completed very quickly. Your mileage may vary if you have tens of thousands of records.

Zoho have done a lot of the hard work for us in creating some pre-built reports and analysis from the CRM data. These reports align nicely under various headings:

In total Zoho have supplied 70+ reports on your CRM data, all of which can be tailored to your needs. Here are a few examples to try:

- Top 5 lead campaigns by revenue
- Leads to potentials drop out analysis
- Average sales cycle in days (by Quarter)
- Existing v's new business
- Quarter over quarter revenue across years
- Monthly sales report
- Pipeline by count/stage
- Salesperson performance last quarter
- Sales pipeline history (Dashboard)

All example reports and charts are interactive and allow examination of underlying data by clicking through on chart and data areas. ;-)



Now for the clever part. As all these data tables, reports and dashboards are just a Zoho Reports instance you could also upload other valuable business data using any of the import methods. (CSV / FEED / Reports Upload Tool / Zoho Creator Sync) Perhaps you store warranty information for equipment you have sold or licences for software you've developed? Simply import it into a new table in the same database. This data can now be 'related' to your CRM data very easily by linking the Customer fields in the new warranty/licence tables to the accounts name field in the CRM Accounts table.

Viola! You can now create reports based on business data that is logically external and separate from your core CRM data to show for instance..

1. Warranty expirations/renewals per account per month or quarter
2. Software licence versions/upgrades per customer
3. Maintenance visits and associated costs by customer, region or any time period

I hope this has been informative, if you have any questions please comment or contact me directly via the website

Congratulations!

I tip my hat to you...

If you or your business are already a Zoho CRM customer you have already made a great decision. Zoho CRM offers great features at even better value. I know; I would struggle to manage my business without it.

The longer you use Zoho CRM, the more you come to appreciate its usefulness and the nice touches that make it so powerful.

But wait, there's more...

CRM however, is just 1 out of 28 different business applications by Zoho. The list is long and pretty distinguished including Human Resources Management, Project Management, Office Productivity and very recently they even added a website creation tool kit.

Combine tools for more...well, everything!

Amongst the other 28 are a few that integrate nicely with Zoho CRM and really add value. Imagine being able to use CRM data as a part of daily operations tasks. 

For instance, your company, Widgets-R-Us produces and sells expensive widgets. The widgets, are all sold with a 12 month warranty and the option to extend this to 5 years of warranty cover.

How would you like to track and comprehensively report on the warranty claims brought by customers? To be able to track failing widgets and report on who bought them, how far into the warranty the average failure occurs, identify clusters of failures by batch numbers or other metric. - All of this, linked, in context to the client and account information as shown in CRM.

This falls outside of the capabilities of Zoho CRM in its vanilla, un-customised form and would stretch the capabilities of the platform to achieve it solely within Zoho CRM.

Meet my little friends, Zoho Creator and Zoho Reports...

Zoho Creator: A bit like Microsoft Access, coupled with VBScript, but all on      the web, with built in security and sharing. Create forms, collect data and save/display in simple easy ways accessible anywhere - even on your phone

Zoho Reports: A powerful reporting tool that takes data in many formats and from many sources and provides query, report and charting options. Create beautiful and powerful reports with drill down options that can be embedded, published and shared to your hears content.


These two in conjunction with Zoho CRM combine to create powerful business data and process workflow tool kit that can help your business in ways that Zoho CRM alone cannot.


The last piece of good news is that the Zoho Creator App and the Reorts generated by Zoho Reports can all be 'published' to new tabs within your CRM system for ease of access/ These new tabs can be secured, shared and managed just like any other.

ZohoCRM Road-Map - What's coming?

Zoho rarely divulge much detail around the upcoming features in their products. This can cause issues as existing customers are always hungry for more features, and have their own views about the relative importance of these.


Potential customers often wait in the wings, getting by until a certain feature set is announced, unable to make the transition to the cloud until this particular box is ticked. Transparency would be wonderful, but I can also see Zoho's problem with publishing a roadmap in detail.

So whats currently in store for CRM users in the coming weeks and months? Well Zoho updated the roadmap (here) in early January, and we're still awaiting for these updates.
Upcoming release:

• Enhancements in Pulse
• Multi-currency support
• Custom links as a related list view
• Workflow Summary view
• Zoho CRM Plug-in for Microsoft Outlook - Support for the Potential module | Support for Microsoft Outlook 2010, Support for 32/64-bit processors

The next release however is looking very interesting...
In development:

• Integration with Zoho Docs
• Integration with Zoho Reports
• Integration with Zoho Creator

I wonder, will Zoho Docs integration allow updates to a shared doc within CRM with synchronisation of edits to a master doc? 


Will Zoho Reports integration support writing queries against all the regular modules/files? Maybe it will support the same brilliant drag and drop report/dashboard builder as the full product? 

Will Zoho Creator integration allow programmatic control over CRM module pages. Hiding and showing fields based on user action or will this be implemented as an in-situ Creator App editor that allows admin users to create apps with CRM that use CRM data in great new ways? For example a product warranty tracker linked to a purchase date or Opportunity close date?


I have my views on this, but know nothing for sure. We'll have to wait and see what gets revealed in the coming weeks/months. I do forecast though that these upcoming developments are the ones that will either lift Zoho CRM to another level or leave it languishing as a merely excellent tool. ;-)