SQL queries and Custom Columns with Google Analytics data

Get Help
1

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!

Google Analytics - Metabase
Google Analytics - Metabase2814×1138 125 KB

2

Hi, unfortunately not directly. I would suggest you connect to a Bigquery and send your GA data to Bigquery for 2 reasons:

  1. we might deprecate GA at some point as it's completely different from all other data sources we support
  2. you will be able to do SQL queries to Bigquery->GA, which you cannot do connecting directly to GA
3

Hi!
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!