In the query tool, you can include or exclude a list or different query.
Navigate to the Queries & Lists tab to see two tables of all the queries and lists in your organisation. There is a search bar to easily find one based on its name, or you can browse the rows.
Use an existing Query
Using a query within a query will allow you create more dynamic and specific queries.
Use an existing List
When a list is selected, you will see three options:
Exclude- This will exclude all contacts in the selected list from showing in the query results, even if they meet other criteria.
Include As Well- This will include all contacts in the list in the query results, even if they meet no other criteria set out.
Include Only- This will only include the contacts in the list in the query results. This can be used to find further detail on these contacts by adding more output columns.
Multiple lists can be added to your query, each with different criteria.
- Ensure you save your query before leaving the query tool