{"id":38053,"date":"2019-04-13T14:55:48","date_gmt":"2019-04-13T14:55:48","guid":{"rendered":""},"modified":"2023-05-12T14:27:36","modified_gmt":"2023-05-12T14:27:36","slug":"clean-customer-database","status":"publish","type":"post","link":"https:\/\/salesdorado.com\/en\/crm\/clean-customer-database\/","title":{"rendered":"The Complete Guide To Cleaning Up Your Customer Database"},"content":{"rendered":"<p>The quality of your customer base is deteriorating, you know you need to clean it up, but you haven&#8217;t done it yet? Or have you inherited a poorly maintained customer base? You don&#8217;t know where to start, how to proceed, what tools to use, what action plan to put in place?<\/p>\n<p>In this comprehensive guide, we will detail how to successfully clean up your customer base.<\/p>\n<h1>What are the problems with your customer base?<\/h1>\n<p>If you do not clean up your customer base, its quality will necessarily deteriorate. Customer data is a living thing, it has a life cycle and deteriorates over time. You cannot have good performance with your marketing and CRM actions if you work on a poor quality customer base: the quality of your campaigns, the actions of your sales people and your customer service depend on it. Cleaning up your customer database &#8211; and let&#8217;s be clear: regularly &#8211; is therefore a major issue. Customer data cleansing is at the heart of any <a href=\"https:\/\/salesdorado.com\/en\/crm\/data-quality-definition\/\" data-internallinksmanager029f6b8e52c=\"61\" title=\"Data Quality\">Data Quality<\/a> Management strategy.<\/p>\n<p class=\"blocIntro\">Read our <a href=\"https:\/\/salesdorado.com\/en\/crm\/data-quality-definition\/\">comprehensive guide to data quality<\/a>.<\/p>\n<p>What is a poor quality customer base? It is a database that contains the following elements<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_83 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Sommaire<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/salesdorado.com\/en\/crm\/clean-customer-database\/#duplicates\" >Duplicates<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/salesdorado.com\/en\/crm\/clean-customer-database\/#incorrect-data\" >Incorrect data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/salesdorado.com\/en\/crm\/clean-customer-database\/#incomplete-data\" >Incomplete data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/salesdorado.com\/en\/crm\/clean-customer-database\/#non-standard-data\" >Non-standard data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/salesdorado.com\/en\/crm\/clean-customer-database\/#obsolete-data\" >Obsolete data<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/salesdorado.com\/en\/crm\/clean-customer-database\/#how-do-you-go-about-cleaning-up-your-customer-base\" >How do you go about cleaning up your customer base?<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/salesdorado.com\/en\/crm\/clean-customer-database\/#define-an-action-plan\" >Define an action plan<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/salesdorado.com\/en\/crm\/clean-customer-database\/#what-solutions-service-providers-can-help-me-clean-up-my-customer-base\" >What solutions \/ service providers can help me clean up my customer base?<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"duplicates\"><\/span><span class=\"ez-toc-section\" id=\"duplicates\"><\/span>Duplicates<span class=\"ez-toc-section-end\"><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>A duplicate refers to a customer or contact who is found several times (at least twice) in a customer\/contact database. Why do duplicates exist? There are several possible reasons:<\/p>\n<ul class=\"listFont iconChevron listLeft\">\n<li>Syntactic &#8211; spelling differences, often related to human errors in data entry or lack of standardisation (FirstnameLastname Vs LastnameFirstname Vs Lastname, etc.)<\/li>\n<li>The fact that services\/sources do not always use the same identifier. For customer service it is the account number, for marketing it is the email, etc. This makes it difficult to reconcile data (in the absence of a unique identifier acting as a reconciliation key).<\/li>\n<li>The fact that the same customer may give different information from one collection source to another. For example, using email A to fill in the form and giving email B to customer service. If the email is the reconciliation key, duplicates are created.<\/li>\n<\/ul>\n<p>In the presence of duplicates, the source contact (the reference data) must be identified and the data merged, taking care not to merge separate contacts incorrectly, which can be a tricky exercise.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"incorrect-data\"><\/span><span class=\"ez-toc-section\" id=\"incorrect-data\"><\/span>Incorrect data<span class=\"ez-toc-section-end\"><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>This applies in particular to email. For example: the contact has mistyped his or her email address in the form or has misspelled it to the customer service advisor: we are dealing with incorrect data. Surname, first name, title, date of birth, city, telephone number, etc. All data can be subject to input errors.<\/p>\n<p>Data entry errors are the main reason for the existence of erroneous data. Another reason is related to problems of format incompatibility between the collection source and the database. For example, the transformation of G\u00e9rard into G\u00c3\u00a9rard.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"incomplete-data\"><\/span><span class=\"ez-toc-section\" id=\"incomplete-data\"><\/span>Incomplete data<span class=\"ez-toc-section-end\"><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Databases often contain uncompleted fields. Some databases look like Swiss cheese, with a significant proportion (sometimes a majority) of the fields being empty.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"non-standard-data\"><\/span><span class=\"ez-toc-section\" id=\"non-standard-data\"><\/span>Non-standard data<span class=\"ez-toc-section-end\"><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>You have to choose between &#8220;bd.&#8221; and &#8220;boulevard&#8221;. Between &#8220;75&#8221; and &#8220;Paris&#8221;, you have to choose. Between Mr. and Mr., you must choose. A given piece of information (age, title, postal address, etc.) must be presented in the same way for all contacts. In technical language: the data must be correctly formatted. Again, it is the existence of a plurality of collection sources that is the main cause of non-standard data.<\/p>\n<p class=\"blocIntro\">See our <a href=\"https:\/\/salesdorado.com\/en\/outbound-sales\/rnvp-software-comparison\/\">comparison of RNVP processing software<\/a>.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"obsolete-data\"><\/span><span class=\"ez-toc-section\" id=\"obsolete-data\"><\/span>Obsolete data<span class=\"ez-toc-section-end\"><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>As we said earlier, customer data is a living thing. Some data that was true at time t becomes false at time t. People move, change their phone number, change jobs, etc. Most data is perishable, even if there is a change in the data. Most data is perishable, even if there are some exceptions: first name, title, etc.<\/p>\n<p>Data obsolescence is particularly important in B2B.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"how-do-you-go-about-cleaning-up-your-customer-base\"><\/span><span class=\"ez-toc-section\" id=\"how-do-you-go-about-cleaning-up-your-customer-base\"><\/span>How do you go about cleaning up your customer base?<span class=\"ez-toc-section-end\"><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>We are now going to give you some advice on how to successfully clean up your data. We will first look at how to define an action plan before presenting you with some tools\/solutions.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"define-an-action-plan\"><\/span><span class=\"ez-toc-section\" id=\"define-an-action-plan\"><\/span>Define an action plan<span class=\"ez-toc-section-end\"><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>You don&#8217;t just jump into a customer database cleaning project. Before you even start and carry out the main stages of the action plan, you must clearly identify the objectives of your database and its use cases. These objectives and use cases will serve as reference points when it comes to making decisions. Agree on what you mean by customer and choose a unique key for identifying contacts\/customers: email, customer account number, etc. You can use a key built on the combination of several fields, for example email + name. Here are the different steps we recommend you follow to clean up your customer database.<\/p>\n<p class=\"blocIntro\">Discover our <a href=\"https:\/\/salesdorado.com\/en\/automation\/enrichment-email-uses-operation\/\">complete guide to email enrichment (use cases and how it works)<\/a>.<\/p>\n<h4>Step #1 &#8211; Involve all users of the customer base<\/h4>\n<p>Marketing, Sales, Legal, Accounting, Customer Service: involve all the people who use or will use the customer base. This will allow :<\/p>\n<ul class=\"listFont iconChevron listLeft\">\n<li>To raise awareness of the importance of maintaining the quality of the customer base among all those who handle it.<\/li>\n<li>To listen to the expectations of those who use the database on a daily basis, to formulate target use cases.<\/li>\n<li>Identify the fields they need and, conversely, those that exist in the current database but have no use.<\/li>\n<\/ul>\n<h4>Step #2 &#8211; Make a copy of the client base<\/h4>\n<p>To ensure that you can go back if you make a wrong decision or have any problems during the cleaning process, make a copy of the client base. This is a safety measure.<\/p>\n<h4>Step #3 &#8211; Rethink the fields in your customer base<\/h4>\n<p>You need to remove data fields that serve no purpose, that are of no use to your marketing team, your sales people, your customer service. There is absolutely no point in maintaining fields that will never be filled in by end users.<\/p>\n<p>Conversely, add fields that are not currently used but which have real added value and will help you to achieve your objectives or to set up new use cases.<\/p>\n<h4>Step #4 Delete inactive contacts<\/h4>\n<p>Customers or contacts that have been inactive for a long period of time should be considered as lost contacts and therefore removed from the database. You can try to reactivate them if you think they are recoverable contacts\/customers, but in any case, a customer base should contain a minimum proportion of inactive customers.<\/p>\n<p>It is sufficient to analyse the date of the last interaction (purchase, telephone contact, web visit, etc.) to identify the inactive.<\/p>\n<h4>Step #5 &#8211; Deal with erroneous data<\/h4>\n<p>Your customer base certainly contains erroneous data. We advise you to correct the data when possible, using data quality tools (we will introduce you to some in a moment). When an erroneous data is impossible to update, delete it.<\/p>\n<h4>Step #6 &#8211; Use the reconciliation key to identify and remove duplicates<\/h4>\n<p>Have you decided to use email as an identification key? Apply this key to your database to identify duplicates, i.e. fields that are filled in several times. Then define a prioritisation rule to define, in case of duplicates, which data to keep. For example, you may decide to prioritise data from source A over data from other sources when there is a data conflict. Once you have defined your prioritisation rule, merge the duplicate records.<\/p>\n<p>Note that some CRMs offer duplicate identification systems and alert users when a duplicate is generated. All the tools we are going to present to you shortly offer <a href=\"https:\/\/salesdorado.com\/en\/crm\/deduplication-deduplication-of-customer-data\/\" data-internallinksmanager029f6b8e52c=\"59\" title=\"Deduplication B2B file\">deduplication<\/a> modules.<\/p>\n<h4>Step #7 Standardize the fields in the customer database<\/h4>\n<p>Postal code, title, telephone number, age: all the fields must be standardised to ensure the uniformity of your database. This means setting up the right parameters in your collection tools\/sources (so that these tools\/sources upload data in the right form to the customer database) and writing the naming rules for users who enter data manually.<\/p>\n<h4>Step #8 Enrich your customer base<\/h4>\n<p>We recommend that you enrich your customer base by filling in as many empty fields as possible&#8230;so that your customer base no longer looks like a Swiss cheese. How to proceed? There are several possibilities:<\/p>\n<ul class=\"listFont iconChevron listLeft\">\n<li>Interview your customers by creating questionnaire campaigns.<\/li>\n<li>Import data from your other databases &amp; tools.<\/li>\n<li>Use data enrichment tools \/ data providers.<\/li>\n<\/ul>\n<p>Here are two bonus tips for cleaning up your customer base:<\/p>\n<ul class=\"listFont iconChevron listLeft\">\n<li>If you are cleaning up a lead base, remove any odd or obviously non-serious email addresses such as &#8220;<span class=\"__cf_email__\" data-cfemail=\"462c3521212c22373522373506212b272f2a6825292b\">[email&#160;protected]<\/span>&#8220;, &#8220;<span class=\"__cf_email__\" data-cfemail=\"91f3fdf0f3fdf0f3fdf0f3fdf0d1f9fee5fcf0f8fdbff2fefc\">[email&#160;protected]<\/span>&#8220;, etc. These are fake leads (typically people who have created an address to download resources for free without giving their real email address). These are fake leads (typically people who have created an address to download resources for free without giving their real email address).<\/li>\n<li>Analyse the performance of your marketing campaigns (especially your emailing campaigns) to identify erroneous email addresses as well as individuals who are inactive or no longer wish to receive your communications (opt-out, spamming, etc.).<\/li>\n<\/ul>\n<p>We are now going to present you 4 tools \/ solutions \/ providers to help you in the cleaning of your customer base.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"what-solutions-service-providers-can-help-me-clean-up-my-customer-base\"><\/span><span class=\"ez-toc-section\" id=\"what-solutions-service-providers-can-help-me-clean-up-my-customer-base\"><\/span>What solutions \/ service providers can help me clean up my customer base?<span class=\"ez-toc-section-end\"><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>We have selected 4 tools for you: Octolis, DQE Software, Winpure and Amabis.<\/p>\n<h4>Octolis<\/h4>\n<div class=\"wp-block-image\"><img decoding=\"async\" src=\"\/wp-content\/uploads\/2019\/04\/customer-data-platform-octolis.png\" \/><\/div>\n<p>Octolis is a lightweight Customer Data Platform designed to connect your different data sources, prepare your data for business use cases and synchronise the prepared data (segments, scores, aggregates) in your Sales and Marketing tools. Octolis offers advanced features to cleanse, de-duplicate, merge, unify, enrich, score and segment customer data.<\/p>\n<p>One of the great advantages of Octolis lies in its very broad functional coverage. More than a Data Quality tool, Octolis is a new generation Customer Data Platform, independent of your database, over which you retain full control.<\/p>\n<p class=\"blocIntro\">Discover .<\/p>\n<h4>DQE Software<\/h4>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"\/wp-content\/uploads\/2019\/04\/outil-deduplication-exemple-dqe-software-1024x446.png\" \/><\/figure>\n<\/div>\n<p><a href=\"https:\/\/www.dqe-software.com\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\" (opens in a new tab)\">DQE Software<\/a> is a software company specialising in data quality. The company, founded in 2008, offers several tools to verify and normalise postal addresses, email addresses, telephone numbers, gender, city, etc. DQE has also developed the &#8220;DQE DEDUP&#8221; product to deduplicate and deduplicate your customer databases. All software is available in licence mode or in SaaS mode (cloud). DQE is a fast-growing player in the data quality market.<\/p>\n<h4>Winpure<\/h4>\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"\/wp-content\/uploads\/2019\/04\/winpure-nettoyage-base-client-1024x533.png\" \/><\/figure>\n<p><a href=\"https:\/\/winpure.com\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Winpure (opens in a new tab)\">Winpure<\/a> is one of, if not the most popular data cleaning tool on the market (worldwide). It allows to automate a large part of the cleaning operations: deduplication \/ deduplication, rectification of erroneous data, data normalisation, email\/phone verification, etc.<\/p>\n<p>Winpure can be used to clean up your CRM, Excel spreadsheets or SLQ Server, Access or Dbase databases. It also handles text files (.txt). Winpure also offers an API. It is a relatively affordable solution.<\/p>\n<h4>Or providers such as Amabis<\/h4>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"\/wp-content\/uploads\/2019\/04\/outil-deduplication-exemple-amabis-1024x484.png\" \/><\/figure>\n<\/div>\n<p>Launched in 1996, <a href=\"https:\/\/www.amabis.com\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Amabis (opens in a new tab)\">Amabis<\/a> is a service provider and software publisher specialising in data quality and CRM\/Marketing database management. From postal standardisation and deduplication to email\/phone validation, Amabis offers a range of high quality solutions to help you clean up your customer base and, more broadly, your data quality strategy. All Amabis tools are available in license or SaaS mode.<\/p>\n<p>Amabis also offers operational support services. Note that Amabis offers a CRM (AmaCRM, targeting SMEs) with native data quality management.<\/p>\n<p class=\"blocIntro\">For more tools, check out our <a href=\"https:\/\/salesdorado.com\/en\/automation\/tools-check-email-lists\/\">Top 10 email list cleaning tools<\/a>.<\/p>\n<p>We are coming to the end of this article. We hope you have found it useful. Would you like to receive advice on your data quality approach or the choice of tools\/solutions? Do not hesitate to contact us! We will be happy to discuss your issues.<\/p>\n<div style=\"display: none;\"\n    class=\"kk-star-ratings kksr-valign-bottom kksr-align-center \"\n    data-id=\"38053\"\n    data-slug=\"\">\n    <div class=\"kksr-stars\">\n    <div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\">\n            <div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\">\n            <div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\">\n            <div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\">\n            <div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\">\n            <div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    <div class=\"kksr-stars-active\" style=\"width: 0px;\">\n            <div class=\"kksr-star\">\n            <div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\">\n            <div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\">\n            <div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\">\n            <div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\">\n            <div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n    <div class=\"kksr-legend\">\n            <span class=\"kksr-muted\">Qu'avez-vous pens\u00e9 de cet article?<\/span>\n    <\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>The quality of your customer base is deteriorating, you know you need to clean it [&hellip;]<\/p>\n","protected":false},"author":46,"featured_media":2526,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[231,303],"tags":[312],"class_list":["post-38053","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-crm","category-sales-strategy","tag-guides"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>The Complete Guide To Cleaning Up Your Customer Database | Salesdorado<\/title>\n<meta name=\"description\" content=\"Do you know that you have to clean your customer database, but you don&#039;t know where to start? this guide is made for you\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/salesdorado.com\/en\/crm\/clean-customer-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The Complete Guide To Cleaning Up Your Customer Database | Salesdorado\" \/>\n<meta property=\"og:description\" content=\"Do you know that you have to clean your customer database, but you don&#039;t know where to start? this guide is made for you\" \/>\n<meta property=\"og:url\" content=\"https:\/\/salesdorado.com\/en\/crm\/clean-customer-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Salesdorado\" \/>\n<meta property=\"article:published_time\" content=\"2019-04-13T14:55:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-12T14:27:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/salesdorado.com\/wp-content\/uploads\/2019\/04\/nettoyer-bdd-clients.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1440\" \/>\n\t<meta property=\"og:image:height\" content=\"810\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Yassine Hamou Tahra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Yassine Hamou Tahra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"The Complete Guide To Cleaning Up Your Customer Database | Salesdorado","description":"Do you know that you have to clean your customer database, but you don't know where to start? this guide is made for you","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:\/\/salesdorado.com\/en\/crm\/clean-customer-database\/","og_locale":"en_US","og_type":"article","og_title":"The Complete Guide To Cleaning Up Your Customer Database | Salesdorado","og_description":"Do you know that you have to clean your customer database, but you don't know where to start? this guide is made for you","og_url":"https:\/\/salesdorado.com\/en\/crm\/clean-customer-database\/","og_site_name":"Salesdorado","article_published_time":"2019-04-13T14:55:48+00:00","article_modified_time":"2023-05-12T14:27:36+00:00","og_image":[{"width":1440,"height":810,"url":"https:\/\/salesdorado.com\/wp-content\/uploads\/2019\/04\/nettoyer-bdd-clients.jpg","type":"image\/jpeg"}],"author":"Yassine Hamou Tahra","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Yassine Hamou Tahra","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/salesdorado.com\/en\/crm\/clean-customer-database\/#article","isPartOf":{"@id":"https:\/\/salesdorado.com\/en\/crm\/clean-customer-database\/"},"author":{"name":"Yassine Hamou Tahra","@id":"https:\/\/salesdorado.com\/en\/#\/schema\/person\/ed9c1cde25eaf45b5be26c723edebebf"},"headline":"The Complete Guide To Cleaning Up Your Customer Database","datePublished":"2019-04-13T14:55:48+00:00","dateModified":"2023-05-12T14:27:36+00:00","mainEntityOfPage":{"@id":"https:\/\/salesdorado.com\/en\/crm\/clean-customer-database\/"},"wordCount":1920,"commentCount":0,"publisher":{"@id":"https:\/\/salesdorado.com\/en\/#organization"},"image":{"@id":"https:\/\/salesdorado.com\/en\/crm\/clean-customer-database\/#primaryimage"},"thumbnailUrl":"https:\/\/salesdorado.com\/wp-content\/uploads\/2019\/04\/nettoyer-bdd-clients.jpg","keywords":["Guides"],"articleSection":["CRM","Sales strategy"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/salesdorado.com\/en\/crm\/clean-customer-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/salesdorado.com\/en\/crm\/clean-customer-database\/","url":"https:\/\/salesdorado.com\/en\/crm\/clean-customer-database\/","name":"The Complete Guide To Cleaning Up Your Customer Database | Salesdorado","isPartOf":{"@id":"https:\/\/salesdorado.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/salesdorado.com\/en\/crm\/clean-customer-database\/#primaryimage"},"image":{"@id":"https:\/\/salesdorado.com\/en\/crm\/clean-customer-database\/#primaryimage"},"thumbnailUrl":"https:\/\/salesdorado.com\/wp-content\/uploads\/2019\/04\/nettoyer-bdd-clients.jpg","datePublished":"2019-04-13T14:55:48+00:00","dateModified":"2023-05-12T14:27:36+00:00","description":"Do you know that you have to clean your customer database, but you don't know where to start? this guide is made for you","breadcrumb":{"@id":"https:\/\/salesdorado.com\/en\/crm\/clean-customer-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/salesdorado.com\/en\/crm\/clean-customer-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/salesdorado.com\/en\/crm\/clean-customer-database\/#primaryimage","url":"https:\/\/salesdorado.com\/wp-content\/uploads\/2019\/04\/nettoyer-bdd-clients.jpg","contentUrl":"https:\/\/salesdorado.com\/wp-content\/uploads\/2019\/04\/nettoyer-bdd-clients.jpg","width":1440,"height":810,"caption":"Photo de 3 personnes qui nettoient la fa\u00e7ade d'un immeuble"},{"@type":"BreadcrumbList","@id":"https:\/\/salesdorado.com\/en\/crm\/clean-customer-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/salesdorado.com\/en\/"},{"@type":"ListItem","position":2,"name":"CRM","item":"https:\/\/salesdorado.com\/en\/.\/crm\/"},{"@type":"ListItem","position":3,"name":"The Complete Guide To Cleaning Up Your Customer Database"}]},{"@type":"WebSite","@id":"https:\/\/salesdorado.com\/en\/#website","url":"https:\/\/salesdorado.com\/en\/","name":"Salesdorado","description":"Work smarter, close more","publisher":{"@id":"https:\/\/salesdorado.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/salesdorado.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/salesdorado.com\/en\/#organization","name":"Salesdorado","url":"https:\/\/salesdorado.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/salesdorado.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/salesdorado.com\/wp-content\/uploads\/2023\/09\/sdo-icon.png","contentUrl":"https:\/\/salesdorado.com\/wp-content\/uploads\/2023\/09\/sdo-icon.png","width":176,"height":176,"caption":"Salesdorado"},"image":{"@id":"https:\/\/salesdorado.com\/en\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/salesdorado.com\/en\/#\/schema\/person\/ed9c1cde25eaf45b5be26c723edebebf","name":"Yassine Hamou Tahra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/94b6302368d85491a15be37533f76a8b6622652168c9262ea22db77195177169?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/94b6302368d85491a15be37533f76a8b6622652168c9262ea22db77195177169?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/94b6302368d85491a15be37533f76a8b6622652168c9262ea22db77195177169?s=96&d=mm&r=g","caption":"Yassine Hamou Tahra"},"description":"Yassine est un des co-fondateurs de Salesdorado. C'est aussi le fondateur et CEO d'Octolis, une CDP de nouvelle g\u00e9n\u00e9ration.","sameAs":["https:\/\/octolis.com\/","https:\/\/www.linkedin.com\/in\/yassineht\/","https:\/\/salesdorado.com\/wp-content\/uploads\/2023\/08\/yassine-hamou-tahra.jpeg"],"url":"https:\/\/salesdorado.com\/en\/author\/yassine\/"}]}},"_links":{"self":[{"href":"https:\/\/salesdorado.com\/en\/wp-json\/wp\/v2\/posts\/38053","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/salesdorado.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/salesdorado.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/salesdorado.com\/en\/wp-json\/wp\/v2\/users\/46"}],"replies":[{"embeddable":true,"href":"https:\/\/salesdorado.com\/en\/wp-json\/wp\/v2\/comments?post=38053"}],"version-history":[{"count":0,"href":"https:\/\/salesdorado.com\/en\/wp-json\/wp\/v2\/posts\/38053\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/salesdorado.com\/en\/wp-json\/wp\/v2\/media\/2526"}],"wp:attachment":[{"href":"https:\/\/salesdorado.com\/en\/wp-json\/wp\/v2\/media?parent=38053"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/salesdorado.com\/en\/wp-json\/wp\/v2\/categories?post=38053"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/salesdorado.com\/en\/wp-json\/wp\/v2\/tags?post=38053"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}