The Essential Guide to the Find & Merge Tool

Why Duplicate Management Matters

Maintaining a pristine prospect database is critical for:
✔ Accurate lead scoring and grading
✔ Personalized marketing campaigns
✔ Reliable reporting and analytics
✔ Efficient sales outreach

The Find and Merge Duplicate Prospect Records tool provides a systematic approach to cleaning your Marketing Cloud Account Engagement, formerly known as Pardot, database while preserving all valuable prospect information.

Step-by-Step Walkthrough

1. Accessing the Tool

1. Launch MCAE Lightning App
   • Click App Launcher (grid icon)
   • Search for “Pardot Lightning App”
2. Navigate to Settings
   • Select “Account Engagement Settings”
   • Choose “Optimizer” tab
3. Locate Duplicate Review
   • Scroll to “Review Duplicate Prospects” section

Pro Tip: Bookmark this location for regular database maintenance.

2. Reviewing Potential Duplicates

The system automatically identifies duplicates based on:

• Email addresses (primary matching criteria)
• Additional configurable matching rules

Review Interface Shows:

• Total duplicate groups found
• Number of records in each group
• Last activity date for each prospect

3. Taking Action

Merge Options:

• Standard Merge (2-3 records):
  1. Select prospects to merge
  2. Designate primary record
  3. Confirm field-level mappings
• Bulk Actions:
  • Export list for external review
  • Mass delete unneeded records

Critical Considerations:

• Merged activities combine into primary record
• Custom field values may require manual review
• Automation rules will apply post-merge

Best Practices for Effective Deduplication

Prevention Strategies

1. Implement Form Handlers with real-time duplicate checking
2. Set Up CRM-Pardot Sync Rules to prevent creation of duplicates
3. Use API Best Practices for data imports

Maintenance Routine

• Weekly: Review high-priority duplicates (active prospects)
• Monthly: Full database audit
• Quarterly: Evaluate matching rules effectiveness

Advanced Configuration Options

Custom Matching Rules

Enhance duplicate detection by configuring additional match criteria:

• Company domain analysis
• Phone number standardization
• Name similarity algorithms

Automation Integration

• Trigger workflows after merge completion
• Notify sales teams of merged accounts
• Update lead scores post-consolidation

Troubleshooting Common Issues

Problem: Missing duplicate groups
Solution: Verify email normalization settings

Problem: Merge failures
Solution: Check for required field conflicts

Problem: Lost activity history
Solution: Always review activity timeline before merging

Measuring Success

Track these key metrics:

• % reduction in duplicate records
• Improvement in email deliverability rates
• Increase in lead scoring accuracy
• Time saved in sales prospecting

“Companies that implement regular deduplication see 23% higher email engagement rates.” – Pardot Benchmark Report

🔔🔔  Follow us on LinkedIn  🔔🔔

Related Posts

AI Automated Offers with Marketing Cloud Personalization

AI-Powered Offers Elevate the relevance of each customer interaction on your website and app through Einstein Decisions. Driven by a Read more

Salesforce OEM AppExchange

Expanding its reach beyond CRM, Salesforce.com has launched a new service called AppExchange OEM Edition, aimed at non-CRM service providers. Read more

The Salesforce Story

In Marc Benioff's own words How did salesforce.com grow from a start up in a rented apartment into the world's Read more

Salesforce Jigsaw

Salesforce.com, a prominent figure in cloud computing, has finalized a deal to acquire Jigsaw, a wiki-style business contact database, for Read more