Reference a list of values in Filters

B

Benjamin Pang

started a topic almost 2 years ago

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

Heidi Virta
said almost 2 years ago

Hi Benjamin,

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

Best,
Heidi / Supermetrics
M

Matt Brodie
said 9 months ago

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

Didn't find what you were looking for?

Start a new topic