Filter without dimensions added#1473

If a user wants to add filters to a query, it looks like they also have to add to the “select fields”, the dimensions that they want to use in the filter.

In so doing the output from the query could end up being too big: i.e. this error message will be displayed:

“Error: ERROR retrieving data: Error: Too big dataset for googlesheets.. Reach out to Support if you are unable to” Is there a way to use filter dimensions that are not added to the “select fields” part of the query?

By way of a tangible example, if a user wants to filter by type of landing page then they would need to add the landing page dimension to the query.

That would be fine if the user is only interested in a single page, but if they want to filter by all product pages then they need to use something in the URL such as /p/.

This will result in output which still shows thousands of pages.

If that is then combined with the ‘date’ for the last 365 days, you can see how the output quickly becomes too big.

This is a common example in which the user / analyst will want to view traffic entering on a specific page type over time in order to assess imact of bot traffic, a poblem that is growing.