We use cookies, including third-party cookies from Google to serve personalized ads through AdSense, to operate this site and understand how it is used. By continuing to browse, you accept this use. See our Privacy Policy and Terms of Use for details, including how to opt out of personalized advertising.
Accept
SmartData CollectiveSmartData Collective
  • Analytics
    AnalyticsShow More
    Flat editorial illustration: The article is about joining public web signals with internal business metrics so BI teams can inter
    Alternative Data in BI: Bringing Public Web Data Into Your Dashboards
    23 Min Read
    Flat editorial illustration: The article is about automating the collection, preparation, and delivery of marketing data across p
    From Data to Dashboards: 5 Marketing Reporting Automation Software Picks
    12 Min Read
    Flat editorial illustration: The article contrasts passive follower totals with a behavioral path from attention and trust to cli
    Creator Analytics Beyond Follower Count: Seven Metrics That Measure Audience Behavior
    11 Min Read
    Flat editorial illustration: The article connects AI and marketing analytics with managerial judgment grounded in consumer behavi
    How an Online MBA in Marketing Connects AI and Data Analytics
    11 Min Read
    What Kind of Problem-Solving Distinguishes Data Analysts From Software Engineers -- AI-generated illustration
    What Kind of Problem-Solving Distinguishes Data Analysts From Software Engineers
    7 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-25 SmartData Collective. All Rights Reserved.
Reading: Successful Sales Forecasting Requires Dedicated Technology
Share
Notification
Font ResizerAa
SmartData CollectiveSmartData Collective
Font ResizerAa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Analytics > Predictive Analytics > Successful Sales Forecasting Requires Dedicated Technology
Predictive Analytics

Successful Sales Forecasting Requires Dedicated Technology

Mark Smith
Mark Smith
9 Min Read
Successful Sales Forecasting Requires Dedicated Technology
Illustration generated with FLUX.2 [klein 4B] via Cloudflare Workers AI.
SHARE

Sales forecasting is an essential process for most businesses.

Sales forecasting is an essential process for most businesses. It helps guide the efforts not only of the sales function but also of finance, operations, manufacturing and customer service. Our recently released sales forecasting benchmark research reveals significant insights and best practices that can help companies optimize the effectiveness of this process. I recently wrote that most sales organizations need to make significant changes to the way they do sales forecasting. In that analyst perspective, I examined aspects of technology that can make sales forecasting a much more efficient process than it is in most organizations that use software not designed for sales forecasting.

This research finds much indecision about making changes to improve the technology for sales forecasting. Half of organizations do not plan to change their vendor for sales forecasting in the next 12 to 18 months, and only 10 percent plan to change, although 8 percent will upgrade to the current vendor’s latest version. For organizations that are planning to change vendors, the most common reason is to speed up the forecasting process (54%); fully half of this group are not satisfied with their current product’s functionality. A substantial number of organizations are dissatisfied with their tools because data gets outdated quickly: One in four ranked this first. This discontent likely reflects the more rapid flow and greater volume of data organizations accumulate today and issues derived from the use of tools like spreadsheets into which people copy and paste data with no direct link to its sources. Yet the pace of business has accelerated along with the mass of data, and sales groups feel pressure to have timely forecasts; this challenge is another reason for improving the tools in use.

Organizations use desktop spreadsheets for many activities, and while they are easily accessible, spreadsheets are not designed for vr_SF12_03_sales_forecasting_technology_is_changingsales forecasting. Nevertheless the research shows that they are the most commonly used tool for sales forecasting (by 29%); sales force automation (SFA) ranked second, an increase from our past research. The third-most common tool used is analytics and business intelligence (BI, 10%). A range of planning and forecasting applications are used by 16 percent of organizations. Most of this technology was not designed to meet the specific needs of sales forecasting.

More Read

War Games:  A New Type of Competitive Analytical Tool
War Games: A New Type of Competitive Analytical Tool
Redefining Loyalty Programs with Big Data and Hadoop
Putting Historic Business Data To Work With Machine Learning
The Fallacy of the Data Scientist Shortage
Putting the “Social” in Social BI: Meet Lou Jordano

It is not surprising that fewer than one-quarter (24%) of the sales organizations primarily using spreadsheets for sales forecasting are satisfied with their process. Our analysis shows a correlation between spreadsheet use and lack of confidence in the information for sales forecasting: Fewer than one in three organizations relying primarily on spreadsheets (32%) are confident or very confident in the quality of their forecast. Moreover, more than half (59%) said that reliance on using spreadsheets makes it difficult to manage the sales forecast efficiently. Yet despite the evidence that spreadsheets have negative effects on sales forecasting, only 38 percent of heavy spreadsheet users are planning to change their forecasting process in the next 12 to 18 months, fewer than users of SFA (48%) and business intelligence tools (53%). When such an important process as the sales forecast is left to tools not designed for the process, risk increases that sales people will not have visibility into their information, let alone timely knowledge of progress and the source of issues that should be addressed.

On the other hand, the research finds that two in five (40%) organizations use dedicated tools for sales forecasting. Most that do are rather new to the technology; three in 10 have been using it for more than a year, and 10 percent more began in the last year. Currently dedicated sales forecasting software is deployed mostly to users on the front lines of sales: 42 percent of front-line sales managers and 41 percent of the front-line sales team have it available. Those that use dedicated sales forecasting technology find value in it: More than one-fifth (22%) of them said it has improved significantly the outcomes of sales activities and processes, and half (51%) indicated it has improved outcomes slightly. Larger organizations use such applications much more often than smaller ones: More than half (54%) of very large companies that use one have been doing so for more than a year, as have 46 percent of large companies. Another 29 percent of the very large started using a dedicated application in the last year, so nearly four out of five of this size of organization have dedicated software. But more than one-fifth of participants said they have no plans to deploy dedicated software. Asked why, most (58%) said they do not know, which indicates a lack of awareness of the technology and its advantages. One-fourth more (24%) said deploying it will not have a positive impact on business, which indicates a lack of understanding of its benefits. Dedicated applications can contribute to more accurate sales forecasts, but we find that many organizations aren’t prepared to implement them or do not understand why they should.

Our analysis finds good reasons for using dedicated technology. vr_SF12_11_teamwork_critical_for_sales_forecastingSales forecasting requires a team effort that involves account managers who track the sales pipeline, operations people and analysts who manage the process and sales managers who approve it and contribute information and metrics. According to our research the most important capabilities for the sales team in the process are to collaborate within the team to improve the sales forecast (selected by 53%), to compare quotas to the sales forecast (47%) and to perform account-level forecasting (40%). These activities make it possible for sales management to compare changes to the forecast, collaborate to address changes and determine actions, and take advantage of operating conditions in sales. The sales operations group processes the sales forecast, from preparing data through presenting the forecast to sales management, and we find that doing so takes a significant amount of time for this essential sales support team – time that could be spent better in applying a range of analytics to the forecast. Sales managers and management have their own priorities, which makes it important to profile the users of sales forecasting and align software capabilities to their roles and responsibilities. Making notations on why the forecast has changed and providing coaching based on the forecast are examples of tasks required to support the sales forecast process that are particularly difficult to do using a desktop spreadsheet.

vr_SF12_06_organizations_planning_to_change_forecastingOverall our research finds a developing movement to adopt more useful technology for supporting the sales forecasting process. For organizations planning to change, most (40%) are going to use software as a service (SaaS), which is convenient as this cloud-based approach has the lightest burden to install, configure and manage the technology. Nearly as many (35%) plan to use the on-premises approach, which could distract sales from its primary mission and the processes designed to support it. Being able to operate on mobile technology likely will spur adoption as more than half (59%) of participants indicated that mobile technology will help improve the accuracy and timeliness of sales forecasting. We urge organizations to use dedicated software for sales forecasting as a way to improve the outcomes of their sales efforts. Those that do not invest in such software will continue to face impediments in the sales process and risk not achieving the best possible outcomes.

Share This Article
Facebook Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

Flat editorial illustration: The article is about joining public web signals with internal business metrics so BI teams can inter
Alternative Data in BI: Bringing Public Web Data Into Your Dashboards
Big Data Business Intelligence Exclusive Web Analytics
Flat editorial illustration: A SaaS-editorial scene showing product usage, support patterns, and renewal feedback informing a fle
Using Product Usage Analytics and Support Data to Build a B2B Product Roadmap
Business Intelligence Infographic
From Hiring To Payroll: Managing HR Data Across Business Systems -- AI-generated illustration
From Hiring To Payroll: Managing HR Data Across Business Systems
Big Data Business Intelligence Infographic
Flat editorial illustration: The article is about automating the collection, preparation, and delivery of marketing data across p
From Data to Dashboards: 5 Marketing Reporting Automation Software Picks
Analytics Business Intelligence Exclusive Marketing

Stay Connected

1.2KFollowersLike
33.7KFollowersFollow
222FollowersPin

You Might also Like

Data Mining Interview: Guillaume Main
Data MiningPredictive Analytics

Data Mining Interview: Guillaume Main

5 Min Read
So You Want to be a Data Analyst
AnalyticsCulture/LeadershipData MiningExclusivePredictive AnalyticsStatisticsWeb Analytics

So You Want to be a Data Analyst

7 Min Read
Research Uncovers Keys to Using Predictive Analytics
Best PracticesPredictive Analytics

Research Uncovers Keys to Using Predictive Analytics

6 Min Read
AQuA - Audio Quality Analyzer is now available for download!
Predictive Analytics

AQuA – Audio Quality Analyzer is now available for download!

7 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

How To Get An Award Winning Giveaway Bot
How To Get An Award Winning Giveaway Bot
Big Data Chatbots Exclusive
5 Great Tips for Using Data Analytics for Website UX
5 Great Tips for Using Data Analytics for Website UX
Big Data

Quick Link

  • About
  • Contact
  • Privacy
Follow US
© 2008-26 SmartData Collective. All Rights Reserved.
Welcome Back!

Sign in to your account

Username or Email Address
Password

Lost your password?