See Google Analytics Data Clearly With These 3 Little Known Tricks

by Russ Henneberry

Last updated on March 13th, 2018

When looking at Google Analytics data, sometimes you’re just one click away from an insight that will change your business.

One simple trick could be the difference between seeing something valuable and not.

Here are three Google Analytics tricks will help you quickly get the business insight you need from your data.

1)  Weighted analytics

I’ve been working to get our bounce rate down here on The Daily Egg.

So, I fired up Google Analytics and decided to take a look at some individual pages that were showing high bounce rates to see if I could find any similarities.

Seems like it would be easy to determine where to start but not so much.   When you are dealing with large amounts of data, you will usually have outliers.  And these outliers can make it impossible to see anything of value.

In this case, I have a number of pages that have 100% bounce rate but very few visits.  This isn’t doing me any good.  It wouldn’t be worth my time to investigate a page with 1 or 2 visits.

Click to enlarge

Weighted Analytics in Google Analytics

This is the data with the “default” sorting method.

Fortunately, Google Analytics has me covered.  By changing the SORT TYPE from DEFAULT to WEIGHTED, I can suddenly see where to start my research.

I won’t go into the magic pixie dust that makes weighted sorting work but suffice it to say that it takes into account traffic volume to bring significant data to the forefront.

Click to enlarge

Weighted Analytics

This is the data with the “weighted” sorting method

2) Data-over-time intervals

Back in the summer, I activated the dormant Crazy Egg Facebook Page.  Nothing too crazy, just posting our articles for our fans and occasionally a status update when I found something interesting to share.

As the end of the year approaches, I would like to see if it makes sense to ramp up our presence on Facebook in 2013.

But looking at data over time can be tricky if you don’t select the right intervals.

In this case, going back 6 months and displaying information by the day is basically worthless.  This view might be OK if I was trying to pinpoint the exact Facebook status updates that did well at driving traffic.

But I just want to know if the posting to Facebook over the last six months has had any affect in the aggregate.

Data over time shown daily

Data over time shown daily

When I view the data by the week, I get a much clearer picture of this data.  This view would be perfect if I was, for example, trying to determine if a Facebook contest I ran generated more traffic than usual.  But, again, that’s not what I am looking for today.

Data Over Time Trick In Google Analytics

Data over time shown weekly.

Viewing the data monthly shows me that our small amount of activity on Facebook has produced more traffic.  This view is (as Goldilocks would say) just right to answer this particular question.

Data over time shown monthly

Ahh, now that’s better.  Data over time shown monthly

3)  Export more than 500 rows in Google Analytics

Sometimes you just need to get out of Google Analytics and into a spreadsheet to get the insight you need.

In my case, I wanted to take a look at our % of email subscriber conversions  by organic keyword.  Understanding the keywords that convert best assists me in making a number of SEO and editorial decisions.  When I do analysis like this, I like to get the data into Excel where I can do some manipulation that can’t be done in Google Analytics.

But Google Analytics limits the number of rows you can export to 500.

In October of 2012 alone, we have visits from over 15,000 different organic keywords.  If I were to export all of them separately and stitch them together in a spreadsheet, I would have to export 30 times.  Ack!

That is, until I learned this easy hack.

First, select ‘500’ as the number of rows to display in your report.

Export more than 500 rows in Google Analytics

Then, find that 500 in the big long ugly URL string as pictured below.

Export more than 500 rows Google Analytics

Change that number to the desired number of rows you would like to export, in my case 15,008.  I believe 20,000 is the upper limit for this hack and besides, if you go too crazy with the number of rows you are exporting you will crash your browser on the next step.  🙂

Export limit in Google Analytics

After you alter the URL, press the Enter key to load the new URL.

Now you are ready to Export as usual.

So, what do you think of these Google Analytics tricks?  Do you know any of your own you could share with us?



Get updates on new articles, webinars and other opportunities:

Russ Henneberry

Russ Henneberry is the Editorial Director at Digital Marketer. He's worked on digital marketing projects for companies like CrazyEgg, and Network Solutions. You can connect with Russ on Twitter, LinkedIn, Google+ or on his blog.


Comment Policy

Please join the conversation! We like long and thoughtful communication.
Abrupt comments and gibberish will not be approved. Please, only use your real name, not your business name or keywords. We rarely allow links in your comment.
Finally, please use your favorite personal social media profile for the website field.


Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

  1. David says:
    January 8, 2013 at 5:54 pm

    Great tips! Thanks for putting these together. Does anyone know how you can sort by actual conversions, not the conversion %? It’s annoying because I always have export and put into excell to see such a simple stat. Thanks in advanced!

    • Russ Henneberry says:
      January 9, 2013 at 8:29 am

      Excellent question David – I have the exact same problem.

  2. Mark Kens says:
    December 28, 2012 at 12:17 am

    These are really great tips which can help any analyser. I personally think that third one is really helpful to me. Previously I used to exports data in more than 5 attempts due to limitation of 500 rows, but now I can do it in one click. Thanks for providing us these really helpful tricks.

    • Russ Henneberry says:
      December 28, 2012 at 12:15 pm

      Yep — that one is a life saver if you do a lot of exporting of Google Analytics data.

  3. Kyle says:
    December 19, 2012 at 12:51 pm

    Editing the URL to export more will save me a chunk of time. It’s small but it’s one of my favourite tips this year. I really hated mashing stuff together in CSV’s!

    Great work.

    • Russ Henneberry says:
      December 19, 2012 at 3:19 pm

      Ha ha… I know exactly what you mean Kyle. It’s a complete pain in the you know what! 🙂

  4. December 17, 2012 at 9:15 am

    Great tips. I will have to try Weighted Intervals. Not sure how much of a “trick” it is, but I like to see Goals and what sources drove them by using the Advanced Segments to see Non-Paid, Paid, Returning, New, Direct – helps greatly with lead sourcing.

    • Russ Henneberry says:
      December 17, 2012 at 9:21 am

      Awesome Carlton. There are some very powerful tools in the new Google Analytics.

  5. Lukas says:
    December 15, 2012 at 8:55 pm

    10000 is the limit but you can always extract more via api.
    Btw. Weighted sort doesnt work with advanced segments – watch out for that.

    • Russ Henneberry says:
      December 16, 2012 at 11:55 am

      Awesome tips — Thanks Lukas!

  6. December 14, 2012 at 12:25 pm

    Valuable points! Especially the first one. I didn’t know there was such a setting as “Weighted”. That may come in handy.

    Thanks for the blog post!

    • Russ Henneberry says:
      December 14, 2012 at 1:06 pm

      Glad you found it useful Hans!

Show Me My Heatmap

Currently looking at @CrazyEgg reports and understanding them. @lorenagomez would be so proud! LOL!

Nicholas Love


What makes people leave your website?