Petavue, run a duplicate-detection scan across our CRM and deliver a consolidated report:
- Detection Criteria
-
Leads & Contacts
- Exact email matches (lowercased)
- Fuzzy name matches (Levenshtein distance ≤ 2 on first + last name)
-
Accounts
- Normalized domain grouping
- Report Outputs
-
Duplicate Group Count by object (Leads, Contacts, Accounts)
-
Sample Record IDs for each group
-
Recommended Master-record Logic (e.g., “keep the record with the most recent activity”)
-
Estimated % Reduction in total records if merged
Based on the duplicate analysis of Lead, Contact, and Account objects, recommend cleanup and prevention actions using:
-
Salesforce or HubSpot for email-based deduplication and merge rules, domain-based Account merge logic, matching workflows
-
Slack to alert Ops or Marketing teams when a duplicate is detected
What This Prompt Does
This prompt identifies and quantifies duplicate records across Leads, Contacts, and Accounts, focusing on duplicate emails, same-name variations, and inconsistent account naming by domain. It recommends deduplication logic based on email, domain, or fuzzy matching rules, and suggests automation to alert Ops or Marketing teams when duplicates are detected. The result is a clear picture of duplication risk and practical guidance to clean it up and prevent recurrence.
Strategic Impact
Duplicate records quietly undermine GTM effectiveness by distorting conversion data, creating misalignment between teams, and leading to redundant outreach. This prompt restores trust in CRM data by helping teams detect and eliminate duplicates at the source. Business outcomes:
-
Reduces CRM clutter and improves attribution accuracy across the funnel
-
Eliminates redundant prospect outreach and improves SDR productivity
-
Enables cleaner segmentation and scoring logic for marketing campaigns
-
Powers reliable lifecycle workflows and reporting for downstream automation