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