Were you able to find a solution for this. For us, doing this daily can solve our needs. The challenge is to find out how we can do incremental update in a loop for each day of last year.
Thanks and regards, Charu
There is a way to create custom reports on the GA website and have them auto-generated and emailed to you on the frequency of your choice (weekly, daily, etc.).
You could combine the output into a single spreadsheet or database and then connect to it from Tableau.
Not a perfectly automated solution, as you'd have to keep adding to your main data source manually, but it might allow you to work around that API limit.