Apply an Event Label Filter to the Product Revenue metric in GBQ using Universal GA Data in Looker

  Kiến thức lập trình

I’ve got an event cat/action/label filter for my Authenticated vs Non-Authenticated users (written into the data layer and working in Universal Analytics) and I am trying to apply it to the product revenue metric. Applying the filter in looker returns “no data” which I first thought was a scope issue but after playing around I found that totals.totalTransactionRevenue will attach to the filter and return results. The first problem is that I want product revenue not transaction revenue but I can live with that if I have to. The second problem is when I apply the event label filter the transaction revenue goes UP!? Am I missing something?

I’ve tried writing calculated metrics using item price X quantity to create a mock Product Revenue and that didn’t work. I’ve got to be missing something with GBQ.

New contributor

Glenn Bourque is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.