Rick Guyton Posted August 3, 2017 Report Share Posted August 3, 2017 @_mc is the tasks API available to us on the SAAS (hosted reseller) cluster? Quote Link to comment Share on other sites More sharing options...
2600Hz Employees mc_ Posted August 3, 2017 2600Hz Employees Report Share Posted August 3, 2017 @Rick Guyton it appears so. I cURL'd /v2/tasks and got the listing of available tasks. Quote Link to comment Share on other sites More sharing options...
Rick Guyton Posted August 3, 2017 Report Share Posted August 3, 2017 Are we able to POST tasks? Any docs? Quote Link to comment Share on other sites More sharing options...
2600Hz Employees mc_ Posted August 3, 2017 2600Hz Employees Report Share Posted August 3, 2017 At the moment, just the ref docs: https://docs.2600hz.com/dev/applications/crossbar/doc/tasks/ Quote Link to comment Share on other sites More sharing options...
Rick Guyton Posted August 3, 2017 Report Share Posted August 3, 2017 Lol, ok thanks I'll rtfm. I forget we can actually do that now! Quote Link to comment Share on other sites More sharing options...
Tuly Posted October 2, 2017 Report Share Posted October 2, 2017 i am looking on a client when and how many times they dialed 911 in the last 6 months, can anyone help me? Quote Link to comment Share on other sites More sharing options...
Rick Guyton Posted October 2, 2017 Report Share Posted October 2, 2017 5 minutes ago, Tuly said: i am looking on a client when and how many times they dialed 911 in the last 6 months, can anyone help me? If it was me, I would go in the smart PBX, and download the CSV from call history. Pretty much every other built in way is painful Quote Link to comment Share on other sites More sharing options...
FASTDEVICE Posted October 19, 2017 Report Share Posted October 19, 2017 On 8/2/2017 at 2:00 PM, mc_ said: With the new Tasks API, store the output CSV file to S3/GoogleDrive/HTTP URL (in addition to or in lieu of the Kazoo DB) or email the CSV as a notification so you can provide reports to customers with white-labeled emails. Create tasks on the backend for the commonly requested reports. I think weekly/monthly usage reports make sense, Month-over-month and week-over-week as well, whatever else the business unit agrees are common requests. @mc_ This is a great idea, can you provide some examples of using the Task API to extract CDRs? I'm looking into an ETL process for data warehousing CDRs, so extraction examples would be much appreciated. Quote Link to comment Share on other sites More sharing options...
esoare Posted October 19, 2017 Report Share Posted October 19, 2017 I just did this for a customer. Painful. It's just a Pivot table based on Raw Data. It doesn't remove No Answer Calls, Rejected, or the Lose Race calls if you have ring groups. . I barely figured it out. Not sure if it's Macro-able or not. But it's doable. Quote Link to comment Share on other sites More sharing options...
2600Hz Employees mc_ Posted October 19, 2017 2600Hz Employees Report Share Posted October 19, 2017 @FASTDEVICE nothing at the moment. Those were just ideas I had that would fit nicely in the tasks framework. You would need to get in the ear of @Chris Kerber or @Darren Schreiber I think and see about getting something like this on the roadmap. Quote Link to comment Share on other sites More sharing options...
Tuly Posted October 31, 2017 Report Share Posted October 31, 2017 Any official word if there will be a searchable CDR app in the future? Quote Link to comment Share on other sites More sharing options...
2600Hz Employees David Singer Posted November 1, 2017 2600Hz Employees Report Share Posted November 1, 2017 @Tully, I have no idea on the roadmap for improvements on the CDR tool. I wrote some ideas/suggestions a while back in a JIRA feature request here: https://2600hz.atlassian.net/browse/UI-2005 Have you read that? Thoughts? Quote Link to comment Share on other sites More sharing options...
FASTDEVICE Posted November 2, 2017 Report Share Posted November 2, 2017 @Tuly My team is working on an ETL process to load a data warehouse containing raw CDR and transformed data. When complete you can use most BI/ Reporting tools to query and build reports. Quote Link to comment Share on other sites More sharing options...
Administrators Darren Schreiber Posted November 2, 2017 Administrators Report Share Posted November 2, 2017 On 8/2/2017 at 11:00 AM, mc_ said: I wonder if we can use the forum software to run a poll? @Darren Schreiber, would it be worth a poll to find the top 3 CDR reports folks want? I'd love such a poll. There's already a CDR Reporting tool in beta on sandbox. But we guessed at what reports people want. Concrete feedback would help indeed. Quote Link to comment Share on other sites More sharing options...
esoare Posted November 2, 2017 Report Share Posted November 2, 2017 11 hours ago, Darren Schreiber said: I'd love such a poll. There's already a CDR Reporting tool in beta on sandbox. But we guessed at what reports people want. Concrete feedback would help indeed. Took a look at the sandbox cdr. Looks nice! Below is what a customer wanted. On my wish list for the call reporting: Ability to look at call history for: daily, weekly, monthly, quarterly, annually Ability to schedule reports – for example, I would really love to have a monthly call report for a particular extension showing the fields that are currently on the online dashboard. For example, an email that comes out on the first Monday of every month showing last month’s calls for extension 1302 --- Total, Unique, Answered, Missed, Total Time, Longest, Average This, combined with the click-to-dial you have setup for us, would be amazing!!" Along with that. I would say. 1) Change your current graph, to allow for "business hours" so that would be zoomed in by the hour, while the out of business hours, would be zoomed out (Maybe before and after...i like 00:00 - 07:00 <- make this changeable by customer, and 17:00-23:59 <- make this changeable by customer) 2) When a customer uses Click to call. It shows in CDR that it's an incoming call, instead of outgoing. Perhaps modify when the name shows "Click to Call" to make that "outgoing" in the metrics. 3) What about incoming calls based on numbers? a) if a customer has multiple numbers, show all the numbers and how many calls came into those numbers. daily,weekly,monthly,quarterly,annually b) along with "every DID" allow for individual DID statistics. 4) Total, Unique, Answered, Missed, Total Time, Longest, Average 5) Cost might be important, but not necessarily. Maybe make that optional? (for instance, my customers are on unlimited) 6) PDF Download 7) Email a PDF 8) Schedule a report to email a PDF (or HTML5?) 9) To be clear, these reports don't need the CDR records in them. But a link to get to them/show them, "might" be nice. From the customer's comments. 1) Ability to look at call history for: daily, weekly, monthly, quarterly, annually 2) monthly call report for a particular extension showing the fields that are currently on the online dashboard. For example, an email that comes out on the first Monday of every month showing last month’s calls for extension 1302 --- Total, Unique, Answered, Missed, Total Time, Longest, Average I'll add more if I can think of some. Quote Link to comment Share on other sites More sharing options...
Administrators Darren Schreiber Posted November 2, 2017 Administrators Report Share Posted November 2, 2017 "Total, Unique, Answered, Missed, Total Time, Longest, Average" screams Call Center reports, not CDRs... Quote Link to comment Share on other sites More sharing options...
Tuly Posted November 2, 2017 Report Share Posted November 2, 2017 Total, Answered, Missed, Total Time, is CDR Longest, Average is call center, I had a simple request yesterday, (It took me about 2 hours to prepare the excel sheet) "Hi I'm logged in to your website, where can I see all of my incoming calls of the last 2 months? I would also like to know who answered them" Quote Link to comment Share on other sites More sharing options...
2600Hz Employees David Singer Posted November 2, 2017 2600Hz Employees Report Share Posted November 2, 2017 On 6/16/2016 at 2:42 PM, FASTDEVICE said: We weren't considering hold-times until 2600hz releases queues, but I don't think hold events are captured in a webhook or CDR. I would need a way to capture the event. @Fastdevice we don't currently do not have webhooks for cubicle events but we do have webshocket events that you can subscribe to. Here is the documentation for that: https://docs.2600hz.com/qubicle/doc/websockets/queue/ https://docs.2600hz.com/qubicle/doc/websockets/recipient/ https://docs.2600hz.com/qubicle/doc/websockets/session/ Quote Link to comment Share on other sites More sharing options...
FASTDEVICE Posted November 2, 2017 Report Share Posted November 2, 2017 There is a clear distinction between CDRs and reporting. Here is what our reporting looks like: Quote Link to comment Share on other sites More sharing options...
2600Hz Employees Mark Magnusson Posted November 2, 2017 2600Hz Employees Report Share Posted November 2, 2017 I will take this opportunity to chime in here to say that as of 4.2 Qubicle has reporting capabilities that include: Per Queue Average wait time Call Count Timeout Count Abandon Count Per Agent Call Count Missed Call Count Rejected Call Count Average Call Duration Average Ring Duration These will all be available via a new qubicle_reports API (as well as in a nice new graphical dashboard). This will likely make it much easier to get the data you are interested in for call center calls without having to process the WebSocket events that Dave listed above. Quote Link to comment Share on other sites More sharing options...
Rick Guyton Posted November 2, 2017 Report Share Posted November 2, 2017 (edited) 48 minutes ago, Mark Magnusson said: I will take this opportunity to chime in here to say that as of 4.2 Qubicle has reporting capabilities that include: Per Queue Average wait time Call Count Timeout Count Abandon Count Per Agent Call Count Missed Call Count Rejected Call Count Average Call Duration Average Ring Duration These will all be available via a new qubicle_reports API (as well as in a nice new graphical dashboard). This will likely make it much easier to get the data you are interested in for call center calls without having to process the WebSocket events that Dave listed above. Awesome news Mark! Very excited. Any idea when that'll drop? Also, will we be able to see time frames better? In the current app, all the statistics are from when queue last started. And that could be this morning, or 3 weeks ago. Would be awesome to see stats for a particular day. Edited November 2, 2017 by Rick Guyton blarg (see edit history) Quote Link to comment Share on other sites More sharing options...
Tuly Posted November 2, 2017 Report Share Posted November 2, 2017 i did see the CDR in the sandbox, but it looks the same what we have now, only added to see per user CDR, (the talk about Qubicle reports are different then CDR, this post is about simple CDR) Quote Link to comment Share on other sites More sharing options...
2600Hz Employees Mark Magnusson Posted November 2, 2017 2600Hz Employees Report Share Posted November 2, 2017 22 minutes ago, Rick Guyton said: Awesome news Mark! Very excited. Any idea when that'll drop? Also, will we be able to see time frames better? In the current app, all the statistics are from when queue last started. And that could be this morning, or 3 weeks ago. Would be awesome to see stats for a particular day. We are already testing this on our sandbox system, I am unsure of the 4.2 rollout time frame unfortunately. And yes, the data resolution will be much improved, allowing you to drill down per day, week, and month. Quote Link to comment Share on other sites More sharing options...
Rick Guyton Posted November 2, 2017 Report Share Posted November 2, 2017 (edited) 3 minutes ago, Mark Magnusson said: We are already testing this on our sandbox system, I am unsure of the 4.2 rollout time frame unfortunately. And yes, the data resolution will be much improved, allowing you to drill down per day, week, and month. I'm excited. My existing clients have been begging for this. And we've lost a couple potential accounts to ring central because we couldn't do this. Edited November 2, 2017 by Rick Guyton can't type (see edit history) Quote Link to comment Share on other sites More sharing options...
esoare Posted November 2, 2017 Report Share Posted November 2, 2017 5 hours ago, Darren Schreiber said: "Total, Unique, Answered, Missed, Total Time, Longest, Average" screams Call Center reports, not CDRs... @Darren Schreiber While it may scream that to some. It doesn't to my customer. He is using those metrics for outgoing calls from his salespeople. p.s. It's the same interface @FASTDEVICE is using. I really think the CDR reporting is for Summary's and Totals, that I listed in my numbered post above. I even have one client, who gives his user's access, so they can see how many outgoing calls they made every day!! I do like the CDR Reporting that is in the sandbox, but as you requested. Some ideas/guidance/suggestions are posted. Glad to see progress on this! and some other sandbox apps that I won't mention. lol Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.