Case Study: Cleaning Up Over 700,000 Salesforce.com Records Removed Confusion From Sales Force | Sales Beacon
19194
page-template,page-template-full_width,page-template-full_width-php,page,page-id-19194,page-child,parent-pageid-18628,ajax_fade,page_not_loaded,,qode-title-hidden,qode-theme-ver-10.1.2,wpb-js-composer js-comp-ver-5.1,vc_responsive

Business Intelligence Case Studies

Case Study: Cleaning Up Over 700,000 Salesforce.com Records Removed Confusion From Sales Force

Years of automatic account create records from numerous feeder systems was creating havoc for pipeline reporting with up to 10 duplicate records per opportunity.

Client Challenge

The account data in Salesforce.com contained duplicate entries and junk data. These Account Records were the result of years of automatic account creates from numerous feeder systems. This data had never been de-duplicated.

Solution

  • Sales Beacon’s account management downloaded, filtered, sorted and formatted raw data, then presented them to the field for 1:1 field validation calls. At the end of the process, the data was loaded into the system, cleaning the live data.
  • During the process, Sales Beacon analyzed and identified a number of instances where the database allowed duplicated data to be created
  • Worked with IT to improve the system, including users clicking submit multiple times
  • Implemented user retraining across all levels
  • Out of 700,00 Records, 72% Were tagged as junk and hidden, 6% of Records were removed in 1:1 validation calls and 22% remained in the system

Business Impact

Based on Sales Beacon’s work, new account management policies and IT fixes were implemented, impacting the entire sales organization. Pipeline analysis and reporting was now far more accurate.