> For the complete documentation index, see [llms.txt](https://community.commandersact.com/adloop/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://community.commandersact.com/adloop/iii-adloop-reports-system/screen-items/filters.md).

# Filters

### A - Column filters

You can access column filters thanks to the small **Filter** icon.

![](https://3498010832-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3KEERJBEyYQ7ZxIIMK79%2Fuploads%2Fgit-blob-4a2f1d27ba7f27413a6f3b6d87f576e52516eaf9%2Fimage-20220301-150255.png?alt=media)Non applied filter (grey colour):

![](https://3498010832-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3KEERJBEyYQ7ZxIIMK79%2Fuploads%2Fgit-blob-e94a7a45e46aaf06d3a8b63c4852d88b236a34c0%2Fimage-20210601-072004.png?alt=media)Applied filter (blue colour):

![](https://3498010832-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3KEERJBEyYQ7ZxIIMK79%2Fuploads%2Fgit-blob-d3d53e57fba74f1df294829b85c919ade6112f09%2Fimage-20210601-071423.png?alt=media)

#### 1 - Text filters

![](https://3498010832-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3KEERJBEyYQ7ZxIIMK79%2Fuploads%2Fgit-blob-2e47514de692b590e4483592f48b4cb2e8bd9f7a%2F1.png?alt=media) ![](https://3498010832-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3KEERJBEyYQ7ZxIIMK79%2Fuploads%2Fgit-blob-c64cb69450aba34f52dc8ac95553d16bb8c022c7%2F2.png?alt=media) ![](https://3498010832-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3KEERJBEyYQ7ZxIIMK79%2Fuploads%2Fgit-blob-a02d9d73301c064d3fd6519142108c53e9c212cd%2F3.png?alt=media)

By default, the filter value is **Contains** but you can access multiple values:

* Contains, does not contain
* Equals to, different from
* Begins with
* Ends with

Once you enter the value, it is applied **automatically** .

You can combine two filters thanks to the **AND/OR** functions.

By hitting the **RESET** button, you can delete all the filters.

#### 2 - Number filters

![](https://3498010832-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3KEERJBEyYQ7ZxIIMK79%2Fuploads%2Fgit-blob-2e47514de692b590e4483592f48b4cb2e8bd9f7a%2F1.png?alt=media) ![](https://3498010832-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3KEERJBEyYQ7ZxIIMK79%2Fuploads%2Fgit-blob-c64cb69450aba34f52dc8ac95553d16bb8c022c7%2F2.png?alt=media) ![](https://3498010832-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3KEERJBEyYQ7ZxIIMK79%2Fuploads%2Fgit-blob-a02d9d73301c064d3fd6519142108c53e9c212cd%2F3.png?alt=media)

By default, the filter value is **Equals to** , but you can access multiple values:

* Equals to
* Different from
* Stricly inferior to
* Inferior or equal to
* Stricly superior to
* Superior or equal to
* Between X and Y

Once you enter the value, it is applied **automatically** .

You can combine two filters thanks to the **AND/OR** functions.

By hitting the **RESET** button, you can delete all the filters.

### B - Data filters

![](https://3498010832-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3KEERJBEyYQ7ZxIIMK79%2Fuploads%2Fgit-blob-9eba754ec6d306630293399fb9d3105e613cd8c2%2Fimage-20220301-151116.png?alt=media)The data Filters Picker can be accessed by clicking on the ‘Funnel’ button in the reports top bar.

#### 1 - Filters Picker

By using the Filters Picker, you can filter the data displayed in your report. Filters can be applied to one or several **Dimensions Values** , even if the Dimension is not displayed in your report.

Example : I want to see the Adgroups and the Keywords of the Google Ads ‘Brand’ campaign.

![](https://3498010832-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3KEERJBEyYQ7ZxIIMK79%2Fuploads%2Fgit-blob-590a07f0ab560a1b6795e17b6f49d51befc4c706%2F22.png?alt=media)It is quite easy to use.

a - Areas (1) and (2): SearchYou can search the **Dimensions** names or **Values** of the selected dimension. You can choose where you are looking for in the zone (2).

b - Area (3): Available Dimensions list All the dimensions in which you can select filtering values will appear here.

c - Area (4) : Available values When you select a dimension, the possible values will appear here.

#### 2 - Add quickly a filter directly from your report

You can also add a Filter value by clicking on the Filter icon in any cell with a Dimension value.

![](https://3498010832-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3KEERJBEyYQ7ZxIIMK79%2Fuploads%2Fgit-blob-61d36100bfec6f2e64b4dea1f53a274eb960ed13%2Fimage-20220301-153136.png?alt=media)