--- title: "USE CASE: Finding and Fixing Duplicate Activities in Salesforce | Data Quality Helper Use Case Library" description: Data Quality Helper allows the use of enhanced duplication rules to better manage the discovery and resolution of duplicate Activity records. image: https://lh6.googleusercontent.com/H484ruk9yETIvvRenFQTa4IdP5x0tRZDft8ye299WO7zdBAbb-W-9oDhTDEVoyxEgZnaTbUG7MP8wvPtY4I2w9zCjtyxTUSBtkvwK_LHEOH3nKZbVyuv04OnAdKhMTqJoUM7KhpPPCXJ-qI69Rla5KQ --- [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) # USE CASE: Finding and Fixing Duplicate Activities in Salesforce [![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) ## **Problem: Users need to identify duplicate Activities and reconcile the data** Activities is an unusual “Object” in Salesforce. It serves as an umbrella Object that actually includes a number of engagement Objects: Tasks, Events, and Calendars. It allows you to track Tasks and Meetings in lists and reports, giving you a comprehensive view of all the various interactions you may have with all Accounts, Campaigns, Contacts, Leads, and Opportunities. However, prioritizing and managing your time becomes more difficult if duplicate records are included within an Activities Object, or if the Activities record itself has duplicates. Data may be incomplete or scattered among the different records. Calendars may not be up-to-date, and important updates may not be easily available. With so many moving parts in Activities, it is important the data is of the highest quality—and that means no dupes. ## **Solution: Automatically notify users of the duplicate Activities and empower them to correct the situation** One sign of potentially duplicate Activities is records with a similar subject and same start/end/due dates. This can be difficult to discover manually, without being directly notified of it when a record is viewed, created, or modified. Using the Free Edition of the [Data Quality Helper](https://www.passagetechnology.com/data-quality-helper-overview) app, an Admin can easily set a similarity percentage threshold that will detect records with similar field values for specified fields, which then displays an alert on the record with the potential duplicates. In response, users can quickly review the potential duplicates’ details. If users determine action is needed, they can use the app’s functionality to merge the information from the duplicates into one corrected record. Salesforce default functionality doesn’t allow flexible duplicate detection and customized resolution—no adjustable duplicate sensitivity settings are available, not all objects are assessed, and the merging of data on duplicate records is limited. With the added functionality of Data Quality Helper, Admins have more flexibility to design unique [duplication rules](https://www.passagetechnology.com/data-quality-helper-merging-and-eliminating-duplicate-records-in-salesforce) that better serve organization goals across a number of situations, beyond this duplicate Activities example. (Check out the [Data Quality Helper Admin Guide](https://www.passagetechnology.com/data-quality-helper-admin-guide) for step-by-step instructions on how to set up duplication rules.) ![Detecting duplicate Activities](https://lh6.googleusercontent.com/H484ruk9yETIvvRenFQTa4IdP5x0tRZDft8ye299WO7zdBAbb-W-9oDhTDEVoyxEgZnaTbUG7MP8wvPtY4I2w9zCjtyxTUSBtkvwK_LHEOH3nKZbVyuv04OnAdKhMTqJoUM7KhpPPCXJ-qI69Rla5KQ) This alert says: “Potential Duplicates Found. If the list below contains duplicate records, select all of the records to merge, then click the ‘Next’ button.” In this particular example, the rule is looking for duplicate records on the Task object using the Subject and Activity Date fields. Here, one Task is listed as a potential duplicate. - If any of the records in the list of potential duplicates are identified as non-duplicates, simply click the dropdown menu in the Action column and click the ‘Mark As Non-Duplicate’ menu item, or click the ‘View Record’ menu item if more information is needed about the record. - Once the duplicate records have been identified, select them before clicking ‘Next,’ which will start the merging process where a user can select the fields that require updates. Note: Merge functionality is only supported on the detail page component for Activity objects (not during edit/creation process). Ideally, you want to streamline duplicates and consolidate information into one record. However, in some situations, a user may want to mark records that look similar as non-duplicates, or maybe they would like to manually adjust field values during the merge of duplicate records (unlike with default Salesforce’s less flexible duplicate resolution functionality). The merge choices should belong to Admins, users, and the organization—not to the Salesforce platform. The good news is that, with Data Quality Helper, unresolved duplicate issues are easy to find at any time using the ‘Data Quality Helper Issues’ home page component. The component may be used as a reminder to find and merge duplicate records when users have availability. *Besides duplicate data detection and resolution, this app also offers enhanced data validation as well as data archival and storage management that exceeds default Salesforce functionality. Plus, the home page component also shows all unresolved validation issues detected by the rules Admins created. Install the free version today!* [![Schedule Demo/Consult](https://no-cache.hubspot.com/cta/default/4130736/cf86c8e7-57d0-4596-af6c-780532d84bf9.png)](https://cta-redirect.hubspot.com/cta/redirect/4130736/cf86c8e7-57d0-4596-af6c-780532d84bf9) [![Install Free App Now](https://no-cache.hubspot.com/cta/default/4130736/75b1670b-97a2-4c85-9ab3-99e04453aaf3.png)](https://cta-redirect.hubspot.com/cta/redirect/4130736/75b1670b-97a2-4c85-9ab3-99e04453aaf3) Tags: [Activity Monitoring](https://www.passagetechnology.com/data-quality-helper-use-cases/topic/activity-monitoring), [Data Quality Helper](https://www.passagetechnology.com/data-quality-helper-use-cases/topic/data-quality-helper), [duplicate records](https://www.passagetechnology.com/data-quality-helper-use-cases/topic/duplicate-records), [merging data](https://www.passagetechnology.com/data-quality-helper-use-cases/topic/merging-data) | [** USE CASE: 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) | [Data Quality Helper Use Case Library](https://www.passagetechnology.com/data-quality-helper-use-cases) | [ USE CASE: Preventing Short or Vague Record Names in Salesforce ** ](https://www.passagetechnology.com/data-quality-helper-use-cases/preventing-short-or-vague-record-names-in-salesforce) | | --- | --- | --- | [ USE CASE: Ensuring All Salesforce Phone Number Fields Are Consistent in Format ](https://www.passagetechnology.com/data-quality-helper-use-cases/use-case-ensuring-all-salesforce-phone-number-fields-are-consistent-in-format) [ USE CASE: Mass Delete Old, Unneeded Marketing Data (Clicks & Opens) ](https://www.passagetechnology.com/data-quality-helper-use-cases/mass-delete-old-unneeded-marketing-data) [ USE CASE: Manage Storage Better by Recycling Unneeded, Archived Calls ](https://www.passagetechnology.com/data-quality-helper-use-cases/manage-storage-better-by-recycling-unneeded-archived-calls) [ USE CASE: Streamline Storage of Automated Emails Used by Salesforce ](https://www.passagetechnology.com/data-quality-helper-use-cases/streamline-storage-of-automated-emails-used-by-salesforce) [ USE CASE: Keep It Clean—Mass Delete Old Synced Tasks in Salesforce Org ](https://www.passagetechnology.com/data-quality-helper-use-cases/keep-it-clean-mass-delete-old-synced-tasks-in-salesforce-org) [ USE CASE: Ensuring All Salesforce Phone Number Fields Are Consistent in Format ](https://www.passagetechnology.com/data-quality-helper-use-cases/use-case-ensuring-all-salesforce-phone-number-fields-are-consistent-in-format) [ USE CASE: Finding and Fixing Duplicate Cases in Salesforce ](https://www.passagetechnology.com/data-quality-helper-use-cases/finding-and-fixing-duplicate-cases-in-salesforce) [ USE CASE: Finding and Fixing Duplicate Opportunities in Salesforce ](https://www.passagetechnology.com/data-quality-helper-use-cases/finding-and-fixing-duplicate-opportunities-in-salesforce) [ USE CASE: Ensuring Reasons Lost Are on Closed Salesforce Opportunities ](https://www.passagetechnology.com/data-quality-helper-use-cases/ensuring-reasons-lost-are-included-on-closed-lost-opportunities-in-salesforce) [ USE CASE: Mass Delete Old Emails, Auto-Responses & Case Email Messages ](https://www.passagetechnology.com/data-quality-helper-use-cases/mass-delete-old-emails-auto-responses-case-email-messages) © 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" : "Passage Technology", "url" : "https://www.passagetechnology.com/data-quality-helper-use-cases/author/passage-technology" }, "dateModified" : "2025-10-10T18:34:48.279Z", "datePublished" : "2023-06-26T15:15:40.000Z", "headline" : "USE CASE: Finding and Fixing Duplicate Activities in Salesforce", "image" : [ "https://lh6.googleusercontent.com/H484ruk9yETIvvRenFQTa4IdP5x0tRZDft8ye299WO7zdBAbb-W-9oDhTDEVoyxEgZnaTbUG7MP8wvPtY4I2w9zCjtyxTUSBtkvwK_LHEOH3nKZbVyuv04OnAdKhMTqJoUM7KhpPPCXJ-qI69Rla5KQ" ], "mainEntityOfPage" : { "@id" : "https://www.passagetechnology.com/data-quality-helper-use-cases/finding-and-fixing-duplicate-activities-in-salesforce", "@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" } } ```