{"id":598,"date":"2013-11-12T15:16:56","date_gmt":"2013-11-12T22:16:56","guid":{"rendered":"http:\/\/bobbacon.net\/blog\/?p=598"},"modified":"2015-12-21T10:21:36","modified_gmt":"2015-12-21T18:21:36","slug":"crm-data-quality-issues","status":"publish","type":"post","link":"https:\/\/bobbacon.net\/blog\/archives\/598","title":{"rendered":"If Your CRM Data Really is Garbage, Clean It Up!"},"content":{"rendered":"

\"GarbageI recently completed another project to address our\u00a0CRM data quality issues\u00a0for our account records in Salesforce.com.\u00a0 Specific firmographic data (annual revenue, employee count and industry) determine our market segmentation and account assignments so having accurate data is critical to keeping the sales teams focused on selling and not on who should own which accounts.\u00a0 The source of our original account data has varied over the twelve years we\u2019ve been using SFDC.\u00a0 Sometimes it is from purchased lists, sometimes trade shows and sometimes directly created by Sales or Marketing.\u00a0 Over time the quality of this data (any data for that matter) decays so a long term solution needs to allow us to update records with current data on a periodic basis.<\/p>\n

When I surveyed the market in late 2012 for possible solutions that integrated with Salesforce.com I found several software packages that all claimed to quickly and accurately solve the vast majority of the data quality problem.\u00a0 As a rational person I didn\u2019t believe it. \u00a0They were expensive and made claims too good to be true. \u00a0At that time I decided to expand the use of Data.com Clean<\/span><\/a> to include the Data.com Premium package which, once installed and configured as an object in SFDC, systematically attempts to identify each SFDC account and match it to a DUNS number.\u00a0 Once matched you can copy over to the SFDC account record any of the nearly 100 fields available in the Data.com object.\u00a0 Data.com sources firmographic data from D&B<\/span><\/a>. \u00a0If you use Microsoft, Oracle or SAP CRM systems you can similarly integrate the D&B 360<\/span><\/a> object in your system directly sourced from D&B.\u00a0 I should mention here that in my opinion D&B data is a good choice as the primary source of corporate firmographic data but it\u2019s not perfect.\u00a0 You need to allow for a systematic approach for exceptions where their data is obviously deficient. More on that later.<\/p>\n

If your account record doesn\u2019t have an accurate physical address, phone number, website URL and, of course, an accurately formed account name then Data.com will not find a match with companies in the D&B database.\u00a0 The pre-sales test of our database performed by the Data.com sales team indicated that about 50% of our records had sufficient data to make a match.\u00a0 The folks at Data.com explained that 50% was slightly higher than typical Data.com customers for first time matches\u00a0but my expectations were significantly<\/span> higher.\u00a0 My goal was to match something just under 100% of the accounts!\u00a0 Thus, Data.com was only going to be part of the solution.<\/p>\n

We obviously needed someone with the expertise to advise me on best practices\u00a0regarding CRM data cleansing or normalization\u00a0and to perform mass de-duplication based on policies rather than one at a time. \u00a0Enter Theresa DeRycke of<\/span> <\/span>Data Therapy, LLC<\/span><\/a>.\u00a0 She uses CRM Fusion\u2019s Demand Tools<\/span><\/a> so, if you go this route, you will need a CRM Fusion license before engaging her.\u00a0 Theresa was an immense help in developing clever methodologies to achieve a quality account database that included the HQ corporate entity and all of its significant subsidiaries. \u00a0That\u2019s an important distinction for two reasons. \u00a0First, the HQ entity is where annual revenue and employee count is retained in the D&B data structure.\u00a0 If accounts are to be assigned to a sales team based on either of these metrics then you need to reference the HQ entity in your database, regardless of where the buying actually occurs.\u00a0 Further, if sales rep ownership of a parent account is deemed to include subsidiaries (based on the assumption that a single buying group influences, if not controls, buying at the subsidiary level) then you need to document the corporate hierarchy in SFDC as well.\u00a0 Theresa successfully guided the necessary revisions to our data to accomplish all of this.<\/p>\n

The first approach I tried with Data.com was too slow because it was based on trial and error in finding the proper combination of name, address, phone and URL. \u00a0In Q2 of 2013 Data.com added a feature that permitted us to match on the DUNS number alone, disregarding any address or account name.\u00a0 With this additional feature I found it was much faster to lookup the account in Hoovers<\/span><\/a> (a D&B subsidiary), find the HQ entity, copy the DUNS number to the SFDC record, and then use Data.com to update the relevant firmographic data.\u00a0 The Hoovers search and presentation functionality allows users to identify the best DUNS number faster than the Data.com search functionality. \u00a0This remained true even after Data.com released \u201cHoovers like\u201d search functionality late that same quarter.<\/p>\n

Data.com may have a valid role in your company if you receive a large number of leads or if your Sales Development Reps create a large number of new accounts on a regular basis but it is an expensive option if you\u2019re only using it to periodically update account firmographics.\u00a0 If I had it do all over again I would use Hoovers exclusively.<\/p>\n

Finally, once the data is accurate you have a short time frame to implement policies and procedures to insure that the data doesn\u2019t degrade over time.\u00a0 This could include limiting the user\u2019s ability to create new accounts or to monitor the creation of new accounts while enhancing their data quality as you go.\u00a0 Along these same lines you may want to lock fields containing certain critical data within the account record so that accounts won\u2019t be \u201caccidently\u201d reassigned based on territory rules and SFDC triggers.<\/p>\n

Creating a new field in the account record for the DUNS number will allow you to update all of the firmographic data in a mass extraction, transformation and load (ETL) process using any source of data that includes the DUNS number. \u00a0As I mentioned previously, you also need to create a process that allows you to update those records which didn\u2019t have accurate D&B data when last checked.\u00a0 For this purpose I created a field on the account record which indicated the source of the non-D&B data so I could avoid over-writing it with what may still be inaccurate data from D&B.<\/p>\n

There are a number of alternative, specialty data sources (some free) which I use to enhance some of the firmographic data.\u00a0 Here are a few:<\/p>\n

American Hospital Directory\u00a0\u00a0\u00a0 http:\/\/www.ahd.com\/disclaimer.php<\/span><\/a>
\niBank\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 http:\/\/www.ibanknet.com\/<\/span><\/a>
\nCharity Navigator\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 http:\/\/www.charitynavigator.org\/<\/span><\/a>
\nPrivCo (private entities)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 http:\/\/www.privco.com\/login”> <\/span><\/a><\/p>\n

There are also firmographic data sources which are not specific to market segments:<\/p>\n

InsideView\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 https:\/\/my.insideview.com\/iv\/welcome.do<\/span><\/a>
\nDiscover.org\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0https:\/\/www.discoverydb.com\/EXEC\/<\/span><\/a>
\nOneSource\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 http:\/\/custom.onesource.com\/<\/span><\/a>
\nZoom Info\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 http:\/\/www.zoominfo.com\/<\/span><\/a><\/p>\n

If you\u2019re planning a project of this nature, my experience is that it can take one person, one month to manually match or enhance about 1,000 accounts.\u00a0 In quantifying your needs remember that a DUNS number\u00a0match may still be inaccurate if the D&B account it represents isn’t at the HQ level.\u00a0 Using the approaches here and over a period of six months I achieved a greater than 99% match rate for\u00a0all accounts.\u00a0 More importantly, the real test of accurate account data quality is when the territories are segmented and accounts assigned, none of the selling resources complained that their territory was inequitable compared with their peers; too small, yes; but inequitable, no.\u00a0 This is a “first” in my career!<\/p>\n

If\u00a0your experience is different from mine, please share\u00a0your\u00a0perspectives or advice to further improve this laborious process.\u00a0 Sooner or later everyone who is responsible for a CRM system has to deal with\u00a0it.<\/p>\n

Cheers!<\/p>\n

Bob Bacon<\/p>\n","protected":false},"excerpt":{"rendered":"

I recently completed another project to address our\u00a0CRM data quality issues\u00a0for our account records in Salesforce.com.\u00a0 Specific firmographic data (annual revenue, employee count and industry) determine our market segmentation and account assignments so having accurate data is critical to keeping … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_s2mail":"no","footnotes":""},"categories":[4],"tags":[48,62,26,77,7,72,80,68,70,71,49,21,37,35,69,78],"class_list":["post-598","post","type-post","status-publish","format-standard","hentry","category-sales_ops","tag-sales20","tag-b2b","tag-bob-bacon","tag-clean","tag-crm","tag-db","tag-data-normalization","tag-data-quality","tag-data-com","tag-hoovers","tag-sales-development","tag-sales-management","tag-sales-operations","tag-sales-ops","tag-sfdc","tag-sfdc-cleanup"],"_links":{"self":[{"href":"https:\/\/bobbacon.net\/blog\/wp-json\/wp\/v2\/posts\/598","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bobbacon.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bobbacon.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bobbacon.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bobbacon.net\/blog\/wp-json\/wp\/v2\/comments?post=598"}],"version-history":[{"count":22,"href":"https:\/\/bobbacon.net\/blog\/wp-json\/wp\/v2\/posts\/598\/revisions"}],"predecessor-version":[{"id":1044,"href":"https:\/\/bobbacon.net\/blog\/wp-json\/wp\/v2\/posts\/598\/revisions\/1044"}],"wp:attachment":[{"href":"https:\/\/bobbacon.net\/blog\/wp-json\/wp\/v2\/media?parent=598"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bobbacon.net\/blog\/wp-json\/wp\/v2\/categories?post=598"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bobbacon.net\/blog\/wp-json\/wp\/v2\/tags?post=598"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}