I would like to know if there is a way to perform SQL queries and Custom Columns with the data we have in Google Analytics. I tried different ways to do it but sadly I couldn't.
Here I share the screen that I currently see. Is it something I could fix when configuring Google Analytics from the administrator account, or is it a limitation that GA has?
Thanks in advance!
Hi, unfortunately not directly. I would suggest you connect to a Bigquery and send your GA data to Bigquery for 2 reasons:
- we might deprecate GA at some point as it's completely different from all other data sources we support
- you will be able to do SQL queries to Bigquery->GA, which you cannot do connecting directly to GA
Sorry for my delay, and thanks a lot for your feedback. So the solution would be using BigQuery in the middle, instead of using only the GA directly. That sounds good to me!