How to Target by Unique Identifier with Duplicates

Juliet_Crema
Level 2

Hi everyone,

 

I recently inherited the Marketo instance at my company and have questions on how I can target by unique identifier in a situation where we utilize duplicates. Our unique identifier is email address and program, so one email address can have multiple records associated with several different programs. Additionally, when a record submits an apply now form, a new lead is created in SFDC and synced to Marketo. These apply now leads are routed very differently and assigned to non-marketing queues. I am trying to automate a campaign that targets these duplicate self apply records by unique identifier or email address in order to remove from a nurture flow, but because different SFDC record IDs are members of different smart lists/campaigns, I am running into difficulties in targeting them. Here is the outline:

smart lists

A -  New Self Apply Leads and duplicate fields = email address 

B - Member of Nurture and duplicate fields = email address

smart campaign

if member of smart lists in both (A and B) and duplicate fields = email address (Two separate records that cannot qualify for both)

flow - mark cadence as paused

 

My goal and thought process is if an email address is going through our nurture program and then progresses to a new self apply lead, we definitely do not want to keep emailing and encouraging them to start an application! I understand what I've got so far is messy due to the way we are handling the self apply leads and because the records in smart lists A vs B have the history of separate records on their log, and therefore not triggering the regular pause nurture campaign. So unfortunately I cant write the logic like "member of smart list A and opened email was from the nurture". Worst case scenario is I have to use vlookup from exports and manually remove, but looking for any advice on this, thank you!

2 REPLIES 2
SanfordWhiteman
Level 10 - Community Moderator

Our unique identifier is email address and program, so one email address can have multiple records associated with several different programs.

The "program" in this case being a custom Lead field, I assume? Not directly tied to the Marketo Program hierarchy.

 

A single lead can be in more than one Marketo Program at once, by definition, so they never have a "a program." Just getting the terminology straight.

Juliet_Crema
Level 2

Hi Sanford,

 

I should have clarified on what I meant by program for the unique identifier. We work with schools so program examples could be Human Resources, Project Management, Business/IT. Any Marketo program membership is not part of the unique identifier. 

 

For example, we could have record A -  juliet@gmail.com with program of interest = HR going through the nurture. If a new self apply lead, record B, is created with email address juliet@gmail.com and program of interest = HR (same unique identifier), I want to make sure record A does not keep getting nurture emails. Because a new record B is created that did not run through the nurture I am not sure how to connect them back so that duplicate unique identifier qualifies for the pause nurture campaign. Please let me know if I need to further clarify on anything else! Thank you.