Mass Delete Salesforce Campaign Members Using Data Loader

This article answers how to mass delete Campaign Members in Salesforce. To mass delete Campaign Members, use Data Loader by following the three phases below.

Phase 1: Back Up Your Campaign Member Data (Recommended)

1. Open Data Loader and select Export.
2. Log in to Salesforce.
3. Select Show All Salesforce Objects and choose Campaign Members.
4. Click Next.
5. Select All fields.
6. Do not apply filters.
7. Complete the export and save the CSV file securely.

Phase 2: Prepare the Deletion File

Create a CSV file containing only the Campaign Members to delete. The required field is Campaign Member ID.

Option A: Prepare the File Using a Report

1. Run a Campaign Members report.
2. Apply filters to identify members to delete.
3. Include the Campaign Member ID field.
4. Export the report as a CSV file.

Option B: Prepare the File Using Data Loader

1. Open Data Loader and select Export.
2. Choose Campaign Members.
3. Select the ID field.
4. Apply filters (for example, CampaignId equals a specific Campaign ID).
5. Export the file.

Validate the CSV file to ensure only intended records are included.

Phase 3: Execute the Mass Delete

1. Open Data Loader and select Delete.
2. Log in to Salesforce.
3. Select Show All Salesforce Objects and choose Campaign Members.
4. Upload the CSV file created in Phase 2.
5. Map the ID field to Campaign Member ID.
6. Choose a location to save success and error logs.
7. Confirm and execute the deletion.

What the Mass Delete Does

This process deletes Campaign Member records and removes the association between Leads or Contacts and the Campaign.