Reporting Question

[NJohnson]

We are a multi-rooftop company with roughly 270 extensions total, a SIP trunk to our local telco company for all our DIDs and external service, and we have roughly 70 DIDs on that one SIP trunk. That said, in version 18, the reporting would allow you to select specific DIDs to generate an inbound statistics report that I could email or give to the manager at each of our locations as needed. In version 20, there really isn't any way to select specific DIDs, or at least that I've been able to find. Is there another way to accomplish this in V20? I know I can't be the only person who needs reports based on DIDs. How are other 3CX users approaching this?

 

[Alejandro_3CX]

Hi @NJohnson did you check the inbound calls report?

You can get the inbound calls on the specific trunk and DIDs.

 

[NJohnson]

I see that and it's helpful, but that's more of a call log report. What I'm looking for is something that shows the total number of calls broken down by answered/unanswered calls over the given date/time range for specific DID(s). I think it was called "Inbound Statistics Report" in V18. The way we have things configured is that each of our stores is a department in 3cx and each of the store's main DID gets routed to their own auto attendant where the caller can select which department of that store they want to go to and then it's routed to the appropriate call queue or ring group. So in the past (V18) when a store manager would ask for a report for last month's total calls broken down by their departments, I would send them the inbound statistics report for their DID and then send them the call queue statistics report containing all their call queues. I can still get them the call queue statistics no problem. It's just the total # of calls for their store that I'm struggling with. Also, I should mention that not all auto attendant options go to a call queue/ring group (but most do). Some go to a individual, which makes it harder if I can't get a total based on DID.

 

[Alejandro_3CX]

Hi @NJohnson you might want to look into these integrations. Setting one of these up will make it much easier to handle any custom reporting requests your store managers might have, giving you a lot more flexibility than the built-in reports:

• https://www.3cx.com/blog/docs/mcp-server-custom-reporting/
• https://www.3cx.com/blog/docs/bigquery-sql-gemini-google-adk/
• https://www.3cx.com/docs/creating-report-graphs/

 

[NJohnson]

So, to confirm what you are saying, there is not a way to natively get that type of report from 3CX and that I would have to leverage an external data/AI service, is that correct? Also, from what I'm reading, I will also need the AI edition of 3CX in order to connect to one of those external services, is that correct?

 

[Alejandro_3CX]

So, to confirm what you are saying, there is not a way to natively get that type of report from 3CX and that I would have to leverage an external data/AI service, is that correct? Also, from what I'm reading, I will also need the AI edition of 3CX in order to connect to one of those external services, is that correct?

If all calls go to an IVR, then you may get a call report filtered by any to the destination, for example option 1 is a ring group, then filter the report to that specific RG and you get the totals.

 

[KyriacosS_3CX]

Hello,

And if DIDs are routed to normal extensions, Extensions Statistics will give you a total count per extension for external calls.