Remove trailing slash in Google Analytics report

Question

In Google Analytics, field Site Content report, I always receive two data about one link, one with slash and one non Like this:

/post-one.html
/post-one.html/

I want to receive only data of (/post-one.html), then I create a Search and Replace filter:

Search string: \.html/$
Replace string: \.html$

But it doesn't work. How can I do it?

Avinash Raj · Answer 1 · 2014-08-29T15:06:02.673

4

Search string: \/$

Replace string: empty string

edited Aug 29 '14 at 15:06

answered Aug 29 '14 at 08:57

Avinash Raj

172,303
28
230
274

Google Analytics told that this Regex is not valid – Charles Aug 29 '14 at 15:05
if it contains only html links then you could try the above. – Avinash Raj Aug 29 '14 at 15:06
The "regex" on this filter creator is sort of... -ish. In the examples, Google suggests "articles/post.php", so I tried without escaping the slash: "/$" and it let me save. – woodardj Nov 09 '14 at 23:12

score 2 · Answer 2 · answered Aug 29 '14 at 08:57

2

You've got an extra * in there. Remove it.
You also need to remove the regex Kung fu from the replace string:

Search string: \.html/$
Replace string: .html

answered Aug 29 '14 at 08:57

Bohemian

412,405
93
575
722

I still don't understand why my replace string: \.html$ doesn't work? Why do I need to remove Regex in replace string? – Charles Aug 29 '14 at 15:11
1

The replace string is not regex, it's plain text, although it may contain "back references" to captured groups, eg `\1` for group 1 etc. – Bohemian Aug 30 '14 at 02:33

woodardj · Answer 3 · 2014-11-12T04:06:39.247

1

Based on some of the other comments and some experimentation, I realized that the Google help text actually implies that forward slashes in the Search field don't need to be escaped (so it's only quasi-regex):

A common use case for the Search and Replace filter is to turn multiple URLs into one. For example, to merge 'example.com/article/CA/planning+your+trip.html' and 'example.com/article/NY/exploring+the+country.html' so that your reports for the profiles for which you will apply this filter will show 'example.com/article/', please follow these steps:

Search String: example\.com/article/.*
Replace String: example\.com/article/

So I was able to create a Search/Replace Filter with the following:

Search String: [^^]/$
Replace String: [blank]

And it appears to be working.

edited Nov 12 '14 at 04:06

answered Nov 09 '14 at 23:19

woodardj

313
1
2
12

1

I understand this Filter. Thank you for your help. In my situation, it's the best to use Behemian's one (answer below). Because it only changes the link end with .html/ - That's what I want. Your filter changes everything end with slash / – Charles Nov 11 '14 at 02:02
Fair point. I should also update this because it causes problems with the site root. ie: ^/$ – woodardj Nov 12 '14 at 04:06

Remove trailing slash in Google Analytics report

3 Answers3