How to use Advanced Filters

BETA This feature is currently in BETA. We're working on improving the quality over time. If you have any feedback, please get in touch at support@onepagecrm.com

To enable Advanced Filters drop us an email by clicking on the link in the Filter pop-up tooltip:

Enable Advaned filters from the tooltip

Advanced Filters allow you to search through your database and create multi-layered reports with saved Filters and conditions.

Choose your search criteria and then decide whether you want to include or exclude any saved Filters or show contacts that meet both—your search criteria and the specified saved Filters.

How to save a Filter

To read more about Filters, check here.

1
In the left-hand side menu hover over Filters → Click on the + icon.
2
Set criteria in the Filter pop-up → Name your Filter.
3
Click on the Save & Run button to Save it.

How to save a Filter

How to add a saved Filter

1
In the left-hand side menu hover over Filters → Click on the + icon to create a new Filter or select an existing Filter from the list.
2
In the Filter pop-up click on Add saved Filter

Add saved filter

3
Select a saved Filter from the dropdown by clicking on the Filter's name.

Select saved Filter from the dropdown

Once the Filter is selected, you can choose to Include, Exclude, or show contacts that are In common with your search criteria. Include is selected by default.

How to add saved Filters to search criteria

Include

This option allows you to add results from the saved Filter to your new criteria.

If a contact meets both—your new criteria and the saved Filter's criteria, it will be counted only once. For example, if a Contact's address country is Ireland and the Lead source is an Affiliate, it will be counted as a single occurrence.

In the example below, if you run this search, you will see all contacts with the address in Ireland and those with the Lead source Affiliate.

Include saved Filter

Exclude

You can Exclude saved Filter results from your search criteria by choosing the Exclude option from the dropdown.

The resulting contacts will match the search criteria excluding those that match the saved Filter.

In the example below, if you run this search, you will see all contacts with the address in Ireland but not those with the Lead source Affiliate.

Exclude saved Filter

In common

The In common option allows you to show contacts that match the intersection of your search criteria and the chosen saved Filter.

In the example below, if you run the search, you will see all contacts with an address in Ireland that also have the Lead source Affiliate.

In common saved Filter

How to save an Advanced Filter

Advanced Filters can be saved and used in the exact same way as regular Filters.

Once you specify the search criteria and its relation to the specific saved Filters → Click on the Save & Run button to create and save an Advanced Filter.

Save Advanced Filter

Notes:

  • Multiple Saved Filters can be combined together.
  • It is possible to save a saved Filter that contains another saved Filter and add it to an Advanced Filter (multi-level saved Filters).
  • Advanced Filters used on a large number of contacts can take a while to run.
  • The number of available contacts in a Filter is shown in the top right corner of the Filter pop-up.
  • Advanced Filters can also be used in the Pipeline. See here.

Still need help? Contact Us Contact Us