Successful sales reps view and manage their open opportunities in Salesforce daily (or more) and ensure that the fields important to their organization (close date, stage, etc.) are accurate and up to date.

Keep your close dates up to date

There is no such thing as a close date in the past for an open opportunity. Near month-end sales reps are often pressed for time and it is easy to neglect managing and updating your opportunities in Salesforce. Neglecting the process, however, has far-reaching ramifications that affect the entire company forecast. If you have 50 open opportunities on the 25th of the month the majority of them will likely be pushed to the next month. Leaving these opportunities in the current month not only results in your own poor forecast but rolls up to your manager’s forecast (and the overall company forecast).

Keep your sales stages minimal and up to date

Having too many stages can lead to confusion. This ultimately leads to more time to review an opportunity which then leads to putting the review on the back burner. When a significant event occurs you should religiously update your stage. Doing so will often trigger an update to the opportunity forecast category. It will also update the probability of closing the deal. This cascades into an updated ‘expected amount’ value which is critical for sales managers.

Keep running notes that are available in list view

You may have a Google Doc or some other method of tracking your notes, but you should also find a way to add short updates directly to the opportunity using a comments/description field. Add to this by editing the opportunity and inserting the most recent, very abbreviated note, at the top of the field).

Opportunity Last Modified Date and Last Activity Date

Successful sales reps are in touch with their prospects often, and when they aren’t there is usually a valid reason, such as a request to follow up on a specific date, which is generally tracked as a task.

When you view and manage your Salesforce opportunities include the last activity date in your view. Your touchpoints may vary depending on your business. You can use the last activity date to make sure you’re not letting opportunities get stale.

If you are updating other fields such as description or next steps consider adding the Last Modified Date to your view. Updates to these fields will not be reflected in the Last Activity Date.

Don’t keep stale opportunities open

All too often a sales rep will be overly optimistic and leave stale opportunities in the forecast. Successful sales reps learn to close opportunities (like set to Closed/Lost) with little chance of success to focus their efforts on the opportunities with the highest chance of success. If a customer is truly interested in buying from you they will be back.

Managing Opportunities Checklist

View your opportunities in Salesforce daily (or more)

  • Make sure the expected close dates are accurate (they should be realistic with none in the past)
  • Update your stages
  • Update your notes / comments, etc.
  • Filter on the last activity date or last modified date to identify opportunities that should be contacted
  • Close your stale opportunities and focus on the ones with a higher chance of closing

Automate the process for accuracy and to save time

Updating opportunities one by one in Salesforce can take a valuable, but necessary, chunk of time out of your day. There are integration tools available such as Celigo’s CloudExtend Excel for Salesforce. They significantly cut the time down to just a few minutes per day by allowing sales reps to view and update their opportunity fields in bulk directly in Excel.


Keeping opportunities up to date is good for you. It’s crucial for your sales manager and the organization as a whole. Without up to date numbers a forecast will be inaccurate. In the worst-case scenario can lead to the demise of a company.

Show Buttons
Hide Buttons