Browsing calls, reports, statistics, payments This page last changed on Feb 24, 2008 by admin

Calls connected through VoipSwitch or failed are available to browse in VSC and VSM application. Any call can be traced using date, client, calling number and other details. It is possible to see summary reports with charts about gateways usage, popular directions and many others. Statistics can help to choose best destinations and modify dialing plan according to such knowledge. Browsing payments made by client help solve misunderstandings.

This section describes every such feature and is divided into subsections listed below. • Calls • ° Time shift ° Export ° Calls clients ° Resellers calls • Failed calls • Reports • ° Export • Statistics • Payments

Calls

History of calls connected successfully through VoipSwitch is available in this part. It is possible to filter calls by:

• Date and time - it is possible to see calls made only in given time. There are helper periods available as Today, Last week, which allow to define exact date interval.

• Called number - destination number dialed by a client.

• Caller ip - ip number from which call was received, starting characters can be used for filtering. • Caller id - caller id from which call was made, starting characters can be used for filtering. • Duration - duration of a call, it can be defined also operator of comparison like <, > or = defined

value.

• Cost - similar to duration but revenue calculated for a client is used. • Tariff - tariff used to calculate revenue for clients.

• PDD - time of connecting to given number, the less time the better. • Route - destination used to terminate calls.

Working with filters, saving them, sorting columns, context menu is described in section Common UI elements

Fig. 1 Main calls window with simple filter

It is possible to use a few criteria to see only specific calls. After clicking Apply button the list of calls will be refreshed with filtering conditions. Below grid with calls summaries are calculated for the filtered set of calls. Informations available in summary section are:

• Total revenue - summary of revenue calculated for clients. • Avarage revenue - average revenue for all filtered calls. • Total duration - total duration for given set of records. • Average duration - average duration for calls.

• Total cost - summary of cost calculated by tariff assigned to destinations, if tariff is not set at cost 0.

• Average cost

• Total profit - summary of profit which is total revenue - total cost value. • Average profit - average profit for every call.

Time shift

This new option allows to show result using time shift. This value is set with hours and allows to modify call_start and call_end columns by adding hour value set there. It is useful when you want to compare calls being made to VoipSwitch with the same calls received from carrier and they are not in the same time zone.

Fig. 2 Using time shift option Export

Calls displayed in the list can be exported to CSV file. It is coma delimited and can be easily opened in Excel application or in Notepad. You may choose columns to export if it suits your needs. After choosing export file the name dialog (as shown on Fig.3) is shown with default export columns selected. Choose

which column to export and click OK button.

Fig. 3 Customizing calls export Calls clients

Calls node can be expanded to show calls made by specific type of clients. Only by using specific type of client it is possible to filter calls for a specific client.

Client login name must be put exact; it cannot be set as starting characters because it won't show any records. Other filtering fileds are the same.

Resellers calls

Special part of calls is availalble for resellers. It is possible to see calls made by every reseller on every level. Filtering by date is also available (as shown on Fig.4).

Fig. 4 Resellers calls

Failed calls

It is possible to filter failed calls by:

• Date and time - it is possible to see calls made only in given time. There are helper periods available as Today, Last week, or from which allows to define exact date interval.

• Called number - destination number dialed by a client.

• Caller ip - ip number from which call was received, starting characters can be used for filtering. • Caller id - caller id from which call was made, starting characters can be used for filtering. • IE Error -

• PDD - time of connecting to given number, the less time the better. • Route - destination used to terminate calls.

Working with filters, saving them, sorting columns, context menu is described in section 1.0 Common UI elements

Fig. 5 Failed calls with simple filter options

Clicking on every row of failed calls loads the form below the list. Values there are similar as in the list but for IE error and reason there are explanation of errors which can be useful for finding error on destination gateway.

In the form below additional fields are: • Client login -

• Client type - • Route type -

• IE Error description - • Release complete reason -

Fig. 6 Failed calls detailed form

Reports

This section is used to see reports for calls made. It is possible to group and filter depending on different criteria. For grouped record it can calculate:

• Sum - calculate revenue for clients.

• Profit - profit as difference between cost of termination and revenue paid by client or reseller. • Average

Fig. 7 Reports window with simple example.

Grouping allows to see sums for chosen client, period of time and other options. Below is a list of possible grouping:

• Clients type - when client type is choosen it will show record grouped by logins from the chosen type. Using such report can be helpful to see clients calling best. To see all clients informations specific client login cannot be chosen.

• Route - when only type is chosen the system will show how traffic is divided between different gateways.

• Period - hour, day, month grouping is allowed.

• Resellers of any level - when reseller of any level is chosen the system will show how traffic is divided for every one of them.

• Country, region - using this grouping we can see best countries and regions chosen by clients. Visualization of this report is available in pie chart.

• Prefix - in comparison to country or region we can group by specific prefix, for example the same region description can have many prefixes so this option will give us more detailed grouping. Defined criteria can be used as one or as many. Below please find list example reports:

Period:Monthly + Route:External gateways - it will show how in every month for chosen dates traffic was sent between destinations defined in Gateways.

Period:Daily + Group by:By country - it will show daily calling to different countries and regions. Period:Monthly + Group by:By country + Resellers:Res 1 - it will show monthly calling to different countries and regions for every reseller.

Choosing many groupings can result in high CPU usage and long operation. It is better to limit time for which such report is being generated and use grouping with caution.

Grouping records will be applied for records filtered. Available filters are: • date interval

• resellers level

• specific reseller of chosen level • client type

• specific client for chosen type • route type

• specific route for chosen type

For some reports the charts generation is available.

Grouping by country makes it possible to see as pie chart countries chosen by clients.

traffic is. Export

Every generated report can be exported to CSV file format. This format can be opened using Excel. Only visible fields will be exported to file.

Statistics

This section is using calls made and failed to calculate statistics. They are useful to check quality of gateways. Values available are:

• ASR

• Number of calls made, calls failed

• Average, total, shortest and median of duration • Best, worst, average, median PDD

Statistics are calculated depending on defined filters:

• *Date and time period * - except for days it is possible to define period of hours. • GW clients - it can be checked for this type of clients ( mostly used in wholesale ). • GK/Registrar clients

• Specific client - it can be chosen by a client from one of types defined above. • External gateway -

• External gatekeeper -

Payments

Section used to browse payments made by clients. Payments can be checked for filtered date, type of client, login and other criterias.

7.0 Settings

This page last changed on Feb 11, 2008 byrashid.

• Introduction • Types of settings