Docs for all releases
Page History
...
This section is designed to provide a user with a possibility to generate a report and trace all call routes from a 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 You can also get the information sorted by clients, events, profit, etc.
...
To create a new summary report, you need to fill in the following parameters in the form and click the Query button:
Information Block | Field Description | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
Filters | On the Filters menu, select the required parameters for the report. To cancel any filter, click the delete icon next to the filter. | |||||||||||
Period (1) | Specify the time interval for the report and a timezone. Please note that the Period field is mandatory. | |||||||||||
Period 2 | Accessible when you enable the Compare Period option by clicking on the plus icon next to the Period. Specify the second interval for the report.
| |||||||||||
Group by | There are the following accessible options to group the data in reports:
|
|
| ||
Additional Filters | ||
---|---|---|
There are the following accessible additional filters:
| ||
Clients Settings | ||
Orig Client | Define an origination client for the report | |
Orig Account | Enter an origination account for the report | |
Orig Code | Specify an origination code for the report | |
Orig Code Name | Indicate an origination code name | |
Orig Serial | Define an origination serial | |
Orig Owner | Define an origination Reseller for the report | |
Orig Client's Tags | Determine tags that belong to an origination client | |
Orig Account's Tags | Specify tags determined for an origination account | |
Term Client | Define a termination client for the report | |
Term Account | Enter a termination account for the report | |
Term Code Name | Indicate a termination code name | |
Term Owner | Define a Reseller for the report | |
Term Client's Tags | Determine tags that belong to a termination client | |
Term Account's Tags | Specify tags determined for a termination account | |
Term Code | Specify a termination code for the report | |
Events Settings | ||
Total | Enter the range of total events | |
Profit | Enter the range of the revenue you would like to display | |
Events Not Zero | Define the range of events, that have a duration greater than 0 | |
ASR Current | Specify the range of ASR Cur for events you would like to display | |
ACD Current | Specify the range of ACD Cur for events you would like to display | |
Volume, Total | Enter the range of total volume of services | |
Extra Settings | ||
Orig Time Profile | Select an orig time profile that will be used as filter criteria | |
Term Time Profile | Specify a term time profile that will be used as filter criteria | |
Service Name | Determine the name of service for the report | |
Output | This form contains settings of the output data of the report. Click the plus icon near the Columns to select respective columns to output a report data. |
You can also cancel any chosen item. | |
Accessible columns in the report | |
---|---|
Columns for the main period are: ASR Std, ASR Cur, ACD Std, ACD Cur, Total Volume, Error, Profit, Profit |
rel, Orig Billed Volume, Orig Cost, Orig Avg Rate, Term Billed Volume, Term Cost, Term Avg Rate, Total Events, Not Zero, Busy, No Channel, Success. Columns for the comparative period are the same as for the main period. Moreover, all parameters could be selected expressed in percentage. | |
Orig | Origination information:
|
Term | Termination information:
|
Profit |
|
| |
Total Volume | Total volume of services |
ASR | Average successful rate (successful events percentage):
|
ACD | Average call duration:
|
Events | Quantity of events in a database
|
Other output settings | |
---|---|
Order by | 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. |
Type | Choose a format of the report from a drop-down list: Web/CSV/Excel XLS/Excel XLSx |
Select a look of a table view next to the Type field:
|
|
| |||||||||
Limit | Determine the number of rows that will be visible in the report. It is useful for displaying some top positions by the chosen parameter. It is available only for plain and plain with total types of the report. | ||||||||
Send to | You can send generated reports via email. Also, it is possible to specify several emails.
|
| |
Currency | Specify a currency for the report. All values will be automatically converted to the specified currency in the report. |
Code Deck | Select a code deck from a drop-down list. All codes in the following report will be presented according to the specified code deck. |
A generated orig-term report is demonstrated on a screenshot below:
Screenshot: Orig-Term Report section
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 icons. To expand all data in the report, please click Ctrl and .
Panel | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
Warning Please note , that the system shows rounded values in the reports. However, while calculating, the system takes an exact value. Hence, the procedure of the rounding is as follows:
|
...
Panel | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
Tip
|
AlsoIn addition, you can sort data in a report manually using special arrows next to the name of the respective columns.
...
Creating Reports Templates
Also, you You can also create a template for reports and save specified parameters by clicking the Save Query button. A pop-up window with settings will appear and you will need to fill out the following form:
Screenshot: New Template creation form
...
You can export data to a CSV or XLSx file, which contains only currently displayed data, no automatic request to update data while exporting. Also, it It is also possible to create charts for illustrating crucial information easily. And you can generate a report using the same criteria in the Summary report and the xDRs list sections.
...
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
Please note , that this button will be visible only when the Type of the output is Plain. For the Grouped output type it is not available. |
...
Afterward, choose columns for the main and comparative period in the report output form. When all the required parameters are specified, click the Query button.
...
Screenshot: Orig-Term Report example
Sharing a Report
Each time you get a report output, the system generates a unique link in the format of "/view?id=<uniq-string>". It allows sharing data between the users, even if they belong to different resellers (the feature works similarly to Share by Link in Google Drive).
The link refers to the report data valid for a specific moment.
Example: When you send a link to a report, you ensure the recipient would see the same data as you do. If you change data in the system (for example, perform rerating), the previously copied link to the report will display data valid for the moment of generation (even though the actual data is now different).
You can also view the additional information about the generated report by hovering over the Info icon, which is located under the Output section:
Title | Description |
---|---|
Data Period | States the period set for a report |
Generated by | Indicates the Role of the user who generated a report and specifies a generation time |
Screenshot: Orig-Term Report Info icon
Knowledge Base Articles
Content by Label showLabels false spaces +KB showSpace false sort modified excerpt true reverse true excerptType simple cql label = "stats_origterm" and space = "KB" labels +stats_origterm