I am using Google Analytics SpreadSheet Addon to get data in Google Sheets.
I took reference to this Google Analytics API V3 documentation for filter operators. I am using RegEx to filter data.
Everything works well, till I am within limit of 128 characters in RegEx. The below RegEx works pretty well.
In the above expression, I also want to filterout 8 specific URls starting with www.example.com so I have to add their path. This makes the expression length longer than 128 characters. It is mentioned that I can use OR(,) or AND(;) operator to combine more than two regEX in order to avoid 128 characters limit.
So I created this RegEx for example:
However, when I run the report, Google by-passes the entier filter expression; and return full report without any filters. (This contains 50,000+ records)
I tried with various combinations in RegEx - like I used !@, != also tried to avoid adding backslash "\" to by-pass "comma ," but it doesn't work.
So what can I do to run the above script correctly?