)
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.”
Field mapping issues prevent existing Salesforce contacts from appearing in imported list views because the import process treats all data as new records rather than recognizing existing ones. This typically stems from missing External ID configuration and incorrect unique identifier selection during the import process.
Here’s how to identify and fix the specific field mapping problems that cause existing contacts to be excluded from your list views.
Fix field mapping issues using Coefficient
Coefficient addresses these mapping challenges by providing sophisticated field matching and upsert capabilities with real-time validation, ensuring existing contacts are properly recognized and included in your list views.
How to make it work
Step 1. Analyze your current field mapping.
Import existing Salesforce Contact data to understand current field values and formats. Compare your Excel data formatting with Salesforce field requirements. Identify optimal matching fields beyond just Email, including Phone, External ID, and custom fields that could serve as unique identifiers.
Step 2. Configure advanced mapping with multiple identifiers.
Set up Coefficient export with proper field mapping: Email → Email (External ID) as primary matching field, Salesforce_Contact_ID__c → Id for direct ID reference when available, Phone → Phone as secondary matching option, and External_ID__c → Custom External ID field for complex matching scenarios.
Step 3. Implement upsert strategy.
Use UPSERT action instead of INSERT to handle existing records properly. Configure multiple External ID options for flexible matching and set up conditional field updates to preserve existing data integrity while incorporating new information from your Excel file.
Step 4. Address visibility and ownership mapping.
Map the Owner field correctly to ensure list view visibility. Handle Record Type assignments appropriately and configure sharing and visibility settings for imported records. Verify user permissions on existing contact records and check role hierarchy impacts.
Step 5. Validate mapping before execution.
Use Coefficient’s preview functionality to verify mapping before export. Test with small batches to confirm existing contacts are properly matched and validate that updated records appear in intended list views with proper field population.
Ensure existing contacts appear in your list views
This comprehensive field mapping strategy ensures existing Salesforce contacts are properly recognized, updated, and included in your imported list views rather than being bypassed. Fix your mapping issues and get complete list visibility.
