
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.