JeraSoft Documentation Portal
Docs for all releases
This tool allows you to generate a report and trace all call routes from the Client to any Provider with orig-term cost and profit. Here you can create a report based on an existing template or generate a new one. Also, you can get the information sorted by clients and calls, etc.
Screenshot: Orig-Term Report form
In order to create a statistic report go to the Statistics and open the Orig-Term Report section. Then, you need to fill out the search form with next parameters:
On the Filters menu, select convenient parameters for the report. To cancel any filter, click the delete sign next to the filter.
Specify an interval for the report. Please note, that the "Period" field is mandatory. You can generate the report also for last 3,7 and 30 days.
Accessible when you enable the "Compare Period" option by clicking the plus sign next to the "Period". Specify the second interval for the report
When you select one of Time parameters for Group By, the end date of the Period 2 will be set automatically to make equal intervals of Period 1 and Period 2.
Select a grouping option, here you can choose and swap columns, change its order. There are following accessible options to group the data in reports:
Please note, the "Group By" field is mandatory, it couldn't be empty in order to generate the report.
This option is intended to simply grouping option, now the system will automatically group data in specified columns.
There are following accessible additional filters:
Please use the Scroll Bart to see all settings in the pull-down list.
|Origination Settings of Clients|
|Orig Client||Define an origination client for the report|
Enter an orig account for the report
|Orig Code||Specify an orig code for the report|
|Orig Code Name||Indicate an orig code name|
|Orig Serial||Define an origination serial|
|Orig Owner||Define an Origination Reseller for report|
|Settings of Calls|
|Calls Total||Enter the range of total calls|
|Profit||Enter the range of the revenue you would like to display|
|Calls Not Zero||Define the range of calls, that have duration equal to or more than 1 second|
|ASR Current||Specify the range of "ASR Cur" for calls you would like to display|
|ACD Current||Specify the range of "ACD Cur" for calls you would like to display|
|Minutes, Total||Enter the range of total calls duration in minutes|
|Termination Settings of Clients|
|Term Client||Define a termination client for the report|
|Term Account||Enter a term account for the report|
|Term Code||Specify a term code for the report|
|Term Code Name||Indicate a term code name|
|Term Owner||Define a termination Reseller for report|
|Orig Tags||Select an orig tag that will be used as filter criteria|
|Term Tags||Specify a term tag|
This form contains settings of the output data of the report.
Click plus sign near the "Columns" to select respective columns to output a report data. Also, you can cancel any chosen item.
|Accessible columns in the report|
ASR Std, ASR Cur, ACD Std, ACD Cur, Calls Total, Calls Success, Calls Error, Profit, Profit (%), Orig Billed Time, Orig Cost, Orig Avg Rate, Term Billed Time, Term Cost, Term Avg Cost, Term Avg Rate, Session Time, Calls Not Zero, Calls Busy, Calls No Channel.
|Time Total||Total time in minutes|
Average successful rate (successful calls percentage)
Average call duration
Quantity of calls in database
|Other output settings|
Select parameters to sort already grouped data in columns. Here you can sort data from highest to lowest values (or vice versa) and select different values.
Choose a format of the report from a drop-down list: Web/CSV/Excel XLS/Excel XLSx.
Also, select next to the "Type" field a look of table view:
Please note, that Grouped type of table view is available only for Excel XLSx and Web formats, it doesn't work with CSV.
|Limit||Determine the number of rows that will be visible in the report. It is useful for displaying some top positions by chosen parameter. It is available only for plain type of the report.|
Specify a currency for the report. And all values will be automatically converted in the report to the specified currency.
Select a code deck from a drop-down list. All codes in the following report will be presented according to the specified code deck.
After selecting all needed parameters, click “Query” button and the system will generate a report:
Screenshot: Orig-Term Report window
If the data is grouped in the report, it will be shown initially collapsed. To expand or collapse data in your report, click the plus or minus signs.
To expand all data in the report, please press Ctrl and .
Please note, the system shows rounded values in the reports. But while calculating the system takes an exact value. Hence, the procedure of the rounding is following:
In order to create a simple orig-term report you need to:
If you want to sort already grouped data in columns, select respective parameters in "Order By" . Also, you can sort from highest to lowest values (or vice versa). To do this, select a respective value with arrows: or and change the "Type" of output from Grouped to Plain.
Please note, the "Order By" option is active when the "Type" of the Output form is Plain. When it is Grouped, the data is only sorting by values specified in the "Group By" field.
Also, you can sort data in report manually using special arrows next to the name of respective columns.
Screenshot: Orig-Term Report
Also, you can create a template for reports and save specified parameters by clicking "Save Query" button. A pop-up window with settings will appear and you need to fill out the following form:
Screenshot: New Template form
|Here you can specify parameters for the template that will be used while running reports|
|Title||Specify a name of the template|
|Reseller||Indicate a Reseller for the report template|
It allows controlling visibility of respective reports templates. Whether you want to keep templates private or leave them visible for users under specified Reseller.
To enable this option, select one parameter from the drop-down list:
This tool allows to automatically generate report at appropriate time and send results to the list of e-mails
Please note, that this tool is not available for Web output type, only for CSV/Excel XLS/Excel XLSx.
|Recipients||Specify recipients, you can indicate your own e-mail or other users of the system, or even 3rd parties|
|Run Time||Mention an appropriate time to automatically generate a report, it could be several times, for example: "10:00, 12:00, 18:00"|
|Days of Week||Mention days of the week to automatically generate a report. For example, you can run a report only on Monday or each day of week|
Here you need to specify filters that will be used for generating correct report and choose the output type to view the report
You can export data to a CSV and XLSx file which contains only currently presented data, no automatic request to update data while exporting. Also, it is possible to create charts for easily illustrating a crucial information. And you can generate a report using the same criteria in the Orig-Term report and the CDRs list sections.
1. To download a report in .csv, click the "Export to CSV" button on the toolbar.
Please note, this button will be visible only when the "Type" of the output is "Plain". For the"Grouped" output type it is not available.
2. To download a .xlsx file, click the "Export to XLSx" button on the toolbar.
4. You can generate a detailed report using the same criteria in the CDRs list by clicking the CDRs list icon on the toolbar.
5. And it is possible to generate a report using the same criteria in the Summary report by clicking the Summary icon on the toolbar.
6. You can check an actual date interval of the report by clicking the Info icon and it could be different from the Interval specified above if there is no date for the period.
Screenshot: Orig-Term Report section
Screenshot: Orig-Term Report section/ chart
This tool allows building a report with side-by-side sub-reports. Use it to run a comparative analysis on the same page. It's helpful for reviewing multiple parameters, totals and compare results at different time intervals. The "Compare Period" option is designed to create a report that shows two sub-reports side-by-side.
To enable this option, click the plus sign next to the "Period" and specify both intervals (Period 1/Period 2) for the report.
Screenshot: Orig-Term Report query form
After, choose columns for main and comparative period in the report output form. When all required parameters are specified, click the "Query" button.
To remove this filter, please click the delete icon .
You can modify a comparative mode by changing periods and columns. For example, to compare how different the profit of the two periods is in percentage terms, choose the "Profit (%)" value from the Columns. Therefore, the final report splits the Profit (%) into separate columns.
Screenshot: Orig-Term Report example