How to filter out specific local call time hours?

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

How to filter out specific local call time hours?

Postby bronson » Sat Oct 23, 2021 3:54 am

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!
Vicibox10
Version: 2.14b0.5
SVN Version: 3529
DB Schema Version: 1645
bronson
 
Posts: 32
Joined: Thu Oct 14, 2021 10:34 am

Re: How to filter out specific local call time hours?

Postby mflorell » Sun Oct 24, 2021 6:49 am

We've had clients use a Filter to do this, using the gmt_offset_now field.
mflorell
Site Admin
 
Posts: 17909
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: How to filter out specific local call time hours?

Postby bronson » Mon Oct 25, 2021 2:37 am

mflorell wrote: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?
Vicibox10
Version: 2.14b0.5
SVN Version: 3529
DB Schema Version: 1645
bronson
 
Posts: 32
Joined: Thu Oct 14, 2021 10:34 am

Re: How to filter out specific local call time hours?

Postby mflorell » Mon Oct 25, 2021 6:30 am

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') )
mflorell
Site Admin
 
Posts: 17909
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: How to filter out specific local call time hours?

Postby bronson » Mon Oct 25, 2021 10:40 am

mflorell wrote: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?
Vicibox10
Version: 2.14b0.5
SVN Version: 3529
DB Schema Version: 1645
bronson
 
Posts: 32
Joined: Thu Oct 14, 2021 10:34 am

Re: How to filter out specific local call time hours?

Postby mflorell » Mon Oct 25, 2021 3:20 pm

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')
mflorell
Site Admin
 
Posts: 17909
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: How to filter out specific local call time hours?

Postby bronson » Wed Oct 27, 2021 5:19 am

mflorell wrote: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.
Vicibox10
Version: 2.14b0.5
SVN Version: 3529
DB Schema Version: 1645
bronson
 
Posts: 32
Joined: Thu Oct 14, 2021 10:34 am

Re: How to filter out specific local call time hours?

Postby mflorell » Wed Oct 27, 2021 7:19 am

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') ) )
mflorell
Site Admin
 
Posts: 17909
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: How to filter out specific local call time hours?

Postby bronson » Wed Oct 27, 2021 9:56 am

mflorell wrote: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.
Vicibox10
Version: 2.14b0.5
SVN Version: 3529
DB Schema Version: 1645
bronson
 
Posts: 32
Joined: Thu Oct 14, 2021 10:34 am

Re: How to filter out specific local call time hours?

Postby bronson » Wed Oct 27, 2021 9:57 am

mflorell wrote: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!
Vicibox10
Version: 2.14b0.5
SVN Version: 3529
DB Schema Version: 1645
bronson
 
Posts: 32
Joined: Thu Oct 14, 2021 10:34 am

Re: How to filter out specific local call time hours?

Postby bronson » Wed Oct 27, 2021 10:03 am

bronson wrote:
mflorell wrote: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.
Vicibox10
Version: 2.14b0.5
SVN Version: 3529
DB Schema Version: 1645
bronson
 
Posts: 32
Joined: Thu Oct 14, 2021 10:34 am

Re: How to filter out specific local call time hours?

Postby mflorell » Wed Oct 27, 2021 1:46 pm

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') ) ) )
mflorell
Site Admin
 
Posts: 17909
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida


Return to Support

Who is online

Users browsing this forum: No registered users and 49 guests