Hi I'm trying to set up dashboards containing google analytics data for an embed that shows data tailored to the customer that has logged into our site (we're using JWT currently to authenticate and send params).
Currently we use Google Data Studio for dashboards to join GA data with Sheets CSVs with customer data.
My question is what is the easiest way to achieve the same with Metabase?
I'm aware joining two data sources is not possible and we're not sure we can afford moving everything to a data warehouse as the GA data is fairly big (1-2 million events a month).
Have identified a few possible solutions:
Import User data into a CSV in our app's code and use in Metabase params JWT Response to filter data
Move GA Analytics to a new Postgres DB, query from there (Not sure on price of this vs. a warehouse)
Import user data into Google Analytics so that any joining can just be done on GA Data source
Use Metabase API somehow?
Please let me know if any of these sounds feasible or if there's a solution I'm not seeing. Thanks!