See Google Analytics Data Clearly With These 3 Little Known Tricks

by 12 12/14/2012

When looking at Google Analytics data, sometimes your 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?

About 

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

Get our Daily Newsletter

Get conversion optimization, design and copywriting articles delivered to your inbox FREE

12 COMMENTS

Hans Kolbeek

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!

December 14, 2012 Reply

Lukas

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

December 15, 2012 Reply

Carlton Smith

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.

December 17, 2012 Reply

    Russ Henneberry

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

    December 17, 2012 Reply

Kyle

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.

December 19, 2012 Reply

    Russ Henneberry

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

    December 19, 2012 Reply

Mark Kens

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.

December 28, 2012 Reply

    Russ Henneberry

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

    December 28, 2012 Reply

David

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!

January 8, 2013 Reply


Leave comment

Some HTML allowed

Get conversion optimization & A/B testing articles FREE >>>