Analytics
1.8K members online now
1.8K members online now
Ask questions about filter set-up and issues with using filters in Google Analytics reports
 
Guide Me
star_border
Reply

GA Event Category filter on Spreadsheet

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi, im a beginner in GA ... I want to embed GA report into my website dashboard.

So, i created the report in GA and then using spreadsheet to get the iframe code and put into my website.

 

I tried to use Filter in my report, and it works on GA but when i tried to write the query in Spreadsheet ga:eventCategory=~/Services/ there no error but the data not appear in my spreadsheet.

 

I hope someone can help me to solve this. Thank you

 

 

GA Event Category filter on Spreadsheet

Follower ✭ ✭ ☆
# 2
Follower ✭ ✭ ☆

If you are using the slashes to do a RegEx match (like in JavaScript), they are not needed here. The =~ operator means 'contains', so if you want to match event categories that contain 'Services' instead of matching categories that contain '/Services/', you can remove the slashes.