Sorry, we don't support your browser.  Install a modern browser

Google Sheets add-on: allow filtering on fields that are not selected/displayed#1953

In the Google Sheets add-on, filters can only be applied to fields that are selected in Select Fields. If a field isn’t displayed, you can’t filter on it - which forces unwanted dimensions into the output.

Example: Show cumulative monthly performance (clicks, impressions, spend by year-month) across all campaigns whose name contains “DE_KS”. Today this only works if you add Campaign Name as a field - but that then splits every row by campaign, breaking the intended monthly aggregate. There’s no way to filter by campaign while keeping it out of the output.

Requested: In the add-on, let users filter on any field regardless of whether it’s selected for display (as Supermetrics does).

Important: This already works at the API level - the connector extracts the filter field, applies it, and drops it from the output. Example (from our own docs):

https://connectors.windsor.ai/facebook?fields=date,spend&filter=[["spend","gt",100],"and",["campaign","contains","Sale"]]&api_key=...

(docs: https://windsor.ai/applying-filters-to-queries/). So this is purely a Google Sheets add-on UI gap, not an API limitation.

2 hours ago