Individual Email Results in Salesforce CRM are the bridge between Marketing Cloud sends and the Contact or Lead records that sales teams rely on daily. They record what was sent, when it was opened, and whether it was clicked — all visible right on the Contact page without needing to log into SFMC.

The gap that most teams run into: IER records do not automatically carry CampaignMemberId or CampaignId when a send originates from a Journey Builder campaign injection. Both fields exist on the IER object — CampaignMemberId is even a standard field — but they stay empty unless you explicitly build the plumbing to carry those values from the moment of send through to the CRM record update.

This guide covers the exact pattern that works: capture the values at send time using the Send Log, join the IER data view against the Send Log with the correct key combination, and update the IER records in CRM via a Journey Object Activity. We have implemented this for clients who needed their sales teams to be able to filter and report on email activity tied to specific Salesforce campaigns directly from CRM.

Individual Email Results on a Salesforce Contact — CampaignMemberId and CampaignId linking each send back to the originating Campaign.

Understanding Why the Fields Do Not Populate Automatically

When Marketing Cloud Connect creates an IER record in Salesforce after a Journey Builder send, it uses the data available in SFMC’s tracking layer. That layer knows about the send — the email, the subscriber, the job — but it does not inherently know which Salesforce Campaign or Campaign Member triggered the journey entry. That context exists in your Journey entry Data Extension, not in the tracking data views.

The IER object in Salesforce has these relevant fields:

The Four-Part Pattern

The implementation runs across four components that must be set up in sequence. Each one hands off context to the next — if any link in the chain is missing, the values will not reach the IER record in CRM.

All Send Log fields must be nullable with no primary key. If your Send Log does not exist yet, create it from the template in the Data Extension creation flow under “Create From Template” and select SendLog.

%%[

/* These variable names match the Send Log field names exactly.
   SFMC automatically writes their values to the Send Log at send time.
   No output is needed — this block runs silently. */

VAR @CampaignMemberId, @CampaignId

/* Pull values from the Journey entry Data Extension */
SET @CampaignMemberId = AttributeValue("CampaignMemberId")
SET @CampaignId       = AttributeValue("CampaignId")

]%%

/* Joins the Send Log (with captured Campaign values) to the IER data view.
   The four-column join key is critical — using SubscriberKey alone will
   create incorrect matches across multiple campaign sends to the same contact.
   Run daily. Action: Overwrite on Update_IER_DE. */

SELECT
    sl.SubscriberKey,
    sl.CampaignMemberId,
    sl.CampaignId,
    ier.ID              AS IER_MergeID,    /* This is the unique IER record ID in Salesforce */
    sl.JobID,
    sl.BatchID,
    sl.ListID,
    sl.EmailAddress

FROM
    SendLog_DE          sl     /* Replace with your Send Log DE name */

JOIN
    _IndividualEmailResult  ier

    ON  sl.JobID         = ier.JobID
    AND sl.BatchID       = ier.BatchID
    AND sl.ListID        = ier.ListID
    AND sl.SubscriberKey = ier.SubscriberKey    /* All four required */

WHERE
    sl.CampaignMemberId IS NOT NULL
    AND sl.CampaignId   IS NOT NULL
    AND ier.ID          IS NOT NULL    /* Ensures IER record exists in CRM */
    AND sl.LogDate      >= DATEADD(day, -1, GETDATE())  /* Incremental daily run */

The Update_IER_DE staging DE should be sendable, with IER_MergeID as the primary key. The Journey Builder Object Activity will use this field to find the correct IER record in Salesforce and update it.

Automation Studio SQL Query Activity — the four-column join on JobID, BatchID, ListID, and SubscriberKey is what correctly links each Send Log entry to its corresponding IER record in Salesforce.

Frequently Asked Questions