How To Create Pivot Table-Friendly Custom Reports in Google Analytics

Normally, in Google Analytics, if you create a custom report and you need more than one dimension, you create drill-down dimensions like this: However, if you want to export that, you’re only going to see in the export whatever you see on your screen, i.e., a list of landing pages or a list of keywords [...]

How To Get More Than 500 Rows From Google Analytics Reports

UPDATE: Google Analytics now gives you up to 5000 rows, so you don’t need to do this trick unless you have > 5,000 rows in a report. Thanks, Goog! When you create a report in Google Analytics (GA), the interface limits you to 500 rows. You can get around that limit though. Your browser will probably [...]

List Of Mobile Device Screen Resolutions

I had to get down and dirty with Google Analytics this week to analyze how mobile users were faring on a client’s site. Spotting an anomaly in the data, figuring out what was causing the issue came down to screen resolution. I came across a site with a comprehensive list and, of course, scraped it [...]

Where To Find Traffic From Image Search In Google Analytics

Trying to rope up traffic from image search is like trying to nail jello to a tree. To keep us on our toes, Google moved its image search engine from images.google.com to google.com in May 2010, then apparently moved image search from referral reports to organic reports in July 2011. (You can keep abreast of [...]

Custom Report To Track Subdomain Performance In GA

I’ve emphasized the critical importance of including hostname in Google Analytics (GA) content reports, if your site has subdomains. But what if you haven’t included it? Is all lost? Originally, I thought yes. But then last week I had an idea to experiment with custom reports and the API to see if I could get [...]

How To Find Hottest Links On A Page in GA [VIDEO]

Last year I wrote this post on how to find top content on your homepage. Since then, Google release version 5 of Google Analytics, so I’m redoing the post with a quick one-minute video.

How To Create Custom Reports in GA [VIDEO]

The standard reports in Google Analytics (GA) are so restricting. What if you want to apply a reusable filter? Or share the report structure with someone without sending along your data? Or measure unique visitors? (Yeah, good luck finding that metric in standard reports.) Or what about the next time a Google hits, and you [...]

How To See Traffic Affected By iOS6 Switch To Secure Search

When Apple’s iOS6 update hit the market in late September, there was one fallout: referrer data in analytics. You can read the back story on the issue. What I’m going to focus on is how to find out how your site has been affected. Custom Report … I created a custom report that will help [...]

How To Add A Hostname Filter in GA

If your site has subdomains, there’s a filter that’s absolutely critical in Google Analytics (GA). It’s called a hostname filter. The Problem GA content reports only include the URI (which is just a URL minus the domain). So my homepage looks like / instead of www.annielytics.com/. And my About page looks like /about/ instead of [...]

See What Social Networks Drive Traffic To Your Site

Want to know which social networks are driving traffic to your site in Google Analytics? You can find out a couple different ways: Navigate to Traffic Sources > Social > Sources in GA. Use this custom report I created. Then you can compare that against this list I compiled of all the social networks I [...]