All Collections
Getting started
How to clean up your sales data
How to clean up your sales data

Its important to get your sales data up-to-date. This article will help you maximise the value you will get out of the app.

Michael Foulkes avatar
Written by Michael Foulkes
Updated over a week ago

Common signs your sales data isn't clean / up to date

Here are a couple of quick ways QuarterOne can help you to spot if something is wrong with your data. Once a week, we'll also send you an email highlighting anything we think needs investigating.

  1. Open deals appearing in past months - the QuarterOne dashboard chart allows you to easily see old open deals hidden in your sales data.

  1. Deals without close dates – deals without close dates are automatically added to the "Unallocated" column of the Pipeline grid.

To see these deals go to:
Pipeline page -> click Customize Grid -> select Unallocated from the menu that appears.

Simple steps to clean-up your sales data

  1. Close lost old deals where the prospect / customer is no longer engaged in the buying journey. If the prospect isn't responding to communications and there is no clear plan to move the conversation forward, the deal probably needs to be taken out of the pipeline or pushed back up the funnel.

  2. Add missing close dates for open and booked deals appearing in the 'Unallocated' column of the Pipeline grid (see point 2 above). The QuarterOne app needs to know at least the month you expect deals to close before including in the forecast. Deals without close dates will not appear in forecast unless they are added manually.

  3. Update close dates for open deals, particularly those appearing in past months (see step 1 of section above). Be realistic about the close timeline – if it frequently takes 3 months for contracts to go through legal approval or your customer goes into shut-down at Christmas, don’t forget to factor this in.

  4. Backfill missing historic sales data so you can view your current pipeline alongside the past performance. Ideally back-date deal “create dates” and “close dates” so QuarterOne can more accurately calculate your historic sales velocity. The can easily be done as an upload file - please see the article Back-filling missing sales data

Did this answer your question?