Campaign members | Adobe Experience League Community
Skip to main content
Stephanie_Gilb1
Stephanie_Gilb1
Level 2
February 26, 2018
Question

Campaign members

  • February 26, 2018
  • 11 replies
  • 5322 views

Good afternoon all!

I am hoping someone can point me in the right direction.  Our SFDC instance is greatly over its storage and our campaign members are the cause.  What I am hoping to do is delete close to 2million campaign members out of SFDC but NOT out of Marketo.  The documentation I am finding is showing how to delete a member or 2 not a mass.  Has anyone else dealt with this issue and if so can you please tell me what you did to resolve this issue.

Thanks!!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

11 replies

A
Anonymous
February 26, 2018

Deleting contacts/leads from Salesforce does not automatically delete them from Marketo. See documentation here: SFDC Sync: Deleting a Lead/Contact - Marketo Docs - Product Documentation

In terms of deleting people en masse from Salesforce, work with your Salesforce admin, if you have one, and it should be easy for them to remove records. If you are deleting that many records you should do it directly from Salesforce.

Amanda_Thomas6
Amanda_Thomas6
Level 8
February 26, 2018

Hi Stephanie,

We created a custom checkbox field called Marketo Auto Sync. Then we set up a custom filter on our sync (open a ticket with support) that only allows those with Marketo Auto Sync = True sync back and forth. Then, you can implement your rules around who gets the value = true within Marketo and within Salesforce.

In your case, you can do the same for clean up, after creating the custom field and applying the custom sync filter with support, mark the leads with Marketo Auto Sync false in Marketo, then remove them from Salesforce. That way it doesn't try to create them again when syncing to Salesforce.

Hope that helps.

Grégoire_Miche2
Grégoire_Miche2
Level 10
February 26, 2018

Hi Geoffrey and Amanda,

I am quite sure that the issue is not about stopping sync'ing leads here

@Stephanie Gilbert

Getting a SFDC instance cluttered with campaign members is a frequent issue. This happens often when you sync programs with campaigns and have a lot of program members.

There are ways to resolve your issue, depending on whether or not your campaigns are synchronized with programs or not.

If the campaigns are not sync'ed with programs, go ahead, deactivate the campaigns in SFDC (field active = False) and delete the campaign members from SFDC.

If the campaigns are sync'ed with programs, this will be much longer. you will have to go to each program and click the SFDC campaign sync and set it back to"none" to stop the sync. The you can go to SFDC and delete the campaign members. Bdetter also to deactivate the campaigns as well.

And vote here :

-Greg

    Stephanie_Gilb1
    Stephanie_Gilb1Author
    Level 2
    February 27, 2018

    Well, there is another question now.

    We need to delete campaign members in SFDC but my fear is that if we delete them, will they also be deleted in Marketo. Now in addition to that, if we delete them in SFDC, since we have the sync set up, will the sync happen again. Meaning, after we delete them out of SFDC and they aren’t deleted Marketo, will the sync just push them back?

    Kevin_McMahon1
    Kevin_McMahon1
    Level 4
    February 27, 2018

    From what I'm understanding you do not simply want to remove the leads from an SFDC campaign, but instead want to delete them from your entire SFDC instance.

    This can be done easily from within Marketo. Create a smart campaign and use the flow step Delete Person from SFDC. Make sure to set the Delete from Marketo to FALSE. This will make sure they are only deleted from SFDC.

    Note: If there is an update in Marketo to any of those deleted, they will sync back to Salesforce

    Terms & ConditionsAccessibility statement

    Loading footer...