Data Quality – The Foundation

As an MSP, your reputation is only as good as your data. If your data is suspect, your clients might question the quality of your services.


Let’s start by considering the data we have. We track our clients’ assets (hardware and software) warranty and purchase dates, supported and Office 365 users, vendor contract and subscription renewals, and operating systems. With this data we provide insights on:


    • Budget forecasts
    • Active and available licenses
    • Contract renewal windows
    • Necessary asset and OS lifecycle replacements

Data Quality (or lack thereof)

Now let’s consider data quality – or more to the point – let’s consider the impact of POOR data quality:

No purchase dates for a device (or no make, model, serial number so we can look up those dates)

  • Without a purchase data, you cannot automate the calculated end of life date lookup. Without an end of life date, the asset is missing in the budget forecast. If the asset is missing in the budget forecast, then it isn’t a forecast, it is a guess – which we already know is wrong.  You’ll be scrambling to explain to your customers why they have to replace hardware at the last minute that you should have known about in advance.
 Inaccurate user lists
  • It is the MSPs responsibility to help its clients run efficiently. Overspending on users’ software licenses because of unaccounted for inactive users is not efficient. Overcharging for users is bad for clients. Undercharging is bad for the MSP.  Either way, you’ll spend your QBR focusing on aligning your data with your client’s actual needs instead of engaging in higher value strategic discussions.
Quick fix data
  • In an effort to get a client report out the door, you manually update a spreadsheet and print. But the problem comes when that data isn’t permanently updated and you have to perform the same effort during the next review cycle. Lather. Rinse. Repeat.  It’s even worse when that person repeating manual tasks is the most expensive employee at your MSP – the owner!

Bad data = Bad business

It is pretty obvious, bad data is bad business. The solution is clearly to do it right, and do it right the first time. But how do you know the quality of your data? That is exactly the question Lifecycle Insights wants to help you answer with their data quality report.

Introducing the data quality score

Lifecycle Insights has developed an algorithm to calculate a data quality score based on a weighted average of missing data. This color-coded score gives you instant feedback on the quality of your clients data. Your data quality score is a baseline. It is not the finish line. It also comes with some other critical information. Each client has a data quality score with drillable reports to pinpoint individual asset details and/or missing data. Prioritize your clients, choosing the ones with upcoming QBRs first and get to work. Thankfully now that you know what is missing, a tier 1 tech or qualified intern could go collect that data and enter it in the source of record. With each sync, data quality scores improve and so does your business.

Better data. Better insights. Better business.


Lifecycle Insights logo

Leave a Reply

Your email address will not be published. Required fields are marked *

Additional Posts