--- title: Harmonizing Data to Get a Single, Unified View of Customers description: Whether you're preparing your data for AI or optimizing your Salesforce org, it’s important that you to have clean and connected data. image: https://www.passagetechnology.com/hubfs/Hamonizing%20Data%20image.png --- [GET DEMO](https://www.passagetechnology.com/any-product-one-on-one) **+1 (224) 655-6779 [![Trusted Salesforce service partner Passage Technology](https://www.passagetechnology.com/hubfs/2021/Nav-header-logo_PT.png) ](https://www.passagetechnology.com) # Harmonizing Data to Get a Single, Unified View of Customers 2024/04/10 [![Free Salesforce business guides to help admins/developers, project managers, sales managers, and decision makers. Download the free PDF series now: Reinventing Your Business, Reimagining Your Salesforce®.](https://www.passagetechnology.com/hubfs/2021/Essential-Salesforce-Guide_Helper-Suite.png) ](https://www.passagetechnology.com/en/essential-guide-for-salesforce-admins-developers) ## How Retailers & Other Organizations Can Use Salesforce® Apps to Optimize Data When you hear a great song, one of the things you might notice is how everything flows together — the melody and the rhythm perfectly in sync. Like music, your data also needs to be arranged and organized in order to work together harmoniously. The Salesforce article, “[Retail Roadblock: Lack of Data Strategy Stands in the Way of Generative AI Progress,](https://www.salesforce.com/news/stories/ai-in-retail-statistics/)” shared results of their recent survey, which lists customer service, marketing, and store operations as areas of focus for generative AI. “Retailers understand the importance of data, according to the survey, but many are still working through how to unify all of their data and build a single view of their customers,” the article explains. But issues with preparing data for AI are preventing organizations from getting harmonious, accurate, and actionable information. “The inability to unify and harmonize data means that a retailer’s generative AI model could deliver ineffective or inaccurate results, or responses laced with toxicity and biases. Even though 67% of retailers say they are fully able to capture customer data, only 39% say they are fully able to clean that data, and just 42% say they are fully able to harmonize it,” explained the article. Whether your goal is to prepare data for AI or to optimize your Salesforce org, it’s important that you have clean and connected data. For example, our customer SquadLocker was experiencing a challenge with associating a new custom object (Sales Line) with their current account object. Since [Lookup Helper works with standard and custom objects, it allows them to display related records in Salesforce.](https://www.passagetechnology.com/customer-success/rollup-helper-online-store) SquadLocker’s Rev/Ops Director Nellie Tillinghast said, “Lookup Helper facilitates the ‘relationship’ build so that records show up easily and without human intervention.” Nellie reports that both [Rollup Helper](https://www.passagetechnology.com/rollup-helper-overview) and [Lookup Helper](https://www.passagetechnology.com/lookup-helper-overview) have simplified their work and saved time. She adds, “Thanks to scheduling offered on both solutions, our records are updated daily and overnight so that there’s no human manipulation, while allowing for accurate information.” Providing Data to Teams, Empowering Them to Be Proactive With Customers  When our customer Clear Capital needed to [display multiple revenue and volume summaries for use in multiple business units,](https://www.passagetechnology.com/customer-success/helper-suite-clear-capital) they chose our apps [Rollup Helper](https://www.passagetechnology.com/rollup-helper-overview) and [Lookup Helper](https://www.passagetechnology.com/lookup-helper-overview). Business Systems Administrator Lisa Foster explains, “Rollup Helper and Lookup Helper allow us to link objects to display multiple revenue and volume summaries for our business units. Before these solutions, this would require written code, which can be difficult to write, test, and maintain.” Now Clear Capital can provide data to their teams that would otherwise be done manually. This allows the marketing team to see the results of their efforts and sales to see what is working well, and where there’s an opportunity for improvement. “We can spot trends in sales to allow us to be proactive with our customers and prospects. Plus, we were able to resolve an issue that was previously done with custom code and objects by adding a lookup and rollup field to accomplish the same task,” said Lisa. ### Helping Customer Service Identify Accounts That Need Assistance Sometimes simple things like calculations can cause delays for customer service teams. For example, an obstacle reps can experience is [calculating the amount of open cases for Account records](https://www.passagetechnology.com/rollup-helper-use-cases/number-of-open-cases-on-an-account) in Salesforce. This can be solved by deploying one of Rollup Helper’s pre-built rollups named, "Number of Open Cases." The Number of Open Cases use case calculates the amount of open cases for each Account record.  The result: your customer service team can now see which Accounts need the most help. And your Sales and Marketing team can also hold off on reaching out to customers or prospects until their issues are cleared up. Check out the use cases below to see how you can clean up, manage, and optimize your data. ### Use Cases – Cleaning Up, Managing, and Optimizing Data [Duplicate Records](https://www.passagetechnology.com/data-quality-helper-use-cases/tag/duplicate-records) [Mass Delete Old Emails, Auto-Responses & Case Email Messages](https://www.passagetechnology.com/storage-helper-use-case-library/recycle-old-cases-case-email-messages) [Easily Monitor Inventory in Salesforce With an Inventory Level Object](https://www.passagetechnology.com/lookup-helper-use-cases/monitor-inventory) [Populate a Date Field on Case with the Most Recent Task for Order Sent](https://www.passagetechnology.com/rollup-helper-use-cases/populate-a-date-field-on-case-with-the-date-of-the-most-recent-task-for-order-sent) [View Available Personnel in a Geographical Area](https://www.passagetechnology.com/lookup-helper-use-cases/view-available-personnel-in-a-geographical-area) [Tracking Open Cases on Accounts and Contacts](https://www.passagetechnology.com/lookup-helper-use-cases/tracking-open-cases-by-priority-on-accounts-and-contacts) [Prevent Missing Comments When Salesforce Case Is Escalated](https://www.passagetechnology.com/data-quality-helper-use-cases/preventing-missing-internal-comments-when-case-is-escalated-in-salesforce) [Create Parent Record on Field Match](https://www.passagetechnology.com/lookup-helper-use-cases/create-parent-record-on-field-match)      Tags: [Account](https://www.passagetechnology.com/passage-technology-blog/topic/account), [Rollup Helper](https://www.passagetechnology.com/passage-technology-blog/topic/rollup-helper), [Scheduled Rollups](https://www.passagetechnology.com/passage-technology-blog/topic/scheduled-rollups), [Lookup Helper](https://www.passagetechnology.com/passage-technology-blog/topic/lookup-helper), [Admin](https://www.passagetechnology.com/passage-technology-blog/topic/admin), [Rollup Summary Field](https://www.passagetechnology.com/passage-technology-blog/topic/rollup-summary-field), [lookup relationship](https://www.passagetechnology.com/passage-technology-blog/topic/lookup-relationship) | [** Repetitive, Inefficient Tasks Are Costing Organizations Millions ](https://www.passagetechnology.com/passage-technology-blog/repetitive-tasks) | [Passage Technology Blog](https://www.passagetechnology.com/passage-technology-blog) | [ Tips for Executing an Effective Data Quality Strategy ** ](https://www.passagetechnology.com/passage-technology-blog/tips-for-executing-an-effective-data-quality-strategy) | | --- | --- | --- | [ 7 Popular Use Cases that Lighten the Load for Salesforce Admins ](https://www.passagetechnology.com/passage-technology-blog/use-cases-admins) [ What is technical debt, and how can you avoid it in Salesforce? ](https://www.passagetechnology.com/passage-technology-blog/what-is-technical-debt-and-how-can-you-avoid-it-in-salesforce) [ Learning from Rollup Helper’s Supportive Trailblazer Community ](https://www.passagetechnology.com/passage-technology-blog/rollup-helpers-supportive-trailblazer-community-app-resources) [ Passage Technology News and Updates – Spring 2026 ](https://www.passagetechnology.com/passage-technology-blog/news-spring-2026) [ True Effectiveness with Salesforce Agentforce Requires Elevating Data Quality First ](https://www.passagetechnology.com/passage-technology-blog/true-effectiveness-with-salesforce-agentforce-requires-elevating-data-quality-first) [ Roll-up Solution When a Roll-up Summary Field Can't be Used ](https://www.passagetechnology.com/passage-technology-blog/roll-up-solution-when-a-roll-up-summary-field-can-not-be-used-and-process-builder-does-not-fire-on-delete) [ GDPR and Using the Salesforce Individual Object ](https://www.passagetechnology.com/passage-technology-blog/gdpr-and-the-using-the-salesforce-individual-object) [ Can’t Create Quote From Opportunity in Lightning Using New Quote Button? ](https://www.passagetechnology.com/passage-technology-blog/new-quote-button) [ Rollup Helper vs Declarative Lookup Roll-up Summaries (DLRS) ](https://www.passagetechnology.com/passage-technology-blog/rollup-helper-vs-declarative-lookup-roll-up-summaries-dlrs) [ Passage Technology News & Updates – Winter 2026 ](https://www.passagetechnology.com/passage-technology-blog/passage-technology-news-updates-winter-2026) © 2026 Passage Technology LLC All Rights Reserved. [Privacy Policy](https://www.passagetechnology.com/privacy-policy) | [Purchasing & Legal](https://www.passagetechnology.com/purchasing-and-legal) | [Terms of Service](https://www.passagetechnology.com/terms-of-service) | [App Security](https://passagetech.my.site.com/KnowledgeBase/s/article/Security-and-Privacy-Policy-1578080055496) - [** ](https://www.facebook.com/passagetech) - - [** ](https://www.linkedin.com/company/passage-technology) - [** ](https://www.youtube.com/channel/UCK2tzaCWVC7PmFCXrLirnZw) ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Carrie Brown", "url" : "https://www.passagetechnology.com/passage-technology-blog/author/carrie-brown" }, "dateModified" : "2024-06-12T18:07:57.381Z", "datePublished" : "2024-04-10T15:35:10.000Z", "headline" : "Harmonizing Data to Get a Single, Unified View of Customers", "image" : [ "https://www.passagetechnology.com/hubfs/Hamonizing%20Data%20image.png" ], "mainEntityOfPage" : { "@id" : "https://www.passagetechnology.com/passage-technology-blog/harmonizing-data", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://www.passagetechnology.com/hubfs/Logo%20PT_colors_wide_on-white.png" }, "name" : "Passage Technology LLC" } } ```