Skip to main content

How to filter reports with AND and OR conditions

Narrow a report with Dimension and Metrics filters, and combine them with AND and OR.

Written by Team adnova

Filters narrow a report down to the ads you care about. Filter by ad details like name, type or tags with Dimension, or by performance like Spend with Metrics.


​

OR conditions sit inside one filter and widen the results. AND joins separate filters and narrows the results.


​

Add a filter

  1. Click Dimension above the chart and pick what to filter by.


    ​

  2. Set the condition. To match more than one value, click Add OR Condition and add another row. Click Apply.


    ​

  3. To narrow the results further, click Dimension or Metrics again and add another filter. The filters bar shows how they are joined.


    ​

Filter by a metric

  1. Click Metrics, pick a metric, choose >, < or is between, enter a value and click Apply.


    ​

AND vs OR

OR

AND

How you add it

Add OR Condition inside one filter

A new filter from Dimension or Metrics

Shows ads that match

Any one of the conditions

Every filter

Effect on results

More ads

Fewer ads


​

Examples

You want

Filter

Ads for either of two products

Ad name contains Gut Gummies OR Ad name contains Collagen Bites

Only the video ads of those products

(the filter above) AND Ad type is Video

Video ads that spent over $1,000

Ad type is Video AND Spend > 1,000

Ads tagged as either winner tag

Tags contains WINNER OR Tags contains Top performer

Everything except one product

Ad name doesn't contain Focus Shot


​

When to use which

  • Use OR when any of several values is fine, like two products, two campaigns or two tags.

  • Use AND when an ad must pass every rule, like a product and a format, or a format and a minimum spend.

  • Keep alternatives for the same thing in one filter with OR. Put different rules in separate filters, so they are joined with AND.


​

Conditions you can use

Filter by

Conditions

Campaign name, Ad set name, Ad name, Tags, AI tags

contains, doesn't contain

Ad type, Ad distribution format, Ad status, Naming convention properties, Delivery (age, gender, platform, placement)

is, is not

Ad launch time

is (a date range)

Ad ID

is

Any metric

>, <, is between


​

Good to know

  • Filters apply to both the chart and the table.

  • Click the x on a filter to remove it.

  • Click Save at the top right to keep the filters in the report.


​

Related links


​

Need help? Message our support team from the chat icon in adnova.

Did this answer your question?