Useful regular expressions in Google Analytics

Google Analytics support for regular expressions has come in handy a few times when I've needed to aggregate data from a few specific segments. To use regular expressions, scroll to the bottom of the report, where there is a dropdown menu and an input field that allows you to filter the data.

Google Analytics regular expression input field

Without further ado:

What percentage of users are using Flash 8 or higher?

Report: Visitors » Browser Capabilities » Flash Versions
Filter type: Include
Regular expression: 8\.|9\.|10\.

What percentage of users are using Flash 9?

Report: Visitors » Browser Capabilities » Flash Versions
Filter type: Include
Regular expression: 9.*

What percentage of users are on broadband connections?

Report: Visitors » Network Properties » Connection Speeds
Filter type: Exclude
Regular expression: dialup|unknown

What percentage of users have screen resolutions 1000 pixels or higher?

Report: Visitors » Browser Capabilities » Screen Resolutions
Filter type: Include
Regular expression: [1-9][0-9][0-9][0-9]x
Note: the trailing 'x' ensures that you're matching a four-digit width (i.e., greater than 1000 pixels. Without it, the regular expression will match oddball resolutions like 800×1500. There probably aren't enough of those to make a significant difference, but the trailing 'x' makes the result set more exact.

Learn everything you could possibly want to know about regular expressions in Google Analytics on this LunaMetrics blog post.

zp8497586rq
|
Posted in | Comments Off

Comments are closed.