In Google Analytics you can only view 500 rows of results from a query at any time. When you try to export the results of the query, unhelpfully it only exports the results that are on your screen at the time, so if you need more than the 500 results on the screen, you have to page through them and export them by hand one page at a time.
Or so I thought.
A little bit of digging around has revealed that if you add the string &limit=50000 to the end of the URL of the page you are looking at, and then export as CSV or TSV you will get up to 50,000 records in your downloaded report file.
Being able to export large volumes of segmented data is of great value to us here in RevaHealth.com, especially with our focus on long tail SEO. Hopefully this tip will save you some time too.
P.S. If you’re using Analytics and haven’t checked out advanced segments yet, you owe it to yourself to do so. They are the answer to innumerable problems that existed in Analytics reporting up to now.
Recent Comments