Prior to uploading any lists to your CRM or Database, you should be doing taking the following steps: De-duping your new list – there is nothing worst than creating duplicates. While, many CRMs and Database have automatic duplicate catchers by applying the email address, there are instances where this may not be the case. If…
When doing data cleaning, it is important to make sure you follow a few simple rules to make sure you not only minimize the risk of data cleansing but also maximize the effort. Here are the top ten rules to remember for your data cleansing project: Create a data cleaning plan – Before you start…
Perhaps the most important part of de-duping is not so much as identifying a duplicate but rather defining what a duplicate is. Each business can have a different definition for the records being duplicated, more so there are different scenarios where you may want to have duplicates for specific reason. So how does one define…
Migrating to a new CRM or marketing automation tool, can be a great way to add new capabilities or save on cost. The risk of migrating into a new system is the data. The quality of data, or lack thereof, is one of the main reasons for the failure of migration projects. Many companies not…
When de-duping duplicate contacts, email address is usually used a unique identifier. After all it is the easiest way to identify if there are duplicate contacts. However, today most tools do not allow for a duplicate email to be entered into the system, making it seem like you have no duplicate contacts. There are three…
The amount of data we produce each day is truly mind-boggling at 2.5 quintillion bytes at our current pace which is only set to increase with new developments in Internet of Things (IoT), quantum, edge and cloud computing. To put that into context, Google processes 40,000 searches every second with over 5 billion searches per…
Data standardization is the process of fixing data into a common format. Not all data can be standardized and it is different than data normalization, which focuses on the formatting of data rather than the actual data content. Below is what you need to know about data standardization. Example of Data Standardization: For example, your…
At a time where customers can communicate via several channels, the quality of the contact data a business holds is heavily important. Although some organizations are beginning a digital transformation journey (deploying processes online), there is still a reliance on offline activities such as call centers to deliver a superior customer service. More than three…
Part of data cleaning is de-duping. But before you can begin your de-duping process you need to define what a duplicate is. Duplicate definition is the most important part of any deduping process, and therefore it is usually step one. Here is what will happen if you do NOT define what makes a record a…
Deduplication is a method used to eliminate redundant copies of data from a database with the objective of reducing storage and cost whilst improving customer experience and loyalty. Something like 2.5 quintillion bytes of data are produced each day and that is only accelerating with the growth and buzz around Big Data and the Internet…