Picklist History Tracking | Online Help - Zoho CRM

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.
NotesNote: You can select up to five user lookup fields for history tracking.

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.

Info

Downgrade flow for picklist tracking

The behavior of the picklist history tracking feature during a downgrade depends on the type of downgrade. Below are the detailed scenarios:
  1. Customer-initiated downgrade:
    1. If the downgrade is initiated by the customer (and not due to license expiry or end of the grace period), the history tracker data will be deleted permanently and immediately upon downgrade.
  2. Downgrade due to license expiry:
    1. In cases where the downgrade occurs because of license expiry, a 60-day grace period will be applied.
    2. During the grace period, all data, including the history tracker, remains intact.
    3. After the 60-day grace period ends, a scheduler will be initiated to delete all higher-edition features, including the history tracker data.
Note: Please ensure to back up your history tracker data before initiating a downgrade to avoid any permanent data loss.

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.

    Access your files securely from anywhere

      Zoho CRM Training Programs

      Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

      Zoho CRM Training
        Redefine the way you work
        with Zoho Workplace

          Zoho DataPrep Personalized Demo

          If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

          Zoho CRM Training

            Create, share, and deliver

            beautiful slides from anywhere.

            Get Started Now


              Zoho Sign now offers specialized one-on-one training for both administrators and developers.

              BOOK A SESSION





                          Quick Links Workflow Automation Data Collection
                          Web Forms Enterprise Begin Data Collection
                          Interactive Forms Workplace Data Collection App
                          CRM Forms Customer Service Accessible Forms
                          Digital Forms Marketing Forms for Small Business
                          HTML Forms Education Forms for Enterprise
                          Contact Forms E-commerce Forms for any business
                          Lead Generation Forms Healthcare Forms for Startups
                          Wordpress Forms Customer onboarding Order Forms for Small Business
                          No Code Forms Construction RSVP tool for holidays
                          Free Forms Travel
                          Prefill Forms Non-Profit

                          Intake Forms Legal
                          Mobile App
                          Form Designer HR
                          Mobile Forms
                          Card Forms Food Offline Forms
                          Assign Forms Photography
                          Mobile Forms Features
                          Translate Forms Real Estate Kiosk in Mobile Forms
                          Electronic Forms

                          Notification Emails for Forms Alternatives Security & Compliance
                          Holiday Forms Google Forms alternative  GDPR
                          Form to PDF Jotform alternative HIPAA Forms
                          Email Forms
                          Encrypted Forms
                          Embeddable Forms
                          Secure Forms
                          Drag and Drop form builder
                          WCAG


                                            You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                                Manage your brands on social media

                                                  Zoho Desk Resources

                                                  • Desk Community Learning Series


                                                  • Digest


                                                  • Functions


                                                  • Meetups


                                                  • Kbase


                                                  • Resources


                                                  • Glossary


                                                  • Desk Marketplace


                                                  • MVP Corner


                                                  • Word of the Day


                                                    Zoho Marketing Automation

                                                      Zoho Sheet Resources

                                                       

                                                          Zoho Forms Resources


                                                            Secure your business
                                                            communication with Zoho Mail


                                                            Mail on the move with
                                                            Zoho Mail mobile application

                                                              Stay on top of your schedule
                                                              at all times


                                                              Carry your calendar with you
                                                              Anytime, anywhere




                                                                    Zoho Sign Resources

                                                                      Sign, Paperless!

                                                                      Sign and send business documents on the go!

                                                                      Get Started Now




                                                                              Zoho TeamInbox Resources



                                                                                      Zoho DataPrep Resources



                                                                                        Zoho DataPrep Demo

                                                                                        Get a personalized demo or POC

                                                                                        REGISTER NOW


                                                                                          Design. Discuss. Deliver.

                                                                                          Create visually engaging stories with Zoho Show.

                                                                                          Get Started Now









                                                                                                              • Related Articles

                                                                                                              • Working with Custom Fields

                                                                                                                In Zoho CRM, you can add new fields as per your requirements. These fields will be available to all the users added to your organization's CRM account. Customize Zoho Defined Fields: You can edit, delete and hide some of Zoho defined fields, but note ...
                                                                                                              • Color Coding of Picklist Values

                                                                                                                Picklists are convenient and functional, as they convey the current state of the record.For example, the lead status or the current stage of the deal, etc., can be easily distinguished and monitored. Furthermore, to provide aesthetic distinction and ...
                                                                                                              • Types of Custom Fields

                                                                                                                In Zoho CRM, you can add different types of custom fields as per your requirements. These fields will be available to all the users added to your organization's CRM account. Customize Zoho Defined Fields : You can edit, delete and hide some of Zoho ...
                                                                                                              • Troubleshooting Module Customization

                                                                                                                Troubleshooting Modules and Fields 1. Why does the editor go from top to bottom instead of left to right when I click the Tab key while creating or editing a record? The order depends on the Tab Order Preference set by the Admin for each particular ...
                                                                                                              • Viewing Import History

                                                                                                                Maintaining a log of the activities performed in your Zoho CRM account is always useful. You know when a record was edited, or who added a record. Similarly, a log of the import activities is also useful in knowing who imported records, when it was ...
                                                                                                                Wherever you are is as good as
                                                                                                                your workplace

                                                                                                                  Resources

                                                                                                                  Videos

                                                                                                                  Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                                  eBooks

                                                                                                                  Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                                  Webinars

                                                                                                                  Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                                  CRM Tips

                                                                                                                  Make the most of Zoho CRM with these useful tips.



                                                                                                                    Zoho Show Resources