AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Analytics
2.9K members online now
2.9K 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.