Struggling to filter by Page (pagePath) using the Google Sheets Add-on for GA

[teddy....@vacasa.com]

Hi all,

I am currently trying to build out a fairly simple report using the Google Analytics add-on to use in Google Sheets. I am able to easily get the report to work when I don't use any filters, but I need to refine it by the page. For reference, I am using some standard traffic metrics (bounce rate, pageviews, etc.). I want to filter using a RegEx that the page contains '/trip'. Below is what I currently have in my filter box:

filters=ga:pagePath%3D~%5E%2Ftrip.*

but when I run the report I keep getting the error: "Invalid value 'filters=ga:pagePath%3D~%5E%2Ftrip.*' for filters parameter." I've tried several different syntaxes, but nothing I've found works. I would greatly appreciate any help.

Thanks!

[Mike Sullivan]

do not include the 'filters='...

[yachna varshney]

Hope you have got the answer by now, but if not try this....

ga : pagePath=~trip.*

[Jorge Aguayo Cabrero]

love yaaaaaa! thanks!! it worked for me

[Geoffrey Callaghan]

https://fabform.io/a/how-to-find-google-sheet-id