)
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 merge operations follow a strict “master wins all” approach where only the master account’s field values survive. All custom fields, field history, and system information from the losing account are permanently deleted without any selective retention options.
Here’s exactly which fields are retained versus lost, plus how to analyze and document these patterns for better merge planning.
Analyze field retention patterns and preserve critical data using Coefficient
Coefficient transforms Salesforce’s “black box” merge process into a transparent operation where you can predict, document, and control exactly which data survives the merge process.
How to make it work
Step 1. Import both accounts for side-by-side field comparison.
Create a Salesforce import using “From Objects & Fields” for the Account object. Select ALL fields (standard and custom) and filter using Account IDs to pull both the master and loser accounts into the same sheet for direct comparison.
Step 2. Build a field retention analysis matrix.
Create columns for Field Name, Master Account Value, Loser Account Value, Will Be Retained (formula: =IF(B<>“”,”Yes”,”No”)), and Data Loss Risk (formula: =IF(AND(C<>“”,B<>C),”HIGH”,”Low”)). This shows exactly which data will survive the merge.
Step 3. Set up automated field loss detection.
Apply conditional formatting to highlight fields with different values between accounts. Create a “Fields to Be Lost” summary using formulas that automatically identify populated custom fields in the loser account that will be permanently deleted.
Step 4. Generate comprehensive merge impact reports.
Build sections showing fields with data loss, data quality comparisons, integration dependencies, and risk assessment scores. Include relationship impacts like child records that will be re-parented and related list implications.
Step 5. Create post-merge verification workflows.
After completing merges, import the merged account and compare against your pre-merge snapshot. Identify any unexpected data loss and use Coefficient’s export functionality to restore critical values that should have been preserved.
Take control of your merge process
Understanding field retention patterns helps you make informed merge decisions and preserve critical data before it’s lost forever. Ready to analyze your merge impact? Start building your field analysis system today.
