The operators "Is Before" or "In Past Before" with a date field return people for whom that field is empty as well as people with date fields earlier than the target date. This can easily trip up even an experienced Marketo user because this behavior is not at all intuitive. In normal language if you say, for example, "raise your hand if you bought a car before December 30th, 2000" - you wouldn't expect people to raise their hands who had never purchased a car.
I suggest that Marketo comment these date field operators in the same way that they add this comment to Data Value Changed filters: "Note: Data of this activity type is archived after 90 days." Similarly, add a comment that says something like "Note: is before and in past before includes people with empty field values. Add another filter for "is not empty" if you want to exclude empty records."
To illustrate, suppose the person email@example.com was never synced to SFDC so SFDC Created Date is empty. The natural logical expectation is that a smart list with either of these sets of filters would come up empty. But it doesn't. Puka is a member unless you add an additional filter (with OR) for "SFDC Created Date is empty."
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.