Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to see users search phrases in Confluence Cloud in Google Analytics and parse it?

Edited

Hello folks.

I think everybody who involved with the creating huge contents for clients wants to make the content better and wants to know what are the users really need from your documentation.

We are using Confluence Cloud and provide our internal and public content. Also, we use Google Analytics to see the statistics. Of course just the visits' calculation is not enough we want to know what really users searched.

1. I mentioned that every time when user is searching an information using the web address for search page /wiki/dosearchsite.action?cql=siteSearch

2. When we look into the construction we can identify phrase which user typed if it pressed Enter button when putting the phrase in the sidebar or standard search field

01.png

3. OK. Now we know full web requests with the search phrase.

4. Of course, your Confluence Cloud has to be connected to the Google Analytics plugin. Its free)

5. Open the Google Analytics: Behavior -> Site Content -> All pages -> type in the search field value siteSearch -> and bingo now we can see all web strings with the users' phrases search. Don't forget to set up the period which you need.

02.png

UPD 05.11.2020. As we now Atlassian changed search header. And now if you want to see search requests you have to find combination text=

NewSearch.png

6. Next step we need to do the results to look the pretty view.

7. Set up rows quantity.

03.png

8. Push Export -> choose Excel format.04.png

9. OK. You can automate this using different tools, such as grep, awk, or etc. I did it in Microsoft Excel and Notepad++.

10. In the Excel, you can do different things, such as change the text or split the rows

05.PNG

06.PNG

11. I also used Notepad++ to do mass changes in the text.

07.PNG

12. And finally, go the result. 

08.PNG

Maybe this workaround will be helpful.

 

0 comments

Comment

Log in or Sign up to comment
TAGS
Community showcase
Posted in Trello

Taco Tuesday: Your favorite Trello blog takeaway

Hello friends! From the community that brought you Welcome Wednesday, Throwback Thursday and Friday Fun, welcome to Taco Tuesday, a weekly discussion about all things Trello. The best part? One Tac...

53 views 3 3
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you