Hi Everyone,
I am going to come right out and say that I am a complete and utter Alteryx newbie. I am trying to understand the limitations of Alteryx's Google Analytics connector. I am currently using Microsoft Power BI to store data from GA, but I am realizing that there are limitations and a database will be needed for the future. The problem I am facing with the GA connector in power bi is I can only have a total of 7 dimensions and 10 metrics per table. Will this also be the case with Alteryx? Another problem I am having with the GA connector in power bi is not being able to recognize unique sight visits.
I am wondering if streaming data into a Microsoft SQL server from GA with the Alteryx connector is a reasonable solution. We will need to store at least two years' worth of data in the database and do daily refreshes.
Thanks for your help
