Deal Forecast report

```mediawiki Navigation: Main_Page > Reports > Deals > Deal Forecast report

Deal Forecast Report

The Deal Forecast report provides an overview of your pipeline status and enables effective business forecasting on a daily, weekly, or monthly basis. This report also allows you to analyze historical trends pertaining to forecast accuracy by reviewing both open and closed deals.

By using this feature, you can:

• Set a date range to see metrics within a specific time period.
• Measure forecast accuracy overall or by deal owner.
• Export results in various formats such as CSV, TXT, Excel (2007 or later), JSON, HTML, or Markdown.

How to Access the Deal Forecast Report

The Deal Forecast report is available to account users assigned to the Admin group or who have permission to view Deals reports.

To access the report, use one of the following methods:

1. Click Reports in the left menu. Then click Deals > Deal Forecast. 2. Click Deals in the left menu. Click Deal Forecast under Reports.

Upon accessing the report, it will load metrics from the last 7 days.

Step-by-Step Instructions

Here's how to effectively use the Deal Forecast report:

Filtering Data in the Deal Forecast Report

At the top of the report, you have several filtering options to refine the data displayed:

• Pipeline: This dropdown allows you to view data for all pipelines or select a specific pipeline.
• Currency: Displayed as a dropdown of all currency types set up for deals. Note that it does not convert deal values; it's purely for categorization.
• Deal Owner: Use this dropdown to filter data for all deal owners or a specific deal owner.
• Forecasted Close Date (Date Range): This filter refers to the date a deal owner has entered into the Forecasted Close Date field. Adjust the displayed data based on selected timeframes, even allowing future date selection to project upcoming revenue.
• Deal Creation Date (Date Range): This filter lets you view deals created within a defined timeframe.

To apply any filter, simply click the dropdown for the relevant filter, select your options, and the report will automatically reload to display the filtered results.

Information Included in the Deal Forecast Report

The Deal Forecast report includes several components that provide insights into your deals:

• Deal Forecast Stats: Located at the top of the report, these four stats summarize top-level data based on your filters:

 * **Total Deal Count**: The number of deals marked as Won, Lost, or open with a forecasted close date.
 * **Forecasted Value**: The total value of all deals with a forecasted close date.
 * **Actual Value Marked Won**: The total value of all deals marked as "Won" with a forecasted close date.
 * **Forecast Accuracy**: This metric indicates overall forecast accuracy. For instance, if a deal was forecasted to close on January 4, 2020, and was marked as "Won" on that date, it represents 100% accuracy. If marked on February 4 instead, accuracy would be 0%.

Clicking on any of these stats allows you to export all deals relating to that particular metric.

• Dynamic Timeframe Chart: Below the Deal Forecast Stats, this chart displays both total forecasted values (represented by purple bars) and actual values marked as won (represented by orange bars) across various time periods. Hover over any bar to see the dynamic date range and total value, and clicking will let you export the deals related to that timeframe.

• Dynamic Timeframe Table: This table appears beneath the Dynamic Timeframe Chart and presents detailed metrics including:

 * Actual Won Total Value
 * Forecast Total Value
 * Forecast Accuracy
 * Actual Won Total Value
 * Forecast Total Value
 * Forecast Accuracy
 Clicking on any number will permit exporting all deals connected to that specific value.

• Deal Level Detail Table: This table lists all deals that correspond to the current report display and breaks down information at a granular level, including:

 * Deal value
 * Stage
 * Pipeline
 * Deal Owner
 * Contact name
 * Contact email
 * Forecasted close date
 * Status date changed
 * Status
 

You can download and export the Deal Level Detail Table for further analysis or sharing. To do so:

1. Hover over the row you wish to export (in the Form Submission Details section). 2. Click the vertical dots that appear on the right. 3. Select Download Data. 4. In the modal popup, choose your desired file format from the dropdown (CSV, TXT, Excel (2007 or later), JSON, HTML, or Markdown). 5. Click the Download button to save the file to your computer.

Configuration Options and Settings

When working with the Deal Forecast report, keep in mind these important configuration options:

• **Forecasted Close Date**: Each deal owner must accurately input this date to realize the full potential of the forecasting capabilities.
• **Pipeline**: Ensures appropriate segmentation of data based on your sales processes.
• **Currency**: Helps categorize deals based on the monetary unit used, but does not perform conversions.

Best Practices and Tips

To maximize the effectiveness of the Deal Forecast report, consider the following best practices:

• **Regular Updates**: Ensure all deal owners consistently update the Forecasted Close Date field to maintain accurate forecasting.
• **Utilize Filters**: Make use of the filtering options to focus on specific segments of your pipeline, which aids in more effective analysis.
• **Monitor Trends**: Regularly review the historical data trends offered in the report to adjust strategies accordingly.

Troubleshooting

If you encounter issues accessing or interpreting the Deal Forecast report, consider these tips:

• Ensure you have the appropriate permissions to access deals reports.
• Refresh the page if the report does not load correctly or shows outdated data.
• Check that all relevant deals have been updated with correct Forecasted Close Dates to ensure that your data is accurate.

FAQ

What is the Deal Forecast report?

The Deal Forecast report gives an overview of your pipeline status and helps forecast business performance based on open and closed deals.

How can I access the Deal Forecast report?

You can access it through the Reports section or directly from the Deals menu in the left navigation pane.

What data can I filter in the Deal Forecast report?

You can filter by Pipeline, Currency, Deal Owner, Forecasted Close Date, and Deal Creation Date.

Can I export data from the Deal Forecast report?

Yes, you can export data in multiple formats including CSV, Excel, JSON, HTML, and Markdown.

What metrics are included in the Deal Forecast report?

Key metrics include Total Deal Count, Forecasted Value, Actual Value Marked Won, and Forecast Accuracy, among others.

How does filtering affect the report's data?

Filtering adjusts the report to show only the deals that meet your selected criteria, providing more targeted insights.

Why is the Forecasted Close Date important?

The Forecasted Close Date is crucial as it determines the accuracy of the forecasts and analysis presented in the report.

By correctly utilizing the Deal Forecast report, you can gain valuable insights into your sales pipeline and significantly impact your forecasting effectiveness. ```