{"id":37954,"date":"2024-10-01T09:00:37","date_gmt":"2024-10-01T09:00:37","guid":{"rendered":""},"modified":"2023-05-12T14:15:21","modified_gmt":"2023-05-12T14:15:21","slug":"deduplication-deduplication-of-customer-data","status":"publish","type":"post","link":"https:\/\/salesdorado.com\/en\/crm\/deduplication-deduplication-of-customer-data\/","title":{"rendered":"Customer data deduplication &amp; deduplication &#8211; Issues, tools and tutorial"},"content":{"rendered":"<p>The performance of your marketing &amp; CRM actions depends to a large extent on the quality of your customer databases. You must clean them up regularly. This means, among other things, de-duplicating your contacts. What is deduplication? Why is it important? How does it work? What tools? This is the subject of this article. At the end, as a bonus, we will present you with a small tutorial to deduplicate your contacts in SQL.<\/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 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/salesdorado.com\/en\/crm\/deduplication-deduplication-of-customer-data\/#deduplication-an-essential-step-in-your-data-quality-crm\" >Deduplication an essential step in your data quality CRM<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/salesdorado.com\/en\/crm\/deduplication-deduplication-of-customer-data\/#why-is-deduplication-so-important\" >Why is deduplication so important?<\/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\/deduplication-deduplication-of-customer-data\/#deduplication-vs-deduplication\" >Deduplication vs. deduplication<\/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\/deduplication-deduplication-of-customer-data\/#what-are-the-traditional-approaches-to-deduplication\" >What are the traditional approaches to deduplication?<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/salesdorado.com\/en\/crm\/deduplication-deduplication-of-customer-data\/#which-tool-should-you-use-to-deduplicate-your-customer-data\" >Which tool should you use to deduplicate your customer data?<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/salesdorado.com\/en\/crm\/deduplication-deduplication-of-customer-data\/#octolis\" >Octolis<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/salesdorado.com\/en\/crm\/deduplication-deduplication-of-customer-data\/#dqe-software\" >DQE Software<\/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\/deduplication-deduplication-of-customer-data\/#amabis\" >Amabis<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/salesdorado.com\/en\/crm\/deduplication-deduplication-of-customer-data\/#what-if-you-learned-to-deduplicate-yourself-in-sql\" >What if you learned to deduplicate yourself in SQL?<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"deduplication-an-essential-step-in-your-data-quality-crm\"><\/span><span class=\"ez-toc-section\" id=\"deduplication-an-essential-step-in-your-data-quality-crm\"><\/span>Deduplication: an essential step in your data quality CRM<span class=\"ez-toc-section-end\"><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Deduplication and deduplication is a key step in any <a href=\"https:\/\/salesdorado.com\/en\/crm\/data-quality-definition\/\" data-internallinksmanager029f6b8e52c=\"61\" title=\"Data Quality\">Data Quality<\/a> Management approach. We will see why it is so important, what the difference is between deduplication and deduplication, and what the typical approaches to deduplication are.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"why-is-deduplication-so-important\"><\/span><span class=\"ez-toc-section\" id=\"why-is-deduplication-so-important\"><\/span>Why is deduplication so important?<span class=\"ez-toc-section-end\"><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Deduplication consists of identifying data that appears in several files in the information system and keeping it in a single file by merging. In the context of database management, it is most often a matter of deduplicating contacts.<\/p>\n<p>An information system such as CRM, for example, necessarily tends to generate duplicate contacts in several different places in the system. For at least 4 reasons:<\/p>\n<ul class=\"listFont iconChevron listLeft\">\n<li>People who manage CRM sometimes add contacts or create accounts without necessarily checking whether or not they have already been registered in the system. Even if your CRM sends notifications when there is a duplication, not everyone pays attention &#8211; and the notifications don&#8217;t always display well on mobile.<\/li>\n<li>Data import tools do not always identify duplications very well.<\/li>\n<li>Integrations with external data sources such as website forms, partner portals or email brokers do not always require the CRM data before importing the new data.<\/li>\n<li>Many human errors or software bugs (bugs in the CRM or associated applications\/tools) can easily result in hundreds or thousands of duplications.<\/li>\n<\/ul>\n<p>Having 2% duplicate data is not a tragedy, as long as it is short-lived data and your tools and processes allow you to detect and correct it. Beyond 5% duplication, things get worse. This is where users start to complain, where reporting leads to false analysis.<\/p>\n<p>Detecting and correcting duplicate data is a time-consuming task that requires methodological rigour. You need to choose the right duplicate data detection tools, use them well, identify from them the main reasons why your IS generates duplicate data and from this understanding dry up the main sources of duplicate creation.<\/p>\n<p>Having an information system with as little duplicated data as possible allows :<\/p>\n<ul class=\"listFont iconChevron listLeft\">\n<li>Have a cleaner database: deduplication is a key step in database cleanup.<\/li>\n<li>Reduce the maintenance and storage costs of your system.<\/li>\n<li>Reduce the cost of sending your campaigns and more broadly all marketing costs.<\/li>\n<li>Improve the customer experience &gt; There is nothing more annoying for a customer than to be targeted several times by the same action, campaign or marketing scenario. Deduplication avoids brand damage resulting from duplicate messages.<\/li>\n<li>Know your customers better by limiting the dispersion of data in several tables.<\/li>\n<li>Improve the reliability of reporting and decision-making based on it.<\/li>\n<\/ul>\n<p>The increase in the number of data sources and the number of contact points tends to encourage the creation of duplicate data. When you use dozens of tools, databases and channels, the risk of a customer being recorded in several places in the system is not negligible. Hence the importance of addressing this issue!<\/p>\n<h3><span class=\"ez-toc-section\" id=\"deduplication-vs-deduplication\"><\/span><span class=\"ez-toc-section\" id=\"deduplication-vs-deduplication\"><\/span>Deduplication vs. deduplication<span class=\"ez-toc-section-end\"><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>People often confuse deduplication with deduplication. However, these are two quite different things.<\/p>\n<p>A &#8220;duplicate&#8221; is when information or data is present several times in the same database or file.<\/p>\n<p>Duplicate data&#8221; is when the same data is present in several databases or files in the information system. The problem of duplicate data is a major one, particularly in the field of prospecting. When you use several different prospecting files, it can easily happen that a contact is present in several files. In this case, data deduplication makes it possible to avoid contacting the same prospect several times.<\/p>\n<p>However, this distinction should not be absolutized. What duplication and deduplication have in common is that they result in the presence of two identical contacts\/data in the information system. In a unified IS with UC, deduplication and deduplication are quite similar.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"what-are-the-traditional-approaches-to-deduplication\"><\/span><span class=\"ez-toc-section\" id=\"what-are-the-traditional-approaches-to-deduplication\"><\/span>What are the traditional approaches to deduplication?<span class=\"ez-toc-section-end\"><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>The creation of duplicate data is often linked to syntactic differences resulting from input errors by sales staff or customer advisers, inversions, the use of abbreviations (for postal addresses, for example), etc. The data entered in the contact form, in the account creation form, or during an exchange with customer service are not strictly identical, which leads to duplicate data in the system, in the CRM for example.<\/p>\n<p>Data is a living thing, most of it is bound to change over time: the individual moves, changes phone number, changes surname (marriage, divorce&#8230;), etc. This can also contribute to the creation of duplicates. This can also contribute to the creation of duplicates. In this case, the company must set up rules of priority between data sources to identify the &quot;good&quot; data, the one that is most likely to be true &gt; and therefore the one to use.<\/p>\n<p class=\"blocIntro\">Discover 10 tips for building optimised Landing Pages for lead collection.<\/p>\n<p>Information system users are usually able to quickly identify information associated with an individual, to spot the identity of the contact behind syntactic differences. However, once a certain volume of data is reached, it becomes essential to use automation mechanisms to detect and correct these differences and remove duplicate data. Here are the main steps in the process:<\/p>\n<p>Step 1: Data Management<\/p>\n<ul class=\"listFont iconChevron listLeft\">\n<li>RNVP (Restructuring, Normalisation, Postal Validation) processing of postal addresses<\/li>\n<li>Standardisation of telephone numbers.<\/li>\n<li>Etc.<\/li>\n<\/ul>\n<p>Second step: The implementation of an algorithm to calculate a proximity score, and this for each type of data: name, first name, postal address, email, telephone&#8230; Two methods are possible:<\/p>\n<ul class=\"listFont iconChevron listLeft\">\n<li>A string similarity analysis and the use of distance calculations: Levenstein, Hamming&#8230;<\/li>\n<li>A sound similarity analysis, which consists of comparing the content of the data from a phonetic point of view. The metaphone and double metaphone methods are widely used for this purpose.<\/li>\n<\/ul>\n<p>Third step: The calculation of a global similarity score of the database. This is where a machine learning model comes into play to build a composite similarity indicator. Random forest type methods can be usefully implemented at this level.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"which-tool-should-you-use-to-deduplicate-your-customer-data\"><\/span><span class=\"ez-toc-section\" id=\"which-tool-should-you-use-to-deduplicate-your-customer-data\"><\/span>Which tool should you use to deduplicate your customer data?<span class=\"ez-toc-section-end\"><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>We are now going to introduce you to 3 very good tools to deduplicate your customer data.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"octolis\"><\/span><span class=\"ez-toc-section\" id=\"octolis\"><\/span>Octolis<span class=\"ez-toc-section-end\"><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"\/wp-content\/uploads\/2019\/04\/deduplication-donnees-clients-exemple-outil-octolis.png\" \/><\/figure>\n<\/div>\n<p><a href=\"https:\/\/octolis.com\" target=\"_blank\" rel=\"noopener\">Octolis<\/a> is a lightweight Customer Data Platform (CDP) designed to connect your data sources, clean them, de-duplicate them, unify them and enrich them. From there, the tool offers you the possibility to create audiences, scores, segments, aggregates that you can then synchronise in a few clicks in your Sales and Marketing tools for your activation use cases.<\/p>\n<p>Unlike traditional CDPs, Octolis is independent of your customer database (your data warehouse) and gives you total control over your database.<\/p>\n<p>The tool deduplicates contacts and companies using several keys, by default: the userId, or Last Name x First Name x Email or Last Name x First Name x Phone. The Octolis team can, if necessary, set up new keys on request.<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2019\/04\/deduplication-donnees-clients-exemple-outil-octolis-2.png\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"dqe-software\"><\/span><span class=\"ez-toc-section\" id=\"dqe-software\"><\/span>DQE Software<span class=\"ez-toc-section-end\"><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\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>Founded in 2008, <a href=\"https:\/\/www.dqe-software.com\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"DQE Software (opens in a new tab)\">DQE Software<\/a> is a solution provider specialising in data quality management and the implementation of unique customer repositories. DQE has developed several intelligent technologies for optimising customer data quality, covering the entire chain from data collection to marketing activation. DQE solutions are available in cloud mode (SaaS) or as hosted versions on company servers. They are designed to interface easily with CRM and ERP tools. With more than 150,000 users and an annual growth rate of +20%, DQE Software is a reference in the market.<\/p>\n<p class=\"blocIntro\">Discover our <a href=\"https:\/\/salesdorado.com\/en\/crm\/free-crm-software\/\">Top B2B CRM &#038; Marketing software with free version<\/a>.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"amabis\"><\/span><span class=\"ez-toc-section\" id=\"amabis\"><\/span>Amabis<span class=\"ez-toc-section-end\"><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\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>With offices in France and Morocco, <a href=\"https:\/\/www.amabis.com\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Amabis (opens in a new tab)\">Amabis<\/a> is a French company that has been operating in the customer data management market for over 20 years. The company has nearly 500 customers. Historically, Amabis was specialized in the management of CRM &#038; marketing databases (AmaBase), which allowed it to acquire a strong expertise in the management of customer data and become a leading player in the world of Data Quality Management. Amabis has been offering a new CRM solution since 2015, AmaCRM, which natively integrates data quality management.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"what-if-you-learned-to-deduplicate-yourself-in-sql\"><\/span><span class=\"ez-toc-section\" id=\"what-if-you-learned-to-deduplicate-yourself-in-sql\"><\/span>What if you learned to deduplicate yourself in SQL?<span class=\"ez-toc-section-end\"><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Did you know that it is possible to deduplicate customer data from your relational database using a &#8220;simple&#8221; SQL query? We have taken some screenshots to quickly explain the logic. The query we are going to present to you allows you to transform a table of contacts into a single customer repository (UCR). Here is the result:<\/p>\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"\/wp-content\/uploads\/2019\/04\/deduplication-sql-1.png\" \/><figcaption><\/figcaption><\/figure>\n<p>The first capture shows the table before the SQL query is executed, the second the table after the query is executed.<\/p>\n<p>This query, as you can see, takes into account unmerging rules, so that two wrongly associated contacts can be dissociated a posteriori. This is very practical. In this case, it prevents two members of the same family from being associated because of the identity of the name. Remember that deduplication is the process that consists of merging identical contacts in your databases. In this process, one of the biggest risks is to merge contacts that are not identical. Unmerging rules act as safeguards. If you decide to de-duplicate your contacts in SQL, we strongly recommend that you implement these rules.<\/p>\n<p class=\"blocIntro\">Discover our complete guide to the <a href=\"https:\/\/salesdorado.com\/en\/account-based-marketing\/identify-anonymous-b2b-visitors\/\">art of identifying anonymous visitors to a B2B<\/a> website.<\/p>\n<p>The other interest of this SQL query is that it succeeds in making a fuzzyjoin on the first name by assimilating the accented \/ unaccented first names and the first names with \/ without capital letters &gt; Cl\u00e9ment = clement. Remember that spelling\/syntactic differences are the main source of duplicates. Here is the query:<\/p>\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"\/wp-content\/uploads\/2019\/04\/deduplication-sql-2.png\" \/><\/figure>\n<p>We have taken the time to detail each of the parts it contains, to help you better understand the logic.<\/p>\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"\/wp-content\/uploads\/2019\/04\/deduplication-sql-3.png\" \/><\/figure>\n<p>If you are familiar with SQL and relational database management, you can deduplicate your customer data in SQL. This is what we wanted to show you in this small example.<\/p>\n<p>Are you a marketer and not at all comfortable with SQL? We invite you to discover <a href=\"https:\/\/www.cartelis.com\/blog\/fondamentaux-sql-marketeurs\/\">the fundamentals of SQL for marketers<\/a>.<\/p>\n<div style=\"display: none;\"\n    class=\"kk-star-ratings kksr-valign-bottom kksr-align-center \"\n    data-id=\"37954\"\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 performance of your marketing &amp; CRM actions depends to a large extent on the [&hellip;]<\/p>\n","protected":false},"author":46,"featured_media":15526,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[231,303],"tags":[312,313],"class_list":["post-37954","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-crm","category-sales-strategy","tag-guides","tag-tools"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Customer data deduplication &amp; deduplication - Issues, tools and tutorial | Salesdorado<\/title>\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\/deduplication-deduplication-of-customer-data\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Customer data deduplication &amp; deduplication - Issues, tools and tutorial | Salesdorado\" \/>\n<meta property=\"og:description\" content=\"The performance of your marketing &amp; CRM actions depends to a large extent on the [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/salesdorado.com\/en\/crm\/deduplication-deduplication-of-customer-data\/\" \/>\n<meta property=\"og:site_name\" content=\"Salesdorado\" \/>\n<meta property=\"article:published_time\" content=\"2024-10-01T09:00:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/salesdorado.com\/wp-content\/uploads\/2019\/04\/deduplication.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1440\" \/>\n\t<meta property=\"og:image:height\" content=\"874\" \/>\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=\"8 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Customer data deduplication &amp; deduplication - Issues, tools and tutorial | Salesdorado","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\/deduplication-deduplication-of-customer-data\/","og_locale":"en_US","og_type":"article","og_title":"Customer data deduplication &amp; deduplication - Issues, tools and tutorial | Salesdorado","og_description":"The performance of your marketing &amp; CRM actions depends to a large extent on the [&hellip;]","og_url":"https:\/\/salesdorado.com\/en\/crm\/deduplication-deduplication-of-customer-data\/","og_site_name":"Salesdorado","article_published_time":"2024-10-01T09:00:37+00:00","og_image":[{"width":1440,"height":874,"url":"https:\/\/salesdorado.com\/wp-content\/uploads\/2019\/04\/deduplication.jpg","type":"image\/jpeg"}],"author":"Yassine Hamou Tahra","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Yassine Hamou Tahra","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/salesdorado.com\/en\/crm\/deduplication-deduplication-of-customer-data\/#article","isPartOf":{"@id":"https:\/\/salesdorado.com\/en\/crm\/deduplication-deduplication-of-customer-data\/"},"author":{"name":"Yassine Hamou Tahra","@id":"https:\/\/salesdorado.com\/en\/#\/schema\/person\/ed9c1cde25eaf45b5be26c723edebebf"},"headline":"Customer data deduplication &amp; deduplication &#8211; Issues, tools and tutorial","datePublished":"2024-10-01T09:00:37+00:00","mainEntityOfPage":{"@id":"https:\/\/salesdorado.com\/en\/crm\/deduplication-deduplication-of-customer-data\/"},"wordCount":1709,"commentCount":0,"publisher":{"@id":"https:\/\/salesdorado.com\/en\/#organization"},"image":{"@id":"https:\/\/salesdorado.com\/en\/crm\/deduplication-deduplication-of-customer-data\/#primaryimage"},"thumbnailUrl":"https:\/\/salesdorado.com\/wp-content\/uploads\/2019\/04\/deduplication.jpg","keywords":["Guides","Tools"],"articleSection":["CRM","Sales strategy"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/salesdorado.com\/en\/crm\/deduplication-deduplication-of-customer-data\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/salesdorado.com\/en\/crm\/deduplication-deduplication-of-customer-data\/","url":"https:\/\/salesdorado.com\/en\/crm\/deduplication-deduplication-of-customer-data\/","name":"Customer data deduplication &amp; deduplication - Issues, tools and tutorial | Salesdorado","isPartOf":{"@id":"https:\/\/salesdorado.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/salesdorado.com\/en\/crm\/deduplication-deduplication-of-customer-data\/#primaryimage"},"image":{"@id":"https:\/\/salesdorado.com\/en\/crm\/deduplication-deduplication-of-customer-data\/#primaryimage"},"thumbnailUrl":"https:\/\/salesdorado.com\/wp-content\/uploads\/2019\/04\/deduplication.jpg","datePublished":"2024-10-01T09:00:37+00:00","breadcrumb":{"@id":"https:\/\/salesdorado.com\/en\/crm\/deduplication-deduplication-of-customer-data\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/salesdorado.com\/en\/crm\/deduplication-deduplication-of-customer-data\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/salesdorado.com\/en\/crm\/deduplication-deduplication-of-customer-data\/#primaryimage","url":"https:\/\/salesdorado.com\/wp-content\/uploads\/2019\/04\/deduplication.jpg","contentUrl":"https:\/\/salesdorado.com\/wp-content\/uploads\/2019\/04\/deduplication.jpg","width":1440,"height":874},{"@type":"BreadcrumbList","@id":"https:\/\/salesdorado.com\/en\/crm\/deduplication-deduplication-of-customer-data\/#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":"Customer data deduplication &amp; deduplication &#8211; Issues, tools and tutorial"}]},{"@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\/37954","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=37954"}],"version-history":[{"count":0,"href":"https:\/\/salesdorado.com\/en\/wp-json\/wp\/v2\/posts\/37954\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/salesdorado.com\/en\/wp-json\/wp\/v2\/media\/15526"}],"wp:attachment":[{"href":"https:\/\/salesdorado.com\/en\/wp-json\/wp\/v2\/media?parent=37954"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/salesdorado.com\/en\/wp-json\/wp\/v2\/categories?post=37954"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/salesdorado.com\/en\/wp-json\/wp\/v2\/tags?post=37954"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}