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.

The example

In this post, I’ll be using Salesforce Flow to create the following statuses based on campaign type.

Campaign TypeCampaign Member Status
Online Advertising
  • Clicked
  • Converted
Email
  • Sent
  • Opened
  • Clicked
  • Unsubscribed
Webinar
  • Invited
  • Registered
  • Attended
  • No Show

 

Prerequisites

I recommend you map out what status values you want to use for each campaign type as well as which statuses should be marked as default and responded before creating your flow.

Create the flow

Navigate to Setup > Process Automation > Flows and select new flow. Select Record-Triggered Flow from the wizard.

Configure the Trigger to occur when a record is created, and after the record is saved.

Select Campaign as the trigger object.

Add a Decision element to the flow

Drag and drop a decision element onto the page. This is where we will set up the logic to determine what campaign statuses to create for each campaign type.

In this example, I will be creating three outcomes:

  1. Campaign type = Webinar
  2. Campaign type = Online Advertising
  3. Campaign type = Email

Each outcome will use the {!$Record.Type} resource and use the value of the campaign type.

Click the plus sign to add each outcome.

Example: Campaign type = Webinar

Example: Campaign type = Online Advertising

Example: Campaign type = Email

Add create record elements to the flow

Once your decision outcomes have been created, you can add actions to create each campaign member status. Each status for the campaign will use a Create Records element. For example, if you want to create four campaign member statuses for webinars, you will need add four Create Record elements to the flow.

Each create records element will set the following values:

  • Create one record
  • Use separate resources, and literal values
  • Set the value for CampaignId to {!$Record.Id}
  • Set a field label

Setting these values are optional:

  • HasResponded: I highly recommend setting this as it is helpful for reporting
  • IsDefault: There can only be one default campaign status.
  • SortOrder: I recommend not setting this value. If your campaign already has values, it can sometimes cause a flow error.

Using my webinar campaign type as an example, here is what my create record steps look like.

Example: Create a campaign member status for invited

Example: Create a campaign member status for registered

Example: Create a campaign member status for attended

Example: Create a campaign member status for no show

Example: All webinar statuses

Here’s what my flow looks like once all my webinar statuses have been added.

Note: There is more than one way to create campaign member statuses using Flow. I’ve chosen to create them using separate create record elements, but you can also create them by using an assignment element paired with a loop element. While this method works and eliminates some steps, you cannot assign HasResponded and IsDefault values to individual statuses.

 

Connect the decision element

Connect the decision element to the first create record element and select webinar as the outcome.

Connect the rest of your elements. Now, we are left with a flow that looks like this.

Repeat for the rest of your campaign statuses

Repeat the process above by adding more create record elements to your flow for the rest of your campaign types.

Here’s what my flow looks like once I added the Online Advertising and the Email statuses.

Optional: Delete the default status values

Optionally, you can delete the two default status values (sent and responded) from campaigns automatically by adding a delete record action to your flow.

Drag and drop the delete records element to your flow, select the Campaign Member Status object, and add the criteria.

Connect the delete records element to the last element of each of the flow steps.

Note: Use caution when deleting these statuses. Campaigns must have one status set to responded and one status set to default. If you remove the ‘Sent’ and ‘Responded’ statuses from campaigns you must set these values for one of your custom custom statuses.

Test, test, test

Save and activate your flow. Create new campaigns for each of the campaign types to ensure the statuses are correct.

Questions?

Send me a tweet @jennamolby, leave a comment below, or book a Peer Chat.

Author

I'm a Freelance Marketing Operations Consultant With 15 years of experience in Marketing Operations, I’ve worked with a wide range of tools including Salesforce, Marketing Cloud Account Engagement (Pardot), Marketo, and many other sales and marketing platforms. I help teams optimize their tech stacks, improve processes, and get accurate, actionable reporting. Whether it’s setting up your Marketing Automation Platform, building Salesforce reports, managing lead lifecycles, tracking attribution, or integrating your tech stack, I ensure everything is aligned to drive real results.

28 Comments

  1. Hi Jenna !

    Great Post 😉

    Is there a way to specify the order the newly created statuses will be displayed on a campaign ?

    For instance, on an email campaign type, it would be more natural if the status “clicked” was displayed after “opened”, since it things happen in that order.

    Any insight on this one ?

    Keep up the good work 😉

    François.

    • Jenna Molby

      Hi Francois, Thank you! Yes, you can set the SortOrder field within the create campaign member step in the flow.

  2. Gustavo Seluja Reply

    Hello Jenna,

    During importing (Data Loader) of campaigns, this weird behavior happens: the newly created campaign creates two campaign member statuses of responded and sent. I posted this question on the Trailblazer Community and a fellow Trailblazer sent me to your post here. Is there a way to get around this? Do I need to include any specific field on the campaign list so this behavior is avoided. Does it have to to with the Type being associated with a campaign member status? If so, how do I dissociate it?

    Here’s my post on the TC (includes screenshot):

    https://trailhead.salesforce.com/trailblazer-community/feed/0D54S00000ChxeXSAR

    Thank you!

    Gustavo

  3. Divya Sheril Reply

    Hi Jenna, This is Brilliant. This worked for me perfectly in Developer org. However, when I tried to do the same in my Production org, the “Campaign Member Status” did not appear in the suggestion for Objects in- create records. Can you please tell me how to solve this?

    • Jenna Molby

      Hi Divya, Awesome! Make sure the “Marketing User” checkbox on your user is checked.

Write A Comment