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.


2 people like this idea
  • Hi Benjamin,

    You can use a cell reference in the Filter fields, something like "=A1". Sample attached:


    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. 

Login to post a comment