SEO Services

Our highly consultative search engine optimization services include link building, on-page optimization, content development creation and more.

Social Media

We take a holistic look at Social Media strategy including blogging, Twitter, Facebook and industry specific social networks to come up with a campaign that works for you.

Local Search

Thunder SEO has extensive experience in creating and implementing local search campaigns for single location, regional and nationwide businesses.

Testimonials

Our company has been working with web designers and internet marketing people for over 10 years....


Read All Testimonials

Tip: Download more than 500 rows in Google Analytics

Submitted on 7/23/2011 by Max Thomas

Okay, this is not the latest-greatest content development insight or an unbelievable link building tool, it’s just a tip on how to download more than 500 keywords in Analytics…which can be very helpful. I suspect lots of people already know about this, but in case you don’t…this can save a lot of time when evaluating a site’s keywords as well as boost campaign analysis productivity tremendously. Please feel free to add any additional tips or suggestions :-)

1) Go to Analytics >> Traffic >> Keywords >> Non-Paid

 

2) Set date range using calendar tool (right side)

3) In URL, add following snippet to end:
&limit=8000 (or whatever length you need)

4) Hit return to reload appended URL.

5) Scroll to URL end to confirm snippet is still there.

6) Export as CSV file (NOT CSV for Excel).

 

7) Downloaded spreadsheet will include all rows; Analytics will still show only 500 rows at a time.

 

That’s it!!! Happy data analyzing!

 

2 Responses to “Tip: Download more than 500 rows in Google Analytics”

  1. If you want for instance 30.000 rows it can take a lot of time, in that case you could use my solution: http://andrescholten.net/how-to-export-more-than-500-rows-in-new-google-analytics-interface/ Happy analyzing ;)

  2. Max Thomas says:

    AndrĂ© – thanks for adding a link to your tool for getting 10,000+ rows. I hope everyone who reads this tries it out.

Leave a Reply