Process Builder to Stamp Last Campaign | Community
Skip to main content
Anonymous
November 3, 2015
Solved

Process Builder to Stamp Last Campaign

I'm trying to stamp the campaign the lead last responded to when they became an MQL. Anyone try this in Process Builder or a similar type of workaround? Thought I'd ask before testing it out

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Conor_Fitzpatri
Conor_FitzpatriAccepted solution
Level 5
November 3, 2015

Hi Emily,

My solution is not the most elegant, but it should get the job done. You'll need two processes and two custom fields on your Lead object, Last Responded Campaign and Last Campaign Responded at MQL. The first process will continue to overwrite the Last Responded Campaign field as Leads respond to your campaigns while the second process will populate the Last Responded Campaign at MQL when the Lead becomes an MQL. Here are the processes:

Process 1

Choose Object and Specify When to Start the Process

  • Object: Campaign Member
  • Start the process when a record is created or edited

Define Criteria for this Action Group

  • Criteria for Executing Actions: Conditions are met
  • Set Conditions: [CampaignMember].HasReponded =True
  • Advanced
    • Do you want to execute the actions only when specified changes are made to the record? Check Yes.

Immediate Actions

  • Update Records - Update Lead field
    • Record: [CampaignMember].LeadID
    • Criteria: No criteria—just update the records!
    • Last Responded Campaign Reference [CampaignMember].Campaign.Name

Process 2

Choose Object and Specify When to Start the Process

  • Object: Lead
  • Start the process when a record is created or edited

Define Criteria for this Action Group

  • Criteria for Executing Actions: Conditions are met
  • Set Conditions
    • [Lead].Status = MQL
    • [Lead].Last_Responded_Campaign is null Boolean False
  • Advanced
    • Do you want to execute the actions only when specified changes are made to the record? Check Yes.

Immediate Actions

  • Update Records - Update Lead field
    • Record: [Lead]
    • Criteria: No criteria—just update the records!
    • Last Responded Campaign at MQL Reference [Lead].Last_Responded_Campaign
View reply

11 replies

Conor_Fitzpatri
Conor_Fitzpatri
Level 5
November 6, 2015

This is not a solution to Emily's problem, but it is related and I thought it would be a cool share. The consultants over at Opfocus devised a way to put the Lead's Status on the Campaign Member object at the time the Campaign was added. I think it would be interesting to run a report to see where Leads are in the funnel when they interact with your campaigns:

opfocus.com/blog/salesforce-campaign-member-to-the-rescue/

Translate
Grégoire_Miche2
Grégoire_Miche2
Level 10
March 9, 2017

Hi Conor,

That would be much easier for Marketers if this idea was implemented:

-Greg

Translate
Anonymous
March 9, 2017

Voted. I wonder how far away this functionality is.

Translate
Conor_Fitzpatri
Conor_FitzpatriAccepted solution
Level 5
November 3, 2015

Hi Emily,

My solution is not the most elegant, but it should get the job done. You'll need two processes and two custom fields on your Lead object, Last Responded Campaign and Last Campaign Responded at MQL. The first process will continue to overwrite the Last Responded Campaign field as Leads respond to your campaigns while the second process will populate the Last Responded Campaign at MQL when the Lead becomes an MQL. Here are the processes:

Process 1

Choose Object and Specify When to Start the Process

  • Object: Campaign Member
  • Start the process when a record is created or edited

Define Criteria for this Action Group

  • Criteria for Executing Actions: Conditions are met
  • Set Conditions: [CampaignMember].HasReponded =True
  • Advanced
    • Do you want to execute the actions only when specified changes are made to the record? Check Yes.

Immediate Actions

  • Update Records - Update Lead field
    • Record: [CampaignMember].LeadID
    • Criteria: No criteria—just update the records!
    • Last Responded Campaign Reference [CampaignMember].Campaign.Name

Process 2

Choose Object and Specify When to Start the Process

  • Object: Lead
  • Start the process when a record is created or edited

Define Criteria for this Action Group

  • Criteria for Executing Actions: Conditions are met
  • Set Conditions
    • [Lead].Status = MQL
    • [Lead].Last_Responded_Campaign is null Boolean False
  • Advanced
    • Do you want to execute the actions only when specified changes are made to the record? Check Yes.

Immediate Actions

  • Update Records - Update Lead field
    • Record: [Lead]
    • Criteria: No criteria—just update the records!
    • Last Responded Campaign at MQL Reference [Lead].Last_Responded_Campaign
Translate
    Conor_Fitzpatri
    Conor_Fitzpatri
    Level 5
    November 3, 2015

    The only issue I see with my process is when someone that wasn't associated with any campaigns turns into an MQL, and then responds to a campaign. In that case it will pull in the first campaign they responded to after becoming an MQL.

    Translate
    Josh_Hill13
    Josh_Hill13
    Level 10
    November 3, 2015

    Just do

    Change Data Value: Last Campaign = X

    either within the main status response flow or centrally.

    Translate
    Anonymous
    November 3, 2015

    Josh, can you expand on the last part?

    Translate
    Grégoire_Miche2
    Grégoire_Miche2
    Level 10
    November 3, 2015

    Hi Emily,

    Are you talking about SFDC process builder ?

    -Greg

    Translate
    Anonymous
    November 3, 2015

    Yes, SFDC Process Builder.

    Translate
    Terms & ConditionsAccessibility statement

    Loading footer...