November 11th, 2009 | Published in Google Analytics
Here are three more interesting uses of the new Advanced Table Filtering:
Looking for specific non-branded keywords
Sometimes, it helps to see keywords that contain a certain word or phrase, but exclude the brand name. Taking a company called DeLallo Italian Foods, for example. If I wanted to see all the keywords that contain the word Italian food but exclude the brand name DeLallo, I could easily use the advanced filters for this. Previously, I would have done this using regular expressions in the filter:
Filter Keyword: containing ^(?=.*italian food)(?!.*(delallo)).*
No more! Now, we don't need to do this! Now, it is so easy with the advanced filters. Just filter for Keyword containing Italian food and excluding DeLallo.
And presto! Your report is updated. And, at any time, you can edit this filter to further refine it, or delete it altogether.
Landing Pages, Sorted by Bounce Rate
Has this ever happened to you - you're looking at your Top Landing Pages report, and you sort by bounce rate, only to have a bunch of pages with 1 entrance clogging the top of the report? With advanced filters, you can filter out those pages with a low number of entrances to get a better look at which landing pages with significant traffic have a high bounce rate. All you have to do is filter by Entrances greater than 50 (or whatever threshhold floats your bounce-rate-boat).
Top Content, Sorted by $ Index
Another similar use for sites with e-commerce or a goal value enabled is when you're looking at the Top Content report, sorted by $ Index. What you're trying to find are the pages that have the highest value - those that are viewed during a visit that results in a conversion. Again, it's common to get a lot of pages at the top that have a low number of pageviews.
First, it helps to filter out those pages that have a low number of pageviews. But once you do that, you'll likely see the pages with the highest $ Index are pages of your shopping cart or checkout process. We can filter out these pages with the advanced filters too - just add a new condition below your first filter that excludes pages that contain the word cart (or checkout, etc.) in the URL.
These three examples give you a taste of Advanced Table Filtering for your analytics, but they just scratch the surface. Once you explore your own analytics, I’m sure you’ll find many more uses of this flexible and powerful new feature. You'll really notice it's use when you find you're happily lingering for 5 extra minutes, using this new interface feature to easily gain insights and ask questions that would've taken you an hour before and possibly a data export. Pure wizardry. :)