Understanding the Issue

The problem lies in the way the data is structured in the Lead_Salesforce_8 data extension. The “Id” field is mapped to the lead ID, and the “Contactkey” field is also mapped to the lead ID initially. After the lead is converted, the “Contactkey” field is updated to the Contact ID, but the Subscriber key remains the same.

The root cause of this issue is that the Subscriber key is not updated when the lead is converted. This causes the email to be sent to the wrong address, as the Subscriber key is still mapped to the lead ID.

Solution

To fix this issue, the Subscriber key needs to be updated to the Contact ID when the lead is converted. This can be done by using a Foreign key to store the email ID of the Contact and then sending the email to the new email ID.

SFMC SQL Query

UPDATE Lead_Salesforce_8
SET SubscriberKey = ContactID
WHERE IsConverted = True

Alternatively, the email can be sent to the Contact email address by using an AMPscript to retrieve the Contact email address and then sending the email to that address.

Best Practices

To avoid this issue in the future, it is recommended to use a Foreign key to store the email ID of the Contact and then send the email to the new email ID. This way, when a lead is converted, the email will be sent to the correct address.

Heads up: Make sure to update the Subscriber key when a lead is converted to ensure that emails are sent to the correct address.

Checklist

• Verify that the Subscriber key is mapped to the lead ID
• Verify that the Contact ID is stored in the Lead_Salesforce_8 data extension
• Verify that the email address is stored in the Contact object
• Verify that the Foreign key is set up to store the email ID of the Contact
• Verify that the AMPscript is set up to retrieve the Contact email address
• Test the email sending process to ensure that emails are sent to the correct address

Frequently Asked Questions

What is the Subscriber key?

The Subscriber key is a unique identifier used to identify the recipient of an email in SFMC.

How do I update the Subscriber key?

The Subscriber key can be updated by using a SQL query to update the SubscriberKey field in the Lead_Salesforce_8 data extension.

What is a Foreign key?

A Foreign key is a field that stores the ID of a related object, in this case, the Contact ID.

How do I set up an AMPscript to retrieve the Contact email address?

An AMPscript can be set up to retrieve the Contact email address by using a SQL query to retrieve the email address from the Contact object.