Good Decision Making Requires Good Data

Over the years, I have become a “data hound” looking for every morsel of wisdom I can ge to help me make smarter decisions. The good news here: accurate data is king. You can’t effectively manage your business without accurate data. Getting it is not always easy but without it you risk making the wrong business decisions — hurting your business when you thought you were helping it. Allow me to explain.

Managing a sales pipeline.

In B2B businesses with long sales cycle the only way to assess the effectiveness of your sales team and predict future revenue is based on data your sales team enters into your CRM. Watch if a salesperson’s number of accounts is growing, how those leads are working their way through the sales funnel and total dollar value of the pipeline being managed.

But, think about what I just said: you are evaluating the success of your sales team based on the data they are entering (or not entering) in the CRM system. That creates multiple problems. I have seen situations where salespeople enter false information to look more successful to save their jobs. More generally, there is plenty of room for error any time you rely on humans for data.

For example, did the salesperson remember to enter a new lead into the CRM? Did they remember to update the status of a lead (e.g., from active to dead)? Did they update the dollar value of that lead from $20,000 to $10,000 after they learned the client didn’t need as many products as they first thought? Did they update the expected close date from April to June, after they learned the project has been delayed?

You get the point. Most businesses are making mission critical decisions based on future expected revenues from this data. More often than not, the data is not very accurate, updated or reliable.

If your CRM suggests you are working with more than $1,000,000 of potential leads, and your normal conversion rate is 20 percent, you would think there is a reasonable chance to close $200,000 in sales. That’s money you count on to run the business, pay your bills and meet payroll. Bad data could put you in an illiquid position, unless you have a cash reserve cover the $200,000 that didn’t show up as predicted.

You need to scrub the data when managing a sales pipelines. Every week, remind your salespeople to update their data. In your one-on-one meetings with the team, talk through their list, line Most good CRMs or sales enablement tools can help you here.

Related: 4 Tips to Move Prospects Through Your Sales Pipeline Faster

Managing marketing spend.

The quality of your marketing efforts depends on the quality of the data being managed and studied. Typically, there are two problems. First, is your marketing team managing towards the right data metrics in the first place. Second, is credit being given to the marketing channel that actually drove the lead? In a multi-device world it’s not easy to get proper attribution.

Recently we hired an ad agency to manage our paid search campaign. We told them the key metric to drive was immediate return on ad spend (ROAS), defined as clearly attributed revenues from the campaign divided So, after six months of these learnings, we switched directions. We told the agency immediate ROAS was no longer the goal. We would be happy waiting until the end of our three-month sales cycle before studying our ROAS. We switched the key metric to immediate B2B leads from the marketing effort. As soon as we made that change our quick, low ticket sales fell back to normal levels but our desired B2B leads rose to record highs. We were thrilled, thinking we had finally “cracked the code” to scaling our business.

But, did we? We did a retroactive cohort analysis of all B2B leads that came into the business over our normal three month booking window. What we learned was concerning: the B2B leads were coming into the business in record numbers, but were converting into sales at levels far lower than our typical conversion rates. After researching this further with our sales team we learned the leads coming in were very price sensitive. They were shopping many websites for the lowest price and often needed last-minute deliveries that were impossible to fulfill in time.

So, now we are back to the drawing board, trying to figure out the right metric to find leads we can actually work with and properly attribute the leads so we are not missing anything important. We also want to be careful not to “throw the baRelated: 5 Stupid Phone Mistakes Ruining Your Sales Pipeline

These are examples in sales and marketing but I easily could have given you data-driven examples from operations, finance, human resources or technology. You are living in a world where accurate data is king. Be sure your business is driven