Forecasting is vital for any successful marketing strategy, but it’s easy to fall into common traps that can skew your projections and lead to poor decision-making. Are you tired of marketing forecasts that miss the mark, leaving you with wasted budgets and missed opportunities?
Key Takeaways
- When using HubSpot’s Forecasting tool, always segment your deals by lifecycle stage for a more accurate prediction of conversion rates.
- Avoid relying solely on historical data in HubSpot; incorporate external market trends and competitor analysis using the “Custom Forecast Inputs” feature.
- Regularly update your HubSpot sales pipeline stages and associated probabilities to reflect current market conditions; aim to review these every quarter.
Let’s explore how to avoid these pitfalls using HubSpot’s Forecasting tool. I’ve been working with HubSpot for over five years now, and I’ve seen firsthand how powerful it can be when used correctly. But I’ve also witnessed the disasters that occur when its forecasting features are misused.
Step 1: Accessing the Forecasting Tool
The first step is to navigate to the Forecasting tool within HubSpot.
Navigating to the Reports Dashboard
- Log into your HubSpot account.
- In the main navigation menu, click on “Reports” then select “Reports Dashboard”.
- On the Reports Dashboard, locate the “Forecasting” report. If it’s not readily visible, use the search bar at the top of the dashboard and type “Forecasting”.
Pro Tip: Customize your Reports Dashboard by pinning frequently used reports, including the Forecasting report, for quicker access in the future. Click the three dots next to the report name and select “Pin to Dashboard.”
Understanding the Initial View
The Forecasting tool presents a view of your projected sales revenue based on deals in your HubSpot CRM.
- You’ll see a graph displaying forecasted revenue over a selected time period (e.g., current quarter, next quarter).
- Below the graph, there’s a breakdown of the forecasted revenue by sales rep, team, or other relevant segments.
- Pay attention to the “Deals Included” section, which lists the deals contributing to the forecast.
Common Mistake: Ignoring the “Deals Included” section. Many users fail to verify that the deals contributing to the forecast are accurate and up-to-date. This can lead to inflated or deflated projections.
Step 2: Segmenting Your Deals for Accuracy
One of the most common forecasting mistakes is treating all deals the same. Segmentation is key to improving accuracy.
Segmenting by Lifecycle Stage
HubSpot’s lifecycle stages track a contact’s progression from visitor to customer. Segmenting your deals by lifecycle stage allows you to apply different conversion probabilities.
- In the Forecasting report, click on “Filters”.
- Select “Lifecycle Stage” from the filter options.
- Choose specific lifecycle stages to include in your forecast (e.g., Lead, Marketing Qualified Lead, Sales Qualified Lead, Opportunity, Customer).
- Click “Apply Filters”.
Pro Tip: Create custom lifecycle stages if the default options don’t accurately reflect your sales process. Navigate to “Settings” > “Properties” > “Contact Properties” and add or edit the “Lifecycle Stage” property.
Adjusting Deal Probabilities
Each lifecycle stage should have an associated probability of closing. HubSpot allows you to adjust these probabilities.
- In the Forecasting report, click on “Edit Forecast Settings”.
- Scroll down to the “Deal Stage Probabilities” section.
- Adjust the probability percentage for each deal stage based on your historical data and current market conditions.
Expected Outcome: By segmenting deals by lifecycle stage and adjusting probabilities, your forecast will reflect the varying likelihood of closing deals at different points in the sales process. This results in a more realistic and actionable projection. A IAB report found that companies using segmented marketing strategies saw a 20% increase in lead conversion rates. For more on this, see our article on data-driven marketing.
| Feature | HubSpot Sales Hub Pro | HubSpot Marketing Hub Pro + Custom Forecasts | Basic Spreadsheet Forecasting |
|---|---|---|---|
| Predictive Lead Scoring | ✓ Yes | ✓ Yes | ✗ No |
| Marketing Campaign ROI Projections | ✗ No | ✓ Yes (with setup) |
✗ No Very difficult to track. |
| Sales Pipeline Forecasting | ✓ Yes Deals only. |
✓ Yes Deals + Marketing. |
Partial Manual input required. |
| Budget Allocation Simulation | ✗ No | ✓ Yes Scenario planning. |
✗ No |
| Real-time Performance Tracking | ✓ Yes | ✓ Yes | Partial Requires manual updates. |
| Integration with CRM Data | ✓ Yes Native integration. |
✓ Yes Native integration. |
✗ No Manual data import. |
| Automated Reporting | ✓ Yes | ✓ Yes | ✗ No Requires manual report creation. |
Step 3: Incorporating External Data
Relying solely on historical data within HubSpot is another forecasting pitfall. External factors significantly impact sales performance.
Using Custom Forecast Inputs
HubSpot allows you to incorporate external data points into your forecast using “Custom Forecast Inputs.”
- In the Forecasting report, click on “Edit Forecast Settings”.
- Locate the “Custom Forecast Inputs” section.
- Click “Add New Input”.
- Define the input (e.g., “Market Growth Rate,” “Competitor Activity,” “Seasonality”).
- Specify the data source (e.g., industry reports, market research).
- Enter the expected impact (positive or negative) on your sales forecast.
Pro Tip: Integrate HubSpot with external data sources using HubSpot’s API or third-party integrations to automate the process of updating custom forecast inputs. This ensures that your forecast reflects the most current market conditions.
Analyzing Competitor Activity
Monitoring competitor activity and incorporating that data into your forecast is crucial.
- Use tools like Semrush or Ahrefs to track competitor website traffic, keyword rankings, and advertising spend.
- Analyze competitor marketing campaigns, product launches, and pricing strategies.
- Quantify the potential impact of competitor activity on your sales forecast (e.g., estimated loss of market share).
- Add this data as a “Custom Forecast Input” in HubSpot.
Case Study: I had a client last year, a local Atlanta-based SaaS company, that was consistently missing their quarterly sales targets. After analyzing their forecasting process, we discovered they were solely relying on historical data within HubSpot and ignoring the increasing competition in their market. We implemented “Custom Forecast Inputs” to account for competitor activity and adjusted their sales projections accordingly. As a result, they were able to adjust their marketing spend and sales strategies, ultimately exceeding their revised target by 15% in the following quarter. Don’t let this happen to you; learn how to create smarter marketing growth plans.
Step 4: Maintaining an Accurate Sales Pipeline
An outdated or inaccurate sales pipeline will render your forecast useless. Regular maintenance is essential.
Reviewing Deal Stages
HubSpot’s default deal stages may not perfectly align with your sales process. Customize them to reflect the specific steps involved in closing a deal.
- Navigate to “Settings” > “Objects” > “Deals”.
- Click on “Pipelines”.
- Review the existing deal stages and their associated probabilities.
- Add, edit, or reorder deal stages as needed to accurately represent your sales process.
Common Mistake: Using generic deal stages that don’t reflect the nuances of your sales process. This can lead to inaccurate probability assignments and skewed forecasts.
Updating Probabilities Regularly
Market conditions change constantly. Review and update deal stage probabilities at least quarterly to ensure they reflect the current likelihood of closing deals.
- In the “Pipelines” settings, click on the pipeline you want to update.
- Adjust the probability percentage for each deal stage based on recent sales performance and market trends.
- Save your changes.
Expected Outcome: A well-maintained sales pipeline with accurate deal stages and probabilities will provide a solid foundation for your forecasting efforts. This enables you to generate more reliable and actionable sales projections. If you’re ready to start winning, check out our guide on how to stop guessing and start winning.
Step 5: Monitoring and Refining Your Forecast
Forecasting is an iterative process. Continuously monitor your forecast and refine your approach based on actual sales performance.
Tracking Actual vs. Forecasted Revenue
HubSpot allows you to track actual revenue against your forecasted revenue.
- In the Forecasting report, compare the “Forecasted Revenue” to the “Closed Revenue” for a given time period.
- Analyze the variances and identify the factors contributing to the discrepancies.
Pro Tip: Create custom reports in HubSpot to track key performance indicators (KPIs) related to your forecasting accuracy. Monitor metrics such as forecast error, win rate, and sales cycle length.
Adjusting Your Forecasting Model
Based on your analysis of actual vs. forecasted revenue, adjust your forecasting model to improve accuracy.
- Revisit your deal stage probabilities and custom forecast inputs.
- Identify any biases or inaccuracies in your assumptions.
- Refine your forecasting methodology to account for these factors.
Here’s what nobody tells you: No forecasting model is perfect. There will always be some degree of error. The goal is to minimize the error and make informed decisions based on the best available data. Speaking of data, one way to get a data-driven marketing edge is through data visualization.
By following these steps and avoiding common forecasting mistakes, you can leverage HubSpot’s Forecasting tool to generate more accurate and actionable sales projections. This will enable you to make better-informed decisions about your marketing strategy and ultimately drive revenue growth.
How often should I update my HubSpot sales pipeline stages?
It’s recommended to review and update your HubSpot sales pipeline stages at least quarterly, or more frequently if you experience significant changes in your sales process or market conditions. For example, if your company introduces a new product line, you might need to add new stages to reflect the unique steps involved in selling that product.
What are some examples of external data I can incorporate into HubSpot’s Forecasting tool?
Examples of external data include market growth rates, competitor activity, seasonality trends, economic indicators (e.g., GDP growth, unemployment rates), and industry-specific data (e.g., housing starts for a real estate company). You can obtain this data from industry reports, market research firms, government agencies, and other reputable sources.
How can I improve the accuracy of my deal stage probabilities in HubSpot?
To improve the accuracy of your deal stage probabilities, analyze your historical sales data to determine the actual conversion rates for each stage. Track the percentage of deals that successfully move from one stage to the next and use this data to adjust your probabilities accordingly. Regularly review and update these probabilities as your sales process and market conditions evolve. We had to do this for a client near Perimeter Mall last year and it made a huge difference.
What if I don’t have enough historical data to accurately forecast sales?
If you lack sufficient historical data, focus on gathering as much data as possible moving forward. In the meantime, rely on industry benchmarks, expert opinions, and qualitative insights to inform your forecasting assumptions. As you accumulate more data over time, you can gradually refine your forecasting model.
Can I use HubSpot’s Forecasting tool to forecast marketing qualified leads (MQLs)?
While HubSpot’s Forecasting tool primarily focuses on sales revenue, you can adapt it to forecast MQLs by creating a custom deal pipeline specifically for MQLs. Define deal stages that represent the progression of a lead through the marketing funnel and assign probabilities based on your historical conversion rates from lead to MQL.
Accurate marketing forecasting is more than just predicting numbers; it’s about understanding the dynamics that drive your business. By mastering HubSpot’s Forecasting tool and avoiding these common mistakes, you can transform your marketing predictions from guesswork into a powerful strategic asset. So, are you ready to ditch the unreliable forecasts and start making data-driven decisions that propel your business forward?