Versions Compared

Old Version 5

changes.mady.by.user Anastasiia Kovalinas

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.

...

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 Code

Specify a code of the needed destination

Info
titleInfo

If a vendor does not have a Rate for the specified longer Dst Code, it would be simulated from an existing shorter one.


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 analysisSelect 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.
  • 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. 
  • Master Profit - calculated based on Orig-Term report. The relative and absolute Profit is displayed per destination.
  • Master Routes - shows how many accepted routes 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.


Info
titleInfo

By default, the system takes statistics for the last 7 days. You can alter this value by specifying a Volume Interval filter. 


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 hovering over the Info  icon above the report on the right, the user's name and , time/date,  when when a report was generated, and Durationwill be displayed in a pop-up window.

Screenshot: Info icon

Image RemovedImage Added

Creating a New

...

Report Query

Also, you can create a template and save specified parameters by clicking the Save Query button.  A pop-up window with settings will appear, where you need to fill out the following form:

Screenshot: New Template form

...

It allows controlling the visibility of respective reports templates. You can set up whether you want to keep templates private or leave them visible for users under a specified Reseller. 

To enable this option, select one parameter from the drop-down list:

  • Public - available for users according to the settings of the Reseller field.
  • Private - accessible strictly for the creator.

...

This tool allows to generate the report automatically at the appropriate time and send the results to the list of emails.

Panel
borderColor#ffffb3
bgColor#ffffb3
borderWidth2px

(warning)   Attention

Please note that this tool is not available for Web output type, only for CSV/Excel XLS/Excel XLSx

...

Report Query form

Image Added

After a template has been created, a new Load Query button will be added to the section. By clicking it, you can select report settings to be filled in from a list of templates for rates analysis.

...

Title

Description

Generated byIndicates the Role of the user who generated a report and specifies a generation time
DurationTime spent to generate a report

...