Reference a list of values in Filters
How can I reference a list of values in Filters?
I am getting data from Facebook Ads and need to filter "Action type (with custom conv. IDs)" with a list of IDs.
Thanks
How can I reference a list of values in Filters?
I am getting data from Facebook Ads and need to filter "Action type (with custom conv. IDs)" with a list of IDs.
Thanks
Hi Benjamin,
You can use a cell reference in the Filter fields, something like "=A1". Sample attached:
Best,
Heidi / Supermetrics
I'm wondering whether I can use this cell reference method (or a different method) to reference a range of cells where I've stored the values I want to filter, i.e. in my case, for Google Search Console, Full URL Contains "=A1:A10", where I've stored the URLs for which I want the data in cells A1:A10. The query would then return the data, say, clicks, for only those URLs.
I'll test this myself, but I'm also wondering whether there may be a better way to do this.