Easily run up against a cell limit in Google Sheets.

[shaownhasan]

For whom is this solution?
This method is definitely for the not fainthearted chinese thailand data and for sure not for anyone who isn’t afraid of getting a repetitive strain injury.

Our score
Backup Completeness Score: 3/10

Learning Curve: Easy

Time: 8 hours per view

Cost: free

Advantages
Values in the data downloaded should match the GA interface exactly.
Inexpensive solution that gives access to lots of data, representing a true backup.
Ability to access some reports not available in the API.
No training needed beyond clicking buttons.
Disadvantages
Must download dozens of reports for hundreds of data ranges.
No visualization native in the data backup.
Prone to user error and requires a system to store and manage everything in harmony.
Data is contained in hundreds of individual sheets files.
9. UA Report Exports to PDF
Of all the reviewed UA backup solutions, exporting UA reports to PDF is the worst.

It can be useful for someone who wants to have a couple of old UA reports as a PDF.