Urchin and Google Analytics Filters

As our Urchin servers are being migrated to a new platform at NTT, I needed to take stock of some of the filters we use for Urchin. I thought sharing them on our blog would be a good idea:

1) Add page title to request stem

Type: Advanced

Field A: request_stem (AUTO)
Extract A: (.*)

Field B: utm_page_title (AUTO)
Extract B: (.*)

Output to: request_stem (AUTO)
Constructor: $A1/$B1

Field A Required=Yes
Field B Required=Yes
Override Output Field=Yes
Case Sensitive=No


2) Add URI

Publish Post

Type: Advanced

Field A: cs_host (RAW)
Extract A: (.*)

Field B: request_uri (AUTO)
Extract B: (.*)

Output to: request_uri (AUTO)
Constructor:$A1$B1

Field A Required=Yes
Field B Required=Yes
Override Output Field=Yes
Case Sensitive=No

3) Add URI (for files)

Type: Advanced

Field A: cs_host (RAW)
Extract A: (.*)

Field B: request_origfilepath(AUTO)
Extract B: (.*)

Output to: request_uri (AUTO)
Constructor:$A1$B1

Field A Required=Yes
Field B Required=Yes
Override Output Field=Yes
Case Sensitive=No

4) Extract "type" parameter in URL and add it to URI (for display information normally only in the query

terms report)

Type: Advanced

Field A: request_stem (AUTO)
Extract A: (.*)

Field B: request_query (AUTO)
Extract B: (\?|&)(type)=([^&]*)

Output to: request_stem (AUTO)
Constructor:$A1/$B2=$B3

Field A Required=Yes
Field B Required=Yes
Override Output Field=Yes
Case Sensitive=No

5) Exclude User Names (assuming username is in Cookie)

Type: Exclude
Filter Field: cs_cookie (RAW)
Filter Pattern: username\]=(matt.trimmer\%40ivantage.co.uk\.co\.uk|sharron\.lonsdale\%

40ivantage\.co\.uk)(;|")

6) Extract user name to geo connection speed (assuming username is in Cookie)

Type: Advanced
Field A: cs_cookie (RAW)
Extract A: (username\])=([^(;|")]+)

Field B: (None)
Extract B:

Output to: geo_connection_speed(AUTO)
Constructor:$A2

Field A Required=Yes
Field B Required=No
Override Output Field=Yes
Case Sensitive=No

7) Extract user name to user defined (assuming username is in Cookie)

Type: Advanced
Field A: cs_cookie (RAW)
Extract A: (username\])=([^(;|")]+)

Field B: (None)
Extract B:

Output to: user_defined_variable (AUTO)
Constructor:$A2

Field A Required=Yes
Field B Required=No
Override Output Field=Yes
Case Sensitive=No

8) Extract user name to username field (assuming username is in Cookie)

Type: Advanced
Field A: cs_cookie (RAW)
Extract A: (username\])=([^(;|")]+)

Field B: (None)
Extract B:

Output to: user_defined_variable (AUTO)
Constructor:$A2


Field A Required=Yes
Field B Required=No
Override Output Field=Yes
Case Sensitive=No

9) Display Full URI for dynamic URLs

Type: Advanced

Field A: request_stem (AUTO)
Extract A: (.*)

Field B: request_query (AUTO)
Extract B: (.*)

Output to: request_stem (AUTO)
Constructor: $A1/$B1

Field A Required=Yes
Field B Required=Yes
Override Output Field=Yes
Case Sensitive=No

10) Display Full URI for dynamic URLs

Type: Advanced

Field A: request_stem (AUTO)
Extract A: (.*)

Field B: request_query (AUTO)
Extract B: (.*)

Output to: request_stem (AUTO)
Constructor: $A1/$B1

Field A Required=Yes
Field B Required=Yes
Override Output Field=Yes
Case Sensitive=No

11) Replace %40 with @ in connection speed

Type: Search and Replace

Type: Exclude
Filter Field: geo_connection_speed(AUTO)
Search String: %40
Replace String: %40


12) Merge visitor ID with username

Type: Advanced

Field A: sid (AUTO)
Extract A: (.*)

Field B: username (AUTO)
Extract B: (.*)

Output to: sid (AUTO)
Constructor: $A1, user=$B1

Field A Required=Yes
Field B Required=Yes
Override Output Field=Yes
Case Sensitive=No