1

We have a working connector between SF and MC. When an invitation is sent via email from Marketing Cloud to campaign members in Salesforce, we want the status to be updated from "Will be sent" to "Invitation sent".

It doesn't happen even thought we have this "Campaign member integration" covered.

I am generally not working in SF and I wonder - what am I missing?

Would it work to update the member status from the actual email (via ampscript)?

Thankful for some help

Improve this question
3
  • Are you using Person Accounts?
    – Eliot Harper
    Commented Aug 10, 2017 at 19:50
  • What Object is your Status field on? All depends what object you are wanting to update... Is it the standard Status field or a custom status field?
    – thechrishaddad
    Commented Aug 10, 2017 at 22:29
  • HI it is custom fields and it is not Person Accounts
    – Tove Walden
    Commented Aug 11, 2017 at 11:39

1 Answer 1

Reset to default
1

AMPscript may be the solution to your problem.

I guess that you are using the Contact (or Lead) IDs as Subscriber Keys (because you are using the connector to connect with SF).

Maybe you can use the AMPscript function UpdateSingleSalesforceObject to update the campaignMember. You need the ID of the corresponding campaignMember in order to update it (which you may retrieve with a lookup from an lead/contact ID in the campaignMember synchronized data extension).

%%[
set @result = UpdateSingleSalesforceObject("CampaignMember", "campaignMember ID here",
"Status", "Invitation sent"
)
]%%

I was not able to test the code as we do not have a Salesforce environment which uses campaignMember. So some changes may be needed.

A list of all Salesforce objects can be found here, including campaignMember.

Hope this helps.

Improve this answer
2
  • Hi, The code provided above can update the status while the email is being sent. Is there a way to update campaign member with statuses like 'Opened', 'Clicked', 'Bounced' etc. which happens after the email has gone out.
    – Sanchit Mittal
    Commented Aug 23, 2017 at 4:19
  • I think that updating open/click/bounce is not possible with AMPscript because it renders only at the moment of sending or viewing the online version
    – Wesley
    Commented Aug 23, 2017 at 5:57

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .