{"id":756,"date":"2020-04-27T04:46:19","date_gmt":"2020-04-27T04:46:19","guid":{"rendered":"https:\/\/leadlists.com.au\/?p=756"},"modified":"2020-07-12T18:07:12","modified_gmt":"2020-07-13T01:07:12","slug":"what-is-data-cleaning","status":"publish","type":"post","link":"https:\/\/leadlistsdata.com\/blog\/what-is-data-cleaning\/","title":{"rendered":"What is Data Cleaning? Why Your Database Needs a Cleanse"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t

Modern-day business is driven by data and information – whether you are a multi-national corporation with thousands of employees or a local tradesman trying to grow your business into more local areas. The problem with all of this data is that it requires regular maintenance to stay accurate and useful to your company. Data scientists spend up to 60 per cent of their time cleansing data, which can sound quite intimidating to a business that doesn\u2019t even have a data scientist!<\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t

What is Data Cleaning?<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t

As you collect contacts and leads for your company and store sales data over time, errors and other issues will come up in those data sets. Data cleansing is the process of removing erroneous records and standardising misspellings. The goal is to eliminate problems that would muddy analysis or cause you to spend more money than you need to on marketing. To put this into perspective, here are a few examples.<\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t

Example 1<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t

Your dry cleaning business has an extensive database of previous clients. Every time a new company or person does business with you, one of your employees puts in their contact information into a spreadsheet or database. Over time, this list has become huge! However, as you look through it, you notice that there are duplicates with misspellings, and the street names aren\u2019t standardised. You work with data cleansing software to help you validate the addresses on file, remove duplicates, and make sure that all the contact information you have is correct. While doing this, you save yourself money on marketing that would have gone out to incorrect addresses.<\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t

Example 2<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t

Your eCommerce brand has been growing over the last few years! Your team has begun pulling in more and more data to base your business and marketing decisions on – but not all of it meets your standards. Some errors in the data mean that the last projections you sent to your leadership board looked a bit off. It turns out that some of the new data sources don\u2019t match the same way you calculate revenue, sales, and other performance indicators. Now your team has the monumental task of figuring out how to clean this data up so you can trust it again.<\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\tData cleansing, by a more technical definition, is the process of preparing information for use or analysis by removing incorrect information and formatting the remaining data in a way that it can adequately be used or analyzed accurately. Data cleaning goes beyond removing incorrect information and makes the data more complete and useable by standardizing data sets and enriching the data by completing missing fields. Data cleansing is a fundamental building block of data science – but don\u2019t let the name intimidate you. The process of scrubbing your data and preparing it for use is critical for every business. \t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t

Data Cleansing: The Why<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t

The number one reason you should be cleansing your data is that not doing it costs your company a ton of money<\/a>. The data-savvy in your company waste their time validating data. You make incorrect decisions based on bad data, and you spend money on marketing campaigns that could have smaller budgets if you had cleaned up your database before.<\/p>

On the other side of (your business) coin, cleaning up your data can be a hidden gold-mine of opportunity that you\u2019re already sitting on. Validating your data for your marketing database can uncover hidden opportunities, and can deliver better results for your marketing campaigns.\u00a0<\/p>

So to sum up and add a few more reasons, here is the \u201cwhy\u201d of data cleansing:<\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t
    \n\t\t\t\t\t\t\t
  • \n\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t<\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\tMake More Money:<\/strong> See higher revenue by taking advantage of your existing opportunities and reduce costs<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t
  • \n\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t<\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\tAccurate Insights and Forecasts: <\/strong> Know what is going to happen with your sales with better forecasting and see more opportunities in your data<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t
  • \n\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t<\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\tMore Efficiency: <\/strong> Save the time of your employees who handle data by taking the burden of correcting records off of them and open up more of their time for analysis. For smaller businesses, save time on any data-entry related tasks.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t

    How to Get Started: The Basics Of Data Cleansing\/ Data Scrubbing<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t
    \n\t\t\t\t

    Great! So you\u2019re sold on the idea that data cleansing is a critical part of modern businesses – so what are the basics? Every data cleansing project has necessary steps that can help outline where to get started.<\/p>

    Data quality can be broken down into a few categories to evaluate and improve the data sets:<\/p>

    Validity: <\/strong>Data validity can be described as \u201cis this data in the right format?\u201d If you have phone numbers in your database, they may need to follow a certain format to be easily used by any of your calling systems. If a phone number is incomplete or is missing an area code, for example, that entry isn\u2019t valid and needs to be corrected.<\/p>

    Accuracy: <\/strong>A phone number or an address might follow a valid pattern, but it could be a fake number. Accuracy is the next critical step in evaluating data. You need to make sure that the information you have matches reality as close as possible. Data cleansing databases and software can be an excellent way to evaluate the accuracy and validity of your data by matching it with known public databases.<\/p>

    Completeness: <\/strong>Filling in the blanks is another way to cleanse your data. By finding records that are incomplete and enriching the data, you can fill in any holes you may have in your current opportunities.<\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

    \n\t\t\t\t\t\t
    \n\t\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t

    The Steps Of Data Cleansing<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t
    \n\t\t\t\t

    Data cleansing is an ongoing process; whether you use an experienced company like Lead Lists or are taking it in-house, you will find that having a standardised process will lighten the load of your employees and give you access to more and more quality information.<\/p>

    Some tips on getting the most out of your data:<\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

    \n\t\t\t\t
    \n\t\t\t\t\t
      \n\t\t\t\t\t\t\t
    • \n\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t<\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\tUse standardized formats:<\/strong> For dates, names, and addresses begin using standardized formats that can easily be recognized and kept up to date.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t
    • \n\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t<\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\tReporting: <\/strong> Report on the errors that have been improved and how your database is changing over time. <\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t
    • \n\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t<\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\tMatch Your Data To Outside Databases: <\/strong> Use external databases for public and business records to validate your customer data and addresses - especially before launching a new marketing campaign! <\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
      \n\t\t\t\t\t\t
      \n\t\t\t\t\t\t\t
      \n\t\t\t\t\t
      \n\t\t\t
      \n\t\t\t\t\t\t\t
      \n\t\t\t\t\t\t
      \n\t\t\t\t
      \n\t\t\t

      How Long Will Data Cleansing Take?<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
      \n\t\t\t\t
      \n\t\t\t\t\t\t\t\t
      \n\t\t\t\t

      Data cleansing is an ongoing process that you should continue to maintain frequently. The amount of data you currently have, the resources internally and externally at your disposal, and the current quality of your data will indicate how long your project will take.<\/p>

      A quick customer contact cleanup can take as little as a week if you are using an external tool to validate your records. If you have massive databases with mixed formats of data coming in from multiple sources, a data cleansing project can take much longer and will continue to be part of your company\u2019s workload.<\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

      \n\t\t\t\t\t\t
      \n\t\t\t\t\t\t\t
      \n\t\t\t\t\t
      \n\t\t\t
      \n\t\t\t\t\t\t\t
      \n\t\t\t\t\t\t
      \n\t\t\t\t
      \n\t\t\t

      Data Cleansing - A Conclusion<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
      \n\t\t\t\t
      \n\t\t\t\t\t\t\t\t
      \n\t\t\t\t

      Data scrubbing is an essential part of your business. Having up-to-date, accurate data will save your company money and help your analysts spend their time on insights instead of fixing records.<\/p>\n

      To learn more about how we can help you get the data your company needs, contact us today.<\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"

      Modern-day business is driven by data and information – whether you are a multi-national corporation with thousands of employees or a local tradesman trying to grow your business into more local areas. The problem with all of this data is that it requires regular maintenance to stay accurate and useful to your company. Data scientists […]<\/p>\n","protected":false},"author":4,"featured_media":773,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}}},"categories":[8],"tags":[],"yoast_head":"\nWhat is Data Cleaning? Why Your Database Needs a Cleanse | Lead Lists<\/title>\n<meta name=\"description\" content=\"Data requires regular cleaning to stay accurate and useful to your company. Data cleaning cleanses your database of outdated and inaccurate information.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/leadlists.com.au\/blog\/what-is-data-cleaning\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is Data Cleaning? Why Your Database Needs a Cleanse | Lead Lists\" \/>\n<meta property=\"og:description\" content=\"Data requires regular cleaning to stay accurate and useful to your company. Data cleaning cleanses your database of outdated and inaccurate information.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/leadlists.com.au\/blog\/what-is-data-cleaning\/\" \/>\n<meta property=\"og:site_name\" content=\"Lead Lists\" \/>\n<meta property=\"article:published_time\" content=\"2020-04-27T04:46:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-07-13T01:07:12+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/wordpress-536652-1753232.cloudwaysapps.com\/wp-content\/uploads\/2020\/04\/data-cleaning-robot-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"622\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Chris Cox\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/leadlistsdata.com\/#organization\",\"name\":\"Lead Lists\",\"url\":\"https:\/\/leadlistsdata.com\/\",\"sameAs\":[],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/leadlistsdata.com\/#logo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/leadlistsdata.com\/wp-content\/uploads\/2019\/05\/lead-lists-logo-light.png\",\"contentUrl\":\"https:\/\/leadlistsdata.com\/wp-content\/uploads\/2019\/05\/lead-lists-logo-light.png\",\"width\":400,\"height\":165,\"caption\":\"Lead Lists\"},\"image\":{\"@id\":\"https:\/\/leadlistsdata.com\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/leadlistsdata.com\/#website\",\"url\":\"https:\/\/leadlistsdata.com\/\",\"name\":\"Lead Lists\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/leadlistsdata.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/leadlistsdata.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/leadlists.com.au\/blog\/what-is-data-cleaning\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/leadlistsdata.com\/wp-content\/uploads\/2020\/04\/data-cleaning-robot-1.jpg\",\"contentUrl\":\"https:\/\/leadlistsdata.com\/wp-content\/uploads\/2020\/04\/data-cleaning-robot-1.jpg\",\"width\":1000,\"height\":622,\"caption\":\"Data cleaning robot\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/leadlists.com.au\/blog\/what-is-data-cleaning\/#webpage\",\"url\":\"https:\/\/leadlists.com.au\/blog\/what-is-data-cleaning\/\",\"name\":\"What is Data Cleaning? Why Your Database Needs a Cleanse | Lead Lists\",\"isPartOf\":{\"@id\":\"https:\/\/leadlistsdata.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/leadlists.com.au\/blog\/what-is-data-cleaning\/#primaryimage\"},\"datePublished\":\"2020-04-27T04:46:19+00:00\",\"dateModified\":\"2020-07-13T01:07:12+00:00\",\"description\":\"Data requires regular cleaning to stay accurate and useful to your company. Data cleaning cleanses your database of outdated and inaccurate information.\",\"breadcrumb\":{\"@id\":\"https:\/\/leadlists.com.au\/blog\/what-is-data-cleaning\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/leadlists.com.au\/blog\/what-is-data-cleaning\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/leadlists.com.au\/blog\/what-is-data-cleaning\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/leadlistsdata.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What is Data Cleaning? Why Your Database Needs a Cleanse\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/leadlists.com.au\/blog\/what-is-data-cleaning\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/leadlists.com.au\/blog\/what-is-data-cleaning\/#webpage\"},\"author\":{\"@id\":\"https:\/\/leadlistsdata.com\/#\/schema\/person\/0f7b7196a66e5297ffa5c951b62d566c\"},\"headline\":\"What is Data Cleaning? Why Your Database Needs a Cleanse\",\"datePublished\":\"2020-04-27T04:46:19+00:00\",\"dateModified\":\"2020-07-13T01:07:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/leadlists.com.au\/blog\/what-is-data-cleaning\/#webpage\"},\"wordCount\":1210,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/leadlistsdata.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/leadlists.com.au\/blog\/what-is-data-cleaning\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/leadlistsdata.com\/wp-content\/uploads\/2020\/04\/data-cleaning-robot-1.jpg\",\"articleSection\":[\"Data Cleaning\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/leadlists.com.au\/blog\/what-is-data-cleaning\/#respond\"]}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/leadlistsdata.com\/#\/schema\/person\/0f7b7196a66e5297ffa5c951b62d566c\",\"name\":\"Chris Cox\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/leadlistsdata.com\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/67fcb07b871ff59db2edc46909667f73?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/67fcb07b871ff59db2edc46909667f73?s=96&d=mm&r=g\",\"caption\":\"Chris Cox\"},\"description\":\"Chris Cox is the Managing Director at Lead Lists and has over 10 years in Lead Generation.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/christo111\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What is Data Cleaning? Why Your Database Needs a Cleanse | Lead Lists","description":"Data requires regular cleaning to stay accurate and useful to your company. Data cleaning cleanses your database of outdated and inaccurate information.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/leadlists.com.au\/blog\/what-is-data-cleaning\/","og_locale":"en_US","og_type":"article","og_title":"What is Data Cleaning? Why Your Database Needs a Cleanse | Lead Lists","og_description":"Data requires regular cleaning to stay accurate and useful to your company. Data cleaning cleanses your database of outdated and inaccurate information.","og_url":"https:\/\/leadlists.com.au\/blog\/what-is-data-cleaning\/","og_site_name":"Lead Lists","article_published_time":"2020-04-27T04:46:19+00:00","article_modified_time":"2020-07-13T01:07:12+00:00","og_image":[{"width":1000,"height":622,"url":"http:\/\/wordpress-536652-1753232.cloudwaysapps.com\/wp-content\/uploads\/2020\/04\/data-cleaning-robot-1.jpg","path":"\/home\/leadlist\/domains\/leadlistsdata.com\/public_html\/wp-content\/uploads\/2020\/04\/data-cleaning-robot-1.jpg","size":"full","id":773,"alt":"Data cleaning robot","pixels":622000,"type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Written by":"Chris Cox","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/leadlistsdata.com\/#organization","name":"Lead Lists","url":"https:\/\/leadlistsdata.com\/","sameAs":[],"logo":{"@type":"ImageObject","@id":"https:\/\/leadlistsdata.com\/#logo","inLanguage":"en-US","url":"https:\/\/leadlistsdata.com\/wp-content\/uploads\/2019\/05\/lead-lists-logo-light.png","contentUrl":"https:\/\/leadlistsdata.com\/wp-content\/uploads\/2019\/05\/lead-lists-logo-light.png","width":400,"height":165,"caption":"Lead Lists"},"image":{"@id":"https:\/\/leadlistsdata.com\/#logo"}},{"@type":"WebSite","@id":"https:\/\/leadlistsdata.com\/#website","url":"https:\/\/leadlistsdata.com\/","name":"Lead Lists","description":"","publisher":{"@id":"https:\/\/leadlistsdata.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/leadlistsdata.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"ImageObject","@id":"https:\/\/leadlists.com.au\/blog\/what-is-data-cleaning\/#primaryimage","inLanguage":"en-US","url":"https:\/\/leadlistsdata.com\/wp-content\/uploads\/2020\/04\/data-cleaning-robot-1.jpg","contentUrl":"https:\/\/leadlistsdata.com\/wp-content\/uploads\/2020\/04\/data-cleaning-robot-1.jpg","width":1000,"height":622,"caption":"Data cleaning robot"},{"@type":"WebPage","@id":"https:\/\/leadlists.com.au\/blog\/what-is-data-cleaning\/#webpage","url":"https:\/\/leadlists.com.au\/blog\/what-is-data-cleaning\/","name":"What is Data Cleaning? Why Your Database Needs a Cleanse | Lead Lists","isPartOf":{"@id":"https:\/\/leadlistsdata.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/leadlists.com.au\/blog\/what-is-data-cleaning\/#primaryimage"},"datePublished":"2020-04-27T04:46:19+00:00","dateModified":"2020-07-13T01:07:12+00:00","description":"Data requires regular cleaning to stay accurate and useful to your company. Data cleaning cleanses your database of outdated and inaccurate information.","breadcrumb":{"@id":"https:\/\/leadlists.com.au\/blog\/what-is-data-cleaning\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/leadlists.com.au\/blog\/what-is-data-cleaning\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/leadlists.com.au\/blog\/what-is-data-cleaning\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/leadlistsdata.com\/"},{"@type":"ListItem","position":2,"name":"What is Data Cleaning? Why Your Database Needs a Cleanse"}]},{"@type":"Article","@id":"https:\/\/leadlists.com.au\/blog\/what-is-data-cleaning\/#article","isPartOf":{"@id":"https:\/\/leadlists.com.au\/blog\/what-is-data-cleaning\/#webpage"},"author":{"@id":"https:\/\/leadlistsdata.com\/#\/schema\/person\/0f7b7196a66e5297ffa5c951b62d566c"},"headline":"What is Data Cleaning? Why Your Database Needs a Cleanse","datePublished":"2020-04-27T04:46:19+00:00","dateModified":"2020-07-13T01:07:12+00:00","mainEntityOfPage":{"@id":"https:\/\/leadlists.com.au\/blog\/what-is-data-cleaning\/#webpage"},"wordCount":1210,"commentCount":0,"publisher":{"@id":"https:\/\/leadlistsdata.com\/#organization"},"image":{"@id":"https:\/\/leadlists.com.au\/blog\/what-is-data-cleaning\/#primaryimage"},"thumbnailUrl":"https:\/\/leadlistsdata.com\/wp-content\/uploads\/2020\/04\/data-cleaning-robot-1.jpg","articleSection":["Data Cleaning"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/leadlists.com.au\/blog\/what-is-data-cleaning\/#respond"]}]},{"@type":"Person","@id":"https:\/\/leadlistsdata.com\/#\/schema\/person\/0f7b7196a66e5297ffa5c951b62d566c","name":"Chris Cox","image":{"@type":"ImageObject","@id":"https:\/\/leadlistsdata.com\/#personlogo","inLanguage":"en-US","url":"https:\/\/secure.gravatar.com\/avatar\/67fcb07b871ff59db2edc46909667f73?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/67fcb07b871ff59db2edc46909667f73?s=96&d=mm&r=g","caption":"Chris Cox"},"description":"Chris Cox is the Managing Director at Lead Lists and has over 10 years in Lead Generation.","sameAs":["https:\/\/www.linkedin.com\/in\/christo111\/"]}]}},"_links":{"self":[{"href":"https:\/\/leadlistsdata.com\/wp-json\/wp\/v2\/posts\/756"}],"collection":[{"href":"https:\/\/leadlistsdata.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/leadlistsdata.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/leadlistsdata.com\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/leadlistsdata.com\/wp-json\/wp\/v2\/comments?post=756"}],"version-history":[{"count":0,"href":"https:\/\/leadlistsdata.com\/wp-json\/wp\/v2\/posts\/756\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/leadlistsdata.com\/wp-json\/wp\/v2\/media\/773"}],"wp:attachment":[{"href":"https:\/\/leadlistsdata.com\/wp-json\/wp\/v2\/media?parent=756"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/leadlistsdata.com\/wp-json\/wp\/v2\/categories?post=756"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/leadlistsdata.com\/wp-json\/wp\/v2\/tags?post=756"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}