Cost / Revenue Statistics’ Advanced Report

Advanced report shows more cost / revenue report details. It allows the grouping of data by customer name and account billing mode or shows details for a specific customer site. It also shows additional customer information (e.g. tax code, contract number, etc.) and uses that to group data in the report.

List of input parameters

Name Mandatory Range of Values Description

Service

N

List of Services. All by default.

Shows the report for one or all services.

Customer

N

Customers. All by default.

Shows the report for one or all customers.

Customer Site

N

Sites for a selected customer.

Shows the report for all customer accounts or accounts of a specific customer site.

From

Y

Date.

Starting date of the period.

To

Y

Date.

Ending date of the period.

Vendor

N

Vendors. All by default.

Shows the report for one or all vendors.

Country

N

List of countries. All by default.

Shows the report for calls made to a specific country.

Destination Description

N

Categories of destinations of a specific country. All by default.

Shows the report for a category of destinations (e.g. mobile numbers, or numbers for some region.)

Account Billing Model

N

Types of accounts.

Shows the report for accounts of a specific billing model.

Output data tab

Column Description

Service

Type of service.

Customer Name

The name of the corresponding customer.

Customer Registration

The unique ID of the customer record used in the database.

Customer Site

The name of the corresponding customer site.

Billing Model

Account billing model.

Destination

Destinations dialed.

Country

The name of the corresponding country.

Destination Description

Description of destinations dialed.

Vendor Name

The name of the corresponding vendor.

All Transactions

The total number of session initiation attempts.

Successful transactions

The total number of successful sessions.

Used quantity

Total amount of traffic consumed.

Unit

Measurement unit of quantity used.

Cost

The cost amount.

Revenue

The revenue amount.

Gross Margin

The gross margin amount.

Currency

The currency value.

ASR

The value of ASR.

ALOC

The value of average call length.

Charged Amount

The amount of money charged.

Customer Currency

The currency in which the customer is charged.

Exchange Rate

The exchange rate between the customer and billing currencies.

Tax ID

The ID of the tax applied.