How to Automatically Create Campaign Member Statuses in Salesforce

In:

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 Type Campaign 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, or leave a comment

Related Posts

  • 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

  • 29/07/2020
    How to Create an Engagement Program to Automate Sales Follow Up in Pardot

    Your event or webinar has finished and now it’s time for Sales to follow up on those leads. A great way to automate Sales follow up is to create an automated engagement program in Pardot to send out emails on the Sales Rep’s behalf and create follow up tasks automatically in Salesforce.

  • 17/06/2020
    Quick Tip: How To Bulk Create Campaigns in Salesforce

    Bulk creating campaigns in Salesforce is a great way to plan your marketing initiatives for the month or the quarter. You can upload your campaign targets as custom fields, set your estimated pipeline, and create Salesforce reports for visibility into your marketing campaigns. Uploading campaigns in Salesforce can be done using Salesforce Data loader. All you need to do is prep your CSV file and upload it into Salesforce.

4 comment(s)
  • Gwen Mui

    13/10/2020 at 7:39 pm
    Reply

    For some reasons, I couldn't find the Campaign Member Status in the Object list. I do have admin access. If I would be able to do this, it would be such a life/time saver.

    • Jenna Molby
      to Gwen Mui

      14/10/2020 at 8:49 am
      Reply

      Hi Gwen, Only users with the Marketing User checkbox selected on their user record can create, edit, or delete campaigns. Does you user have this permission? Cheers, Jenna

  • Judson Voss

    07/10/2020 at 7:09 pm
    Reply

    Amazing Jenna! What a great use of flows for marketers. It feels like there are so many different scenarios that marketers can use flows to create low or no-code automation and I look forward to the community digging in and leveraging this very powerful tool.

    • Jenna Molby
      to Judson Voss

      08/10/2020 at 7:58 am
      Reply

      Thank you! Yes, there are so many great use-cases for using Flow, especially for marketers.

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