How to transfer data for several websites tracked on google analytics to big query as one dataset?

I have several websites that are being tracked on google analytics. I need to analyze the performance of websites and compare their performance. In order to do this, I wanted to export all data to Big Query. I was able to link Google Analytics to Big Query, but each website data separately. For comparison purposes, I need all websites data to be in one dataset. How can I achieve this?

P.S. I don’t have beta version, however, if it is the only option, I may try to persuade my boss to buy it.

Thank you!

Hello @kdilrabo2911
With this, there is a need for data integration too. You can check out: https://airbyte.com/

I hope it has the best way of integrating data sources into one source.

1 Like