1 of 1 people found this helpful
I love that blog post! But it's a bit dated. Looks like the blogger has a new one just now: Multiple Google Analytics accounts in one Tableau data source! – VizPainter
Hope it helps!
Joshua - this is awesome, thanks so much! Using this method I was able to repeat the proof of concept in just a few minutes rather than hours - but even better, this is readily scalable to any number of GA accounts with minimal effort.
It's a great solution. Thanks
Just a heads up -- I did discover that by default, the number of rows returned for each report is 1000 with a maximum limit of 10,000 (per the configuration). To get around that you can create multiple copies of the report using the MAX and INDEX properties of the configuration (i.e. the first copy is index 1 to 10,000; the second is 10,001 to 11,000; etc...) That's definitely a bit tedious if you have lots of data, but still a workable solution.
Hi Joshua - I now seem to be maxing out the Google sheet when running a report for the 79 GA properties I have added in - this even when limited to a minimum number of metrics (3) and dimensions (4) I need to see, and just one day of data - the error occurring midway though the process: "ScriptError: This action would increase the number of cells in the workbook above the limit of 2000000 cells." It's hard to believe the Google Sheet is so limited, and a shame as the method is great for feeding Tableau. Besides going some data management wizardry in Google, any ideas? Thank you!