Understanding the Challenge

The main issue with migrating from email to SFID as the Contact Key is that it involves changing the unique identifier for each contact, which can lead to data inconsistencies if not done correctly.

When a contact’s Subscriber Key is updated, their tracking data, such as email opens, clicks, and other interactions, is tied to the old key, and updating this key without proper handling can result in data loss.

The root cause of the complexity in this migration is the way Salesforce Marketing Cloud stores tracking data, which is tightly coupled with the Subscriber Key, making it difficult to update the key without affecting the associated data.

Manual Approach Limitations

A manual approach to the migration can only create archives related to the old keys for reference, as it would require deletion of old records and creation of new ones, which does not preserve the tracking data on the same records.

Without the assistance of Salesforce Professional Services, teams can archive tracking data to Data Extensions (DEs) or a Data Warehouse (DWH), remove old subscribers, and create new subscribers with a foreign key allowing for a match to the archives.

Preserving Tracking Data with Professional Services

However, to truly migrate the Subscriber Key from email to SFID while keeping the tracking data intact and related to the new keys, the involvement of Salesforce Professional Services is necessary, as they have the tools and expertise to perform this complex operation without data loss.

This process, while effective, can be long and costly, highlighting the importance of careful planning and consideration before initiating such a migration.

Example SSJS for archiving

var customerKey = 'yourCustomerKey';
var dataExtension = DataExtension.Init(customerKey);
// Archive tracking data to DE

Heads up: Always back up your data before performing any migration to ensure data integrity and availability in case of unforeseen issues.

Conclusion and Next Steps

In conclusion, while parts of the migration from email to SFID as the Contact Key can be managed manually, preserving tracking data requires the expertise of Salesforce Professional Services.

Pre-Migration Checklist

• Assess current data structure and tracking data volume.
• Plan for data archiving if choosing a manual approach.
• Engage with Salesforce Professional Services for a guided migration if tracking data preservation is critical.
• Backup all data before initiating the migration process.
• Test the migration process in a sandbox environment before applying it to production.

What is the main challenge in migrating from email to SFID as Contact Key?

The main challenge is preserving the tracking data associated with the contacts without losing any information during the migration.

Can the migration be done entirely manually?

While some parts can be done manually, such as archiving tracking data, the complete migration with tracking data preservation requires Salesforce Professional Services.

What is the role of Salesforce Professional Services in this migration?

Salesforce Professional Services provides the necessary tools and expertise to migrate the Subscriber Key from email to SFID while preserving the tracking data, ensuring a seamless transition without data loss.

How long and costly is the migration process with Professional Services?

The duration and cost of the migration process can vary depending on the complexity of the data structure, the volume of tracking data, and the specific requirements of the migration, making it a significant undertaking for any organization.