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.