How to export complete Google Analytics historical data?
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?
Answer
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