How To Bulk Create Campaign Member Statuses in Salesforce

In:

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.

Questions?

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

Related Posts

  • 06/12/2017
    Salesforce Certified Pardot Specialist Practice Exam

    Ace your Salesforce Certified Pardot Specialist exam by using this practice exam to test your Pardot knowledge. This practice test contains 50 multiple choice questions and covers most of the topics on the Salesforce Certified Pardot Specialist exam, including administration, scoring, lead management, engagement programs and integrations.

  • 30/11/2017
    12 Tools That Every Pardot User Should Know About

    Make your job (and life) easier by using one of these 12 tools I recommend for Pardot users. These tools will save you time and automate tasks such as sifting through hundreds of email replies once a big email campaign has gone out or automatically sending out your blog digest email.

  • 21/09/2017
    3 Free Pardot Landing Page Templates for Asset Downloads

    Create beautiful, responsive landing pages in Pardot by using one of these 3 free Pardot layout templates. These landing page templates are designed specifically for gated assets such as white papers and eBooks, but they will work well with any landing page that contains a form.

Leave A Comment

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

About Me

I am a results focused marketing automation expert, with a strong background in design and development. With a high level computer science background, I have the unique ability to design, code and understand data, while utilizing this skillset to further enhance my value and ROI in the digital marketing space.
LEARN MORE

Categories
Most Commented
Popular Posts