3 Replies Latest reply on Jul 18, 2016 6:15 AM by Manideep Bhattacharyya

    Combining data between SQL and analytics

    Matan Bracha

      Hi all!

      I need to build a dashboard using data from both SQL and Google Analytics.

      At first I thought "No problem, I'll use data relationship", and then I remembered that it sucks and never works as well as I need it to work.

       

      So, In order I could use my data like I should, my question is this:

      Is there a possibility to execute a custom SQL query on data pulled from analytics?

      Or a way to create a "query" by doing "UNION ALL" between the data from SQL and the data from Analytics?

       

      Thank you all!