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

  • 27/10/2020
    How to Prevent Automatic Email Unsubscribes in Pardot

    The standard unsubscribe link in Pardot is a one-click unsubscribe link, meaning that once the link in the email is clicked, the prospect is unsubscribed automatically. While this makes it easy for the prospect to opt-out of your emails, it also makes it easy for spam filters to click this link and unsubscribe your prospect unintentionally. Unfortunately, there’s no way to customize the standard unsubscribe page to prevent this from happening, but you can create a preferences page and customize it to act like an unsubscribe page.

  • 15/10/2020
    How to Use Flex Fields in Pardot

    Flex fields are custom fields that can be used over and over again to limit the number of one-time-only fields within Pardot and Salesforce. They contain data that is required temporarily to execute a specific event or campaign. Once the data is no longer needed, the fields can be reset to blank using an Engagement Program or Automation Rule

  • 06/10/2020
    How to Automatically Create Campaign Member Statuses in Salesforce

    New campaigns in Salesforce have two default member status values: “Sent” and “Responded”. To customize the values, you can create them manually, set up “campaign templates” to copy the status values or bulk create the values using Data Loader. Now, thanks to one of the Summer ’20 updates, you can easily automate this process using only Salesforce Flow. In this post, I’ll show you how to use Salesforce Flow to create campaign member statuses automatically based on campaign type.

1 comment(s)
  • James

    07/01/2019 at 3:31 pm
    Reply

    Hey, great article. This will be really helpful thanks. Do you know of a way to pull a report to show Campaigns with all member statuses, and whether or not the status is default or responded? Thanks.

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 Marketing Operations leader.

Categories
Most Commented
Popular Posts