If I go to a report and I do a search in the search box (1) I can filter the results. So on this screen I'm on the products result and I've decided to filter anything with a certain word in the product name. That works great.
I can also do an advanced filter and then I can add multiple AND/OR filters so I could have two (or more) product names.
When I try to use a segment (2 as seen in the image below) and do product contains "word" it doesn't seem to filter properly. It is not 100% of the results, so something is filtering, but it is not limited to just that word but far more.
Can someone explain why it doesn't work the way I think it works and how to achieve this?
As a secondary question, how can I get that search function to work in Google Data Studio. Neither filter or segment seems to work.
The results I get in Google Data Studio show no sessions which is not what shows in Google Analytics at all.