Additional Filter Options for Constraints

Additional Filter Options for Constraints

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

  1. Are there any people with any visit web page activity after 11/1/18 where the query string is NULL or not contains xyz
  2. 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.

pastedImage_11.png

Please add any comments and vote if you like please!

-Mike

3 Comments
Mark_Haynes
Level 1

Corollary to this, it would be great to be able to combine constraints of the same type such as multiple querystring, IP address, Referrer, Browser, Search Engine, Search Query, etc. constraints in the same filter.

For advanced users, access to a custom query field that would allow users to code their on database queries with CASE and other conditionals.

Geoff_Krajeski1
Level 10 - Champion Alumni

Also:

kh-lschutte
Community Manager
Status changed to: Open Ideas