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.
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?
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.
The report will be available in your downloads folder. Google Analytics exports up to 5k rows when you download a report as a CSV.
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.
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
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With