Filtering Your Data: Unofficial Google Analytics Blog

By Michael Harrison, Google Analytics Support Tech

Control is everything when it comes to web site analytics. You want to make sure you're tracking the right data, and you need to make sure you're tracking the data right. With traffic filters, you can control exactly which data are flowing into your Google Analytics profile, and which aren't.

There are three predefined filters that you can use, right out of the box:

Exclude all clicks from a domain (hostname), which can be used to exclude all clicks originating from one network. Get rid of the hits from your internal office network. Just plug in your hostname here and apply to your profile.
Exclude all clicks from an IP address, which is great for removing any clicks from a single IP address, or even a range of IP addresses. Take a visit to www.whatismyip.com, then plug in the IP address here to exclude any computer that has a static IP address from your data results.
Include only traffic from a subdirectory will allow you to set your profile to only report on a subdomain or a subdirectory. Use this to only see traffic to your nonfiction titles (www.example.com/nonfiction/) or to your user's section (users.example.com).

In addition, you can apply custom filters to any of your profiles. Use Exclude Patterns to remove hits that contain certain criteria (visitor's browser type, operating system, or even the city they're surfing in from). Include Patterns do the opposite, so be careful with them. You'll be matching only results that match your filter, and excluding everything else.

Search and Replace filters are great for converting query strings into useful Analytics data. /fiction/detail.php?id=9376 doesn't mean much to the average user, but change it to /fiction/detail/harrypotter5, and everyone's on the same page, so to speak.

Lookup Tables and Advanced filters, while more complex than the filters listed above, are also great tools for manipulating the data coming into your Analytics profile. For more information on applying the right filters to your website's Google Analytics profile, drop us a line or check out the Google Analytics Help Center.

Comments

I've been fiddling with filters but I don't see any (immediate) changes in the reports.

So, my question is, when do the filters take effect? As data is collected? Or, as it is compiled into reports?

If the former, how do you retain comparability with history if you tweak the filters as you go along?

And, if the later, what is the refresh rate for the report generation?

- nello

Posted by: Nello Lucchesi at January 13, 2006 6:04 PM

Hey Nello. The filters are applied as the data is collected. Currently, there's no way to process historical data, but Google have hinted that the feature may be re-implemented in the future.

If you'd like for us to keep you informed over the status of this, and many other features in Google Analytics, please take a look at our email newsletter, ROI Revolution News.

Posted by: Michael Harrison at January 16, 2006 2:58 PM

I am using the Search and Replace filter to help Identify the pages in GA but I don't think it is working correctly. My site creates pages that have dynamic URL's and the URI's look like this /pagina.asp?DocID=15
So I do a search and replace filter and replace it with this /pagina/AboutUs to reconize it. The question that I have is what Filter Field selection do I use from the drop down box when using this filter?

Posted by: Philippe Ward at March 25, 2007 12:40 PM

Hey Philippe. You need to use the Request URI filter field. Also, be sure to escape out certain characters like the period (.) and the question mark (?) with a backslash (\). This will ensure that the regex operates properly.

Posted by: Michael Harrison at March 26, 2007 8:39 AM

Michael,
I have done this and it doesn't seem to be working. Here is what I set up

Filter Type = Search and Replace

Filter Field = Request URI

Search String = /pagina.asp?DocID=17

Replace String = /pagina/DebtConsolidationPage

Case Sensitive = No

Does this look correct to you?

Thanks,
Philippe

Posted by: Philippe Ward at March 27, 2007 3:00 PM

Philippe, it's really important that you escape out the period and the question mark with a backslash. Your search string should be /pagina\.asp\?DocID=17

The search strings can utilize regular expressions. For more info on regex, check out Regular-Expressions.info.

Posted by: Michael Harrison at March 27, 2007 4:27 PM

Hi guys,

I've been trying to clean up my analytics data and just wanted to confirm that any query parameters you exclude in your settings will only affect future data, and will not exclude the query parameters in URL's of past data; is that right?

So for example I have this URL:

/site/training-class2.php?st=Completed&amt=799.00&cc=USD&cm=&item_number=2583&sig=qLO8+m+rzF70wNGQzqUvBz//iHdywPLZLmjSC

Every time someone signs up for our training, they land on this unique confirmation URL which is essentially the same page. So I am seeing many of these but they are the same page and I want to combine data for all of them into one recognizable URL; GA sees them as different pages because they pass unique info in the query parameters.

So if I set up my profile to exclude all of those query parameters, would I still all of those unique URL's when looking at past data, and anything from this point forward would be combined into one?

Would a ^/site/training-class2.php search and replace filter work on past data so that I could rename all of those URL's as one? I wonder if that would work on past data as well.......

Jesse

Posted by: Jesse DaCosta at June 2, 2008 10:54 AM

Post Your Comments

Filtering Your Data

TrackBack

Comments

Post Your Comments

Post a comment