Versions Compared

Old Version 5

changes.mady.by.user Anastasiia Kovalinas

Saved on

compared with

New Version 6

changes.mady.by.user Anastasiia Kovalinas

Saved on

Key

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

...

Information BlockField Description
Filters

On the Filters menu, select the required parameters for the report. To cancel any filter, click on the delete 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.

ServiceSelect a service for rates analysis. Default is calls
Dst CodeSpecify a code of the needed destination
Dst Code NameDefine a code name of the desired destination
ClientsIndicate termination clients for analysis
Accounts

Indicate termination accounts for analysis

Select clients matching specified tags for analysis

Rate Table

Define rate tables for analysis

Select a grouping option from the following list:

  • Dst Code - aggregation by default output.
    • Dst Code Name - grouping by rate rows with the same names and rates for all codes in each rate table.

    This option is intended to simplify grouping, the system will automatically group data in specified columns.

    Additional Filters

    Master Source

    Master - TableSpecify a rate table that all other rates will be compared to
    Master - ClientSpecify an origination client that all other rates will be compared to
    Master - AccountSpecify an origination account that all other rates will be compared to
    Rate Filters
    Dst Code CountryEnter the name of the respective country
    Rate TagsIndicate a tag, which relates to specific rates
    Extras
    Actual on

    Define the date, when the rates should be effective on

    Info
    titleInfo

    Applies both to Effective Date and Time Profile.


    Volume IntervalSpecify the number of days of statistics that would be taken for analysis
    Output



    This information block contains settings of the report output data.

    Click the plus Image Added icon next to Columns and select the required columns to add them to the Output information block. Also, you can cancel any chosen item.

    Accessible columns in the report

    The list of additional columns include:

    • Sources Volume - calculated based on Summary Report. By default - last 7 days. You can alter this value by specifying a Volume Interval filter. 
    • Sources Quality - calculated based on Summary Report. Quality parameters for traffic - ASR and ACD -  are available per row.
    • Master Volume - calculated based on Orig-Term report. By default - last 7 days. You can alter this value by specifying a Volume Interval filter. 
    • Master Profit - calculated based on Orig-Term report. The relative and absolute Profit is displayed per destination.
    • Master Routes - shows how many accepted routs there are according to the Routing Plan on the selected master entity. When clicked, prompts you to the Routing Analysis for the respective case.
    Note
    titleNote

    A master filter must be selected for any master-related output columns.


    Order bySelect 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 XLSExcel XLSx

    If CSV , Excel XLS or Excel XLSx type has been selected, an additional Send to field will be displayed. In this field, you can specify emails of the clients, to which the current report in the selected format will be sent.

    Currency

    Specify a the currency of the report. All values will be automatically converted to the specified currency in the report.

    Dst 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

    .

    Simulate long codes checkbox

     Check if a rate table does not have codes, which are presented in other tables for simulating them using shorter codes.

    Panel
    borderColor#ffffb3
    bgColor#ffffb3
    borderWidth2px

    (warning)   AttentionIf you check the Simulate long codes checkbox, the system will try to simulate the longest available code with the shorter one. For example, we analyze two rate tables, one of which has code 380, and the other has 380 and 38044 codes.
    When the mentioned checkbox is active, the first rate table will have unavailable 38044 code simulated with the price of available 380. Rates like these have the Simulated label when you hover the mouse pointer over them and are colored in light-red, light-green and grey respectively

    This field is not mandatory by default. However, it is required if you have any destination name-related filters and/or Group by Code Name.


    Group by

    Select a grouping option from the following list:

    • Dst Code - aggregation by default output
    • Dst Code Name - grouping by rate rows with the same names and rates for all codes in each rate table

    This option is intended to simplify grouping, the system will automatically group data in specified columns. If certain termination entities will have different prices within the same Code Name, the rows will be displayed separately.

    After clicking the Query button button, the system will form a list of rates with prices for each destination.  The highest rate available for the destination is colored in red, the lowest – in green, and middle rates are colored in blackThe appeal of rates is visualized as a heat map for convenience. The darker the red - the least profitable, the brighter the green - the more, respectively.

    Screenshot: Rates Analysis section output

    Image Added

    By clicking the Info  icon above the report on the right, the user's name and time/date, when a report was generated, will be displayed in a pop-up window.

    ...