Lead Filtering allows leads to be filtered against a set of SQL query fragment's. This is most commonly used to filter leads by the number of times called.

Notes on Lead Filtering:

Requires some understanding of SQL queries.
Do not begin or end with an AND, that will be added by the hopper cron script automatically.
An example SQL query that would work here is "called_count > 4 and called_count < 8".

Creating a lead filter 

1. Login to the Vicidial Admin page.
2. Click the Filters tab at the top of the page.
3. Enter a Filter ID.
   Filter ID - This is the short name of a Vicidial Lead Filter. This needs to be a unique identifier. Do not use any spaces or punctuation for this field. max 10 characters, minimum of 2 characters.
4. Enter a Filter name.
   Filter Name - This is a more descriptive name of the Filter. This is a short summary of the filter. max 30 characters, minimum of 2 characters.
5. Enter the Filter Comments.
   Filter Name - This is a more descriptive name of the Filter. This is a short summary of the filter. max 30 characters, minimum of 2 characters.
6. Enter the Filter SQL.
   Filter SQL - This is where you place the SQL query fragment that you want to filter by. do not begin or end with an AND, that will be added by the hopper cron script automatically. an example SQL query that would work here is "called_count > 4 and called_count < 8".
7. Click the Submit button to save the Filter.

Enabling the Filter in a Campaign

1. Login to the Vicidal Admin console.
2. Click the Campaigns tab at the top of the page.
3. Click the Modify link for the campaign you want to change.
4. Find the "Lead Filter" setting and choose the filter from the drop down dox.
5. Click the Submit button to save the changes.