Versions Compared

Old Version 1

changes.mady.by.user Andrii Zinchenko

Saved on

compared with

New Version Current

changes.mady.by.user Anastasiia Kovalinas

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

To create a new summary report, you need to fill in the following parameters in the form and click the Query button:

Clients SettingsOrig Client Define an origination client for the reportOrig Account

Enter an origination account for the report

Orig CodeSpecify an origination code for the reportOrig Code Name Indicate an origination code nameOrig SerialDefine an origination serialOrig OwnerDefine an origination Reseller for the reportOrig Client's TagsDetermine tags that belong to an origination client Orig Account's TagsSpecify tags determined for an origination accountTerm ClientDefine a termination client for the reportTerm AccountEnter a termination account for the reportTerm Code Name Indicate a termination code nameTerm OwnerDefine a Reseller for the reportTerm Client's TagsDetermine tags that belong to a termination client Term Account's TagsSpecify tags determined for a termination accountTerm CodeSpecify a termination code for the reportEvents SettingsTotalEnter the range of total eventsProfitEnter the range of the revenue you would like to displayEvents Not Zero
Information BlockField Description
Filters

On the Filters menu, select the required parameters for the report. To cancel any filter, click the delete Image Modified icon next to the filter.
You can start a quick search by typing filters' names in the field at the top of a drop-down menu with filters.

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 Image Modified icon next to the Period. Specify the second interval for the report.

Panel
borderColor#ccffcc
bgColor#ccffcc
borderWidth2px
borderStylesolid
Image Modified Tip

When you select one of the 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.


Group by

There are the following accessible options to group the data in reports:

  • Time: Year, Month, Date, Hour.
  • Clients: Orig Client, Orig Account, Orig Code, Orig Code Name, Orig Code Country, Orig Rate, Term Client, Term Account, Term Code, Term Code Name, Term Code Country, Term Rate
  • Extras: Service, Orig Serial, Orig Client Type, Orig Owner, Orig Time profile, Term Client Type, Term Owner, Term Time profile
Panel
borderColor#ffffb3
bgColor#ffffb3
borderWidth2px

(warning)   Attention

Please note that the Group by field is mandatory, it couldn't be empty in order to generate the report.


Additional Filters

There are the following accessible additional filters:

Clients
: Orig Client/ Orig Account/ Orig Code/ Orig Code Name/ Orig Serial/ Orig Owner/ Orig Client's Tags/ Orig Account's Tags/ Term Client/ Term Account/ Term Code/ Term Code Name/ Term Owner/ Term Client's Tags/ Term Account's Tags
  • Events: Total/ Profit/ Volume, Total/ Events Not Zero/ ASR Cur/ ACD Cur
  • Extras: Service/ Orig Time profile/ Term Time profile

    • Orig OwnerDefine an origination Reseller for the report. Accepts multiple values.
    Orig Client Define an origination client for the report
    Orig Client TypeDetermine the type of origination client: Client, Reseller, Calling Card, Call Shop
    Orig Client TagsDetermine tags that belong to an origination client
    Orig SerialDefine an origination serial
    Orig Account

    Enter an origination account for the report

    Orig Account TagsSpecify tags determined for an origination account
    Term OwnerDefine a Reseller for the report. Accepts multiple values.
    Term ClientDefine a termination client for the report
    Term Client TypeDetermine the type of termination client: Client, Reseller, Calling Card, Call Shop
    Term Client TagsDetermine tags that belong to a termination client
    Term AccountEnter a termination account for the report
    Term Account TagsSpecify tags determined for a termination account
    Events
    ServiceDetermine the name of service for the report
    Match Orig Client
    		Search for matched/mismatched origination clients
    Match Orig Rate
    		Search for matched/mismatched origination rates
    Orig Dst CodeSpecify an origination code for the report
    Orig Dst Code Name Indicate an origination code name
    Orig Dst Code Country
    		Indicate an origination country name
    Orig Src CodeSpecify an origination source code for the report
    Orig Src Code NameIndicate an origination source code name
    Orig Src Code Country
    		Indicate an origination source country name
    Orig Rate (avg)
    		Enter the range of average call rate for origination
    Orig Time ProfileSelect an orig time profile that will be used as filter criteria
    Match Term Client
    		Search for matched/mismatched termination clients
    Match Term Rate
    		Search for matched/mismatched termination rates
    Term Dst CodeSpecify a termination code for the report
    Term Dst Code Name Indicate a termination code name
    Term Dst Code Country Indicate a termination country name
    Term Src CodeSpecify a termination source code for the report
    Term Src Code Name
    		Indicate a termination source code name
    Term Src Code Country
    		Indicate a termination source country name
    Term Rate (avg)Enter the range of average call rate for termination
    Term Time ProfileSpecify a term time profile that will be used as filter criteria
    Statistics
    ASR StdSpecify the range of ASR Std for events you would like to display
    ASR CurrentSpecify the range of ASR Cur for events you would like to display
    ACD StdSpecify the range of ACD Std for events you would like to display
    ACD CurrentSpecify the range of ACD Cur for events you would like to display
    Totals
    Volume TotalEnter the range of total volume of services
    Orig Volume Billed
    		Enter the range of orig volume of billed services
    Term Volume Billed
    		Enter the range of term volume of billed services
    Profit (abs)
    		Enter the absolute profit range
    Profit (rel)
    		Enter the relative profit range
    MarginEnter the margin range
    Total RecordsEnter the range of total events
    Not Zero Records

    		Define the range of events, that have a duration greater
    than 0
    than 0
    Success Records
    		Define the range of successful events
    Busy RecordsDefine the range of busy events
    No Channel RecordsDefine the range of no channel events
    Error RecordsDefine the range of error events
    ASR CurrentSpecify the range of ASR Cur for events you would like to displayACD CurrentSpecify the range of ACD Cur for events you would like to displayVolume, TotalEnter the range of total volume of servicesExtra SettingsOrig Time ProfileSelect an orig time profile that will be used as filter criteria Term Time ProfileSpecify a term time profile that will be used as filter criteria ServiceDetermine the name of service for the report
    Output



    This form contains settings of the output data of the report.

    Click the plus Image Modified icon near the Columns to select respective columns to output a report data. Also, you can 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 (abs), Profit (rel), Orig Billed Volume, Orig Cost, Orig

    Avg

    Rate (avg), Term Billed Volume, Term Cost, Term

    Avg

    Rate (avg), Total Events, Not Zero, Busy, No Channel, Success, Error, Margin.

    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:

    • Billed Volume - Billed event volume
    • Cost - Price of the event
    • Avg. Rate - Average event rate
    Term

    Termination information:

    • Billed Volume - Billed event volume
    • Cost - Event cost
    • Avg. Rate - Average event rate
    Profit
    • Profit (abs) - Revenue in respective currency, for example, USD (in fact, any system currency can be specified here)
    • Profit (rel
     
    • )- Revenue in percent value
    Total Volume
    Total

    The total volume of services

    MarginThe absolute value of profit divided by volume billed (orig and term).
    ASR

    Average successful rate (successful events percentage):

    • Std - Number of events with success status divided by the total number of events minus all events with no channel available status
    • Cur - Number of events with duration > 0 divided by the total number of events
    ACD

    Average call duration:

    • Std - Sum of all event duration divided by the number of events with success status
    • Cur - Sum of all event duration divided by the number of events with a duration > 0
    Events

    Quantity of events in a database

    • Total Events - Total events quantity
    • Not Zero - Quantity of events that have a duration equal to or more than 1 second
    • Success - Quantity of events that have a duration equal to or more than 1 second and a successful end code, events with Q.931, disconnect cause 16 or 31
    • Error - Quantity of declined events

    • Busy - Busy events quantity

    • No Channel - No circuit/channel available. Events with Q.931, disconnect cause 34
    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

    Also, select a look of a table view next to the Type field:

    • Grouped - a table view with grouped data and possibility to collapse it

    • Plain - a simple table view

    • Plain with total - a simple table view with an additional Total row at the beginning of the report

    Panel
    borderColor#ffffb3
    bgColor#ffffb3
    borderWidth2px

    (warning)   Attention

    Please note, that the 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 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.

    Panel
    borderColor#ffffb3
    bgColor#ffffb3
    borderWidth2px

    (warning) Attention

    This feature is available only for CSV/Excel XLS/Excel XLSx formats of the report; it doesn't work with Web.


    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:

    ...

    Panel
    borderColor#ccffcc
    bgColor#ccffcc
    borderWidth2px
    borderStylesolid
    Tip

    To find more details about templates, please refer to the Report Templates article in our User Guide.  

    ...

    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 is 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. 

    1. To expand/collapse all the data for the Grouped output, click on the Image Added icon above the report.

    2. To  1.  To download a report in .csv, click the Export to CSV  button on the toolbar.

    Panel
    borderColor#ffffb3
    bgColor#ffffb3
    borderWidth2px

    (warning)  Attention

    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.

     23. To download a .xlsx file, click the Export to XLSx  button on the toolbar. 

     34. To create a visual chart, click the Show Chart  button on the toolbar. There is more information available on this topic in the article "How to create a statistic chart?" in our Knowledge Base. 

     45. You can generate a detailed report using the same criteria in the xDRs list section by clicking the xDRs list  icon on the toolbar. 

     56. And it is possible to generate a report using the same criteria in the Summary report section by clicking the Summary  icon on the toolbar. 

     67. 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 data for the period.

    ...