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
- Launch MCAE Lightning App
- Click App Launcher (grid icon)
- Search for “Pardot Lightning App”
- Navigate to Settings
- Select “Account Engagement Settings”
- Choose “Optimizer” tab
- 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):
- Select prospects to merge
- Designate primary record
- 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
- Implement Form Handlers with real-time duplicate checking
- Set Up CRM-Pardot Sync Rules to prevent creation of duplicates
- 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 🔔🔔
Who is Salesforce? Here is their story in their own words. From our inception, we've proudly embraced the identity of Read more
Salesforce Marketing Cloud Transactional Emails are immediate, automated, non-promotional messages crucial to business operations and customer satisfaction, such as order Read more
Salesforce has unveiled a comprehensive analytics solution tailored for wealth managers, home office professionals, and retail bankers, merging its Financial Read more
AI plays a crucial role in propensity score estimation as it can discern underlying patterns between treatments and confounding variables Read more
