)
Written by
Table of Contents
“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”
Salesforce native account merge has significant data retention limitations that can result in permanent data loss. All custom field values from the losing account are deleted, with no recovery options through the Recycle Bin or field history tracking.
Here’s a comprehensive breakdown of these limitations and how to overcome each one with automated backup solutions.
Overcome every Salesforce merge limitation with comprehensive data preservation using Coefficient
Coefficient provides powerful solutions to overcome each of Salesforce’s merge limitations, ensuring no valuable data is ever lost during account consolidation processes.
How to make it work
Step 1. Preserve all custom field values with automated backups.
Import all accounts before merges using Salesforce “From Objects & Fields” and create snapshots of custom fields from both records. Build preservation matrices and export critical loser data to master accounts post-merge, completely solving the custom field loss limitation.
Step 2. Create comprehensive audit trails for merge history.
Build merge history logs in spreadsheets that track all Account IDs, dates, and users. Use Coefficient’s Append feature for running audit trails and export audit data to custom Salesforce objects, providing the merge history that Salesforce doesn’t maintain natively.
Step 3. Document child record relationships before re-parenting.
Import Opportunities, Contacts, and Cases to document current parent relationships. Create re-parenting impact analysis and preserve original associations, maintaining context that Salesforce loses when child records are automatically moved to the master account.
Step 4. Backup system field information for historical accuracy.
Capture CreatedDate, CreatedBy, and LastModifiedDate from both accounts. Store this information in custom fields like “Original_Created_Date__c” and maintain ownership history, preserving system information that Salesforce overwrites during merges.
Step 5. Enable selective field retention with intelligent mapping.
Import both accounts side-by-side to choose the best value for each field. Apply business rules for conflicts and export optimal combined datasets, overcoming Salesforce’s all-or-nothing approach with intelligent field selection capabilities.
Eliminate merge data loss forever
By leveraging Coefficient’s import, snapshot, and export capabilities, you can completely mitigate Salesforce’s native merge data retention limitations and ensure no valuable data is ever lost. Ready to protect your merge data? Build your comprehensive backup system today.
