Idea: I would like to add an additional filter for constraints that allows the user to query data that not contains specific strings AND excludes empty strings. It is essentially a combination of Not Contains and Is Not Empty
If you have played around with constraints, you will notice that selecting the option not contains excludes the specific strings you enter in the filter box. What it does not exclude however, are data values that are empty. There are some instances where this might be desired.
Use case: Say you want to perform an audit of all the query parameters coming into your Marketo instance when certain forms are filled out. Maybe you are trying to ensure the parameters are all formatted correctly to fit your tracking model in Marketo or that no brand new parameters have been created that the Ops team was unaware of.
The below filters will not work because even though you are using ALL for both filters, the visited web page activity has a 1-many relationship with people. Marketo reads the below filter as follows
- Are there any people with any visit web page activity after 11/1/18 where the query string is NULL or not contains xyz
- Are there any people with any visit web page activity after 11/1/18 where the query string has a value
What is interesting here is that both filters are combating each other. The first filter pulls records that have ANY web page activities with no querystring or ones that exclude xyz. The 2nd filter further qualifies records where ANY web page has a query string (say xyz 
). So you ultimately get false positives with this list.
There is currently no way to isolate this data to the best of my knowledge.
Please add any comments and vote if you like please!
-Mike
3 Comments
.png)