Refinement of the EWT service
Improvement of EWT:
Fix the error: when calculating EWT, if all offline - it shows not 99999, but the substituted number in the EWT calculation. Refine
Correct the EWT calculation
The current formula is as follows:
ewt = (max_value_call (from history) + osr.count_ewt_coef (from the cabinet)) - (average conversation per department + 10)
From what is currently working, max_value_call (from history) - is not calculated
average conversation per department - is not calculated
Works only = (__ + osr.count_ewt_coef (from the cabinet)) - (__ - 10)
What are the proposals for calculation:
3.1 Binotel has a web socket, from which data can be pulled without a timeout.
(Web Sockets) - this is an advanced technology that allows creating an interactive connection between the client (browser) and the server to exchange messages in real-time. Web sockets, unlike HTTP, allow working with a bidirectional data flow.
With WebSocket Binotel, you can simply listen to the server, which will send you messages as they become available.
All requests must be sent in JSON format, All server responses also come in JSON format
Connection and authorization
To connect to WebSocket Binotel, you need to use the address -
To use WebSocket, you need to obtain authorization parameters from Binotel technical support. To obtain authorization parameters key and secret, contact the technical support department by email, or by phone specifying the purpose for key and secret WebSocket!
Attention!!! Data for API REST key and secret are different from WebSocket key and secret!!!
Authentication is done by sending the following parameters:
Example:
{"task":"authLikeService","key":"bd125183c-12e3t39","secret":"3b213761b-9b12a1-dffag5-73fqqq-9d3we79a"}
Please note!! The data shown in the example is not relevant to you.
3.2 make the formula as follows:
ewt = ((average call duration with binotel + osr.count_ewt_coef, from the cabinet) - (*maximum conversation per department currently, those online, with binotel) + average waiting time for response, with binotel + (**number of calls in queue * 400 (average conversation) * average waiting time for response, with binotel)
*maximum conversation per department currently, those online, with binotel - there is a moment here.
Calls we can transfer, and we need to see how we can take the longest conversation from the cabinet now without considering transfers. They are underlined.
What is transfer - the manager communicated with the Client, understands that he cannot solve the issue, and transferred back to the customer. The manager is now free and can take a break, or take another call, or do something else, while the call will continue until the customer's manager resolves the client's issue.
Such conversations for each department should not be taken, as they do not provide any value to us.
Perhaps by receiving data on such calls, we can filter them out if the client's number repeats twice.
Next, we take the maximum conversation for each department now and substitute it into the formula.
3.3 (**number of calls in queue * 400 (average conversation) * average waiting time for response, with binotel) - if it is possible to extract the number of calls for each OSR - each line, it will be great, this will help when there is a long queue on the line, so that they no longer send us calls.
3.4 Data for calculation suggest taking for the last hour, before the calculation.
3.5 If the value of ewt is less than 0, for example, -200, suggest converting it to a positive value, for example, 200.
3.6 There is a question about the calculation in the first hour when there is no data for the previous hour, here you can take from the previous day, for example, without erasing the history, or instead of a negative value, make it positive, or some other method, so far no ideas.
3.7 I suggest not to touch the current calculation, add a button in the cabinet temporarily to switch from the old calculation to the new one. This is in case of any breakdown.
Employees in the cabinet cannot be disconnected - Employees marked with a checkmark in the cabinet are still taken into account. Fix the error
There are currently changes regarding restarting the bot, if it stops, it is not clear how to do it, new instructions are needed.
Current freelance projects in the category Python
Approximately 5 microservices on FastAPI + edits and refactoring
350 USD
There is a project consisting of approximately ~11 microservices on FastAPI with integrations, which is more than half ready. The task is to complete the remaining ~5 microservices (more specifically - subscription/billing and integration with Revenuecat, abuse protection for… Python, Web Programming ∙ 3 hours 40 minutes back ∙ 21 proposals |
Power BI
16 USD
The dashboard runs on a Google server, we need to transfer all logic + code Required skills: deployment of ETL processes on a Linux server + working with BigQuery and Postgre There is working code that runs on Google, where the database itself is, we need to transfer it to… Python, Databases & SQL ∙ 1 day 9 hours back ∙ 15 proposals |
Telegram bot for hiring/searching employees. For job searching.
24 USD
1. General Concept Creation of a Telegram bot for automating recruitment and mutual job searching. The system operates on the principle of active response and mutual confirmation of interest (Double Opt-In). The system includes two roles: Employer (Company Owner) and Worker (Job… Python, Bot Development ∙ 2 days 17 hours back ∙ 92 proposals |
Technical support for web platform (Python/Django)There is a working web project that needs to be maintained and gradually organized, without rewriting from scratch. Project stack: Backend: Python, Django, Django Rest Framework Frontend: Next.js Database: PostgreSQL Infrastructure: AWS (EC2), Nginx There are integrations… Python, Web Programming ∙ 2 days 19 hours back ∙ 73 proposals |
Application developmentI wish to create a mobile application for communication, the app should have audio and video calls, group chat creation, the ability to sync with phone contacts, account settings: email binding, 2FA, phone number, the ability to customize app notifications, change the app… Java, Python ∙ 4 days 18 hours back ∙ 39 proposals |