Articles

Clean your messy pipeline data with these 5 simple reports

Written by Ryan Haughey | Oct 4, 2022 11:30:00 AM

The concept of “messy data” comes up a lot in my world as Head of Data at Falkon. Our platform pulls in various data sources, reasons over them, and serves up actionable insights to help teams drive more revenue.

When people hear about that process, they commonly react with the assumption that their data is too messy to be useful. In particular, Salesforce data quality is a concern for many go-to-market teams. 

Messy data is a problem because it gets in the way of taking the right actions. It hides accounts that need attention.

Our CEO has written about how to be data driven even if your data is messy, and I’m going to add some concrete steps you can take to clean up your data. 

These five reports will help you do three things to drive more revenue: 

  1. Prioritize the opps your team should focus on in a given week
  2. Ask your team the right questions about deals that need attention
  3. Decrease the number of opps that are in problem states

You can make these reports using Salesforce or Hubspot and spreadsheets that will also prepare you to get better insights out of an intelligence platform should you decide to use one at some point. 

What is messy data?

I’ve noticed that there are three distinct situations people refer to when they talk about messy data.

Messy data can mean:

  1. We don’t have the data we need. We’re not collecting it.
  2. Our data is wrong. Collection isn’t automated and people don’t fill in their fields. 
  3. Our data is stale. We collect the right data and it’s accurate, but we don’t have visibility into it until it’s no longer relevant. We can’t use it to course correct or to coach, only to look back at a moment in time and we don’t know which moment we’re actually looking at. 

All three of these scenarios are problematic. I’m focusing here on the third one because visibility is the most vital component to making data actionable and it’s the most difficult one to make progress on without an intentional plan. 

The first two problems need to be solved by sales or operations teams. The third should be solved by revenue leaders. 

The five reports

Each of these reports should take five minutes or less to set up with your current CRM, such as Salesforce or Hubspot, and a spreadsheet. They represent problem states that you might not otherwise see in aggregate data. 

Taken together, these reports help you identify pipeline that’s stuck, neglected, and “fake” in the sense that it’s not really going to close in the quarter. 

Once you see the deals that pop up, it will be easy to make decisions about next steps and improve your data quality.

Should an opp be prioritized? Should it be taken out of your quarter’s commit number? Should the rep be coached on how to move it to the next stage? You'll get clarity as you clean up your pipeline using these reports. 

Stuck deals

This report requires that you know your ideal sales cycle timeline by stage.

If you don't already know how long a deal should be in a stage, start by doing a quick analysis on recent deals to find those numbers by looking at the average time spent between stages for closed-won deals over the past year.

Create a report that flags any deal that’s been in its current stage for 1.5x longer than it should be.

Work with the owners of these deals to get them unstuck. 

Setting it up

Timing: Friday mornings

Audience: Sales managers

Why? Using this report on Fridays helps get initial questions in before the week ends. Then, set up deep dives as soon as the new week starts. This timing means you don’t lag on taking action. 

“Fake” opps

Use the timeline you researched for stuck deals again to identify deals that are inflating your pipeline numbers.

Set up a report that looks for deals with a closing date in this quarter, but a stage that’s too early for that date to be hit.

To do this, compare the days between today and the current close date. Then compare that with the average time from the current stage to closing for closed-won deals over the past quarter. If the average number is 1.75x larger than the current number, it’s worth the time to check out what’s going on. 

These deals may have dates that need to be updated, which the owner can easily fix. They may also have the wrong close date. Either way, they need attention to stay on track for the appropriate quarter.

Setting it up

Timing: Weekly for reps on Monday, every other week for managers on Wednesday

Audience: Reps and managers

Why: Most of the time, this issue is simply a function of not keeping inputs up to date, so best to flag with the reps that own the inputs. Giving them two days before managers see the report is enough time to make the first pass at addressing the issue before it makes it onto the Wednesday report. 

Frequently pushed deals

Deals that have had their close date change frequently, particularly three or more times, may also be inflating your pipeline. 

Set up a report to flag any deals in best case and commit stages with more than two pushed-out date changes so you can find out from the owner if something is going on that needs attention.

Setting it up

Timing: Weekly

Audience: Managers

Why: Pushed deals are one of the most common and frequent ways teams get surprised by missing their goals for the quarter. Checking on them weekly gives time to course correct. 

Past due opps

Set up a report to capture active deals with a close date in the past.

Again, work with the owners to find out why the deals aren’t yet closed. Find out if they’re still legitimate opportunities and, if so, how to get them back on track. 

Timing: Weekly

Audience: Reps and managers

Why: Similarly to pushed deals, past due opps often surprise teams at the end of the quarter. Finding out about them as soon as they happen gives the team a chance to close them or move them so revenue isn’t falsely tied to the quarter. 

Neglected deals

This report will help you identify deals that are slipping through the cracks or don’t have the level of visibility needed to drive effective coaching. 

Set up a monitor for deals that haven’t had their next steps updated in the past 30 days. 

These deals may be neglected by the owners, or the owners may simply not be updating their records. Both issues should be addressed.

If this data isn’t kept up to date, then your 1:1s will be about bringing status up to date rather than talking about solutions. Keeping detailed, up-to-date records lets you get context before a 1:1 so you can coach.

Setting it up

Timing: Weekly

Audience: Reps

Why: While your ability to coach is affected by this data, it’s difficult for reps to keep tabs on every detail. Giving them the report before your 1:1 gives them the tools to understand their own pipeline status and update what’s missing without being nagged. 

How to use the reports

Once the reports are created, follow these steps to use them to clean your pipeline data.

  1. Set up a Slack alert or email report to deliver the information to the recommended team members on the recommended cadence.
  2. Define a key result for the quarter to drive realistic improvement. If your initial list of neglected deals, for example, contains 50 opps, set your key result to get it down to 10 by the end of the quarter. 
  3. Carve out 5 minutes as a recurring appointment with yourself to review the reports. They should be simple enough to check on at a glance, but it’s easy to forget to pay attention to your alerts with everything going on. If a meeting on your calendar won’t help you remember, choose any structure that will. 

As you get used to seeing the reports and your team gets used to you reacting to the data, fewer and fewer deals will show up—the team will improve and the data itself will be more accurate. 

Download these tips as a PDF > 

Follow us on LinkedIn for more tactics like this. We'd love to connect!