As the publisher of more than fifty sites, I have more than a hundred profiles in my Google Analytics accounts. Spotting trends across this many individual reports is rather difficult without an aggregate view. After thinking about it, I figured I had four options. I’m sure there are more ways to do this, but here’s what I came up with.
In order to view an aggregate report across multiple Google Analytics profiles, I could either:
- manually export each profile to a spreadsheet
- or learn to use the Google Analytics API (or more sensibly hire someone to use the Google Analytics API)
- or buy a script such as GA Data Grabber (which is a fine script, but all that downloading/creating/graphing still takes desktop time)
- or create an aggregate Google Analytics profile, and let Google do all the heavy lifting
I opted for option 4 (create an aggregate GA profile) because after the initial bother of touching each of my sites to modify the onsite Google Analytics code, it pretty much gave me EXACTLY what I needed: an efficient way of looking for big picture trends across all my sites! This approach involves calling TWO Google Analytics profiles from each site. One dedicated to that domain, and the second being the Aggregate profile.
Here’s how I did it.
1) First I created a profile called “Aggregate” in Google Analytics. Unfortunately you need to specify a domain URL to do this. So pick one, let’s say “example.com”.
2) Then create another profile for example.com where you will FILTER out the aggregate traffic. Now you will have three profiles for domain example.com: Aggregate, Unfiltered, Filtered. For reporting purposes, you can ignore the Unfiltered profile. In Filtered, you need to add the following filter, which will ignore all the other domains which are being tracked, and only give you reports for “www.example.com”:
3) In the Aggregate profile, you need to add full URLs to the reports (such as “www.example.com/about-me/” ) because otherwise you will only see URIs which look like this: “/category/widgets/” or “aboutme.php” and you won’t know which site they belong to! Here is the filter you need to add to the Aggregate profile:
4) Now you need to add the Aggregate profile to the Google Analytics tracking code on each site you want included in the Aggregate profile. If you are using the standard asynchronous GA code for profile UA-111111-22, it will look like this before you add the aggregate profile to it:
Assuming your Aggregate profile is UA-333333-44, you will replace the two _gaq.push lines from the default code above, so your GA code now looks like this:
Now, rinse and repeat, modifying the GA code on each site you want included in your Aggregate profile. Have a good night’s sleep, and tomorrow you can check your Aggregate profile stats!
Let me know if this was helpful to you, by leaving a comment below.