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


2 people like this idea
  • 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. 

Login or Signup to post a comment