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

  • Are you using Person Accounts? – Eliot Harper Aug 10 '17 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 Aug 10 '17 at 22:29
  • HI it is custom fields and it is not Person Accounts – Tove Walden Aug 11 '17 at 11:39

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 | |
  • 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 Aug 23 '17 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 Aug 23 '17 at 5:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.