Analytics
2.1K members online now
Understand information in your reports and troubleshoot reporting issues such as self-referrals, (not set) data, and inaccurate information
 
Guide Me
star_border
Reply

Site search: singular vs plural

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi,

 

I'm looking at the site search report and noticed singular vs plural search terms are different line items e.g. shirt vs shirts. Is there a way to roll this up through search parameters? I know that singular vs plural terms could provide different insights but was wondering if there was an option to even roll up.

 

Thanks!

Mel

1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Melanie T
November 2016

Re: Site search: singular vs plural

[ Edited ]
Participant ✭ ✭ ✭
# 2
Participant ✭ ✭ ✭

Hi Melanie,

 

That's a great question!

 

What you can do is that you can filter out those different words and analyze them together. If you have thousands of different words (singular and plural), it's not that easy to automatically combine all the different singular and plural words together, but it's possible. It just takes a bit more time.

 

First of all, let's start with the basic things. I would first filter out words "shirt" and "shirts" using this kind of regex: ^shirt$|^shirts$

 

a) Caret "^" - It means that something begins with… An example: ^shirt -> It matches shirt, shirts, shirts for summer but it doesn’t match skirts or summer skirts.

b) Pipe "|" - The pipe symbol means or.

c) Dollar sign ($) - It means that something ends with… An example: shirt$ -> It matches shirt, summer shirt, but it doesn’t match summer shirts or summer shirts for girls.

 

This regex: ^shirt$|^shirts$ will give you only those search queries: "shirt" or "shirts".  Now, you should go to your Google Analytics account -> Reporting -> Behavior -> Site Search -> Search Terms and enter this regex to this field:

Screen Shot 2016-11-28 at 23.26.15.png

 

Now you're able to analyze those results more easily. If you haven't yet configured site search, you'll find an amazing guide from here: https://support.google.com/analytics/answer/1012264?hl=en

 

Hope this helps. Let us know how it goes. We can go deeper as well later on. Smiley Happy

Taavi

View solution in original post

Marked as Best Answer.
Solution
Accepted by topic author Melanie T
November 2016

Re: Site search: singular vs plural

[ Edited ]
Participant ✭ ✭ ✭
# 2
Participant ✭ ✭ ✭

Hi Melanie,

 

That's a great question!

 

What you can do is that you can filter out those different words and analyze them together. If you have thousands of different words (singular and plural), it's not that easy to automatically combine all the different singular and plural words together, but it's possible. It just takes a bit more time.

 

First of all, let's start with the basic things. I would first filter out words "shirt" and "shirts" using this kind of regex: ^shirt$|^shirts$

 

a) Caret "^" - It means that something begins with… An example: ^shirt -> It matches shirt, shirts, shirts for summer but it doesn’t match skirts or summer skirts.

b) Pipe "|" - The pipe symbol means or.

c) Dollar sign ($) - It means that something ends with… An example: shirt$ -> It matches shirt, summer shirt, but it doesn’t match summer shirts or summer shirts for girls.

 

This regex: ^shirt$|^shirts$ will give you only those search queries: "shirt" or "shirts".  Now, you should go to your Google Analytics account -> Reporting -> Behavior -> Site Search -> Search Terms and enter this regex to this field:

Screen Shot 2016-11-28 at 23.26.15.png

 

Now you're able to analyze those results more easily. If you haven't yet configured site search, you'll find an amazing guide from here: https://support.google.com/analytics/answer/1012264?hl=en

 

Hope this helps. Let us know how it goes. We can go deeper as well later on. Smiley Happy

Taavi

Site search: singular vs plural

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

This is perfect - I will do this for our top 10 search terms week over week! I was basically manually doing it in excel Smiley Happy

 

Thanks for the prompt response - do you have any amazing guides like the above for regex tricks/definitions?

 

Mel

Site search: singular vs plural

Participant ✭ ✭ ✭
# 4
Participant ✭ ✭ ✭

Awesome! Smiley Happy

 

Here you can find a couple of amazing guides about this topic:

1) http://www.lunametrics.com/regex-book/Regular-Expressions-Google-Analytics.pdf

2) http://online-metrics.com/regular-expressions/

3) https://www.optimizesmart.com/regular-expression-guide-for-seos/

 

Here's a great tool that I use day-to-day in order to test different regular expressions: http://www.analyticsmarket.com/freetools/regex-tester

 

Hope this helps.

 

Cheers,

Taavi

Re: Site search: singular vs plural

[ Edited ]
Participant ✭ ✭ ✭
# 5
Participant ✭ ✭ ✭

Melanie, one more tip that would be useful.

 

The site visitors sometimes use different letter casings for their search terms. It's possible to enforce all these terms be recorded as lowercase so that it will be easier for you to analyze data. It's possible if you apply this filter:

  • Filter Name: Lowercase Search Term
  • Filter Type: Custom > Lowercase
  • Filter Field: Search Term

You can find it under Admin -> View -> Filters -> Add filter. It should look like this:

Screen Shot 2016-11-29 at 00.30.28.png

 

This filter will not change historical data that is already there in your reports but it will enforce all the search terms to be recorded as lowercase in the future. Smiley Happy

 

Taavi

Site search: singular vs plural

Visitor ✭ ✭ ✭
# 6
Visitor ✭ ✭ ✭

Taavi - this is amazing, I'm already looking to see if I can implement the lowercase change to our data and have already bookmarked your guides Smiley Happy thank you again!

 

Mel