Loading
Salesforce now sends email only from verified domains. Read More
Analyze Your Data
Table of Contents
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

          Search all of Salesforce Help
          Track Changes in Your Sales Pipeline

          Track Changes in Your Sales Pipeline

          A historical report can help you monitor your company’s sales pipeline to make sure it contains enough activity to meet current and future sales goals. For example, focus on deals whose value grew or shrank in the last three months, or deals that moved into or out of a given target period.

          Compare historical and current values of key attributes of opportunities such as dates, amounts, and status, to see how your pipeline has changed over time. For example, this Lightning Experience report points out opportunity amounts and close dates that have changed since 3 months ago.

          • Snapshot up to five dates to track day-to-day or week-to-week trends.
          • Current and historical values are shown side by side for easy comparison.
          • Changed dates and amounts are highlighted in red or green.

          An opportunity report with the historical trending custom report type.

          1. Watch Your Pipeline Change Over Time
            Let’s say you want to know how the total value of your pipeline today compares with its value yesterday. Create a simple report to compare the two dates.
          2. Identify Historical Deals Over a Given Value
            Suppose you want to focus only on deals in your pipeline worth more than $5,000, but you’re not concerned about today’s fluctuations. Use a historical trending report that filters out any deal with a value that was below $5,000 yesterday.
          3. Find Deals that Have Been Pushed Out
            To focus on deals that are taking more time to close than expected, create a historical trending report that finds deals in your pipeline that have had their close dates moved to a later date.
          4. Identify Shrinking Deals
            Historical trending analysis can help you prioritize by quickly identifying deals that are at risk. For example, target the deals in your pipeline that have decreased in value since yesterday. Use a historical trending report that gives you the deals whose value yesterday was greater than their value today.
           
          Loading
          Salesforce Help | Article