How to filter out specific local call time hours?

[bronson]

Hey vicicrew,
I would like to filter out certain hours during the call time window at a campaign level. Specifically, I'd like to block dialing during local lunchtime.

We're calling nationwide and my local call time is set to 8:00am - 6:00pm local time but I would like to filter out calling between 12:00pm and 1:00pm local time.

I don't want to create 2 campaigns, for example, morning and afternoon campaigns. I'd prefer to keep everything in one campaign and simply filter out lunchtime local time dialing.

How best to accomplish this? Can I create a campaign filter or is there some way to set it up through the call time rules?

thanks!

[mflorell]

We've had clients use a Filter to do this, using the gmt_offset_now field.

[bronson]

We've had clients use a Filter to do this, using the gmt_offset_now field.

thanks, Matt, can you give me an example of how that would look? exclude calling between 12:00 to 13:00?

[mflorell]

This Filter would exclude the 12-oclock hour for EST(Eastern Standard Time) leads on an EST-configured system, during standard time only(not during daylight savings time):

( (hour(now()) <= 11) and (hour(now()) >=13) and (gmt_offset_now='-4.0') )

[bronson]

This Filter would exclude the 12-oclock hour for EST(Eastern Standard Time) leads on an EST-configured system, during standard time only(not during daylight savings time):

( (hour(now()) <= 11) and (hour(now()) >=13) and (gmt_offset_now='-4.0') )

thanks again, Matt. Is there a resource where I can learn more about the different filter options available? I have the paid managers manual but it only has a few examples. Is there some list somewhere I can use as a reference so I can build my own filters?

[mflorell]

We don't really have a single reference for filter examples, but there are probably dozens spread out through the Forums. Here are a few:

Below are several examples of Filters that can be used to further limit VICIdial outbound calling

72 hour block on auto-Answering-Machine detected calls -
This specific example was used to comply with the UK's OFCOM auto-dialing regulations to not call back auto-detected answering machines within 3 days of the last attempt:
( ( (status='AA') and (last_local_call_time < CONCAT(DATE_ADD(CURDATE(), INTERVAL -3 DAY),' ',CURTIME()) ) ) or (status != 'AA') )

Two examples for blocking areacodes -
These examples are for two areacodes in Puerto Rico:
(left(phone_number,3) NOT IN('787','939'))
(phone_number NOT LIKE '787%' AND phone_number NOT LIKE '939%')

Exclude a list of cities:
(city NOT IN('london','paris','tampa'))

Include only specific states:
state IN('FL','NY','CA')

Do not call NI(Not Interested) leads for 7 days
( ( (status='NI') and (last_local_call_time < CONCAT(DATE_ADD(CURDATE(), INTERVAL -7 DAY),' ',CURTIME()) ) ) or (status != 'NI') )

No more than one call per lead per 24 hours:
(last_local_call_time < CONCAT(DATE_ADD(CURDATE(), INTERVAL -1 DAY),' ',CURTIME()) )

Multiple filters in one -
This filter was designed to limit the call attempts, states and time zones of leads:
called_count IN('7','8','9') and state NOT IN('CA','OR','WA') and gmt_offset_now IN('-4','-5')

[bronson]

This Filter would exclude the 12-oclock hour for EST(Eastern Standard Time) leads on an EST-configured system, during standard time only(not during daylight savings time):

( (hour(now()) <= 11) and (hour(now()) >=13) and (gmt_offset_now='-4.0') )

I tested this and it did not work for me. It reduced my list to 0 available records.

[mflorell]

What time zone are your leads in?

What time zone is your server set to?


Try this one:

( ( (hour(now()) <= 11) and (hour(now()) >=13) and (gmt_offset_now='-4.0') ) or ( (hour(now()) >= 0) and (gmt_offset_now!='-4.0') ) )

[bronson]

What time zone are your leads in?

What time zone is your server set to?


Try this one:

( ( (hour(now()) <= 11) and (hour(now()) >=13) and (gmt_offset_now='-4.0') ) or ( (hour(now()) >= 0) and (gmt_offset_now!='-4.0') ) )

the server is set to eastern time. the leads are across all US time zones.

[bronson]

What time zone are your leads in?

What time zone is your server set to?


Try this one:

( ( (hour(now()) <= 11) and (hour(now()) >=13) and (gmt_offset_now='-4.0') ) or ( (hour(now()) >= 0) and (gmt_offset_now!='-4.0') ) )

this one seems to work!

[bronson]

What time zone are your leads in?

What time zone is your server set to?


Try this one:

( ( (hour(now()) <= 11) and (hour(now()) >=13) and (gmt_offset_now='-4.0') ) or ( (hour(now()) >= 0) and (gmt_offset_now!='-4.0') ) )

this one seems to work!

question, will this automatically filter out all calls between 12:00 and 1:00 pm across all time zones, or do I need to modify the filter for each time zone?

for example, from 12:00 pm to 1:00 pm eastern time EST leads won't be dialed,
then from 1:00pm to 2:00pm eastern time, CST leads won't be dialed,
then from 2:00 pm to 3:00 pm eastern time, MST leads won't be dialed,
etc...

that's the result I'm trying to achieve.

[mflorell]

Nope, it's time-zone specific for Eastern Daylight Time as written. If you want EDT, CDT, MDT, PDT you would do something like this:


( ( ( (hour(now()) <= 11) and (hour(now()) >=13) and (gmt_offset_now='-4.0') ) or ( (hour(now()) >= 0) and (gmt_offset_now!='-4.0') ) ) and ( ( (hour(now()) <= 12) and (hour(now()) >=14) and (gmt_offset_now='-5.0') ) or ( (hour(now()) >= 0) and (gmt_offset_now!='-5.0') ) ) and ( ( (hour(now()) <= 13) and (hour(now()) >=15) and (gmt_offset_now='-6.0') ) or ( (hour(now()) >= 0) and (gmt_offset_now!='-6.0') ) ) and ( ( (hour(now()) <= 14) and (hour(now()) >=16) and (gmt_offset_now='-7.0') ) or ( (hour(now()) >= 0) and (gmt_offset_now!='-7.0') ) ) )