How To Bulk Create Campaign Member Statuses in Salesforce


Standard campaign statuses are essential to have consistent reports within Salesforce, but there’s no easy way to bulk create new statuses within the UI. In this tutorial, I’ll show you how to bulk create campaign member statuses in Salesforce using the Data Loader.

Pull a campaign report

The first step is to create a Salesforce report of all the campaigns you want to update. You will need all the campaign IDs as well as the campaign type (online advertising, webinar, email blast, etc) if you want to update the statuses based on campaign type. Export the report as a CSV file.

Prep the CSV file

Next, you need to prep your CSV file for upload. The Campaign Member Status object contains 5 fields:

  1. Campaign ID
  2. Responded (True or False)
  3. Is Default (True or False)
  4. Member Status (Text)
  5. Sort Order (Number)

I recommend using all 5 of these fields, but only Campaign ID and Member Status will be required to create the statuses.

Here’s an example of a file that is ready to be uploaded.

Upload Using Data Loader

If you don’t already have Data Loader installed on your computer, login to your Salesforce instance navigate to setup and search Data Loader using the quick find. Follow the instructions to install Data Loader on your computer.

Once you have Data Loader installed, you can upload your campaign member statuses. To do this, click on the Insert button and login using your Salesforce credentials. When prompted to select your Salesforce data object, check “Show all Salesforce objects” and select Campaign Member Status as your object.

Select your CSV file and click next. Map the available fields to the columns in your CSV file and click next to start the import.


Send them to me via email, send me a tweet @jennamolby, or leave a comment

Related Posts

  • 15/03/2018
    Salesforce Certified Platform App Builder Practice Exam

    Ace your Salesforce Certified Platform App Builder exam by using this practice exam to test your knowledge. This practice exam contains 45 multiple choice questions and covers most of the topics on the Salesforce Certified Platform App Builder exam, including data modeling, security, process automation and business logic.

  • 28/02/2018
    How To Create Your First Survey Using Salesforce Surveys

    Salesforce Surveys is now available with the Spring ’18 release! This new feature allows you to create easy-to-use forms for collecting feedback and data by using a simple editor. All the survey data you collect is stored within your org. You can then use Salesforce to view survey data, create reports and dashboards, and share insights with your company. I’m going to walk through how to enable, customize and activate your first Salesforce Survey.

  • 14/02/2018
    How to Keep Salesforce Records From Syncing to Marketo

    There are many reasons why you would want to keep Salesforce leads or contacts out of Marketo. Maybe you are reaching your Marketo database limit and you want to remove anyone who you can no longer email (hard bounces). Or perhaps you have a bunch of leads or contacts in Salesforce without an email address, that are taking up space in your Marketo database. The bad news is that if you delete these people from your Marketo database, once the Salesforce sync runs, they will be added to your Marketo database again. The good news is there’s an easy way to keep Salesforce records from syncing to Marketo, using a custom sync rule.

Leave A Comment

Your email address will not be published. Required fields are marked *

About Me

Welcome to my blog, where I share, tips, tricks, thoughts and solutions that I learn in my daily life as a sales and marketing professional.


Most Commented
Popular Posts