Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to export complete Google Analytics historical data? [closed]

I was given a few days to export all the historical data from a Google Analytics account before access will be shutoff. Important to note that you cannot migrate historical data (at the time of this post) from one Google Analytics account to another. I would specifically like to program this for Excel or better yet get guidance on what others have used.

I have never done this before so wanted to reach out and see what others have used? Wanted to avoid the Google Analytics Data Export API unless there was no other option. There is about 5 years of data for a very active site.

Update

I decided moving the information manually was the best route to go at that time. There may be new solutions, see links below.

Related references that may be helpful to others:

Account merge and data move options
Developers.Google.Com - Google Dev Guide
Can we move Google Analytics data to other account?
Exporting Data from Google Analytics - Trying to avoid the API
Google Analytics Application Gallery - Apps list, anyone use these?

like image 358
chainwork Avatar asked Jul 26 '13 21:07

chainwork


People also ask

How do I export more than 5000 rows in Google Analytics?

There are a couple of ways for users to export more than 5,000 rows: Change the number from 5,000 at the end of the URL to 50,000 or other number to get larger reports — except that doesn't work anymore. Install the Google Analytics Sheets Add-On to pull 10,000 rows.

Can you download Google Analytics report?

The report will be available in your downloads folder. Google Analytics exports up to 5k rows when you download a report as a CSV.

Can you export Google Analytics data to Excel?

Google Analytics Export Options You can export from just about any reporting view within Google Analytics (excluding Real-Time reports). When viewing a report, select the “Export” button right above the graph. Next, choose your desired file type from CSV, TSV, TSV for Excel, Excel (XLSX), Google Sheets, and PDF.


1 Answers

You can't (not with the free version of GA in any case). You can export aggregated reports (with up to 50 000 rows for standard reports or 200 000 rows for ad-hoc (not pre-calculated) reports via the API either by scripting yourself or using a tool like Next Analytics (the only programm from the Application Gallery I have used myself). But with 5 years of data you will at some point hit the courtesy limits for the Google API. And I'm not sure how helpful the exports are when you cannot get at the raw data.

Data Liberation from google may contanin updated info about this topic https://sites.google.com/a/dataliberation.org/www/google/analytics

like image 60
Eike Pierstorff Avatar answered Sep 18 '22 10:09

Eike Pierstorff