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