Skip to content

Filters ​

Filters are data-selection conditions that limit the set of rows included in a report. They let you include only the campaigns you need, exclude irrelevant data, or restrict output by metric values.

Types of filters ​

Dimension filters ​

  • Include — include only the specified values (for example, campaigns X, Y, Z)
  • Exclude — exclude the specified values (for example, brand campaigns)
  • Contains — include rows containing a substring
  • Not Contains — exclude rows containing a substring
  • Regex — filter using a regular expression

Metric filters ​

  • Greater Than (>) — metric value greater than N
  • Less Than (<) — metric value less than N
  • Between — metric value within the range [A, B]
  • Equals — metric value equal to N

Step-by-step instructions ​

1. Add a filter ​

In the builder, go to the Data > Filters section. Click Add filter.

2. Choose the filter type ​

Choose what to filter by:

  • By dimension — Campaign Name, Ad Group, Device, etc.
  • By metric — Impressions, Clicks, Cost, Conversions, etc.

3. Configure the condition ​

For a dimension filter:

  • Select a dimension from the list
  • Select an operator (Include/Exclude/Contains/Regex)
  • Enter a value or choose from the list of available values

For a metric filter:

  • Select a metric
  • Select a comparison operator
  • Enter a threshold value

4. Combine filters ​

You can add several filters. By default they are combined with AND — a row must satisfy all conditions at once. Switch to OR so a row only needs to satisfy at least one condition.

5. Verify the logic ​

The system shows the row count before and after filters are applied (if run history data is available).

Examples ​

  • Active campaigns only > Filter: Campaign Status = ENABLED
  • Exclude brand > Filter: Campaign Name Exclude "brand"
  • Significant campaigns > Filter: Cost > 100
  • Multiple campaigns > Filter: Campaign Name Include ["Campaign A", "Campaign B", "Campaign C"]

How to verify ​

  • Apply filters and run the report
  • Check that the excluded values are indeed absent from the output
  • Check the boundary values of metric filters (strictly greater/less than?)
  • Check the AND/OR logic against test data

Maintained by the LightLead Documentation Team · Last verified: 2026-07-25