This is Anish's Typepad Profile.
Join Typepad and start following Anish's activity
Join Now!
Already a member? Sign In
Anish
Recent Activity
Image
In all my years looking at data, I’ve never found a CRM database without duplicates (I’m assuming a database of more than a few thousand records.) Many of the CRM systems have easy ways to identify duplicates, but duplicates still remain. So why is that? The main reason is that duplicates are far more complex than simply matching of names, emails, etc. Yes, you will match some obvious duplicates this way, but there are many more complex versions. CRM applications assume the data is correct in the first place, that the data is present and that the data is in... Continue reading
Posted Jul 19, 2017 at Acuate Data Quality
Image
How bad does someone’s data have to be before they realise that bad data just doesn’t work. Working with bad data gets bad results. You try and get away with it until it no longer works for you. You realise you cannot carry on. With no choice, you see that good data is the only way to be. As with so many things in life only when things go wrong do you change your attitude towards something…I’ve been there many times myself…it’s only human. So, let’s learn this lesson a little earlier, before things go really bad for your data.... Continue reading
Posted Jul 6, 2017 at Acuate Data Quality
Image
Acquiring current and accurate B2B data can be difficult from data suppliers. They tend to be good for senior positions, but problems arise if you want positions lower than this or you want contacts in niche segments. Whatever you’re looking for, currency will be a problem. Is the contact that you were supplied current? Some vendors have current data but many do not. To be honest, it’s not easy to keep B2B data current with job mobility at 11-15% per year, a lot of maintenance is required to keep a database current. It’s worth commissioning your own web research. The... Continue reading
Posted Jun 29, 2017 at Acuate Data Quality
Thank you Mish, very good point.
Thank you, Patrick.
Image
Recently I was asked to source some data for a client, and after engaging the main data suppliers, I chose a vendor I trusted. I’ve purchased data many times, so I wasn’t expecting this result. Well you can imagine I wasn’t too happy to find over 60% of the contacts supplied where no longer at their stated organisations. Now 60% is very high. With B2B data degrading at 10-22% per annum depending on which industry, I was expecting 1 in 10 or at worst case 1 in 5 contacts to be out of date (the latter case is what I... Continue reading
Posted Jun 8, 2017 at Acuate Data Quality
Image
In the last two blog posts we focused on these six reports: Seven Dimensions of Data Quality Data Quality Trends Duplicate Trends Company Level Capture Team or Departmental Level Capture Individual Level Capture If you didn’t get a chance to read Part 1 or Part 2, here are the links 9 Most Popular Data Quality Charts (Part 1) 9 Most Popular Data Quality Charts (Part 2) In today's post we look at three more important charts that all companies should look at, namely: Data Degradation Information Quality Profiling Data Degradation Chart I can't stress enough how important data degradation is.... Continue reading
Posted May 31, 2017 at Acuate Data Quality
Image
Last week we looked at three charts most often requested by clients, charts that are very useful in managing your business’ data quality. If you didn’t get a chance to read Part 1, here’s a link 9 Most Popular Data Quality Charts (Part 1) In this second of three posts, we look at a further three charts that are essential for managing your data. When speaking about data quality, most of us focus on what’s wrong with our data, but there is another more important measure, namely, what data are we missing. Having data with errors is annoying and a... Continue reading
Posted Feb 23, 2017 at Acuate Data Quality
Image
I don’t know about you, but when I receive a lengthy business report I always have a feeling of ‘oh no!’ I’ll admit it, I love looking at charts and diagrams…I feel I can see the right questions to ask immediately…what the chart shows and what the chart doesn’t show. I can then decide to read the report or seek answers elsewhere. When you’re busy, this has to be the best way to see information. “A picture is worth a thousand words” is never truer when analysing data quality results. In this first of 3 posts, I’m going to briefly... Continue reading
Posted Feb 2, 2017 at Acuate Data Quality
Image
My nephew’s thinking of a career in sales. While researching on the internet he came across the infamous sales movie Glengarry Glen Ross starring Al Pacino, Jack Lemmon and Alec Baldwin. For all sales people out there, this is just ones of those movies you watch, whether you agree with the contents or not, but for some young sales people, the testosterone driven environment is really encouraging. One of the most famous scenes is where Blake (Alec Baldwin) is sent from the parent company to motivate an underperforming sales team by unleashing a torrent of verbal abuse. In that scene... Continue reading
Posted Jan 26, 2017 at Acuate Data Quality
Image
When you fancy a particular meal, sometimes going to the right restaurant is what you need, but if you know it’s home cooked, then it’s likely to taste so much better. Well, that’s my feeling about creating a targeted data set. Buying is sometimes right, but often, building your own is so much better. Before I start on the pro and cons, I have to say, for some target markets there are some very good niche data suppliers out there, in which case buying is a no brainer. However, there are many companies that are just not happy with the... Continue reading
Posted Dec 8, 2016 at Acuate Data Quality
Image
I recently came across a lovely Telemarketing company with a compelling proposition of guaranteeing good quality appointments for his clients for a fixed price and the client would get to determine the quality, a good deal all round! So, here is someone delivering what they promised, but their results are dependent on two key factors: The message The data As an experienced marketer, one can control the quality of a message until it gets the conversion rates you require. However, this company relies on the client providing their data as basis for the telemarketing campaign. If the quality of the... Continue reading
Posted Nov 24, 2016 at Acuate Data Quality
Image
“There is real magic in enthusiasm. It spells the difference between mediocrity and accomplishment” – Norman Vincent Peale For me this quote sums up why some companies have good data and why others have poor data. It’s their enthusiasm about data. When you’re not so enthusiastic about your data, then it’s likely your data will be mediocre or of poor quality, but if you’re enthusiastic about data then I’ll bet you have good quality data. So here are 5 suggestions that will move you from mediocrity to excellence: Having an Evangelist If you may have the overall responsibility for your... Continue reading
Posted Nov 17, 2016 at Acuate Data Quality
Image
Have you been through that experience where you procrastinated or had a fear about something, only then to overcome it and think to yourself ‘that was a lot easier than I thought and what took me so long to overcome it’. You then realise it’s all in your head. So you may be wondering how one can have a fear of cleaning data…it’s only data after all, but no need to mock it…you’ll be surprised how often this happens. Fear happens when you see a threat from danger, pain or harm. In our context, it’s the pain that triggers this... Continue reading
Posted Oct 28, 2016 at Acuate Data Quality
Image
Do you remember the time when you decorated a room or a house, and after many days of toil you looked at the final product only to see bits of your new wall not painted, or the paint on the skirting has edged over to the wall, and so on, and you keep on spotting tiny errors here and there. You then go through the process of tidying this up, and if you’re like me, you’re wondering how you missed all this, I was always sure I worked thoroughly. We’ll, we are only humans, and we are going to miss... Continue reading
Posted Sep 23, 2016 at Acuate Data Quality
Image
This is got to be one of the most frustrating aspects of helping companies achieve exceptional data quality; it’s the CRM’s inability to import cleansed data easily. For the larger CRM systems the task of re-importing cleansed data is not too onerous, but merging duplicate data can be a real challenge. Now it’s understandable that merging two entities in a CRM application is complicated, here are two good reasons why: (a) Because of all the linked information. For example, an account may have contacts, opportunities, orders, activities, tasks, etc. attached to it, so all of these have to be merged... Continue reading
Posted Sep 15, 2016 at Acuate Data Quality
Image
So here’s my take on how the majority of companies (not all) see data quality (admittedly some do not see data quality at all, but that’s another blog post.) Many see data quality as a percentage game – 80% good data is good enough – and there is plenty of merit to warrant this approach, but as I’ll try and explain taking data quality from maybe a 80/20 game to 95/5 game or 99/1 game or even 100/0 game is doable and the upside significant. I can hear people screaming about 100/0 game but for some companies this is an... Continue reading
Posted Mar 23, 2016 at Acuate Data Quality
Image
Imagine you’re 16 years old, it’s the first day of your public exams, it feels a little scary and certainly you’re apprehensive. Your life’s path could be defined by these very results. Even writing this now gives me a sense of past nervousness, so I can’t imagine how it feels for today’s students. Now rewind to a few months earlier when you’re in the midst of creating a revision plan. If your revision plan consisted of a single method of learning for all your subjects, then the likelihood of you doing well in all your subjects is far less than... Continue reading
Posted Mar 16, 2016 at Acuate Data Quality
Image
‘It would be really, really nice if all our clients’ data were in a similar format and of similar quality, then we could write simple automated routines to create excellent levels of data quality and not have to work too much.’ We’ll, I can keep on dreaming all I want, but the harsh reality is that data comes in as many variations as there are clients. This is not that surprising as data has its own personality primarily driven by the characteristics of the company or people managing it. (See a previous post on Data Personality to explain why.) If... Continue reading
Posted Jan 26, 2016 at Acuate Data Quality
Image
A few years ago I came across a story about a data migration for a new CRM application that can be classified in the ‘Oops’ category. The company in question had a rather large CRM application being deployed over several sites and hundreds of users. The responsibility fell with the IT team to make it happen smoothly. The IT team had a good reputation for project implementation and undertook all the necessary steps for a successful roll-out, apart from this one mistake. On go-live day, the system worked flawlessly, all users were trained with additional video training available via the... Continue reading
Posted Jan 19, 2016 at Acuate Data Quality
Image
Data Matching is one of those beautiful techniques that rears its head across lots of different applications. It involves complicated algorithms and can be a science as well as an art. But it is surprising how many times these techniques are required in so many business applications. Before we list some of these applications, let’s quickly review what we mean by Data Matching. Trying not to be too technical…it’s the process of comparing 2 or more data sets to see if records from either of the data sets are the same or similar. A special case of data matching is... Continue reading
Posted Dec 2, 2015 at Acuate Data Quality
Image
Recently, I attended a sales meeting with someone who didn’t get data quality. For some reason the topic seemed too bothersome or just not relevant to them. In this case, it was relevant to this person because they were responsible for the company’s data quality; admittedly it was their primary responsibility. I was surprised to hear them say that formatting name information didn’t matter much as their mailings got to the right people. He had been cleaning addresses, so the mailings were being delivered to the correct destination, but he was taking a risk in the name not being correctly... Continue reading
Posted Jul 6, 2015 at Acuate Data Quality
Image
Every time I’m interested in a particular website, I have no hesitation to give them my email because in return I’m getting some information that I want. There’s a trade here, an email address for something I value. This process of trading something you value to capture a potential prospect’s details is the best way to capture contact details. An attractive offer must be created that has enough value to be traded. In some cases a whitepaper is sufficient, or a video or some free software. What the offer is, will depend on your business and the value perceived by... Continue reading
Posted Jun 26, 2015 at Acuate Data Quality
Image
Have you every procrastinated on a task, knowing that you should do it, but for some reason it’s doesn’t seem relevant, not exciting enough or just too difficult; you go through that crazy loop of saying you should do it and then you don’t, you should do it and then you don’t, and the cycle continues. Until all of a sudden the task becomes the most important task ever! Perhaps a deadline is approaching or there are big consequences if you don’t do it – now you are motivated to move and complete the task. We’ll this is how it... Continue reading
Posted Jun 19, 2015 at Acuate Data Quality
Image
I get a lot of requests to find emails for clients and at times it seems like there’s a mad rush, a bit like the California Gold Rush of 1848, where at first, loose gold and gold nuggets could be picked up off the ground. 300,000 people from all over the world rushed over a 7 year period to find their fortune. The rush for emails is not that spectacular, but it's certainly immense. So, why is it a gold rush, well gold was scarce and precious so had a great value as many desired it; with email addresses, it’s... Continue reading
Posted Jun 12, 2015 at Acuate Data Quality