Report to breakdown calls per areacode and DID's needed

Any and all non-support discussions

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

Report to breakdown calls per areacode and DID's needed

Postby carpenox » Sun Jan 12, 2025 12:49 am

I created a New repo on github fellas for custom reports - the first one will break down how many calls were made to each area code based on a date range, suggest the amount of DID's you should have for each area code based on the data collected for that date range(based on a 6 day work week with less than 50 calls per DID per day which is the new spam math for 2025) and the ability to export that data to a CSV file


https://dialer.one/index.php/custom-vic ... on-github/


Chris aka carpenox
Alma Linux 9.5 | SVN Version: 3920 | DB Schema Version: 1725 | Asterisk 18.26.0 | PHP8
https://dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WA: +19549477572
DC: https://discord.gg/DVktk6smbh -:- TG: https://t.me/+wkDmkF9U4aUxOGYx
carpenox
 
Posts: 2595
Joined: Wed Apr 08, 2020 2:02 am
Location: St Petersburg, FL

Re: Report to breakdown calls per areacode and DID's needed

Postby carpenox » Sun Jan 12, 2025 4:25 pm

I added two new reports that will break down calls to each area code per campaign within a set date range and the same report with a breakdown of how many DID's you should have per area code for each campaign.
Alma Linux 9.5 | SVN Version: 3920 | DB Schema Version: 1725 | Asterisk 18.26.0 | PHP8
https://dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WA: +19549477572
DC: https://discord.gg/DVktk6smbh -:- TG: https://t.me/+wkDmkF9U4aUxOGYx
carpenox
 
Posts: 2595
Joined: Wed Apr 08, 2020 2:02 am
Location: St Petersburg, FL

Re: Report to breakdown calls per areacode and DID's needed

Postby carpenox » Sun Jan 26, 2025 11:05 am

anyone have any other report ideas?
Alma Linux 9.5 | SVN Version: 3920 | DB Schema Version: 1725 | Asterisk 18.26.0 | PHP8
https://dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WA: +19549477572
DC: https://discord.gg/DVktk6smbh -:- TG: https://t.me/+wkDmkF9U4aUxOGYx
carpenox
 
Posts: 2595
Joined: Wed Apr 08, 2020 2:02 am
Location: St Petersburg, FL

Re: Report to breakdown calls per areacode and DID's needed

Postby williamconley » Sun Jan 26, 2025 11:42 am

carpenox wrote:anyone have any other report ideas?


ACD / ASR / Short Call %
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # 888-883-8488 # +44(203) 769-2294
williamconley
 
Posts: 20444
Joined: Wed Oct 31, 2007 4:17 pm
Location: Bartow, FL (In the boondocks)

Re: Report to breakdown calls per areacode and DID's needed

Postby carpenox » Sun Jan 26, 2025 11:55 am

well those stats are already on real time report minus SCD which isnt a bad idea
Alma Linux 9.5 | SVN Version: 3920 | DB Schema Version: 1725 | Asterisk 18.26.0 | PHP8
https://dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WA: +19549477572
DC: https://discord.gg/DVktk6smbh -:- TG: https://t.me/+wkDmkF9U4aUxOGYx
carpenox
 
Posts: 2595
Joined: Wed Apr 08, 2020 2:02 am
Location: St Petersburg, FL

Re: Report to breakdown calls per areacode and DID's needed

Postby williamconley » Wed Jan 29, 2025 11:42 am

per carrier. so clients can gauge their barriers to lower pricing options.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # 888-883-8488 # +44(203) 769-2294
williamconley
 
Posts: 20444
Joined: Wed Oct 31, 2007 4:17 pm
Location: Bartow, FL (In the boondocks)

Re: Report to breakdown calls per areacode and DID's needed

Postby carpenox » Fri Jan 31, 2025 6:56 am

oh thats a bit harder, thats a rather complex mysql query, let me see if i can figure it out
Alma Linux 9.5 | SVN Version: 3920 | DB Schema Version: 1725 | Asterisk 18.26.0 | PHP8
https://dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WA: +19549477572
DC: https://discord.gg/DVktk6smbh -:- TG: https://t.me/+wkDmkF9U4aUxOGYx
carpenox
 
Posts: 2595
Joined: Wed Apr 08, 2020 2:02 am
Location: St Petersburg, FL

Re: Report to breakdown calls per areacode and DID's needed

Postby williamconley » Fri Jan 31, 2025 1:08 pm

maybe just by "dial prefix" then. Since at present Vici doesn't really record the Carrier. Adding code to identify the carrier used for each call, however, that would make a lot of people happy.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # 888-883-8488 # +44(203) 769-2294
williamconley
 
Posts: 20444
Joined: Wed Oct 31, 2007 4:17 pm
Location: Bartow, FL (In the boondocks)

Re: Report to breakdown calls per areacode and DID's needed

Postby carpenox » Sat Feb 01, 2025 11:19 am

not a bad idea, let me see what i can come up with
Alma Linux 9.5 | SVN Version: 3920 | DB Schema Version: 1725 | Asterisk 18.26.0 | PHP8
https://dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WA: +19549477572
DC: https://discord.gg/DVktk6smbh -:- TG: https://t.me/+wkDmkF9U4aUxOGYx
carpenox
 
Posts: 2595
Joined: Wed Apr 08, 2020 2:02 am
Location: St Petersburg, FL


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 33 guests