You could say data runs the world. Need to make a decision? What does the data say? Going to invest? What is the data telling you? Starting a new business? I have no idea where to find the data! Data helps to inform good decisions, but what happens when the data is not good?
How can data be bad?
Data is a set of quantitative and qualitative variables – it is facts. Facts inform via information, which is interpreted and evaluated to make decisions. That seems simple enough. So, how can facts be bad?
Bad data is data that is inaccurate, incomplete, inconsistent or duplicated information. It corrupts and disrupts. Bad data can be a part of the ignorance of the process, where data was not requested or was inconsistently gathered.
Scandals such as The Facebook Cambridge Analytica news story from a few years back, make people distrust your reasons for collecting data. In the situation with Cambridge Analytica, data was being collected without knowledge, clear recognition of what data was being collected and what it was being used for. This data was used for psychological profiling for targeted ads and messaging. Check out Tech Republic for a good analysis of the situation with the data.
CSO provide a good list of the biggest data breaches over the past 10 years. These are companies you may not have thought twice about giving data to yourself. These sites collect payments, ask for a range of data, and if you have used two or three of them and hackers get your information, they are filling in data gaps you may not even realise they have the ability to define.
What are the pitfalls of having bad data?
When you collect data, it should have some meaning to your deliverables. Why are you collecting this data? Where is the data going? Do you understand the system that is collating the data?
When we don’t know the answers to these questions, the risk of having bad data greatly increases. Let’s have a look at the pitfalls we might encounter when this happens.
Pitfall 1: You don’t acknowledge there is a problem
A head-in-the-sand approach does not work with data. You will keep gathering bad data and won’t be able to use it effectively. If a questionable decision was made that impacted data collection people may not want to admit it. People are human, it happens. Covering it up won’t help though, inevitably the truth comes out eventually. Besides, by owning our mistakes, we create the opportunity to improve.
Pitfall 2: You don’t fix it
You have some bad data. Hopefully, you’ve identified where the data issue has come from and know how to fix it. If you haven’t yet worked out where the bad data is coming from, find it and fix it!
If you don’t fix it, you’ll continue to collect bad data. Failure to fix it is just bad form and begs the question – why are you collecting the data in the first place? It can’t be useful if you won’t accept it needs to be fixed.
Pitfall 3: You don’t know how to fix it
This pitfall is an area that may not be entirely within your own control and may need external expertise. With the development of APIs and automations data is much easier to gather than ever before but you may not know what you’re collecting. Or you could be collecting information you do not need and should not collect.
Pitfall 4: You don’t secure your data because you don’t think its valuable
Data leaks should not happen, but they do. According to Security Magazine, a hacker attacks every 39 seconds. They do not care how bad your data is, just what they can get and how much. If you don’t take protection of your data seriously, it doesn’t matter how bad it is, you shouldn’t be collecting it.
If you collect banking information, how secure is the system you store your data? If you do not know, find out right now. More and more emails are being sent advising of hacks and data exploitation.
Any data you collect is valuable, never forget that. It’s valuable to the person who provided it to you. If you don’t collect the right data that’s your responsibility, not the person who gave it to you. If you are collecting dates of birth, be very clear on why. If you just thought that would be cool but you have no plan to use it? That’s a big red flag.
Every piece of data you collect from someone is valuable. Keep that in the back of your mind when you make decisions on what data you collect. If you don’t need it, don’t collect it.
What are the opportunities of making bad data useable?
Bad data doesn’t have to remain bad if you acknowledge, identify and take steps to become data aware. Any data you collect is valuable so with some thought and planning you can make your data work for you.
Opportunity 1: You’re being data aware
What is the best way to deal with bad data? Acknowledge the issue and take steps to rectify the problem. If you forgot to add an essential field to a form and have gaps in your data, add in the field and consider whether you need to go back to people and ask them to provide the data you are missing.
Being data aware is a big asset. If you don’t know what data you are collecting or what you’re doing with it right now? Ask questions and find out!
Opportunity 2: Get a CRM to help you manage your data effectively
By collecting data and copying and pasting it into an Excel sheet, you’re on entry-level data collection. If you’re using complex systems that are collecting the right information through automations and providing tailored reporting that analyses and guides you on how to use that data? Then you are a few rungs further up on the data collection ladder.
If you are a small or medium business you can be data smart by using a CRM or a data system to collect your data into, with a mechanism to understand and interpret it. A CRM, or customer relationship management tool is a great way of helping you manage your data effectively and minimise bad data issues.
You can determine what data is most useful to you and customise the CRM to your requirements. Smart tools like Zapier and Automate.io help you streamline how information gets into your CRM, and also how to get it back out again.
Opportunity 3: Data reporting can be a big asset if you let it
There is big money in data analysis because it’s an area that’s difficult to understand. And, to be very honest, you probably don’t need to know too much about how it works. It can also be a very expensive area to dip into. But, the value of getting good and useful data should be your goal.
Social media tools have some reporting functionality embedded so you can read what the data is telling you about who is looking at your profiles, pages and groups. CRMs will have some reporting as well but be aware many offer reporting as a premium or extra so know what reporting you will get out of any tool you use.
If you’re serious about your data, you may want to hire a specialist to help you understand and use your data to guide your decisions. They’ll be able to help you analyse and articulate what data you have, and also what you may not be collecting that could be of value.
