Forecast performance analysis

Forecast performance analysis

Last modified on 15/05/2023: Performance analysis in forecasts is now available for all Zoho CRM users in all DCs. Note that it was an early access feature available only upon request. As of May 10, 2023, it is rolled out for all Zoho CRM accounts. Find out more about forecasts in our help doc.

Hello everyone! 

We are thrilled to announce an exciting update on comprehensive performance analysis for CRM forecasts, including trends, gap reasons, improvement suggestions, and more.

Forecasts help organizations estimate how sales will progress in the approaching months, quarters, or fiscal years, as well as monitor current sales growth and find ways to accelerate it. They yield important insights into the company's performance and enable businesses to plan upcoming activities accordingly.

In the revamped forecast, until now, we provided the Target Achievement Report page, which showed the targets set for different roles within the organization, their achievements, and the number of open deals they had in a hierarchy. We're introducing a few enhancements to forecasts to provide even more details about performance, as well as an overview—which can be found in the User and Roles Performance pages and Forecast Overview section of the Target Achievement Report page.

We've introduced the following:
  • Performance Trend
  • Achievement Comparison
  • Comparison Across Forecast
  • Current Deals by Stages
  • Reasons for Gaps
  • Improvements


Let's have a look at these charts and at the overall enhancement in detail.

Forecast Overview

We've introduced a section at the top of the Target Achievement Report page called Forecast Overview. The analytics in this section help users track their performance and plan according to their targets and requirements.

  • Performance Trend: Users can analyze their performance with the help of the performance trend chart, which compares actual achievements across time with target achievements. The trend line predicts whether the achievement can be met within the forecast period based on the current performance, and shows the predicted achievement on particular dates. Users, therefore, have a visually clear representation of what's necessary to improve performance to reach targets.

  • Achievement Comparison: Users can compare their performance at different intervals to analyze how their performance has changed over time. They can set the chart to compare performance on a daily, weekly, or monthly basis.

  • Comparison Across Forecasts: This chart helps users compare their targets, open deals, and achievements across different forecast periods. The bars signify the total deal value assigned to a particular user and contrast it with the deal value closed at the end of the period. Combined with the line plot representing targets in the selected time frame, this enables users to determine whether the target is achievable, and how much more effort is required.

User Performance page
We've introduced the User Performance page for users and admins to track individual performance in a particular period. Apart from providing insights into users' performance, on this page, there are additional details including charts and other widgets. Users can see suggestions for improving their performance or the reasons for which they're not able to meet their targets, and can therefore act accordingly.


The following details are available on the User Performance page:
  • Open deals
  • Deals in the best case, pipelines, and omitted deals.
  • Predictions
  • Targets
  • Achievements
The User Performance page also has charted—Performance Trends and Achievement Comparison—with similar functionality as those in the Forecast Overview section.


The Achievement Comparison chart compares total achievement over time with the number of available deals that can be completed, with a plot for overall targets provided for context.


Apart from these two charts, the User Performance page features the additional Current Deals by Stages chart. The main purpose of this chart is to show deal amounts in different stages. All deals in the current period are plotted as bar graphs according to the deal stage. Each bar breaks down the sum of the deal amounts into three forecast categories: pipeline, best case, and committed. If a pipeline is added, you can also view the current deals by stage based on that pipeline.


We didn't stop just at providing insight into user performance; we've also introduced two additional sections: reasons for gap, which highlights the gap between the target and the achievement and provides reasons that could have led to the gap, and the improvements section, which lists out the various improvements the user can make in order to reduce the gap.

Here are some examples:

Reasons for gaps
  • High number of untouched deals: Any untouched deals will be mentioned here, along with the actual count of untouched deals. Clicking the deal count makes a list of those specific deals pop up.
  • Failed to approach at the right time: Deals that were not approached at the right time are referenced here. Clicking on the link reveals a list of deals that weren't approached at the right time.
  • Doesn't fall in this forecast period: Deals that are outside of the forecast period are referenced for this reason.
  • Deal value insufficient to close target: Deals in the pipeline whose values are too low to reach the target are referenced here.

Improvements
  • Focus on recommended deals: Deals that are likely to be won are referenced here, along with the total deal value upon closing. The deal count is hyperlinked to summon the deal list.
  • Focus on high-value deals: This improvement recommendation suggests which deals to focus on, including high-value deals or low-value deals, based on the win rate for each type of deal. It also mentions the number of such deals available in the pipeline and lists them via a link.
  • Improve closing rate: This improvement is suggested if the user needs to improve their closing rate, along with the percentage by which it needs to increase.
  • Kick out the stalled deals: If a high number of deals in the pipeline have a low chance of being won, they will be mentioned here. Users can click on the deal count to see a list of such deals.

Role Performance page
Users can access the role performance report via the Roles Performance page by clicking on a particular role in the hierarchical view of the Target Achievement Report page.

The Roles Performance page also features sections that show reasons for achievement gaps and improvements (different than those suggested in the User Performance page). Admins can thereby analyze the performance of particular roles and their direct subordinates.

Here are examples of reasons for achievement gaps and improvement suggestions:

Reasons for achievement gaps
  • Users recently switched roles: Users who have switched roles are cited here as a potential reason for a performance gap, along with the count of such users and the percentage of the target deal value that they owned. Clicking on the count of users summons a list of users who have switched roles.
  • Mismatch found in the split and target: In case there is a delay in the allocation of values in the target, it will be mentioned as the percentage of the value in the target that is mismatched.
  • Low user performance: The number of users who closed less than 20% of their targets is cited here. The list of users is linked with the provided count.
  • Overrated targets: If users' targets are overrated, this reason will appear, along with the percentage of how overly rated the targets are.

Improvements
  • Identify users who have a low follow-up rate: Users who have contributed to a decline in customer happiness are referenced here, along with a list linked to the user count.
  • Right deals to the right person: If a certain user has a high win rate of 76% on high-value deals and 60% on low-value deals, the system will suggest assigning high-value deals to that user to get better results.
  • Reassignment yields better results: If two users have some stagnant and untouched deals, the system will suggest that those deals be reassigned to help closure.
  • Target correction: If five users have overrated targets and three users have low-rated targets compared to the individual's average performance, the system will suggest reassigning targets based on performance.

Notes:
  • The charts on the User and Role Performance pages are available only for completed and current forecasts only.
  • The Current Deals by Stages chart is available only for the Current forecast.
  • The Achievement Comparison chart is only available if there is data from previous forecast periods.
  • Improvements and reasons for performance gaps are updated once per week


    • Recent Topics

    • What's wrong with this deluge code to create a Bill?

      I know that all the data in the map is correct. The line items are pulled directly from a purchase order. // Add the purchase order ID to the bill billPOIds.add(poID); // Retrieve and merge the line items poLineItems = purchaseOrder.get("line_items");

    • 2 Ideas, Clone timesheet entry from monthly view and Notes in Weekly view

      While i love timekeeping I am finding some things slow me down.  Slow to the point of considering writing my own API call to do this. It would be so useful to be able to clone a timesheet entry from the monthly view.  It is somewhat painful to have to

    • Zoho Workdrive API call to find public external Link for a Folder

      Hi all, I can create new external share links for a WD Folder using this API call https://workdrive.zoho.com.au/api/v1/links . This works fine, however if there is already an external link created for a given folder, trying to create a new one fails (which

    • Converting Sales Order to Purchase Order

      Hi All, Firstly, this code works to convert a sales order(SO) to a purchase order (PO) via a button, however I am running into an issue when I convert the SO where the values from the line items are not pulled across from the SO to the PO. The ones in

    • Accessing and Using Formula Field

      Hi There, I created a formula field called 'Day of the Week' in the Leads module that takes the record created time and transforms it into the day of the week. The formula field returns the correct values. However, I am unable to find or use the field

    • 🇺🇸 🇨🇦 🇲🇽 Ask the Experts: A Live Q&A Session

      Session Closed Thank you to everyone who participated in this Ask the Experts session! Your questions, insights, and engagement made it a valuable discussion for the entire Zoho Recruit community. The comment section is now closed, but feel free to browse

    • Request For Quotation (RFQ) module

      Hello, Do you have any plans to implement a RFQ module in to ZOHO Inventory? I would like to chose items that I require a price for, select a number of different suppliers to e-mail and have them submit there pricing online. I would then like to see a

    • Ability to Append or Prepend specific signer name field to all documents in an envelope

      We use templates regularly and have a need to be able to rename the individual pdf documents contained in an envelope, such that a signer's name is appended or prepended (e.g. Form1 - SignerName). This is critical for us, because of how we process documents

    • Export an email as an HTML file?

      How do we export an email in Zoho Marketing Automation as an HTML file? We have an advertising partner that needs our campaign email as an HTML file. We can't find any way to do this. If this is not possible, please explain why. It doesn't make sense

    • Function #30: Display list of associated PO on SO details screen

      Hello everyone, welcome back to our series! Imagine having the ability to effortlessly access and view details of all purchase orders linked to a sales order directly from the sales order itself. Well, today's script is designed to do just that for you.

    • Custom Print Button in Page/Stateless Form

      [Zoho Creator] Unable to Add Custom Print Button to Page or Stateless Form We need the ability to add a custom print button on a page or stateless form in Zoho Creator to print a templated or formatted output (e.g., appointment confirmation, summary slip).

    • Page Variable Not Passed from Report to Form

      [Zoho Creator] Page Variable (Resource) Not Passed from Report to Form in Appointment Module We are facing a limitation in our Appointment Module related to the handling of page-level variables. We are using a page variable to select a resource, which

    • Creating Layout Rule With Formula Field

      By The Grace Of G-D. Hi, I see that i cannot use Layout Rules to show/hide Formula Fields. Is that something you plan on adding sometime soon?

    • Combine / merge multiple invoices into master

      Good morning Zoho! Upon looking for a solution for my issue, I found many that had my similar problem...dating 13 years ago! Please, any updates on this? Merging multiple invoices on a Master Invoice would alleviate all the extra work of resending and

    • Free Webinar Alert! Productivity Hacks that you don't want to miss on June 24

      Hello Zoho Community! Want to work smarter and get more done with Zoho Mail? We’re here to help! Join our interactive webinar to explore powerful Zoho Mail features that can boost your productivity. Watch live demos, learn helpful tips, and take part

    • Web Clipper cannot save to collections

      With the recent update that added collections, i am unable to use the web clipper to save to a collection

    • sort by name is always z to a

      I typically keep my notes in alphabetical order. Suddenly they are all backwards - z to a. They stay that way whether I select a to z or z to a. Is there a way to fix this?

    • Project Management Bulletin: June, 2025

      Our project management suite's representatives have been busy socializing with global customers in the USA (Zoholics) and Australia (roadshows). We also had multiple stop overs at our customer’s establishments and were glad to see the efficiency our products

    • Agenda For Zoholics Benelux & Nordics 2025

      Dear Zoho Benelux community, We are pleased to announce the agenda for Zoholics Benelux & Nordics 2025 on September 23-24 at NBC Congrescentrum in Nieuwegein. The topics of the presentations are: Zoho innovations in the region and worldwide The introduction

    • How to query Deal "Stage" "Is Open" in Analytics SQL?

      How do I query this "field" in Analytics? What is going on? It seems like there is another 'mapping' somewhere but that it is inaccessible with raw sql??? If I query "Stage" Like '%Won%' I get a wildly different number than I do when I manually filter

    • Enhanced Candidate Portal: Now Featuring Federated Login, Passwordless Access & MFA

      You can now enhance your Candidate Portal experience with Federated Login, Password less Sign-in and Multi-Factor Authentication (MFA). These features offer greater flexibility and control—allowing seamless sign-ins through trusted platforms and adding

    • Custom View and Custom Fields

      Hi We have custom fields that we need in the Sales\Customer module and we would like to have the fields available to view in the Bills module so that we can add them to a custom view, is that possible? That way we can look at the Bills screen to see what

    • Can I write a check in Zoho Books with no associated bill?

      This currently does not seem possible, and I have a client that desperately needs this function if I am able to convert them with Quickbooks. Thank you in advance for your reply. 

    • Automation#35 : Auto-Add Comments under the Owner's Name in Tickets via Macros

      Hello Everyone, This week's custom function provides simple steps to configure a Macro for adding comments to tickets with the name of the Comment owner. When managing tickets, you can use the Comment feature to communicate internally with your team and

    • Subfrom Changes are NOT included in Audit Logs and Timeline

      In the Timeline the subform changes are not tracked We have an important custom module for Recording Pricing Information It has a subfrom, now if Changes are made to the subform fields they are not shown in the timeline, ONLY the aggregated fields This

    • Tracking Emails sent through Outlook

      All of our sales team have their Outlook 365 accounts setup with IMAP integration. We're trying to track their email activity that occurs outside the CRM. I can see the email exchanges between the sales people and the clients in the contact module. But

    • Changing Link Color

      When I create a link from a block of text, the text color changes to a color i do not want. After scrolling through the CSS and HTML files I cannot find the setting for the link color. Changing the link color word by word seems inefficient and must be a setting somewhere? Greg Aanes 2109 Queen Street Bellingha WA USA

    • Content Management System

      Is there any plan to develop a CMS application that allows us to manage all of the ZOHO services such as Writer, Sheet, and Planner? Besides that, it would be nice to manage the files and logs of WebNMS using SOA. Otherwise i'll try to make it. Thanks, Takash F

    • How do I pause or halt a running campaign?

      Hi, I set up an A/B campaign - and after testing, scheduled the campaign, I noticed an error in the subject line and had to pause or halt the campaign 'mid-flight' - could not find this, and the only option was to delete the entire campaign to halt the send (it was an emergency). Is there a campaign Pause or Stop function/button? I could not find it - am I missing something? (Thank you for your help  - I searched the resources and could not find an answer)

    • Contact Segments with multiple CRM modules

      Hello, We have a somewhat unique setup in our system involving various components: Contacts, Accounts, Deals, and a couple of custom modules named Properties and Audit Logs. We're looking to implement a notification system via SMS and Email specifically

    • Cannot reorder fields in Page Layout in Expenses and Purchase Requests

      It is very inconvenient that the custom fields in Page Layout cannot be re-ordered. The only way is to remove the fields and re-create them; however, it is impractical. This would affect the reports and dashboards we are having. Not able to re-order the

    • Having issues with creator, flow and calendar

      So I have made a creator app when engineer puts in the date and time for when they are going to out on site , this then passes the calendar data to flow and then should populate the inputed data to the calendar. So If use${system.zf_current_date_time}.

    • Problem when forwarding emails

      When I want to forward an email received through Zoho, the layout changes: Buttons are cut Pictures change size Text changes alignment (left/right/center) Is this a common problem in Zoho? Thank you, Suzannah 

    • View Audit Trail field

      The Audit Trail feature is great, but its data is only available to admin users. It would be really great to have a system field "Audit trail" that we can add to the detailed view of a record. This would allow supervisors, directors and etc. to quickly track what changes have been done by whom for each record. It is a current feature from a client of mine and while it's probably possible to hard code it, since this data is already available in Zoho, I would be surprised to hear how hard it would

    • Recuring bills payments

      I've entered recuring bills that are auto drafted from my account monthly. Can I set up the recuring payment or do I continue to manually do it monthly?

    • Automatically assign Contact Roles to a Deal

      Hi guys, Is there a way to assign multiple Contact Roles to a Deal via a workflow or similar? Thanks

    • on submit of creator form then record is create in Zoho crm purchase module then on automatically task want to create in the crm

      on submit of creator form then record is create in Zoho crm purchase module then on automatically task want to create in the crm

    • Zoho CRM Webinar – Automate everything across Customer Journeys in CommandCenter 2.0

      How efficient is your current CRM automation setup? As customer journeys become more dynamic, it's common for data and actions to get scattered across teams and modules. This leads to broken processes and inconsistent customer experiences—especially across

    • Changing employees email address

      How do I change an employee's email address? I am an administrator on the account but it says that I am "not allowed" to do it?

    • MULTI-SELECT LOOKUP - MAIL TEMPLATE

      Dear all how are you? We need to insert data from MULTI-SELECT LOOKUP in a email template, but I can't do that, when I'm creating the template I can't find the field to insert it. is there any solution? PVU

    • Next Page