Reputation: 71
Using the google analytics query explorer, I would like to limit the output of the following data:
Example data
ga:pagePath
/100464.html
/108659.html?promid=1552
Aim
only get the numbers from pagepath, so:
ga:pagePath
100464
108659
Tried
The following filter fails:
ga:pagePath=/....
With following error message:
400 : Invalid value 'ga:pagePath=/....' for filters parameter.
Solution
Thanks to Eike Pierstorff -> this is not filtering. This is programming logic.
E.g. a filter is used to narrow down the data but NOT control/ change how the output is returned.
To only get the numbers, use a regex in your programming code. An example on how to do so is given here.
Upvotes: 2
Views: 2841
Reputation: 116968
its == not =
== (Equals) %3D%3D Return results where the time on the page is exactly ten seconds: filters=ga:timeOnPage%3D%3D10
so try
ga:pagePath==/
ga:pagePath==/?attachment_id=106
for fun: returns everything with a ?
ga:pagePath=@?
Upvotes: 3