Tracking History of Zoho CRM Picklist Values

Tracking History of Zoho CRM Picklist Values

Tracking History of Picklist Values

In every business it is very important to keep track of the updates so that you don't miss out any vital information. Say for example, in sales it's crucial to track the "deal stage" or "lead status" to get an idea of the entire progress or traversal of a deal or lead. In Zoho CRM, you can track the history of such picklist values each time it gets updated. In addition to this, you can also see the changes in the related fields and its values with respect to a record's transition to different stages.

Lets take a few examples to understand this further. 

Scenario 1. The sales manager wants to pinpoint the stage in the lead conversion process that shows a major stagnation. So, he tracks the "lead status" picklist field to find out the amount of time a lead spends at a particular stage. The tracking showed that the lead was held at "not contacted" stage for 15 days before moving to "contacted". It was easier to track this update since every transition of "lead status" was recorded. 

Scenario 2. The sales manager wants to track the variation in the total amount that is quoted for every Quote stage. So, he enables tracking in "Quote stages" and chooses "Amount" as the related field of a record. 

Scenario 3. The sales manager wants to get the list of deals which have moved to closed lost stage from negotiation stage. He can create a report with stage history module by choosing Stage Field as Negotiation and Moved To field as Closed lost.
If the customer wants to get the list of deals which has moved to In Progress stage from Requirements gathering stage with duration greater than 4 days.

Availability
Permission Required
Users with Module Customization permission can enable picklist history tracking.

Enable picklist history tracking

You can enable tracking for one picklist field per module. The history tracking for the mentioned field will be enabled across all the layouts. In the Picklist History related list, we will display 5 default fields namely picklist values, duration, modified time, modified by, and moved to. Aside from this, you can include 10 additional fields.

To enable history tracking
  1. Log in to your Zoho CRM account.
  2. Go to Setup > Customization > Modules and Fields.
    Module refers to the Leads, Accounts, Contacts, etc. tabs.
  3. Click the desired module and select a Layout.
  4. In the Layout editor, go to the required picklist field, click the Settings icon and select Edit Properties.
  5. In the Pick List Properties page, select the Enable history tracking for picklist values checkbox.
  6. In the Picklist History Tracking page, select other Fields you want to view.
    Note that the fields which are marked as Encrypted will not be listed here.
  7. Click Done.

 View history tracking

You can view the tracking history of a record as well as the other selected fields right under the record's related list.



You can also select the fields to be shown in the picklist history related list and unselect the unwanted fields.

Edit History Tracking in Deals Module

The Deals module displays a default stage history in the record's related list. You can add more columns to the existing stage history by clicking on the Edit History Tracking option from the layout. You can select the "Stage" field and click on the More icon to find this option. 


By editing the history tracking, you will be able to change the related list name and add up to six more columns to it. 


Points to Remember

  • Zoho CRM provides smart filter options with which you can filter the records based on the duration.
  • The tracked data will be available in the Data Backup section, so you can access it anytime.
  • History tracking for picklist values option is not supported in the Tasks, Calls and Meetings (Activities) modules.
  • If the tracking option for a picklist field is disabled or if the picklist field with the tracking option enabled is deleted, then all the tracked data will be lost permanently.
  • Tracking will not be enabled for the picklist field created in other modules from Leads, Quotes, and Sales Order using "Also create for" option.
  • While selecting fields in the related list column, you will not be able to select any field that is encrypted. See also Encrypting a field.
Remember:  At most, only one picklist field can be tracked within a module.
    • Related Articles

    • Get Ready to Sell on the Go with Zoho Mobile

      A mobile CRM is not a downsized version of the desktop CRM. It’s a more specialized and dedicated platform aimed at higher productivity. In the mobile version, you concentrate on what matters most. In this ebook, find out about the useful features ...
    • Segmentation in Zoho CRM

      Customer segmentation is the process of categorizing customers based on common characteristics such as their region, industry, product preference, or revenue generated. It is a powerful technique that helps companies better address their customers' ...
    • Working with Zoho CRM Sales Forecast Module

      What is a sales forecast? A sales forecast is similar to a weather forecast, where you predict the weather based on various factors like humidity, precipitation, air speed, wind speed, and so on. This prediction drives decisions like what you wear, ...
    • Zoho CRM Data Migration Wizard Overview

      What is the Data Migration Wizard in Zoho CRM? The data migration wizard in Zoho CRM ensures that your data is migrated correctly and helps you reduce much of the manual work. It automatically maps import files to CRM modules and matches data columns ...
    • Zoho CRM CPQ Overview

      CPQ explained with a Scenario - CPQ is an effective tool to achieve line item automation in Zoho CRM. Consider the case of Zylker Apparel, which uses the CRM to maintain a database of their customers. They are often faced with situations such as ...