Is there a way in Marketo to select only particular values from SFDC picklist fields?

Question

Hey, is there a way in Marketo to select/filter out leads with only particular values from SFDC pick-list field?

Let's say, I sell vegetables and fruit, in a Product Entity field in SFDC my targeted record has this field populated with: potatoes, apples, pears and cucumber:

In Marketo, I want to target only those that has potatoes and apples interest identified:

I do have dummy leads created with different variation or the pick-list values in SFDC. However, I noticed that marketo does not trigger the values from the SFDC pick-list field.

***I used fruit as an example values, I tested this with my actual Product Entity field pick-list values***

Do you know if there is a way around it?

Many Thanks,
D

SanfordWhiteman · Answer

Preferably, create another Marketo-only field that's the value of the SFDC field wrapped in an additional semicolon on either side. This is how you prevent errors due to ambiguous [contains] matching.

Then your filters are like

Product Entity [contains] ;apples;

Product Entity [contains] ;oranges;

Sign up

Login with SSO

Login to the community

Login with SSO