Skip to main content

EQT Transforms Data Quality and Eliminate Thousands of Duplicates Monthly

“Implementing DataGroomr was a game-changer for us. Within six months, we saw a tremendous improvement in our data quality, reducing duplicates by thousands each month.”

Josh Hoyt, Director of the Salesforce Oil & Gas IT Team at EQT

josh hoyt

Free 14-Day Trial

No Setup or Customization Required.

eqt logo

EQT Corporation is one of the leading natural gas producers in the United States, dedicated to delivering reliable and sustainable energy solutions. With a strong focus on operational excellence, innovation, and environmental responsibility, EQT operates with a commitment to safety and efficiency. The company leverages advanced technologies to optimize natural gas production and reduce environmental impact, ensuring a stable and secure energy future for its customers and stakeholders. For more information, visit EQT Corporation.

The Challenge

EQT faced a comprehensive data quality challenge with their Accounts and Contact data. The issues spanned across various facets of their operations: 

  1. Education: Employees lacked understanding of duplicates and their negative impacts, ignoring Salesforce’s duplicate warnings and failing to capture essential contact information. 
  2. Business Process: An unrestricted environment for creating accounts and contacts led to significant issues. Manual checks using spreadsheets were insufficient for acquisitions, and there were no initiatives focused on data quality. 
  3. Technical Issues: Salesforce’s unique username requirements invited duplicates, and multiple Account and Contact Record Types created confusion. Marketing Cloud campaigns revealed hard bounce backs, but this information wasn’t shared with users. Additionally, States and Countries weren’t standardized. 
eqt challenge

Discovery of DataGroomr

EQT found DataGroomr on AppExchange. After comparing it with another leading solution, they were impressed by DataGroomr’s AI capabilities, user-friendly interface, and intuitive design.

The Solution

DataGroomr accelerated EQT’s efforts to reduce duplicates and maintain data quality. Prior to implementing DataGroomr, EQT had already made foundational changes: 

  • User Education: Training on the importance of duplicates and their impacts.
  • Reduced Account and Contact Types: Streamlining these types over two years for better process management. 
  • Controlled Account Creation: Tightening control over account creation while allowing free creation of contacts. 
  • Account and Contact Quality Score: Implementing a quality score system displayed prominently on the highlights bar. 
  • Collaborative Efforts: Engaging various teams to address duplicate issues and improve data quality. 
  • Standardization: Standardizing States and Countries and fixing registration processes. 
  • KPIs for Data Quality: Setting KPIs for teams to improve data quality through duplicate reduction and contact information capture. 
appexchange

Improvements Noted

Within six months of implementing DataGroomr, EQT saw a significant improvement in data quality, reducing duplicates by thousands each month. Over 2.5 years, they removed over 20,000 duplicate contacts and significantly improved their account data. 

EQT also successfully avoided creating thousands of duplicate accounts during acquisitions, improving customer experience by preventing multiple statements for the same customer. The focus on data quality resulted in a 50% increase in quality scores, even as the volume of accounts and contacts doubled. 

“Implementing DataGroomr was a game-changer for us. Within six months, we saw a tremendous improvement in our data quality, reducing duplicates by thousands each month. The Importr feature has been instrumental in preventing duplicates during acquisitions, making a significant impact on our ROI. DataGroomr has truly transformed our approach to data management, ensuring our information is accurate and reliable.” commented Josh Hoyt, Director of the Salesforce Oil & Gas IT Team at EQT 

improvements noted

Key Features and Benefits of DataGroomr

Filtering and Sorting

Prioritizing duplicates for efficient reduction.

Formatting Standardization

Ensuring consistency in account names, phone numbers, and addresses.

Importr Feature

Preventing duplicates during acquisitions, enhancing ROI.

Unmerge Functionality

Exclusive use of DataGroomr for merging to avoid Salesforce's limitations.

Verification Tools

Address, phone, and email verification for up-to-date and accurate information.

Future Outlook

EQT aims to maintain data quality with periodic checks and continuous contact point verifications. The Importr tool will play a crucial role in future acquisitions, ensuring seamless integration and high data quality. 

Conclusion

EQT’s journey with DataGroomr demonstrates how focusing on data quality and leveraging the right tools can transform an organization’s data management practices. By addressing foundational issues and using DataGroomr’s advanced features, EQT achieved remarkable improvements in data quality, contributing to overall business success and efficiency

DataGroomr has truly transformed our approach to data management, ensuring our information is accurate and reliable.

Josh Hoyt