How do I mass update member status in SFDC? | Community
Skip to main content
Level 2
March 18, 2015
Solved

How do I mass update member status in SFDC?

  • March 18, 2015
  • 4 replies
  • 2562 views
I just completed syncing leads from a webinar into SFDC.  I forgot to add the member statuses of attendeed and no show in the SFDC campaign before syncing, so when the leads synced, they went in with the default status of "sent".  The status in Marketo is showing correctly.  Is there a way to mass update the leads so the status is listed correctly in SFDC?
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by
Hi Erin, 

Yes I would suggest setting up the batch campaigns as smart campaigns within the program. 

Use the "Member of Program" filter with a status constraint -- one for each status you want to correct, to keep it simple. Then in the flow step, Change Status in SFDC Campaign to the matching status as in your smart list. 



 

4 replies

March 18, 2015
If you use Marketo to create the SFDC campaign, then it will automatically sync over all the statuses of the program channel for you. 

Sounds like in this case you synced the program with an existing campaign. In that case you can manually add the exact matching statuses to the SFDC campaign, then run some batch campaigns in Marketo to update status. 

E.g., if program status is x, update status in SFDC campaign to = x. 
Level 2
March 18, 2015
Justin,
Thank you for the quick reply. Yes, I synced the program with an existing campaign.  Would I set up this batch campaign as a smart campaign within the program? Also, I am only seeing "program status was changed" as an option in the smart list. Sorry if this seems elementary, I am taking over for our previous admin and I don't have a ton of experience.
Accepted solution
March 18, 2015
Hi Erin, 

Yes I would suggest setting up the batch campaigns as smart campaigns within the program. 

Use the "Member of Program" filter with a status constraint -- one for each status you want to correct, to keep it simple. Then in the flow step, Change Status in SFDC Campaign to the matching status as in your smart list. 



 
Level 2
March 18, 2015
Thank you!