So I would create a new Marketo only field called SFDC Type Mirror, thats a string field and then I would create a smart campaign where the smart list would have the criteria of "SFDC Type is Not empty" and my Flow Step would be Change Data Value to the new Marketo only field, with a value of customer or lead? This new field would then be available in my segmentations? Would I schedule this to run like once a day?
Thanks for help!
The Change Data Value step would use the New Value
That's what I'm getting at by saying "mirror" — it always holds the same value as the original field.
Your filters should qualify
Or: How about you use SFDC Contact ID is not empty and SFDC Lead ID is not empty as criteria? These fields are available for segments.
Yes, although I'd suggest you want the 2 SFDC Types to be different segments as that might be useful later.
Michael has another good idea, although make sure to check SFDC Contact ID first as that has priority.