Seems like filter with product name don't work.
I set up a real simple query (query for google analytics) with
custom date range
metric = transactions
filter = product name equals "XYZ"
which doesn't work.
When I remove the filter however I get the total amount of transactions. But I'd like to report the total amount of transactions for one specific product.
I also tried it's product sku, it's product category, filtering with avg revenue greater then and so forth.
What am I doing wrong here?