Mass Remove Campaign Members - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Isaac LewisIsaac Lewis 

Mass Remove Campaign Members

I found the following help article from Salesforce to mass-remove campaign members from a campaign (https://help.salesforce.com/HTViewHelpDoc?id=campaigns_deletewizard.htm&language=en_US), but I can't find this feature anywhere in our implementation, nor can I find anyone talking about it online!

Do any of you know how to use this feature to mass remove campaign members?


subramani Jsubramani J
Hi,

Create a Campaign with Campaign Members report that returns the campaign members in question. Include the Campaign Member ID. Export the report as a CSV file and then use this to run a delete against SFDC using Data Loader. If you cannot use Data Loader, you can use something like Informatica Data Loader.



Here are some Data Management Options that you can use.

Apex Data Loader - for Enterprise, Unlimited and Developer Editions:
http://wiki.developerforce.com/index.php/Apex_Data_Loader

Starfish ETL:
http://www.starfishetl.com/

Informatica Data Loader - for Professional, Enterprise, Unlimited and Developer Editions:
http://appexchange.salesforce.com/listingDetail?listingId=a0N300000016cUTEAY

Excel Connector - for Professional, Enterprise, Unlimited and Developer Editions:
http://wiki.developerforce.com/index.php/Force.com_Excel_Connector

Workbench:
https://workbench.developerforce.com/

if it helps mark best Answer make others will use this..:)

Regards
Subra
subramani Jsubramani J
Although there is no mass delete function for Campaign Members in the Salesforce CRM GUI,

you can mass delete via the Data Loader.  This functionality is available to Enterprise and Unlimited users.


Campaign Members - both Leads and Contacts - do not show up as related list or field in GUI.

IMPORTANT: To obtain the Campaign Member ID, you cannot run a Contact or Lead report. Likewise do not export Contacts or Leads using Data Loader.

Instead, run a Campaign Member Report or do a Data Loader export of the Campaign Members to get a list of Campaign Member Id's, which then you can use the Data Loader to delete.

**For instructions on how to run the Campaign Member report, or how to create a custom link to show each Campaign's members (if it hasn't already been added to the Campaign page layout), search the Help & Training for Solution 00003483 "How do I get a list of Campaign members (contacts and leads)?"**


How it works: Deleting a Campaign Member removes the association between the Lead/Contact record and the Campaign.

Always create a backup of your data before doing any mass deletes or updates.

Method 1 (using Campaign Member reports and Data Loader):
1) BACKUP - Make a backup of Campaign Members:
Data Loader > Export > Show All Objects > Campaign Members > Fields: Id, Campaign Id, or all fields
Determine SOQL condition such as Campaign Id <equals> (Campaign Id value), or export all records
**This backup can also be performed by exporting the Campaign Member report**

2) EXPORT
a) Navigate to the Campaign from which Members will be deleted
b) Click the "View All Campaign Members" link (if the Member ID column does not appear on the report, be sure to customize and add the Member ID column)
c) Export this report to a CSV file by clicking on the Export Details button.

3) Delete - Compile a list of the Campaign Members who should be deleted.  The Delete command will delete each Campaign Member listed in the file!
Data Loader > Delete > Show All Objects > Campaign Members
IMPORTANT: Map fields: Member Id (CSV file) to Id (Salesforce CRM Campaign Members object)


Method 2 (using only the Data Loader):
1) BACKUP - Make a backup of Campaign Members:
Data Loader > Export > Show All Objects > Campaign Members > Fields: Id, Campaign Id, or all fields
Determine SOQL condition such as Campaign Id <equals> (Campaign Id value), or export all records

2) EXPORT - Extract list of Campaign Member Id's for later update
Data Loader > Export > Show All Objects > Campaigns > Fields: Campaign Id, Campaign Member Id(s)
Determine SOQL condition such as Campaign Id <equals> (Campaign Id value), or export all records

3) Delete - Compile a list of the Campaign Members who should be deleted.  The Delete command will delete each Campaign Member listed in the file!
Data Loader > Delete > Show All Objects > Campaign Members
IMPORTANT: Map fields: Campaign Member Id (CSV file) to Id (Salesforce CRM Campaign Members object)
Brad FordBrad Ford
I stumbled accross this post as I had the same question. 

The only way to access this 'mass remove campaign members' feature referenced by the original poster is to enable 'accessibility mode' on the user's profile.