Mastering Sales Forecasting: Insights from Ops Experts

Sales forecasting is more than just calling a number—it's the operating rhythm of the entire company. A solid sales forecast allows a company to invest and grow with confidence, while a poor one leads to distrust and finger-pointing. In this episode of Operations, Sean Lane dives deep into the art and science of forecasting with two experts from Drift, Paul Shea and Chris Lowry.

---

Understanding the Foundations of Forecasting

Paul Shea and Chris Lowry both played crucial roles in building and refining Drift’s forecasting model. They emphasize the importance of balancing data analysis with a deep understanding of the business. When they began at Drift, they faced the challenge of creating a forecasting model that could predict within 5% of actual results.

Key Ingredients for Accurate Forecasting

1. Know Your Business:

   • Paul started by understanding Drift’s target market and sales cycles. Whether targeting SMBs or Fortune 500 companies, knowing your ICP (Ideal Customer Profile) is critical.

   • Chris adapted the existing model by focusing on data accuracy and aligning with business changes, such as shifting from SMB to enterprise clients.

2. Data and People:

   • Spend time with sales leaders and reps to understand their perspectives.

   • Dive into Salesforce data to track opportunity progress and conversion rates.

3. Crawl, Walk, Run Approach:

   • Begin with simple models, like weekly snapshots of pipeline data.

   • Gradually add complexity, such as segment-specific conversion rates and rep capacity analysis.

---

Practical Steps for Building a Forecasting Model

1. Weekly Snapshots:

   • Use tools like G Connector to connect Salesforce to Google Sheets and take weekly pipeline snapshots.

   • Analyze how deals progress through stages and use historical data to predict future conversions.

2. Segment-Specific Models:

   • Tailor models for different market segments to account for varying sales cycles and win rates.

   • Separate forecasts for new business, renewal, and expansion dollars.

3. Sales Capacity Analysis:

   • For create-and-close pipeline, consider the number of reps and their historical performance.

   • Adjust for factors like rep ramp time and inbound lead volume.

4. Renewal Base Forecasting:

   • Implement a pipeline date field to track when positive pipeline potential is identified.

   • Use this data to forecast expansion opportunities more accurately.

---

Overcoming Challenges and Building Trust

Effective forecasting requires collaboration and trust between operations and sales teams. Paul and Chris share strategies for aligning their forecasts with sales leaders’ insights:

1. Collaborative Conversations:

   • Understand how sales leaders build their forecasts and use data to support or challenge their assumptions.

   • Aim for a unified forecast number that combines data-driven insights with sales leader expertise.

2. Consistent Communication:

   • Regularly update and refine the model based on new data and changing business conditions.

   • Use forecasts to drive strategic decisions and maintain alignment across the organization.

---

Is It Worth the Effort?

Both Paul and Chris affirm the value of investing in a robust forecasting model. While it requires significant effort and ongoing maintenance, the benefits of accurate forecasting far outweigh the challenges. For companies at different stages, the key is to assess the timing and resources available to build and maintain the model effectively.

---

Additional Materials

For further insights and practical tools, explore the following resources:

1. Listen to the full podcast here or watch the full Interview here

2. Video Short: Sales+Ops Together = Accurate Forecast

---

FAQs

• What are the key components of an effective sales forecasting model?

  Key components include understanding your business and ICP, using data and people insights, applying a crawl-walk-run approach, and segment-specific models for accurate predictions.

• How can sales and operations teams collaborate on forecasting?

  Collaboration involves understanding each other’s perspectives, using data to support or challenge assumptions, and aiming for a unified forecast number that combines data-driven insights with sales leader expertise.

• What are the benefits of accurate sales forecasting?

  Accurate sales forecasting allows a company to invest and grow with confidence, aligning business strategy with realistic revenue expectations and reducing the risk of distrust and finger-pointing.

• How should companies approach forecasting for different market segments?

  Companies should tailor forecasting models for different segments, considering factors like varying sales cycles and win rates, and creating separate forecasts for new business, renewal, and expansion dollars.

• When is the right time to invest in a robust forecasting model?

  The right time depends on the company’s stage, resources, and business complexity. Early-stage companies might start with simple models and gradually add complexity as they grow and gather more data.