How to Update SFDC Campaign Member with AI Email Status using Marketo

Laurel Slutsky

Here internally at 6sense, we  track the progression of contacts/leads from AI Email Campaigns within SFDC campaigns. Although AI Email pushes AI Email status to contacts and leads in SFDC, we have found it easier to use a trigger in Marketo (or your own MAP) to not only add contacts/leads to SFDC campaigns for AI Email,  but also update their status fields dynamically. One requirement for this is that you must have all your lead/contact fields mapped 1:1 from SFDC to Marketo to ensure your MAP can read the correct contact/lead status. 

To summarize, the benefits of using Marketo to sync AI Email Status to SFDC Campaign are: 

*Streamlined Naming Conventions: This way, the campaign name from Marketo/SFDC are the same. 

*Easy to Replicate for New Campaigns: You can easily replicate the trigger in Marketo to use for future campaigns.  It’s quick and easy to clone Marketo Programs. 

*Data Change Values are more complicated in SFDC Workflows. You would need history tracking turned ON To ensure all new status updates are changed. 

*If using workflows in SFDC vs Triggers in Marketo, in many organizations, oversight and approval from SFDC admin which could slow efficiency and delay launching campaigns.  

______ 

 

Before Launching the AI Email Campaign 

In Marketo, you need to create the Program (best practice is for it to be named after the SFDC Campaign AND the AI Email Campaign).  

1. Create your Marketing Program Name  

Then, we need to create Triggers under the Marketing Program. 

1. Trigger 1: Added  to SFDC Campaign” - (This is because the first thing we need to make sure of is that the contacts/leads are added to the campaign in SFDC as they enter the AI Email Campaign) 
   1. Create a SmartList and use the Data Value Change filter 
      1. Attribute = AI Email Campaign Name 
      2. New Value = (insert your AI Email Campaign Name)  
   2. Add filter for “Person is NOT in (insert your SFDC Campaign Name) 
      1. (this is to ensure it adds them to the SFDC campaign and updates the  status) 

2. Create a Flow within “add to SFDC” trigger for Change Status in SFDC 

This ensures that when an AI Email status is updated, it will update respectively in SFDC. 

1. If AI Email status IS “Not Started” for Campaign (SFDC CAMPAIGN NAME), then update “New Status” to “Member” 
2. If AI Email status IS “Qualified” for Campaign (SFDC CAMPAIGN NAME), then update “New Status” to “Qualified” 
3. If AI Email status IS “Bounced” for Campaign (SFDC CAMPAIGN NAME), then update “New Status” to “Bounced” 
4. If AI Email status IS “Not_interested” for Campaign (SFDC CAMPAIGN NAME), then update “New Status” to “Not_Interested” 
5. If AI Email status IS “Unresponsive” for Campaign (SFDC CAMPAIGN NAME), then update “New Status” to "Unresponsive” 
6. If AI Emailstatus IS “human_review” for Campaign (SFDC CAMPAIGN NAME), then update “New Status” to “Human Review” 
7. If AI Email status IS “in_progress” for Campaign (SFDC CAMPAIGN NAME), then update “New Status” to “In Progress 
8. If AI Email status IS “stopped_responding” for Campaign (SFDC CAMPAIGN NAME), then update “New Status” to “Stopped Responding” 

This simply changes their status once they are in the campaign. 

Now, once someone is already in the SFDC campaign, their status may change again. For example, they may go from Not Started to Human Review. We must capture that with different triggers for each status.  

3. Trigger #2: Create Triggers for changing status once contact is ALREADY IN campaign 

1. Data Value Change: Example here is for Need Human Review 
   1. Attribute  = AI Email Contact Status 
   2. New  Value is = Human Review 
2. Filters 
   1.  AI Email Campaign Name is = (Insert AI Email Campaign Name) 
   2. Member of SFDC Campaign: Person is IN (insert SFDC Campaign Name)  

 

 4. Within "Flow" Tab, change Status in SFDC campaign 

a. Campaign = SFDC Campaign 

b. New Status = Need Human Review  

Next, create separate triggers for each AI Email Status to ensure the status is updated example as in the Human Review example.

CE Status Names: Bounced, In Progress, Need Human Review, Not Interested, Qualified, Stopped Responding and Unresponsive. 

 As this is a triggered campaign, you cannot schedule it to end, but Marketo has a great feature to ‘Set local asset expiration’ so that the triggered smart campaigns can be turned off.   

 

Result: This allows you to measure AI Email Campaign effectiveness as it relates to members of the SFDC Campaign. 

Example Dashboard: 

Kimberly Conklin

Awesome - thanks for sharing!