Rates Analysis Form

Rates Analysis is an advanced feature of the JeraSoft Billing Rates Management Module. It allows you to analyze and compare rates within the JeraSoft Billing web interface without the usage of any third-party software. 

Screenshot: Rates Analysis section

Creating a New Analysis Report 

To analyze and compare different rates, you need to fill in the form with the next parameters:

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

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

Rate Table

Define rate tables for analysis

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

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

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


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 XLSx

If CSV 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 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

(warning)   Attention

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, the system will form a list of rates with prices for each destination. The 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


By hovering over the Info  icon above the report on the right, the user's nametime/date, when a report was generated, and Duration will be displayed in a window.

Screenshot: Info icon

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 Report Query form

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.

Export generated report

You can export report data either in .xlsx file or .csv that would contain currently presented data. Click the Export to XLSx or Export to CSV button above the report output to download a file of the respective format.

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

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