How to set Up a month in Lead Recycling?

[toxi]

Hello.
How to set Up a month in Lead Recycling?


VERSION: 2.12-571a
BUILD: 161031-1415

[mflorell]

You don't, it's not designed to work past 1 day.

Maybe if you explained in more detail what you are trying to accomplish, we could offer an alternative option.

[toxi]

It is necessary to make the numbers with a certain status, the system will ring up at the end of the entire lead (list of numbers), as well as to be able to postpone some of the numbers to call statuses for 1 week / month / six months.
Maybe there is some option?

[mflorell]

That would be best to do with filters, here's one for delaying calling NI status leads for 7 days:

( ( (status='NI') and (last_local_call_time < CONCAT(DATE_ADD(CURDATE(), INTERVAL -7 DAY),' ',CURTIME()) ) ) or (status != 'NI') )

[williamconley]

If you want to have detailed control, you can also write a script that resets the "called since last reset" value on the leads based on your logic nightly. Then avoid resetting the lists manually and let your script to the trick. This reduces the load on the DB server that may result from a filter (not a problem if you have a small system, but if you have a larger system it can become a problem pretty quickly to have a lot of complex filters).

A nightly (or hourly?) mysql script that makes the change once per day/hour takes a lot less cpu cycles than a filter that runs every minute on every campaign all day long.

[toxi]

If you want to have detailed control, you can also write a script that resets the "called since last reset" value on the leads based on your logic nightly. Then avoid resetting the lists manually and let your script to the trick. This reduces the load on the DB server that may result from a filter (not a problem if you have a small system, but if you have a larger system it can become a problem pretty quickly to have a lot of complex filters).

A nightly (or hourly?) mysql script that makes the change once per day/hour takes a lot less cpu cycles than a filter that runs every minute on every campaign all day long.

It can be an example of such a script, if there is such a possibility?

[toxi]

That would be best to do with filters, here's one for delaying calling NI status leads for 7 days:

( ( (status='NI') and (last_local_call_time < CONCAT(DATE_ADD(CURDATE(), INTERVAL -7 DAY),' ',CURTIME()) ) ) or (status != 'NI') )

This request must be run in the database each time a new entry with the desired status appears?

[mflorell]

That is a "Filter", you create a new filter in the web admin and then enable it for your campaign. None of that requires you to manually run anything on the database.